- SalesWebMVC is a comprehensive sales management system designed to streamline sales operations. It facilitates the management of departments, sellers, and sales records with seamless relation between them. Built on ASP.NET Core MVC, the system offers a user-friendly interface for performing CRUD operations on departments and sellers. Additionally, it provides robust search functionality for both simple and grouped sales records. Leveraging Entity Framework with PostgreSQL, SalesWebMVC ensures efficient data handling and storage. The frontend is developed using Razor Pages with Bootstrap, offering a responsive and visually appealing user experience.
- CRUD Operations: Seamlessly manage departments and sellers with Create, Read, Update, and Delete (CRUD) operations.
- Simple Sales Record Search: Easily search through sales records based on various criteria, enabling quick access to specific data.
- Grouping Sales Record Search: Effortlessly group and filter sales records to analyze trends and patterns, providing valuable insights into sales performance and trends.
- Ensure you have PostgreSQL installed locally.
- Create a new database for the project.
- Navigate to the appsettings.json file in the project.
- Update the connection string under "ConnectionStrings" to point to your local PostgreSQL database.
- Open the solution in Visual Studio or your preferred code editor.
- Build the solution and resolve any dependencies.
- Run the application.
- The database will be created and seeded with initial data automatically.
OBS: Sellers have this CRUD screens as well.
Caption: Department Table Screen
Caption: Create Screen
Caption: Read Screen
Caption: Update Screen
Caption: Delete Screen
Caption: Simple and Grouping Search Screen
Caption: Simple Search Result Screen on Mobile Resolution
Caption: Groupin Search Result Screen on Mobile Resolution
