Point of Sale System for Pharmacy in C# and SQL Server
The move from manual process to automated, it means that there is a greater chance that information will be readily available when important decisions must be made about improving organization services. The point of sale system for pharmacy is a database oriented project that ensures the efficiency and accuracy of transactions between the management and the customers.
Features and Screenshots of the Point of Sale System for Pharmacy
Product Module
This is the module where the lists of products are managed (encoded and updated).
Sales Module
Sales Module which consist and capable for product inquiry, adding discount, viewing daily sales and settle payment.
Settle Payment Module
Settle Payment Form capable for printing receipts. It has validation for short transactions and errors.
Print Receipt
The system is capable of printing the receipt using the receipt printer.
Product Inquiry Module
Product Inquiry is capable of searching classifications, brand, generic, and formulation. You can monitor the stocks available in this module.
Stock-in and Stock History Module
- Stock In and Stock History Module
- Receiving of Stocks with reference number with the receiver.
- Track the received total stocks
- Print the Stock In History
Maintenance Module
- Insert, Update, Retrieve and Delete of Brand, Generic, Classification, Formulation and Type.
- Adding Discount and VAT.
- Update System Name
- Update Company/Business Information for receipt header
- Update Thermal Printer Name
Change Password Form
Change Password with validation if new and confirm password didn’t match, cannot change other user, exclusive for whose credentials currently signed.
Management User Account
- Adding user or cashier
- Can change status (Active and Inactive)
Sales Report Module
- Track sales record done by a cashier
- Print Sales Record
Record List Module
- Can monitor and view the stock inventory
- Monitor the Quantity of stocks sold out
- Monitor the under and out of stocks
- Monitor and rank the fast moving stocks
System Lock
The system lock is a security features that requires a password to reopen the system.
Development Tools
C#.Net
C# is an elegant and type-safe object-oriented language that enables developers to build a variety of secure and robust applications that run in the .NET ecosystem. You can use C# to create Windows client applications, XML Web services, distributed components, client-server applications, database applications, and much, much more.
Source: https://docs.microsoft.com/en-us/dotnet/csharp/getting-started/introduction-to-the-csharp-language-and-the-net-framework
SQL Server
According to this website (www.databasejournal.com) SQL Server is a Microsoft product used to manage and store information. Technically, SQL Server is a “relational database management system” (RDMS). Broken apart, this term means two things. First, that data stored inside SQL Server will be housed in a “relational database”, and second, that SQL Server is an entire “management system”, not just a database. SQL itself stands for Structured Query Language. This is the language used to manage and administer the database server.
Phases of the Software Development Life Cycle
The team used the Rapid Application Development model in the development of the project and the following are the phases of the said model.
Analysis and Quick Design
Before to start of Analysis and Quick Design phase, the researchers did an interview with the chosen company where the study conducted. The company head were given privilege to suggest, comment and request on how the system will be designed and developed. After the conducted data gathering, the researchers made a primary design for proposed system.
Data Analysis
During this phase, the researcher analyzed the data that was obtained from the initial data gathering. The analyzed data will be used towards the design and development of the system, thus making sure that all recommendations of the end-user were meet.
System Design
The researchers start to develop the proposed system. It includes the design layout of how the system would look like based on the user requirements, and researchers/programmer would also add personal designs to make the system more interactive.
Prototype Cycle
This phase of rapid application development involves three activities namely Demonstrate, Refine and Develop. After the analysis of the gathered data, the researcher had started the system development which was based on the recommendations form the end-users. After the prototype has been developed, demonstration of the system was done to the end-users. If there are some recommendations after the demonstration, the system will be refined based on the results from the demonstration.
Testing
At this point, the whole design and its construction are put under a test to check its functionality. If there are any errors then they will surface at this point of the process.
Deployment/Implementation
In this phase of integration, the company puts it in use after the system has been successfully tested. This phase also discussed if the recommended functions and suggestions of the respondents and users are met.
Developer of the Project
Stephen Yecyec
09090695219
stephenyecyec@gmail.com
Youtube Channel: Programming Hub Ph
You may visit our facebook page for more information, inquiries and comments.
Hire our team to do the project.
