A robust and efficient Point-of-Sale (POS) desktop application built using C# Windows Forms. The app features a local database powered by MS SQL Server, with seamless database operations managed through LINQ.
- ๐พ Local Database: Ensures secure and fast access to data with MS SQL Server.
- โจ MAterialSkin.2: Better UI
- ๐ Inventory Management: Simplified tracking of products and stock levels.
- ๐ธ Transaction Processing: Smooth handling of sales transactions.
- ๐ Search & Filter: Quickly find products or view categories.
- ๐ฅ๏ธ Intuitive Interface: User-friendly Windows Forms design for easy navigation.
- C# Windows Forms: For building the desktop application.
- MS SQL Server: Backend database for storing and managing data.
- LINQ: For efficient and readable database queries.
To install and run the application:
-
Clone the repository:
git clone https://github.com/YourUsername/PointOfSaleApp cd PointOfSaleApp -
Setup the database:
- Open SQL Server Management Studio (SSMS).
- Restore the provided database backup file (
pos_database.bak). - Update the connection string in
App.configto match your SQL Server instance.
Example connection string:
<connectionStrings> <add name="POSConnection" connectionString="Server=YourServerName;Database=POSDatabase;Trusted_Connection=True;" providerName="System.Data.SqlClient" /> </connectionStrings>
-
Build and Run the Application:
- Open the project in Visual Studio.
- Restore NuGet packages.
- Build the solution and run the application.
- Login: Enter your credentials to access the application.
- Manage Inventory: Add, update, or delete products.
- Process Sales: Scan barcodes or manually select items to complete transactions.
- View Reports: Generate and view sales and inventory reports.