LIFEWebSite Solution

A comprehensive healthcare administration and patient care platform built with ASP.NET MVC and SQL Server. This platform enables patients to book appointments, manage accounts, and interface with doctors, while providing administrators with tools to oversee hospital resources, rooms, medicines, and orders.

Project Architecture

The solution is divided into two primary projects:

1. LIFEWebSite (ASP.NET MVC Web Application):

   • Built on the MVC pattern with Entity Framework (EDMX) Database-First approach.
   • Includes user authentication (Patients, Doctors, and Administrators).
   • Features dynamic appointment booking, patient history tracking, feedback forms, and an ordering system.
   • Uses modern libraries like EntityFramework, OWIN, and PagedList for high-performance data querying and pagination.

2. LIFEDB (SQL Server Database Project):

   • Standardized SQL Database project defining the application's relational schema.
   • Manages relational tables, foreign key constraints, default constraints, and identity columns.
   • Provides DDL scripts for immediate local deployment and publishing.

---

Database Schema Design

The LIFEDB database represents a robust relational model with the following tables:

• Users: The foundation for authentication, managing user details, passwords (hashed), and account roles (Patient, Doctor, Admin).
• Patients: Patient-specific records containing demographic information, contact details, and blood groups.
• Doctors: Doctor-specific records specifying professional credentials, experience, specialization, and ratings.
• Appointments: Manages the link between Patients and Doctors, recording booking dates, symptoms, status updates (Scheduled, Completed, Cancelled), and reasons.
• Hospitals: Stores metadata about affiliate healthcare centers and clinics.
• HospitalRooms: Tracks rooms, room types, and room occupancy status within hospitals.
• Medicines: An inventory of available medications, unit prices, and stock quantities.
• Orders & OrderDetails: Tracks medicine orders placed by patients, order status, totals, and transaction items.
• Alerts: Generates notifications or reminders for patients and doctors.
• Feedbacks: Stores reviews, comments, and satisfaction ratings submitted by users.

---

Technical Stack & Dependencies

• Backend Logic: C# .NET Framework 4.5.2+
• Web Framework: ASP.NET MVC 5
• ORM & Data Access: Entity Framework 6 (EDMX Database First)
• Database Engine: Microsoft SQL Server
• UI Components: Bootstrap, jQuery, Modernizr
• Git Compatibility: Fully configured with a tailored .gitignore to exclude Visual Studio temporary files, user preferences, local database caches, and NuGet package binaries.

---

How to Set Up and Run Locally

Prerequisites

• Visual Studio 2015 / 2017 / 2019 / 2022 (with ASP.NET and web development and Data storage and processing workloads installed)
• LocalDB or Microsoft SQL Server

Step-by-Step Setup

1. Clone the Repository:

   git clone https://github.com/Paras2611/LifeWebApp.git
   cd LifeWebApp

2. Restore NuGet Packages:

   • Open LIFEWebSiteSln.sln in Visual Studio.
   • Right-click the solution in Solution Explorer and select Restore NuGet Packages (or run dotnet restore / nuget restore from the command line).

3. Deploy the Database:

   • Open SQL Server Object Explorer in Visual Studio.
   • Right-click the LIFEDB project and select Publish.
   • Target your local SQL Server instance (e.g. (localdb)\MSSQLLocalDB), specify LIFEDB as the database name, and click Publish.
   • Alternatively, execute the .sql scripts inside the LIFEDB directory on your database server to create the schema.

4. Update Connection Strings:

   • In LIFEWebSite, open Web.config and check the LIFEDBEntities connection string under <connectionStrings> to ensure it points to your local SQL Server instance.

5. Run the Web Project:

   • Set LIFEWebSite as the Startup Project.
   • Press F5 or click Start in Visual Studio to compile and launch the application in IIS Express.