Project Introduction
The Hospital Management System is designed to streamline the operations of healthcare facilities by providing a comprehensive platform for managing patient information, appointments, billing, and inventory. Built using ASP.NET and SQL Server, this application aims to enhance the efficiency of hospital administration and improve patient care. The system will facilitate the management of various aspects of hospital operations, including user roles, patient records, doctor schedules, lab tests, and financial transactions, ensuring a seamless experience for both healthcare providers and patients.
Project Objectives
- To create a secure user authentication system for managing user accounts and roles within the hospital.
- To enable efficient management of patient records, including personal information and medical history.
- To facilitate appointment scheduling between patients and doctors.
- To manage billing and invoicing for medical services rendered to patients.
- To track payments and maintain financial records for the hospital.
- To manage inventory items, including medical supplies and equipment.
- To provide a platform for lab tests and prescriptions management.
- To generate reports on patient visits, lab tests, and financial performance.
- To enable secure messaging between users for effective communication.
- To collect feedback from users to improve the quality of services provided.
Project Modules
- User Management Module: Handles user registration, login, and role management.
- Patient Management Module: Manages patient records, including personal and medical information.
- Appointment Management Module: Facilitates scheduling and management of patient appointments with doctors.
- Billing and Invoicing Module: Manages invoices and payment processing for medical services.
- Inventory Management Module: Tracks inventory items, including medical supplies and equipment.
- Lab Test Management Module: Manages lab tests, including scheduling and results tracking.
- Prescription Management Module: Facilitates the creation and management of patient prescriptions.
- Reporting Module: Generates reports on patient visits, lab tests, and financial performance.
- Messaging Module: Enables secure messaging between users for effective communication.
- Emergency Contact Management Module: Manages emergency contacts for patients.
- Feedback Module: Collects user feedback and ratings to improve hospital services.
SQL Server Database Tables
-- Users Table
CREATE TABLE Users (
UserId INT PRIMARY KEY IDENTITY(1,1),
Username NVARCHAR(50) NOT NULL UNIQUE,
PasswordHash NVARCHAR(255) NOT NULL,
Email NVARCHAR(100) NOT NULL UNIQUE,
Phone NVARCHAR(15),
RoleId INT,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (RoleId) REFERENCES Roles(RoleId)
);
-- Roles Table
CREATE TABLE Roles (
RoleId INT PRIMARY KEY IDENTITY(1,1),
RoleName NVARCHAR(50) NOT NULL UNIQUE
);
-- Patients Table
CREATE TABLE Patients (
PatientId INT PRIMARY KEY IDENTITY(1,1),
FirstName NVARCHAR(50) NOT NULL,
LastName NVARCHAR(50) NOT NULL,
DateOfBirth DATE NOT NULL,
Gender NVARCHAR(10),
Phone NVARCHAR(15),
Email NVARCHAR(100) UNIQUE,
Address NVARCHAR(255),
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE()
);
-- Doctors Table
CREATE TABLE Doctors (
DoctorId INT PRIMARY KEY IDENTITY(1,1),
FirstName NVARCHAR(50) NOT NULL,
LastName NVARCHAR(50) NOT NULL,
Specialty NVARCHAR(100),
Phone NVARCHAR(15),
Email NVARCHAR(100) UNIQUE,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE()
);
-- Appointments Table
CREATE TABLE Appointments (
AppointmentId INT PRIMARY KEY IDENTITY(1,1),
PatientId INT,
DoctorId INT,
AppointmentDate DATETIME NOT NULL,
Status NVARCHAR(20) DEFAULT 'Scheduled',
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (PatientId) REFERENCES Patients(PatientId),
FOREIGN KEY (DoctorId) REFERENCES Doctors(DoctorId)
);
-- Invoices Table
CREATE TABLE Invoices (
InvoiceId INT PRIMARY KEY IDENTITY(1,1),
PatientId INT,
TotalAmount DECIMAL(10, 2) NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (PatientId) REFERENCES Patients(PatientId)
);
-- Payments Table
CREATE TABLE Payments (
PaymentId INT PRIMARY KEY IDENTITY(1,1),
InvoiceId INT,
PaymentDate DATETIME DEFAULT GETDATE(),
Amount DECIMAL(10, 2) NOT NULL,
PaymentMethod NVARCHAR(50),
Status NVARCHAR(20) DEFAULT 'Pending',
FOREIGN KEY (InvoiceId) REFERENCES Invoices(InvoiceId)
);
-- InventoryItems Table
CREATE TABLE InventoryItems (
ItemId INT PRIMARY KEY IDENTITY(1,1),
ItemName NVARCHAR(100) NOT NULL,
Quantity INT NOT NULL,
UnitPrice DECIMAL(10, 2) NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE()
);
-- LabTests Table
CREATE TABLE LabTests (
LabTestId INT PRIMARY KEY IDENTITY(1,1),
TestName NVARCHAR(100) NOT NULL,
Description NVARCHAR(MAX),
Price DECIMAL(10, 2) NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE()
);
-- Prescriptions Table
CREATE TABLE Prescriptions (
PrescriptionId INT PRIMARY KEY IDENTITY(1,1),
PatientId INT,
DoctorId INT,
PrescriptionDate DATETIME DEFAULT GETDATE(),
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (PatientId) REFERENCES Patients(PatientId),
FOREIGN KEY (DoctorId) REFERENCES Doctors(DoctorId)
);
-- Reports Table
CREATE TABLE Reports (
ReportId INT PRIMARY KEY IDENTITY(1,1),
PatientId INT,
ReportDate DATETIME DEFAULT GETDATE(),
Description NVARCHAR(MAX),
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (PatientId) REFERENCES Patients(PatientId)
);
-- Messages Table
CREATE TABLE Messages (
MessageId INT PRIMARY KEY IDENTITY(1,1),
SenderId INT,
ReceiverId INT,
MessageText NVARCHAR(MAX),
SentAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (SenderId) REFERENCES Users(UserId),
FOREIGN KEY (ReceiverId) REFERENCES Users(UserId)
);
-- EmergencyContacts Table
CREATE TABLE EmergencyContacts (
EmergencyContactId INT PRIMARY KEY IDENTITY(1, 1),
PatientId INT,
ContactName NVARCHAR(100) NOT NULL,
Relationship NVARCHAR(50),
Phone NVARCHAR(15),
FOREIGN KEY (PatientId) REFERENCES Patients(PatientId)
);
-- Feedback Table
CREATE TABLE Feedbacks (
FeedbackId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
Comments NVARCHAR(MAX),
Rating INT CHECK (Rating >= 1 AND Rating <= 5),
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
Explanation of Tables
Users: Stores user information, including their credentials and roles.
Roles: Defines different roles within the system (e.g., admin, doctor, nurse).
Patients: Contains patient details, including personal information and contact details.
Doctors: Stores information about doctors, including their specialties and contact information.
Appointments: Tracks appointments between patients and doctors, including status.
Invoices: Manages billing information for patients.
Payments: Records payment transactions related to invoices.
InventoryItems: Manages hospital inventory, including items and their quantities.
LabTests: Contains information about lab tests available in the hospital.
Prescriptions: Stores prescriptions issued by doctors to patients.
Reports: Manages medical reports associated with patients.
Messages: Facilitates communication between users within the system.
EmergencyContacts: Stores emergency contact information for patients.
Feedback: Collects feedback from users regarding their experiences.
Creating a Model and Repository Pattern
To create a model and repository pattern using ADO.NET for the provided SQL Server tables in an ASP.NET application, we will follow these steps:
Step 1: Create Model Classes
Define C# classes that represent each table.
Here are the model classes for the tables defined in your SQL schema:
public class User
{
public int UserId { get; set; }
public string Username { get; set; }
public string PasswordHash { get; set; }
public string Email { get; set; }
public string Phone { get; set; }
public int? RoleId { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Role
{
public int RoleId { get; set; }
public string RoleName { get; set; }
}
public class Patient
{
public int PatientId { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
public DateTime DateOfBirth { get; set; }
public string Gender { get; set; }
public string Phone { get; set; }
public string Email { get; set; }
public string Address { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Doctor
{
public int DoctorId { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
public string Specialty { get; set; }
public string Phone { get; set; }
public string Email { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Appointment
{
public int AppointmentId { get; set; }
public int PatientId { get; set; }
public int DoctorId { get; set; }
public DateTime AppointmentDate { get; set; }
public string Status { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Invoice
{
public int InvoiceId { get; set; }
public int PatientId { get; set; }
public decimal TotalAmount { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Payment
{
public int PaymentId { get; set; }
public int InvoiceId { get; set; }
public DateTime PaymentDate { get; set; }
public decimal Amount { get; set; }
public string PaymentMethod { get; set; }
public string Status { get; set; }
}
public class InventoryItem
{
public int ItemId { get; set; }
public string ItemName { get; set; }
public int Quantity { get; set; }
public decimal UnitPrice { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class LabTest
{
public int LabTestId { get; set; }
public string TestName { get; set; }
public string Description { get; set; }
public decimal Price { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Prescription
{
public int PrescriptionId { get; set; }
public int PatientId { get; set; }
public int DoctorId { get; set; }
public DateTime PrescriptionDate { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Report
{
public int ReportId { get; set; }
public int PatientId { get; set; }
public DateTime ReportDate { get; set; }
public string Description { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Message
{
public int MessageId { get; set; }
public int SenderId { get; set; }
public int ReceiverId { get; set; }
public string MessageText { get; set; }
public DateTime SentAt { get; set; }
}
public class EmergencyContact
{
public int EmergencyContactId { get; set; }
public int PatientId { get; set; }
public string ContactName { get; set; }
public string Relationship { get; set; }
public string Phone { get; set; }
}
public class Feedback
{
public int FeedbackId { get; set; }
public int UserId { get; set; }
public string Comments { get; set; }
public int Rating { get; set; }
public DateTime CreatedAt { get; set; }
}
Step 2: Create Repository Interfaces
Define interfaces for each repository:
public interface IUserRepository
{
User GetUser ById(int userId);
IEnumerable<User> GetAllUsers();
void AddUser (User user);
void UpdateUser (User user);
void DeleteUser (int userId);
}
public interface IRoleRepository
{
Role GetRoleById(int roleId);
IEnumerable<Role> GetAllRoles();
void AddRole(Role role);
void UpdateRole(Role role);
void DeleteRole(int roleId);
}
// Repeat for other entities (Patient, Doctor, Appointment, etc.)
Step 3: Implement Repository Classes
Here is an example implementation of the User Repository using ADO.NET:
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
public class UserRepository : IUserRepository
{
private readonly string _connectionString;
public UserRepository(string connectionString)
{
_connectionString = connectionString;
}
public User GetUser ById(int userId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Users WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", userId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new User
{
UserId = (int)reader["User Id"],
Username = reader["Username"].ToString(),
PasswordHash = reader["PasswordHash"].ToString(),
Email = reader["Email"].ToString(),
Phone = reader[" Phone"].ToString(),
RoleId = reader["RoleId"] as int?,
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<User> GetAllUsers()
{
var users = new List<User>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Users", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
users.Add(new User
{
UserId = (int)reader["User Id"],
Username = reader["Username"].ToString(),
PasswordHash = reader["PasswordHash"].ToString(),
Email = reader["Email"].ToString(),
Phone = reader["Phone"].ToString(),
RoleId = reader["RoleId"] as int?,
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return users;
}
public void AddUser (User user)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Users (Username, PasswordHash, Email, Phone, RoleId) VALUES (@Username, @PasswordHash, @Email, @Phone, @RoleId)", connection);
command.Parameters.AddWithValue("@Username", user.Username);
command.Parameters.AddWithValue("@PasswordHash", user.PasswordHash);
command.Parameters.AddWithValue("@Email", user.Email);
command.Parameters.AddWithValue("@Phone", user.Phone);
command.Parameters.AddWithValue("@RoleId", user.RoleId.HasValue ? (object)user.RoleId.Value : DBNull.Value);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateUser (User user)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Users SET Username = @Username, PasswordHash = @PasswordHash, Email = @Email, Phone = @Phone, RoleId = @RoleId, UpdatedAt = GETDATE() WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", user.UserId);
command.Parameters.AddWithValue("@Username", user.Username);
command.Parameters.AddWithValue("@PasswordHash", user.PasswordHash);
command.Parameters.AddWithValue("@Email", user.Email);
command.Parameters.AddWithValue("@Phone", user.Phone);
command.Parameters.AddWithValue("@RoleId", user.RoleId.HasValue ? (object)user.RoleId.Value : DBNull.Value);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteUser (int userId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Users WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", userId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
This pattern can be replicated for other entities such as Role, Patient, Doctor, etc., by creating corresponding repository classes and implementing the methods defined in their respective interfaces. Each repository will handle the CRUD operations for its associated model, ensuring a clean separation of concerns and maintainability in the application.
Repository Implementations
Below are the repository implementations for the remaining models based on the SQL schema you provided. Each repository will implement the corresponding interface for CRUD operations.
Role Repository
public class RoleRepository : IRoleRepository
{
private readonly string _connectionString;
public RoleRepository(string connectionString)
{
_connectionString = connectionString;
}
public Role GetRoleById(int roleId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Roles WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", roleId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Role
{
RoleId = (int)reader["RoleId"],
RoleName = reader["RoleName"].ToString()
};
}
}
}
return null;
}
public IEnumerable<Role> GetAllRoles()
{
var roles = new List<Role>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Roles", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
roles.Add(new Role
{
RoleId = (int)reader["RoleId"],
RoleName = reader["RoleName"].ToString()
});
}
}
}
return roles;
}
public void AddRole(Role role)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Roles (RoleName) VALUES (@RoleName)", connection);
command.Parameters.AddWithValue("@RoleName", role.RoleName);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateRole(Role role)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Roles SET RoleName = @RoleName WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", role.RoleId);
command.Parameters.AddWithValue("@RoleName", role.RoleName);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteRole(int roleId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Roles WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", roleId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Patient Repository
public class PatientRepository : IPatientRepository
{
private readonly string _connectionString;
public PatientRepository(string connectionString)
{
_connectionString = connectionString;
}
public Patient GetPatientById(int patientId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Patients WHERE PatientId = @PatientId", connection);
command.Parameters.AddWithValue("@PatientId", patientId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Patient
{
PatientId = (int)reader["PatientId"],
FirstName = reader["FirstName"].ToString(),
LastName = reader["LastName"].ToString(),
DateOfBirth = (DateTime)reader["DateOfBirth"],
Gender = reader["Gender"].ToString(),
Phone = reader["Phone"].ToString(),
Email = reader["Email"].ToString(),
Address = reader["Address"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Patient> GetAllPatients()
{
var patients = new List<Patient>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Patients", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
patients.Add(new Patient
{
PatientId = (int)reader["PatientId"],
FirstName = reader["FirstName"].ToString(),
LastName = reader["LastName"].ToString(),
DateOfBirth = (DateTime)reader["DateOfBirth"],
Gender = reader["Gender"].ToString(),
Phone = reader["Phone"].ToString(),
Email = reader["Email"].ToString(),
Address = reader["Address"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return patients;
}
public void AddPatient(Patient patient)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Patients (FirstName, LastName, DateOfBirth, Gender, Phone, Email, Address) VALUES (@FirstName, @LastName, @DateOfBirth, @Gender, @Phone, @Email, @Address)", connection);
command.Parameters.AddWithValue("@FirstName", patient.FirstName);
command.Parameters.AddWithValue("@LastName", patient.LastName);
command.Parameters.AddWithValue("@DateOfBirth", patient.DateOfBirth);
command.Parameters.AddWithValue("@Gender", patient.Gender);
command.Parameters.AddWithValue("@Phone", patient.Phone);
command.Parameters.AddWithValue("@Email", patient.Email);
command.Parameters.AddWithValue("@Address", patient.Address);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdatePatient(Patient patient)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Patients SET FirstName = @FirstName, LastName = @LastName, DateOfBirth = @DateOfBirth, Gender = @Gender, Phone = @Phone, Email = @Email, Address = @Address, UpdatedAt = GETDATE() WHERE PatientId = @PatientId", connection);
command.Parameters.AddWithValue("@PatientId", patient.PatientId);
command.Parameters.AddWithValue("@FirstName", patient.FirstName);
command.Parameters.AddWithValue("@LastName", patient.LastName);
command.Parameters.AddWithValue("@DateOfBirth", patient.DateOfBirth);
command.Parameters.AddWithValue("@Gender", patient.Gender);
command.Parameters.AddWithValue("@Phone", patient.Phone);
command.Parameters.AddWithValue("@Email", patient.Email);
command.Parameters.AddWithValue("@Address", patient.Address);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeletePatient(int patientId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Patients WHERE PatientId = @PatientId", connection);
command.Parameters.AddWithValue("@PatientId", patientId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Doctor Repository
public class DoctorRepository : IDoctorRepository
{
private readonly string _connectionString;
public DoctorRepository(string connectionString)
{
_connectionString = connectionString;
}
public Doctor GetDoctorById(int doctorId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Doctors WHERE DoctorId = @DoctorId", connection);
command.Parameters.AddWithValue("@DoctorId", doctorId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Doctor
{
DoctorId = (int)reader["DoctorId"],
FirstName = reader["FirstName"].ToString(),
LastName = reader["LastName"].ToString(),
Specialty = reader["Specialty"].ToString(),
Phone = reader["Phone"].ToString(),
Email = reader["Email"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Doctor> GetAllDoctors()
{
var doctors = new List<Doctor>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Doctors", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
doctors.Add(new Doctor
{
DoctorId = (int)reader["DoctorId"],
FirstName = reader["FirstName"].ToString(),
LastName = reader["LastName"].ToString(),
Specialty = reader["Specialty"].ToString(),
Phone = reader["Phone"].ToString(),
Email = reader["Email"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return doctors;
}
public void AddDoctor(Doctor doctor)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Doctors (FirstName, LastName, Specialty, Phone, Email) VALUES (@FirstName, @LastName, @Specialty, @Phone, @Email)", connection);
command.Parameters.AddWithValue("@FirstName", doctor.FirstName);
command.Parameters.AddWithValue("@LastName", doctor.LastName);
command.Parameters.AddWithValue("@Specialty", doctor.Specialty);
command.Parameters.AddWithValue("@Phone", doctor.Phone);
command.Parameters.AddWithValue("@Email", doctor.Email);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateDoctor(Doctor doctor)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Doctors SET FirstName = @FirstName, LastName = @LastName, Specialty = @Specialty, Phone = @Phone, Email = @Email, UpdatedAt = GETDATE() WHERE DoctorId = @DoctorId", connection);
command.Parameters.AddWithValue("@DoctorId", doctor.DoctorId);
command.Parameters.AddWithValue("@FirstName", doctor.FirstName);
command.Parameters.AddWithValue("@LastName", doctor.LastName);
command.Parameters.AddWithValue("@Specialty", doctor.Specialty);
command.Parameters.AddWithValue("@Phone", doctor.Phone);
command.Parameters.AddWithValue("@Email", doctor.Email);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteDoctor(int doctorId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Doctors WHERE DoctorId = @DoctorId", connection);
command.Parameters.AddWithValue("@DoctorId", doctorId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Appointment Repository
public class AppointmentRepository : IAppointmentRepository
{
private readonly string _connectionString;
public AppointmentRepository(string connectionString)
{
_connectionString = connectionString;
}
public Appointment GetAppointmentById(int appointmentId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Appointments WHERE AppointmentId = @AppointmentId", connection);
command.Parameters.AddWithValue("@AppointmentId", appointmentId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Appointment
{
AppointmentId = (int)reader["AppointmentId"],
PatientId = (int)reader["PatientId"],
DoctorId = (int)reader["DoctorId"],
AppointmentDate = (DateTime)reader["AppointmentDate"],
Status = reader["Status"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Appointment> GetAllAppointments()
{
var appointments = new List<Appointment>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Appointments", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
appointments.Add(new Appointment
{
AppointmentId = (int)reader["AppointmentId"],
PatientId = (int)reader["PatientId"],
DoctorId = (int)reader["DoctorId"],
AppointmentDate = (DateTime)reader["AppointmentDate"],
Status = reader["Status"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return appointments;
}
public void AddAppointment(Appointment appointment)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Appointments (PatientId, DoctorId, AppointmentDate, Status) VALUES (@PatientId, @DoctorId, @AppointmentDate, @Status)", connection);
command.Parameters.AddWithValue("@PatientId", appointment.PatientId);
command.Parameters.AddWithValue("@DoctorId", appointment.DoctorId);
command.Parameters.AddWithValue("@AppointmentDate", appointment.AppointmentDate);
command.Parameters.AddWithValue("@Status", appointment.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateAppointment(Appointment appointment)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Appointments SET PatientId = @PatientId, DoctorId = @DoctorId, AppointmentDate = @AppointmentDate, Status = @Status, UpdatedAt = GETDATE() WHERE AppointmentId = @AppointmentId", connection);
command.Parameters.AddWithValue("@AppointmentId", appointment.AppointmentId);
command.Parameters.AddWithValue("@PatientId", appointment.PatientId);
command.Parameters.AddWithValue("@DoctorId", appointment.DoctorId);
command.Parameters.AddWithValue("@AppointmentDate", appointment.AppointmentDate);
command.Parameters.AddWithValue("@Status", appointment.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteAppointment(int appointmentId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Appointments WHERE AppointmentId = @AppointmentId", connection);
command.Parameters.AddWithValue("@AppointmentId", appointmentId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Invoice Repository
public class InvoiceRepository : IInvoiceRepository
{
private readonly string _connectionString;
public InvoiceRepository(string connectionString)
{
_connectionString = connectionString;
}
public Invoice GetInvoiceById(int invoiceId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Invoices WHERE InvoiceId = @InvoiceId", connection);
command.Parameters.AddWithValue("@InvoiceId", invoiceId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Invoice
{
InvoiceId = (int)reader["InvoiceId"],
PatientId = (int)reader["PatientId"],
TotalAmount = (decimal)reader["TotalAmount"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Invoice> GetAllInvoices()
{
var invoices = new List<Invoice>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Invoices", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
invoices.Add(new Invoice
{
InvoiceId = (int)reader["InvoiceId"],
PatientId = (int)reader["PatientId"],
TotalAmount = (decimal)reader["TotalAmount"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = ( DateTime)reader["UpdatedAt"]
});
}
}
}
return invoices;
}
public void AddInvoice(Invoice invoice)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Invoices (PatientId, TotalAmount) VALUES (@PatientId, @TotalAmount)", connection);
command.Parameters.AddWithValue("@PatientId", invoice.PatientId);
command.Parameters.AddWithValue("@TotalAmount", invoice.TotalAmount);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateInvoice(Invoice invoice)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Invoices SET PatientId = @PatientId, TotalAmount = @TotalAmount, UpdatedAt = GETDATE() WHERE InvoiceId = @InvoiceId", connection);
command.Parameters.AddWithValue("@InvoiceId", invoice.InvoiceId);
command.Parameters.AddWithValue("@PatientId", invoice.PatientId);
command.Parameters.AddWithValue("@TotalAmount", invoice.TotalAmount);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteInvoice(int invoiceId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Invoices WHERE InvoiceId = @InvoiceId", connection);
command.Parameters.AddWithValue("@InvoiceId", invoiceId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Payment Repository
public class PaymentRepository : IPaymentRepository
{
private readonly string _connectionString;
public PaymentRepository(string connectionString)
{
_connectionString = connectionString;
}
public Payment GetPaymentById(int paymentId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Payments WHERE PaymentId = @PaymentId", connection);
command.Parameters.AddWithValue("@PaymentId", paymentId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Payment
{
PaymentId = (int)reader["PaymentId"],
InvoiceId = (int)reader["InvoiceId"],
PaymentDate = (DateTime)reader["PaymentDate"],
Amount = (decimal)reader["Amount"],
PaymentMethod = reader["PaymentMethod"].ToString(),
Status = reader["Status"].ToString()
};
}
}
}
return null;
}
public IEnumerable<Payment> GetAllPayments()
{
var payments = new List<Payment>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Payments", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
payments.Add(new Payment
{
PaymentId = (int)reader["PaymentId"],
InvoiceId = (int)reader["InvoiceId"],
PaymentDate = (DateTime)reader["PaymentDate"],
Amount = (decimal)reader["Amount"],
PaymentMethod = reader["PaymentMethod"].ToString(),
Status = reader["Status"].ToString()
});
}
}
}
return payments;
}
public void AddPayment(Payment payment)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Payments (InvoiceId, PaymentDate, Amount, PaymentMethod, Status) VALUES (@InvoiceId, @PaymentDate, @Amount, @PaymentMethod, @Status)", connection);
command.Parameters.AddWithValue("@InvoiceId", payment.InvoiceId);
command.Parameters.AddWithValue("@PaymentDate", payment.PaymentDate);
command.Parameters.AddWithValue("@Amount", payment.Amount);
command.Parameters.AddWithValue("@PaymentMethod", payment.PaymentMethod);
command.Parameters.AddWithValue("@Status", payment.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdatePayment(Payment payment)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Payments SET InvoiceId = @InvoiceId, PaymentDate = @PaymentDate, Amount = @Amount, PaymentMethod = @PaymentMethod, Status = @Status WHERE PaymentId = @PaymentId", connection);
command.Parameters.AddWithValue("@PaymentId", payment.PaymentId);
command.Parameters.AddWithValue("@InvoiceId", payment.InvoiceId);
command.Parameters.AddWithValue("@PaymentDate", payment.PaymentDate);
command.Parameters.AddWithValue("@Amount", payment.Amount);
command.Parameters.AddWithValue("@PaymentMethod", payment.PaymentMethod);
command.Parameters.AddWithValue("@Status", payment.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeletePayment(int paymentId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Payments WHERE PaymentId = @PaymentId", connection);
command.Parameters.AddWithValue("@PaymentId", paymentId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
InventoryItem Repository
public class InventoryItemRepository : IInventoryItemRepository
{
private readonly string _connectionString;
public InventoryItemRepository(string connectionString)
{
_connectionString = connectionString;
}
public InventoryItem GetInventoryItemById(int itemId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM InventoryItems WHERE ItemId = @ItemId", connection);
command.Parameters.AddWithValue("@ItemId", itemId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new InventoryItem
{
ItemId = (int)reader["ItemId"],
ItemName = reader["ItemName"].ToString(),
Quantity = (int)reader["Quantity"],
UnitPrice = (decimal)reader["UnitPrice"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<InventoryItem> GetAllInventoryItems()
{
var items = new List<InventoryItem>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM InventoryItems", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
items.Add(new InventoryItem
{
ItemId = (int)reader["ItemId"],
ItemName = reader["ItemName"].ToString(),
Quantity = (int)reader["Quantity"],
UnitPrice = (decimal)reader["UnitPrice"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return items;
}
public void AddInventoryItem(InventoryItem item)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO InventoryItems (ItemName, Quantity, UnitPrice) VALUES (@ItemName, @Quantity, @UnitPrice)", connection);
command.Parameters.AddWithValue("@ItemName", item.ItemName);
command.Parameters.AddWithValue("@Quantity", item.Quantity);
command.Parameters.AddWithValue("@UnitPrice", item.UnitPrice);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateInventoryItem(InventoryItem item)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE InventoryItems SET ItemName = @ItemName, Quantity = @Quantity, UnitPrice = @UnitPrice, UpdatedAt = GETDATE() WHERE ItemId = @ItemId", connection);
command.Parameters.AddWithValue("@ItemId", item.ItemId);
command.Parameters.AddWithValue("@ItemName", item.ItemName);
command.Parameters.AddWithValue("@Quantity", item.Quantity);
command.Parameters.AddWithValue("@UnitPrice", item.UnitPrice);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteInventoryItem(int itemId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM InventoryItems WHERE ItemId = @ItemId", connection);
command.Parameters.AddWithValue("@ItemId", itemId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
LabTest Repository
public class LabTestRepository : ILabTestRepository
{
private readonly string _connectionString;
public LabTestRepository(string connectionString)
{
_connectionString = connectionString;
}
public LabTest GetLabTestById(int labTestId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM LabTests WHERE LabTestId = @LabTestId", connection);
command.Parameters.AddWithValue("@LabTestId", labTestId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new LabTest
{
LabTestId = (int)reader["LabTestId"],
TestName = reader["TestName"].ToString(),
Description = reader["Description"].ToString(),
Price = (decimal)reader["Price"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<LabTest> GetAllLabTests()
{
var labTests = new List<LabTest>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM LabTests", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
labTests.Add(new LabTest
{
LabTestId = (int)reader["LabTestId"],
TestName = reader["TestName"].ToString(),
Description = reader["Description"].ToString(),
Price = (decimal)reader["Price"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return labTests;
}
public void AddLabTest(LabTest labTest)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO LabTests (TestName, Description, Price) VALUES (@TestName, @Description, @Price)", connection);
command.Parameters.AddWithValue("@TestName", labTest.TestName);
command.Parameters.AddWithValue("@Description", labTest.Description);
command.Parameters.AddWithValue("@Price", labTest.Price);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateLabTest(LabTest labTest)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE LabTests SET TestName = @TestName, Description = @Description, Price = @Price, UpdatedAt = GETDATE() WHERE LabTestId = @LabTestId", connection);
command.Parameters.AddWithValue("@LabTestId", labTest.LabTestId);
command.Parameters.AddWithValue("@TestName", labTest.TestName);
command.Parameters.AddWithValue("@Description", labTest.Description);
command.Parameters.AddWithValue("@Price", labTest.Price);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteLabTest(int labTestId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM LabTests WHERE LabTestId = @LabTestId", connection);
command.Parameters.AddWithValue("@LabTestId", labTestId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Prescription Repository
public class PrescriptionRepository : IPrescriptionRepository
{
private readonly string _connectionString;
public PrescriptionRepository(string connectionString)
{
_connectionString = connectionString;
}
public Prescription GetPrescriptionById(int prescriptionId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Prescriptions WHERE PrescriptionId = @PrescriptionId", connection);
command.Parameters.AddWithValue("@PrescriptionId", prescriptionId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Prescription
{
PrescriptionId = (int)reader["PrescriptionId"],
PatientId = (int)reader["PatientId"],
DoctorId = (int)reader["DoctorId"],
PrescriptionDate = (DateTime)reader["PrescriptionDate"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Prescription> GetAllPrescriptions()
{
var prescriptions = new List<Prescription>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Prescriptions", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
prescriptions.Add(new Prescription
{
PrescriptionId = (int)reader["PrescriptionId"],
PatientId = (int)reader["PatientId"],
DoctorId = (int)reader["DoctorId"],
PrescriptionDate = (DateTime)reader["PrescriptionDate"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return prescriptions;
}
public void AddPrescription(Prescription prescription)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Prescriptions (PatientId , DoctorId, PrescriptionDate) VALUES (@PatientId, @DoctorId, @PrescriptionDate)", connection);
command.Parameters.AddWithValue("@PatientId", prescription.PatientId);
command.Parameters.AddWithValue("@DoctorId", prescription.DoctorId);
command.Parameters.AddWithValue("@PrescriptionDate", prescription.PrescriptionDate);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdatePrescription(Prescription prescription)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Prescriptions SET PatientId = @PatientId, DoctorId = @DoctorId, PrescriptionDate = @PrescriptionDate, UpdatedAt = GETDATE() WHERE PrescriptionId = @PrescriptionId", connection);
command.Parameters.AddWithValue("@PrescriptionId", prescription.PrescriptionId);
command.Parameters.AddWithValue("@PatientId", prescription.PatientId);
command.Parameters.AddWithValue("@DoctorId", prescription.DoctorId);
command.Parameters.AddWithValue("@PrescriptionDate", prescription.PrescriptionDate);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeletePrescription(int prescriptionId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Prescriptions WHERE PrescriptionId = @PrescriptionId", connection);
command.Parameters.AddWithValue("@PrescriptionId", prescriptionId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Report Repository
public class ReportRepository : IReportRepository
{
private readonly string _connectionString;
public ReportRepository(string connectionString)
{
_connectionString = connectionString;
}
public Report GetReportById(int reportId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Reports WHERE ReportId = @ReportId", connection);
command.Parameters.AddWithValue("@ReportId", reportId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Report
{
ReportId = (int)reader["ReportId"],
PatientId = (int)reader["PatientId"],
ReportDate = (DateTime)reader["ReportDate"],
Description = reader["Description"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Report> GetAllReports()
{
var reports = new List<Report>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Reports", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
reports.Add(new Report
{
ReportId = (int)reader["ReportId"],
PatientId = (int)reader["PatientId"],
ReportDate = (DateTime)reader["ReportDate"],
Description = reader["Description"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return reports;
}
public void AddReport(Report report)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Reports (PatientId, ReportDate, Description) VALUES (@PatientId, @ReportDate, @Description)", connection);
command.Parameters.AddWithValue("@PatientId", report.PatientId);
command.Parameters.AddWithValue("@ReportDate", report.ReportDate);
command.Parameters.AddWithValue("@Description", report.Description);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateReport(Report report)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Reports SET PatientId = @PatientId, ReportDate = @ReportDate, Description = @Description, UpdatedAt = GETDATE() WHERE ReportId = @ReportId", connection);
command.Parameters.AddWithValue("@ReportId", report.ReportId);
command.Parameters.AddWithValue("@PatientId", report.PatientId);
command.Parameters.AddWithValue("@ReportDate", report.ReportDate);
command.Parameters.AddWithValue("@Description", report.Description);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteReport(int reportId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Reports WHERE ReportId = @ReportId", connection);
command.Parameters.AddWithValue("@ReportId", reportId);
connection.Open command.ExecuteNonQuery();
}
}
}
Message Repository
public class MessageRepository : IMessageRepository
{
private readonly string _connectionString;
public MessageRepository(string connectionString)
{
_connectionString = connectionString;
}
public Message GetMessageById(int messageId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Messages WHERE MessageId = @MessageId", connection);
command.Parameters.AddWithValue("@MessageId", messageId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Message
{
MessageId = (int)reader["MessageId"],
SenderId = (int)reader["SenderId"],
ReceiverId = (int)reader["ReceiverId"],
MessageText = reader["MessageText"].ToString(),
SentAt = (DateTime)reader["SentAt"]
};
}
}
}
return null;
}
public IEnumerable<Message> GetAllMessages()
{
var messages = new List<Message>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Messages", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
messages.Add(new Message
{
MessageId = (int)reader["MessageId"],
SenderId = (int)reader["SenderId"],
ReceiverId = (int)reader["ReceiverId"],
MessageText = reader["MessageText"].ToString(),
SentAt = (DateTime)reader["SentAt"]
});
}
}
}
return messages;
}
public void AddMessage(Message message)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Messages (SenderId, ReceiverId, MessageText) VALUES (@SenderId, @ReceiverId, @MessageText)", connection);
command.Parameters.AddWithValue("@SenderId", message.SenderId);
command.Parameters.AddWithValue("@ReceiverId", message.ReceiverId);
command.Parameters.AddWithValue("@MessageText", message.MessageText);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateMessage(Message message)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Messages SET SenderId = @SenderId, ReceiverId = @ReceiverId, MessageText = @MessageText WHERE MessageId = @MessageId", connection);
command.Parameters.AddWithValue("@MessageId", message.MessageId);
command.Parameters.AddWithValue("@SenderId", message.SenderId);
command.Parameters.AddWithValue("@ReceiverId", message.ReceiverId);
command.Parameters.AddWithValue("@MessageText", message.MessageText);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteMessage(int messageId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Messages WHERE MessageId = @MessageId", connection);
command.Parameters.AddWithValue("@MessageId", messageId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
EmergencyContact Repository
public class EmergencyContactRepository : IEmergencyContactRepository
{
private readonly string _connectionString;
public EmergencyContactRepository(string connectionString)
{
_connectionString = connectionString;
}
public EmergencyContact GetEmergencyContactById(int emergencyContactId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM EmergencyContacts WHERE EmergencyContactId = @EmergencyContactId", connection);
command.Parameters.AddWithValue("@EmergencyContactId", emergencyContactId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new EmergencyContact
{
EmergencyContactId = (int)reader["EmergencyContactId"],
PatientId = (int)reader["PatientId"],
ContactName = reader["ContactName"].ToString(),
Relationship = reader["Relationship"].ToString(),
Phone = reader["Phone"].ToString()
};
}
}
}
return null;
}
public IEnumerable<EmergencyContact> GetAllEmergencyContacts()
{
var contacts = new List<EmergencyContact>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM EmergencyContacts", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
contacts.Add(new EmergencyContact
{
EmergencyContactId = (int)reader["EmergencyContactId"],
PatientId = (int)reader["PatientId"],
ContactName = reader["ContactName"].ToString(),
Relationship = reader["Relationship"].ToString(),
Phone = reader["Phone"].ToString()
});
}
}
}
return contacts;
}
public void AddEmergencyContact(EmergencyContact contact)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO EmergencyContacts (PatientId, ContactName, Relationship, Phone) VALUES (@PatientId, @ContactName, @Relationship, @Phone)", connection);
command.Parameters.AddWithValue("@PatientId", contact.PatientId);
command.Parameters.AddWithValue("@ContactName", contact.ContactName);
command.Parameters.AddWithValue("@Relationship", contact.Relationship);
command.Parameters.AddWithValue("@Phone", contact.Phone);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateEmergencyContact(EmergencyContact contact)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE EmergencyContacts SET PatientId = @PatientId, ContactName = @ContactName, Relationship = @Relationship, Phone = @Phone WHERE EmergencyContactId = @EmergencyContactId", connection);
command.Parameters.AddWithValue("@EmergencyContactId", contact.EmergencyContactId);
command.Parameters.AddWithValue("@PatientId", contact.PatientId);
command.Parameters.AddWithValue("@ContactName", contact.ContactName);
command.Parameters.AddWithValue("@Relationship", contact.Relationship);
command.Parameters.AddWithValue("@Phone", contact.Phone);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteEmergencyContact(int emergencyContactId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM EmergencyContacts WHERE EmergencyContactId = @EmergencyContactId", connection);
command.Parameters.AddWithValue("@EmergencyContactId", emergencyContactId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Feedback Repository
public class FeedbackRepository : IFeedbackRepository
{
private readonly string _connectionString;
public FeedbackRepository(string connectionString)
{
_connectionString = connectionString;
}
public Feedback GetFeedbackById(int feedbackId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Feedbacks WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@FeedbackId", feedbackId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Feedback
{
FeedbackId = (int)reader["FeedbackId"],
UserId = (int)reader["User Id"],
Comments = reader["Comments"].ToString(),
Rating = (int)reader["Rating"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Feedback> GetAllFeedbacks()
{
var feedbacks = new List<Feedback>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Feedbacks", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
feedbacks.Add(new Feedback
{
FeedbackId = (int)reader["FeedbackId"],
UserId = (int)reader["User Id"],
Comments = reader["Comments"].ToString(),
Rating = (int)reader["Rating"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return feedbacks;
}
public void AddFeedback(Feedback feedback)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Feedbacks (User Id, Comments, Rating) VALUES (@User Id, @Comments, @Rating)", connection);
command.Parameters.AddWithValue("@User Id", feedback.UserId);
command.Parameters.AddWithValue("@Comments", feedback.Comments);
command.Parameters.AddWithValue("@Rating", feedback.Rating);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateFeedback(Feedback feedback)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Feedbacks SET UserId = @User Id, Comments = @Comments, Rating = @Rating WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@FeedbackId", feedback.FeedbackId command.Parameters.AddWithValue("@User Id", feedback.UserId);
command.Parameters.AddWithValue("@Comments", feedback.Comments);
command.Parameters.AddWithValue("@Rating", feedback.Rating);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteFeedback(int feedbackId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Feedbacks WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@FeedbackId", feedbackId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
This completes the repository implementations for all the models based on the SQL schema you provided. Each repository follows the same pattern for CRUD operations, ensuring a consistent approach to data access throughout your ASP.NET application.
Creating Controllers
To create controllers for each repository in an ASP.NET MVC application, we will follow the standard pattern of creating a controller for each entity. Each controller will handle HTTP requests, interact with the corresponding repository, and return views or data as needed.
Below are example controllers for each of the repositories we created earlier. Each controller will include basic CRUD actions (Create, Read, Update, Delete) and will use dependency injection to access the repositories.
UserController
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
public class UserController : Controller
{
private readonly IUserRepository _userRepository;
public UserController(IUser Repository userRepository)
{
_userRepository = userRepository;
}
public IActionResult Index()
{
var users = _userRepository.GetAllUsers();
return View(users);
}
public IActionResult Details(int id)
{
var user = _userRepository.GetUser ById(id);
return View(user);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(User user)
{
if (ModelState.IsValid)
{
_userRepository.AddUser (user);
return RedirectToAction(nameof(Index));
}
return View(user);
}
public IActionResult Edit(int id)
{
var user = _userRepository.GetUser ById(id);
return View(user);
}
[HttpPost]
public IActionResult Edit(User user)
{
if (ModelState.IsValid)
{
_userRepository.UpdateUser (user);
return RedirectToAction(nameof(Index));
}
return View(user);
}
public IActionResult Delete(int id)
{
var user = _userRepository.GetUser ById(id);
return View(user);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_userRepository.DeleteUser (id);
return RedirectToAction(nameof(Index));
}
}
RoleController
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
public class RoleController : Controller
{
private readonly IRoleRepository _roleRepository;
public RoleController(IRoleRepository roleRepository)
{
_roleRepository = roleRepository;
}
public IActionResult Index()
{
var roles = _roleRepository.GetAllRoles();
return View(roles);
}
public IActionResult Details(int id)
{
var role = _roleRepository.GetRoleById(id);
return View(role);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Role role)
{
if (ModelState.IsValid)
{
_roleRepository.AddRole(role);
return RedirectToAction(nameof(Index));
}
return View(role);
}
public IActionResult Edit(int id)
{
var role = _roleRepository.GetRoleById(id);
return View(role);
}
[HttpPost]
public IActionResult Edit(Role role)
{
if (ModelState.IsValid)
{
_roleRepository.UpdateRole(role);
return RedirectToAction(nameof(Index));
}
return View(role);
}
public IActionResult Delete(int id)
{
var role = _roleRepository.GetRoleById(id);
return View(role);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_roleRepository.DeleteRole(id);
return RedirectToAction(nameof(Index));
}
}
PatientController
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
public class PatientController : Controller
{
private readonly IPatientRepository _patientRepository;
public PatientController(IPatientRepository patientRepository)
{
_patientRepository = patientRepository;
}
public IActionResult Index()
{
var patients = _patientRepository.GetAllPatients();
return View(patients);
}
public IActionResult Details(int id)
{
var patient = _patientRepository.GetPatientById(id);
return View(patient);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Patient patient)
{
if (ModelState.IsValid)
{
_patientRepository.AddPatient(patient);
return RedirectToAction(nameof(Index));
}
return View(patient);
}
public IActionResult Edit(int id)
{
var patient = _patientRepository.GetPatientById(id);
return View(patient);
}
[HttpPost]
public IActionResult Edit(Patient patient)
{
if (ModelState.IsValid)
{
_patientRepository.UpdatePatient(patient);
return RedirectToAction(nameof(Index));
}
return View(patient);
}
public IActionResult Delete(int id)
{
var patient = _patientRepository.GetPatientById(id);
return View(patient);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_patientRepository.DeletePatient(id);
return RedirectToAction(nameof(Index));
}
}
DoctorController
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
public class DoctorController : Controller
{
private readonly IDoctorRepository _doctorRepository;
public DoctorController(IDoctorRepository doctorRepository)
{
_doctorRepository = doctorRepository;
}
public IActionResult Index()
{
var doctors = _doctorRepository.GetAllDoctors();
return View(doctors);
}
public IActionResult Details(int id)
{
var doctor = _doctorRepository.GetDoctorById(id);
return View(doctor);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Doctor doctor)
{
if (ModelState.IsValid)
{
_doctorRepository.AddDoctor(doctor);
return RedirectToAction(nameof(Index));
}
return View(doctor);
}
public IActionResult Edit(int id)
{
var doctor = _doctorRepository.GetDoctorById(id);
return View(doctor);
}
[HttpPost]
public IActionResult Edit(Doctor doctor)
{
if (ModelState.IsValid)
{
_doctorRepository.UpdateDoctor(doctor);
return RedirectToAction(nameof(Index));
}
return View(doctor);
}
public IActionResult Delete(int id)
{
var doctor = _doctorRepository.GetDoctorById(id);
return View(doctor);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_doctorRepository.DeleteDoctor(id);
return RedirectToAction(nameof(Index));
}
}
AppointmentController
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
public class AppointmentController : Controller
{
private readonly IAppointmentRepository _appointmentRepository;
public AppointmentController(IAppointmentRepository appointmentRepository)
{
_appointmentRepository = appointmentRepository;
}
public IActionResult Index()
{
var appointments = _appointmentRepository.GetAllAppointments();
return View(appointments);
}
public IActionResult Details(int id)
{
var appointment = _appointmentRepository.GetAppointmentById(id);
return View(appointment);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Appointment appointment)
{
if (ModelState.IsValid)
{
_appointmentRepository.AddAppointment(appointment);
return RedirectToAction(nameof(Index));
}
return View(appointment);
}
public IActionResult Edit(int id)
{
var appointment = _appointmentRepository.GetAppointmentById(id);
return View(appointment);
}
[HttpPost]
public IActionResult Edit(Appointment appointment)
{
if (ModelState.IsValid)
{
_appointmentRepository.UpdateAppointment(appointment);
return RedirectToAction(nameof(Index));
}
return View(appointment);
}
public IActionResult Delete(int id)
{
var appointment = _appointmentRepository.GetAppointmentById(id);
return View(appointment);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_appointmentRepository.DeleteAppointment(id);
return RedirectToAction(nameof(Index));
}
}
InvoiceController
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
public class InvoiceController : Controller
{
private readonly IInvoiceRepository _invoiceRepository;
public InvoiceController(IInvoiceRepository invoiceRepository)
{
_invoiceRepository = invoiceRepository;
}
public IActionResult Index()
{
var invoices = _invoiceRepository.GetAllInvoices();
return View(invoices);
}
public IActionResult Details(int id)
{
var invoice = _invoiceRepository.GetInvoiceById(id);
return View(invoice);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Invoice invoice)
{
if (ModelState.IsValid)
{
_invoiceRepository.AddInvoice(invoice);
return RedirectToAction(nameof(Index));
}
return View(invoice);
}
public IActionResult Edit(int id)
{
var invoice = _invoiceRepository.GetInvoiceById(id);
return View(invoice);
}
[HttpPost]
public IActionResult Edit(Invoice invoice)
{
if (ModelState.IsValid)
{
_invoiceRepository.UpdateInvoice(invoice);
return RedirectToAction(nameof(Index));
}
return View(invoice);
}
public IActionResult Delete(int id)
{
var invoice = _invoiceRepository.GetInvoiceById(id);
return View(invoice);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_invoiceRepository.DeleteInvoice(id);
return RedirectToAction(nameof(Index));
}
}
PaymentController
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
public class PaymentController : Controller
{
private readonly IPaymentRepository _paymentRepository;
public PaymentController(IPaymentRepository paymentRepository)
{
_paymentRepository = paymentRepository;
}
public IActionResult Index()
{
var payments = _paymentRepository.GetAllPayments();
return View(payments);
}
public IActionResult Details(int id)
{
var payment = _paymentRepository.GetPaymentById(id);
return View(payment);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Payment payment)
{
if (ModelState.IsValid)
{
_paymentRepository.AddPayment(payment);
return RedirectToAction(nameof(Index));
}
return View(payment);
}
public IActionResult Edit(int id)
{
var payment = _paymentRepository.GetPaymentById(id);
return View(payment);
}
[HttpPost]
public IActionResult Edit(Payment payment)
{
if (ModelState.IsValid)
{
_paymentRepository.UpdatePayment(payment);
return RedirectToAction(nameof(Index));
}
return View(payment);
}
public IActionResult Delete(int id)
{
var payment = _paymentRepository.GetPaymentById(id);
return View(payment);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_paymentRepository.DeletePayment(id);
return RedirectToAction(nameof(Index));
}
}
InventoryItemController
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
public class InventoryItemController : Controller
{
private readonly IInventoryItemRepository _inventoryItemRepository;
public InventoryItemController(IInventoryItemRepository inventoryItemRepository)
{
_inventoryItemRepository = inventoryItemRepository;
}
public IActionResult Index()
{
var items = _inventory ItemRepository.GetAllInventoryItems();
return View(items);
}
public IActionResult Details(int id)
{
var item = _inventoryItemRepository.GetInventoryItemById(id);
return View(item);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(InventoryItem item)
{
if (ModelState.IsValid)
{
_inventoryItemRepository.AddInventoryItem(item);
return RedirectToAction(nameof(Index));
}
return View(item);
}
public IActionResult Edit(int id)
{
var item = _inventoryItemRepository.GetInventoryItemById(id);
return View(item);
}
[HttpPost]
public IActionResult Edit(InventoryItem item)
{
if (ModelState.IsValid)
{
_inventoryItemRepository.UpdateInventoryItem(item);
return RedirectToAction(nameof(Index));
}
return View(item);
}
public IActionResult Delete(int id)
{
var item = _inventoryItemRepository.GetInventoryItemById(id);
return View(item);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_inventoryItemRepository.DeleteInventoryItem(id);
return RedirectToAction(nameof(Index));
}
}
LabTestController
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
public class LabTestController : Controller
{
private readonly ILabTestRepository _labTestRepository;
public LabTestController(ILabTestRepository labTestRepository)
{
_labTestRepository = labTestRepository;
}
public IActionResult Index()
{
var labTests = _labTestRepository.GetAllLabTests();
return View(labTests);
}
public IActionResult Details(int id)
{
var labTest = _labTestRepository.GetLabTestById(id);
return View(labTest);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(LabTest labTest)
{
if (ModelState.IsValid)
{
_labTestRepository.AddLabTest(labTest);
return RedirectToAction(nameof(Index));
}
return View(labTest);
}
public IActionResult Edit(int id)
{
var labTest = _labTestRepository.GetLabTestById(id);
return View(labTest);
}
[HttpPost]
public IActionResult Edit(LabTest labTest)
{
if (ModelState.IsValid)
{
_labTestRepository.UpdateLabTest(labTest);
return RedirectToAction(nameof(Index));
}
return View(labTest);
}
public IActionResult Delete(int id)
{
var labTest = _labTestRepository.GetLabTestById(id);
return View(labTest);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_labTestRepository.DeleteLabTest(id);
return RedirectToAction(nameof(Index));
}
}
PrescriptionController
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
public class PrescriptionController : Controller
{
private readonly IPrescriptionRepository _prescriptionRepository;
public PrescriptionController(IPrescriptionRepository prescriptionRepository)
{
_prescriptionRepository = prescriptionRepository;
}
public IActionResult Index()
{
var prescriptions = _prescriptionRepository.GetAllPrescriptions();
return View(prescriptions);
}
public IActionResult Details(int id)
{
var prescription = _prescriptionRepository.GetPrescriptionById(id);
return View(prescription);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Prescription prescription)
{
if (ModelState.IsValid)
{
_prescriptionRepository.AddPrescription(prescription);
return RedirectToAction(nameof(Index));
}
return View(prescription);
}
public IActionResult Edit(int id)
{
var prescription = _prescriptionRepository.GetPrescriptionById(id);
return View(prescription);
}
[HttpPost]
public IActionResult Edit(Prescription prescription)
{
if (ModelState.IsValid)
{
_prescriptionRepository.UpdatePrescription(prescription);
return RedirectToAction(nameof(Index));
}
return View(prescription);
}
public IActionResult Delete(int id)
{
var prescription = _prescriptionRepository.GetPrescriptionById(id);
return View(prescription);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_prescriptionRepository.DeletePrescription(id);
return RedirectToAction(nameof(Index));
}
}
Report Controller
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
public class ReportController : Controller
{
private readonly IReportRepository _reportRepository;
public ReportController(IReportRepository reportRepository)
{
_reportRepository = reportRepository;
}
public IActionResult Index()
{
var reports = _reportRepository.GetAllReports();
return View(reports);
}
public IActionResult Details(int id)
{
var report = _reportRepository.GetReportById(id);
return View(report);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Report report)
{
if (ModelState.IsValid)
{
_reportRepository.AddReport(report);
return RedirectToAction(nameof(Index));
}
return View(report);
}
public IActionResult Edit(int id)
{
var report = _reportRepository.GetReportById(id);
return View(report);
}
[HttpPost]
public IActionResult Edit(Report report)
{
if (ModelState.IsValid)
{
_reportRepository.UpdateReport(report);
return RedirectToAction(nameof(Index));
}
return View(report);
}
public IActionResult Delete(int id)
{
var report = _reportRepository.GetReportById(id);
return View(report);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_reportRepository.DeleteReport(id);
return RedirectToAction(nameof(Index));
}
}
MessageController
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
public class MessageController : Controller
{
private readonly IMessageRepository _messageRepository;
public MessageController(IMessageRepository messageRepository)
{
_messageRepository = messageRepository;
}
public IActionResult Index()
{
var messages = _messageRepository.GetAllMessages();
return View(messages);
}
public IActionResult Details(int id)
{
var message = _messageRepository.GetMessageById(id);
return View(message);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Message message)
{
if (ModelState.IsValid)
{
_messageRepository.AddMessage(message);
return RedirectToAction(nameof(Index));
}
return View(message);
}
public IActionResult Edit(int id)
{
var message = _messageRepository.GetMessageById(id);
return View(message);
}
[HttpPost]
public IActionResult Edit(Message message)
{
if (ModelState.IsValid)
{
_messageRepository.UpdateMessage(message);
return RedirectToAction(nameof(Index));
}
return View(message);
}
public IActionResult Delete(int id)
{
var message = _messageRepository.GetMessageById(id);
return View(message);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_messageRepository.DeleteMessage(id);
return RedirectToAction(nameof(Index));
}
}
EmergencyContactController
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
public class EmergencyContactController : Controller
{
private readonly IEmergencyContactRepository _emergencyContactRepository;
public EmergencyContactController(IEmergencyContactRepository emergencyContactRepository)
{
_emergencyContactRepository = emergencyContactRepository;
}
public IActionResult Index()
{
var contacts = _emergencyContactRepository.GetAllEmergencyContacts();
return View(contacts);
}
public IActionResult Details(int id)
{
var contact = _emergencyContactRepository.GetEmergencyContactById(id);
return View(contact);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(EmergencyContact contact)
{
if (ModelState.IsValid)
{
_emergencyContactRepository.AddEmergencyContact(contact);
return RedirectToAction(nameof(Index));
}
return View(contact);
}
public IActionResult Edit(int id)
{
var contact = _emergencyContactRepository.GetEmergencyContactById(id);
return View(contact);
}
[HttpPost]
public IActionResult Edit(EmergencyContact contact)
{
if (ModelState.IsValid)
{
_emergencyContactRepository.UpdateEmergencyContact(contact);
return RedirectToAction(nameof(Index));
}
return View(contact);
}
public IActionResult Delete(int id)
{
var contact = _emergencyContactRepository.GetEmergencyContactById(id);
return View(contact);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_emergencyContactRepository.DeleteEmergencyContact(id );
return RedirectToAction(nameof(Index));
}
}
FeedbackController
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
public class FeedbackController : Controller
{
private readonly IFeedbackRepository _feedbackRepository;
public FeedbackController(IFeedbackRepository feedbackRepository)
{
_feedbackRepository = feedbackRepository;
}
public IActionResult Index()
{
var feedbacks = _feedbackRepository.GetAllFeedbacks();
return View(feedbacks);
}
public IActionResult Details(int id)
{
var feedback = _feedbackRepository.GetFeedbackById(id);
return View(feedback);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Feedback feedback)
{
if (ModelState.IsValid)
{
_feedbackRepository.AddFeedback(feedback);
return RedirectToAction(nameof(Index));
}
return View(feedback);
}
public IActionResult Edit(int id)
{
var feedback = _feedbackRepository.GetFeedbackById(id);
return View(feedback);
}
[HttpPost]
public IActionResult Edit(Feedback feedback)
{
if (ModelState.IsValid)
{
_feedbackRepository.UpdateFeedback(feedback);
return RedirectToAction(nameof(Index));
}
return View(feedback);
}
public IActionResult Delete(int id)
{
var feedback = _feedbackRepository.GetFeedbackById(id);
return View(feedback);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_feedbackRepository.DeleteFeedback(id);
return RedirectToAction(nameof(Index));
}
}
This completes the controller implementations for all the repositories based on the SQL schema you provided. Each controller follows the standard MVC pattern, allowing for easy interaction with the corresponding repository and providing views for user interaction.
Creating Views
Creating views for each controller in an ASP.NET MVC application involves creating Razor view files that correspond to the actions in the controllers. Below, I will provide a basic structure for the views for each controller, including the necessary files for the Index, Details, Create, Edit, and Delete actions.
Folder Structure
Assuming you have a standard ASP.NET MVC project structure, the views for each controller will be placed in their respective folders under the Views directory. For example, the views for the User Controller will be in Views/User/.
User Views
Views/User/Index.cshtml
@model IEnumerable<User>
<h2>Users</h2>
<a asp-action="Create">Create New User</a>
<table>
<thead>
<tr>
<th>Username</th>
<th>Email</th>
<th>Phone</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var user in Model)
{
<tr>
<td>@user.Username</td>
<td>@user.Email</td>
<td>@user.Phone</td>
<td>
<a asp-action="Details" asp-route-id="@user.UserId">Details</a> |
<a asp-action="Edit" asp-route-id="@user.UserId">Edit</a> |
<a asp-action="Delete" asp-route-id="@user.UserId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/User/Details.cshtml
@model User
<h2>User Details</h2>
<div>
<h4>@Model.Username</h4>
<p>Email: @Model.Email</p>
<p>Phone: @Model.Phone</p>
<p>Created At: @Model.CreatedAt</p>
<p>Updated At: @Model.UpdatedAt</p>
</div>
<a asp-action="Edit" asp-route-id="@Model.UserId">Edit</a> |
<a asp-action="Index">Back to List</a>
Views/User/Create.cshtml
@model User
<h2>Create User</h2>
<form asp-action="Create">
<div>
<label asp-for="Username"></label>
<input asp-for="Username" />
<span asp-validation-for="Username"></span>
</div>
<div>
<label asp-for="PasswordHash"></label>
<input asp-for="PasswordHash" type="password" />
<span asp-validation-for="PasswordHash"></span>
</div>
<div>
<label asp-for="Email"></label>
<input asp-for="Email" />
<span asp-validation-for="Email"></span>
</div>
<div>
<label asp-for="Phone"></label>
<input asp-for="Phone" />
<span asp-validation-for="Phone"></span>
</div>
<div>
<label asp-for="RoleId"></label>
<input asp-for="RoleId" />
<span asp-validation-for="RoleId"></span>
</div>
<button type="submit">Create</button>
</form>
<a asp-action="Index">Back to List</a>
Views/User/Edit.cshtml
@model User
<h2>Edit User</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="User Id" />
<div>
<label asp-for="Username"></label>
<input asp-for="Username" />
<span asp-validation-for="Username"></span>
</div>
<div>
<label asp-for="Email"></label>
<input asp-for="Email" />
<span asp-validation-for="Email"></span>
</div>
<div>
<label asp-for="Phone"></label>
<input asp-for="Phone" />
<span asp-validation-for="Phone"></span>
</div>
<div>
<label asp-for="RoleId"></label>
<input asp-for="RoleId" />
<span asp-validation-for="RoleId"></span>
</div>
<button type="submit">Save</button>
</form>
<a asp-action="Index">Back to List</a>
Views/User/Delete.cshtml
@model User
<h2>Delete User</h2>
<div>
<h4>Are you sure you want to delete this user?</h4>
<h4>@Model.Username</h4>
<p>Email: @Model.Email</p>
<p>Phone: @Model.Phone</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="User Id" />
<button type="submit">Delete</button>
</form>
<a asp-action="Index">Cancel</a>
Role Views
Views/Role/Index.cshtml
@model IEnumerable<Role>
<h2>Roles</h2>
<a asp-action="Create">Create New Role</a>
<table>
<thead>
<tr>
<th>Role Name</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var role in Model)
{
<tr>
<td>@role.RoleName</td>
<td>
<a asp-action="Details" asp-route-id="@role.RoleId">Details</a> |
<a asp-action="Edit" asp-route-id="@role.RoleId">Edit</a> |
<a asp-action="Delete" asp-route-id="@role.RoleId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Role/Details.cshtml
@model Role
<h2>Role Details</h2>
<div>
<h4>@Model.RoleName</h4>
</div>
<a asp-action="Edit" asp-route-id="@Model.RoleId">Edit</a> |
<a asp-action="Index">Back to List</a>
Views/Role/Create.cshtml
@model Role
<h2>Create Role</h2>
<form asp-action="Create">
<div>
<label asp-for="RoleName"></label>
<input asp-for="RoleName" />
<span asp-validation-for="RoleName"></span>
</div>
<button type="submit">Create</button>
</form>
<a asp-action="Index">Back to List</a>
Views/Role/Edit.cshtml
@model Role
<h2>Edit Role</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="RoleId" />
<div>
<label asp-for="RoleName"></label>
<input asp-for="RoleName" />
<span asp-validation-for="RoleName"></span>
</div>
<button type="submit">Save</button>
</form>
<a asp-action="Index">Back to List</a>
Views/Role/Delete.cshtml
@model Role
<h2>Delete Role</h2>
<div>
<h4>Are you sure you want to delete this role?</h4>
<h4>@Model.RoleName</h4>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="RoleId" />
<button type="submit">Delete</button>
</form>
<a asp-action="Index">Cancel</a>
Patient Views
Views/Patient/Index.cshtml
@model IEnumerable<Patient>
<h2>Patients</h2>
<a asp-action="Create">Create New Patient</a>
<table>
<thead>
<tr>
<th>Name</th>
<th>Age</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var patient in Model)
{
<tr>
<td>@patient.Name</td>
<td>@patient.Age</td>
<td>
<a asp-action="Details" asp-route-id="@patient.PatientId">Details</a> |
<a asp-action="Edit" asp-route-id="@patient.PatientId">Edit</a> |
<a asp-action="Delete" asp-route-id="@patient.PatientId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Patient/Details.cshtml
@model Patient
<h2>Patient Details</h2>
<div>
<h4>@Model.Name</h4>
<p>Age: @Model.Age</p>
<p>Gender: @Model.Gender</p>
</div>
<a asp-action="Edit" asp-route-id="@Model.PatientId">Edit</a> |
<a asp-action="Index">Back to List</a>
Views/Patient/Create.cshtml
@model Patient
<h2>Create Patient</h2>
<form asp-action="Create">
<div>
<label asp-for="Name"></label>
<input asp-for="Name" />
<span asp-validation-for="Name"></span>
</div>
<div>
<label asp-for="Age"></label>
<input asp-for="Age" />
<span asp-validation-for="Age"></span>
</div>
<div>
<label asp-for="Gender"></label>
<input asp-for="Gender" />
<span asp-validation-for="Gender"></span>
</div>
<button type="submit">Create</button>
</form>
<a asp-action="Index">Back to List</a>
Views/Patient/Edit.cshtml
@model Patient
<h2>Edit Patient</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="PatientId" />
<div>
<label asp-for="Name"></label>
<input asp-for="Name" />
<span asp-validation-for="Name"></span>
</div>
<div>
<label asp-for="Age"></label>
<input asp-for="Age" />
<span asp-validation-for="Age"></span>
</div>
<div>
<label asp-for="Gender"></label>
<input asp-for="Gender" />
<span asp-validation-for="Gender"></span>
</div>
<button type="submit">Save</button>
</form>
<a asp-action="Index">Back to List</a>
Views/Patient/Delete.cshtml
@model Patient
<h2>Delete Patient</h2>
<div>
<h4>Are you sure you want to delete this patient?</h4>
<h4>@Model.Name</h4>
<p>Age: @Model.Age</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="PatientId" />
<button type="submit">Delete</button>
</form>
<a asp-action="Index">Cancel</a>
Doctor Views
Views/Doctor/Index.cshtml
@model IEnumerable<Doctor>
<h2>Doctors</h2>
<a asp-action="Create">Create New Doctor</a>
<table>
<thead>
<tr>
<th>Name</th>
<th>Specialization</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var doctor in Model)
{
<tr>
<td>@doctor.Name</td>
<td>@doctor.Specialization</td>
<td>
<a asp-action="Details" asp-route-id="@doctor.DoctorId">Details</a> |
<a asp-action="Edit" asp-route-id="@doctor.DoctorId">Edit</a> |
<a asp-action="Delete" asp-route-id="@doctor.DoctorId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Doctor/Details.cshtml
@model Doctor
<h2>Doctor Details</h2>
<div>
<h4>@Model.Name</h4>
<p>Specialization: @Model.Specialization</p>
<p>Phone: @Model.Phone</p>
</div>
<a asp-action="Edit" asp-route-id="@Model.DoctorId">Edit</a> |
<a asp-action="Index">Back to List</a>
Views/Doctor/Create.cshtml
@model Doctor
<h2>Create Doctor</h2>
<form asp-action="Create">
<div>
<label asp-for="Name"></label>
<input asp-for="Name" />
<span asp-validation-for="Name"></span>
</div>
<div>
<label asp-for="Specialization"></label>
<input asp-for="Specialization" />
<span asp-validation-for="Specialization"></span>
</div>
<div>
<label asp-for="Phone"></label>
<input asp-for="Phone" />
<span asp-validation-for="Phone"></span>
</div>
<button type="submit">Create</button>
</form>
<a asp-action="Index">Back to List</a>
Views/Doctor/Edit.cshtml
@model Doctor
<h2>Edit Doctor</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="DoctorId" />
<div>
<label asp-for="Name"></label>
<input asp-for="Name" />
<span asp-validation-for="Name"></span>
</div>
<div>
<label asp-for="Specialization"></label>
<input asp-for="Specialization" />
<span asp-validation-for="Specialization"></span>
</div>
<div>
<label asp-for="Phone"></label>
<input asp-for="Phone" />
<span asp-validation-for="Phone"></span>
</div>
<button type="submit">Save</button>
</form>
<a asp-action="Index">Back to List</a>
Views/Doctor/Delete.cshtml
@model Doctor
<h2>Delete Doctor</h2>
<div>
<h4>Are you sure you want to delete this doctor?</h4>
<h4>@Model.Name</h4>
<p>Specialization: @Model.Specialization</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="DoctorId" />
<button type="submit">Delete</button>
</form>
<a asp-action="Index">Cancel</a>
Appointment Views
Views/Appointment/Index.cshtml
@model IEnumerable<Appointment>
<h2>Appointments</h2>
<a asp-action="Create">Create New Appointment</a>
<table>
<thead>
<tr>
<th>Patient</th>
<th>Doctor</th>
<th>Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var appointment in Model)
{
<tr>
<td>@appointment.PatientName</td>
<td>@appointment.DoctorName</td>
<td>@appointment.AppointmentDate.ToShortDateString()</td>
<td>
<a asp-action="Details" asp-route-id="@appointment.AppointmentId">Details</a> |
<a asp-action="Edit" asp-route-id="@appointment.AppointmentId">Edit</a> |
<a asp-action="Delete" asp-route-id="@appointment.AppointmentId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Appointment/Details.cshtml
@model Appointment
<h2>Appointment Details</h2>
<div>
<h4>Patient: @Model.PatientName</h4>
<p>Doctor: @Model.DoctorName</p>
<p>Date: @Model.AppointmentDate.ToShortDateString()</p>
<p>Notes: @Model.Notes</p>
</div>
<a asp-action="Edit" asp-route-id ="@Model.AppointmentId">Edit</a> |
<a asp-action="Index">Back to List</a>
Views/Appointment/Create.cshtml
@model Appointment
<h2>Create Appointment</h2>
<form asp-action="Create">
<div>
<label asp-for="PatientId"></label>
<input asp-for="PatientId" />
<span asp-validation-for="PatientId"></span>
</div>
<div>
<label asp-for="DoctorId"></label>
<input asp-for="DoctorId" />
<span asp-validation-for="DoctorId"></span>
</div>
<div>
<label asp-for="AppointmentDate"></label>
<input asp-for="AppointmentDate" type="date" />
<span asp-validation-for="AppointmentDate"></span>
</div>
<div>
<label asp-for="Notes"></label>
<textarea asp-for="Notes"></textarea>
<span asp-validation-for="Notes"></span>
</div>
<button type="submit">Create</button>
</form>
<a asp-action="Index">Back to List</a>
Views/Appointment/Edit.cshtml
@model Appointment
<h2>Edit Appointment</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="AppointmentId" />
<div>
<label asp-for="PatientId"></label>
<input asp-for="PatientId" />
<span asp-validation-for="PatientId"></span>
</div>
<div>
<label asp-for="DoctorId"></label>
<input asp-for="DoctorId" />
<span asp-validation-for="DoctorId"></span>
</div>
<div>
<label asp-for="AppointmentDate"></label>
<input asp-for="AppointmentDate" type="date" />
<span asp-validation-for="AppointmentDate"></span>
</div>
<div>
<label asp-for="Notes"></label>
<textarea asp-for="Notes"></textarea>
<span asp-validation-for="Notes"></span>
</div>
<button type="submit">Save</button>
</form>
<a asp-action="Index">Back to List</a>
Views/Appointment/Delete.cshtml
@model Appointment
<h2>Delete Appointment</h2>
<div>
<h4>Are you sure you want to delete this appointment?</h4>
<h4>Patient: @Model.PatientName</h4>
<p>Doctor: @Model.DoctorName</p>
<p>Date: @Model.AppointmentDate.ToShortDateString()</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="AppointmentId" />
<button type="submit">Delete</button>
</form>
<a asp-action="Index">Cancel</a>
Invoice Views
Views/Invoice/Index.cshtml
@model IEnumerable<Invoice>
<h2>Invoices</h2>
<a asp-action="Create">Create New Invoice</a>
<table>
<thead>
<tr>
<th>Invoice Number</th>
<th>Patient</th>
<th>Amount</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var invoice in Model)
{
<tr>
<td>@invoice.InvoiceNumber</td>
<td>@invoice.PatientName</td>
<td>@invoice.Amount.ToString("C")</td>
<td>
<a asp-action="Details" asp-route-id="@invoice.InvoiceId">Details</a> |
<a asp-action="Edit" asp-route-id="@invoice.InvoiceId">Edit</a> |
<a asp-action="Delete" asp-route-id="@invoice.InvoiceId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Invoice/Details.cshtml
@model Invoice
<h2>Invoice Details</h2>
<div>
<h4>Invoice Number: @Model.InvoiceNumber</h4>
<p>Patient: @Model.PatientName</p>
<p>Amount: @Model.Amount.ToString("C")</p>
<p>Date: @Model.InvoiceDate.ToShortDateString()</p>
</div>
<a asp-action="Edit" asp-route-id="@Model.InvoiceId">Edit</a> |
<a asp-action="Index">Back to List</a>
Views/Invoice/Create.cshtml
@model Invoice
<h2>Create Invoice</h2>
<form asp-action="Create">
<div>
<label asp-for="InvoiceNumber"></label>
<input asp-for="InvoiceNumber" />
<span asp-validation-for="InvoiceNumber"></span>
</div>
<div>
<label asp-for="PatientId"></label>
<input asp-for="PatientId" />
<span asp-validation-for="PatientId"></span>
</div>
<div>
<label asp-for="Amount"></label>
<input asp-for="Amount" type="number" step="0.01" />
<span asp-validation-for="Amount"></span>
</div>
<div>
<label asp-for="InvoiceDate"></label>
<input asp-for="InvoiceDate" type="date" />
<span asp-validation-for="InvoiceDate"></span>
</div>
<button type="submit">Create</button>
</form>
<a asp-action="Index">Back to List</a>
Views/Invoice/Edit.cshtml
@model Invoice
<h2>Edit Invoice</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="InvoiceId" />
<div>
<label asp-for="InvoiceNumber"></label>
<input asp-for="InvoiceNumber" />
<span asp-validation-for="InvoiceNumber"></span>
</div>
<div>
<label asp-for="PatientId"></label>
<input asp-for="PatientId" />
<span asp-validation-for="PatientId"></span>
</div>
<div>
<label asp-for="Amount"></label>
<input asp-for="Amount" type="number" step="0.01" />
<span asp-validation-for="Amount"></span>
</div>
<div>
<label asp-for="InvoiceDate"></label>
<input asp-for="InvoiceDate" type="date" />
<span asp-validation-for="InvoiceDate"></span>
</div>
<button type="submit">Save</button>
</form>
<a asp-action="Index">Back to List</a>
Views/Invoice/Delete.cshtml
@model Invoice
<h2>Delete Invoice</h2>
<div>
<h4>Are you sure you want to delete this invoice?</h4>
<h4>Invoice Number: @Model.InvoiceNumber</h4>
<p>Patient: @Model.PatientName</p>
<p>Amount: @Model.Amount.ToString("C")</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="InvoiceId" />
<button type="submit">Delete</button>
</form>
<a asp-action="Index">Cancel</a>
Payment Views
Views/Payment/Index.cshtml
@model IEnumerable<Payment>
<h2>Payments</h2>
<a asp-action="Create">Create New Payment</a>
<table>
<thead>
<tr>
<th>Payment ID</th>
<th>Invoice Number</th>
<th>Amount</th>
<th>Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var payment in Model)
{
<tr>
<td>@payment.PaymentId</td>
<td>@payment.InvoiceNumber</td>
<td>@payment.Amount.ToString("C")</td>
<td>@payment.PaymentDate.ToShortDateString()</td>
<td>
<a asp-action="Details" asp-route-id="@payment.PaymentId">Details</a> |
<a asp-action="Edit" asp-route-id="@payment.PaymentId">Edit</a> |
<a asp-action="Delete" asp-route-id="@payment.PaymentId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Payment/Details.cshtml
@model Payment
<h2>Payment Details</h2>
<div>
<h4>Payment ID: @Model.PaymentId</h4>
<p>Invoice Number: @Model.InvoiceNumber</p>
<p>Amount: @Model.Amount.ToString("C")</p>
<p>Date: @Model.PaymentDate.ToShortDateString()</p>
</div>
<a asp-action="Edit" asp-route-id="@Model.PaymentId">Edit</a> |
<a asp-action="Index">Back to List</a>
Views/Payment/Create.cshtml
@model Payment
<h2>Create Payment</h2>
<form asp-action="Create">
<div>
<label asp-for="InvoiceId"></label>
<input asp-for="InvoiceId" />
<span asp-validation-for="InvoiceId"></span>
</div>
<div>
<label asp-for="Amount"></label>
<input asp-for="Amount" type="number" step="0.01" />
<span asp-validation-for="Amount"></span>
</div>
<div>
<label asp-for="PaymentDate"></label>
<input asp-for="PaymentDate" type="date" />
<span asp-validation-for="PaymentDate"></span>
</div>
<button type="submit">Create</button>
</form>
<a asp-action="Index">Back to List</a>
Views/Payment/Edit.cshtml
@model Payment
<h2>Edit Payment</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="PaymentId" />
<div>
<label asp-for="InvoiceId"></label>
<input asp-for="InvoiceId" />
<span asp-validation-for="InvoiceId"></span>
</div>
<div>
<label asp-for="Amount"></label>
<input asp-for="Amount" type="number" step="0.01" />
<span asp-validation-for="Amount"></span>
</div>
<div>
<label asp-for="PaymentDate"></label>
<input asp-for="PaymentDate" type="date" />
<span asp-validation-for="PaymentDate"></span>
</div>
<button type="submit">Save</button>
</form>
<a asp-action="Index">Back to List</a>
Views/Payment/Delete.cshtml
@model Payment
<h2>Delete Payment</h2>
<div>
<h4>Are you sure you want to delete this payment?</h4>
<h4>Payment ID: @Model.PaymentId</h4>
<p>Invoice Number: @Model.InvoiceNumber</p>
<p>Amount: @Model.Amount.ToString("C")</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="PaymentId" />
<button type="submit">Delete</button>
</form>
<a asp-action="Index">Cancel</a>
InventoryItem Views
Views/InventoryItem/Index.cshtml
@model IEnumerable<InventoryItem>
<h2>Inventory Items</h2>
<a asp-action="Create">Create New Inventory Item</a>
<table>
<thead>
<tr>
<th>Item Name</th>
<th>Quantity</th>
<th>Price</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
<td>@item.ItemName</td>
<td>@item.Quantity</td>
<td>@item.Price.ToString("C")</td>
<td>
<a asp-action="Details" asp-route-id="@item.InventoryItemId">Details</a> |
<a asp-action="Edit" asp-route-id="@item.InventoryItemId">Edit</a> |
<a asp-action="Delete" asp-route-id="@item.InventoryItemId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/InventoryItem/Details.cshtml
@model InventoryItem
<h2>Inventory Item Details</h2>
<div>
<h4>@Model.ItemName</h4>
<p>Quantity: @Model.Quantity</p>
<p>Price: @Model.Price.ToString("C")</p>
</div>
<a asp-action="Edit" asp-route-id="@Model.InventoryItemId">Edit</a> |
<a asp-action="Index">Back to List</a>
Views/InventoryItem/Create.cshtml
@model InventoryItem
<h2>Create Inventory Item</h2>
<form asp-action="Create">
<div>
<label asp-for="ItemName"></label>
<input asp-for="ItemName" />
<span asp-validation-for="ItemName"></span>
</div>
<div>
<label asp-for="Quantity"></label>
<input asp-for="Quantity" type="number" />
<span asp-validation-for="Quantity"></span>
</div>
<div>
<label asp-for="Price"></label>
<input asp-for="Price" type="number" step="0.01" />
<span asp-validation-for="Price"></span>
</div>
<button type="submit">Create</button>
</form>
<a asp-action="Index">Back to List</a>
Views/InventoryItem/Edit.cshtml
@model InventoryItem
<h2>Edit Inventory Item</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="InventoryItemId" />
<div>
<label asp-for="ItemName"></label>
<input asp-for="ItemName" />
<span asp-validation-for="ItemName"></span>
</div>
<div>
<label asp-for="Quantity"></label>
<input asp-for="Quantity" type="number" />
<span asp-validation-for="Quantity"></span>
</div>
<div>
<label asp-for="Price"></label>
<input asp-for="Price" type="number" step="0.01" />
<span asp-validation-for="Price"></span>
</div>
<button type="submit">Save</button>
</form>
<a asp-action="Index">Back to List</a>
Views/InventoryItem/Delete.cshtml
@model InventoryItem
<h2>Delete Inventory Item</h2>
<div>
<h4>Are you sure you want to delete this item?</h4>
<h4>@Model.ItemName</h4>
<p>Quantity: @Model.Quantity</p>
<p>Price: @Model.Price.ToString("C")</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="InventoryItemId" />
<button type="submit">Delete</button>
</form>
<a asp-action="Index">Cancel</a>
LabTest Views
Views/LabTest/Index.cshtml
@model IEnumerable<LabTest>
<h2>Lab Tests</h2>
<a asp-action="Create">Create New Lab Test</a>
<table>
<thead>
<tr>
<th>Test Name</th>
<th>Price</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var labTest in Model)
{
<tr>
<td>@labTest.TestName</td>
<td>@labTest.Price.ToString("C")</td>
<td>
<a asp-action="Details" asp-route-id="@labTest.LabTestId">Details</a> |
<a asp-action="Edit" asp-route-id="@labTest.LabTestId">Edit</a> |
<a asp-action="Delete" asp-route-id="@labTest.LabTestId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/LabTest/Details.cshtml
@model LabTest
<h2>Lab Test Details</h2>
<div>
<h4>@Model.TestName</h4>
<p>Price: @Model.Price.ToString("C")</p>
</div>
<a asp-action="Edit" asp-route-id="@Model.LabTestId">Edit</a> |
<a asp-action="Index">Back to List</a>
Views/LabTest/Create.cshtml
@model LabTest
<h2>Create Lab Test</h2>
<form asp-action="Create">
<div>
<label asp-for="TestName"></label>
<input asp-for="TestName" />
<span asp-validation-for="TestName"></span>
</div>
<div>
<label asp-for="Price"></label>
<input asp-for="Price" type="number" step="0.01" />
<span asp-validation-for="Price"></span>
</div>
<button type="submit">Create</button>
</form>
<a asp-action="Index">Back to List</a>
Views/LabTest/Edit.cshtml
@model LabTest
<h2>Edit Lab Test</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="LabTestId" />
<div>
<label asp-for="TestName"></label>
<input asp-for="TestName" />
<span asp-validation-for="TestName"></span>
</div>
<div>
<label asp-for="Price"></label>
<input asp-for="Price" type="number" step="0.01" />
<span asp-validation-for="Price"></span>
</div>
<button type="submit">Save</button>
</form>
<a asp-action="Index">Back to List</a>
Views/LabTest/Delete.cshtml
@model LabTest
<h2>Delete Lab Test</h2>
<div>
<h4>Are you sure you want to delete this lab test?</h4>
<h4>@Model .TestName</h4>
<p>Price: @Model.Price.ToString("C")</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="LabTestId" />
<button type="submit">Delete</button>
</form>
<a asp-action="Index">Cancel</a>
Prescription Views
Views/Prescription/Index.cshtml
@model IEnumerable<Prescription>
<h2>Prescriptions</h2>
<a asp-action="Create">Create New Prescription</a>
<table>
<thead>
<tr>
<th>Prescription ID</th>
<th>Patient</th>
<th>Doctor</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var prescription in Model)
{
<tr>
<td>@prescription.PrescriptionId</td>
<td>@prescription.PatientName</td>
<td>@prescription.DoctorName</td>
<td>
<a asp-action="Details" asp-route-id="@prescription.PrescriptionId">Details</a> |
<a asp-action="Edit" asp-route-id="@prescription.PrescriptionId">Edit</a> |
<a asp-action="Delete" asp-route-id="@prescription.PrescriptionId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Prescription/Details.cshtml
@model Prescription
<h2>Prescription Details</h2>
<div>
<h4>Prescription ID: @Model.PrescriptionId</h4>
<p>Patient: @Model.PatientName</p>
<p>Doctor: @Model.DoctorName</p>
<p>Medication: @Model.Medication</p>
<p>Dosage: @Model.Dosage</p>
</div>
<a asp-action="Edit" asp-route-id="@Model.PrescriptionId">Edit</a> |
<a asp-action="Index">Back to List</a>
Views/Prescription/Create.cshtml
@model Prescription
<h2>Create Prescription</h2>
<form asp-action="Create">
<div>
<label asp-for="PatientId"></label>
<input asp-for="PatientId" />
<span asp-validation-for="PatientId"></span>
</div>
<div>
<label asp-for="DoctorId"></label>
<input asp-for="DoctorId" />
<span asp-validation-for="DoctorId"></span>
</div>
<div>
<label asp-for="Medication"></label>
<input asp-for="Medication" />
<span asp-validation-for="Medication"></span>
</div>
<div>
<label asp-for="Dosage"></label>
<input asp-for="Dosage" />
<span asp-validation-for="Dosage"></span>
</div>
<button type="submit">Create</button>
</form>
<a asp-action="Index">Back to List</a>
Views/Prescription/Edit.cshtml
@model Prescription
<h2>Edit Prescription</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="PrescriptionId" />
<div>
<label asp-for="PatientId"></label>
<input asp-for="PatientId" />
<span asp-validation-for="PatientId"></span>
</div>
<div>
<label asp-for="DoctorId"></label>
<input asp-for="DoctorId" />
<span asp-validation-for="DoctorId"></span>
</div>
<div>
<label asp-for="Medication"></label>
<input asp-for="Medication" />
<span asp-validation-for="Medication"></span>
</div>
<div>
<label asp-for="Dosage"></label>
<input asp-for="Dosage" />
<span asp-validation-for="Dosage"></span>
</div>
<button type="submit">Save</button>
</form>
<a asp-action="Index">Back to List</a>
Views/Prescription/Delete.cshtml
@model Prescription
<h2>Delete Prescription</h2>
<div>
<h4>Are you sure you want to delete this prescription?</h4>
<h4>Prescription ID: @Model.PrescriptionId</h4>
<p>Patient: @Model.PatientName</p>
<p>Doctor: @Model.DoctorName</p>
<p>Medication: @Model.Medication</p>
<p>Dosage: @Model.Dosage</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="PrescriptionId" />
<button type="submit">Delete</button>
</form>
<a asp-action="Index">Cancel</a>
Report Views
Views/Report/Index.cshtml
@model IEnumerable<Report>
<h2>Reports</h2>
<a asp-action="Create">Create New Report</a>
<table>
<thead>
<tr>
<th>Report ID</th>
<th>Patient</th>
<th>Doctor</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var report in Model)
{
<tr>
<td>@report.ReportId</td>
<td>@report.PatientName</td>
<td>@report.DoctorName</td>
<td>
<a asp-action="Details" asp-route-id="@report.ReportId">Details</a> |
<a asp-action="Edit" asp-route-id="@report.ReportId">Edit</a> |
<a asp-action="Delete" asp-route-id="@report.ReportId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Report/Details.cshtml
@model Report
<h2>Report Details</h2>
<div>
<h4>Report ID: @Model.ReportId</h4>
<p>Patient: @Model.PatientName</p>
<p>Doctor: @Model.DoctorName</p>
<p>Details: @Model.Details</p>
</div>
<a asp-action="Edit" asp-route-id="@Model.ReportId">Edit</a> |
<a asp-action="Index">Back to List</a>
Views/Report/Create.cshtml
@model Report
<h2>Create Report</h2>
<form asp-action="Create">
<div>
<label asp-for="PatientId"></label>
<input asp-for="PatientId" />
<span asp-validation-for="PatientId"></span>
</div>
<div>
<label asp-for="DoctorId"></label>
<input asp-for="DoctorId" />
<span asp-validation-for="DoctorId"></span>
</div>
<div>
<label asp-for="Details"></label>
<textarea asp-for="Details"></textarea>
<span asp-validation-for="Details"></span>
</div>
<button type="submit">Create</button>
</form>
<a asp-action="Index">Back to List</a>
Views/Report/Edit.cshtml
@model Report
<h2>Edit Report</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="ReportId" />
<div>
<label asp-for="PatientId"></label>
<input asp-for="PatientId" />
<span asp-validation-for="PatientId"></span>
</div>
<div>
<label asp-for="DoctorId"></label>
<input asp-for="DoctorId" />
<span asp-validation-for="DoctorId"></span>
</div>
<div>
<label asp-for="Details"></label>
<textarea asp-for="Details"></textarea>
<span asp-validation-for="Details"></span>
</div>
<button type="submit">Save</button>
</form>
<a asp-action="Index">Back to List</a>
Views/Report/Delete.cshtml
@model Report
<h2>Delete Report</h2>
<div>
<h4>Are you sure you want to delete this report?</h4>
<h4>Report ID: @Model.ReportId</h4>
<p>Patient: @Model.PatientName</p>
<p>Doctor: @Model.DoctorName</p>
<p>Details: @Model.Details</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="ReportId" />
<button type="submit">Delete</button>
</form>
<a asp-action="Index">Cancel</a>
Message Views
Views/Message/Index.cshtml
@model IEnumerable<Message>
<h2>Messages</h2>
<a asp-action="Create">Create New Message</a>
<table>
<thead>
<tr>
<th>Message ID</th>
<th>Sender</th>
<th>Receiver</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var message in Model)
{
<tr>
<td>@message.MessageId</td>
<td>@message.SenderName</td>
<td>@message.ReceiverName</td>
<td>
<a asp-action="Details" asp-route-id="@message.MessageId">Details</a> |
<a asp-action="Edit" asp-route-id="@message.MessageId">Edit</a> |
<a asp-action="Delete" asp-route-id="@message.MessageId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Message/Details.cshtml
@model Message
<h2>Message Details</h2>
<div>
<h4>Message ID: @Model.MessageId</h4>
<p>Sender: @Model.SenderName</p>
<p>Receiver: @Model.ReceiverName</p>
<p>Content: @Model.Content</p>
</div>
<a asp-action="Edit" asp-route-id="@Model.MessageId">Edit</a> |
<a asp-action="Index">Back to List</a>
Views/Message/Create.cshtml
@model Message
<h2>Create Message</h2>
<form asp-action="Create">
<div>
<label asp-for="SenderId"></label>
<input asp-for="SenderId" />
<span asp-validation-for="SenderId"></span>
</div>
<div>
<label asp-for="ReceiverId"></label>
<input asp-for="ReceiverId" />
<span asp-validation-for="ReceiverId"></span>
</div>
<div>
<label asp-for="Content"></label>
<textarea asp-for="Content"></textarea>
<span asp-validation-for="Content"></span>
</div>
<button type="submit">Create</button>
</form>
<a asp-action="Index">Back to List</a>
Views/Message/Edit.cshtml
@model Message
<h2>Edit Message</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="MessageId" />
<div>
<label asp-for="SenderId"></label>
<input asp-for="SenderId" />
<span asp-validation-for="SenderId"></span>
</div>
<div>
<label asp-for="ReceiverId"></label>
<input asp-for="ReceiverId" />
<span asp-validation-for="ReceiverId"></span>
</div>
<div>
<label asp-for="Content"></label>
<textarea asp-for="Content"></textarea>
<span asp-validation-for="Content"></span>
</div>
<button type="submit">Save</button>
</form>
<a asp-action="Index">Back to List</a>
Views/Message/Delete.cshtml
@model Message
<h2>Delete Message</h2>
<div>
<h4>Are you sure you want to delete this message?</h4>
<h4>Message ID: @Model.MessageId</h4>
<p>Sender: @Model.SenderName</p>
<p>Receiver: @Model.ReceiverName</p>
<p>Content: @Model.Content</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="MessageId" />
<button type="submit">Delete</button>
</form>
<a asp-action="Index">Cancel</a>
EmergencyContact Views
Views/EmergencyContact/Index.cshtml
@model IEnumerable<EmergencyContact>
<h2>Emergency Contacts</h2>
<a asp-action="Create">Create New Emergency Contact</a>
<table>
<thead>
<tr>
<th>Name</th>
<th>Phone</th>
<th>Relationship</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var contact in Model)
{
<tr>
<td>@contact.Name</td>
<td>@contact.Phone</td>
<td>@contact.Relationship</td>
<td>
<a asp-action="Details" asp-route-id="@contact.EmergencyContactId">Details</a> |
<a asp-action="Edit" asp-route-id="@contact.EmergencyContactId">Edit</a> |
<a asp-action="Delete" asp-route-id="@contact.EmergencyContactId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/EmergencyContact/Details.cshtml
@model EmergencyContact
<h2>Emergency Contact Details</h2>
<div>
<h4>@Model.Name</h4>
<p>Phone: @Model.Phone</p>
<p>Relationship: @Model.Relationship</p>
</div>
<a asp-action="Edit" asp-route-id="@Model.EmergencyContactId">Edit</a> |
<a asp-action="Index">Back to List</a>
Views/EmergencyContact/Create.cshtml
@model EmergencyContact
<h2>Create Emergency Contact</h2>
<form asp-action="Create">
<div>
<label asp-for="Name"></label>
<input asp-for="Name" />
<span asp-validation-for="Name"></span>
</div>
<div>
<label asp-for="Phone"></label>
<input asp-for="Phone" />
<span asp-validation-for="Phone"></span>
</div>
<div>
<label asp-for="Relationship"></label>
<input asp-for="Relationship" />
<span asp-validation-for="Relationship"></span>
</div>
<button type="submit">Create</button>
</form>
<a asp-action="Index">Back to List</a>
Views/EmergencyContact/Edit.cshtml
@model EmergencyContact
<h2>Edit Emergency Contact</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="EmergencyContactId" />
<div>
<label asp-for="Name"></label>
<input asp-for="Name" />
<span asp-validation-for="Name"></span>
</div>
<div>
<label asp-for="Phone"></label>
<input asp-for="Phone" />
<span asp-validation-for="Phone"></span>
</div>
<div>
<label asp-for="Relationship"></label>
<input asp-for="Relationship" />
<span asp-validation-for="Relationship"></span>
</div>
<button type="submit">Save</button>
</form>
<a asp-action="Index">Back to List</a>
Views/EmergencyContact/Delete.cshtml
@model EmergencyContact
<h2>Delete Emergency Contact</h2>
<div>
<h4>Are you sure you want to delete this contact?</h4>
<h4>@Model.Name</h4>
<p>Phone: @Model.Phone</p>
<p>Relationship: @Model.Relationship</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="EmergencyContactId" />
<button type="submit">Delete</button>
</form>
<a asp-action="Index">Cancel</a>
Feedback Views
Views/Feedback/Index.cshtml
@model IEnumerable<Feedback>
<h2>Feedbacks</h2>
<a asp-action="Create">Create New Feedback</a>
<table>
<thead>
<tr>
<th>Feedback ID</th>
<th>Patient</th>
<th>Comments</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var feedback in Model)
{
<tr>
<td>@feedback.FeedbackId</td>
<td>@feedback.PatientName</td>
<td>@feedback.Comments</td>
<td>
<a asp-action="Details" asp-route-id="@feedback.FeedbackId">Details</a> |
<a asp-action="Edit" asp-route-id="@feedback.FeedbackId">Edit</a> |
<a asp-action="Delete" asp-route-id="@feedback.FeedbackId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Feedback/Details.cshtml
@model Feedback
<h2>Feedback Details</h2>
<div>
<h4>Feedback ID: @Model.FeedbackId</h4>
<p>Patient: @Model.PatientName</p>
<p>Comments: @Model.Comments</p>
</div>
<a asp-action="Edit" asp-route-id="@Model.FeedbackId">Edit</a> |
<a asp-action="Index">Back to List</a>
Views/Feedback/Create.cshtml
@model Feedback
<h2>Create Feedback</h2>
<form asp-action="Create">
<div>
<label asp-for="PatientId"></label>
<input asp-for="PatientId" />
<span asp-validation-for="PatientId"></span>
</div>
<div>
<label asp-for="Comments"></label>
<textarea asp-for="Comments"></textarea>
<span asp-validation-for="Comments"></span>
</div>
<button type="submit">Create</button>
</form>
<a asp-action="Index">Back to List</a>
Views/Feedback/Edit.cshtml
@model Feedback
<h2>Edit Feedback</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="FeedbackId" />
<div>
<label asp-for="PatientId"></label>
<input asp-for="PatientId" />
<span asp-validation-for="PatientId"></span>
</div>
<div>
<label asp-for="Comments"></label>
<textarea asp-for="Comments"></textarea>
<span asp-validation-for="Comments"></span>
</div>
<button type="submit">Save</button>
</form>
<a asp-action="Index">Back to List</a>
Views/Feedback/Delete.cshtml
@model Feedback
<h2>Delete Feedback</h2>
<div>
<h4>Are you sure you want to delete this feedback?</h4>
<h4>Feedback ID: @Model.FeedbackId</h4>
<p>Patient: @Model.PatientName</p>
<p>Comments: @Model.Comments</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="FeedbackId" />
<button type="submit">Delete</button>
</form>
<a asp-action="Index">Cancel</a>
Creating a Dashboard Page
Creating a dashboard page in an ASP.NET MVC application involves aggregating data from various models and presenting it in a user-friendly format. Below, I will outline how to create a simple dashboard that displays consolidated data related to the project, such as the number of users, roles, patients, doctors, appointments, invoices, payments, and feedback.
Step 1: Create a Dashboard ViewModel
First, we need to create a ViewModel that will hold the consolidated data for the dashboard.
Models/DashboardViewModel.cs
public class DashboardViewModel
{
public int TotalUsers { get; set; }
public int TotalRoles { get; set; }
public int TotalPatients { get; set; }
public int TotalDoctors { get; set; }
public int TotalAppointments { get; set; }
public int TotalInvoices { get; set; }
public int TotalPayments { get; set; }
public int TotalFeedbacks { get; set; }
}
Step 2: Create a Dashboard Controller
Next, we will create a controller that will fetch the necessary data from the repositories and pass it to the dashboard view.
Controllers/DashboardController.cs
using Microsoft.AspNetCore.Mvc;
public class DashboardController : Controller
{
private readonly IUserRepository _userRepository;
private readonly IRoleRepository _roleRepository;
private readonly IPatientRepository _patientRepository;
private readonly IDoctorRepository _doctorRepository;
private readonly IAppointmentRepository _appointmentRepository;
private readonly IInvoiceRepository _invoiceRepository;
private readonly IPaymentRepository _paymentRepository;
private readonly IFeedbackRepository _feedbackRepository;
public DashboardController(IUser Repository userRepository, IRoleRepository roleRepository,
IPatientRepository patientRepository, IDoctorRepository doctorRepository,
IAppointmentRepository appointmentRepository, IInvoiceRepository invoiceRepository,
IPaymentRepository paymentRepository, IFeedbackRepository feedbackRepository)
{
_userRepository = userRepository;
_roleRepository = roleRepository;
_patientRepository = patientRepository;
_doctorRepository = doctorRepository;
_appointmentRepository = appointmentRepository;
_invoiceRepository = invoiceRepository;
_paymentRepository = paymentRepository;
_feedbackRepository = feedbackRepository;
}
public IActionResult Index()
{
var dashboardViewModel = new DashboardViewModel
{
TotalUsers = _userRepository.GetAllUsers().Count(),
TotalRoles = _roleRepository.GetAllRoles().Count(),
TotalPatients = _patientRepository.GetAllPatients().Count(),
TotalDoctors = _doctorRepository.GetAllDoctors().Count(),
TotalAppointments = _appointmentRepository.GetAllAppointments().Count(),
TotalInvoices = _invoiceRepository.GetAllInvoices().Count(),
TotalPayments = _paymentRepository.GetAllPayments().Count(),
TotalFeedbacks = _feedbackRepository.GetAllFeedbacks().Count()
};
return View(dashboardViewModel);
}
}
Step 3: Create the Dashboard View
Now, we will create the view that will display the dashboard data.
Views/Dashboard/Index.cshtml
@model DashboardViewModel
<h2>Dashboard</h2>
<div class="dashboard">
<div class="card">
<h3>Total Users</h3>
<p>@Model.TotalUsers</p>
</div>
<div class="card">
<h3>Total Roles</h3>
<p>@Model.TotalRoles</p>
</div>
<div class="card">
<h3>Total Patients</h3>
<p>@Model.TotalPatients</p>
</div>
<div class="card">
<h3>Total Doctors</h3>
<p>@Model.TotalDoctors</p>
</div>
<div class="card">
<h3>Total Appointments</h3>
<p>@Model.TotalAppointments</p>
</div>
<div class="card">
<h3>Total Invoices</h3>
<p>@Model.TotalInvoices</p>
</div>
<div class="card">
<h3>Total Payments</h3>
<p>@Model.TotalPayments</p>
</div>
<div class="card">
<h3>Total Feedbacks</h3>
<p>@Model.TotalFeedbacks</p>
</div>
</div>
<style>
.dashboard {
display: grid;
grid-template-columns: repeat(auto-fill, minmax(200px, 1fr));
gap: 20px;
}
.card {
border: 1px solid #ccc;
border-radius: 5px;
padding: 20px;
text-align: center;
background-color: #f9f9f9;
}
</style>
Step 4: Update the Navigation
To access the dashboard, you may want to add a link to it in your main layout or navigation menu.
Views/Shared/_Layout.cshtml
<nav>
<ul>
<li><a asp-controller="Dashboard" asp-action="Index">Dashboard</a></li>
<li><a asp-controller="User " asp-action="Index">Users</a></li>
<li><a asp-controller="Role" asp-action="Index">Roles</a></li>
<li><a asp-controller="Patient" asp-action="Index">Patients</a></li>
<li><a asp-controller="Doctor" asp-action="Index">Doctors</a></li>
<li><a asp-controller="Appointment" asp-action="Index">Appointments</a></li>
<li><a asp-controller="Invoice" asp-action="Index">Invoices</a></li>
<li><a asp-controller="Payment" asp-action="Index">Payments</a></li>
<li><a asp-controller="Feedback" asp-action="Index">Feedbacks</a></li>
</ul>
</nav>
AI 
ASP.NET API 
ASP.NET CLI 
ASP.NET Core 
ASP.NET MVC 
ASP.NET Projects With Source Code 
ASP.NET Web Forms 
ASP.NET Web Pages 
AWS 
Angular 10 
Bash 
Bitcoin 
Blockchain 
C Tutorial 
C# 
CPP 
Chat GPT 
Cheat Sheet 
Cyber Security 
Dart 
Django 
Docker 
Ether.js 
Ethereum 
Flask 
Flask Projects With Source Code 
GEN AI 
Git 
Go Language 
Google Cloud Platform 
GraphQL 
Hardhat 
INI 
JSON 
Java 
JavaScript 
Kotlin 
Kubernetes 
LaTeX 
Laravel 
Laravel 10 E-Commerce Project 
Laravel 11 E-Commerce Project 
Laravel 9 E-Commerce Project 
Laravel 9 React Tutorial 
Laravel E-Commerce Project 
Laravel Home Services Project 
Laravel Projects With Source Code 
Laravel Tutorial Advanced 
Laravel Tutorial Beginners 
Livewire 
Markdown 
Matlab 
Metamask 
Microsoft Azure 
MongoDB Tutorial Advanced 
MongoDB Tutorial Beginners 
MySql Tutorial Advanced 
MySql Tutorial Beginners 
NextJS 
Node JS 
Node JS Projects With Source Code 
PHP Projects With Source Code 
PHP Tutorial Advanced 
PHP Tutorial Beginners 
Project Database Schema 
Python 
React JS 
Ruby 
Rust 
SQL Server Queries 
SQL Server Tutorial Advanced 
SQL Server Tutorial Beginners 
Sass 
Solidity 
Spring Boot 
Truffle 
TypeScript 
VueJS 
Web3.js 
WordPress Tutorial Advanced 
WordPress Tutorial Beginners 
YAML