Project Introduction
The Coaching Management System is designed to facilitate the management of coaching classes, including course offerings, student enrollments, attendance tracking, assessments, and payments. Built using ASP.NET and SQL Server, this system aims to provide a comprehensive solution for coaching centers to manage their operations efficiently. The application will allow administrators to create and manage courses, track student progress, and generate reports, enhancing the overall learning experience for students.
Project Objectives
- To create a user-friendly interface for students and administrators to manage courses and enrollments.
- To implement a secure authentication system for users with different roles (e.g., admin, student).
- To manage course details, including syllabus, schedules, and resources.
- To facilitate student enrollment in courses and track their attendance.
- To handle assessments and feedback for continuous improvement of courses.
- To manage payments and generate invoices for enrolled students.
- To provide notifications and reports to keep users informed about course updates and performance.
Project Modules
- User Management Module: Handles user registration, login, and role management.
- Course Management Module: Manages course creation, updates, and syllabus details.
- Schedule Management Module: Facilitates the creation and management of course schedules.
- Enrollment Management Module: Handles student enrollments, including status tracking.
- Attendance Management Module: Tracks student attendance for each class session.
- Assessment Management Module: Manages assessments, quizzes, and exams for courses.
- Payment Management Module: Handles payment processing and invoice generation for courses.
- Feedback Management Module: Collects and manages feedback from students on courses.
- Reporting Module: Generates reports on student performance, attendance, and course effectiveness.
- Resource Management Module: Manages additional resources such as books, articles, and videos for courses.
- Notification Module: Sends notifications to users regarding course updates and important announcements.
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
);
-- Courses Table
CREATE TABLE Courses (
CourseId INT PRIMARY KEY IDENTITY(1,1),
CourseName NVARCHAR(100) NOT NULL,
Description NVARCHAR(MAX),
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE()
);
-- Syllabus Table
CREATE TABLE Syllabuses (
SyllabusId INT PRIMARY KEY IDENTITY(1,1),
CourseId INT,
Topic NVARCHAR(255) NOT NULL,
Description NVARCHAR(MAX),
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (CourseId) REFERENCES Courses(CourseId)
);
-- Schedule Table
CREATE TABLE Schedules (
ScheduleId INT PRIMARY KEY IDENTITY(1,1),
CourseId INT,
StartDate DATETIME NOT NULL,
EndDate DATETIME NOT NULL,
Location NVARCHAR(100),
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (CourseId) REFERENCES Courses(CourseId)
);
-- Enrollments Table
CREATE TABLE Enrollments (
EnrollmentId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
CourseId INT,
EnrollmentDate DATETIME DEFAULT GETDATE(),
Status NVARCHAR(20) DEFAULT 'Active', -- e.g., Active, Completed, Dropped
FOREIGN KEY (User Id) REFERENCES Users(UserId),
FOREIGN KEY (CourseId) REFERENCES Courses(CourseId)
);
-- Attendance Table
CREATE TABLE Attendance (
AttendanceId INT PRIMARY KEY IDENTITY(1,1),
EnrollmentId INT,
ScheduleId INT,
Attended BIT DEFAULT 0,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (EnrollmentId) REFERENCES Enrollments(EnrollmentId),
FOREIGN KEY (ScheduleId) REFERENCES Schedules(ScheduleId)
);
-- Assessments Table
CREATE TABLE Assessments (
AssessmentId INT PRIMARY KEY IDENTITY(1,1),
CourseId INT,
AssessmentType NVARCHAR(50), -- e.g., Quiz, Exam
TotalMarks INT,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (CourseId) REFERENCES Courses(CourseId)
);
-- Payments Table
CREATE TABLE Payments (
PaymentId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
CourseId INT,
Amount DECIMAL(10, 2) NOT NULL,
PaymentDate DATETIME DEFAULT GETDATE(),
PaymentMethod NVARCHAR(50), -- e.g., Credit Card, Bank Transfer
Status NVARCHAR(20) DEFAULT 'Pending',
FOREIGN KEY (User Id) REFERENCES Users(UserId),
FOREIGN KEY (CourseId) REFERENCES Courses(CourseId)
);
-- Feedback Table
CREATE TABLE Feedbacks (
FeedbackId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
CourseId INT,
Comments NVARCHAR(MAX),
Rating INT CHECK (Rating >= 1 AND Rating <= 5),
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId),
FOREIGN KEY (CourseId) REFERENCES Courses(CourseId)
);
-- Reports Table
CREATE TABLE Reports (
ReportId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
CourseId INT,
ReportDate DATETIME DEFAULT GETDATE(),
Description NVARCHAR(MAX),
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId),
FOREIGN KEY (CourseId) REFERENCES Courses(CourseId)
);
-- Resources Table
CREATE TABLE Resources (
ResourceId INT PRIMARY KEY IDENTITY(1,1),
CourseId INT,
ResourceType NVARCHAR(50), -- e.g., Book, Article, Video
ResourceUrl NVARCHAR(255) NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (CourseId) REFERENCES Courses(CourseId)
);
-- Notifications Table
CREATE TABLE Notifications (
NotificationId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
Message NVARCHAR(MAX),
IsRead BIT DEFAULT 0,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
Explanation of the Tables
Users: Stores user information, including credentials and roles.
Roles: Defines different roles within the system (e.g., admin, instructor, student).
Courses: Contains details about the courses offered, including descriptions and timestamps.
Syllabuses: Manages the syllabus for each course, detailing topics and descriptions.
Schedules: Tracks the scheduling of courses, including start and end dates and locations.
Enrollments: Records user enrollments in courses, along with their status.
Attendance: Monitors attendance for scheduled sessions linked to enrollments.
Assessments: Stores information about assessments related to courses, including types and total marks.
Payments: Manages payment records for courses, including amounts and payment methods.
Feedback: Collects feedback from users regarding courses, including ratings and comments.
Reports: Records reports generated by users regarding courses, including descriptions and timestamps.
Resources: Contains additional resources related to courses, such as articles and videos.
Notifications: Manages notifications sent to users, tracking whether they have been read.
Creating Models and Repositories
To create a model and repository pattern using ADO.NET for the provided SQL Server database schema in an ASP.NET application, we will follow these steps:
Step 1: Create Model Classes
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 Course
{
public int CourseId { get; set; }
public string CourseName { get; set; }
public string Description { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Syllabus
{
public int SyllabusId { get; set; }
public int CourseId { get; set; }
public string Topic { get; set; }
public string Description { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Schedule
{
public int ScheduleId { get; set; }
public int CourseId { get; set; }
public DateTime StartDate { get; set; }
public DateTime EndDate { get; set; }
public string Location { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Enrollment
{
public int EnrollmentId { get; set; }
public int UserId { get; set; }
public int CourseId { get; set; }
public DateTime EnrollmentDate { get; set; }
public string Status { get; set; }
}
public class Attendance
{
public int AttendanceId { get; set; }
public int EnrollmentId { get; set; }
public int ScheduleId { get; set; }
public bool Attended { get; set; }
public DateTime CreatedAt { get; set; }
}
public class Assessment
{
public int AssessmentId { get; set; }
public int CourseId { get; set; }
public string AssessmentType { get; set; }
public int TotalMarks { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Payment
{
public int PaymentId { get; set; }
public int UserId { get; set; }
public int CourseId { get; set; }
public decimal Amount { get; set; }
public DateTime PaymentDate { get; set; }
public string PaymentMethod { get; set; }
public string Status { get; set; }
}
public class Feedback
{
public int FeedbackId { get; set; }
public int UserId { get; set; }
public int CourseId { get; set; }
public string Comments { get; set; }
public int Rating { get; set; }
public DateTime CreatedAt { get; set; }
}
public class Report
{
public int ReportId { get; set; }
public int UserId { get; set; }
public int CourseId { get; set; }
public DateTime ReportDate { get; set; }
public string Description { get; set; }
public DateTime CreatedAt { get; set; }
}
public class Resource
{
public int ResourceId { get; set; }
public int CourseId { get; set; }
public string ResourceType { get; set; }
public string ResourceUrl { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Notification
{
public int NotificationId { get; set; }
public int UserId { get; set; }
public string Message { get; set; }
public bool IsRead { get; set; }
public DateTime CreatedAt { get; set; }
}
Step 2: Create Repository Interfaces
Define interfaces for the repositories. Here’s an example for the User repository:
public interface IUserRepository
{
User GetUser ById(int userId);
IEnumerable<User> GetAllUsers();
void AddUser (User user);
void UpdateUser (User user);
void DeleteUser (int userId);
}
You would create similar interfaces for other entities (e.g., ICourseRepository, IRoleRepository, etc.).
Step 3: Implement Repository Classes
Here’s 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", (object)user.Phone ?? DBNull.Value);
command.Parameters.AddWithValue("@RoleId", (object)user.RoleId ?? 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", (object)user.Phone ?? DBNull.Value);
command.Parameters.AddWithValue("@RoleId", (object)user.RoleId ?? 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 by creating their respective repository interfaces and classes, ensuring that each repository handles its specific data operations using ADO.NET.
Additional Repository Implementations
Below are the repository interfaces and implementations for the remaining models based on the SQL schema you provided. Each repository will follow a similar pattern to the User Repository example.
Role Repository
Interface:
public interface IRoleRepository
{
Role GetRoleById(int roleId);
IEnumerable<Role> GetAllRoles();
void AddRole(Role role);
void UpdateRole(Role role);
void DeleteRole(int roleId);
}
Implementation:
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();
}
}
}
Course Repository
Interface:
public interface ICourseRepository
{
Course GetCourseById(int courseId);
IEnumerable<Course> GetAllCourses();
void AddCourse(Course course);
void UpdateCourse(Course course);
void DeleteCourse(int courseId);
}
Implementation:
public class CourseRepository : ICourseRepository
{
private readonly string _connectionString;
public CourseRepository(string connectionString)
{
_connectionString = connectionString;
}
public Course GetCourseById(int courseId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Courses WHERE CourseId = @CourseId", connection);
command.Parameters.AddWithValue("@CourseId", courseId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Course
{
CourseId = (int)reader["CourseId"],
CourseName = reader["CourseName"].ToString(),
Description = reader["Description"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Course> GetAllCourses()
{
var courses = new List<Course>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Courses", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
courses.Add(new Course
{
CourseId = (int)reader["CourseId"],
CourseName = reader["CourseName"].ToString(),
Description = reader["Description"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return courses;
}
public void AddCourse(Course course)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Courses (CourseName, Description) VALUES (@CourseName, @Description)", connection);
command.Parameters.AddWithValue("@CourseName", course.CourseName);
command.Parameters.AddWithValue("@Description", course.Description);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateCourse(Course course)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Courses SET CourseName = @CourseName, Description = @Description, UpdatedAt = GETDATE() WHERE CourseId = @CourseId", connection);
command.Parameters.AddWithValue("@CourseId", course.CourseId);
command.Parameters.AddWithValue("@CourseName", course.CourseName);
command.Parameters.AddWithValue("@Description", course.Description);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteCourse(int courseId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Courses WHERE CourseId = @CourseId", connection);
command.Parameters.AddWithValue("@CourseId", courseId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Syllabus Repository
Interface:
public interface ISyllabusRepository
{
Syllabus GetSyllabusById(int syllabusId);
IEnumerable<Syllabus> GetAllSyllabuses();
void AddSyllabus(Syllabus syllabus);
void UpdateSyllabus(Syllabus syllabus);
void DeleteSyllabus(int syllabusId);
}
Implementation:
public class SyllabusRepository : ISyllabusRepository
{
private readonly string _connectionString;
public SyllabusRepository(string connectionString)
{
_connectionString = connectionString;
}
public Syllabus GetSyllabusById(int syllabusId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Syllabuses WHERE SyllabusId = @SyllabusId", connection);
command.Parameters.AddWithValue("@SyllabusId", syllabusId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Syllabus
{
SyllabusId = (int)reader["SyllabusId"],
CourseId = (int)reader["CourseId"],
Topic = reader["Topic"].ToString(),
Description = reader["Description"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Syllabus> GetAllSyllabuses()
{
var syllabuses = new List<Syllabus>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Syllabuses", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
syllabuses.Add(new Syllabus
{
SyllabusId = (int)reader["SyllabusId"],
CourseId = (int)reader["CourseId"],
Topic = reader["Topic"].ToString(),
Description = reader["Description"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return syllabuses;
}
public void AddSyllabus(Syllabus syllabus)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Syllabuses (CourseId, Topic, Description) VALUES (@CourseId, @Topic, @Description)", connection);
command.Parameters.AddWithValue("@CourseId", syllabus.CourseId);
command.Parameters.AddWithValue("@Topic", syllabus.Topic);
command.Parameters.AddWithValue("@Description", syllabus.Description);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateSyllabus(Syllabus syllabus)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Syllabuses SET CourseId = @CourseId, Topic = @Topic, Description = @Description, UpdatedAt = GETDATE() WHERE SyllabusId = @SyllabusId", connection);
command.Parameters.AddWithValue("@SyllabusId", syllabus.SyllabusId);
command.Parameters.AddWithValue("@CourseId", syllabus.CourseId);
command.Parameters.AddWithValue("@Topic", syllabus.Topic);
command.Parameters.AddWithValue("@Description", syllabus.Description);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteSyllabus(int syllabusId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Syllabuses WHERE SyllabusId = @SyllabusId", connection);
command.Parameters.AddWithValue("@SyllabusId", syllabusId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Schedule Repository
Interface:
public interface IScheduleRepository
{
Schedule GetScheduleById(int scheduleId);
IEnumerable<Schedule> GetAllSchedules();
void AddSchedule(Schedule schedule);
void UpdateSchedule(Schedule schedule);
void DeleteSchedule(int scheduleId);
}
Implementation:
public class ScheduleRepository : IScheduleRepository
{
private readonly string _connectionString;
public ScheduleRepository(string connectionString)
{
_connectionString = connectionString;
}
public Schedule GetScheduleById(int scheduleId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Schedules WHERE ScheduleId = @ScheduleId", connection);
command.Parameters.AddWithValue("@ScheduleId", scheduleId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Schedule
{
ScheduleId = (int)reader["ScheduleId"],
CourseId = (int)reader["CourseId"],
StartDate = (DateTime)reader["Start Date"],
EndDate = (DateTime)reader["EndDate"],
Location = reader["Location"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Schedule> GetAllSchedules()
{
var schedules = new List<Schedule>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Schedules", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
schedules.Add(new Schedule
{
ScheduleId = (int)reader["ScheduleId"],
CourseId = (int)reader["CourseId"],
StartDate = (DateTime)reader["StartDate"],
EndDate = (DateTime)reader["EndDate"],
Location = reader["Location"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return schedules;
}
public void AddSchedule(Schedule schedule)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Schedules (CourseId, StartDate, EndDate, Location) VALUES (@CourseId, @StartDate, @EndDate, @Location)", connection);
command.Parameters.AddWithValue("@CourseId", schedule.CourseId);
command.Parameters.AddWithValue("@StartDate", schedule.StartDate);
command.Parameters.AddWithValue("@EndDate", schedule.EndDate);
command.Parameters.AddWithValue("@Location", schedule.Location);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateSchedule(Schedule schedule)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Schedules SET CourseId = @CourseId, StartDate = @StartDate, EndDate = @EndDate, Location = @Location, UpdatedAt = GETDATE() WHERE ScheduleId = @ScheduleId", connection);
command.Parameters.AddWithValue("@ScheduleId", schedule.ScheduleId);
command.Parameters.AddWithValue("@CourseId", schedule.CourseId);
command.Parameters.AddWithValue("@StartDate", schedule.StartDate);
command.Parameters.AddWithValue("@EndDate", schedule.EndDate);
command.Parameters.AddWithValue("@Location", schedule.Location);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteSchedule(int scheduleId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Schedules WHERE ScheduleId = @ScheduleId", connection);
command.Parameters.AddWithValue("@ScheduleId", scheduleId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Enrollment Repository
Interface:
public interface IEnrollmentRepository
{
Enrollment GetEnrollmentById(int enrollmentId);
IEnumerable<Enrollment> GetAllEnrollments();
void AddEnrollment(Enrollment enrollment);
void UpdateEnrollment(Enrollment enrollment);
void DeleteEnrollment(int enrollmentId);
}
Implementation:
public class EnrollmentRepository : IEnrollmentRepository
{
private readonly string _connectionString;
public EnrollmentRepository(string connectionString)
{
_connectionString = connectionString;
}
public Enrollment GetEnrollmentById(int enrollmentId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Enrollments WHERE EnrollmentId = @EnrollmentId", connection);
command.Parameters.AddWithValue("@EnrollmentId", enrollmentId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Enrollment
{
EnrollmentId = (int)reader["EnrollmentId"],
UserId = (int)reader["User Id"],
CourseId = (int)reader["CourseId"],
EnrollmentDate = (DateTime)reader["EnrollmentDate"],
Status = reader["Status"].ToString()
};
}
}
}
return null;
}
public IEnumerable<Enrollment> GetAllEnrollments()
{
var enrollments = new List<Enrollment>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Enrollments", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
enrollments.Add(new Enrollment
{
EnrollmentId = (int)reader["EnrollmentId"],
UserId = (int)reader["User Id"],
CourseId = (int)reader["CourseId"],
EnrollmentDate = (DateTime)reader["EnrollmentDate"],
Status = reader["Status"].ToString()
});
}
}
}
return enrollments;
}
public void AddEnrollment(Enrollment enrollment)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Enrollments (User Id, CourseId, EnrollmentDate, Status) VALUES (@User Id, @CourseId, GETDATE(), @Status)", connection);
command.Parameters.AddWithValue("@User Id", enrollment.UserId);
command.Parameters.AddWithValue("@CourseId", enrollment.CourseId);
command.Parameters.AddWithValue("@Status", enrollment.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateEnrollment(Enrollment enrollment)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Enrollments SET UserId = @User Id, CourseId = @CourseId, Status = @Status WHERE EnrollmentId = @EnrollmentId", connection);
command.Parameters.AddWithValue("@EnrollmentId", enrollment.EnrollmentId);
command.Parameters.AddWithValue("@User Id", enrollment.UserId);
command.Parameters.AddWithValue("@CourseId", enrollment.CourseId);
command.Parameters.AddWithValue("@Status", enrollment.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteEnrollment(int enrollmentId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Enrollments WHERE EnrollmentId = @EnrollmentId", connection);
command.Parameters.AddWithValue("@EnrollmentId", enrollmentId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Attendance Repository
Interface:
public interface IAttendanceRepository
{
Attendance GetAttendanceById(int attendanceId);
IEnumerable<Attendance> GetAllAttendances();
void AddAttendance(Attendance attendance);
void UpdateAttendance(Attendance attendance);
void DeleteAttendance(int attendanceId);
}
Implementation:
public class AttendanceRepository : IAttendanceRepository
{
private readonly string _connectionString;
public AttendanceRepository(string connectionString)
{
_connectionString = connectionString;
}
public Attendance GetAttendanceById(int attendanceId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Attendance WHERE AttendanceId = @AttendanceId", connection);
command.Parameters.AddWithValue("@AttendanceId", attendanceId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Attendance
{
AttendanceId = (int)reader["AttendanceId"],
EnrollmentId = (int)reader["EnrollmentId"],
ScheduleId = (int)reader["ScheduleId"],
Attended = (bool)reader["Attended"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Attendance> GetAllAttendances()
{
var attendances = new List<Attendance>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Attendance", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
attendances.Add(new Attendance
{
AttendanceId = (int)reader["AttendanceId"],
EnrollmentId = (int)reader["EnrollmentId"],
ScheduleId = (int)reader["ScheduleId"],
Attended = (bool)reader["Attended"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return attendances;
}
public void AddAttendance(Attendance attendance)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Attendance (EnrollmentId, ScheduleId, Attended, CreatedAt) VALUES (@EnrollmentId, @ScheduleId, @Attended, GETDATE())", connection);
command.Parameters.AddWithValue("@EnrollmentId", attendance.EnrollmentId);
command.Parameters.AddWithValue("@ScheduleId", attendance.ScheduleId);
command.Parameters.AddWithValue("@Attended", attendance.Attended);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateAttendance(Attendance attendance)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Attendance SET EnrollmentId = @EnrollmentId, ScheduleId = @ScheduleId, Attended = @Attended WHERE AttendanceId = @AttendanceId", connection);
command.Parameters.AddWithValue("@AttendanceId", attendance.AttendanceId);
command.Parameters.AddWithValue("@EnrollmentId", attendance.EnrollmentId);
command.Parameters.AddWithValue("@ScheduleId", attendance.ScheduleId);
command.Parameters.AddWithValue("@Attended", attendance.Attended);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteAttendance(int attendanceId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Attendance WHERE AttendanceId = @AttendanceId", connection);
command.Parameters.AddWithValue("@AttendanceId", attendanceId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Assessment Repository
Interface:
public interface IAssessmentRepository
{
Assessment GetAssessmentById(int assessmentId);
IEnumerable<Assessment> GetAllAssessments();
void AddAssessment(Assessment assessment);
void UpdateAssessment(Assessment assessment);
void DeleteAssessment(int assessmentId);
}
Implementation:
public class AssessmentRepository : IAssessmentRepository
{
private readonly string _connectionString;
public AssessmentRepository(string connectionString)
{
_connectionString = connectionString;
}
public Assessment GetAssessmentById(int assessmentId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Assessments WHERE AssessmentId = @AssessmentId", connection);
command.Parameters.AddWithValue("@AssessmentId", assessmentId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Assessment
{
AssessmentId = (int)reader["AssessmentId"],
CourseId = (int)reader["CourseId"],
AssessmentType = reader["AssessmentType"].ToString(),
TotalMarks = (int)reader["TotalMarks"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Assessment> GetAllAssessments()
{
var assessments = new List<Assessment>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Assessments", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
assessments.Add(new Assessment
{
AssessmentId = (int)reader["AssessmentId"],
CourseId = (int)reader["CourseId"],
AssessmentType = reader["AssessmentType"].ToString(),
TotalMarks = (int)reader["TotalMarks"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return assessments;
}
public void AddAssessment(Assessment assessment)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Assessments (CourseId, AssessmentType, TotalMarks) VALUES (@CourseId, @AssessmentType, @TotalMarks)", connection);
command.Parameters.AddWithValue("@CourseId", assessment.CourseId);
command.Parameters.AddWithValue("@AssessmentType", assessment.AssessmentType);
command.Parameters.AddWithValue("@TotalMarks", assessment.TotalMarks);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateAssessment(Assessment assessment)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Assessments SET CourseId = @CourseId, AssessmentType = @AssessmentType, TotalMarks = @TotalMarks, UpdatedAt = GETDATE() WHERE AssessmentId = @AssessmentId", connection);
command.Parameters.AddWithValue("@AssessmentId", assessment.AssessmentId);
command.Parameters.AddWithValue("@CourseId", assessment.CourseId);
command.Parameters.AddWithValue("@AssessmentType", assessment.AssessmentType);
command.Parameters.AddWithValue("@TotalMarks", assessment.TotalMarks);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteAssessment(int assessmentId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Assessments WHERE AssessmentId = @AssessmentId", connection);
command.Parameters.AddWithValue("@AssessmentId", assessmentId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Payment Repository
Interface:
public interface IPaymentRepository
{
Payment GetPaymentById(int paymentId);
IEnumerable<Payment> GetAllPayments();
void AddPayment(Payment payment);
void UpdatePayment(Payment payment);
void Delete Payment(int paymentId);
}
Implementation:
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"],
UserId = (int)reader["User Id"],
CourseId = (int)reader["CourseId"],
Amount = (decimal)reader["Amount"],
PaymentDate = (DateTime)reader["PaymentDate"],
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"],
UserId = (int)reader["User Id"],
CourseId = (int)reader["CourseId"],
Amount = (decimal)reader["Amount"],
PaymentDate = (DateTime)reader["PaymentDate"],
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 (User Id, CourseId, Amount, PaymentDate, PaymentMethod, Status) VALUES (@User Id, @CourseId, @Amount, GETDATE(), @PaymentMethod, @Status)", connection);
command.Parameters.AddWithValue("@User Id", payment.UserId);
command.Parameters.AddWithValue("@CourseId", payment.CourseId);
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 UserId = @User Id, CourseId = @CourseId, Amount = @Amount, PaymentMethod = @PaymentMethod, Status = @Status WHERE PaymentId = @PaymentId", connection);
command.Parameters.AddWithValue("@PaymentId", payment.PaymentId);
command.Parameters.AddWithValue("@User Id", payment.UserId);
command.Parameters.AddWithValue("@CourseId", payment.CourseId);
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();
}
}
}
Feedback Repository
Interface:
public interface IFeedbackRepository
{
Feedback GetFeedbackById(int feedbackId);
IEnumerable<Feedback> GetAllFeedbacks();
void AddFeedback(Feedback feedback);
void UpdateFeedback(Feedback feedback);
void DeleteFeedback(int feedbackId);
}
Implementation:
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"],
CourseId = (int)reader["CourseId"],
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"],
CourseId = (int)reader["CourseId"],
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, CourseId, Comments, Rating, CreatedAt) VALUES (@User Id, @CourseId, @Comments, @Rating, GETDATE())", connection);
command.Parameters.AddWithValue("@User Id", feedback.UserId);
command.Parameters.AddWithValue("@CourseId", feedback.CourseId);
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, CourseId = @CourseId, Comments = @Comments, Rating = @Rating WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@FeedbackId", feedback.FeedbackId);
command.Parameters.AddWithValue("@User Id", feedback.UserId);
command.Parameters.AddWithValue("@CourseId", feedback.CourseId);
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();
}
}
}
Report Repository
Interface:
public interface IReportRepository
{
Report GetReportById(int reportId);
IEnumerable<Report> GetAllReports();
void AddReport(Report report);
void UpdateReport(Report report);
void DeleteReport(int reportId);
}
Implementation:
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"],
UserId = (int)reader["User Id"],
CourseId = (int)reader["CourseId"],
ReportDate = (DateTime)reader["ReportDate"],
Description = reader["Description"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
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"],
UserId = (int)reader["User Id"],
CourseId = (int)reader["CourseId"],
ReportDate = (DateTime)reader["ReportDate"],
Description = reader["Description"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return reports;
}
public void AddReport(Report report)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Reports (User Id, CourseId, ReportDate, Description, CreatedAt) VALUES (@User Id, @CourseId, GETDATE(), @Description, GETDATE())", connection);
command.Parameters.AddWithValue("@User Id", report.UserId);
command.Parameters.AddWithValue("@CourseId", report.CourseId);
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 UserId = @User Id, CourseId = @CourseId, Description = @Description WHERE ReportId = @ReportId", connection);
command.Parameters.AddWithValue("@ReportId", report.ReportId);
command.Parameters.AddWithValue("@User Id", report.UserId);
command.Parameters.AddWithValue("@CourseId", report.CourseId);
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();
}
}
}
Resource Repository
Interface:
public interface IResourceRepository
{
Resource GetResourceById(int resourceId);
IEnumerable<Resource> GetAllResources();
void AddResource(Resource resource);
void UpdateResource(Resource resource);
void DeleteResource(int resourceId);
}
Implementation:
public class ResourceRepository : IResourceRepository
{
private readonly string _connectionString;
public ResourceRepository(string connectionString)
{
_connectionString = connectionString;
}
public Resource GetResourceById(int resourceId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Resources WHERE ResourceId = @ResourceId", connection);
command.Parameters.AddWithValue("@ResourceId", resourceId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Resource
{
ResourceId = (int)reader["ResourceId"],
CourseId = (int)reader["CourseId"],
ResourceType = reader["ResourceType"].ToString(),
ResourceUrl = reader["ResourceUrl"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Resource> GetAllResources()
{
var resources = new List<Resource>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Resources", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
resources.Add(new Resource
{
ResourceId = (int)reader["ResourceId"],
CourseId = (int)reader["CourseId"],
ResourceType = reader["ResourceType"].ToString(),
ResourceUrl = reader["ResourceUrl"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return resources;
}
public void AddResource(Resource resource)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Resources (CourseId, ResourceType, ResourceUrl) VALUES (@CourseId, @ResourceType, @ResourceUrl)", connection);
command.Parameters.AddWithValue("@CourseId", resource.CourseId);
command.Parameters.AddWithValue("@ResourceType", resource.ResourceType);
command.Parameters.AddWithValue("@ResourceUrl", resource.ResourceUrl);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateResource(Resource resource)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Resources SET CourseId = @CourseId, ResourceType = @ResourceType, ResourceUrl = @ResourceUrl, UpdatedAt = GETDATE() WHERE ResourceId = @ResourceId", connection);
command.Parameters.AddWithValue("@ResourceId", resource.ResourceId);
command.Parameters.AddWithValue("@CourseId", resource.CourseId);
command.Parameters.AddWithValue("@ResourceType", resource.ResourceType);
command.Parameters.AddWithValue("@ResourceUrl", resource.ResourceUrl);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteResource(int resourceId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Resources WHERE ResourceId = @ResourceId", connection);
command.Parameters.AddWithValue("@ResourceId", resourceId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Notification Repository
Interface:
public interface INotificationRepository
{
Notification GetNotificationById(int notificationId);
IEnumerable<Notification> GetAllNotifications();
void AddNotification(Notification notification);
void UpdateNotification(Notification notification);
void DeleteNotification(int notificationId);
}
Implementation:
public class NotificationRepository : INotificationRepository
{
private readonly string _connectionString;
public NotificationRepository(string connectionString)
{
_connectionString = connectionString;
}
public Notification GetNotificationById(int notificationId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Notifications WHERE NotificationId = @NotificationId", connection);
command.Parameters.AddWithValue("@NotificationId", notificationId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Notification
{
NotificationId = (int)reader["NotificationId"],
UserId = (int)reader["User Id"],
Message = reader["Message"].ToString(),
IsRead = (bool)reader["IsRead"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Notification> GetAllNotifications()
{
var notifications = new List<Notification>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Notifications", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
notifications.Add(new Notification
{
NotificationId = (int)reader["NotificationId"],
UserId = (int)reader["User Id"],
Message = reader["Message"].ToString(),
IsRead = (bool)reader["IsRead"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return notifications;
}
public void AddNotification(Notification notification)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Notifications (User Id, Message, IsRead) VALUES (@User Id, @Message, @IsRead)", connection);
command.Parameters.AddWithValue("@User Id", notification.UserId);
command.Parameters.AddWithValue("@Message", notification.Message);
command.Parameters.AddWithValue("@IsRead", notification.IsRead);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateNotification(Notification notification)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Notifications SET UserId = @User Id, Message = @Message, IsRead = @IsRead WHERE NotificationId = @NotificationId", connection);
command.Parameters.AddWithValue("@NotificationId", notification.NotificationId);
command.Parameters.AddWithValue("@User Id", notification.UserId);
command.Parameters.AddWithValue("@Message", notification.Message);
command.Parameters.AddWithValue("@IsRead", notification.IsRead);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteNotification(int notificationId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Notifications WHERE NotificationId = @NotificationId", connection);
command.Parameters.AddWithValue("@NotificationId", notificationId);
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, allowing for easy data access and manipulation using ADO.NET in your ASP.NET application.
Creating Controllers
To create controllers for each repository in an ASP.NET MVC application, we will follow the standard MVC pattern. Each controller will handle HTTP requests, interact with the corresponding repository, and return views or data as needed.
Example Controllers
1. 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));
}
}
2. RoleController
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));
}
}
3. CourseController
public class CourseController : Controller
{
private readonly ICourseRepository _courseRepository;
public CourseController(ICourseRepository courseRepository)
{
_courseRepository = courseRepository;
}
public IActionResult Index()
{
var courses = _courseRepository.GetAllCourses();
return View(courses);
}
public IActionResult Details(int id)
{
var course = _courseRepository.GetCourseById(id);
return View(course);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Course course)
{
if (ModelState.IsValid)
{
_courseRepository.AddCourse(course);
return RedirectToAction(nameof(Index));
}
return View(course);
}
public IActionResult Edit(int id)
{
var course = _courseRepository.GetCourseById(id);
return View(course);
}
[HttpPost]
public IActionResult Edit(Course course)
{
if (ModelState.IsValid)
{
_courseRepository.UpdateCourse(course);
return RedirectToAction(nameof(Index));
}
return View(course);
}
public IActionResult Delete(int id)
{
var course = _courseRepository.GetCourseById(id);
return View(course);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_courseRepository.DeleteCourse(id);
return RedirectToAction(nameof(Index));
}
}
4. SyllabusController
public class SyllabusController : Controller
{
private readonly ISyllabusRepository _syllabusRepository;
public SyllabusController(ISyllabusRepository syllabusRepository)
{
_syllabusRepository = syllabusRepository;
}
public IActionResult Index()
{
var syllabuses = _syllabusRepository.GetAllSyllabuses();
return View(syllabuses);
}
public IActionResult Details(int id)
{
var syllabus = _syllabusRepository.GetSyllabusById(id);
return View(syllabus);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Syllabus syllabus)
{
if (ModelState.IsValid)
{
_syllabusRepository.AddSyllabus(syllabus);
return RedirectToAction(nameof(Index));
}
return View(syllabus);
}
public IActionResult Edit(int id)
{
var syllabus = _syllabusRepository.GetSyllabusById(id);
return View(syllabus);
}
[HttpPost]
public IActionResult Edit(Syllabus syllabus)
{
if (ModelState.IsValid)
{
_syllabusRepository.UpdateSyllabus(syllabus);
return RedirectToAction(nameof(Index));
}
return View(syllabus);
}
public IActionResult Delete(int id)
{
var syllabus = _syllabusRepository.GetSyllabusById(id);
return View(syllabus);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_syllabusRepository.DeleteSyllabus(id);
return RedirectToAction(nameof(Index));
}
}
5. ScheduleController
public class ScheduleController : Controller
{
private readonly IScheduleRepository _scheduleRepository;
public ScheduleController(IScheduleRepository scheduleRepository)
{
_scheduleRepository = scheduleRepository;
}
public IActionResult Index()
{
var schedules = _scheduleRepository.GetAllSchedules();
return View(schedules);
}
public IActionResult Details(int id)
{
var schedule = _scheduleRepository.GetScheduleById(id);
return View(schedule);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Schedule schedule)
{
if (ModelState.IsValid)
{
_scheduleRepository.AddSchedule(schedule);
return RedirectToAction(nameof(Index));
}
return View(schedule);
}
public IActionResult Edit(int id)
{
var schedule = _scheduleRepository.GetScheduleById(id);
return View(schedule);
}
[HttpPost]
public IActionResult Edit(Schedule schedule)
{
if (ModelState.IsValid)
{
_scheduleRepository.UpdateSchedule(schedule);
return RedirectToAction(nameof(Index));
}
return View(schedule);
}
public IActionResult Delete(int id)
{
var schedule = _scheduleRepository.GetScheduleById(id);
return View(schedule);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_scheduleRepository.DeleteSchedule(id);
return RedirectToAction(nameof(Index));
}
}
6. EnrollmentController
public class EnrollmentController : Controller
{
private readonly IEnrollmentRepository _enrollmentRepository;
public EnrollmentController(IEnrollmentRepository enrollmentRepository)
{
_enrollmentRepository = enrollmentRepository;
}
public IActionResult Index()
{
var enrollments = _enrollmentRepository.GetAllEnrollments();
return View(enrollments);
}
public IActionResult Details(int id)
{
var enrollment = _enrollmentRepository.GetEnrollmentById(id);
return View(enrollment);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Enrollment enrollment)
{
if (ModelState.IsValid)
{
_enrollmentRepository.AddEnrollment(enrollment);
return RedirectToAction(nameof(Index));
}
return View(enrollment);
}
public IActionResult Edit(int id)
{
var enrollment = _enrollmentRepository.GetEnrollmentById(id);
return View(enrollment);
}
[HttpPost]
public IActionResult Edit(Enrollment enrollment)
{
if (ModelState.IsValid)
{
_enrollmentRepository.UpdateEnrollment(enrollment);
return RedirectToAction(nameof(Index));
}
return View(enrollment);
}
public IActionResult Delete(int id)
{
var enrollment = _enrollmentRepository.GetEnrollmentById(id);
return View(enrollment);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_enrollmentRepository.DeleteEnrollment(id);
return RedirectToAction(nameof(Index));
}
}
7. AttendanceController
public class AttendanceController : Controller
{
private readonly IAttendanceRepository _attendanceRepository;
public AttendanceController(IAttendanceRepository attendanceRepository)
{
_attendanceRepository = attendanceRepository;
}
public IActionResult Index()
{
var attendances = _attendanceRepository.GetAllAttendances();
return View(attendances);
}
public IActionResult Details(int id)
{
var attendance = _attendanceRepository.GetAttendanceById(id);
return View(attendance);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Attendance attendance)
{
if (ModelState.IsValid)
{
_attendanceRepository.AddAttendance(attendance);
return RedirectToAction(nameof(Index));
}
return View(attendance);
}
public IActionResult Edit(int id)
{
var attendance = _attendanceRepository.GetAttendanceById(id);
return View(attendance);
}
[HttpPost]
public IActionResult Edit(Attendance attendance)
{
if (ModelState.IsValid)
{
_attendanceRepository.UpdateAttendance(attendance);
return RedirectToAction(nameof(Index));
}
return View(attendance);
}
public IActionResult Delete(int id)
{
var attendance = _attendanceRepository.GetAttendanceById(id);
return View(attendance);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_attendanceRepository.DeleteAttendance(id);
return RedirectToAction(nameof(Index));
}
}
8. AssessmentController
public class AssessmentController : Controller
{
private readonly IAssessmentRepository _assessmentRepository;
public AssessmentController(IAssessmentRepository assessmentRepository)
{
_assessmentRepository = assessmentRepository;
}
public IActionResult Index()
{
var assessments = _assessmentRepository.GetAllAssessments();
return View(assessments);
}
public IActionResult Details(int id)
{
var assessment = _assessmentRepository.GetAssessmentById(id);
return View(assessment);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Assessment assessment)
{
if (ModelState.IsValid)
{
_assessmentRepository.AddAssessment(assessment);
return RedirectToAction(nameof(Index));
}
return View(assessment);
}
public IActionResult Edit(int id)
{
var assessment = _assessmentRepository.GetAssessmentById(id);
return View(assessment);
}
[HttpPost]
public IActionResult Edit(Assessment assessment)
{
if (ModelState.IsValid)
{
_assessmentRepository.UpdateAssessment(assessment);
return RedirectToAction(nameof(Index));
}
return View(assessment);
}
public IActionResult Delete(int id)
{
var assessment = _assessmentRepository.GetAssessmentById(id);
return View(assessment);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_assessmentRepository.DeleteAssessment(id);
return RedirectToAction(nameof(Index));
}
}
9. PaymentController
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));
}
}
10. FeedbackController
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));
}
}
11. ReportController
public class ReportController : Controller
{
private readonly IReportRepository _reportRepository;
public ReportController(IReportRepository reportRepository)
{
_report Repository = 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));
}
}
12. ResourceController
public class ResourceController : Controller
{
private readonly IResourceRepository _resourceRepository;
public ResourceController(IResourceRepository resourceRepository)
{
_resourceRepository = resourceRepository;
}
public IActionResult Index()
{
var resources = _resourceRepository.GetAllResources();
return View(resources);
}
public IActionResult Details(int id)
{
var resource = _resourceRepository.GetResourceById(id);
return View(resource);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Resource resource)
{
if (ModelState.IsValid)
{
_resourceRepository.AddResource(resource);
return RedirectToAction(nameof(Index));
}
return View(resource);
}
public IActionResult Edit(int id)
{
var resource = _resourceRepository.GetResourceById(id);
return View(resource);
}
[HttpPost]
public IActionResult Edit(Resource resource)
{
if (ModelState.IsValid)
{
_resourceRepository.UpdateResource(resource);
return RedirectToAction(nameof(Index));
}
return View(resource);
}
public IActionResult Delete(int id)
{
var resource = _resourceRepository.GetResourceById(id);
return View(resource);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_resourceRepository.DeleteResource(id);
return RedirectToAction(nameof(Index));
}
}
13. NotificationController
public class NotificationController : Controller
{
private readonly INotificationRepository _notificationRepository;
public NotificationController(INotificationRepository notificationRepository)
{
_notificationRepository = notificationRepository;
}
public IActionResult Index()
{
var notifications = _notificationRepository.GetAllNotifications();
return View(notifications);
}
public IActionResult Details(int id)
{
var notification = _notificationRepository.GetNotificationById(id);
return View(notification);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Notification notification)
{
if (ModelState.IsValid)
{
_notificationRepository.AddNotification(notification);
return RedirectToAction(nameof(Index));
}
return View(notification);
}
public IActionResult Edit(int id)
{
var notification = _notificationRepository.GetNotificationById(id);
return View(notification);
}
[HttpPost]
public IActionResult Edit(Notification notification)
{
if (ModelState.IsValid)
{
_notificationRepository.UpdateNotification(notification);
return RedirectToAction(nameof(Index));
}
return View(notification);
}
public IActionResult Delete(int id)
{
var notification = _notificationRepository.GetNotificationById(id);
return View(notification);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_notificationRepository.DeleteNotification(id);
return RedirectToAction(nameof(Index));
}
}
This completes the controller implementations for all the repositories. Each controller provides the necessary actions to manage the corresponding entities, allowing for a complete CRUD interface in your ASP.NET MVC application.
Creating Views
Creating view files for each controller in an ASP.NET MVC application involves creating Razor view files that correspond to the actions in each controller. Below, I will provide a basic structure for the views associated with each controller, including the necessary files for Index, Details, Create, Edit, and Delete actions.
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>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var user in Model)
{
<tr>
<td>@user.Username</td>
<td>@user.Email</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>Role ID: @Model.RoleId</p>
<a asp-action="Edit" asp-route-id="@Model.UserId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
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>
<a asp-action="Index">Cancel</a>
</form>
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>
<a asp-action="Index">Cancel</a>
</form>
Views/User/Delete.cshtml
@model User
<h2>Delete User</h2>
<div>
<h4>Are you sure you want to delete this user?</h4>
<div>
<h4>@Model.Username</h4>
<p>Email: @Model.Email</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="User Id" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
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>
<a asp-action="Edit" asp-route-id="@Model.RoleId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
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>
<a asp-action="Index">Cancel</a>
</form>
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>
<a asp-action="Index">Cancel</a>
</form>
Views/Role/Delete.cshtml
@model Role
<h2>Delete Role</h2>
<div>
<h4>Are you sure you want to delete this role?</h4>
<div>
<h4>@Model.RoleName</h4>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="RoleId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
Course Views
Views/Course/Index.cshtml
@model IEnumerable<Course>
<h2>Courses</h2>
<a asp-action="Create">Create New Course</a>
<table>
<thead>
<tr>
<th>Course Name</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var course in Model)
{
<tr>
<td>@course.CourseName</td>
<td>
<a asp-action="Details" asp-route-id="@course.CourseId">Details</a> |
<a asp-action="Edit" asp-route-id="@course.CourseId">Edit</a> |
<a asp-action="Delete" asp-route-id="@course.CourseId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Course/Details.cshtml
@model Course
<h2>Course Details</h2>
<div>
<h4>@Model.CourseName</h4>
<p>Description: @Model.Description</p>
<a asp-action="Edit" asp-route-id="@Model.CourseId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Course/Create.cshtml
@model Course
<h2>Create Course</h2>
<form asp-action="Create">
<div>
<label asp-for="CourseName"></label>
<input asp-for="CourseName" />
<span asp-validation-for="CourseName"></span>
</div>
<div>
<label asp-for="Description"></label>
<textarea asp-for="Description"></textarea>
<span asp-validation-for="Description"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Course/Edit.cshtml
@model Course
<h2>Edit Course</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="CourseId" />
<div>
<label asp-for="CourseName"></label>
<input asp-for="CourseName" />
<span asp-validation-for="CourseName"></span>
</div>
<div>
<label asp-for="Description"></label>
<textarea asp-for="Description"></textarea>
<span asp-validation-for="Description"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Course/Delete.cshtml
@model Course
<h2>Delete Course</h2>
<div>
<h4>Are you sure you want to delete this course?</h4>
<div>
<h4>@Model.CourseName</h4>
<p>Description: @Model.Description</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="CourseId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
Syllabus Views
Views/Syllabus/Index.cshtml
@model IEnumerable<Syllabus>
<h2>Syllabuses</h2>
<a asp-action="Create">Create New Syllabus</a>
<table>
<thead>
<tr>
<th>Syllabus Title</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var syllabus in Model)
{
<tr>
<td>@syllabus.Title</td>
<td>
<a asp-action="Details" asp-route-id="@syllabus.SyllabusId">Details</a> |
<a asp-action="Edit" asp-route-id="@syllabus.SyllabusId">Edit</a> | <a asp-action="Delete" asp-route-id="@syllabus.SyllabusId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Syllabus/Details.cshtml
@model Syllabus
<h2>Syllabus Details</h2>
<div>
<h4>@Model.Title</h4>
<p>Description: @Model.Description</p>
<a asp-action="Edit" asp-route-id="@Model.SyllabusId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Syllabus/Create.cshtml
@model Syllabus
<h2>Create Syllabus</h2>
<form asp-action="Create">
<div>
<label asp-for="Title"></label>
<input asp-for="Title" />
<span asp-validation-for="Title"></span>
</div>
<div>
<label asp-for="Description"></label>
<textarea asp-for="Description"></textarea>
<span asp-validation-for="Description"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Syllabus/Edit.cshtml
@model Syllabus
<h2>Edit Syllabus</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="SyllabusId" />
<div>
<label asp-for="Title"></label>
<input asp-for="Title" />
<span asp-validation-for="Title"></span>
</div>
<div>
<label asp-for="Description"></label>
<textarea asp-for="Description"></textarea>
<span asp-validation-for="Description"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Syllabus/Delete.cshtml
@model Syllabus
<h2>Delete Syllabus</h2>
<div>
<h4>Are you sure you want to delete this syllabus?</h4>
<div>
<h4>@Model.Title</h4>
<p>Description: @Model.Description</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="SyllabusId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
Creating More Views
Below are the view files for the remaining controllers: Schedule, Enrollment, Attendance, Assessment, Payment, Feedback, Report, Resource, and Notification. Each set of views will include the necessary files for Index, Details, Create, Edit, and Delete actions.
Schedule Views
Views/Schedule/Index.cshtml
@model IEnumerable<Schedule>
<h2>Schedules</h2>
<a asp-action="Create">Create New Schedule</a>
<table>
<thead>
<tr>
<th>Course ID</th>
<th>Start Date</th>
<th>End Date</th>
<th>Location</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var schedule in Model)
{
<tr>
<td>@schedule.CourseId</td>
<td>@schedule.StartDate.ToShortDateString()</td>
<td>@schedule.EndDate.ToShortDateString()</td>
<td>@schedule.Location</td>
<td>
<a asp-action="Details" asp-route-id="@schedule.ScheduleId">Details</a> |
<a asp-action="Edit" asp-route-id="@schedule.ScheduleId">Edit</a> |
<a asp-action="Delete" asp-route-id="@schedule.ScheduleId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Schedule/Details.cshtml
@model Schedule
<h2>Schedule Details</h2>
<div>
<h4>Course ID: @Model.CourseId</h4>
<p>Start Date: @Model.StartDate.ToShortDateString()</p>
<p>End Date: @Model.EndDate.ToShortDateString()</p>
<p>Location: @Model.Location</p>
<a asp-action="Edit" asp-route-id="@Model.ScheduleId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Schedule/Create.cshtml
@model Schedule
<h2>Create Schedule</h2>
<form asp-action="Create">
<div>
<label asp-for="CourseId"></label>
<input asp-for="CourseId" />
<span asp-validation-for="CourseId"></span>
</div>
<div>
<label asp-for="StartDate"></label>
<input asp-for="StartDate" type="date" />
<span asp-validation-for="StartDate"></span>
</div>
<div>
<label asp-for="EndDate"></label>
<input asp-for="EndDate" type="date" />
<span asp-validation-for="EndDate"></span>
</div>
<div>
<label asp-for="Location"></label>
<input asp-for="Location" />
<span asp-validation-for="Location"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Schedule/Edit.cshtml
@model Schedule
<h2>Edit Schedule</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="ScheduleId" />
<div>
<label asp-for="CourseId"></label>
<input asp-for="CourseId" />
<span asp-validation-for="CourseId"></span>
</div>
<div>
<label asp-for="StartDate"></label>
<input asp-for="StartDate" type="date" />
<span asp-validation-for="StartDate"></span>
</div>
<div>
<label asp-for="EndDate"></label>
<input asp-for="EndDate" type="date" />
<span asp-validation-for="EndDate"></span>
</div>
<div>
<label asp-for="Location"></label>
<input asp-for="Location" />
<span asp-validation-for="Location"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Schedule/Delete.cshtml
@model Schedule
<h2>Delete Schedule</h2>
<div>
<h4>Are you sure you want to delete this schedule?</h4>
<div>
<h4>Course ID: @Model.CourseId</h4>
<p>Start Date: @Model.StartDate.ToShortDateString()</p>
<p>End Date: @Model.EndDate.ToShortDateString()</p>
<p>Location: @Model.Location</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="ScheduleId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
Enrollment Views
Views/Enrollment/Index.cshtml
@model IEnumerable<Enrollment>
<h2>Enrollments</h2>
<a asp-action="Create">Create New Enrollment</a>
<table>
<thead>
<tr>
<th>User ID</th>
<th>Course ID</th>
<th>Enrollment Date</th>
<th>Status</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var enrollment in Model)
{
<tr>
<td>@enrollment.UserId</td>
<td>@enrollment.CourseId</td>
<td>@enrollment.EnrollmentDate.ToShortDateString()</td>
<td>@enrollment.Status</td>
<td>
<a asp-action="Details" asp-route-id="@enrollment.EnrollmentId">Details</a> |
<a asp-action="Edit" asp-route-id="@enrollment.EnrollmentId">Edit</a> |
<a asp-action="Delete" asp-route-id="@enrollment.EnrollmentId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Enrollment/Details.cshtml
@model Enrollment
<h2>Enrollment Details</h2>
<div>
<h4>User ID: @Model.UserId</h4>
<p>Course ID: @Model.CourseId</p>
<p>Enrollment Date: @Model.EnrollmentDate.ToShortDateString()</p>
< p>Status: @Model.Status</p>
<a asp-action="Edit" asp-route-id="@Model.EnrollmentId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Enrollment/Create.cshtml
@model Enrollment
<h2>Create Enrollment</h2>
<form asp-action="Create">
<div>
<label asp-for="User Id"></label>
<input asp-for="User Id" />
<span asp-validation-for="User Id"></span>
</div>
<div>
<label asp-for="CourseId"></label>
<input asp-for="CourseId" />
<span asp-validation-for="CourseId"></span>
</div>
<div>
<label asp-for="EnrollmentDate"></label>
<input asp-for="EnrollmentDate" type="date" />
<span asp-validation-for="EnrollmentDate"></span>
</div>
<div>
<label asp-for="Status"></label>
<input asp-for="Status" />
<span asp-validation-for="Status"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Enrollment/Edit.cshtml
@model Enrollment
<h2>Edit Enrollment</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="EnrollmentId" />
<div>
<label asp-for="User Id"></label>
<input asp-for="User Id" />
<span asp-validation-for="User Id"></span>
</div>
<div>
<label asp-for="CourseId"></label>
<input asp-for="CourseId" />
<span asp-validation-for="CourseId"></span>
</div>
<div>
<label asp-for="EnrollmentDate"></label>
<input asp-for="EnrollmentDate" type="date" />
<span asp-validation-for="EnrollmentDate"></span>
</div>
<div>
<label asp-for="Status"></label>
<input asp-for="Status" />
<span asp-validation-for="Status"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Enrollment/Delete.cshtml
@model Enrollment
<h2>Delete Enrollment</h2>
<div>
<h4>Are you sure you want to delete this enrollment?</h4>
<div>
<h4>User ID: @Model.UserId</h4>
<p>Course ID: @Model.CourseId</p>
<p>Enrollment Date: @Model.EnrollmentDate.ToShortDateString()</p>
<p>Status: @Model.Status</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="EnrollmentId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
Attendance Views
Views/Attendance/Index.cshtml
@model IEnumerable<Attendance>
<h2>Attendance Records</h2>
<a asp-action="Create">Create New Attendance Record</a>
<table>
<thead>
<tr>
<th>User ID</th>
<th>Course ID</th>
<th>Date</th>
<th>Status</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var attendance in Model)
{
<tr>
<td>@attendance.UserId</td>
<td>@attendance.CourseId</td>
<td>@attendance.Date.ToShortDateString()</td>
<td>@attendance.Status</td>
<td>
<a asp-action="Details" asp-route-id="@attendance.AttendanceId">Details</a> |
<a asp-action="Edit" asp-route-id="@attendance.AttendanceId">Edit</a> |
<a asp-action="Delete" asp-route-id="@attendance.AttendanceId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Attendance/Details.cshtml
@model Attendance
<h2>Attendance Details</h2>
<div>
<h4>User ID: @Model.UserId</h4>
<p>Course ID: @Model.CourseId</p>
<p>Date: @Model.Date.ToShortDateString()</p>
<p>Status: @Model.Status</p>
<a asp-action="Edit" asp-route-id="@Model.AttendanceId ">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Attendance/Create.cshtml
@model Attendance
<h2>Create Attendance Record</h2>
<form asp-action="Create">
<div>
<label asp-for="User Id"></label>
<input asp-for="User Id" />
<span asp-validation-for="User Id"></span>
</div>
<div>
<label asp-for="CourseId"></label>
<input asp-for="CourseId" />
<span asp-validation-for="CourseId"></span>
</div>
<div>
<label asp-for="Date"></label>
<input asp-for="Date" type="date" />
<span asp-validation-for="Date"></span>
</div>
<div>
<label asp-for="Status"></label>
<input asp-for="Status" />
<span asp-validation-for="Status"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Attendance/Edit.cshtml
@model Attendance
<h2>Edit Attendance Record</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="AttendanceId" />
<div>
<label asp-for="User Id"></label>
<input asp-for="User Id" />
<span asp-validation-for="User Id"></span>
</div>
<div>
<label asp-for="CourseId"></label>
<input asp-for="CourseId" />
<span asp-validation-for="CourseId"></span>
</div>
<div>
<label asp-for="Date"></label>
<input asp-for="Date" type="date" />
<span asp-validation-for="Date"></span>
</div>
<div>
<label asp-for="Status"></label>
<input asp-for="Status" />
<span asp-validation-for="Status"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Attendance/Delete.cshtml
@model Attendance
<h2>Delete Attendance Record</h2>
<div>
<h4>Are you sure you want to delete this attendance record?</h4>
<div>
<h4>User ID: @Model.UserId</h4>
<p>Course ID: @Model.CourseId</p>
<p>Date: @Model.Date.ToShortDateString()</p>
<p>Status: @Model.Status</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="AttendanceId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
Assessment Views
Views/Assessment/Index.cshtml
@model IEnumerable<Assessment>
<h2>Assessments</h2>
<a asp-action="Create">Create New Assessment</a>
<table>
<thead>
<tr>
<th>Course ID</th>
<th>Title</th>
<th>Due Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var assessment in Model)
{
<tr>
<td>@assessment.CourseId</td>
<td>@assessment.Title</td>
<td>@assessment.DueDate.ToShortDateString()</td>
<td>
<a asp-action="Details" asp-route-id="@assessment.AssessmentId">Details</a> |
<a asp-action="Edit" asp-route-id="@assessment.AssessmentId">Edit</a> |
<a asp-action="Delete" asp-route-id="@assessment.AssessmentId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Assessment/Details.cshtml
@model Assessment
<h2>Assessment Details</h2>
<div>
<h4>Course ID: @Model.CourseId</h4>
<p>Title: @Model.Title</p>
<p>Due Date: @Model.DueDate.ToShortDateString()</p>
<a asp-action="Edit" asp-route-id="@Model.AssessmentId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Assessment/Create.cshtml
@model Assessment
<h2>Create Assessment</h2>
<form asp-action="Create ">
<div>
<label asp-for="CourseId"></label>
<input asp-for="CourseId" />
<span asp-validation-for="CourseId"></span>
</div>
<div>
<label asp-for="Title"></label>
<input asp-for="Title" />
<span asp-validation-for="Title"></span>
</div>
<div>
<label asp-for="DueDate"></label>
<input asp-for="DueDate" type="date" />
<span asp-validation-for="DueDate"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Assessment/Edit.cshtml
@model Assessment
<h2>Edit Assessment</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="AssessmentId" />
<div>
<label asp-for="CourseId"></label>
<input asp-for="CourseId" />
<span asp-validation-for="CourseId"></span>
</div>
<div>
<label asp-for="Title"></label>
<input asp-for="Title" />
<span asp-validation-for="Title"></span>
</div>
<div>
<label asp-for="DueDate"></label>
<input asp-for="DueDate" type="date" />
<span asp-validation-for="DueDate"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Assessment/Delete.cshtml
@model Assessment
<h2>Delete Assessment</h2>
<div>
<h4>Are you sure you want to delete this assessment?</h4>
<div>
<h4>Course ID: @Model.CourseId</h4>
<p>Title: @Model.Title</p>
<p>Due Date: @Model.DueDate.ToShortDateString()</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="AssessmentId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
Payment Views
Views/Payment/Index.cshtml
@model IEnumerable<Payment>
<h2>Payments</h2>
<a asp-action="Create">Create New Payment</a>
<table>
<thead>
<tr>
<th>User ID</th>
<th>Amount</th>
<th>Date</th>
<th>Status</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var payment in Model)
{
<tr>
<td>@payment.UserId</td>
<td>@payment.Amount</td>
<td>@payment.Date.ToShortDateString()</td>
<td>@payment.Status</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>User ID: @Model.UserId</h4>
<p>Amount: @Model.Amount</p>
<p>Date: @Model.Date.ToShortDateString()</p>
<p>Status: @Model.Status</p>
<a asp-action="Edit" asp-route-id="@Model.PaymentId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Payment/Create.cshtml
@model Payment
<h2>Create Payment</h2>
<form asp-action="Create">
<div>
<label asp-for="User Id"></label>
<input asp-for="User Id" />
<span asp-validation-for="User Id"></span>
</div>
<div>
<label asp-for="Amount"></label>
<input asp-for="Amount" />
<span asp-validation-for="Amount"></span>
</div>
<div>
<label asp-for="Date"></label>
<input asp-for="Date" type="date" />
<span asp-validation-for="Date"></span>
</div>
<div>
<label asp-for="Status"></label>
<input asp-for="Status" />
<span asp-validation-for="Status"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Payment/Edit.cshtml
@model Payment
<h2>Edit Payment</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="PaymentId" />
<div>
<label asp-for="User Id"></label>
<input asp-for="User Id" />
<span asp-validation-for="User Id"></span>
</div>
<div>
<label asp-for="Amount"></label>
<input asp-for="Amount" />
<span asp-validation-for="Amount"></span>
</div>
<div>
<label asp-for="Date"></label>
<input asp-for="Date" type="date" />
<span asp-validation-for="Date"></span>
</div>
<div>
<label asp-for="Status"></label>
<input asp-for="Status" />
<span asp-validation-for="Status"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Payment/Delete.cshtml
@model Payment
<h2>Delete Payment</h2>
<div>
<h4>Are you sure you want to delete this payment?</h4>
<div>
<h4>User ID: @Model.UserId</h4>
<p>Amount: @Model.Amount</p>
<p>Date: @Model.Date.ToShortDateString()</p>
<p>Status: @Model.Status</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="PaymentId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
Feedback Views
Views/Feedback/Index.cshtml
@model IEnumerable<Feedback>
<h2>Feedbacks</h2>
<a asp-action="Create">Create New Feedback</a>
<table>
<thead>
<tr>
<th>User ID</th>
<th>Course ID</th>
<th>Comments</th>
<th>Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var feedback in Model)
{
<tr>
<td>@feedback.UserId</td>
<td>@feedback.CourseId</td>
<td>@feedback.Comments</td>
<td>@feedback.Date.ToShortDateString()</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>User ID: @Model.UserId</h4>
<p>Course ID: @Model.CourseId</p>
<p>Comments: @Model.Comments</p>
<p>Date: @Model.Date.ToShortDateString()</p>
<a asp-action="Edit" asp-route-id="@Model.FeedbackId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Feedback/Create.cshtml
@model Feedback
<h2>Create Feedback</h2>
<form asp-action="Create">
<div>
<label asp-for="User Id"></label>
<input asp-for="User Id" />
<span asp-validation-for="User Id"></span>
</div>
<div>
<label asp-for="CourseId"></label>
<input asp-for="CourseId" />
<span asp-validation-for="CourseId"></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>
<a asp-action="Index">Cancel</a>
</form>
Views/Feedback/Edit.cshtml
@model Feedback
<h2>Edit Feedback</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="FeedbackId" />
<div>
<label asp-for="User Id"></label>
<input asp-for="User Id" />
<span asp-validation-for="User Id"></span>
</div>
<div>
<label asp-for="CourseId"></label>
<input asp-for="CourseId" />
<span asp-validation-for="CourseId"></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>
<a asp-action="Index">Cancel</a>
</form>
Views/Feedback/Delete.cshtml
@model Feedback
<h2>Delete Feedback</h2>
<div>
<h4>Are you sure you want to delete this feedback?</h4>
<div>
<h4>User ID: @Model.UserId</h4>
<p>Course ID: @Model.CourseId</p>
<p>Comments: @Model.Comments</p>
<p>Date: @Model.Date.ToShortDateString()</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="FeedbackId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
Report Views
Views/Report/Index.cshtml
@model IEnumerable<Report>
<h2>Reports</h2>
<a asp-action="Create">Create New Report</a>
<table>
<thead>
<tr>
<th>Title</th>
<th>Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var report in Model)
{
<tr>
<td>@report.Title</td>
<td>@report.Date.ToShortDateString()</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>@Model.Title</h4>
<p>Date: @Model.Date.ToShortDateString()</p>
<p>Content: @Model.Content</p>
<a asp-action="Edit" asp-route-id="@Model.ReportId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Report/Create.cshtml
@model Report
<h2>Create Report</h2>
<form asp-action="Create">
<div>
<label asp-for="Title"></label>
<input asp-for="Title" />
<span asp-validation-for="Title"></span>
</div>
<div>
<label asp-for="Content"></label>
<textarea asp-for="Content"></textarea>
<span asp-validation-for="Content"></span>
</div>
<div>
<label asp-for="Date"></label>
<input asp-for="Date" type="date" />
<span asp-validation-for="Date"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Report/Edit.cshtml
@model Report
<h2>Edit Report</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="ReportId" />
<div>
<label asp-for="Title"></label>
<input asp-for="Title" />
<span asp-validation-for="Title"></span>
</div>
<div>
<label asp-for="Content"></label>
<textarea asp-for="Content"></textarea>
<span asp-validation-for="Content"></span>
</div>
<div>
<label asp-for="Date"></label>
<input asp-for="Date" type="date" />
<span asp-validation-for="Date"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Report/Delete.cshtml
@model Report
<h2>Delete Report</h2>
<div>
<h4>Are you sure you want to delete this report?</h4>
<div>
<h4>@Model.Title</h4>
<p>Date: @Model.Date.ToShortDateString()</p>
<p>Content: @Model.Content</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="ReportId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
Resource Views
Views/Resource/Index.cshtml
@model IEnumerable<Resource>
<h2>Resources</h2>
<a asp-action="Create">Create New Resource</a>
<table>
<thead>
<tr>
<th>Title</th>
<th>Type</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var resource in Model)
{
<tr>
<td>@resource.Title</td>
<td>@resource.Type</td>
<td>
<a asp-action="Details" asp-route-id="@resource.ResourceId">Details</a> |
<a asp-action="Edit" asp-route-id="@resource.ResourceId">Edit</a> |
<a asp-action="Delete" asp-route-id="@resource.ResourceId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Resource/Details.cshtml
@model Resource
<h2>Resource Details</h2>
<div>
<h4>@Model.Title</h4>
<p>Type: @Model.Type</p>
<p>Description: @Model.Description</p>
<a asp-action="Edit" asp-route-id="@Model.ResourceId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Resource/Create.cshtml
@model Resource
<h2>Create Resource</h2>
<form asp-action="Create">
<div>
<label asp-for="Title"></label>
<input asp-for="Title" />
<span asp-validation-for="Title"></span>
</div>
<div>
<label asp-for="Type"></label>
<input asp-for="Type" />
<span asp-validation-for="Type"></span>
</div>
<div>
<label asp-for="Description"></label>
<textarea asp-for="Description"></textarea>
<span asp-validation-for="Description"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Resource/Edit.cshtml
@model Resource
<h2>Edit Resource</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="ResourceId" />
<div>
<label asp-for="Title"></label>
<input asp-for="Title" />
<span asp-validation-for="Title"></span>
</div>
<div>
<label asp-for="Type"></label>
<input asp-for="Type" />
<span asp-validation-for="Type"></span>
</div>
<div>
<label asp-for="Description"></label>
<textarea asp-for="Description"></textarea>
<span asp-validation-for="Description"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Resource/Delete.cshtml
@model Resource
<h2>Delete Resource</h2>
<div>
<h4>Are you sure you want to delete this resource?</h4>
<div>
<h4>@Model.Title</h4>
<p>Type: @Model.Type</p>
<p>Description: @Model.Description</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="ResourceId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
Notification Views
Views/Notification/Index.cshtml
@model IEnumerable<Notification>
<h2>Notifications</h2>
<a asp-action="Create">Create New Notification</a>
<table>
<thead>
<tr>
<th>Title</th>
<th>Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var notification in Model)
{
<tr>
<td>@notification.Title</td>
<td>@notification.Date.ToShortDateString()</td>
<td>
<a asp-action="Details" asp-route-id="@notification.NotificationId">Details</a> |
<a asp-action="Edit" asp-route-id="@notification.NotificationId">Edit</a> |
<a asp-action="Delete" asp-route-id="@notification.NotificationId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Notification/Details.cshtml
@model Notification
<h2>Notification Details</h2>
<div>
<h4>@Model.Title</h4>
<p>Date: @Model.Date.ToShortDateString()</p>
<p>Message: @Model.Message</p>
<a asp-action="Edit" asp-route-id="@Model.NotificationId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Notification/Create.cshtml
@model Notification
<h2>Create Notification</h2>
<form asp-action="Create">
<div>
<label asp-for="Title"></label>
<input asp-for="Title" />
<span asp-validation-for="Title"></span>
</div>
<div>
<label asp-for="Message"></label>
<textarea asp-for="Message"></textarea>
<span asp-validation-for="Message"></span>
</div>
<div>
<label asp-for="Date"></label>
<input asp-for="Date" type="date" />
<span asp-validation-for="Date"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Notification/Edit.cshtml
@model Notification
<h2>Edit Notification</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="NotificationId" />
<div>
<label asp-for="Title"></label>
<input asp-for="Title" />
<span asp-validation-for="Title"></span>
</div>
<div>
<label asp-for="Message"></label>
<textarea asp-for="Message"></textarea>
<span asp-validation-for="Message"></span>
</div>
<div>
<label asp-for="Date"></label>
<input asp-for="Date" type="date" />
<span asp-validation-for="Date"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Notification/Delete.cshtml
@model Notification
<h2>Delete Notification</h2>
<div>
<h4>Are you sure you want to delete this notification?</h4>
<div>
<h4>@Model.Title</h4>
<p>Date: @Model.Date.ToShortDateString()</p>
<p>Message: @Model.Message</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="NotificationId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
Creating a Dashboard Page
Creating a dashboard page in an ASP.NET MVC application involves aggregating data from various models and displaying it in a user-friendly format. Below, I will outline how to create a simple dashboard view that consolidates data from the different repositories (Users, Roles, Courses, Enrollments, etc.) and displays it on a single page.
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 TotalCourses { get; set; }
public int TotalEnrollments { get; set; }
public int TotalFeedbacks { get; set; }
public int TotalPayments { get; set; }
// Add more properties as needed
}
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 ICourseRepository _courseRepository;
private readonly IEnrollmentRepository _enrollmentRepository;
private readonly IFeedbackRepository _feedbackRepository;
private readonly IPaymentRepository _paymentRepository;
public DashboardController(IUser Repository userRepository, IRoleRepository roleRepository,
ICourseRepository courseRepository, IEnrollmentRepository enrollmentRepository,
IFeedbackRepository feedbackRepository, IPaymentRepository paymentRepository)
{
_userRepository = userRepository;
_roleRepository = roleRepository;
_courseRepository = courseRepository;
_enrollmentRepository = enrollmentRepository;
_feedbackRepository = feedbackRepository;
_paymentRepository = paymentRepository;
}
public IActionResult Index()
{
var model = new DashboardViewModel
{
TotalUsers = _userRepository.GetAllUsers().Count(),
TotalRoles = _roleRepository.GetAllRoles().Count(),
TotalCourses = _courseRepository.GetAllCourses().Count(),
TotalEnrollments = _enrollmentRepository.GetAllEnrollments().Count(),
TotalFeedbacks = _feedbackRepository.GetAllFeedbacks().Count(),
TotalPayments = _paymentRepository.GetAllPayments().Count()
};
return View(model);
}
}
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 Courses</h3>
<p>@Model.TotalCourses</p>
</div>
<div class="card">
<h3>Total Enrollments</h3>
<p>@Model.TotalEnrollments</p>
</div>
<div class="card">
<h3>Total Feedbacks</h3>
<p>@Model.TotalFeedbacks</p>
</div>
<div class="card">
<h3>Total Payments</h3>
<p>@Model.TotalPayments</p>
</div>
</div>
<style>
.dashboard {
display: flex;
flex-wrap: wrap;
gap: 20px;
}
.card {
border: 1px solid #ccc;
border-radius: 5px;
padding: 20px;
width: 200px;
text-align: center;
}
</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="Course" asp-action="Index">Courses</a></li>
<li><a asp-controller="Enrollment" asp-action="Index">Enrollments</a></li>
<li><a asp-controller="Attendance" asp-action="Index">Attendance</a></li>
<li><a asp-controller="Assessment" asp-action="Index">Assessments</a></li>
<li><a asp-controller="Payment" asp-action="Index">Payments</a></li>
<li><a asp-controller="Feedback" asp-action="Index">Feedbacks</a></li>
<li><a asp-controller="Report" asp-action="Index">Reports</a></li>
<li><a asp-controller="Resource" asp-action="Index">Resources</a></li>
<li><a asp-controller="Notification" asp-action="Index">Notifications</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