Pharmacy Sales Management System / POS System (VB.Net & MySQL)

Overview: This Pharmacy Sales Management System (also known as POS - Point of Sale) was developed using VB.NET and a MySQL database. The system aims to simplify pharmacy sales transactions and inventory management, offering a user-friendly interface with intuitive features. It is a perfect project for IT students or self-learners looking to explore VB.Net programming, database integration, and system development.

Key Features:

• User Login System:
  • Admin Login
  • Cashier Login
• Product Management:
  • Medicine/Product List Management
  • Add, Update, and Track Stock
• Sales Management:
  • Cash Registry Form for Recording Sales Transactions
  • Generate Printable Receipts
• Reporting:
  • Sales Report Generation
• User Management:
  • Admin privileges for managing system data
  • Cashier privileges limited to sales and transactions

System Requirements: To run this Pharmacy Sales Management System, you need the following software:

1. Microsoft Visual Studio
2. XAMPP (for MySQL and Apache server)
3. MySQL Database (for backend data management)

How to Run the System:

1. Download & Install:

   • Download and extract the source code ZIP file.
   • Install Microsoft Visual Studio and XAMPP (if not already installed).

2. Set Up Database:

   • Open XAMPP Control Panel, then start Apache and MySQL.
   • Open a web browser and go to localhost/phpmyadmin.
   • Create a new database named "pmisdb".
   • Import the "pmisdb.sql" file located in the source code folder into the "pmisdb" database.

3. Run the Application:

   • Locate and open the "WindowsApplication1.sln" file in Visual Studio.
   • Press F5 to run the system.

Sample User Credentials:

• Admin User:
  • Username: admin
  • Password: admin
• Cashier User:
  • Username: testrun
  • Password: 12345

Important Notes:

• Virus Safety: Ensure to scan all downloaded files with your personal antivirus before using them.
• Only run the source code (avoid running compiled executable files for security reasons).

Enjoy Learning and Coding! Feel free to modify the source code to meet your learning or development goals. This project serves as an excellent example for anyone interested in VB.Net and MySQL development.

Disclaimer: While the files are scanned daily for viruses, no antivirus can catch 100% of all new threats. Always perform your own virus checks before using any downloaded files.