Hospital Management System

An ASP.NET and SQL Server system for running a hospital. It manages patient registration and records, doctors, wards, pharmacy stock and billing through one interface.

Users and the admin log in through ASP.NET pages with role-based access. Forms validate input on both the browser and the server. Records are stored in SQL Server tables designed in third normal form. Reports and search pages let the admin view, filter and export the data.

Web Forms uses server controls and view state with an event model. MVC separates Model, View and Controller, gives full control over HTML and is easier to test.

It follows a three-tier architecture: the browser shows the user interface, the server-side code handles logic and validation, and the MySQL database stores records. Requests travel over HTTP and responses are rendered as HTML or JSON.

All queries use prepared statements with bound parameters, so user input is never joined into the SQL text. Inputs are also validated on the server.

We followed an iterative (incremental) model: requirements and a basic design first, then modules built and tested one by one, with the guide's feedback after each review. It suits a project where requirements become clearer as we build.

Unit testing of each module, integration testing of the complete flow and system testing with real inputs. Test cases with expected and actual results are listed in the report, including invalid inputs.

The current version is tested on a limited dataset or number of users. Future work includes deploying on the cloud, adding more features or languages, improving accuracy with more data and building a mobile version.