Design and Implementation of a Computerized Drug Inventory Management Information System Using ASP.NET MVC

Abstract

Automation in the drug inventory distribution process is helpful to pharmacist. Pharmacy management has kept paper record in filing cabinets. Managing a very large pharmacy with records on papers will be tedious and difficult to keep track of inventories with regards to the drugs in the store, expiry date, quantity of drugs available based on the categories and their functions. A Drug Inventory Management Information System(DIMIS) is basically a computer system that can manage all the information to allow pharmacists to do their jobs faster and more effective in real time. These jobs include: dispensing of drugs, drug regulation, and the sale of these drugs. The developed methodology adopted in the implementation of the software is iterative model of system development life cycle. This method produces an early stage of model. The development of the system is based on using new technologies like AJAX, ASP.NET MVC 5, Bootstrap, HTML and CSS which make the user interface more interactive. C#.NET language was used as server language whereas as a database server Microsoft SQL server 2012 was utilized. DIMIS is able to search and check a huge number and expiration date of drug in the purchase as well as delivery records. These attributes and functions are powerful, efficient and subsequently useful in patient's safety and cost containment