SalesWebMVC

• 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.

Features

• 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.

How to Run

1. Clone the Repository.

2. Setup Local Database:

• 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.

3. Run the Application:

• 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.

Images:

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