Home C#.net Pharmacy Inventory Management System (Point of Sales system)

Pharmacy Inventory Management System (Point of Sales system)

9 min read
0
1
2,006

The Pharmacy Inventory Management System is developed using C#.net and microsoft sql server. The project is built to manage pharmacy items and transactions. To make a new transaction, fields such as: drag name, qty and payment needs to be selected. If you like to learn point of sales systems step by step, this is the right place to learn from the beginning. In this tutorial, we will learn crystal reports step by step and design and print receipts for the payments.

Search Record

The systm shall be able search the drag name, price by the relevant “Drug Code”.

Paste this Code inside the keypress Event of the textbox. we created the textbox name txtdcode of this project.

Add the Product details into the dataGridView

After receiving the drag name and price where the user has the option to add the qty by clicking the add button to see all Products details which will be shown in the below table.

Calculating the Total and balance

Remove items

if you want remove items from the datagridview. select the row of table which item wants to. then click delete button in the datagridview.

After that  create the method Salessave().we have to create two different tables to store data into the database. we also have to create the following tables from database.
sales tables consist of following colums – id,subtotal,pay,balance.
sales_products tables consist of following colums –id,sales_id,drugname,price,qty,total

Call the Salessave() method inside the Print Invoice button. after calculating the total Print receipt will be released. This print receipt is design by Jsper Reporting.

Paste this code inside the Print Invoice button

Print Receipt

i have attached the video link below. which will do this tutorials step by step.

 

 

 

 

 

Load More Related Articles
Load More By admin
Load More In C#.net

Leave a Reply

Your email address will not be published. Required fields are marked *

Check Also

Sales Transaction Management in Java Mysql

The set of one or more sql statements that are executed as a single unit called as transac…