Project Introduction
The Training Management System is designed to facilitate the organization, management, and tracking of training programs and courses. Built using ASP.NET and SQL Server, this application provides a comprehensive platform for users to create and manage courses, enroll participants, track attendance, and assess performance. The system aims to enhance the learning experience by providing structured training programs and valuable feedback to both trainers and participants.
Project Objectives
- To create a secure user authentication system for managing user accounts and roles.
- To enable the creation and management of training courses, including descriptions and schedules.
- To facilitate the uploading and management of course content, such as videos and documents.
- To track user enrollments in courses and manage their statuses.
- To implement attendance tracking for each training session.
- To manage assessments and evaluations for courses to gauge participant performance.
- To collect feedback from users to improve course offerings and training quality.
- To send notifications to users regarding course updates and important announcements.
- To provide resources related to courses for enhanced learning.
- To generate reports on course performance, user feedback, and attendance statistics.
Project Modules
- User Management Module: Handles user registration, login, and role management.
- Course Management Module: Allows users to create, edit, and delete training courses.
- Content Management Module: Facilitates the upload and management of course materials.
- Enrollment Management Module: Manages user enrollments in courses and tracks their statuses.
- Attendance Management Module: Tracks attendance for each training session.
- Assessment Management Module: Manages assessments and evaluations for courses.
- Feedback Module: Collects and analyzes user feedback on courses and training quality.
- Notification Module: Sends notifications to users regarding course updates and announcements.
- Resource Management Module: Provides additional resources related to courses for enhanced learning.
- Report Generation Module: Generates reports on course performance and user engagement.
SQL Server Database Tables
-- Create Users Table
CREATE TABLE Users (
UserId INT PRIMARY KEY IDENTITY(1,1),
Username NVARCHAR(50) NOT NULL UNIQUE,
PasswordHash NVARCHAR(256) NOT NULL,
Email NVARCHAR(100) NOT NULL UNIQUE,
FirstName NVARCHAR(50) NOT NULL,
LastName NVARCHAR(50) NOT NULL,
RoleId INT NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (RoleId) REFERENCES Roles(RoleId)
);
-- Create Roles Table
CREATE TABLE Roles (
RoleId INT PRIMARY KEY IDENTITY(1,1),
RoleName NVARCHAR(50) NOT NULL UNIQUE,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE()
);
-- Create Courses Table
CREATE TABLE Courses (
CourseId INT PRIMARY KEY IDENTITY(1,1),
CourseName NVARCHAR(100) NOT NULL,
Description NVARCHAR(MAX),
CreatedBy INT NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (CreatedBy) REFERENCES Users(UserId)
);
-- Create Content Table
CREATE TABLE Content (
ContentId INT PRIMARY KEY IDENTITY(1,1),
CourseId INT NOT NULL,
ContentType NVARCHAR(50) NOT NULL, -- e.g., Video, Document, Quiz
ContentLink NVARCHAR(255),
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (CourseId) REFERENCES Courses(CourseId)
);
-- Create Schedule Table
CREATE TABLE Schedules (
ScheduleId INT PRIMARY KEY IDENTITY(1,1),
CourseId INT NOT NULL,
StartDate DATETIME NOT NULL,
EndDate DATETIME NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (CourseId) REFERENCES Courses(CourseId)
);
-- Create Enrollment Table
CREATE TABLE Enrollments (
EnrollmentId INT PRIMARY KEY IDENTITY(1,1),
UserId INT NOT NULL,
CourseId INT NOT NULL,
EnrollmentDate DATETIME DEFAULT GETDATE(),
Status NVARCHAR(50) NOT NULL, -- e.g., Active, Completed, Dropped
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId),
FOREIGN KEY (CourseId) REFERENCES Courses(CourseId)
);
-- Create Attendance Table
CREATE TABLE Attendance (
AttendanceId INT PRIMARY KEY IDENTITY(1,1),
EnrollmentId INT NOT NULL,
AttendanceDate DATETIME NOT NULL,
Status NVARCHAR(20) NOT NULL, -- e.g., Present, Absent
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (EnrollmentId) REFERENCES Enrollments(EnrollmentId)
);
-- Create Assessments Table
CREATE TABLE Assessments (
AssessmentId INT PRIMARY KEY IDENTITY(1,1),
CourseId INT NOT NULL,
AssessmentType NVARCHAR(50) NOT NULL, -- e.g., Quiz, Exam
TotalMarks INT NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (CourseId) REFERENCES Courses(CourseId)
);
-- Create Feedback Table
CREATE TABLE Feedback (
FeedbackId INT PRIMARY KEY IDENTITY(1,1),
UserId INT NOT NULL,
CourseId INT NOT NULL,
FeedbackContent NVARCHAR(MAX) NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId),
FOREIGN KEY (CourseId) REFERENCES Courses(CourseId)
);
-- Create Notifications Table
CREATE TABLE Notifications (
NotificationId INT PRIMARY KEY IDENTITY(1,1),
UserId INT NOT NULL,
Message NVARCHAR(255) NOT NULL,
IsRead BIT NOT NULL DEFAULT 0,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- Create Resources Table
CREATE TABLE Resources (
ResourceId INT PRIMARY KEY IDENTITY(1,1),
CourseId INT NOT NULL,
ResourceName NVARCHAR(100) NOT NULL,
ResourceLink NVARCHAR(255),
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (CourseId) REFERENCES Courses(CourseId)
);
-- Create Reports Table
CREATE TABLE Reports (
ReportId INT PRIMARY KEY IDENTITY(1,1),
UserId INT NOT NULL,
ReportDate DATETIME NOT NULL,
ReportContent NVARCHAR(MAX),
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
Explanation of Tables
Users: Stores user information, including their role in the system (e.g., Admin, Participant).
Roles: Defines different roles in the system (e.g., Admin, User).
Courses: Contains information about training courses, including name and description.
Content: Manages course content, specifying the type and link to the content.
Schedules: Tracks the schedule for each course, including start and end dates.
Enrollments: Records user enrollments in courses, including status and enrollment date.
Attendance: Manages attendance records for enrolled users in courses.
Assessments: Stores information about assessments related to courses, including type and total marks.
Feedback: Collects feedback from users regarding courses.
Notifications: Manages notifications sent to users, including read status.
Resources: Tracks additional resources related to courses, including links.
Reports: Stores reports generated by users, including content and date of the report.
To create a model and repository pattern using ADO.NET for an ASP.NET application based on the SQL Server tables you've defined
We will follow these steps:
Create Models
Define C# classes that represent the tables in your database.
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 FirstName { get; set; }
public string LastName { 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 DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Course
{
public int CourseId { get; set; }
public string CourseName { get; set; }
public string Description { get; set; }
public int CreatedBy { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Content
{
public int ContentId { get; set; }
public int CourseId { get; set; }
public string ContentType { get; set; }
public string ContentLink { 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 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 DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Attendance
{
public int AttendanceId { get; set; }
public int EnrollmentId { get; set; }
public DateTime AttendanceDate { get; set; }
public string Status { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { 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 Feedback
{
public int FeedbackId { get; set; }
public int UserId { get; set; }
public int CourseId { get; set; }
public string FeedbackContent { get; set; }
public DateTime CreatedAt { 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; }
}
public class Resource
{
public int ResourceId { get; set; }
public int CourseId { get; set; }
public string ResourceName { get; set; }
public string ResourceLink { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Report
{
public int ReportId { get; set; }
public int UserId { get; set; }
public DateTime ReportDate { get; set; }
public string ReportContent { get; set; }
public DateTime CreatedAt { get; set; }
}
Create Repositories
Next, we will create a generic repository interface and a concrete implementation for the User entity. You can create similar repositories for other entities.
Generic Repository Interface
public interface IRepository<T>
{
IEnumerable<T> GetAll();
T GetById(int id);
void Add(T entity);
void Update(T entity);
void Delete(int id);
}
User Repository Implementation
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
public class UserRepository : IRepository<User>
{
private readonly string _connectionString;
public UserRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<User> GetAll()
{
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(),
FirstName = reader["FirstName"].ToString(),
LastName = reader["LastName"].ToString(),
RoleId = (int)reader["RoleId"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return users;
}
public User GetById(int id)
{
User user = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Users WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
user = new User
{
UserId = (int)reader["User Id"],
Username = reader["Username"].ToString(),
PasswordHash = reader["PasswordHash"].ToString(),
Email = reader["Email"].ToString(),
FirstName = reader["FirstName"].ToString(),
LastName = reader["LastName"].ToString(),
RoleId = (int)reader["RoleId"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return user;
}
public void Add(User user)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Users (Username, PasswordHash, Email, FirstName, LastName, RoleId) VALUES (@Username, @PasswordHash, @Email, @FirstName, @LastName, @RoleId)", connection);
command.Parameters.AddWithValue("@Username", user.Username);
command.Parameters.AddWithValue("@PasswordHash", user.PasswordHash);
command.Parameters.AddWithValue("@Email", user.Email);
command.Parameters.AddWithValue("@FirstName", user.FirstName);
command.Parameters.AddWithValue("@LastName", user.LastName);
command.Parameters.AddWithValue("@RoleId", user.RoleId);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(User user)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Users SET Username = @Username, PasswordHash = @PasswordHash, Email = @Email, FirstName = @FirstName, LastName = @LastName, 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("@FirstName", user.FirstName);
command.Parameters.AddWithValue("@LastName", user.LastName);
command.Parameters.AddWithValue("@RoleId", user.RoleId);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Users WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
This structure provides a solid foundation for your ASP.NET application using ADO.NET with a repository pattern. You can create similar repository classes for other entities like Role, Course, Content, etc., following the same pattern as shown for the User Repository.
Below are the repository implementations for the remaining models:
Role, Course, Content, Schedule, Enrollment, Attendance, Assessment, Feedback, Notification, Resource, and Report. Each repository follows a similar pattern to the User Repository provided earlier.
Role Repository
public class RoleRepository : IRepository<Role>
{
private readonly string _connectionString;
public RoleRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Role> GetAll()
{
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(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return roles;
}
public Role GetById(int id)
{
Role role = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Roles WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
role = new Role
{
RoleId = (int)reader["RoleId"],
RoleName = reader["RoleName"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return role;
}
public void Add(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 Update(Role role)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Roles SET RoleName = @RoleName, UpdatedAt = GETDATE() WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", role.RoleId);
command.Parameters.AddWithValue("@RoleName", role.RoleName);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Roles WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Course Repository
public class CourseRepository : IRepository<Course>
{
private readonly string _connectionString;
public CourseRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Course> GetAll()
{
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(),
CreatedBy = (int)reader["CreatedBy"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return courses;
}
public Course GetById(int id)
{
Course course = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Courses WHERE CourseId = @CourseId", connection);
command.Parameters.AddWithValue("@CourseId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
course = new Course
{
CourseId = (int)reader["CourseId"],
CourseName = reader["CourseName"].ToString(),
Description = reader["Description"].ToString(),
CreatedBy = (int)reader["CreatedBy"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return course;
}
public void Add(Course course)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Courses (CourseName, Description, CreatedBy) VALUES (@CourseName, @Description, @CreatedBy)", connection);
command.Parameters.AddWithValue("@CourseName", course.CourseName);
command.Parameters.AddWithValue("@Description", course.Description);
command.Parameters.AddWithValue("@CreatedBy", course.CreatedBy);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(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 Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Courses WHERE CourseId = @CourseId", connection);
command.Parameters.AddWithValue("@CourseId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Content Repository
public class ContentRepository : IRepository<Content>
{
private readonly string _connectionString;
public ContentRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Content> GetAll()
{
var contents = new List<Content>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Content", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
contents.Add(new Content
{
ContentId = (int)reader["ContentId"],
CourseId = (int)reader["CourseId"],
ContentType = reader["ContentType"].ToString(),
ContentLink = reader["ContentLink"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return contents;
}
public Content GetById(int id)
{
Content content = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Content WHERE ContentId = @ContentId", connection);
command.Parameters.AddWithValue("@ContentId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
content = new Content
{
ContentId = (int)reader["ContentId"],
CourseId = (int)reader["CourseId"],
ContentType = reader["ContentType"].ToString(),
ContentLink = reader["ContentLink"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return content;
}
public void Add(Content content)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Content (CourseId, ContentType, ContentLink) VALUES (@CourseId, @ContentType, @ContentLink)", connection);
command.Parameters.AddWithValue("@CourseId", content.CourseId);
command.Parameters.AddWithValue("@ContentType", content.ContentType);
command.Parameters.AddWithValue("@ContentLink", content.ContentLink);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Content content)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Content SET CourseId = @CourseId, ContentType = @ContentType, ContentLink = @ContentLink, UpdatedAt = GETDATE() WHERE ContentId = @ContentId", connection);
command.Parameters.AddWithValue("@ContentId", content.ContentId);
command.Parameters.AddWithValue("@CourseId", content.CourseId);
command.Parameters.AddWithValue("@ContentType", content.ContentType);
command.Parameters.AddWithValue("@ContentLink", content.ContentLink);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Content WHERE ContentId = @ContentId", connection);
command.Parameters.AddWithValue("@ContentId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Schedule Repository
public class ScheduleRepository : IRepository<Schedule>
{
private readonly string _connectionString;
public ScheduleRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Schedule> GetAll()
{
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"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return schedules;
}
public Schedule GetById(int id)
{
Schedule schedule = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Schedules WHERE ScheduleId = @ScheduleId", connection);
command.Parameters.AddWithValue("@ScheduleId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
schedule = new Schedule
{
ScheduleId = (int)reader["ScheduleId"],
CourseId = (int)reader["CourseId"],
StartDate = (DateTime) reader["StartDate"],
EndDate = (DateTime)reader["EndDate"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return schedule;
}
public void Add(Schedule schedule)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Schedules (CourseId, StartDate, EndDate) VALUES (@CourseId,
@StartDate, @EndDate)", connection);
command.Parameters.AddWithValue("@CourseId", schedule.CourseId);
command.Parameters.AddWithValue("@StartDate", schedule.StartDate);
command.Parameters.AddWithValue("@EndDate", schedule.EndDate);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Schedule schedule)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Schedules SET CourseId = @CourseId, StartDate = @StartDate, EndDate =
@EndDate, 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);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Schedules WHERE ScheduleId = @ScheduleId", connection);
command.Parameters.AddWithValue("@ScheduleId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Enrollment Repository
public class EnrollmentRepository : IRepository<Enrollment>
{
private readonly string _connectionString;
public EnrollmentRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Enrollment> GetAll()
{
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(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return enrollments;
}
public Enrollment GetById(int id)
{
Enrollment enrollment = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Enrollments WHERE EnrollmentId = @EnrollmentId", connection);
command.Parameters.AddWithValue("@EnrollmentId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
enrollment = new Enrollment
{
EnrollmentId = (int)reader["EnrollmentId"],
UserId = (int)reader["User Id"],
CourseId = (int)reader["CourseId"],
EnrollmentDate = (DateTime)reader["EnrollmentDate"],
Status = reader["Status"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return enrollment;
}
public void Add(Enrollment enrollment)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Enrollments (User Id, CourseId, Status) VALUES (@User Id, @CourseId, @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 Update(Enrollment enrollment)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Enrollments SET UserId = @User Id, CourseId = @CourseId, Status = @Status, UpdatedAt = GETDATE() 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 Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Enrollments WHERE EnrollmentId = @EnrollmentId", connection);
command.Parameters.AddWithValue("@EnrollmentId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Attendance Repository
public class AttendanceRepository : IRepository<Attendance>
{
private readonly string _connectionString;
public AttendanceRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Attendance> GetAll()
{
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"],
AttendanceDate = (DateTime)reader["AttendanceDate"],
Status = reader["Status"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return attendances;
}
public Attendance GetById(int id)
{
Attendance attendance = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Attendance WHERE AttendanceId = @AttendanceId", connection);
command.Parameters.AddWithValue("@AttendanceId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
attendance = new Attendance
{
AttendanceId = (int)reader["AttendanceId"],
EnrollmentId = (int)reader["EnrollmentId"],
AttendanceDate = (DateTime)reader["AttendanceDate"],
Status = reader["Status"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return attendance;
}
public void Add(Attendance attendance)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Attendance (EnrollmentId, AttendanceDate, Status) VALUES (@EnrollmentId, @AttendanceDate, @Status)", connection);
command.Parameters.AddWithValue("@EnrollmentId", attendance.EnrollmentId);
command.Parameters.AddWithValue("@AttendanceDate", attendance.AttendanceDate);
command.Parameters.AddWithValue("@Status", attendance.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Attendance attendance)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Attendance SET EnrollmentId = @EnrollmentId, AttendanceDate = @AttendanceDate, Status = @Status, UpdatedAt = GETDATE() WHERE AttendanceId = @AttendanceId", connection);
command.Parameters.AddWithValue("@AttendanceId", attendance.AttendanceId);
command.Parameters.AddWithValue("@EnrollmentId", attendance.EnrollmentId);
command.Parameters.AddWithValue("@AttendanceDate", attendance.AttendanceDate);
command.Parameters.AddWithValue("@Status", attendance.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Attendance WHERE AttendanceId = @AttendanceId", connection);
command.Parameters.AddWithValue("@AttendanceId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Assessment Repository
public class AssessmentRepository : IRepository<Assessment>
{
private readonly string _connectionString;
public AssessmentRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Assessment> GetAll()
{
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 Assessment GetById(int id)
{
Assessment assessment = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Assessments WHERE AssessmentId = @AssessmentId", connection);
command.Parameters.AddWithValue("@AssessmentId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
assessment = 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 assessment;
}
public void Add(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 Update(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 Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Assessments WHERE AssessmentId = @AssessmentId", connection);
command.Parameters.AddWithValue("@AssessmentId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Feedback Repository
public class FeedbackRepository : IRepository<Feedback>
{
private readonly string _connectionString;
public FeedbackRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Feedback> GetAll()
{
var feedbacks = new List<Feedback>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Feedback", 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"],
FeedbackContent = reader["FeedbackContent"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return feedbacks;
}
public Feedback GetById(int id)
{
Feedback feedback = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Feedback WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@FeedbackId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
feedback = new Feedback
{
FeedbackId = (int)reader["FeedbackId"],
UserId = (int)reader["User Id"],
CourseId = (int)reader["CourseId"],
FeedbackContent = reader["FeedbackContent"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return feedback;
}
public void Add(Feedback feedback)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Feedback (User Id, CourseId, FeedbackContent) VALUES (@User Id, @CourseId, @FeedbackContent)", connection);
command.Parameters.AddWithValue("@User Id", feedback.UserId);
command.Parameters.AddWithValue("@CourseId", feedback.CourseId);
command.Parameters.AddWithValue("@FeedbackContent", feedback.FeedbackContent);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Feedback feedback)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Feedback SET UserId = @User Id, CourseId = @CourseId, FeedbackContent = @FeedbackContent 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("@FeedbackContent", feedback.FeedbackContent);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Feedback WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@FeedbackId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Notification Repository
public class NotificationRepository : IRepository<Notification>
{
private readonly string _connectionString;
public NotificationRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Notification> GetAll()
{
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 Notification GetById(int id)
{
Notification notification = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Notifications WHERE NotificationId = @NotificationId", connection);
command.Parameters.AddWithValue("@NotificationId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
notification = new Notification
{
NotificationId = (int)reader["NotificationId"],
UserId = (int)reader["User Id"],
Message = reader["Message"].ToString(),
IsRead = (bool)reader["IsRead"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return notification;
}
public void Add(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 Update(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 Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Notifications WHERE NotificationId = @NotificationId", connection);
command.Parameters.AddWithValue("@NotificationId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Resource Repository
public class ResourceRepository : IRepository<Resource>
{
private readonly string _connectionString;
public ResourceRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Resource> GetAll()
{
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"],
ResourceName = reader["ResourceName"].ToString(),
ResourceLink = reader["ResourceLink"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return resources;
}
public Resource GetById(int id)
{
Resource resource = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Resources WHERE ResourceId = @ResourceId", connection);
command.Parameters.AddWithValue("@ResourceId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
resource = new Resource
{
ResourceId = (int)reader["ResourceId"],
CourseId = (int)reader["CourseId"],
ResourceName = reader["ResourceName"].ToString(),
ResourceLink = reader["ResourceLink"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return resource;
}
public void Add(Resource resource)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Resources (CourseId, ResourceName, ResourceLink) VALUES (@CourseId, @ResourceName, @ResourceLink)", connection);
command.Parameters.AddWithValue("@CourseId", resource.CourseId);
command.Parameters.AddWithValue("@ResourceName", resource.ResourceName);
command.Parameters.AddWithValue("@ResourceLink", resource.ResourceLink);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Resource resource)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Resources SET CourseId = @CourseId, ResourceName = @ResourceName, ResourceLink = @ResourceLink, UpdatedAt = GETDATE() WHERE ResourceId = @ResourceId", connection);
command.Parameters.AddWithValue("@ResourceId", resource.ResourceId);
command.Parameters.AddWithValue("@CourseId", resource.CourseId);
command.Parameters.AddWithValue("@ResourceName", resource.ResourceName);
command.Parameters.AddWithValue("@ResourceLink", resource.ResourceLink);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Resources WHERE ResourceId = @ResourceId", connection);
command.Parameters.AddWithValue("@ResourceId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Report Repository
public class ReportRepository : IRepository<Report>
{
private readonly string _connectionString;
public ReportRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Report> GetAll()
{
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"],
ReportDate = (DateTime)reader["ReportDate"],
ReportContent = reader["ReportContent"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return reports;
}
public Report GetById(int id)
{
Report report = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Reports WHERE ReportId = @ReportId", connection);
command.Parameters.AddWithValue("@ReportId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
report = new Report
{
ReportId = (int)reader["ReportId"],
UserId = (int)reader["User Id"],
ReportDate = (DateTime)reader["ReportDate"],
Report Content = reader["ReportContent"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return report;
}
public void Add(Report report)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Reports (User Id, ReportDate, ReportContent) VALUES (@User Id, @ReportDate, @ReportContent)", connection);
command.Parameters.AddWithValue("@User Id", report.UserId);
command.Parameters.AddWithValue("@ReportDate", report.ReportDate);
command.Parameters.AddWithValue("@ReportContent", report.ReportContent);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Report report)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Reports SET UserId = @User Id, ReportDate = @ReportDate, ReportContent = @ReportContent WHERE ReportId = @ReportId", connection);
command.Parameters.AddWithValue("@ReportId", report.ReportId);
command.Parameters.AddWithValue("@User Id", report.UserId);
command.Parameters.AddWithValue("@ReportDate", report.ReportDate);
command.Parameters.AddWithValue("@ReportContent", report.ReportContent);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Reports WHERE ReportId = @ReportId", connection);
command.Parameters.AddWithValue("@ReportId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
This completes the repository implementations for all the models defined in your SQL Server schema. Each repository follows the same pattern, allowing for easy data access and manipulation using ADO.NET in your ASP.NET application.
To create controllers for each repository in an ASP.NET MVC application
We will follow the standard pattern of creating a controller for each model. Each controller will handle HTTP requests, interact with the corresponding repository, and return views or data as needed.
Below are the controller implementations for each of the repositories we created earlier:
Each controller will include basic CRUD operations (Create, Read, Update, Delete).
UserController
using System.Web.Mvc;
public class UserController : Controller
{
private readonly UserRepository _userRepository;
public UserController()
{
_userRepository = new UserRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var users = _userRepository.GetAll();
return View(users);
}
public ActionResult Details(int id)
{
var user = _userRepository.GetById(id);
return View(user);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(User user)
{
if (ModelState.IsValid)
{
_userRepository.Add(user);
return RedirectToAction("Index");
}
return View(user);
}
public ActionResult Edit(int id)
{
var user = _userRepository.GetById(id);
return View(user);
}
[HttpPost]
public ActionResult Edit(User user)
{
if (ModelState.IsValid)
{
_userRepository.Update(user);
return RedirectToAction("Index");
}
return View(user);
}
public ActionResult Delete(int id)
{
var user = _userRepository.GetById(id);
return View(user);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_userRepository.Delete(id);
return RedirectToAction("Index");
}
}
RoleController
public class RoleController : Controller
{
private readonly RoleRepository _roleRepository;
public RoleController()
{
_roleRepository = new RoleRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var roles = _roleRepository.GetAll();
return View(roles);
}
public ActionResult Details(int id)
{
var role = _roleRepository.GetById(id);
return View(role);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Role role)
{
if (ModelState.IsValid)
{
_roleRepository.Add(role);
return RedirectToAction("Index");
}
return View(role);
}
public ActionResult Edit(int id)
{
var role = _roleRepository.GetById(id);
return View(role);
}
[HttpPost]
public ActionResult Edit(Role role)
{
if (ModelState.IsValid)
{
_roleRepository.Update(role);
return RedirectToAction("Index");
}
return View(role);
}
public ActionResult Delete(int id)
{
var role = _roleRepository.GetById(id);
return View(role);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_roleRepository.Delete(id);
return RedirectToAction("Index");
}
}
CourseController
public class CourseController : Controller
{
private readonly CourseRepository _courseRepository;
public CourseController()
{
_courseRepository = new CourseRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var courses = _courseRepository.GetAll();
return View(courses);
}
public ActionResult Details(int id)
{
var course = _courseRepository.GetById(id);
return View(course);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Course course)
{
if (ModelState.IsValid)
{
_courseRepository.Add(course);
return RedirectToAction("Index");
}
return View(course);
}
public ActionResult Edit(int id)
{
var course = _courseRepository.GetById(id);
return View(course);
}
[HttpPost]
public ActionResult Edit(Course course)
{
if (ModelState.IsValid)
{
_courseRepository.Update(course);
return RedirectToAction("Index");
}
return View(course);
}
public ActionResult Delete(int id)
{
var course = _courseRepository.GetById(id);
return View(course);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_courseRepository.Delete(id);
return RedirectToAction("Index");
}
}
ContentController
public class ContentController : Controller
{
private readonly ContentRepository _contentRepository;
public ContentController()
{
_contentRepository = new ContentRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var contents = _contentRepository.GetAll();
return View(contents);
}
public ActionResult Details(int id)
{
var content = _contentRepository.GetById(id);
return View(content);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Content content)
{
if (ModelState.IsValid)
{
_contentRepository.Add(content);
return RedirectToAction("Index");
}
return View(content);
}
public ActionResult Edit(int id)
{
var content = _contentRepository.GetById(id);
return View(content);
}
[HttpPost]
public ActionResult Edit(Content content)
{
if (ModelState.IsValid)
{
_contentRepository.Update(content);
return RedirectToAction("Index");
}
return View(content);
}
public ActionResult Delete(int id)
{
var content = _contentRepository.GetById(id);
return View(content);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_contentRepository.Delete(id);
return RedirectToAction("Index");
}
}
ScheduleController
public class ScheduleController : Controller
{
private readonly ScheduleRepository _scheduleRepository;
public ScheduleController()
{
_scheduleRepository = new ScheduleRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var schedules = _scheduleRepository.GetAll();
return View(schedules);
}
public ActionResult Details(int id)
{
var schedule = _scheduleRepository.GetById(id);
return View(schedule);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Schedule schedule)
{
if (ModelState.IsValid)
{
_scheduleRepository.Add(schedule);
return RedirectToAction("Index");
}
return View(schedule);
}
public ActionResult Edit(int id)
{
var schedule = _scheduleRepository.GetById(id);
return View(schedule);
}
[HttpPost]
public ActionResult Edit(Schedule schedule)
{
if (ModelState.IsValid)
{
_scheduleRepository.Update(schedule);
return RedirectToAction("Index");
}
return View(schedule);
}
public ActionResult Delete(int id)
{
var schedule = _scheduleRepository.GetById(id);
return View(schedule);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_scheduleRepository.Delete(id);
return RedirectToAction("Index");
}
}
EnrollmentController
public class EnrollmentController : Controller
{
private readonly EnrollmentRepository _enrollmentRepository;
public EnrollmentController()
{
_enrollmentRepository = new EnrollmentRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var enrollments = _enrollmentRepository.GetAll();
return View(enrollments);
}
public ActionResult Details(int id)
{
var enrollment = _enrollmentRepository.GetById(id);
return View(enrollment);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Enrollment enrollment)
{
if (ModelState.IsValid)
{
_enrollmentRepository.Add(enrollment);
return RedirectToAction("Index");
}
return View(enrollment);
}
public ActionResult Edit(int id)
{
var enrollment = _enrollmentRepository.GetById(id);
return View(enrollment);
}
[HttpPost]
public ActionResult Edit(Enrollment enrollment)
{
if (ModelState.IsValid)
{
_enrollmentRepository.Update(enrollment);
return RedirectToAction("Index");
}
return View(enrollment);
}
public ActionResult Delete(int id)
{
var enrollment = _enrollmentRepository.GetById(id);
return View(enrollment);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_enrollmentRepository.Delete(id);
return RedirectToAction("Index");
}
}
AttendanceController
public class AttendanceController : Controller
{
private readonly AttendanceRepository _attendanceRepository;
public AttendanceController()
{
_attendanceRepository = new AttendanceRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var attendances = _attendanceRepository.GetAll();
return View(attendances);
}
public ActionResult Details(int id)
{
var attendance = _attendanceRepository.GetById(id);
return View(attendance);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Attendance attendance)
{
if (ModelState.IsValid)
{
_attendanceRepository.Add(attendance);
return RedirectToAction("Index");
}
return View(attendance);
}
public ActionResult Edit(int id)
{
var attendance = _attendanceRepository.GetById(id);
return View(attendance);
}
[HttpPost]
public ActionResult Edit(Attendance attendance)
{
if (ModelState.IsValid)
{
_attendanceRepository.Update(attendance);
return RedirectToAction("Index");
}
return View(attendance);
}
public ActionResult Delete(int id)
{
var attendance = _attendanceRepository.GetById(id);
return View(attendance);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_attendanceRepository.Delete(id);
return RedirectToAction("Index");
}
}
AssessmentController
public class AssessmentController : Controller
{
private readonly AssessmentRepository _assessmentRepository;
public AssessmentController()
{
_assessmentRepository = new AssessmentRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var assessments = _assessmentRepository.GetAll();
return View(assessments);
}
public ActionResult Details(int id)
{
var assessment = _assessmentRepository.GetById(id);
return View(assessment);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Assessment assessment)
{
if (ModelState.IsValid)
{
_assessmentRepository.Add(assessment);
return RedirectToAction("Index");
}
return View(assessment);
}
public ActionResult Edit(int id)
{
var assessment = _assessmentRepository.GetById(id);
return View(assessment);
}
[HttpPost]
public ActionResult Edit(Assessment assessment)
{
if (ModelState.IsValid)
{
_assessmentRepository.Update(assessment);
return RedirectToAction("Index");
}
return View(assessment);
}
public ActionResult Delete(int id)
{
var assessment = _assessmentRepository.GetById(id);
return View(assessment);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_assessmentRepository.Delete(id);
return RedirectToAction("Index");
}
}
FeedbackController
public class FeedbackController : Controller
{
private readonly FeedbackRepository _feedbackRepository;
public FeedbackController()
{
_feedbackRepository = new FeedbackRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var feedbacks = _feedbackRepository.GetAll();
return View(feedbacks);
}
public ActionResult Details(int id)
{
var feedback = _feedbackRepository.GetById(id);
return View(feedback);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Feedback feedback)
{
if (ModelState.IsValid)
{
_feedbackRepository.Add(feedback);
return RedirectToAction("Index");
}
return View(feedback);
}
public ActionResult Edit(int id)
{
var feedback = _feedbackRepository.GetById(id);
return View(feedback);
}
[HttpPost]
public ActionResult Edit(Feedback feedback)
{
if (ModelState.IsValid)
{
_feedbackRepository.Update(feedback);
return RedirectToAction("Index");
}
return View(feedback);
}
public ActionResult Delete(int id)
{
var feedback = _feedbackRepository.GetById(id);
return View(feedback);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_feedbackRepository.Delete(id);
return RedirectToAction("Index");
}
}
NotificationController
public class NotificationController : Controller
{
private readonly NotificationRepository _notificationRepository;
public NotificationController()
{
_notificationRepository = new NotificationRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var notifications = _notificationRepository.GetAll();
return View(notifications);
}
public ActionResult Details(int id)
{
var notification = _notificationRepository.GetById(id);
return View(notification);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Notification notification)
{
if (ModelState.IsValid)
{
_notificationRepository.Add(notification);
return RedirectToAction("Index");
}
return View(notification);
}
public ActionResult Edit(int id)
{
var notification = _notificationRepository.GetById(id);
return View(notification);
}
[HttpPost]
public ActionResult Edit(Notification notification)
{
if (ModelState.IsValid)
{
_notificationRepository.Update(notification);
return RedirectToAction("Index");
}
return View(notification);
}
public ActionResult Delete(int id)
{
var notification = _notificationRepository.GetById(id);
return View(notification);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_notificationRepository.Delete(id);
return RedirectToAction("Index");
}
}
ResourceController
public class ResourceController : Controller
{
private readonly ResourceRepository _resourceRepository;
public ResourceController()
{
_resourceRepository = new ResourceRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var resources = _resourceRepository.GetAll();
return View(resources);
}
public ActionResult Details(int id)
{
var resource = _resourceRepository.GetById(id);
return View(resource);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Resource resource)
{
if (ModelState.IsValid)
{
_resourceRepository.Add(resource);
return RedirectToAction("Index");
}
return View(resource);
}
public ActionResult Edit(int id)
{
var resource = _resourceRepository.GetById(id);
return View(resource);
}
[HttpPost]
public ActionResult Edit(Resource resource)
{
if (ModelState.IsValid)
{
_resourceRepository.Update(resource);
return RedirectToAction("Index");
}
return View(resource);
}
public ActionResult Delete(int id)
{
var resource = _resourceRepository.GetById(id);
return View(resource);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_resourceRepository.Delete(id);
return RedirectToAction("Index");
}
}
ReportController
public class ReportController : Controller
{
private readonly ReportRepository _reportRepository;
public ReportController()
{
_reportRepository = new ReportRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var reports = _reportRepository.GetAll();
return View(reports);
}
public ActionResult Details(int id)
{
var report = _reportRepository.GetById(id);
return View(report);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Report report)
{
if (ModelState.IsValid)
{
_reportRepository.Add(report);
return RedirectToAction("Index");
}
return View(report);
}
public ActionResult Edit(int id)
{
var report = _reportRepository.GetById(id);
return View(report);
}
[HttpPost]
public ActionResult Edit(Report report)
{
if (ModelState.IsValid)
{
_reportRepository.Update(report);
return RedirectToAction("Index");
}
return View(report);
}
public ActionResult Delete(int id)
{
var report = _reportRepository.GetById(id);
return View(report);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_reportRepository.Delete(id);
return RedirectToAction("Index");
}
}
This completes the controller implementations for all the repositories. Each controller provides the necessary actions to manage the corresponding model, allowing for a full CRUD interface in your ASP.NET MVC application.
Creating views for each controller in an ASP.NET MVC application involves creating Razor view files that correspond to the actions in the controllers. Below, I will provide the basic structure for the views for each controller, including the Index, Details, Create, Edit, and Delete views.
User Views
Views/User/Index.cshtml
@model IEnumerable<YourNamespace.Models.User>
@{
ViewBag.Title = "Users";
}
<h2>Users</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.First().Username)
</th>
<th>
@Html.DisplayNameFor(model => model.First().Email)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => item.Username)</td>
<td>@Html.DisplayFor(modelItem => item.Email)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = item.UserId }) |
@Html.ActionLink("Details", "Details", new { id = item.UserId }) |
@Html.ActionLink("Delete", "Delete", new { id = item.UserId })
</td>
</tr>
}
</tbody>
</table>
Views/User/Details.cshtml
@model YourNamespace.Models.User
@{
ViewBag.Title = "User Details";
}
<h2>User Details</h2>
<div>
<h4>User</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Username)
</dt>
<dd>
@Html.DisplayFor(model => model.Username)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Email)
</dt>
<dd>
@Html.DisplayFor(model => model.Email)
</dd>
<dt>
@Html.DisplayNameFor(model => model.FirstName)
</dt>
<dd>
@Html.DisplayFor(model => model.FirstName)
</dd>
<dt>
@Html.DisplayNameFor(model => model.LastName)
</dt>
<dd>
@Html.DisplayFor(model => model.LastName)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.UserId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/User/Create.cshtml
@model YourNamespace.Models.User
@{
ViewBag.Title = "Create User";
}
<h2>Create User</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>User</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Username, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Username, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Username, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Email, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Email, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Email, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.PasswordHash, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.PasswordHash, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.PasswordHash, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/User/Edit.cshtml
@model YourNamespace.Models.User
@{
ViewBag.Title = "Edit User";
}
<h2>Edit User</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>User</h4>
<hr />
@Html.HiddenFor(model => model.UserId)
<div class="form-group">
@Html.LabelFor(model => model.Username, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Username, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Username, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Email, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Email, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Email, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.PasswordHash, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.PasswordHash, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.PasswordHash, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class=" col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/User/Delete.cshtml
@model YourNamespace.Models.User
@{
ViewBag.Title = "Delete User";
}
<h2>Delete User</h2>
<div>
<h4>User</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Username)
</dt>
<dd>
@Html.DisplayFor(model => model.Username)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Email)
</dt>
<dd>
@Html.DisplayFor(model => model.Email)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(model => model.UserId)
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Back to List", "Index", null, new { @class = "btn btn-default" })
</div>
}
Role Views
Views/Role/Index.cshtml
@model IEnumerable<YourNamespace.Models.Role>
@{
ViewBag.Title = "Roles";
}
<h2>Roles</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.First().RoleName)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => item.RoleName)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = item.RoleId }) |
@Html.ActionLink("Details", "Details", new { id = item.RoleId }) |
@Html.ActionLink("Delete", "Delete", new { id = item.RoleId })
</td>
</tr>
}
</tbody>
</table>
Views/Role/Details.cshtml
@model YourNamespace.Models.Role
@{
ViewBag.Title = "Role Details";
}
<h2>Role Details</h2>
<div>
<h4>Role</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.RoleName)
</dt>
<dd>
@Html.DisplayFor(model => model.RoleName)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.RoleId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/Role/Create.cshtml
@model YourNamespace.Models.Role
@{
ViewBag.Title = "Create Role";
}
<h2>Create Role</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Role</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.RoleName, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.RoleName, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.RoleName, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Role/Edit.cshtml
@model YourNamespace.Models.Role
@{
ViewBag.Title = "Edit Role";
}
<h2>Edit Role</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Role</h4>
<hr />
@Html.HiddenFor(model => model.RoleId)
<div class="form-group">
@Html.LabelFor(model => model.RoleName, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.RoleName, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.RoleName, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Role/Delete.cshtml
@model YourNamespace.Models.Role
@{
ViewBag.Title = "Delete Role";
}
<h2>Delete Role</h2>
<div>
<h4>Role</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.RoleName)
</dt>
<dd>
@Html.DisplayFor(model => model.RoleName)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(model => model.RoleId)
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Back to List", "Index", null, new { @class = "btn btn-default" })
</div>
}
Course Views
Views/Course/Index.cshtml
@model IEnumerable<YourNamespace.Models.Course>
@{
ViewBag.Title = "Courses";
}
<h2>Courses</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.First().CourseName)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => item.CourseName)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = item.CourseId }) |
@Html.ActionLink("Details", "Details", new { id = item.CourseId }) |
@Html.ActionLink("Delete", "Delete", new { id = item.CourseId })
</td>
</tr>
}
</tbody>
</table>
Views/Course/Details.cshtml
@model YourNamespace.Models.Course
@{
ViewBag.Title = "Course Details";
}
<h2>Course Details</h2>
<div>
<h4>Course</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.CourseName)
</dt>
<dd>
@Html.DisplayFor(model => model.CourseName)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Description)
</dt>
<dd>
@Html.DisplayFor(model => model.Description)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.CourseId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/Course/Create.cshtml
@model YourNamespace.Models.Course
@{
ViewBag.Title = "Create Course";
}
<h2>Create Course</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Course</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.CourseName, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.CourseName, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.CourseName, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Description, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Description, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Description, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Course/Edit.cshtml
@model YourNamespace.Models.Course
@{
ViewBag.Title = "Edit Course";
}
<h2>Edit Course</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Course</h4>
<hr />
@Html.HiddenFor(model => model.CourseId)
<div class="form-group">
@Html.LabelFor(model => model.CourseName, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.CourseName, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.CourseName, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Description, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Description, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Description, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Course/Delete.cshtml
@model YourNamespace.Models.Course
@{
ViewBag.Title = "Delete Course";
}
<h2>Delete Course</h2>
<div>
<h4>Course</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.CourseName)
</dt>
<dd>
@Html.DisplayFor(model => model.CourseName)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Description)
</dt>
<dd>
@Html.DisplayFor(model => model.Description)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(model => model.CourseId)
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Back to List", "Index", null, new { @class = "btn btn-default" })
</div>
}
Content Views
Views/Content/Index.cshtml
@model IEnumerable<YourNamespace.Models.Content>
@{
ViewBag.Title = "Contents";
}
<h2>Contents</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.First().Title)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => item.Title)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = item.ContentId }) |
@Html.ActionLink("Details", "Details", new { id = item.ContentId }) |
@Html.ActionLink("Delete", "Delete", new { id = item.ContentId })
</td>
</tr>
}
</tbody>
</table>
Views/Content/Details.cshtml
@model YourNamespace.Models.Content
@{
ViewBag.Title = "Content Details";
}
<h2>Content Details</h2>
<div>
<h4>Content</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Title)
</dt>
<dd>
@Html.DisplayFor(model => model.Title)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Body)
</dt>
<dd>
@Html.DisplayFor(model => model.Body)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.ContentId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/Content/Create.cshtml
@model Your Namespace.Models.Content
@{
ViewBag.Title = "Create Content";
}
<h2>Create Content</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Content</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Title, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Title, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Title, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Body, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Body, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Body, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Content/Edit.cshtml
@model YourNamespace.Models.Content
@{
ViewBag.Title = "Edit Content";
}
<h2>Edit Content</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Content</h4>
<hr />
@Html.HiddenFor(model => model.ContentId)
<div class="form-group">
@Html.LabelFor(model => model.Title, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Title, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Title, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Body, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Body, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Body, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Content/Delete.cshtml
@model YourNamespace.Models.Content
@{
ViewBag.Title = "Delete Content";
}
<h2>Delete Content</h2>
<div>
<h4>Content</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Title)
</dt>
<dd>
@Html.DisplayFor(model => model.Title)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Body)
</dt>
<dd>
@Html.DisplayFor(model => model.Body)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(model => model.ContentId)
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Back to List", "Index", null, new { @class = "btn btn-default" })
</div>
}
Schedule Views
Views/Schedule/Index.cshtml
@model IEnumerable<YourNamespace.Models.Schedule>
@{
ViewBag.Title = "Schedules";
}
<h2>Schedules</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.First().ScheduleDate)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
<td>@ Html.DisplayFor(modelItem => item.ScheduleDate)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = item.ScheduleId }) |
@Html.ActionLink("Details", "Details", new { id = item.ScheduleId }) |
@Html.ActionLink("Delete", "Delete", new { id = item.ScheduleId })
</td>
</tr>
}
</tbody>
</table>
Views/Schedule/Details.cshtml
@model YourNamespace.Models.Schedule
@{
ViewBag.Title = "Schedule Details";
}
<h2>Schedule Details</h2>
<div>
<h4>Schedule</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.ScheduleDate)
</dt>
<dd>
@Html.DisplayFor(model => model.ScheduleDate)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Description)
</dt>
<dd>
@Html.DisplayFor(model => model.Description)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.ScheduleId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/Schedule/Create.cshtml
@model YourNamespace.Models.Schedule
@{
ViewBag.Title = "Create Schedule";
}
<h2>Create Schedule</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Schedule</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.ScheduleDate, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.ScheduleDate, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.ScheduleDate, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Description, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Description, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Description, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Schedule/Edit.cshtml
@model YourNamespace.Models.Schedule
@{
ViewBag.Title = "Edit Schedule";
}
<h2>Edit Schedule</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Schedule</h4>
<hr />
@Html.HiddenFor(model => model.ScheduleId)
<div class="form-group">
@Html.LabelFor(model => model.ScheduleDate, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.ScheduleDate, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.ScheduleDate, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Description, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Description, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Description, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Schedule/Delete.cshtml
@model YourNamespace.Models.Schedule
@{
ViewBag.Title = "Delete Schedule";
}
<h2>Delete Schedule</h2>
<div>
<h4>Schedule</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.ScheduleDate)
</dt>
<dd>
@Html.DisplayFor(model => model.ScheduleDate)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Description)
</dt>
<dd>
@Html.DisplayFor(model => model.Description)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(model => model.ScheduleId)
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Back to List", "Index", null, new { @class = "btn btn-default" })
</div>
}
Enrollment Views
Views/Enrollment/Index.cshtml
@model IEnumerable<YourNamespace.Models.Enrollment>
@{
ViewBag.Title = "Enrollments";
}
<h2>Enrollments</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.First().StudentName)
</th>
<th>
@Html.DisplayNameFor(model => model.First().CourseName)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => item.StudentName)</td>
<td>@Html.DisplayFor(modelItem => item.CourseName)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = item.EnrollmentId }) |
@Html.ActionLink("Details", "Details", new { id = item.EnrollmentId }) |
@Html.ActionLink("Delete", "Delete", new { id = item.EnrollmentId })
</td>
</tr>
}
</tbody>
</table>
Views/Enrollment/Details.cshtml
@model YourNamespace.Models.Enrollment
@{
ViewBag.Title = "Enrollment Details";
}
<h2>Enrollment Details</h2>
<div>
<h4>Enrollment</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.StudentName)
</dt>
<dd>
@Html.DisplayFor(model => model.StudentName)
</dd>
<dt>
@Html.DisplayNameFor(model => model.CourseName)
</dt>
<dd>
@Html.DisplayFor(model => model.CourseName)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.EnrollmentId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/Enrollment/Create.cshtml
@model YourNamespace.Models.Enrollment
@{
ViewBag.Title = "Create Enrollment";
}
<h2>Create Enrollment</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Enrollment</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.StudentName, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.StudentName, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.StudentName, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.CourseName, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.CourseName, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.CourseName, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Enrollment/Edit.cshtml
@model YourNamespace.Models.Enrollment
@{
ViewBag.Title = "Edit Enrollment";
}
<h2>Edit Enrollment</h2>
@using (Html.BeginForm ())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Enrollment</h4>
<hr />
@Html.HiddenFor(model => model.EnrollmentId)
<div class="form-group">
@Html.LabelFor(model => model.StudentName, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.StudentName, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.StudentName, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.CourseName, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.CourseName, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.CourseName, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Enrollment/Delete.cshtml
@model YourNamespace.Models.Enrollment
@{
ViewBag.Title = "Delete Enrollment";
}
<h2>Delete Enrollment</h2>
<div>
<h4>Enrollment</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.StudentName)
</dt>
<dd>
@Html.DisplayFor(model => model.StudentName)
</dd>
<dt>
@Html.DisplayNameFor(model => model.CourseName)
</dt>
<dd>
@Html.DisplayFor(model => model.CourseName)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(model => model.EnrollmentId)
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Back to List", "Index", null, new { @class = "btn btn-default" })
</div>
}
Attendance Views
Views/Attendance/Index.cshtml
@model IEnumerable<YourNamespace.Models.Attendance>
@{
ViewBag.Title = "Attendance Records";
}
<h2>Attendance Records</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.First().StudentName)
</th>
<th>
@Html.DisplayNameFor(model => model.First().CourseName)
</th>
<th>
@Html.DisplayNameFor(model => model.First().AttendanceDate)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => item.StudentName)</td>
<td>@Html.DisplayFor(modelItem => item.CourseName)</td>
<td>@Html.DisplayFor(modelItem => item.AttendanceDate)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = item.AttendanceId }) |
@Html.ActionLink("Details", "Details", new { id = item.AttendanceId }) |
@Html.ActionLink("Delete", "Delete", new { id = item.AttendanceId })
</td>
</tr>
}
</tbody>
</table>
Views/Attendance/Details.cshtml
@model YourNamespace.Models.Attendance
@{
ViewBag.Title = "Attendance Details";
}
<h2>Attendance Details</h2>
<div>
<h4>Attendance</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.StudentName)
</dt>
<dd>
@Html.DisplayFor(model => model.StudentName)
</dd>
<dt>
@Html.DisplayNameFor(model => model.CourseName)
</dt>
<dd>
@Html.DisplayFor(model => model.CourseName)
</dd>
<dt>
@Html.DisplayNameFor(model => model.AttendanceDate)
</dt>
<dd>
@Html.DisplayFor(model => model.AttendanceDate)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.AttendanceId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/Attendance/Create.cshtml
@model YourNamespace.Models.Attendance
@{
ViewBag.Title = "Create Attendance";
}
<h2>Create Attendance</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Attendance</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.StudentName, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.StudentName, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.StudentName, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.CourseName, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.CourseName, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.CourseName, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.AttendanceDate, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.AttendanceDate, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.AttendanceDate, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Attendance/Edit.cshtml
@model YourNamespace.Models.Attendance
@{
ViewBag.Title = "Edit Attendance";
}
<h2>Edit Attendance</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Attendance</h4>
<hr />
@Html.HiddenFor(model => model.AttendanceId)
<div class="form-group">
@Html.LabelFor(model => model.StudentName, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.StudentName, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.StudentName, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.CourseName, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.CourseName, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.CourseName, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.AttendanceDate, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.AttendanceDate, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.AttendanceDate, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Attendance/Delete.cshtml
@model YourNamespace.Models.Attendance
@{
ViewBag.Title = "Delete Attendance";
}
<h2>Delete Attendance</h2>
<div>
<h4>Attendance</h4>
<hr/>
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.StudentName)
</dt>
<dd>
@Html.DisplayFor(model => model.StudentName)
</dd>
<dt>
@Html.DisplayNameFor(model => model.CourseName)
</dt>
<dd>
@Html.DisplayFor(model => model.CourseName)
</dd>
<dt>
@Html.DisplayNameFor(model => model.AttendanceDate)
</dt>
<dd>
@Html.DisplayFor(model => model.AttendanceDate)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(model => model.AttendanceId)
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Back to List", "Index", null, new { @class = "btn btn-default" })
</div>
}
Assessment Views
Views/Assessment/Index.cshtml
@model IEnumerable<YourNamespace.Models.Assessment>
@{
ViewBag.Title = "Assessments";
}
<h2>Assessments</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.First().Title)
</th>
<th>
@Html.DisplayNameFor(model => model.First().Score)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => item.Title)</td>
<td>@Html.DisplayFor(modelItem => item.Score)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = item.AssessmentId }) |
@Html.ActionLink("Details", "Details", new { id = item.AssessmentId }) |
@Html.ActionLink("Delete", "Delete", new { id = item.AssessmentId })
</td>
</tr>
}
</tbody>
</table>
Views/Assessment/Details.cshtml
@model YourNamespace.Models.Assessment
@{
ViewBag.Title = "Assessment Details";
}
<h2>Assessment Details</h2>
<div>
<h4>Assessment</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Title)
</dt>
<dd>
@Html.DisplayFor(model => model.Title)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Score)
</dt>
<dd>
@Html.DisplayFor(model => model.Score)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.AssessmentId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/Assessment/Create.cshtml
@model YourNamespace.Models.Assessment
@{
ViewBag.Title = "Create Assessment";
}
<h2>Create Assessment</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Assessment</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Title, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Title, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Title, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Score, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Score, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Score, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Assessment/Edit.cshtml
@model YourNamespace .Models.Assessment
@{
ViewBag.Title = "Edit Assessment";
}
<h2>Edit Assessment</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Assessment</h4>
<hr />
@Html.HiddenFor(model => model.AssessmentId)
<div class="form-group">
@Html.LabelFor(model => model.Title, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Title, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Title, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Score, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Score, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Score, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Assessment/Delete.cshtml
@model YourNamespace.Models.Assessment
@{
ViewBag.Title = "Delete Assessment";
}
<h2>Delete Assessment</h2>
<div>
<h4>Assessment</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Title)
</dt>
<dd>
@Html.DisplayFor(model => model.Title)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Score)
</dt>
<dd>
@Html.DisplayFor(model => model.Score)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(model => model.AssessmentId)
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Back to List", "Index", null, new { @class = "btn btn-default" })
</div>
}
Feedback Views
Views/Feedback/Index.cshtml
@model IEnumerable<YourNamespace.Models.Feedback>
@{
ViewBag.Title = "Feedbacks";
}
<h2>Feedbacks</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.First().Comment)
</th>
<th>
@Html.DisplayNameFor(model => model.First().Rating)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => item.Comment)</td>
<td>@Html.DisplayFor(modelItem => item.Rating)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = item.FeedbackId }) |
@Html.ActionLink("Details", "Details", new { id = item.FeedbackId }) |
@Html.ActionLink("Delete", "Delete", new { id = item.FeedbackId })
</td>
</tr>
}
</tbody>
</table>
Views/Feedback/Details.cshtml
@model YourNamespace.Models.Feedback
@{
ViewBag.Title = "Feedback Details";
}
<h2>Feedback Details</h2>
<div>
<h4>Feedback</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Comment)
</dt>
<dd>
@Html.DisplayFor(model => model.Comment)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Rating)
</dt>
<dd>
@Html.DisplayFor(model => model.Rating)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.FeedbackId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/Feedback/Create.cshtml
@model YourNamespace.Models.Feedback
@{ ViewBag.Title = "Create Feedback"; }
<h2>Create Feedback</h2>
@using (Html.BeginForm()) { @Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Feedback</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Comment, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Comment, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Comment, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Rating, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Rating, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Rating, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
# Views/Feedback/Edit.cshtml
@model YourNamespace.Models.Feedback
@{
ViewBag.Title = "Edit Feedback";
}
<h2>Edit Feedback</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Feedback</h4>
<hr />
@Html.HiddenFor(model => model.FeedbackId)
<div class="form-group">
@Html.LabelFor(model => model.Comment, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Comment, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Comment, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Rating, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Rating, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Rating, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Feedback/Delete.cshtml
@model YourNamespace.Models.Feedback
@{
ViewBag.Title = "Delete Feedback";
}
<h2>Delete Feedback</h2>
<div>
<h4>Feedback</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Comment)
</dt>
<dd>
@Html.DisplayFor(model => model.Comment)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Rating)
</dt>
<dd>
@Html.DisplayFor(model => model.Rating)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(model => model.FeedbackId)
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Back to List", "Index", null, new { @class = "btn btn-default" })
</div>
}
Notification Views
Views/Notification/Index.cshtml
@model IEnumerable<YourNamespace.Models.Notification>
@{
ViewBag.Title = "Notifications";
}
<h2>Notifications</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.First().Message)
</th>
<th>
@Html.DisplayNameFor(model => model.First().Date)
</ th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => item.Message)</td>
<td>@Html.DisplayFor(modelItem => item.Date)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = item.NotificationId }) |
@Html.ActionLink("Details", "Details", new { id = item.NotificationId }) |
@Html.ActionLink("Delete", "Delete", new { id = item.NotificationId })
</td>
</tr>
}
</tbody>
</table>
Views/Notification/Details.cshtml
@model YourNamespace.Models.Notification
@{
ViewBag.Title = "Notification Details";
}
<h2>Notification Details</h2>
<div>
<h4>Notification</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Message)
</dt>
<dd>
@Html.DisplayFor(model => model.Message)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Date)
</dt>
<dd>
@Html.DisplayFor(model => model.Date)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.NotificationId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/Notification/Create.cshtml
@model YourNamespace.Models.Notification
@{
ViewBag.Title = "Create Notification";
}
<h2>Create Notification</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Notification</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Message, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Message, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Message, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Date, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Date, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Date, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Notification/Edit.cshtml
@model YourNamespace.Models.Notification
@{
ViewBag.Title = "Edit Notification";
}
<h2>Edit Notification</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Notification</h4>
<hr />
@Html.HiddenFor(model => model.NotificationId)
<div class="form-group">
@Html.LabelFor(model => model.Message, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Message, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Message, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Date, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Date, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Date, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Notification/Delete.cshtml
@model YourNamespace.Models.Notification
@{
ViewBag.Title = "Delete Notification";
}
<h2>Delete Notification</h2>
<div>
<h4>Notification</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Message)
</dt>
<dd>
@Html.DisplayFor(model => model.Message)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Date)
</dt>
<dd>
@Html.DisplayFor(model => model.Date)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(model => model.NotificationId)
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Back to List", "Index", null, new { @class = "btn btn-default" })
</div>
}
Resource Views
Views/Resource/Index.cshtml
@model IEnumerable<YourNamespace.Models.Resource>
@{
ViewBag.Title = "Resources";
}
<h2>Resources</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.First().Title)
</th>
<th>
@Html.DisplayNameFor(model => model.First().Description)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => item.Title)</td>
<td>@Html.DisplayFor(modelItem => item.Description)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = item.ResourceId }) |
@Html.ActionLink("Details", "Details", new { id = item.ResourceId }) |
@Html.ActionLink("Delete", "Delete", new { id = item.ResourceId })
</td>
</tr>
}
</tbody>
</table>
Views/Resource/Details.cshtml
@model YourNamespace.Models.Resource
@{
ViewBag.Title = "Resource Details";
}
<h2>Resource Details</h2>
<div>
<h4>Resource</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Title)
</dt>
<dd>
@Html.DisplayFor(model => model.Title)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Description)
</dt>
<dd>
@Html.DisplayFor(model => model.Description)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.ResourceId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/Resource/Create.cshtml
@model YourNamespace.Models.Resource
@{
ViewBag.Title = "Create Resource";
}
<h2>Create Resource</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Resource</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Title, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Title, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Title, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Description, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Description, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Description, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Resource/Edit.cshtml
@model YourNamespace.Models.Resource
@{
ViewBag.Title = "Edit Resource";
}
<h2>Edit Resource</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Resource</h4>
<hr />
@Html.HiddenFor(model => model.ResourceId)
<div class="form-group">
@Html.LabelFor(model => model.Title, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Title, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Title, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Description, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Description, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Description, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Resource/Delete.cshtml
@model YourNamespace.Models.Resource
@{
ViewBag.Title = "Delete Resource";
}
<h2>Delete Resource</h2>
<div>
<h4>Resource</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Title)
</dt>
<dd>
@Html.DisplayFor(model => model.Title)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Description)
</dt>
<dd>
@Html.DisplayFor(model => model.Description)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(model => model.ResourceId)
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Back to List", "Index", null, new { @class = "btn btn-default" })
</div>
}
Report Views
Views/Report/Index.cshtml
@model IEnumerable<YourNamespace.Models.Report>
@{
ViewBag.Title = "Reports";
}
<h2>Reports</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.First().Title)
</th>
<th>
@Html.DisplayNameFor(model => model.First().Date)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => item.Title)</td>
<td>@Html.DisplayFor(modelItem => item.Date)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = item.ReportId }) |
@Html.ActionLink("Details", "Details", new { id = item.ReportId }) |
@Html.ActionLink("Delete", "Delete", new { id = item.ReportId })
</td>
</tr>
}
</tbody>
</table>
Views/Report/Details.cshtml
@model YourNamespace.Models.Report
@{
ViewBag.Title = "Report Details";
}
<h2>Report Details</h2>
<div>
<h4>Report</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Title)
</dt>
<dd>
@Html.DisplayFor(model => model.Title)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Date)
</dt>
<dd>
@Html.DisplayFor(model => model.Date)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.ReportId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/Report/Create.cshtml
@model YourNamespace.Models.Report
@{
ViewBag.Title = "Create Report";
}
<h2>Create Report </h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Report</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Title, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Title, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Title, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Date, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Date, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Date, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Report/Edit.cshtml
@model YourNamespace.Models.Report
@{
ViewBag.Title = "Edit Report";
}
<h2>Edit Report</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Report</h4>
<hr />
@Html.HiddenFor(model => model.ReportId)
<div class="form-group">
@Html.LabelFor(model => model.Title, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Title, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Title, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Date, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Date, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Date, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Report/Delete.cshtml
@model YourNamespace.Models.Report
@{
ViewBag.Title = "Delete Report";
}
<h2>Delete Report</h2>
<div>
<h4>Report</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Title)
</dt>
<dd>
@Html.DisplayFor(model => model.Title)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Date)
</dt>
<dd>
@Html.DisplayFor(model => model.Date)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(model => model.ReportId)
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Back to List", "Index", null, new { @class = "btn btn-default" })
</div>
}
This completes the view implementations for all the controllers in your ASP.NET MVC application. Each view corresponds to the actions defined in the controllers, providing a full CRUD interface for managing the respective models.
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 that consolidates data from the different models (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
using System.Collections.Generic;
namespace YourNamespace.Models
{
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 TotalResources { get; set; }
public int TotalReports { get; set; }
}
}
Step 2: Create the Dashboard Controller
Next, we will create a controller that will fetch the necessary data and pass it to the dashboard view.
Controllers/DashboardController.cs
using System.Web.Mvc;
using YourNamespace.Models;
namespace YourNamespace.Controllers
{
public class DashboardController : Controller
{
private readonly UserRepository _userRepository;
private readonly RoleRepository _roleRepository;
private readonly CourseRepository _courseRepository;
private readonly EnrollmentRepository _enrollmentRepository;
private readonly FeedbackRepository _feedbackRepository;
private readonly ResourceRepository _resourceRepository;
private readonly ReportRepository _reportRepository;
public DashboardController()
{
_userRepository = new UserRepository("YourConnectionStringHere");
_roleRepository = new RoleRepository("YourConnectionStringHere");
_courseRepository = new CourseRepository("YourConnectionStringHere");
_enrollmentRepository = new EnrollmentRepository("YourConnectionStringHere");
_feedbackRepository = new FeedbackRepository("YourConnectionStringHere");
_resourceRepository = new ResourceRepository("YourConnectionStringHere");
_reportRepository = new ReportRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var dashboardViewModel = new DashboardViewModel
{
TotalUsers = _userRepository.GetAll().Count(),
TotalRoles = _roleRepository.GetAll().Count(),
TotalCourses = _courseRepository.GetAll().Count(),
TotalEnrollments = _enrollmentRepository.GetAll().Count(),
TotalFeedbacks = _feedbackRepository.GetAll().Count(),
TotalResources = _resourceRepository.GetAll().Count(),
TotalReports = _reportRepository.GetAll().Count()
};
return View(dashboardViewModel);
}
}
}
Step 3: Create the Dashboard View
Now, we will create the view that will display the dashboard data.
Views/Dashboard/Index.cshtml
@model YourNamespace.Models.DashboardViewModel
@{
ViewBag.Title = "Dashboard";
}
<h2>Dashboard</h2>
<div class="row">
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Total Users</div>
<div class="panel-body">
<h3>@Model.TotalUsers</h3>
</div>
</div>
</div>
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Total Roles</div>
<div class="panel-body">
<h3>@Model.TotalRoles</h3>
</div>
</div>
</div>
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Total Courses</div>
<div class="panel-body">
<h3>@Model.TotalCourses</h3>
</div>
</div>
</div>
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Total Enrollments</div>
<div class="panel-body">
<h3>@Model.TotalEnrollments</h3>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Total Feedbacks</div>
<div class="panel-body">
<h3>@Model.TotalFeedbacks</h3>
</div>
</div>
</div>
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Total Resources</div>
<div class="panel-body">
<h3>@Model.TotalResources</h3>
</div>
</div>
</div>
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Total Reports</div>
<div class="panel-body">
<h3>@Model.TotalReports</h3>
</div>
</div>
</div>
</div>
Step 4: Add a Route for the Dashboard
Make sure to add a route for the dashboard in your RouteConfig.cs file if you want to access it easily.
public class RouteConfig
{
public static void RegisterRoutes(RouteCollection routes)
{
routes.IgnoreRoute("{resource}.axd/{*pathInfo}");
routes.MapRoute(
name: "Dashboard",
url: "Dashboard",
defaults: new { controller = "Dashboard", action = "Index" }
);
routes.MapRoute(
name: "Default",
url: "{controller}/{action}/{id}",
defaults: new { controller = "Home", action = "Index", id = UrlParameter.Optional }
);
}
}
Step 5: Add Navigation to the Dashboard
You may want to add a link to the dashboard in your main layout or navigation menu.
Views/Shared/_Layout.cshtml
<ul class="nav navbar-nav">
<li>@Html.ActionLink("Home", "Index", "Home")</li>
<li>@Html.ActionLink("Dashboard", "Index", "Dashboard")</li>
<li>@Html.ActionLink("Users", "Index", "User ")</li>
<li>@Html.ActionLink("Roles", "Index", "Role")</li>
<li>@Html.ActionLink("Courses", "Index", "Course")</li>
< li>@Html.ActionLink("Enrollments", "Index", "Enrollment")</li>
<li>@Html.ActionLink("Feedbacks", "Index", "Feedback")</li>
<li>@Html.ActionLink("Resources", "Index", "Resource")</li>
<li>@Html.ActionLink("Reports", "Index", "Report")</li>
</ul>
Conclusion
With these steps, you have created a dashboard page that consolidates data from various models in your ASP.NET MVC application. The dashboard displays the total counts of users, roles, courses, enrollments, feedbacks, resources, and reports, providing a quick overview of the project's status. You can further enhance the dashboard by adding charts, graphs, or other visual elements to represent the data more effectively.
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