Project Introduction
The Event Management System is designed to facilitate the planning, organization, and execution of events. Built using ASP.NET and SQL Server, this application aims to provide a comprehensive solution for event organizers to manage various aspects of events, including registrations, ticketing, vendor management, and marketing campaigns. The system will enhance the overall event experience for attendees while providing organizers with the tools they need to ensure successful events.
Project Objectives
- To create a user-friendly interface for event organizers and attendees to manage events and registrations.
- To implement a secure user authentication system for managing user accounts and roles.
- To manage event details, including descriptions, dates, and venues.
- To facilitate user registrations for events and track their status.
- To handle ticketing, including different ticket types and pricing.
- To manage notifications for users regarding event updates and important information.
- To maintain vendor information for event services and supplies.
- To create and manage marketing campaigns to promote events.
- To collect feedback from attendees to improve future events.
- To generate attendance and financial reports for event analysis and decision-making.
- To track performance metrics for evaluating the success of events.
Project Modules
- User Management Module: Handles user registration, login, and role management.
- Event Management Module: Manages event creation, updates, and details.
- Venue Management Module: Facilitates the management of venues for events.
- Registration Management Module: Handles user registrations for events and tracks their status.
- Ticket Management Module: Manages ticket types, pricing, and sales.
- Notification Management Module: Sends notifications to users regarding event updates.
- Vendor Management Module: Manages vendor information and contact details.
- Marketing Campaign Management Module: Creates and manages marketing campaigns for events.
- Feedback Management Module: Collects and manages feedback from event attendees.
- Attendance Reporting Module: Generates reports on total attendees for each event.
- Financial Reporting Module: Tracks revenue and expenses for events.
- Performance Metrics Module: Evaluates event success through performance metrics.
SQL Server Database Tables
-- Users Table
CREATE TABLE Users (
UserId INT PRIMARY KEY IDENTITY(1,1),
Username NVARCHAR(50) NOT NULL UNIQUE,
PasswordHash NVARCHAR(255) NOT NULL,
Email NVARCHAR(100) NOT NULL UNIQUE,
Phone NVARCHAR(15),
RoleId INT,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (RoleId) REFERENCES Roles(RoleId)
);
-- Roles Table
CREATE TABLE Roles (
RoleId INT PRIMARY KEY IDENTITY(1,1),
RoleName NVARCHAR(50) NOT NULL UNIQUE
);
-- Events Table
CREATE TABLE Events (
EventId INT PRIMARY KEY IDENTITY(1,1),
EventName NVARCHAR(100) NOT NULL,
Description NVARCHAR(MAX),
StartDate DATETIME NOT NULL,
EndDate DATETIME NOT NULL,
VenueId INT,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (VenueId) REFERENCES Venues(VenueId)
);
-- Venues Table
CREATE TABLE Venues (
VenueId INT PRIMARY KEY IDENTITY(1,1),
VenueName NVARCHAR(100) NOT NULL,
Address NVARCHAR(255) NOT NULL,
Capacity INT,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE()
);
-- Registrations Table
CREATE TABLE Registrations (
RegistrationId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
EventId INT,
RegistrationDate DATETIME DEFAULT GETDATE(),
Status NVARCHAR(20) DEFAULT 'Registered', -- e.g., Registered, Cancelled
FOREIGN KEY (User Id) REFERENCES Users(UserId),
FOREIGN KEY (EventId) REFERENCES Events(EventId)
);
-- Tickets Table
CREATE TABLE Tickets (
TicketId INT PRIMARY KEY IDENTITY(1,1),
RegistrationId INT,
TicketType NVARCHAR(50), -- e.g., Regular, VIP
Price DECIMAL(10, 2) NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (RegistrationId) REFERENCES Registrations(RegistrationId)
);
-- Notifications Table
CREATE TABLE Notifications (
NotificationId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
Message NVARCHAR(MAX),
IsRead BIT DEFAULT 0,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- Vendors Table
CREATE TABLE Vendors (
VendorId INT PRIMARY KEY IDENTITY(1,1),
VendorName NVARCHAR(100) NOT NULL,
ContactPerson NVARCHAR(100),
Phone NVARCHAR(15),
Email NVARCHAR(100),
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE()
);
-- MarketingCampaigns Table
CREATE TABLE MarketingCampaigns (
CampaignId INT PRIMARY KEY IDENTITY(1,1),
CampaignName NVARCHAR(100) NOT NULL,
StartDate DATETIME,
EndDate DATETIME,
Budget DECIMAL(10, 2),
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE()
);
-- Feedback Table
CREATE TABLE Feedbacks (
FeedbackId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
EventId INT,
Comments NVARCHAR(MAX),
Rating INT CHECK (Rating >= 1 AND Rating <= 5),
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId),
FOREIGN KEY (EventId) REFERENCES Events(EventId)
);
-- AttendanceReports Table
CREATE TABLE AttendanceReports (
ReportId INT PRIMARY KEY IDENTITY(1,1),
EventId INT,
TotalAttendees INT,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (EventId) REFERENCES Events(EventId)
);
-- FinancialReports Table
CREATE TABLE FinancialReports (
FinancialReportId INT PRIMARY KEY IDENTITY(1,1),
EventId INT,
TotalRevenue DECIMAL(10, 2),
TotalExpenses DECIMAL(10, 2),
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (EventId) REFERENCES Events(EventId)
);
-- PerformanceMetrics Table
CREATE TABLE PerformanceMetrics (
MetricId INT PRIMARY KEY IDENTITY(1,1),
EventId INT,
MetricName NVARCHAR(100),
MetricValue DECIMAL(10, 2),
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (EventId) REFERENCES Events(EventId)
);
Explanation of Tables
Users: Stores user information, including credentials and roles.
Roles: Defines different roles within the system (e.g., admin, organizer, attendee).
Events: Contains details about the events, including descriptions, start and end dates, and associated venues.
Venues: Manages venue information, including name, address, and capacity.
Registrations: Records user registrations for events, along with their status.
Tickets: Tracks ticket information related to registrations, including types and prices.
Notifications: Manages notifications sent to users, tracking whether they have been read.
Vendors: Stores information about vendors involved in the events, including contact details.
MarketingCampaigns: Contains details about marketing campaigns for events, including budgets and timelines.
Feedback: Collects feedback from users regarding events, including ratings and comments.
AttendanceReports: Records attendance data for events, including total attendees.
FinancialReports: Manages financial data related to events, including revenue and expenses.
PerformanceMetrics: Tracks performance metrics for events, allowing for analysis of success factors.
Creating Model and Repository Pattern
To create a model and repository pattern using ADO.NET for the provided SQL Server database schema in an ASP.NET application, we will follow these steps:
Step 1: Create Model Classes
Here are the model classes for the tables defined in your SQL schema:
public class User
{
public int UserId { get; set; }
public string Username { get; set; }
public string PasswordHash { get; set; }
public string Email { get; set; }
public string Phone { get; set; }
public int? RoleId { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Role
{
public int RoleId { get; set; }
public string RoleName { get; set; }
}
public class Course
{
public int CourseId { get; set; }
public string CourseName { get; set; }
public string Description { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Syllabus
{
public int SyllabusId { get; set; }
public int CourseId { get; set; }
public string Topic { get; set; }
public string Description { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Schedule
{
public int ScheduleId { get; set; }
public int CourseId { get; set; }
public DateTime StartDate { get; set; }
public DateTime EndDate { get; set; }
public string Location { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Enrollment
{
public int EnrollmentId { get; set; }
public int UserId { get; set; }
public int CourseId { get; set; }
public DateTime EnrollmentDate { get; set; }
public string Status { get; set; }
}
public class Attendance
{
public int AttendanceId { get; set; }
public int EnrollmentId { get; set; }
public int ScheduleId { get; set; }
public bool Attended { get; set; }
public DateTime CreatedAt { get; set; }
}
public class Assessment
{
public int AssessmentId { get; set; }
public int CourseId { get; set; }
public string AssessmentType { get; set; }
public int TotalMarks { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Payment
{
public int PaymentId { get; set; }
public int UserId { get; set; }
public int CourseId { get; set; }
public decimal Amount { get; set; }
public DateTime PaymentDate { get; set; }
public string PaymentMethod { get; set; }
public string Status { get; set; }
}
public class Feedback
{
public int FeedbackId { get; set; }
public int UserId { get; set; }
public int CourseId { get; set; }
public string Comments { get; set; }
public int Rating { get; set; }
public DateTime CreatedAt { get; set; }
}
public class Report
{
public int ReportId { get; set; }
public int UserId { get; set; }
public int CourseId { get; set; }
public DateTime ReportDate { get; set; }
public string Description { get; set; }
public DateTime CreatedAt { get; set; }
}
public class Resource
{
public int ResourceId { get; set; }
public int CourseId { get; set; }
public string ResourceType { get; set; }
public string ResourceUrl { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Notification
{
public int NotificationId { get; set; }
public int UserId { get; set; }
public string Message { get; set; }
public bool IsRead { get; set; }
public DateTime CreatedAt { get; set; }
}
Step 2: Create Repository Interfaces
Define interfaces for the repositories. Here’s an example for the User repository:
public interface IUserRepository
{
User GetUser ById(int userId);
IEnumerable<User> GetAllUsers();
void AddUser (User user);
void UpdateUser (User user);
void DeleteUser (int userId);
}
You would create similar interfaces for other entities (e.g., ICourseRepository, IRoleRepository, etc.).
Step 3: Implement Repository Classes
Here’s an example implementation of the User Repository using ADO.NET:
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
public class UserRepository : IUserRepository
{
private readonly string _connectionString;
public UserRepository(string connectionString)
{
_connectionString = connectionString;
}
public User GetUser ById(int userId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Users WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", userId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new User
{
UserId = (int)reader["User Id"],
Username = reader["Username"].ToString(),
PasswordHash = reader["PasswordHash"].ToString(),
Email = reader["Email"].ToString(),
Phone = reader["Phone"]?.ToString(),
RoleId = reader["RoleId"] as int?,
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<User> GetAllUsers()
{
var users = new List<User>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Users", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
users.Add(new User
{
UserId = (int)reader["User Id"],
Username = reader["Username"].ToString(),
PasswordHash = reader["PasswordHash"].ToString(),
Email = reader["Email"].ToString(),
Phone = reader["Phone"]?.ToString(),
RoleId = reader["RoleId"] as int?,
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return users;
}
public void AddUser (User user)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Users (Username, PasswordHash, Email, Phone, RoleId) VALUES (@Username, @PasswordHash, @Email, @Phone, @RoleId)", connection);
command.Parameters.AddWithValue("@Username", user.Username);
command.Parameters.AddWithValue("@PasswordHash", user.PasswordHash);
command.Parameters.AddWithValue("@Email", user.Email);
command.Parameters.AddWithValue("@Phone", (object)user.Phone ?? DBNull.Value);
command.Parameters.AddWithValue("@RoleId", (object)user.RoleId ?? DBNull.Value);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateUser (User user)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Users SET Username = @Username, PasswordHash = @PasswordHash, Email = @Email, Phone = @Phone, RoleId = @RoleId, UpdatedAt = GETDATE() WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", user.UserId);
command.Parameters.AddWithValue("@Username", user.Username);
command.Parameters.AddWithValue("@PasswordHash", user.PasswordHash);
command.Parameters.AddWithValue("@Email", user.Email);
command.Parameters.AddWithValue("@Phone", (object)user.Phone ?? DBNull.Value);
command.Parameters.AddWithValue("@RoleId", (object)user.RoleId ?? DBNull.Value);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteUser (int userId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Users WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", userId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
This pattern can be replicated for other entities by creating their respective repository interfaces and classes, ensuring that each repository handles its specific data operations using ADO.NET.
Repository Interfaces and Implementations
Sure! Below are the repository interfaces and implementations for the remaining models based on the SQL schema you provided. Each repository will follow a similar pattern to the User Repository example.
1. Role Repository
Interface:
public interface IRoleRepository
{
Role GetRoleById(int roleId);
IEnumerable<Role> GetAllRoles();
void AddRole(Role role);
void UpdateRole(Role role);
void DeleteRole(int roleId);
}
Implementation:
public class RoleRepository : IRoleRepository
{
private readonly string _connectionString;
public RoleRepository(string connectionString)
{
_connectionString = connectionString;
}
public Role GetRoleById(int roleId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Roles WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", roleId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Role
{
RoleId = (int)reader["RoleId"],
RoleName = reader["RoleName"].ToString()
};
}
}
}
return null;
}
public IEnumerable<Role> GetAllRoles()
{
var roles = new List<Role>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Roles", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
roles.Add(new Role
{
RoleId = (int)reader["RoleId"],
RoleName = reader["RoleName"].ToString()
});
}
}
}
return roles;
}
public void AddRole(Role role)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Roles (RoleName) VALUES (@RoleName)", connection);
command.Parameters.AddWithValue("@RoleName", role.RoleName);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateRole(Role role)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Roles SET RoleName = @RoleName WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", role.RoleId);
command.Parameters.AddWithValue("@RoleName", role.RoleName);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteRole(int roleId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Roles WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", roleId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
2. Course Repository
Interface:
public interface ICourseRepository
{
Course GetCourseById(int courseId);
IEnumerable<Course> GetAllCourses();
void AddCourse(Course course);
void UpdateCourse(Course course);
void DeleteCourse(int courseId);
}
Implementation:
public class CourseRepository : ICourseRepository
{
private readonly string _connectionString;
public CourseRepository(string connectionString)
{
_connectionString = connectionString;
}
public Course GetCourseById(int courseId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Courses WHERE CourseId = @CourseId", connection);
command.Parameters.AddWithValue("@CourseId", courseId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Course
{
CourseId = (int)reader["CourseId"],
CourseName = reader["CourseName"].ToString(),
Description = reader["Description"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Course> GetAllCourses()
{
var courses = new List<Course>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Courses", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
courses.Add(new Course
{
CourseId = (int)reader["CourseId"],
CourseName = reader["CourseName"].ToString(),
Description = reader["Description"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return courses;
}
public void AddCourse(Course course)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Courses (CourseName, Description) VALUES (@CourseName, @Description)", connection);
command.Parameters.AddWithValue("@CourseName", course.CourseName);
command.Parameters.AddWithValue("@Description", course.Description);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateCourse(Course course)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Courses SET CourseName = @CourseName, Description = @Description, UpdatedAt = GETDATE() WHERE CourseId = @CourseId", connection);
command.Parameters.AddWithValue("@CourseId", course.CourseId);
command.Parameters.AddWithValue("@CourseName", course.CourseName);
command.Parameters.AddWithValue("@Description", course.Description);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteCourse(int courseId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Courses WHERE CourseId = @CourseId", connection);
command.Parameters.AddWithValue("@CourseId", courseId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
3. Syllabus Repository
Interface:
public interface ISyllabusRepository
{
Syllabus GetSyllabusById(int syllabusId);
IEnumerable<Syllabus> GetAllSyllabuses();
void AddSyllabus(Syllabus syllabus);
void UpdateSyllabus(Syllabus syllabus);
void DeleteSyllabus(int syllabusId);
}
Implementation:
public class SyllabusRepository : ISyllabusRepository
{
private readonly string _connectionString;
public SyllabusRepository(string connectionString)
{
_connectionString = connectionString;
}
public Syllabus GetSyllabusById(int syllabusId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Syllabuses WHERE SyllabusId = @SyllabusId", connection);
command.Parameters.AddWithValue("@SyllabusId", syllabusId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Syllabus
{
SyllabusId = (int)reader["SyllabusId"],
CourseId = (int)reader["CourseId"],
Topic = reader["Topic"].ToString(),
Description = reader["Description"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Syllabus> GetAllSyllabuses()
{
var syllabuses = new List<Syllabus>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Syllabuses", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
syllabuses.Add(new Syllabus
{
SyllabusId = (int)reader["SyllabusId"],
CourseId = (int)reader["CourseId"],
Topic = reader["Topic"].ToString(),
Description = reader["Description"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return syllabuses;
}
public void AddSyllabus(Syllabus syllabus)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Syllabuses (CourseId, Topic, Description) VALUES (@CourseId, @Topic, @Description)", connection);
command.Parameters.AddWithValue("@CourseId", syllabus.CourseId);
command.Parameters.AddWithValue("@Topic", syllabus.Topic);
command.Parameters.AddWithValue("@Description", syllabus.Description);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateSyllabus(Syllabus syllabus)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Syllabuses SET CourseId = @CourseId, Topic = @Topic, Description = @Description, UpdatedAt = GETDATE() WHERE SyllabusId = @SyllabusId", connection);
command.Parameters.AddWithValue("@SyllabusId", syllabus.SyllabusId);
command.Parameters.AddWithValue("@CourseId", syllabus.CourseId);
command.Parameters.AddWithValue("@Topic", syllabus.Topic);
command.Parameters.AddWithValue("@Description", syllabus.Description);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteSyllabus(int syllabusId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Syllabuses WHERE SyllabusId = @SyllabusId", connection);
command.Parameters.AddWithValue("@SyllabusId", syllabusId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
4. Schedule Repository
Interface:
public interface IScheduleRepository
{
Schedule GetScheduleById(int scheduleId);
IEnumerable<Schedule> GetAllSchedules();
void AddSchedule(Schedule schedule);
void UpdateSchedule(Schedule schedule);
void DeleteSchedule(int scheduleId);
}
Implementation:
public class ScheduleRepository : IScheduleRepository
{
private readonly string _connectionString;
public ScheduleRepository(string connectionString)
{
_connectionString = connectionString;
}
public Schedule GetScheduleById(int scheduleId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Schedules WHERE ScheduleId = @ScheduleId", connection);
command.Parameters.AddWithValue("@ScheduleId", scheduleId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Schedule
{
ScheduleId = (int)reader["ScheduleId"],
CourseId = (int)reader["CourseId"],
StartDate = (DateTime)reader["Start Date"],
EndDate = (DateTime)reader["EndDate"],
Location = reader["Location"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Schedule> GetAllSchedules()
{
var schedules = new List<Schedule>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Schedules", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
schedules.Add(new Schedule
{
ScheduleId = (int)reader["ScheduleId"],
CourseId = (int)reader["CourseId"],
StartDate = (DateTime)reader["StartDate"],
EndDate = (DateTime)reader["EndDate"],
Location = reader["Location"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return schedules;
}
public void AddSchedule(Schedule schedule)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Schedules (CourseId, StartDate, EndDate, Location) VALUES (@CourseId, @StartDate, @EndDate, @Location)", connection);
command.Parameters.AddWithValue("@CourseId", schedule.CourseId);
command.Parameters.AddWithValue("@StartDate", schedule.StartDate);
command.Parameters.AddWithValue("@EndDate", schedule.EndDate);
command.Parameters.AddWithValue("@Location", schedule.Location);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateSchedule(Schedule schedule)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Schedules SET CourseId = @CourseId, StartDate = @StartDate, EndDate = @EndDate, Location = @Location, UpdatedAt = GETDATE() WHERE ScheduleId = @ScheduleId", connection);
command.Parameters.AddWithValue("@ScheduleId", schedule.ScheduleId);
command.Parameters.AddWithValue("@CourseId", schedule.CourseId);
command.Parameters.AddWithValue("@StartDate", schedule.StartDate);
command.Parameters.AddWithValue("@EndDate", schedule.EndDate);
command.Parameters.AddWithValue("@Location", schedule.Location);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteSchedule(int scheduleId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Schedules WHERE ScheduleId = @ScheduleId", connection);
command.Parameters.AddWithValue("@ScheduleId", scheduleId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
5. Enrollment Repository
Interface:
public interface IEnrollmentRepository
{
Enrollment GetEnrollmentById(int enrollmentId);
IEnumerable<Enrollment> GetAllEnrollments();
void AddEnrollment(Enrollment enrollment);
void UpdateEnrollment(Enrollment enrollment);
void DeleteEnrollment(int enrollmentId);
}
Implementation:
public class EnrollmentRepository : IEnrollmentRepository
{
private readonly string _connectionString;
public EnrollmentRepository(string connectionString)
{
_connectionString = connectionString;
}
public Enrollment GetEnrollmentById(int enrollmentId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Enrollments WHERE EnrollmentId = @EnrollmentId", connection);
command.Parameters.AddWithValue("@EnrollmentId", enrollmentId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Enrollment
{
EnrollmentId = (int)reader["EnrollmentId"],
UserId = (int)reader["User Id"],
CourseId = (int)reader["CourseId"],
EnrollmentDate = (DateTime)reader["EnrollmentDate"],
Status = reader["Status"].ToString()
};
}
}
}
return null;
}
public IEnumerable<Enrollment> GetAllEnrollments()
{
var enrollments = new List<Enrollment>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Enrollments", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
enrollments.Add(new Enrollment
{
EnrollmentId = (int)reader["EnrollmentId"],
UserId = (int)reader["User Id"],
CourseId = (int)reader["CourseId"],
EnrollmentDate = (DateTime)reader["EnrollmentDate"],
Status = reader["Status"].ToString()
});
}
}
}
return enrollments;
}
public void AddEnrollment(Enrollment enrollment)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Enrollments (User Id, CourseId, EnrollmentDate, Status) VALUES (@User Id, @CourseId, GETDATE(), @Status)", connection);
command.Parameters.AddWithValue("@User Id", enrollment.UserId);
command.Parameters.AddWithValue("@CourseId", enrollment.CourseId);
command.Parameters.AddWithValue("@Status", enrollment.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateEnrollment(Enrollment enrollment)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Enrollments SET UserId = @User Id, CourseId = @CourseId, Status = @Status WHERE EnrollmentId = @EnrollmentId", connection);
command.Parameters.AddWithValue("@EnrollmentId", enrollment.EnrollmentId);
command.Parameters.AddWithValue("@User Id", enrollment.UserId);
command.Parameters.AddWithValue("@CourseId", enrollment.CourseId);
command.Parameters.AddWithValue("@Status", enrollment.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteEnrollment(int enrollmentId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Enrollments WHERE EnrollmentId = @EnrollmentId", connection);
command.Parameters.AddWithValue("@EnrollmentId", enrollmentId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
6. Attendance Repository
Interface:
public interface IAttendanceRepository
{
Attendance GetAttendanceById(int attendanceId);
IEnumerable<Attendance> GetAllAttendances();
void AddAttendance(Attendance attendance);
void UpdateAttendance(Attendance attendance);
void DeleteAttendance(int attendanceId);
}
Implementation:
public class AttendanceRepository : IAttendanceRepository
{
private readonly string _connectionString;
public AttendanceRepository(string connectionString)
{
_connectionString = connectionString;
}
public Attendance GetAttendanceById(int attendanceId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Attendance WHERE AttendanceId = @AttendanceId", connection);
command.Parameters.AddWithValue("@AttendanceId", attendanceId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Attendance
{
AttendanceId = (int)reader["AttendanceId"],
EnrollmentId = (int)reader["EnrollmentId"],
ScheduleId = (int)reader["ScheduleId"],
Attended = (bool)reader["Attended"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Attendance> GetAllAttendances()
{
var attendances = new List<Attendance>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Attendance", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
attendances.Add(new Attendance
{
AttendanceId = (int)reader["AttendanceId"],
EnrollmentId = (int)reader["EnrollmentId"],
ScheduleId = (int)reader["ScheduleId"],
Attended = (bool)reader["Attended"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return attendances;
}
public void AddAttendance(Attendance attendance)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Attendance (EnrollmentId, ScheduleId, Attended, CreatedAt) VALUES (@EnrollmentId, @ScheduleId, @Attended, GETDATE())", connection);
command.Parameters.AddWithValue("@EnrollmentId", attendance.EnrollmentId);
command.Parameters.AddWithValue("@ScheduleId", attendance.ScheduleId);
command.Parameters.AddWithValue("@Attended", attendance.Attended);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateAttendance(Attendance attendance)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Attendance SET EnrollmentId = @EnrollmentId, ScheduleId = @ScheduleId, Attended = @Attended WHERE AttendanceId = @AttendanceId", connection);
command.Parameters.AddWithValue("@AttendanceId", attendance.AttendanceId);
command.Parameters.AddWithValue("@EnrollmentId", attendance.EnrollmentId);
command.Parameters.AddWithValue("@ScheduleId", attendance.ScheduleId);
command.Parameters.AddWithValue("@Attended", attendance.Attended);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteAttendance(int attendanceId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Attendance WHERE AttendanceId = @AttendanceId", connection);
command.Parameters.AddWithValue("@AttendanceId", attendanceId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
7. Assessment Repository
Interface:
public interface IAssessmentRepository
{
Assessment GetAssessmentById(int assessmentId);
IEnumerable<Assessment> GetAllAssessments();
void AddAssessment(Assessment assessment);
void UpdateAssessment(Assessment assessment);
void DeleteAssessment(int assessmentId);
}
Implementation:
public class AssessmentRepository : IAssessmentRepository
{
private readonly string _connectionString;
public AssessmentRepository(string connectionString)
{
_connectionString = connectionString;
}
public Assessment GetAssessmentById(int assessmentId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Assessments WHERE AssessmentId = @AssessmentId", connection);
command.Parameters.AddWithValue("@AssessmentId", assessmentId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Assessment
{
AssessmentId = (int)reader["AssessmentId"],
CourseId = (int)reader["CourseId"],
AssessmentType = reader["AssessmentType"].ToString(),
TotalMarks = (int)reader["TotalMarks"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Assessment> GetAllAssessments()
{
var assessments = new List<Assessment>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Assessments", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
assessments.Add(new Assessment
{
AssessmentId = (int)reader["AssessmentId"],
CourseId = (int)reader["CourseId"],
AssessmentType = reader["AssessmentType"].ToString(),
TotalMarks = (int)reader["TotalMarks"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return assessments;
}
public void AddAssessment(Assessment assessment)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Assessments (CourseId, AssessmentType, TotalMarks) VALUES (@CourseId, @AssessmentType, @TotalMarks)", connection);
command.Parameters.AddWithValue("@CourseId", assessment.CourseId);
command.Parameters.AddWithValue("@AssessmentType", assessment.AssessmentType);
command.Parameters.AddWithValue("@TotalMarks", assessment.TotalMarks);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateAssessment(Assessment assessment)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Assessments SET CourseId = @CourseId, AssessmentType = @AssessmentType, TotalMarks = @TotalMarks, UpdatedAt = GETDATE() WHERE AssessmentId = @AssessmentId", connection);
command.Parameters.AddWithValue("@AssessmentId", assessment.AssessmentId);
command.Parameters.AddWithValue("@CourseId", assessment.CourseId);
command.Parameters.AddWithValue("@AssessmentType", assessment.AssessmentType);
command.Parameters.AddWithValue("@TotalMarks", assessment.TotalMarks);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteAssessment(int assessmentId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Assessments WHERE AssessmentId = @AssessmentId", connection);
command.Parameters.AddWithValue("@AssessmentId", assessmentId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
8. Payment Repository
Interface:
public interface IPaymentRepository
{
Payment GetPaymentById(int paymentId);
IEnumerable<Payment> GetAllPayments();
void AddPayment(Payment payment);
void UpdatePayment(Payment payment);
void Delete Payment(int paymentId);
}
Implementation:
public class PaymentRepository : IPaymentRepository
{
private readonly string _connectionString;
public PaymentRepository(string connectionString)
{
_connectionString = connectionString;
}
public Payment GetPaymentById(int paymentId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Payments WHERE PaymentId = @PaymentId", connection);
command.Parameters.AddWithValue("@PaymentId", paymentId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Payment
{
PaymentId = (int)reader["PaymentId"],
UserId = (int)reader["User Id"],
CourseId = (int)reader["CourseId"],
Amount = (decimal)reader["Amount"],
PaymentDate = (DateTime)reader["PaymentDate"],
PaymentMethod = reader["PaymentMethod"].ToString(),
Status = reader["Status"].ToString()
};
}
}
}
return null;
}
public IEnumerable<Payment> GetAllPayments()
{
var payments = new List<Payment>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Payments", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
payments.Add(new Payment
{
PaymentId = (int)reader["PaymentId"],
UserId = (int)reader["User Id"],
CourseId = (int)reader["CourseId"],
Amount = (decimal)reader["Amount"],
PaymentDate = (DateTime)reader["PaymentDate"],
PaymentMethod = reader["PaymentMethod"].ToString(),
Status = reader["Status"].ToString()
});
}
}
}
return payments;
}
public void AddPayment(Payment payment)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Payments (User Id, CourseId, Amount, PaymentDate, PaymentMethod, Status) VALUES (@User Id, @CourseId, @Amount, GETDATE(), @PaymentMethod, @Status)", connection);
command.Parameters.AddWithValue("@User Id", payment.UserId);
command.Parameters.AddWithValue("@CourseId", payment.CourseId);
command.Parameters.AddWithValue("@Amount", payment.Amount);
command.Parameters.AddWithValue("@PaymentMethod", payment.PaymentMethod);
command.Parameters.AddWithValue("@Status", payment.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdatePayment(Payment payment)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Payments SET UserId = @User Id, CourseId = @CourseId, Amount = @Amount, PaymentMethod = @PaymentMethod, Status = @Status WHERE PaymentId = @PaymentId", connection);
command.Parameters.AddWithValue("@PaymentId", payment.PaymentId);
command.Parameters.AddWithValue("@User Id", payment.UserId);
command.Parameters.AddWithValue("@CourseId", payment.CourseId);
command.Parameters.AddWithValue("@Amount", payment.Amount);
command.Parameters.AddWithValue("@PaymentMethod", payment.PaymentMethod);
command.Parameters.AddWithValue("@Status", payment.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeletePayment(int paymentId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Payments WHERE PaymentId = @PaymentId", connection);
command.Parameters.AddWithValue("@PaymentId", paymentId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
9. Feedback Repository
Interface:
public interface IFeedbackRepository
{
Feedback GetFeedbackById(int feedbackId);
IEnumerable<Feedback> GetAllFeedbacks();
void AddFeedback(Feedback feedback);
void UpdateFeedback(Feedback feedback);
void DeleteFeedback(int feedbackId);
}
Implementation:
public class FeedbackRepository : IFeedbackRepository
{
private readonly string _connectionString;
public FeedbackRepository(string connectionString)
{
_connectionString = connectionString;
}
public Feedback GetFeedbackById(int feedbackId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Feedbacks WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@FeedbackId", feedbackId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Feedback
{
FeedbackId = (int)reader["FeedbackId"],
UserId = (int)reader["User Id"],
CourseId = (int)reader["CourseId"],
Comments = reader["Comments"].ToString(),
Rating = (int)reader["Rating"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Feedback> GetAllFeedbacks()
{
var feedbacks = new List<Feedback>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Feedbacks", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
feedbacks.Add(new Feedback
{
FeedbackId = (int)reader["FeedbackId"],
UserId = (int)reader["User Id"],
CourseId = (int)reader["CourseId"],
Comments = reader["Comments"].ToString(),
Rating = (int)reader["Rating"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return feedbacks;
}
public void AddFeedback(Feedback feedback)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Feedbacks (User Id, CourseId, Comments, Rating, CreatedAt) VALUES (@User Id, @CourseId, @Comments, @Rating, GETDATE())", connection);
command.Parameters.AddWithValue("@User Id", feedback.UserId);
command.Parameters.AddWithValue("@CourseId", feedback.CourseId);
command.Parameters.AddWithValue("@Comments", feedback.Comments);
command.Parameters.AddWithValue("@Rating", feedback.Rating);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateFeedback(Feedback feedback)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Feedbacks SET UserId = @User Id, CourseId = @CourseId, Comments = @Comments, Rating = @Rating WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@FeedbackId", feedback.FeedbackId);
command.Parameters.AddWithValue("@User Id", feedback.UserId);
command.Parameters.AddWithValue("@CourseId", feedback.CourseId);
command.Parameters.AddWithValue("@Comments", feedback.Comments);
command.Parameters.AddWithValue("@Rating", feedback.Rating);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteFeedback(int feedbackId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Feedbacks WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@FeedbackId", feedbackId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
10. Report Repository
Interface:
public interface IReportRepository
{
Report GetReportById(int reportId);
IEnumerable<Report> GetAllReports();
void AddReport(Report report);
void UpdateReport(Report report);
void DeleteReport(int reportId);
}
Implementation:
public class ReportRepository : IReportRepository
{
private readonly string _connectionString;
public ReportRepository(string connectionString)
{
_connectionString = connectionString;
}
public Report GetReportById(int reportId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Reports WHERE ReportId = @ReportId", connection);
command.Parameters.AddWithValue("@ReportId", reportId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Report
{
ReportId = (int)reader["ReportId"],
UserId = (int)reader["User Id"],
CourseId = (int)reader["CourseId"],
ReportDate = (DateTime)reader["ReportDate"],
Description = reader["Description"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Report> GetAllReports()
{
var reports = new List<Report>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Reports", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
reports.Add(new Report
{
ReportId = (int)reader ["ReportId"],
UserId = (int)reader["User Id"],
CourseId = (int)reader["CourseId"],
ReportDate = (DateTime)reader["ReportDate"],
Description = reader["Description"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return reports;
}
public void AddReport(Report report)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Reports (User Id, CourseId, ReportDate, Description, CreatedAt) VALUES (@User Id, @CourseId, GETDATE(), @Description, GETDATE())", connection);
command.Parameters.AddWithValue("@User Id", report.UserId);
command.Parameters.AddWithValue("@CourseId", report.CourseId);
command.Parameters.AddWithValue("@Description", report.Description);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateReport(Report report)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Reports SET UserId = @User Id, CourseId = @CourseId, Description = @Description WHERE ReportId = @ReportId", connection);
command.Parameters.AddWithValue("@ReportId", report.ReportId);
command.Parameters.AddWithValue("@User Id", report.UserId);
command.Parameters.AddWithValue("@CourseId", report.CourseId);
command.Parameters.AddWithValue("@Description", report.Description);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteReport(int reportId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Reports WHERE ReportId = @ReportId", connection);
command.Parameters.AddWithValue("@ReportId", reportId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
11. Resource Repository
Interface:
public interface IResourceRepository
{
Resource GetResourceById(int resourceId);
IEnumerable<Resource> GetAllResources();
void AddResource(Resource resource);
void UpdateResource(Resource resource);
void DeleteResource(int resourceId);
}
Implementation:
public class ResourceRepository : IResourceRepository
{
private readonly string _connectionString;
public ResourceRepository(string connectionString)
{
_connectionString = connectionString;
}
public Resource GetResourceById(int resourceId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Resources WHERE ResourceId = @ResourceId", connection);
command.Parameters.AddWithValue("@ResourceId", resourceId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Resource
{
ResourceId = (int)reader["ResourceId"],
CourseId = (int)reader["CourseId"],
ResourceType = reader["ResourceType"].ToString(),
ResourceUrl = reader["ResourceUrl"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Resource> GetAllResources()
{
var resources = new List<Resource>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Resources", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
resources.Add(new Resource
{
ResourceId = (int)reader["ResourceId"],
CourseId = (int)reader["CourseId"],
ResourceType = reader["ResourceType"].ToString(),
ResourceUrl = reader["ResourceUrl"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return resources;
}
public void AddResource(Resource resource)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Resources (CourseId, ResourceType, ResourceUrl) VALUES (@CourseId, @ResourceType, @ResourceUrl)", connection);
command.Parameters.AddWithValue("@CourseId", resource.CourseId);
command.Parameters.AddWithValue("@ResourceType", resource.ResourceType);
command.Parameters.AddWithValue("@ResourceUrl", resource.ResourceUrl);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateResource(Resource resource)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Resources SET CourseId = @CourseId, ResourceType = @ResourceType, ResourceUrl = @ResourceUrl, UpdatedAt = GETDATE() WHERE ResourceId = @ResourceId", connection);
command.Parameters.AddWithValue("@ResourceId", resource.ResourceId);
command.Parameters.AddWithValue("@CourseId", resource.CourseId);
command.Parameters.AddWithValue("@ResourceType", resource.ResourceType);
command.Parameters.AddWithValue("@ResourceUrl", resource.ResourceUrl);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteResource(int resourceId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Resources WHERE ResourceId = @ResourceId", connection);
command.Parameters.AddWithValue("@ResourceId", resourceId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
12. Notification Repository
Interface:
public interface INotificationRepository
{
Notification GetNotificationById(int notificationId);
IEnumerable<Notification> GetAllNotifications();
void AddNotification(Notification notification);
void UpdateNotification(Notification notification);
void DeleteNotification(int notificationId);
}
Implementation:
public class NotificationRepository : INotificationRepository
{
private readonly string _connectionString;
public NotificationRepository(string connectionString)
{
_connectionString = connectionString;
}
public Notification GetNotificationById(int notificationId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Notifications WHERE NotificationId = @NotificationId", connection);
command.Parameters.AddWithValue("@NotificationId", notificationId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Notification
{
NotificationId = (int)reader["NotificationId"],
UserId = (int)reader["User Id"],
Message = reader["Message"].ToString(),
IsRead = (bool)reader["IsRead"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Notification> GetAllNotifications()
{
var notifications = new List<Notification>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Notifications", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
notifications.Add(new Notification
{
NotificationId = (int)reader["NotificationId"],
UserId = (int)reader["User Id"],
Message = reader["Message"].ToString(),
IsRead = (bool)reader["IsRead"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return notifications;
}
public void AddNotification(Notification notification)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Notifications (User Id, Message, IsRead) VALUES (@User Id, @Message, @IsRead)", connection);
command.Parameters.AddWithValue("@User Id", notification.UserId);
command.Parameters.AddWithValue("@Message", notification.Message);
command.Parameters.AddWithValue("@IsRead", notification.IsRead);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateNotification(Notification notification)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Notifications SET UserId = @User Id, Message = @Message, IsRead = @IsRead WHERE NotificationId = @NotificationId", connection);
command.Parameters.AddWithValue("@NotificationId", notification.NotificationId);
command.Parameters.AddWithValue("@User Id", notification.UserId);
command.Parameters.AddWithValue("@Message", notification.Message);
command.Parameters.AddWithValue("@IsRead", notification.IsRead);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteNotification(int notificationId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Notifications WHERE NotificationId = @NotificationId", connection);
command.Parameters.AddWithValue("@NotificationId", notificationId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Creating Controllers
This completes the repository implementations for all the models based on the SQL schema you provided. Each repository follows the same pattern, allowing for easy data access and manipulation using ADO.NET in your ASP.NET application.
To create controllers for each repository in an ASP.NET MVC application, we will follow the standard MVC pattern. Each controller will handle HTTP requests, interact with the corresponding repository, and return views or data as needed.
1. UserController
public class UserController : Controller
{
private readonly IUserRepository _userRepository;
public UserController(IUser Repository userRepository)
{
_userRepository = userRepository;
}
public IActionResult Index()
{
var users = _userRepository.GetAllUsers();
return View(users);
}
public IActionResult Details(int id)
{
var user = _userRepository.GetUser ById(id);
return View(user);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(User user)
{
if (ModelState.IsValid)
{
_userRepository.AddUser (user);
return RedirectToAction(nameof(Index));
}
return View(user);
}
public IActionResult Edit(int id)
{
var user = _userRepository.GetUser ById(id);
return View(user);
}
[HttpPost]
public IActionResult Edit(User user)
{
if (ModelState.IsValid)
{
_userRepository.UpdateUser (user);
return RedirectToAction(nameof(Index));
}
return View(user);
}
public IActionResult Delete(int id)
{
var user = _userRepository.GetUser ById(id);
return View(user);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_userRepository.DeleteUser (id);
return RedirectToAction(nameof(Index));
}
}
2. RoleController
public class RoleController : Controller
{
private readonly IRoleRepository _roleRepository;
public RoleController(IRoleRepository roleRepository)
{
_roleRepository = roleRepository;
}
public IActionResult Index()
{
var roles = _roleRepository.GetAllRoles();
return View(roles);
}
public IActionResult Details(int id)
{
var role = _roleRepository.GetRoleById(id);
return View(role);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Role role)
{
if (ModelState.IsValid)
{
_roleRepository.AddRole(role);
return RedirectToAction(nameof(Index));
}
return View(role);
}
public IActionResult Edit(int id)
{
var role = _roleRepository.GetRoleById(id);
return View(role);
}
[HttpPost]
public IActionResult Edit(Role role)
{
if (ModelState.IsValid)
{
_roleRepository.UpdateRole(role);
return RedirectToAction(nameof(Index));
}
return View(role);
}
public IActionResult Delete(int id)
{
var role = _roleRepository.GetRoleById(id);
return View(role);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_roleRepository.DeleteRole(id);
return RedirectToAction(nameof(Index));
}
}
3. CourseController
public class CourseController : Controller
{
private readonly ICourseRepository _courseRepository;
public CourseController(ICourseRepository courseRepository)
{
_courseRepository = courseRepository;
}
public IActionResult Index()
{
var courses = _courseRepository.GetAllCourses();
return View(courses);
}
public IActionResult Details(int id)
{
var course = _courseRepository.GetCourseById(id);
return View(course);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Course course)
{
if (ModelState.IsValid)
{
_courseRepository.AddCourse(course);
return RedirectToAction(nameof(Index));
}
return View(course);
}
public IActionResult Edit(int id)
{
var course = _courseRepository.GetCourseById(id);
return View(course);
}
[HttpPost]
public IActionResult Edit(Course course)
{
if (ModelState.IsValid)
{
_courseRepository.UpdateCourse(course);
return RedirectToAction(nameof(Index));
}
return View(course);
}
public IActionResult Delete(int id)
{
var course = _courseRepository.GetCourseById(id);
return View(course);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_courseRepository.DeleteCourse(id);
return RedirectToAction(nameof(Index));
}
}
4. SyllabusController
public class SyllabusController : Controller
{
private readonly ISyllabusRepository _syllabusRepository;
public SyllabusController(ISyllabusRepository syllabusRepository)
{
_syllabusRepository = syllabusRepository;
}
public IActionResult Index()
{
var syllabuses = _syllabusRepository.GetAllSyllabuses();
return View(syllabuses);
}
public IActionResult Details(int id)
{
var syllabus = _syllabusRepository.GetSyllabusById(id);
return View(syllabus);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Syllabus syllabus)
{
if (ModelState.IsValid)
{
_syllabusRepository.AddSyllabus(syllabus);
return RedirectToAction(nameof(Index));
}
return View(syllabus);
}
public IActionResult Edit(int id)
{
var syllabus = _syllabusRepository.GetSyllabusById(id);
return View(syllabus);
}
[HttpPost]
public IActionResult Edit(Syllabus syllabus)
{
if (ModelState.IsValid)
{
_syllabusRepository.UpdateSyllabus(syllabus);
return RedirectToAction(nameof(Index));
}
return View(syllabus);
}
public IActionResult Delete(int id)
{
var syllabus = _syllabusRepository.GetSyllabusById(id);
return View(syllabus);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_syllabusRepository.DeleteSyllabus(id);
return RedirectToAction(nameof(Index));
}
}
5. ScheduleController
csharp csharp public class ScheduleController : Controller { private readonly IScheduleRepository _scheduleRepository;
public ScheduleController(IScheduleRepository scheduleRepository)
{
_scheduleRepository = scheduleRepository;
}
public IActionResult Index()
{
var schedules = _scheduleRepository.GetAllSchedules();
return View(schedules);
}
public IActionResult Details(int id)
{
var schedule = _scheduleRepository.GetScheduleById(id);
return View(schedule);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Schedule schedule)
{
if (ModelState.IsValid)
{
_scheduleRepository.AddSchedule(schedule);
return RedirectToAction(nameof(Index));
}
return View(schedule);
}
public IActionResult Edit(int id)
{
var schedule = _scheduleRepository.GetScheduleById(id);
return View(schedule);
}
[HttpPost]
public IActionResult Edit(Schedule schedule)
{
if (ModelState.IsValid)
{
_scheduleRepository.UpdateSchedule(schedule);
return RedirectToAction(nameof(Index));
}
return View(schedule);
}
public IActionResult Delete(int id)
{
var schedule = _scheduleRepository.GetScheduleById(id);
return View(schedule);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_scheduleRepository.DeleteSchedule(id);
return RedirectToAction(nameof(Index));
}
}
6. EnrollmentController
public class EnrollmentController : Controller
{
private readonly IEnrollmentRepository _enrollmentRepository;
public EnrollmentController(IEnrollmentRepository enrollmentRepository)
{
_enrollmentRepository = enrollmentRepository;
}
public IActionResult Index()
{
var enrollments = _enrollmentRepository.GetAllEnrollments();
return View(enrollments);
}
public IActionResult Details(int id)
{
var enrollment = _enrollmentRepository.GetEnrollmentById(id);
return View(enrollment);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Enrollment enrollment)
{
if (ModelState.IsValid)
{
_enrollmentRepository.AddEnrollment(enrollment);
return RedirectToAction(nameof(Index));
}
return View(enrollment);
}
public IActionResult Edit(int id)
{
var enrollment = _enrollmentRepository.GetEnrollmentById(id);
return View(enrollment);
}
[HttpPost]
public IActionResult Edit(Enrollment enrollment)
{
if (ModelState.IsValid)
{
_enrollmentRepository.UpdateEnrollment(enrollment);
return RedirectToAction(nameof(Index));
}
return View(enrollment);
}
public IActionResult Delete(int id)
{
var enrollment = _enrollmentRepository.GetEnrollmentById(id);
return View(enrollment);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_enrollmentRepository.DeleteEnrollment(id);
return RedirectToAction(nameof(Index));
}
}
6. AttendanceController
public class AttendanceController : Controller
{
private readonly IAttendanceRepository _attendanceRepository;
public AttendanceController(IAttendanceRepository attendanceRepository)
{
_attendanceRepository = attendanceRepository;
}
public IActionResult Index()
{
var attendances = _attendanceRepository.GetAllAttendances();
return View(attendances);
}
public IActionResult Details(int id)
{
var attendance = _attendanceRepository.GetAttendanceById(id);
return View(attendance);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Attendance attendance)
{
if (ModelState.IsValid)
{
_attendanceRepository.AddAttendance(attendance);
return RedirectToAction(nameof(Index));
}
return View(attendance);
}
public IActionResult Edit(int id)
{
var attendance = _attendanceRepository.GetAttendanceById(id);
return View(attendance);
}
[HttpPost]
public IActionResult Edit(Attendance attendance)
{
if (ModelState.IsValid)
{
_attendanceRepository.UpdateAttendance(attendance);
return RedirectToAction(nameof(Index));
}
return View(attendance);
}
public IActionResult Delete(int id)
{
var attendance = _attendanceRepository.GetAttendanceById(id);
return View(attendance);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_attendanceRepository.DeleteAttendance(id);
return RedirectToAction(nameof(Index));
}
}
7. AssessmentController
public class AssessmentController : Controller
{
private readonly IAssessmentRepository _assessmentRepository;
public AssessmentController(IAssessmentRepository assessmentRepository)
{
_assessmentRepository = assessmentRepository;
}
public IActionResult Index()
{
var assessments = _assessmentRepository.GetAllAssessments();
return View(assessments);
}
public IActionResult Details(int id)
{
var assessment = _assessmentRepository.GetAssessmentById(id);
return View(assessment);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Assessment assessment)
{
if (ModelState.IsValid)
{
_assessmentRepository.AddAssessment(assessment);
return RedirectToAction(nameof(Index));
}
return View(assessment);
}
public IActionResult Edit(int id)
{
var assessment = _assessmentRepository.GetAssessmentById(id);
return View(assessment);
}
[HttpPost]
public IActionResult Edit(Assessment assessment)
{
if (ModelState.IsValid)
{
_assessmentRepository.UpdateAssessment(assessment);
return RedirectToAction(nameof(Index));
}
return View(assessment);
}
public IActionResult Delete(int id)
{
var assessment = _assessmentRepository.GetAssessmentById(id);
return View(assessment);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_assessmentRepository.DeleteAssessment(id);
return RedirectToAction(nameof(Index));
}
}
8. PaymentController
public class PaymentController : Controller
{
private readonly IPaymentRepository _paymentRepository;
public PaymentController(IPaymentRepository paymentRepository)
{
_paymentRepository = paymentRepository;
}
public IActionResult Index()
{
var payments = _paymentRepository.GetAllPayments();
return View(payments);
}
public IActionResult Details(int id)
{
var payment = _paymentRepository.GetPaymentById(id);
return View(payment);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Payment payment)
{
if (ModelState.IsValid)
{
_paymentRepository.AddPayment(payment);
return RedirectToAction(nameof(Index));
}
return View(payment);
}
public IActionResult Edit(int id)
{
var payment = _paymentRepository.GetPaymentById(id);
return View(payment);
}
[HttpPost]
public IActionResult Edit(Payment payment)
{
if (ModelState.IsValid)
{
_paymentRepository.UpdatePayment(payment);
return RedirectToAction(nameof(Index));
}
return View(payment);
}
public IActionResult Delete(int id)
{
var payment = _paymentRepository.GetPaymentById(id);
return View(payment);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_paymentRepository.DeletePayment(id);
return RedirectToAction(nameof(Index));
}
}
9. FeedbackController
public class FeedbackController : Controller
{
private readonly IFeedbackRepository _feedbackRepository;
public FeedbackController(IFeedbackRepository feedbackRepository)
{
_feedbackRepository = feedbackRepository;
}
public IActionResult Index()
{
var feedbacks = _feedbackRepository.GetAllFeedbacks();
return View(feedbacks);
}
public IActionResult Details(int id)
{
var feedback = _feedbackRepository.GetFeedbackById(id);
return View(feedback);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Feedback feedback)
{
if (ModelState.IsValid)
{
_feedbackRepository.AddFeedback(feedback);
return RedirectToAction(nameof(Index));
}
return View(feedback);
}
public IActionResult Edit(int id)
{
var feedback = _feedbackRepository.GetFeedbackById(id);
return View(feedback);
}
[HttpPost]
public IActionResult Edit(Feedback feedback)
{
if (ModelState.IsValid)
{
_feedbackRepository.UpdateFeedback(feedback);
return RedirectToAction(nameof(Index));
}
return View(feedback);
}
public IActionResult Delete(int id)
{
var feedback = _feedbackRepository.GetFeedbackById(id);
return View(feedback);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_feedbackRepository.DeleteFeedback(id);
return RedirectToAction(nameof(Index));
}
}
10. ReportController
public class ReportController : Controller
{
private readonly IReportRepository _reportRepository;
public ReportController(IReportRepository reportRepository)
{
_report Repository = reportRepository;
}
public IActionResult Index()
{
var reports = _reportRepository.GetAllReports();
return View(reports);
}
public IActionResult Details(int id)
{
var report = _reportRepository.GetReportById(id);
return View(report);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Report report)
{
if (ModelState.IsValid)
{
_reportRepository.AddReport(report);
return RedirectToAction(nameof(Index));
}
return View(report);
}
public IActionResult Edit(int id)
{
var report = _reportRepository.GetReportById(id);
return View(report);
}
[HttpPost]
public IActionResult Edit(Report report)
{
if (ModelState.IsValid)
{
_reportRepository.UpdateReport(report);
return RedirectToAction(nameof(Index));
}
return View(report);
}
public IActionResult Delete(int id)
{
var report = _reportRepository.GetReportById(id);
return View(report);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_reportRepository.DeleteReport(id);
return RedirectToAction(nameof(Index));
}
}
11. ResourceController
public class ResourceController : Controller
{
private readonly IResourceRepository _resourceRepository;
public ResourceController(IResourceRepository resourceRepository)
{
_resourceRepository = resourceRepository;
}
public IActionResult Index()
{
var resources = _resourceRepository.GetAllResources();
return View(resources);
}
public IActionResult Details(int id)
{
var resource = _resourceRepository.GetResourceById(id);
return View(resource);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Resource resource)
{
if (ModelState.IsValid)
{
_resourceRepository.AddResource(resource);
return RedirectToAction(nameof(Index));
}
return View(resource);
}
public IActionResult Edit(int id)
{
var resource = _resourceRepository.GetResourceById(id);
return View(resource);
}
[HttpPost]
public IActionResult Edit(Resource resource)
{
if (ModelState.IsValid)
{
_resourceRepository.UpdateResource(resource);
return RedirectToAction(nameof(Index));
}
return View(resource);
}
public IActionResult Delete(int id)
{
var resource = _resourceRepository.GetResourceById(id);
return View(resource);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_resourceRepository.DeleteResource(id);
return RedirectToAction(nameof(Index));
}
}
12. NotificationController
public class NotificationController : Controller
{
private readonly INotificationRepository _notificationRepository;
public NotificationController(INotificationRepository notificationRepository)
{
_notificationRepository = notificationRepository;
}
public IActionResult Index()
{
var notifications = _notificationRepository.GetAllNotifications();
return View(notifications);
}
public IActionResult Details(int id)
{
var notification = _notificationRepository.GetNotificationById(id);
return View(notification);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Notification notification)
{
if (ModelState.IsValid)
{
_notificationRepository.AddNotification(notification);
return RedirectToAction(nameof(Index));
}
return View(notification);
}
public IActionResult Edit(int id)
{
var notification = _notificationRepository.GetNotificationById(id);
return View(notification);
}
[HttpPost]
public IActionResult Edit(Notification notification)
{
if (ModelState.IsValid)
{
_notificationRepository.UpdateNotification(notification);
return RedirectToAction(nameof(Index));
}
return View(notification);
}
public IActionResult Delete(int id)
{
var notification = _notificationRepository.GetNotificationById(id);
return View(notification);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_notificationRepository.DeleteNotification(id);
return RedirectToAction(nameof(Index));
}
}
Creating View Files
This completes the controller implementations for all the repositories. Each controller provides the necessary actions to manage the corresponding entities, allowing for a complete CRUD interface in your ASP.NET MVC application.
Creating view files for each controller in an ASP.NET MVC application involves creating Razor view files that correspond to the actions in each controller. Below, I will provide a basic structure for the views associated with each controller, including the necessary files for Index, Details, Create, Edit, and Delete actions.
1. User Views
Views/User/Index.cshtml
@model IEnumerable<User>
<h2>Users</h2>
<a asp-action="Create">Create New User</a>
<table>
<thead>
<tr>
<th>Username</th>
<th>Email</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var user in Model)
{
<tr>
<td>@user.Username</td>
<td>@user.Email</td>
<td>
<a asp-action="Details" asp-route-id="@user.UserId">Details</a> |
<a asp-action="Edit" asp-route-id="@user.UserId">Edit</a> |
<a asp-action="Delete" asp-route-id="@user.UserId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/User/Details.cshtml
@model User
<h2>User Details</h2>
<div>
<h4>@Model.Username</h4>
<p>Email: @Model.Email</p>
<p>Phone: @Model.Phone</p>
<p>Role ID: @Model.RoleId</p>
<a asp-action="Edit" asp-route-id="@Model.UserId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/User/Create.cshtml
@model User
<h2>Create User</h2>
<form asp-action="Create">
<div>
<label asp-for="Username"></label>
<input asp-for="Username" />
<span asp-validation-for="Username"></span>
</div>
<div>
<label asp-for="PasswordHash"></label>
<input asp-for="PasswordHash" type="password" />
<span asp-validation-for="PasswordHash"></span>
</div>
<div>
<label asp-for="Email"></label>
<input asp-for="Email" />
<span asp-validation-for="Email"></span>
</div>
<div>
<label asp-for="Phone"></label>
<input asp-for="Phone" />
<span asp-validation-for="Phone"></span>
</div>
<div>
<label asp-for="RoleId"></label>
<input asp-for="RoleId" />
<span asp-validation-for="RoleId"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/User/Edit.cshtml
@model User
<h2>Edit User</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="User Id" />
<div>
<label asp-for="Username"></label>
<input asp-for="Username" />
<span asp-validation-for="Username"></span>
</div>
<div>
<label asp-for="Email"></label>
<input asp-for="Email" />
<span asp-validation-for="Email"></span>
</div>
<div>
<label asp-for="Phone"></label>
<input asp-for="Phone" />
<span asp-validation-for="Phone"></span>
</div>
<div>
<label asp-for="RoleId"></label>
<input asp-for="RoleId" />
<span asp-validation-for="RoleId"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/User/Delete.cshtml
@model User
<h2>Delete User</h2>
<div>
<h4>Are you sure you want to delete this user?</h4>
<div>
<h4>@Model.Username</h4>
<p>Email: @Model.Email</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="User Id" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
2. Role Views
Views/Role/Index.cshtml
@model IEnumerable<Role>
<h2>Roles</h2>
<a asp-action="Create">Create New Role</a>
<table>
<thead>
<tr>
<th>Role Name</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var role in Model)
{
<tr>
<td>@role.RoleName</td>
<td>
<a asp-action="Details" asp-route-id="@role.RoleId">Details</a> |
<a asp-action="Edit" asp-route-id="@role.RoleId">Edit</a> |
<a asp-action="Delete" asp-route-id="@role.RoleId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Role/Details.cshtml
@model Role
<h2>Role Details</h2>
<div>
<h4>@Model.RoleName</h4>
<a asp-action="Edit" asp-route-id="@Model.RoleId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Role/Create.cshtml
@model Role
<h2>Create Role</h2>
<form asp-action="Create">
<div>
<label asp-for="RoleName"></label>
<input asp-for="RoleName" />
<span asp-validation-for="RoleName"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Role/Edit.cshtml
@model Role
<h2>Edit Role</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="RoleId" />
<div>
<label asp-for="RoleName"></label>
<input asp-for="RoleName" />
<span asp-validation-for="RoleName"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Role/Delete.cshtml
@model Role
<h2>Delete Role</h2>
<div>
<h4>Are you sure you want to delete this role?</h4>
<div>
<h4>@Model.RoleName</h4>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="RoleId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
3. Course Views
Views/Course/Index.cshtml
@model IEnumerable<Course>
<h2>Courses</h2>
<a asp-action="Create">Create New Course</a>
<table>
<thead>
<tr>
<th>Course Name</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var course in Model)
{
<tr>
<td>@course.CourseName</td>
<td>
<a asp-action="Details" asp-route-id="@course.CourseId">Details</a> |
<a asp-action="Edit" asp-route-id="@course.CourseId">Edit</a> |
<a asp-action="Delete" asp-route-id="@course.CourseId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Course/Details.cshtml
@model Course
<h2>Course Details</h2>
<div>
<h4>@Model.CourseName</h4>
<p>Description: @Model.Description</p>
<a asp-action="Edit" asp-route-id="@Model.CourseId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Course/Create.cshtml
@model Course
<h2>Create Course</h2>
<form asp-action="Create">
<div>
<label asp-for="CourseName"></label>
<input asp-for="CourseName" />
<span asp-validation-for="CourseName"></span>
</div>
<div>
<label asp-for="Description"></label>
<textarea asp-for="Description"></textarea>
<span asp-validation-for="Description"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Course/Edit.cshtml
@model Course
<h2>Edit Course</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="CourseId" />
<div>
<label asp-for="CourseName"></label>
<input asp-for="CourseName" />
<span asp-validation-for="CourseName"></span>
</div>
<div>
<label asp-for="Description"></label>
<textarea asp-for="Description"></textarea>
<span asp-validation-for="Description"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Course/Delete.cshtml
@model Course
<h2>Delete Course</h2>
<div>
<h4>Are you sure you want to delete this course?</h4>
<div>
<h4>@Model.CourseName</h4>
<p>Description: @Model.Description</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="CourseId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
4. Syllabus Views
Views/Syllabus/Index.cshtml
@model IEnumerable<Syllabus>
<h2>Syllabuses</h2>
<a asp-action="Create">Create New Syllabus</a>
<table>
<thead>
<tr>
<th>Syllabus Title</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var syllabus in Model)
{
<tr>
<td>@syllabus.Title</td>
<td>
<a asp-action="Details" asp-route-id="@syllabus.SyllabusId">Details</a> |
<a asp-action="Edit" asp-route-id="@syllabus.SyllabusId">Edit</a> | <a asp-action="Delete" asp-route-id="@syllabus.SyllabusId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Syllabus/Details.cshtml
@model Syllabus
<h2>Syllabus Details</h2>
<div>
<h4>@Model.Title</h4>
<p>Description: @Model.Description</p>
<a asp-action="Edit" asp-route-id="@Model.SyllabusId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Syllabus/Create.cshtml
@model Syllabus
<h2>Create Syllabus</h2>
<form asp-action="Create">
<div>
<label asp-for="Title"></label>
<input asp-for="Title" />
<span asp-validation-for="Title"></span>
</div>
<div>
<label asp-for="Description"></label>
<textarea asp-for="Description"></textarea>
<span asp-validation-for="Description"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Syllabus/Edit.cshtml
@model Syllabus
<h2>Edit Syllabus</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="SyllabusId" />
<div>
<label asp-for="Title"></label>
<input asp-for="Title" />
<span asp-validation-for="Title"></span>
</div>
<div>
<label asp-for="Description"></label>
<textarea asp-for="Description"></textarea>
<span asp-validation-for="Description"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Syllabus/Delete.cshtml
@model Syllabus
<h2>Delete Syllabus</h2>
<div>
<h4>Are you sure you want to delete this syllabus?</h4>
<div>
<h4>@Model.Title</h4>
<p>Description: @Model.Description</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="SyllabusId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
Creating More Views
Below are the view files for the remaining controllers: Schedule, Enrollment, Attendance, Assessment, Payment, Feedback, Report, Resource, and Notification. Each set of views will include the necessary files for Index, Details, Create, Edit, and Delete actions.
5. Schedule Views
Views/Schedule/Index.cshtml
@model IEnumerable<Schedule>
<h2>Schedules</h2>
<a asp-action="Create">Create New Schedule</a>
<table>
<thead>
<tr>
<th>Course ID</th>
<th>Start Date</th>
<th>End Date</th>
<th>Location</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var schedule in Model)
{
<tr>
<td>@schedule.CourseId</td>
<td>@schedule.StartDate.ToShortDateString()</td>
<td>@schedule.EndDate.ToShortDateString()</td>
<td>@schedule.Location</td>
<td>
<a asp-action="Details" asp-route-id="@schedule.ScheduleId">Details</a> |
<a asp-action="Edit" asp-route-id="@schedule.ScheduleId">Edit</a> |
<a asp-action="Delete" asp-route-id="@schedule.ScheduleId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Schedule/Details.cshtml
@model Schedule
<h2>Schedule Details</h2>
<div>
<h4>Course ID: @Model.CourseId</h4>
<p>Start Date: @Model.StartDate.ToShortDateString()</p>
<p>End Date: @Model.EndDate.ToShortDateString()</p>
<p>Location: @Model.Location</p>
<a asp-action="Edit" asp-route-id="@Model.ScheduleId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Schedule/Create.cshtml
@model Schedule
<h2>Create Schedule</h2>
<form asp-action="Create">
<div>
<label asp-for="CourseId"></label>
<input asp-for="CourseId" />
<span asp-validation-for="CourseId"></span>
</div>
<div>
<label asp-for="StartDate"></label>
<input asp-for="StartDate" type="date" />
<span asp-validation-for="StartDate"></span>
</div>
<div>
<label asp-for="EndDate"></label>
<input asp-for="EndDate" type="date" />
<span asp-validation-for="EndDate"></span>
</div>
<div>
<label asp-for="Location"></label>
<input asp-for="Location" />
<span asp-validation-for="Location"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Schedule/Edit.cshtml
@model Schedule
<h2>Edit Schedule</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="ScheduleId" />
<div>
<label asp-for="CourseId"></label>
<input asp-for="CourseId" />
<span asp-validation-for="CourseId"></span>
</div>
<div>
<label asp-for="StartDate"></label>
<input asp-for="StartDate" type="date" />
<span asp-validation-for="StartDate"></span>
</div>
<div>
<label asp-for="EndDate"></label>
<input asp-for="EndDate" type="date" />
<span asp-validation-for="EndDate"></span>
</div>
<div>
<label asp-for="Location"></label>
<input asp-for="Location" />
<span asp-validation-for="Location"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Schedule/Delete.cshtml
@model Schedule
<h2>Delete Schedule</h2>
<div>
<h4>Are you sure you want to delete this schedule?</h4>
<div>
<h4>Course ID: @Model.CourseId</h4>
<p>Start Date: @Model.StartDate.ToShortDateString()</p>
<p>End Date: @Model.EndDate.ToShortDateString()</p>
<p>Location: @Model.Location</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="ScheduleId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
6. Enrollment Views
Views/Enrollment/Index.cshtml
@model IEnumerable<Enrollment>
<h2>Enrollments</h2>
<a asp-action="Create">Create New Enrollment</a>
<table>
<thead>
<tr>
<th>User ID</th>
<th>Course ID</th>
<th>Enrollment Date</th>
<th>Status</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var enrollment in Model)
{
<tr>
<td>@enrollment.UserId</td>
<td>@enrollment.CourseId</td>
<td>@enrollment.EnrollmentDate.ToShortDateString()</td>
<td>@enrollment.Status</td>
<td>
<a asp-action="Details" asp-route-id="@enrollment.EnrollmentId">Details</a> |
<a asp-action="Edit" asp-route-id="@enrollment.EnrollmentId">Edit</a> |
<a asp-action="Delete" asp-route-id="@enrollment.EnrollmentId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Enrollment/Details.cshtml
@model Enrollment
<h2>Enrollment Details</h2>
<div>
<h4>User ID: @Model.UserId</h4>
<p>Course ID: @Model.CourseId</p>
<p>Enrollment Date: @Model.EnrollmentDate.ToShortDateString()</p>
< p>Status: @Model.Status</p>
<a asp-action="Edit" asp-route-id="@Model.EnrollmentId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Enrollment/Create.cshtml
@model Enrollment
<h2>Create Enrollment</h2>
<form asp-action="Create">
<div>
<label asp-for="User Id"></label>
<input asp-for="User Id" />
<span asp-validation-for="User Id"></span>
</div>
<div>
<label asp-for="CourseId"></label>
<input asp-for="CourseId" />
<span asp-validation-for="CourseId"></span>
</div>
<div>
<label asp-for="EnrollmentDate"></label>
<input asp-for="EnrollmentDate" type="date" />
<span asp-validation-for="EnrollmentDate"></span>
</div>
<div>
<label asp-for="Status"></label>
<input asp-for="Status" />
<span asp-validation-for="Status"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Enrollment/Edit.cshtml
@model Enrollment
<h2>Edit Enrollment</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="EnrollmentId" />
<div>
<label asp-for="User Id"></label>
<input asp-for="User Id" />
<span asp-validation-for="User Id"></span>
</div>
<div>
<label asp-for="CourseId"></label>
<input asp-for="CourseId" />
<span asp-validation-for="CourseId"></span>
</div>
<div>
<label asp-for="EnrollmentDate"></label>
<input asp-for="EnrollmentDate" type="date" />
<span asp-validation-for="EnrollmentDate"></span>
</div>
<div>
<label asp-for="Status"></label>
<input asp-for="Status" />
<span asp-validation-for="Status"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Enrollment/Delete.cshtml
@model Enrollment
<h2>Delete Enrollment</h2>
<div>
<h4>Are you sure you want to delete this enrollment?</h4>
<div>
<h4>User ID: @Model.UserId</h4>
<p>Course ID: @Model.CourseId</p>
<p>Enrollment Date: @Model.EnrollmentDate.ToShortDateString()</p>
<p>Status: @Model.Status</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="EnrollmentId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
7. Attendance Views
Views/Attendance/Index.cshtml
@model IEnumerable<Attendance>
<h2>Attendance Records</h2>
<a asp-action="Create">Create New Attendance Record</a>
<table>
<thead>
<tr>
<th>User ID</th>
<th>Course ID</th>
<th>Date</th>
<th>Status</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var attendance in Model)
{
<tr>
<td>@attendance.UserId</td>
<td>@attendance.CourseId</td>
<td>@attendance.Date.ToShortDateString()</td>
<td>@attendance.Status</td>
<td>
<a asp-action="Details" asp-route-id="@attendance.AttendanceId">Details</a> |
<a asp-action="Edit" asp-route-id="@attendance.AttendanceId">Edit</a> |
<a asp-action="Delete" asp-route-id="@attendance.AttendanceId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Attendance/Details.cshtml
@model Attendance
<h2>Attendance Details</h2>
<div>
<h4>User ID: @Model.UserId</h4>
<p>Course ID: @Model.CourseId</p>
<p>Date: @Model.Date.ToShortDateString()</p>
<p>Status: @Model.Status</p>
<a asp-action="Edit" asp-route-id="@Model.AttendanceId ">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Attendance/Create.cshtml
@model Attendance
<h2>Create Attendance Record</h2>
<form asp-action="Create">
<div>
<label asp-for="User Id"></label>
<input asp-for="User Id" />
<span asp-validation-for="User Id"></span>
</div>
<div>
<label asp-for="CourseId"></label>
<input asp-for="CourseId" />
<span asp-validation-for="CourseId"></span>
</div>
<div>
<label asp-for="Date"></label>
<input asp-for="Date" type="date" />
<span asp-validation-for="Date"></span>
</div>
<div>
<label asp-for="Status"></label>
<input asp-for="Status" />
<span asp-validation-for="Status"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Attendance/Edit.cshtml
@model Attendance
<h2>Edit Attendance Record</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="AttendanceId" />
<div>
<label asp-for="User Id"></label>
<input asp-for="User Id" />
<span asp-validation-for="User Id"></span>
</div>
<div>
<label asp-for="CourseId"></label>
<input asp-for="CourseId" />
<span asp-validation-for="CourseId"></span>
</div>
<div>
<label asp-for="Date"></label>
<input asp-for="Date" type="date" />
<span asp-validation-for="Date"></span>
</div>
<div>
<label asp-for="Status"></label>
<input asp-for="Status" />
<span asp-validation-for="Status"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Attendance/Delete.cshtml
@model Attendance
<h2>Delete Attendance Record</h2>
<div>
<h4>Are you sure you want to delete this attendance record?</h4>
<div>
<h4>User ID: @Model.UserId</h4>
<p>Course ID: @Model.CourseId</p>
<p>Date: @Model.Date.ToShortDateString()</p>
<p>Status: @Model.Status</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="AttendanceId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
8. Assessment Views
Views/Assessment/Index.cshtml
@model IEnumerable<Assessment>
<h2>Assessments</h2>
<a asp-action="Create">Create New Assessment</a>
<table>
<thead>
<tr>
<th>Course ID</th>
<th>Title</th>
<th>Due Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var assessment in Model)
{
<tr>
<td>@assessment.CourseId</td>
<td>@assessment.Title</td>
<td>@assessment.DueDate.ToShortDateString()</td>
<td>
<a asp-action="Details" asp-route-id="@assessment.AssessmentId">Details</a> |
<a asp-action="Edit" asp-route-id="@assessment.AssessmentId">Edit</a> |
<a asp-action="Delete" asp-route-id="@assessment.AssessmentId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Assessment/Details.cshtml
@model Assessment
<h2>Assessment Details</h2>
<div>
<h4>Course ID: @Model.CourseId</h4>
<p>Title: @Model.Title</p>
<p>Due Date: @Model.DueDate.ToShortDateString()</p>
<a asp-action="Edit" asp-route-id="@Model.AssessmentId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Assessment/Create.cshtml
@model Assessment
<h2>Create Assessment</h2>
<form asp-action="Create ">
<div>
<label asp-for="CourseId"></label>
<input asp-for="CourseId" />
<span asp-validation-for="CourseId"></span>
</div>
<div>
<label asp-for="Title"></label>
<input asp-for="Title" />
<span asp-validation-for="Title"></span>
</div>
<div>
<label asp-for="DueDate"></label>
<input asp-for="DueDate" type="date" />
<span asp-validation-for="DueDate"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Assessment/Edit.cshtml
@model Assessment
<h2>Edit Assessment</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="AssessmentId" />
<div>
<label asp-for="CourseId"></label>
<input asp-for="CourseId" />
<span asp-validation-for="CourseId"></span>
</div>
<div>
<label asp-for="Title"></label>
<input asp-for="Title" />
<span asp-validation-for="Title"></span>
</div>
<div>
<label asp-for="DueDate"></label>
<input asp-for="DueDate" type="date" />
<span asp-validation-for="DueDate"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Assessment/Delete.cshtml
@model Assessment
<h2>Delete Assessment</h2>
<div>
<h4>Are you sure you want to delete this assessment?</h4>
<div>
<h4>Course ID: @Model.CourseId</h4>
<p>Title: @Model.Title</p>
<p>Due Date: @Model.DueDate.ToShortDateString()</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="AssessmentId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
9. Payment Views
Views/Payment/Index.cshtml
@model IEnumerable<Payment>
<h2>Payments</h2>
<a asp-action="Create">Create New Payment</a>
<table>
<thead>
<tr>
<th>User ID</th>
<th>Amount</th>
<th>Date</th>
<th>Status</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var payment in Model)
{
<tr>
<td>@payment.UserId</td>
<td>@payment.Amount</td>
<td>@payment.Date.ToShortDateString()</td>
<td>@payment.Status</td>
<td>
<a asp-action="Details" asp-route-id="@payment.PaymentId">Details</a> |
<a asp-action="Edit" asp-route-id="@payment.PaymentId">Edit</a> |
<a asp-action="Delete" asp-route-id="@payment.PaymentId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Payment/Details.cshtml
@model Payment
<h2>Payment Details</h2>
<div>
<h4>User ID: @Model.UserId</h4>
<p>Amount: @Model.Amount</p>
<p>Date: @Model.Date.ToShortDateString()</p>
<p>Status: @Model.Status</p>
<a asp-action="Edit" asp-route-id="@Model.PaymentId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Payment/Create.cshtml
@model Payment
<h2>Create Payment</h2>
<form asp-action="Create">
<div>
<label asp-for="User Id"></label>
<input asp-for="User Id" />
<span asp-validation-for="User Id"></span>
</div>
<div>
<label asp-for="Amount"></label>
<input asp-for="Amount" />
<span asp-validation-for="Amount"></span>
</div>
<div>
<label asp-for="Date"></label>
<input asp-for="Date" type="date" />
<span asp-validation-for="Date"></span>
</div>
<div>
<label asp-for="Status"></label>
<input asp-for="Status" />
<span asp-validation-for="Status"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Payment/Edit.cshtml
@model Payment
<h2>Edit Payment</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="PaymentId" />
<div>
<label asp-for="User Id"></label>
<input asp-for="User Id" />
<span asp-validation-for="User Id"></span>
</div>
<div>
<label asp-for="Amount"></label>
<input asp-for="Amount" />
<span asp-validation-for="Amount"></span>
</div>
<div>
<label asp-for="Date"></label>
<input asp-for="Date" type="date" />
<span asp-validation-for="Date"></span>
</div>
<div>
<label asp-for="Status"></label>
<input asp-for="Status" />
<span asp-validation-for="Status"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Payment/Delete.cshtml
@model Payment
<h2>Delete Payment</h2>
<div>
<h4>Are you sure you want to delete this payment?</h4>
<div>
<h4>User ID: @Model.UserId</h4>
<p>Amount: @Model.Amount</p>
<p>Date: @Model.Date.ToShortDateString()</p>
<p>Status: @Model.Status</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="PaymentId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
10. Feedback Views
Views/Feedback/Index.cshtml
@model IEnumerable<Feedback>
<h2>Feedbacks</h2>
<a asp-action="Create">Create New Feedback</a>
<table>
<thead>
<tr>
<th>User ID</th>
<th>Course ID</th>
<th>Comments</th>
<th>Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var feedback in Model)
{
<tr>
<td>@feedback.UserId</td>
<td>@feedback.CourseId</td>
<td>@feedback.Comments</td>
<td>@feedback.Date.ToShortDateString()</td>
<td>
<a asp-action="Details" asp-route-id="@feedback.FeedbackId">Details</a> |
<a asp-action="Edit" asp-route-id="@feedback.FeedbackId">Edit</a> |
<a asp-action="Delete" asp-route-id="@feedback.FeedbackId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Feedback/Details.cshtml
@model Feedback
<h2>Feedback Details</h2>
<div>
<h4>User ID: @Model.UserId</h4>
<p>Course ID: @Model.CourseId</p>
<p>Comments: @Model.Comments</p>
<p>Date: @Model.Date.ToShortDateString()</p>
<a asp-action="Edit" asp-route-id="@Model.FeedbackId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Feedback/Create.cshtml
@model Feedback
<h2>Create Feedback</h2>
<form asp-action="Create">
<div>
<label asp-for="User Id"></label>
<input asp-for="User Id" />
<span asp-validation-for="User Id"></span>
</div>
<div>
<label asp-for="CourseId"></label>
<input asp-for="CourseId" />
<span asp-validation-for="CourseId"></span>
</div>
<div>
<label asp-for="Comments"></label>
<textarea asp-for="Comments"></textarea>
<span asp-validation-for="Comments"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Feedback/Edit.cshtml
@model Feedback
<h2>Edit Feedback</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="FeedbackId" />
<div>
<label asp-for="User Id"></label>
<input asp-for="User Id" />
<span asp-validation-for="User Id"></span>
</div>
<div>
<label asp-for="CourseId"></label>
<input asp-for="CourseId" />
<span asp-validation-for="CourseId"></span>
</div>
<div>
<label asp-for="Comments"></label>
<textarea asp-for="Comments"></textarea>
<span asp-validation-for="Comments"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Feedback/Delete.cshtml
@model Feedback
<h2>Delete Feedback</h2>
<div>
<h4>Are you sure you want to delete this feedback?</h4>
<div>
<h4>User ID: @Model.UserId</h4>
<p>Course ID: @Model.CourseId</p>
<p>Comments: @Model.Comments</p>
<p>Date: @Model.Date.ToShortDateString()</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="FeedbackId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
11. Report Views
Views/Report/Index.cshtml
@model IEnumerable<Report>
<h2>Reports</h2>
<a asp-action="Create">Create New Report</a>
<table>
<thead>
<tr>
<th>Title</th>
<th>Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var report in Model)
{
<tr>
<td>@report.Title</td>
<td>@report.Date.ToShortDateString()</td>
<td>
<a asp-action="Details" asp-route-id="@report.ReportId">Details</a> |
<a asp-action="Edit" asp-route-id="@report.ReportId">Edit</a> |
<a asp-action="Delete" asp-route-id="@report.ReportId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Report/Details.cshtml
@model Report
<h2>Report Details</h2>
<div>
<h4>@Model.Title</h4>
<p>Date: @Model.Date.ToShortDateString()</p>
<p>Content: @Model.Content</p>
<a asp-action="Edit" asp-route-id="@Model.ReportId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Report/Create.cshtml
@model Report
<h2>Create Report</h2>
<form asp-action="Create">
<div>
<label asp-for="Title"></label>
<input asp-for="Title" />
<span asp-validation-for="Title"></span>
</div>
<div>
<label asp-for="Content"></label>
<textarea asp-for="Content"></textarea>
<span asp-validation-for="Content"></span>
</div>
<div>
<label asp-for="Date"></label>
<input asp-for="Date" type="date" />
<span asp-validation-for="Date"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Report/Edit.cshtml
@model Report
<h2>Edit Report</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="ReportId" />
<div>
<label asp-for="Title"></label>
<input asp-for="Title" />
<span asp-validation-for="Title"></span>
</div>
<div>
<label asp-for="Content"></label>
<textarea asp-for="Content"></textarea>
<span asp-validation-for="Content"></span>
</div>
<div>
<label asp-for="Date"></label>
<input asp-for="Date" type="date" />
<span asp-validation-for="Date"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Report/Delete.cshtml
@model Report
<h2>Delete Report</h2>
<div>
<h4>Are you sure you want to delete this report?</h4>
<div>
<h4>@Model.Title</h4>
<p>Date: @Model.Date.ToShortDateString()</p>
<p>Content: @Model.Content</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="ReportId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
12. Resource Views
Views/Resource/Index.cshtml
@model IEnumerable<Resource>
<h2>Resources</h2>
<a asp-action="Create">Create New Resource</a>
<table>
<thead>
<tr>
<th>Title</th>
<th>Type</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var resource in Model)
{
<tr>
<td>@resource.Title</td>
<td>@resource.Type</td>
<td>
<a asp-action="Details" asp-route-id="@resource.ResourceId">Details</a> |
<a asp-action="Edit" asp-route-id="@resource.ResourceId">Edit</a> |
<a asp-action="Delete" asp-route-id="@resource.ResourceId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Resource/Details.cshtml
@model Resource
<h2>Resource Details</h2>
<div>
<h4>@Model.Title</h4>
<p>Type: @Model.Type</p>
<p>Description: @Model.Description</p>
<a asp-action="Edit" asp-route-id="@Model.ResourceId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Resource/Create.cshtml
@model Resource
<h2>Create Resource</h2>
<form asp-action="Create">
<div>
<label asp-for="Title"></label>
<input asp-for="Title" />
<span asp-validation-for="Title"></span>
</div>
<div>
<label asp-for="Type"></label>
<input asp-for="Type" />
<span asp-validation-for="Type"></span>
</div>
<div>
<label asp-for="Description"></label>
<textarea asp-for="Description"></textarea>
<span asp-validation-for="Description"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Resource/Edit.cshtml
@model Resource
<h2>Edit Resource</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="ResourceId" />
<div>
<label asp-for="Title"></label>
<input asp-for="Title" />
<span asp-validation-for="Title"></span>
</div>
<div>
<label asp-for="Type"></label>
<input asp-for="Type" />
<span asp-validation-for="Type"></span>
</div>
<div>
<label asp-for="Description"></label>
<textarea asp-for="Description"></textarea>
<span asp-validation-for="Description"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Resource/Delete.cshtml
@model Resource
<h2>Delete Resource</h2>
<div>
<h4>Are you sure you want to delete this resource?</h4>
<div>
<h4>@Model.Title</h4>
<p>Type: @Model.Type</p>
<p>Description: @Model.Description</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="ResourceId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
13. Notification Views
Views/Notification/Index.cshtml
@model IEnumerable<Notification>
<h2>Notifications</h2>
<a asp-action="Create">Create New Notification</a>
<table>
<thead>
<tr>
<th>Title</th>
<th>Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var notification in Model)
{
<tr>
<td>@notification.Title</td>
<td>@notification.Date.ToShortDateString()</td>
<td>
<a asp-action="Details" asp-route-id="@notification.NotificationId">Details</a> |
<a asp-action="Edit" asp-route-id="@notification.NotificationId">Edit</a> |
<a asp-action="Delete" asp-route-id="@notification.NotificationId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Notification/Details.cshtml
@model Notification
<h2>Notification Details</h2>
<div>
<h4>@Model.Title</h4>
<p>Date: @Model.Date.ToShortDateString()</p>
<p>Message: @Model.Message</p>
<a asp-action="Edit" asp-route-id="@Model.NotificationId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Notification/Create.cshtml
@model Notification
<h2>Create Notification</h2>
<form asp-action="Create">
<div>
<label asp-for="Title"></label>
<input asp-for="Title" />
<span asp-validation-for="Title"></span>
</div>
<div>
<label asp-for="Message"></label>
<textarea asp-for="Message"></textarea>
<span asp-validation-for="Message"></span>
</div>
<div>
<label asp-for="Date"></label>
<input asp-for="Date" type="date" />
<span asp-validation-for="Date"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Notification/Edit.cshtml
@model Notification
<h2>Edit Notification</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="NotificationId" />
<div>
<label asp-for="Title"></label>
<input asp-for="Title" />
<span asp-validation-for="Title"></span>
</div>
<div>
<label asp-for="Message"></label>
<textarea asp-for="Message"></textarea>
<span asp-validation-for="Message"></span>
</div>
<div>
<label asp-for="Date"></label>
<input asp-for="Date" type="date" />
<span asp-validation-for="Date"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Notification/Delete.cshtml
@model Notification
<h2>Delete Notification</h2>
<div>
<h4>Are you sure you want to delete this notification?</h4>
<div>
<h4>@Model.Title</h4>
<p>Date: @Model.Date.ToShortDateString()</p>
<p>Message: @Model.Message</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="NotificationId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
Creating a dashboard page in an ASP.NET MVC application involves aggregating data from various models and displaying it in a user-friendly format. Below, I will outline how to create a simple dashboard view that consolidates data from the different repositories (Users, Roles, Courses, Enrollments, etc.) and displays it on a single page.
Step 1: Create a Dashboard ViewModel
First, we need to create a ViewModel that will hold the consolidated data for the dashboard.
Models/DashboardViewModel.cs
public class DashboardViewModel
{
public int TotalUsers { get; set; }
public int TotalRoles { get; set; }
public int TotalCourses { get; set; }
public int TotalEnrollments { get; set; }
public int TotalFeedbacks { get; set; }
public int TotalPayments { get; set; }
}
Step 2: Create a Dashboard Controller
Next, we will create a controller that will fetch the necessary data from the repositories and pass it to the dashboard view.
Controllers/DashboardController.cs
public class DashboardController : Controller
{
private readonly IUserRepository _userRepository;
private readonly IRoleRepository _roleRepository;
private readonly ICourseRepository _courseRepository;
private readonly IEnrollmentRepository _enrollmentRepository;
private readonly IFeedbackRepository _feedbackRepository;
private readonly IPaymentRepository _paymentRepository;
public DashboardController(IUser Repository userRepository, IRoleRepository roleRepository,
ICourseRepository courseRepository, IEnrollmentRepository enrollmentRepository,
IFeedbackRepository feedbackRepository, IPaymentRepository paymentRepository)
{
_userRepository = userRepository;
_roleRepository = roleRepository;
_courseRepository = courseRepository;
_enrollmentRepository = enrollmentRepository;
_feedbackRepository = feedbackRepository;
_paymentRepository = paymentRepository;
}
public IActionResult Index()
{
var model = new DashboardViewModel
{
TotalUsers = _userRepository.GetAllUsers().Count(),
TotalRoles = _roleRepository.GetAllRoles().Count(),
TotalCourses = _courseRepository.GetAllCourses().Count(),
TotalEnrollments = _enrollmentRepository.GetAllEnrollments().Count(),
TotalFeedbacks = _feedbackRepository.GetAllFeedbacks().Count(),
TotalPayments = _paymentRepository.GetAllPayments().Count()
};
return View(model);
}
}
Step 3: Create the Dashboard View
Now, we will create the view that will display the dashboard data.
Views/Dashboard/Index.cshtml
@model DashboardViewModel
<h2>Dashboard</h2>
<div class="dashboard">
<div class="card">
<h3>Total Users</h3>
<p>@Model.TotalUsers</p>
</div>
<div class="card">
<h3>Total Roles</h3>
<p>@Model.TotalRoles</p>
</div>
<div class="card">
<h3>Total Courses</h3>
<p>@Model.TotalCourses</p>
</div>
<div class="card">
<h3>Total Enrollments</h3>
<p>@Model.TotalEnrollments</p>
</div>
<div class="card">
<h3>Total Feedbacks</h3>
<p>@Model.TotalFeedbacks</p>
</div>
<div class="card">
<h3>Total Payments</h3>
<p>@Model.TotalPayments</p>
</div>
</div>
<style>
.dashboard {
display: flex;
flex-wrap: wrap;
gap: 20px;
}
.card {
border: 1px solid #ccc;
border-radius: 5px;
padding: 20px;
width: 200px;
text-align: center;
}
</style>
Step 4: Update the Navigation
To access the dashboard, you may want to add a link to it in your main layout or navigation menu.
Views/Shared/_Layout.cshtml
<nav>
<ul>
<li><a asp-controller="Dashboard" asp-action="Index">Dashboard</a></li>
<li><a asp-controller="User " asp-action="Index">Users</a></li>
<li><a asp-controller="Role" asp-action="Index">Roles</a></li>
<li><a asp-controller="Course" asp-action="Index">Courses</a></li>
<li><a asp-controller="Enrollment" asp-action="Index">Enrollments</a></li>
<li><a asp-controller="Attendance" asp-action="Index">Attendance</a></li>
<li><a asp-controller="Assessment" asp-action="Index">Assessments</a></li>
<li><a asp-controller="Payment" asp-action="Index">Payments</a></li>
<li><a asp-controller="Feedback" asp-action="Index">Feedbacks</a></li>
<li><a asp-controller="Report" asp-action="Index">Reports</a></li>
<li><a asp-controller="Resource" asp-action="Index">Resources</a></li>
<li><a asp-controller="Notification" asp-action="Index">Notifications</a></li>
</ul>
</nav>
Summary
With these steps, you have created a dashboard page that consolidates data from various repositories and displays it in a user-friendly format. You can further enhance the dashboard by adding charts, graphs, or other visual elements to represent the data more effectively. You can use libraries like Chart.js or D3.js for more advanced visualizations.
-- Users Table CREATE TABLE Users ( UserId INT PRIMARY KEY IDENTITY(1,1), Username NVARCHAR(50) NOT NULL UNIQUE, PasswordHash NVARCHAR(255) NOT NULL, Email NVARCHAR(100) NOT NULL UNIQUE, Phone NVARCHAR(15), RoleId INT, CreatedAt DATETIME DEFAULT GETDATE(), UpdatedAt DATETIME DEFAULT GETDATE(), FOREIGN KEY (RoleId) REFERENCES Roles(RoleId) );
-- Roles Table CREATE TABLE Roles ( RoleId INT PRIMARY KEY IDENTITY(1,1), RoleName NVARCHAR(50) NOT NULL UNIQUE );
-- Events Table CREATE TABLE Events ( EventId INT PRIMARY KEY IDENTITY(1,1), EventName NVARCHAR(100) NOT NULL, Description NVARCHAR(MAX), StartDate DATETIME NOT NULL, EndDate DATETIME NOT NULL, VenueId INT, CreatedAt DATETIME DEFAULT GETDATE(), UpdatedAt DATETIME DEFAULT GETDATE(), FOREIGN KEY (VenueId) REFERENCES Venues(VenueId) );
-- Venues Table CREATE TABLE Venues ( VenueId INT PRIMARY KEY IDENTITY(1,1), VenueName NVARCHAR(100) NOT NULL, Address NVARCHAR(255) NOT NULL, Capacity INT, CreatedAt DATETIME DEFAULT GETDATE(), UpdatedAt DATETIME DEFAULT GETDATE() );
-- Registrations Table CREATE TABLE Registrations ( RegistrationId INT PRIMARY KEY IDENTITY(1,1), UserId INT, EventId INT, RegistrationDate DATETIME DEFAULT GETDATE(), Status NVARCHAR(20) DEFAULT 'Registered', -- e.g., Registered, Cancelled FOREIGN KEY (User Id) REFERENCES Users(UserId), FOREIGN KEY (EventId) REFERENCES Events(EventId) );
-- Tickets Table CREATE TABLE Tickets ( TicketId INT PRIMARY KEY IDENTITY(1,1), RegistrationId INT, TicketType NVARCHAR(50), -- e.g., Regular, VIP Price DECIMAL(10, 2) NOT NULL, CreatedAt DATETIME DEFAULT GETDATE(), FOREIGN KEY (RegistrationId) REFERENCES Registrations(RegistrationId) );
-- Notifications Table CREATE TABLE Notifications ( NotificationId INT PRIMARY KEY IDENTITY(1,1), UserId INT, Message NVARCHAR(MAX), IsRead BIT DEFAULT 0, CreatedAt DATETIME DEFAULT GETDATE(), FOREIGN KEY (User Id) REFERENCES Users(UserId) );
-- Vendors Table CREATE TABLE Vendors ( VendorId INT PRIMARY KEY IDENTITY(1,1), VendorName NVARCHAR(100) NOT NULL, ContactPerson NVARCHAR(100), Phone NVARCHAR(15), Email NVARCHAR(100), CreatedAt DATETIME DEFAULT GETDATE(), UpdatedAt DATETIME DEFAULT GETDATE() );
-- MarketingCampaigns Table CREATE TABLE MarketingCampaigns ( CampaignId INT PRIMARY KEY IDENTITY(1,1), CampaignName NVARCHAR(100) NOT NULL, StartDate DATETIME, EndDate DATETIME, Budget DECIMAL(10, 2), CreatedAt DATETIME DEFAULT GETDATE(), UpdatedAt DATETIME DEFAULT GETDATE() );
-- Feedback Table CREATE TABLE Feedbacks ( FeedbackId INT PRIMARY KEY IDENTITY(1,1), UserId INT, EventId INT, Comments NVARCHAR(MAX), Rating INT CHECK (Rating >= 1 AND Rating <= 5), CreatedAt DATETIME DEFAULT GETDATE(), FOREIGN KEY (User Id) REFERENCES Users(UserId), FOREIGN KEY (EventId) REFERENCES Events(EventId) );
-- AttendanceReports Table CREATE TABLE AttendanceReports ( ReportId INT PRIMARY KEY IDENTITY(1,1), EventId INT, TotalAttendees INT, CreatedAt DATETIME DEFAULT GETDATE(), FOREIGN KEY (EventId) REFERENCES Events(EventId) );
-- FinancialReports Table CREATE TABLE FinancialReports ( FinancialReportId INT PRIMARY KEY IDENTITY(1,1), EventId INT, TotalRevenue DECIMAL(10, 2), TotalExpenses DECIMAL(10, 2), CreatedAt DATETIME DEFAULT GETDATE(), FOREIGN KEY (EventId) REFERENCES Events(EventId) );
-- PerformanceMetrics Table CREATE TABLE PerformanceMetrics ( MetricId INT PRIMARY KEY IDENTITY(1,1), EventId INT, MetricName NVARCHAR(100), MetricValue DECIMAL(10, 2), CreatedAt DATETIME DEFAULT GETDATE(), FOREIGN KEY (EventId) REFERENCES Events(EventId) );
To create models and repositories using ADO.NET for the provided SQL Server database schema in an ASP.NET application, we will follow these steps:
Create Model Classes: Define C# classes that represent the tables in the database.
Create Repository Interfaces: Define interfaces for the repositories that will handle data access.
Implement Repository Classes: Implement the repository interfaces using ADO.NET to interact with the database.
Step 1: Create Model Classes
Here are the model classes for the tables defined in your SQL schema:
public class User
{
public int UserId { get; set; }
public string Username { get; set; }
public string PasswordHash { get; set; }
public string Email { get; set; }
public string Phone { get; set; }
public int? RoleId { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Role
{
public int RoleId { get; set; }
public string RoleName { get; set; }
}
public class Event
{
public int EventId { get; set; }
public string EventName { get; set; }
public string Description { get; set; }
public DateTime StartDate { get; set; }
public DateTime EndDate { get; set; }
public int? VenueId { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Venue
{
public int VenueId { get; set; }
public string VenueName { get; set; }
public string Address { get; set; }
public int Capacity { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Registration
{
public int RegistrationId { get; set; }
public int UserId { get; set; }
public int EventId { get; set; }
public DateTime RegistrationDate { get; set; }
public string Status { get; set; }
}
public class Ticket
{
public int TicketId { get; set; }
public int RegistrationId { get; set; }
public string TicketType { get; set; }
public decimal Price { 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 Vendor
{
public int VendorId { get; set; }
public string VendorName { get; set; }
public string ContactPerson { get; set; }
public string Phone { get; set; }
public string Email { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class MarketingCampaign
{
public int CampaignId { get; set; }
public string CampaignName { get; set; }
public DateTime? StartDate { get; set; }
public DateTime? EndDate { get; set; }
public decimal? Budget { 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 EventId { get; set; }
public string Comments { get; set; }
public int Rating { get; set; }
public DateTime CreatedAt { get; set; }
}
public class AttendanceReport
{
public int ReportId { get; set; }
public int EventId { get; set; }
public int TotalAttendees { get; set; }
public DateTime CreatedAt { get; set; }
}
public class FinancialReport
{
public int FinancialReportId { get; set; }
public int EventId { get; set; }
public decimal TotalRevenue { get; set; }
public decimal TotalExpenses { get; set; }
public DateTime CreatedAt { get; set; }
}
public class PerformanceMetric
{
public int MetricId { get; set; }
public int EventId { get; set; }
public string MetricName { get; set; }
public decimal MetricValue { get; set; }
public DateTime CreatedAt { get; set; }
}
Step 2: Create Repository Interfaces
Define interfaces for the repositories. Here’s an example for the User repository:
public interface IUserRepository
{
User GetUser ById(int userId);
IEnumerable<User> GetAllUsers();
void AddUser (User user);
void UpdateUser (User user);
void DeleteUser (int userId);
}
You would create similar interfaces for other entities (e.g., IRoleRepository, IEventRepository, etc.).
Step 3: Implement Repository Classes
Here’s an example implementation of the User Repository using ADO.NET:
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
public class UserRepository : IUserRepository
{
private readonly string _connectionString;
public UserRepository(string connectionString)
{
_connectionString = connectionString;
}
public User GetUser ById(int userId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Users WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", userId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new User
{
UserId = (int)reader["User Id"],
Username = reader["Username"].ToString(),
PasswordHash = reader["PasswordHash"].ToString(),
Email = reader["Email"].ToString(),
Phone = reader["Phone"]?.ToString(),
RoleId = reader["RoleId"] as int?,
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<User> GetAllUsers()
{
var users = new List<User>();
using ( var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Users", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
users.Add(new User
{
UserId = (int)reader["User Id"],
Username = reader["Username"].ToString(),
PasswordHash = reader["PasswordHash"].ToString(),
Email = reader["Email"].ToString(),
Phone = reader["Phone"]?.ToString(),
RoleId = reader["RoleId"] as int?,
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return users;
}
public void AddUser (User user)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Users (Username, PasswordHash, Email, Phone, RoleId) VALUES (@Username, @PasswordHash, @Email, @Phone, @RoleId)", connection);
command.Parameters.AddWithValue("@Username", user.Username);
command.Parameters.AddWithValue("@PasswordHash", user.PasswordHash);
command.Parameters.AddWithValue("@Email", user.Email);
command.Parameters.AddWithValue("@Phone", user.Phone ?? (object)DBNull.Value);
command.Parameters.AddWithValue("@RoleId", user.RoleId ?? (object)DBNull.Value);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateUser (User user)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Users SET Username = @Username, PasswordHash = @PasswordHash, Email = @Email, Phone = @Phone, RoleId = @RoleId, UpdatedAt = GETDATE() WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", user.UserId);
command.Parameters.AddWithValue("@Username", user.Username);
command.Parameters.AddWithValue("@PasswordHash", user.PasswordHash);
command.Parameters.AddWithValue("@Email", user.Email);
command.Parameters.AddWithValue("@Phone", user.Phone ?? (object)DBNull.Value);
command.Parameters.AddWithValue("@RoleId", user.RoleId ?? (object)DBNull.Value);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteUser (int userId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Users WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", userId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
This structure provides a clear separation of concerns, with models representing the data, interfaces defining the contract for data access, and implementations using ADO.NET to interact with the SQL Server database. You can create similar repository classes for other entities like Role, Event, Venue, etc., following the same pattern.
Below are the repository interfaces and implementations for the remaining models based on the SQL schema you provided. Each repository will follow a similar pattern to the User Repository example.
1. Role Repository
Interface:
public interface IRoleRepository
{
Role GetRoleById(int roleId);
IEnumerable<Role> GetAllRoles();
void AddRole(Role role);
void UpdateRole(Role role);
void DeleteRole(int roleId);
}
Implementation:
public class RoleRepository : IRoleRepository
{
private readonly string _connectionString;
public RoleRepository(string connectionString)
{
_connectionString = connectionString;
}
public Role GetRoleById(int roleId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Roles WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", roleId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Role
{
RoleId = (int)reader["RoleId"],
RoleName = reader["RoleName"].ToString()
};
}
}
}
return null;
}
public IEnumerable<Role> GetAllRoles()
{
var roles = new List<Role>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Roles", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
roles.Add(new Role
{
RoleId = (int)reader["RoleId"],
RoleName = reader["RoleName"].ToString()
});
}
}
}
return roles;
}
public void AddRole(Role role)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Roles (RoleName) VALUES (@RoleName)", connection);
command.Parameters.AddWithValue("@RoleName", role.RoleName);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateRole(Role role)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Roles SET RoleName = @RoleName WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", role.RoleId);
command.Parameters.AddWithValue("@RoleName", role.RoleName);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteRole(int roleId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Roles WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", roleId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
2. Event Repository
Interface:
public interface IEventRepository
{
Event GetEventById(int eventId);
IEnumerable<Event> GetAllEvents();
void AddEvent(Event event);
void UpdateEvent(Event event);
void DeleteEvent(int eventId);
}
Implementation:
public class EventRepository : IEventRepository
{
private readonly string _connectionString;
public EventRepository(string connectionString)
{
_connectionString = connectionString;
}
public Event GetEventById(int eventId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Events WHERE EventId = @EventId", connection);
command.Parameters.AddWithValue("@EventId", eventId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Event
{
EventId = (int)reader["EventId"],
EventName = reader["EventName"].ToString(),
Description = reader["Description"].ToString(),
StartDate = (DateTime)reader["StartDate"],
EndDate = (DateTime)reader["EndDate"],
VenueId = reader["VenueId"] as int?,
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Event> GetAllEvents()
{
var events = new List<Event>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Events", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
events.Add(new Event
{
EventId = (int)reader["EventId"],
EventName = reader["EventName"].ToString(),
Description = reader["Description"].ToString(),
StartDate = (DateTime)reader["StartDate"],
EndDate = (DateTime)reader["EndDate"],
VenueId = reader["VenueId"] as int?,
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return events;
}
public void AddEvent(Event event)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Events (EventName, Description, StartDate, EndDate, VenueId) VALUES (@EventName, @Description, @StartDate, @EndDate, @VenueId)", connection);
command.Parameters.AddWithValue("@EventName", event.EventName);
command.Parameters.AddWithValue("@Description", event.Description);
command.Parameters.AddWithValue("@StartDate", event.StartDate);
command.Parameters.AddWithValue("@EndDate", event.EndDate);
command.Parameters.AddWithValue("@VenueId", event.VenueId ?? (object)DBNull.Value);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateEvent(Event event)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Events SET EventName = @EventName, Description = @Description, StartDate = @StartDate, EndDate = @EndDate, VenueId = @VenueId, UpdatedAt = GETDATE() WHERE EventId = @EventId", connection);
command.Parameters.AddWithValue("@EventId", event.EventId);
command.Parameters.AddWithValue("@EventName", event.Event Name);
command.Parameters.AddWithValue("@Description", event.Description);
command.Parameters.AddWithValue("@StartDate", event.StartDate);
command.Parameters.AddWithValue("@EndDate", event.EndDate);
command.Parameters.AddWithValue("@VenueId", event.VenueId ?? (object)DBNull.Value);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteEvent(int eventId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Events WHERE EventId = @EventId", connection);
command.Parameters.AddWithValue("@EventId", eventId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
3. Venue Repository
Interface:
public interface IVenueRepository
{
Venue GetVenueById(int venueId);
IEnumerable<Venue> GetAllVenues();
void AddVenue(Venue venue);
void UpdateVenue(Venue venue);
void DeleteVenue(int venueId);
}
Implementation:
public class VenueRepository : IVenueRepository
{
private readonly string _connectionString;
public VenueRepository(string connectionString)
{
_connectionString = connectionString;
}
public Venue GetVenueById(int venueId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Venues WHERE VenueId = @VenueId", connection);
command.Parameters.AddWithValue("@VenueId", venueId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Venue
{
VenueId = (int)reader["VenueId"],
VenueName = reader["VenueName"].ToString(),
Address = reader["Address"].ToString(),
Capacity = (int)reader["Capacity"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Venue> GetAllVenues()
{
var venues = new List<Venue>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Venues", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
venues.Add(new Venue
{
VenueId = (int)reader["VenueId"],
VenueName = reader["VenueName"].ToString(),
Address = reader["Address"].ToString(),
Capacity = (int)reader["Capacity"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return venues;
}
public void AddVenue(Venue venue)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Venues (VenueName, Address, Capacity) VALUES (@VenueName, @Address, @Capacity)", connection);
command.Parameters.AddWithValue("@VenueName", venue.VenueName);
command.Parameters.AddWithValue("@Address", venue.Address);
command.Parameters.AddWithValue("@Capacity", venue.Capacity);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateVenue(Venue venue)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Venues SET VenueName = @VenueName, Address = @Address, Capacity = @Capacity, UpdatedAt = GETDATE() WHERE VenueId = @VenueId", connection);
command.Parameters.AddWithValue("@VenueId", venue.VenueId);
command.Parameters.AddWithValue("@VenueName", venue.VenueName);
command.Parameters.AddWithValue("@Address", venue.Address);
command.Parameters.AddWithValue("@Capacity", venue.Capacity);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteVenue(int venueId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Venues WHERE VenueId = @VenueId", connection);
command.Parameters.AddWithValue("@VenueId", venueId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
4. Registration Repository
Interface:
public interface IRegistrationRepository
{
Registration GetRegistrationById(int registrationId);
IEnumerable<Registration> GetAllRegistrations();
void AddRegistration(Registration registration);
void UpdateRegistration(Registration registration);
void DeleteRegistration(int registrationId);
}
Implementation:
public class RegistrationRepository : IRegistrationRepository
{
private readonly string _connectionString;
public RegistrationRepository(string connectionString)
{
_connectionString = connectionString;
}
public Registration GetRegistrationById(int registrationId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Registrations WHERE RegistrationId = @RegistrationId", connection);
command.Parameters.AddWithValue("@RegistrationId", registrationId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Registration
{
RegistrationId = (int)reader["RegistrationId"],
UserId = (int)reader["User Id"],
EventId = (int)reader["EventId"],
RegistrationDate = (DateTime)reader["RegistrationDate"],
Status = reader["Status"].ToString()
};
}
}
return null;
}
public IEnumerable<Registration> GetAllRegistrations()
{
var registrations = new List<Registration>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Registrations", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
registrations.Add(new Registration
{
RegistrationId = (int)reader["RegistrationId"],
UserId = (int)reader["User Id"],
EventId = (int)reader["EventId"],
RegistrationDate = (DateTime)reader["RegistrationDate"],
Status = reader["Status"].ToString()
});
}
}
}
return registrations;
}
public void AddRegistration(Registration registration)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Registrations (User Id, EventId, RegistrationDate, Status) VALUES
(@User Id, @EventId, @RegistrationDate, @Status)", connection);
command.Parameters.AddWithValue("@User Id", registration.UserId);
command.Parameters.AddWithValue("@EventId", registration.EventId);
command.Parameters.AddWithValue("@RegistrationDate", registration.RegistrationDate);
command.Parameters.AddWithValue("@Status", registration.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateRegistration(Registration registration)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Registrations SET UserId = @User Id, EventId = @EventId, RegistrationDate =
@RegistrationDate, Status = @Status WHERE RegistrationId = @RegistrationId", connection);
command.Parameters.AddWithValue("@RegistrationId", registration.RegistrationId);
command.Parameters.AddWithValue("@User Id", registration.UserId);
command.Parameters.AddWithValue("@EventId", registration.EventId);
command.Parameters.AddWithValue("@RegistrationDate", registration.RegistrationDate);
command.Parameters.AddWithValue("@Status", registration.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteRegistration(int registrationId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Registrations WHERE RegistrationId = @RegistrationId", connection);
command.Parameters.AddWithValue("@RegistrationId", registrationId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
5. Ticket Repository
Interface:
public interface ITicketRepository
{
Ticket GetTicketById(int ticketId);
IEnumerable<Ticket> GetAllTickets();
void AddTicket(Ticket ticket);
void UpdateTicket(Ticket ticket);
void DeleteTicket(int ticketId);
}
Implementation:
public class TicketRepository : ITicketRepository
{
private readonly string _connectionString;
public TicketRepository(string connectionString)
{
_connectionString = connectionString;
}
public Ticket GetTicketById(int ticketId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Tickets WHERE TicketId = @TicketId", connection);
command.Parameters.AddWithValue("@TicketId", ticketId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Ticket
{
TicketId = (int)reader["TicketId"],
RegistrationId = (int)reader["RegistrationId"],
TicketType = reader["TicketType"].ToString(),
Price = (decimal)reader["Price"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public IEnumerable <Ticket> GetAllTickets()
{
var tickets = new List<Ticket>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Tickets", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
tickets.Add(new Ticket
{
TicketId = (int)reader["TicketId"],
RegistrationId = (int)reader["RegistrationId"],
TicketType = reader["TicketType"].ToString(),
Price = (decimal)reader["Price"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return tickets;
}
public void AddTicket(Ticket ticket)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Tickets (RegistrationId, TicketType, Price) VALUES (@RegistrationId, @TicketType, @Price)", connection);
command.Parameters.AddWithValue("@RegistrationId", ticket.RegistrationId);
command.Parameters.AddWithValue("@TicketType", ticket.TicketType);
command.Parameters.AddWithValue("@Price", ticket.Price);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateTicket(Ticket ticket)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Tickets SET RegistrationId = @RegistrationId, TicketType = @TicketType, Price = @Price WHERE TicketId = @TicketId", connection);
command.Parameters.AddWithValue("@TicketId", ticket.TicketId);
command.Parameters.AddWithValue("@RegistrationId", ticket.RegistrationId);
command.Parameters.AddWithValue("@TicketType", ticket.TicketType);
command.Parameters.AddWithValue("@Price", ticket.Price);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteTicket(int ticketId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Tickets WHERE TicketId = @TicketId", connection);
command.Parameters.AddWithValue("@TicketId", ticketId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
6. Notification Repository
Interface:
public interface INotificationRepository
{
Notification GetNotificationById(int notificationId);
IEnumerable<Notification> GetAllNotifications();
void AddNotification(Notification notification);
void UpdateNotification(Notification notification);
void DeleteNotification(int notificationId);
}
Implementation:
public class NotificationRepository : INotificationRepository
{
private readonly string _connectionString;
public NotificationRepository(string connectionString)
{
_connectionString = connectionString;
}
public Notification GetNotificationById(int notificationId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Notifications WHERE NotificationId = @NotificationId", connection);
command.Parameters.AddWithValue("@NotificationId", notificationId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Notification
{
NotificationId = (int)reader["NotificationId"],
UserId = (int)reader["User Id"],
Message = reader["Message"].ToString(),
IsRead = (bool)reader["IsRead"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Notification> GetAllNotifications()
{
var notifications = new List<Notification>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Notifications", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
notifications.Add(new Notification
{
NotificationId = (int)reader["NotificationId"],
UserId = (int)reader["User Id"],
Message = reader["Message"].ToString(),
IsRead = (bool)reader["IsRead"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return notifications;
}
public void AddNotification(Notification notification)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Notifications (User Id, Message, IsRead) VALUES (@User Id, @Message, @IsRead)", connection);
command.Parameters.AddWithValue("@User Id", notification.UserId);
command.Parameters.AddWithValue("@Message", notification.Message);
command.Parameters.AddWithValue("@IsRead", notification.IsRead);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateNotification(Notification notification)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Notifications SET UserId = @User Id, Message = @Message, IsRead = @IsRead WHERE NotificationId = @NotificationId", connection);
command.Parameters.AddWithValue("@NotificationId", notification.NotificationId);
command.Parameters.AddWithValue("@User Id", notification.UserId);
command.Parameters.AddWithValue("@Message", notification.Message);
command.Parameters.AddWithValue("@IsRead", notification.IsRead);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteNotification(int notificationId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Notifications WHERE NotificationId = @NotificationId", connection);
command.Parameters.AddWithValue("@NotificationId", notificationId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
7. Vendor Repository
Interface:
public interface IVendorRepository
{
Vendor GetVendorById(int vendorId);
IEnumerable<Vendor> GetAllVendors();
void AddVendor(Vendor vendor);
void UpdateVendor(Vendor vendor);
void DeleteVendor(int vendorId);
}
Implementation:
public class VendorRepository : IVendorRepository
{
private readonly string _connectionString;
public VendorRepository(string connectionString)
{
_connectionString = connectionString;
}
public Vendor GetVendorById(int vendorId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Vendors WHERE VendorId = @VendorId", connection);
command.Parameters.AddWithValue("@VendorId", vendorId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Vendor
{
VendorId = (int)reader["VendorId"],
VendorName = reader["VendorName"].ToString(),
ContactPerson = reader["ContactPerson"].ToString(),
Phone = reader["Phone"]?.ToString(),
Email = reader["Email"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Vendor> GetAllVendors()
{
var vendors = new List<Vendor>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Vendors", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
vendors.Add(new Vendor
{
VendorId = (int)reader["VendorId"],
VendorName = reader["VendorName"].ToString(),
ContactPerson = reader["ContactPerson"].ToString(),
Phone = reader["Phone"]?.ToString(),
Email = reader["Email"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return vendors;
}
public void AddVendor(Vendor vendor)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Vendors (VendorName, ContactPerson, Phone, Email) VALUES (@VendorName, @ContactPerson, @Phone, @Email)", connection);
command.Parameters.AddWithValue("@VendorName", vendor.VendorName);
command.Parameters.AddWithValue("@ContactPerson", vendor.ContactPerson);
command.Parameters.AddWithValue("@Phone", vendor.Phone ?? (object)DBNull.Value);
command.Parameters.AddWithValue("@Email", vendor.Email);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateVendor(Vendor vendor)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Vendors SET VendorName = @VendorName, ContactPerson = @ContactPerson, Phone = @Phone, Email = @Email, UpdatedAt = GETDATE() WHERE VendorId = @VendorId", connection);
command.Parameters.AddWithValue("@VendorId", vendor.VendorId);
command.Parameters.AddWithValue("@VendorName", vendor.VendorName);
command.Parameters.AddWithValue("@ContactPerson", vendor.ContactPerson);
command.Parameters.AddWithValue("@Phone", vendor.Phone ?? (object)DBNull.Value);
command.Parameters.AddWithValue("@Email", vendor.Email);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteVendor(int vendorId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Vendors WHERE VendorId = @VendorId", connection);
command.Parameters.AddWithValue("@VendorId", vendorId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
8. Marketing Campaign Repository
Interface:
public interface IMarketingCampaignRepository
{
MarketingCampaign GetCampaignById(int campaignId);
IEnumerable<MarketingCampaign> GetAllCampaigns();
void AddCampaign(MarketingCampaign campaign);
void UpdateCampaign(MarketingCampaign campaign);
void DeleteCampaign(int campaignId);
}
Implementation:
public class MarketingCampaignRepository : IMarketingCampaignRepository
{
private readonly string _connectionString;
public MarketingCampaignRepository(string connectionString)
{
_connectionString = connectionString;
}
public MarketingCampaign GetCampaignById(int campaignId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM MarketingCampaigns WHERE CampaignId = @CampaignId", connection);
command.Parameters.AddWithValue("@CampaignId", campaignId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new MarketingCampaign
{
CampaignId = (int)reader["CampaignId"],
CampaignName = reader["CampaignName"].ToString(),
StartDate = reader["StartDate"] as DateTime?,
EndDate = reader["EndDate"] as DateTime?,
Budget = reader["Budget"] as decimal?,
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<MarketingCampaign> GetAllCampaigns()
{
var campaigns = new List<MarketingCampaign>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM MarketingCampaigns", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
campaigns.Add(new MarketingCampaign
{
CampaignId = (int)reader["CampaignId"],
CampaignName = reader["CampaignName"].ToString(),
StartDate = reader["StartDate"] as DateTime?,
EndDate = reader["EndDate"] as DateTime?,
Budget = reader["Budget"] as decimal?,
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return campaigns;
}
public void AddCampaign(MarketingCampaign campaign)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO MarketingCampaigns (CampaignName, StartDate, EndDate, Budget) VALUES (@CampaignName, @StartDate, @EndDate, @Budget)", connection);
command.Parameters.AddWithValue("@CampaignName", campaign.CampaignName);
command.Parameters.AddWithValue("@StartDate", campaign.StartDate ?? (object)DBNull.Value);
command.Parameters.AddWithValue("@EndDate", campaign.EndDate ?? (object)DBNull.Value);
command.Parameters.AddWithValue("@Budget", campaign.Budget ?? (object)DBNull.Value);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateCampaign(MarketingCampaign campaign)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE MarketingCampaigns SET CampaignName = @CampaignName, StartDate = @StartDate, EndDate = @EndDate, Budget = @Budget, UpdatedAt = GETDATE() WHERE CampaignId = @CampaignId", connection);
command.Parameters.AddWithValue("@CampaignId", campaign.CampaignId);
command.Parameters.AddWithValue("@CampaignName", campaign.CampaignName);
command.Parameters.AddWithValue("@StartDate", campaign.StartDate ?? (object)DBNull.Value);
command.Parameters.AddWithValue("@EndDate", campaign.EndDate ?? (object)DBNull.Value);
command.Parameters.AddWithValue("@Budget", campaign.Budget ?? (object)DBNull.Value);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteCampaign(int campaignId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM MarketingCampaigns WHERE CampaignId = @CampaignId", connection);
command.Parameters.AddWithValue("@CampaignId", campaignId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
9. Feedback Repository
Interface:
public interface IFeedbackRepository
{
Feedback Get FeedbackById(int feedbackId);
IEnumerable<Feedback> GetAllFeedbacks();
void AddFeedback(Feedback feedback);
void UpdateFeedback(Feedback feedback);
void DeleteFeedback(int feedbackId);
}
Implementation:
public class FeedbackRepository : IFeedbackRepository
{
private readonly string _connectionString;
public FeedbackRepository(string connectionString)
{
_connectionString = connectionString;
}
public Feedback GetFeedbackById(int feedbackId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Feedbacks WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@FeedbackId", feedbackId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Feedback
{
FeedbackId = (int)reader["FeedbackId"],
UserId = (int)reader["User Id"],
EventId = (int)reader["EventId"],
Comments = reader["Comments"].ToString(),
Rating = (int)reader["Rating"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Feedback> GetAllFeedbacks()
{
var feedbacks = new List<Feedback>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Feedbacks", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
feedbacks.Add(new Feedback
{
FeedbackId = (int)reader["FeedbackId"],
UserId = (int)reader["User Id"],
EventId = (int)reader["EventId"],
Comments = reader["Comments"].ToString(),
Rating = (int)reader["Rating"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return feedbacks;
}
public void AddFeedback(Feedback feedback)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Feedbacks (User Id, EventId, Comments, Rating) VALUES (@User Id, @EventId, @Comments, @Rating)", connection);
command.Parameters.AddWithValue("@User Id", feedback.UserId);
command.Parameters.AddWithValue("@EventId", feedback.EventId);
command.Parameters.AddWithValue("@Comments", feedback.Comments);
command.Parameters.AddWithValue("@Rating", feedback.Rating);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateFeedback(Feedback feedback)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Feedbacks SET UserId = @User Id, EventId = @EventId, Comments = @Comments, Rating = @Rating WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@FeedbackId", feedback.FeedbackId);
command.Parameters.AddWithValue("@User Id", feedback.UserId);
command.Parameters.AddWithValue("@EventId", feedback.EventId);
command.Parameters.AddWithValue("@Comments", feedback.Comments);
command.Parameters.AddWithValue("@Rating", feedback.Rating);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteFeedback(int feedbackId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Feedbacks WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@FeedbackId", feedbackId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
10. Attendance Report Repository
Interface:
public interface IAttendanceReportRepository
{
AttendanceReport GetReportById(int reportId);
IEnumerable<AttendanceReport> GetAllReports();
void AddReport(AttendanceReport report);
void UpdateReport(AttendanceReport report);
void DeleteReport(int reportId);
}
Implementation:
public class AttendanceReportRepository : IAttendanceReportRepository
{
private readonly string _connectionString;
public AttendanceReportRepository(string connectionString)
{
_connectionString = connectionString;
}
public AttendanceReport GetReportById(int reportId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM AttendanceReports WHERE ReportId = @ReportId", connection);
command.Parameters.AddWithValue("@ReportId", reportId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new AttendanceReport
{
ReportId = (int)reader["ReportId"],
EventId = (int)reader["EventId"],
TotalAttendees = (int)reader["TotalAttendees"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public IEnumerable<AttendanceReport> GetAllReports()
{
var reports = new List<AttendanceReport>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM AttendanceReports", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
reports.Add(new AttendanceReport
{
ReportId = (int)reader["ReportId"],
EventId = (int)reader["EventId"],
TotalAttendees = (int)reader["TotalAttendees"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return reports;
}
public void AddReport(AttendanceReport report)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO AttendanceReports (EventId, TotalAttendees) VALUES (@EventId, @TotalAttendees)", connection);
command.Parameters.AddWithValue("@EventId", report.EventId);
command.Parameters.AddWithValue("@TotalAttendees", report.TotalAttendees);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateReport(AttendanceReport report)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE AttendanceReports SET EventId = @EventId, TotalAttendees = @TotalAttendees WHERE ReportId = @ReportId", connection);
command.Parameters.AddWithValue("@ReportId", report.ReportId);
command.Parameters.AddWithValue("@EventId", report.EventId);
command.Parameters.AddWithValue("@TotalAttendees", report.TotalAttendees);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteReport(int reportId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM AttendanceReports WHERE ReportId = @ReportId", connection);
command.Parameters.AddWithValue("@ReportId", reportId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
11. Financial Report Repository
Interface:
public interface IFinancialReportRepository
{
FinancialReport GetReportById(int financialReportId);
IEnumerable<FinancialReport> GetAllReports();
void AddReport(FinancialReport report);
void UpdateReport(FinancialReport report);
void DeleteReport(int financialReportId);
}
Implementation:
public class FinancialReportRepository : IFinancialReportRepository
{
private readonly string _connectionString;
public FinancialReportRepository(string connectionString)
{
_connectionString = connectionString;
}
public FinancialReport GetReportById(int financialReportId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM FinancialReports WHERE FinancialReportId = @FinancialReportId", connection);
command.Parameters.AddWithValue("@FinancialReportId", financialReportId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new FinancialReport
{
FinancialReportId = (int)reader["FinancialReportId"],
EventId = (int)reader["EventId"],
TotalRevenue = (decimal)reader["TotalRevenue"],
TotalExpenses = (decimal)reader["TotalExpenses"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public IEnumerable<FinancialReport> GetAllReports()
{
var reports = new List<FinancialReport>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM FinancialReports", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
reports.Add(new FinancialReport
{
FinancialReportId = (int)reader["FinancialReportId"],
EventId = (int)reader["EventId"],
TotalRevenue = (decimal)reader["TotalRevenue"],
TotalExpenses = (decimal)reader["TotalExpenses"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return reports;
}
public void AddReport(FinancialReport report)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO FinancialReports (EventId, TotalRevenue, TotalExpenses) VALUES (@EventId, @TotalRevenue, @TotalExpenses)", connection);
command.Parameters.AddWithValue("@EventId", report.EventId);
command.Parameters.AddWithValue("@TotalRevenue", report.TotalRevenue);
command.Parameters.AddWithValue("@TotalExpenses", report.TotalExpenses);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateReport(FinancialReport report)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE FinancialReports SET EventId = @EventId, TotalRevenue = @TotalRevenue, TotalExpenses = @TotalExpenses WHERE FinancialReportId = @FinancialReportId", connection);
command.Parameters.AddWithValue("@FinancialReportId", report.FinancialReportId);
command.Parameters.AddWithValue("@EventId", report.EventId);
command.Parameters.AddWithValue("@TotalRevenue", report.TotalRevenue);
command.Parameters.AddWithValue("@TotalExpenses", report.TotalExpenses);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteReport(int financialReportId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM FinancialReports WHERE FinancialReportId = @FinancialReportId", connection);
command.Parameters.AddWithValue("@FinancialReportId", financialReportId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
12. Performance Metric Repository
Interface:
public interface IPerformanceMetricRepository
{
PerformanceMetric GetMetricById(int metricId);
IEnumerable<PerformanceMetric> GetAllMetrics();
void AddMetric(PerformanceMetric metric);
void UpdateMetric(PerformanceMetric metric);
void DeleteMetric(int metricId);
}
Implementation:
public class PerformanceMetricRepository : IPerformanceMetricRepository
{
private readonly string _connectionString;
public PerformanceMetricRepository(string connectionString)
{
_connectionString = connectionString;
}
public PerformanceMetric GetMetricById(int metricId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM PerformanceMetrics WHERE MetricId = @MetricId", connection);
command.Parameters.AddWithValue("@MetricId", metricId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new PerformanceMetric
{
MetricId = (int)reader["MetricId"],
EventId = (int)reader["EventId"],
MetricName = reader["MetricName"].ToString(),
MetricValue = (decimal)reader["MetricValue"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public IEnumerable<PerformanceMetric> GetAllMetrics()
{
var metrics = new List<PerformanceMetric>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM PerformanceMetrics", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
metrics.Add(new PerformanceMetric
{
MetricId = (int)reader["MetricId"],
EventId = (int)reader["EventId"],
MetricName = reader["MetricName"].ToString(),
MetricValue = (decimal)reader["MetricValue"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return metrics;
}
public void AddMetric(PerformanceMetric metric)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO PerformanceMetrics (EventId, MetricName, MetricValue) VALUES (@EventId, @MetricName, @MetricValue)", connection);
command.Parameters.AddWithValue("@EventId", metric.EventId);
command.Parameters.AddWithValue("@MetricName", metric.MetricName);
command.Parameters.AddWithValue("@MetricValue", metric.MetricValue);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateMetric(PerformanceMetric metric)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE PerformanceMetrics SET EventId = @EventId, MetricName = @MetricName, MetricValue = @MetricValue WHERE MetricId = @MetricId", connection);
command.Parameters.AddWithValue("@MetricId", metric.MetricId);
command.Parameters.AddWithValue("@EventId", metric.EventId);
command.Parameters.AddWithValue("@MetricName", metric.MetricName);
command.Parameters.AddWithValue("@MetricValue", metric.MetricValue);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteMetric(int metricId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM PerformanceMetrics WHERE MetricId = @MetricId", connection);
command.Parameters.AddWithValue("@MetricId", metricId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
This completes the repository implementations for all the models based on the SQL schema you provided. Each repository follows a consistent pattern, allowing for easy data access and manipulation for the respective entities in your ASP.NET application. You can now utilize these repositories to perform CRUD operations on your database tables effectively.
Certainly! Below are the ASP.NET MVC controllers for each repository, designed to handle CRUD operations (Create, Read, Update, Delete) for each model. Each controller will interact with its respective repository and return views as needed.
1. UserController
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
public class UserController : Controller
{
private readonly IUserRepository _userRepository;
public UserController(IUser Repository userRepository)
{
_userRepository = userRepository;
}
public IActionResult Index()
{
var users = _userRepository.GetAllUsers();
return View(users);
}
public IActionResult Details(int id)
{
var user = _userRepository.GetUser ById(id);
return View(user);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(User user)
{
if (ModelState.IsValid)
{
_userRepository.AddUser (user);
return RedirectToAction(nameof(Index));
}
return View(user);
}
public IActionResult Edit(int id)
{
var user = _userRepository.GetUser ById(id);
return View(user);
}
[HttpPost]
public IActionResult Edit(User user)
{
if (ModelState.IsValid)
{
_userRepository.UpdateUser (user);
return RedirectToAction(nameof(Index));
}
return View(user);
}
public IActionResult Delete(int id)
{
var user = _userRepository.GetUser ById(id);
return View(user);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_userRepository.DeleteUser (id);
return RedirectToAction(nameof(Index));
}
}
2. RoleController
public class RoleController : Controller
{
private readonly IRoleRepository _roleRepository;
public RoleController(IRoleRepository roleRepository)
{
_roleRepository = roleRepository;
}
public IActionResult Index()
{
var roles = _roleRepository.GetAllRoles();
return View(roles);
}
public IActionResult Details(int id)
{
var role = _roleRepository.GetRoleById(id);
return View(role);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Role role)
{
if (ModelState.IsValid)
{
_roleRepository.AddRole(role);
return RedirectToAction(nameof(Index));
}
return View(role);
}
public IActionResult Edit(int id)
{
var role = _roleRepository.GetRoleById(id);
return View(role);
}
[HttpPost]
public IActionResult Edit(Role role)
{
if (ModelState.IsValid)
{
_roleRepository.UpdateRole(role);
return RedirectToAction(nameof(Index));
}
return View(role);
}
public IActionResult Delete(int id)
{
var role = _roleRepository.GetRoleById(id);
return View(role);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_roleRepository.DeleteRole(id);
return RedirectToAction(nameof(Index));
}
}
3. EventController
public class EventController : Controller
{
private readonly IEventRepository _eventRepository;
public EventController(IEventRepository eventRepository)
{
_eventRepository = eventRepository;
}
public IActionResult Index()
{
var events = _eventRepository.GetAllEvents();
return View(events);
}
public IActionResult Details(int id)
{
var event = _eventRepository.GetEventById(id);
return View(event);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Event event)
{
if (ModelState.IsValid)
{
_eventRepository.AddEvent(event);
return RedirectToAction(nameof(Index));
}
return View(event);
}
public IActionResult Edit(int id)
{
var event = _eventRepository.GetEventById(id);
return View(event);
}
[HttpPost]
public IActionResult Edit(Event event)
{
if (ModelState.IsValid)
{
_eventRepository.UpdateEvent(event);
return RedirectToAction(nameof(Index));
}
return View(event);
}
public IActionResult Delete(int id)
{
var event = _eventRepository.GetEventById(id);
return View(event);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_eventRepository.DeleteEvent(id);
return RedirectToAction(nameof(Index));
}
}
4. VenueController
public class VenueController : Controller
{
private readonly IVenueRepository _venueRepository;
public VenueController(IVenueRepository venueRepository)
{
_venueRepository = venueRepository;
}
public IActionResult Index()
{
var venues = _venueRepository.GetAllVenues();
return View(venues);
}
public IActionResult Details(int id)
{
var venue = _venueRepository.GetVenueById(id);
return View(venue);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Venue venue)
{
if (ModelState.IsValid)
{
_venueRepository.AddVenue(venue);
return RedirectToAction(nameof(Index));
}
return View(venue);
}
public IActionResult Edit(int id)
{
var venue = _venueRepository.GetVenueById(id);
return View(venue);
}
[HttpPost]
public IActionResult Edit(Venue venue)
{
if (ModelState.IsValid)
{
_venueRepository.UpdateVenue(venue);
return RedirectToAction(nameof(Index));
}
return View(venue);
}
public IActionResult Delete(int id)
{
var venue = _venueRepository.GetVenueById(id);
return View(venue);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_venueRepository.DeleteVenue(id);
return RedirectToAction(nameof(Index));
}
}
5. RegistrationController
public class RegistrationController : Controller
{
private readonly IRegistrationRepository _registrationRepository;
public RegistrationController(IRegistrationRepository registrationRepository)
{
_registrationRepository = registrationRepository;
}
public IActionResult Index()
{
var registrations = _registrationRepository .GetAllRegistrations();
return View(registrations);
}
public IActionResult Details(int id)
{
var registration = _registrationRepository.GetRegistrationById(id);
return View(registration);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Registration registration)
{
if (ModelState.IsValid)
{
_registrationRepository.AddRegistration(registration);
return RedirectToAction(nameof(Index));
}
return View(registration);
}
public IActionResult Edit(int id)
{
var registration = _registrationRepository.GetRegistrationById(id);
return View(registration);
}
[HttpPost]
public IActionResult Edit(Registration registration)
{
if (ModelState.IsValid)
{
_registrationRepository.UpdateRegistration(registration);
return RedirectToAction(nameof(Index));
}
return View(registration);
}
public IActionResult Delete(int id)
{
var registration = _registrationRepository.GetRegistrationById(id);
return View(registration);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_registrationRepository.DeleteRegistration(id);
return RedirectToAction(nameof(Index));
}
}
6. TicketController
public class TicketController : Controller
{
private readonly ITicketRepository _ticketRepository;
public TicketController(ITicketRepository ticketRepository)
{
_ticketRepository = ticketRepository;
}
public IActionResult Index()
{
var tickets = _ticketRepository.GetAllTickets();
return View(tickets);
}
public IActionResult Details(int id)
{
var ticket = _ticketRepository.GetTicketById(id);
return View(ticket);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Ticket ticket)
{
if (ModelState.IsValid)
{
_ticketRepository.AddTicket(ticket);
return RedirectToAction(nameof(Index));
}
return View(ticket);
}
public IActionResult Edit(int id)
{
var ticket = _ticketRepository.GetTicketById(id);
return View(ticket);
}
[HttpPost]
public IActionResult Edit(Ticket ticket)
{
if (ModelState.IsValid)
{
_ticketRepository.UpdateTicket(ticket);
return RedirectToAction(nameof(Index));
}
return View(ticket);
}
public IActionResult Delete(int id)
{
var ticket = _ticketRepository.GetTicketById(id);
return View(ticket);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_ticketRepository.DeleteTicket(id);
return RedirectToAction(nameof(Index));
}
}
7. NotificationController
public class NotificationController : Controller
{
private readonly INotificationRepository _notificationRepository;
public NotificationController(INotificationRepository notificationRepository)
{
_notificationRepository = notificationRepository;
}
public IActionResult Index()
{
var notifications = _notificationRepository.GetAllNotifications();
return View(notifications);
}
public IActionResult Details(int id)
{
var notification = _notificationRepository.GetNotificationById(id);
return View(notification);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Notification notification)
{
if (ModelState.IsValid)
{
_notificationRepository.AddNotification(notification);
return RedirectToAction(nameof(Index));
}
return View(notification);
}
public IActionResult Edit(int id)
{
var notification = _notificationRepository.GetNotificationById(id);
return View(notification);
}
[HttpPost]
public IActionResult Edit(Notification notification)
{
if (ModelState.IsValid)
{
_notificationRepository.UpdateNotification(notification);
return RedirectToAction(nameof(Index));
}
return View(notification);
}
public IActionResult Delete(int id)
{
var notification = _notificationRepository.GetNotificationById(id);
return View(notification);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_notificationRepository.DeleteNotification(id);
return RedirectToAction(nameof(Index));
}
}
8. VendorController
public class VendorController : Controller
{
private readonly IVendorRepository _vendorRepository;
public VendorController(IVendorRepository vendorRepository)
{
_vendorRepository = vendorRepository;
}
public IActionResult Index()
{
var vendors = _vendorRepository.GetAllVendors();
return View(vendors);
}
public IActionResult Details(int id)
{
var vendor = _vendorRepository.GetVendorById(id);
return View(vendor);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Vendor vendor)
{
if (ModelState.IsValid)
{
_vendorRepository.AddVendor(vendor);
return RedirectToAction(nameof(Index));
}
return View(vendor);
}
public IActionResult Edit(int id)
{
var vendor = _vendorRepository.GetVendorById(id);
return View(vendor);
}
[HttpPost]
public IActionResult Edit(Vendor vendor)
{
if (ModelState.IsValid)
{
_vendorRepository.UpdateVendor(vendor);
return RedirectToAction(nameof(Index));
}
return View(vendor);
}
public IActionResult Delete(int id)
{
var vendor = _vendorRepository.GetVendorById(id);
return View(vendor);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_vendorRepository.DeleteVendor(id);
return RedirectToAction(nameof(Index));
}
}
9. MarketingCampaignController
public class MarketingCampaignController : Controller
{
private readonly IMarketingCampaignRepository _campaignRepository;
public MarketingCampaignController(IMarketingCampaignRepository campaignRepository)
{
_campaignRepository = campaignRepository;
}
public IActionResult Index()
{
var campaigns = _campaignRepository.GetAllCampaigns();
return View(campaigns);
}
public IActionResult Details(int id)
{
var campaign = _campaignRepository.GetCampaignById(id);
return View(campaign);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(MarketingCampaign campaign)
{
if (ModelState.IsValid)
{
_campaignRepository.AddCampaign(campaign);
return RedirectToAction(nameof(Index));
}
return View(campaign);
}
public IActionResult Edit(int id)
{
var campaign = _campaignRepository.GetCampaignById(id);
return View(campaign);
}
[HttpPost]
public IActionResult Edit(MarketingCampaign campaign)
{
if (ModelState.IsValid)
{
_campaignRepository.UpdateCampaign(campaign);
return RedirectToAction(nameof(Index));
}
return View(campaign);
}
public IActionResult Delete(int id)
{
var campaign = _campaignRepository.GetCampaignById(id);
return View(campaign);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_campaignRepository.DeleteCampaign(id);
return RedirectToAction(nameof(Index));
}
}
10. FeedbackController
public class FeedbackController : Controller
{
private readonly IFeedbackRepository _feedbackRepository;
public FeedbackController(IFeedbackRepository feedbackRepository)
{
_feedbackRepository = feedbackRepository;
}
public IActionResult Index()
{
var feedbacks = _feedbackRepository.GetAllFeedbacks();
return View(feedbacks);
}
public IActionResult Details(int id)
{
var feedback = _feedbackRepository.GetFeedbackById(id);
return View(feedback);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Feedback feedback)
{
if (ModelState.IsValid)
{
_feedbackRepository.AddFeedback(feedback);
return RedirectToAction(nameof(Index));
}
return View(feedback);
}
public IActionResult Edit(int id)
{
var feedback = _feedbackRepository.GetFeedbackById(id);
return View(feedback);
}
[HttpPost]
public IActionResult Edit(Feedback feedback)
{
if (ModelState.IsValid)
{
_feedbackRepository.UpdateFeedback(feedback);
return RedirectToAction(nameof(Index));
}
return View(feedback);
}
public IActionResult Delete(int id)
{
var feedback = _feedbackRepository.GetFeedbackById(id);
return View(feedback);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_feedbackRepository.DeleteFeedback(id);
return RedirectToAction(nameof(Index));
}
}
11. AttendanceReportController
public class AttendanceReportController : Controller
{
private readonly IAttendanceReportRepository _reportRepository;
public AttendanceReportController(IAttendanceReportRepository reportRepository)
{
_reportRepository = reportRepository;
}
public IActionResult Index()
{
var reports = _reportRepository.GetAllReports();
return View(reports);
}
public IActionResult Details(int id)
{
var report = _reportRepository.GetReportById(id);
return View(report);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(AttendanceReport report)
{
if (ModelState.IsValid)
{
_reportRepository.AddReport(report);
return RedirectToAction(nameof(Index));
}
return View(report);
}
public IActionResult Edit(int id)
{
var report = _reportRepository.GetReportById(id);
return View(report);
}
[HttpPost]
public IActionResult Edit(AttendanceReport report)
{
if (ModelState.IsValid)
{
_reportRepository.UpdateReport(report);
return RedirectToAction(nameof(Index));
}
return View(report);
}
public IActionResult Delete(int id)
{
var report = _reportRepository.GetReportById(id);
return View(report);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_reportRepository.DeleteReport(id);
return RedirectToAction(nameof(Index));
}
}
12. FinancialReportController
public class FinancialReportController : Controller
{
private readonly IFinancialReportRepository _financialReportRepository;
public FinancialReportController(IFinancialReportRepository financialReportRepository)
{
_financialReportRepository = financialReportRepository;
}
public IActionResult Index()
{
var reports = _financialReportRepository.GetAllReports();
return View(reports);
}
public IActionResult Details(int id)
{
var report = _financialReportRepository.GetReportById(id);
return View(report);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(FinancialReport report)
{
if (ModelState.IsValid)
{
_financialReportRepository.AddReport(report);
return RedirectToAction(nameof(Index));
}
return View(report);
}
public IActionResult Edit(int id)
{
var report = _financialReportRepository.GetReportById(id);
return View(report);
}
[HttpPost]
public IActionResult Edit(FinancialReport report)
{
if (ModelState.IsValid)
{
_financialReportRepository.UpdateReport(report);
return RedirectToAction(nameof(Index));
}
return View(report);
}
public IActionResult Delete(int id)
{
var report = _financialReportRepository.GetReportById(id);
return View(report);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_financialReportRepository.DeleteReport(id);
return RedirectToAction(nameof(Index));
}
}
13. PerformanceMetricController
public class PerformanceMetricController : Controller
{
private readonly IPerformanceMetricRepository _metricRepository;
public PerformanceMetricController(IPerformanceMetricRepository metricRepository)
{
_metricRepository = metricRepository;
}
public IActionResult Index()
{
var metrics = _metricRepository.GetAllMetrics();
return View(metrics);
}
public IActionResult Details(int id)
{
var metric = _metricRepository.GetMetricById(id);
return View(metric);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(PerformanceMetric metric)
{
if (ModelState.IsValid)
{
_metricRepository.AddMetric(metric);
return RedirectToAction(nameof(Index));
}
return View(metric);
}
public IActionResult Edit(int id)
{
var metric = _metricRepository.GetMetricById(id);
return View(metric);
}
[HttpPost]
public IActionResult Edit(PerformanceMetric metric)
{
if (ModelState.IsValid)
{
_metricRepository.UpdateMetric(metric);
return RedirectToAction(nameof(Index));
}
return View(metric);
}
public IActionResult Delete(int id)
{
var metric = _metricRepository.GetMetricById(id);
return View(metric);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_metricRepository.DeleteMetric(id);
return RedirectToAction(nameof(Index));
}
}
This completes the creation of controllers for each repository, allowing for full CRUD operations on the respective models. Each controller follows a similar structure, ensuring consistency and ease of use within your ASP.NET MVC application. You can now create views for each action method to provide a user interface for interacting with the data.
Below are the view files for each controller, designed to handle CRUD operations (Create, Read, Update, Delete) for each model. Each set of views will include the necessary files for Index, Details, Create, Edit, and Delete actions.
1. User Views
Views/User/Index.cshtml
@model IEnumerable<User>
<h2>Users</h2>
<a asp-action="Create">Create New User</a>
<table>
<thead>
<tr>
<th>Username</th>
<th>Email</th>
<th>Phone</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var user in Model)
{
<tr>
<td>@user.Username</td>
<td>@user.Email</td>
<td>@user.Phone</td>
<td>
<a asp-action="Details" asp-route-id="@user.UserId">Details</a> |
<a asp-action="Edit" asp-route-id="@user.UserId">Edit</a> |
<a asp-action="Delete" asp-route-id="@user.UserId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/User/Details.cshtml
@model User
<h2>User Details</h2>
<div>
<h4>@Model.Username</h4>
<p>Email: @Model.Email</p>
<p>Phone: @Model.Phone</p>
<p>Role ID: @Model.RoleId</p>
<a asp-action="Edit" asp-route-id="@Model.UserId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/User/Create.cshtml
@model User
<h2>Create User</h2>
<form asp-action="Create">
<div>
<label asp-for="Username"></label>
<input asp-for="Username" />
<span asp-validation-for="Username"></span>
</div>
<div>
<label asp-for="PasswordHash"></label>
<input asp-for="PasswordHash" type="password" />
<span asp-validation-for="PasswordHash"></span>
</div>
<div>
<label asp-for="Email"></label>
<input asp-for="Email" />
<span asp-validation-for="Email"></span>
</div>
<div>
<label asp-for="Phone"></label>
<input asp-for="Phone" />
<span asp-validation-for="Phone"></span>
</div>
<div>
<label asp-for="RoleId"></label>
<input asp-for="RoleId" />
<span asp-validation-for="RoleId"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/User/Edit.cshtml
@model User
<h2>Edit User</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="User Id" />
<div>
<label asp-for="Username"></label>
<input asp-for="Username" />
<span asp-validation-for="Username"></span>
</div>
<div>
<label asp-for="Email"></label>
<input asp-for="Email" />
<span asp-validation-for="Email"></span>
</div>
<div>
<label asp-for="Phone"></label>
<input asp-for="Phone" />
<span asp-validation-for="Phone"></span>
</div>
<div>
<label asp-for="RoleId"></label>
<input asp-for="RoleId" />
<span asp-validation-for="RoleId"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/User/Delete.cshtml
@model User
<h2>Delete User</h2>
<div>
<h4>Are you sure you want to delete this user?</h4>
<div>
<h4>@Model.Username</h4>
<p>Email: @Model.Email</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="User Id" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
2. Role Views
Views/Role/Index.cshtml
@model IEnumerable<Role>
<h2>Roles</h2>
<a asp-action="Create">Create New Role</a>
<table>
<thead>
<tr>
<th>Role Name</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var role in Model)
{
<tr>
<td>@role.RoleName</td>
<td>
<a asp-action="Details" asp-route-id="@role.RoleId">Details</a> |
<a asp-action="Edit" asp-route-id="@role.RoleId">Edit</a> |
<a asp-action="Delete" asp-route-id="@role.RoleId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Role/Details.cshtml
@model Role
<h2>Role Details</h2>
<div>
<h4>@Model.RoleName</h4>
<a asp-action="Edit" asp-route-id="@Model.RoleId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Role/Create.cshtml
@model Role
<h2>Create Role</h2>
<form asp-action="Create">
<div>
<label asp-for="RoleName"></label>
<input asp-for="RoleName" />
<span asp-validation-for="RoleName"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Role/Edit.cshtml
@model Role
<h2>Edit Role</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="RoleId" />
<div>
<label asp-for="RoleName"></label>
<input asp -for="RoleName" />
<span asp-validation-for="RoleName"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Role/Delete.cshtml
@model Role
<h2>Delete Role</h2>
<div>
<h4>Are you sure you want to delete this role?</h4>
<div>
<h4>@Model.RoleName</h4>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="RoleId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
3. Event Views
Views/Event/Index.cshtml
@model IEnumerable<Event>
<h2>Events</h2>
<a asp-action="Create">Create New Event</a>
<table>
<thead>
<tr>
<th>Event Name</th>
<th>Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var event in Model)
{
<tr>
<td>@event.EventName</td>
<td>@event.EventDate.ToShortDateString()</td>
<td>
<a asp-action="Details" asp-route-id="@event.EventId">Details</a> |
<a asp-action="Edit" asp-route-id="@event.EventId">Edit</a> |
<a asp-action="Delete" asp-route-id="@event.EventId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Event/Details.cshtml
@model Event
<h2>Event Details</h2>
<div>
<h4>@Model.EventName</h4>
<p>Date: @Model.EventDate.ToShortDateString()</p>
<p>Venue: @Model.VenueId</p>
<a asp-action="Edit" asp-route-id="@Model.EventId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Event/Create.cshtml
@model Event
<h2>Create Event</h2>
<form asp-action="Create">
<div>
<label asp-for="EventName"></label>
<input asp-for="EventName" />
<span asp-validation-for="EventName"></span>
</div>
<div>
<label asp-for="EventDate"></label>
<input asp-for="EventDate" type="date" />
<span asp-validation-for="EventDate"></span>
</div>
<div>
<label asp-for="VenueId"></label>
<input asp-for="VenueId" />
<span asp-validation-for="VenueId"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Event/Edit.cshtml
@model Event
<h2>Edit Event</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="EventId" />
<div>
<label asp-for="EventName"></label>
<input asp-for="EventName" />
<span asp-validation-for="EventName"></span>
</div>
<div>
<label asp-for="EventDate"></label>
<input asp-for="EventDate" type="date" />
<span asp-validation-for="EventDate"></span>
</div>
<div>
<label asp-for="VenueId"></label>
<input asp-for="VenueId" />
<span asp-validation-for="VenueId"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Event/Delete.cshtml
@model Event
<h2>Delete Event</h2>
<div>
<h4>Are you sure you want to delete this event?</h4>
<div>
<h4>@Model.EventName</h4>
<p>Date: @Model.EventDate.ToShortDateString()</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="EventId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
4. Venue Views
Views/Venue/Index.cshtml
@model IEnumerable <Venue>
<h2>Venues</h2>
<a asp-action="Create">Create New Venue</a>
<table>
<thead>
<tr>
<th>Venue Name</th>
<th>Location</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var venue in Model)
{
<tr>
<td>@venue.VenueName</td>
<td>@venue.Location</td>
<td>
<a asp-action="Details" asp-route-id="@venue.VenueId">Details</a> |
<a asp-action="Edit" asp-route-id="@venue.VenueId">Edit</a> |
<a asp-action="Delete" asp-route-id="@venue.VenueId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Venue/Details.cshtml
@model Venue
<h2>Venue Details</h2>
<div>
<h4>@Model.VenueName</h4>
<p>Location: @Model.Location</p>
<a asp-action="Edit" asp-route-id="@Model.VenueId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Venue/Create.cshtml
@model Venue
<h2>Create Venue</h2>
<form asp-action="Create">
<div>
<label asp-for="VenueName"></label>
<input asp-for="VenueName" />
<span asp-validation-for="VenueName"></span>
</div>
<div>
<label asp-for="Location"></label>
<input asp-for="Location" />
<span asp-validation-for="Location"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Venue/Edit.cshtml
@model Venue
<h2>Edit Venue</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="VenueId" />
<div>
<label asp-for="VenueName"></label>
<input asp-for="VenueName" />
<span asp-validation-for="VenueName"></span>
</div>
<div>
<label asp-for="Location"></label>
<input asp-for="Location" />
<span asp-validation-for="Location"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Venue/Delete.cshtml
@model Venue
<h2>Delete Venue</h2>
<div>
<h4>Are you sure you want to delete this venue?</h4>
<div>
<h4>@Model.VenueName</h4>
<p>Location: @Model.Location</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="VenueId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
5. Registration Views
Views/Registration/Index.cshtml
@model IEnumerable<Registration>
<h2>Registrations</h2>
<a asp-action="Create">Create New Registration</a>
<table>
<thead>
<tr>
<th>Event Name</th>
<th>User Name</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var registration in Model)
{
<tr>
<td>@registration.EventName</td>
<td>@registration.UserName</td>
<td>
<a asp-action="Details" asp-route-id="@registration.RegistrationId">Details</a> |
<a asp-action="Edit" asp-route-id="@registration.RegistrationId">Edit</a> |
<a asp-action="Delete" asp-route-id="@registration.RegistrationId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Registration/Details.cshtml
@model Registration
<h2>Registration Details</h2>
<div>
<h4>Event: @Model.EventName</h4>
<p>User: @Model.UserName</p>
<a asp-action="Edit" asp-route-id="@Model.RegistrationId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Registration/Create.cshtml
@model Registration
<h2>Edit Registration</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="RegistrationId" />
<div>
<label asp-for="EventName"></label>
<input asp-for="EventName" />
<span asp-validation-for="EventName"></span>
</div>
<div>
<label asp-for="User Name"></label>
<input asp-for="User Name" />
<span asp-validation-for="User Name"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Registration/Delete.cshtml
@model Registration
<h2>Delete Registration</h2>
<div>
<h4>Are you sure you want to delete this registration?</h4>
<div>
<h4>Event: @Model.EventName</h4>
<p>User: @Model.UserName</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="RegistrationId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
6. Ticket Views
Views/Ticket/Index.cshtml
@model IEnumerable<Ticket>
<h2>Tickets</h2>
<a asp-action="Create">Create New Ticket</a>
<table>
<thead>
<tr>
<th>Ticket Number</th>
<th>Event Name</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var ticket in Model)
{
<tr>
<td>@ticket.TicketNumber</td>
<td>@ticket.EventName</td>
<td>
<a asp-action="Details" asp-route-id="@ticket.TicketId">Details</a> |
<a asp-action="Edit" asp-route-id="@ticket.TicketId">Edit</a> |
<a asp-action="Delete" asp-route-id="@ticket.TicketId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Ticket/Details.cshtml
@model Ticket
<h2>Ticket Details</h2>
<div>
<h4>Ticket Number: @Model.TicketNumber</h4>
<p>Event: @Model.EventName</p>
<a asp-action="Edit" asp-route-id="@Model.TicketId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Ticket/Create.cshtml
@model Ticket
<h2>Create Ticket</h2>
<form asp-action="Create">
<div>
<label asp-for="TicketNumber"></label>
<input asp-for="TicketNumber" />
<span asp-validation-for="TicketNumber"></span>
</div>
<div>
<label asp-for="EventName"></label>
<input asp-for="EventName" />
<span asp-validation-for="EventName"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Ticket/Edit.cshtml
@model Ticket
<h2>Edit Ticket</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="TicketId" />
<div>
<label asp-for="TicketNumber"></label>
<input asp-for="TicketNumber" />
<span asp-validation-for="TicketNumber"></span>
</div>
<div>
<label asp-for="EventName"></label>
<input asp-for="EventName" />
<span asp-validation-for="EventName"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Ticket/Delete.cshtml
@model Ticket
<h2>Delete Ticket</h2>
<div>
<h4>Are you sure you want to delete this ticket?</h4>
<div>
<h4>Ticket Number: @Model.TicketNumber</h4>
<p>Event: @Model.EventName</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="TicketId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
7. Notification Views
Views/Notification/Index.cshtml
@model IEnumerable<Notification>
<h2>Notifications</h2>
<a asp-action="Create">Create New Notification</a>
<table>
<thead>
<tr>
<th>Notification Title</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var notification in Model)
{
<tr>
<td>@notification.Title</td>
<td>
<a asp-action="Details" asp-route-id="@notification.NotificationId">Details</a> |
<a asp-action="Edit" asp-route-id="@notification.NotificationId">Edit</a> |
<a asp-action="Delete" asp-route-id="@notification.NotificationId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Notification/Details.cshtml
@model Notification
<h2>Notification Details</h2>
<div>
<h4>@Model.Title</h4>
<p>@Model.Message</p>
<a asp-action="Edit" asp-route-id="@Model.NotificationId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Notification/Create.cshtml
@model Notification
<h2>Create Notification</h2>
<form asp-action="Create">
<div>
<label asp-for="Title"></label>
<input asp-for="Title" />
<span asp-validation-for="Title"></span>
</div>
<div>
<label asp-for="Message"></label>
<textarea asp-for="Message"></textarea>
<span asp-validation-for="Message"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Notification/Edit.cshtml
@model Notification
<h2>Edit Notification</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="NotificationId" />
<div>
<label asp-for="Title"></label>
<input asp-for="Title" />
<span asp-validation-for="Title"></span>
</div>
<div>
<label asp-for="Message"></label>
<textarea asp-for="Message"></textarea>
<span asp-validation-for="Message"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Notification/Delete.cshtml
@model Notification
<h2>Delete Notification</h2>
<div>
<h4>Are you sure you want to delete this notification?</h4>
<div>
<h4>@Model.Title</h4>
<p>@Model.Message</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="NotificationId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
8. Vendor Views
Views/Vendor/Index.cshtml
@model IEnumerable<Vendor>
<h2>Vendors</h2>
<a asp-action="Create">Create New Vendor</a>
<table>
<thead>
<tr>
<th>Vendor Name</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var vendor in Model)
{
<tr>
<td>@vendor.VendorName</td>
<td>
<a asp-action="Details" asp-route-id="@vendor.VendorId">Details</a> |
<a asp-action="Edit" asp-route-id="@vendor.VendorId">Edit</a> |
<a asp-action="Delete" asp-route-id="@vendor.VendorId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Vendor/Details.cshtml
@model Vendor
<h2>Vendor Details</h2>
<div>
<h4>@Model.VendorName</h4>
<p>Contact: @Model.ContactInfo</p>
<a asp-action="Edit" asp-route-id="@Model.VendorId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Vendor/Create.cshtml
@model Vendor
<h2>Create Vendor</h2>
<form asp-action="Create">
<div>
<label asp-for="VendorName"></label>
<input asp-for="VendorName" />
<span asp-validation-for="VendorName"></span>
</div>
<div>
<label asp-for="ContactInfo"></label>
<input asp-for="ContactInfo" />
<span asp-validation-for="ContactInfo"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Vendor/Edit.cshtml
@model Vendor
<h2>Edit Vendor</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="VendorId" />
<div>
<label asp-for="VendorName"></label>
<input asp-for="VendorName" />
<span asp-validation-for="VendorName"></span>
</div>
<div>
<label asp-for="ContactInfo"></label>
<input asp-for="ContactInfo" />
<span asp-validation-for="ContactInfo"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Vendor/Delete.cshtml
@model Vendor
<h2>Delete Vendor</h2>
<div>
<h4>Are you sure you want to delete this vendor?</h4>
<div>
<h4>@Model.VendorName</h4>
<p>Contact: @Model.ContactInfo</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="VendorId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
9. Marketing Campaign Views
Views/MarketingCampaign/Index.cshtml
@model IEnumerable<MarketingCampaign>
<h2>Marketing Campaigns</h2>
<a asp-action="Create">Create New Campaign</a>
<table>
<thead>
<tr>
<th>Campaign Name</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var campaign in Model)
{
<tr>
<td>@campaign.CampaignName</td>
<td>
<a asp-action="Details" asp-route-id="@campaign.CampaignId">Details</a> |
<a asp-action="Edit" asp-route-id="@campaign.CampaignId">Edit</a> |
<a asp-action="Delete" asp-route-id="@campaign.CampaignId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/MarketingCampaign/Details.cshtml
@model MarketingCampaign
<h2>Campaign Details</h2>
<div>
<h4>@Model.CampaignName</h4>
<p>Description: @Model.Description</p>
<a asp-action="Edit" asp-route-id="@Model.CampaignId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/MarketingCampaign/Create.cshtml
@model MarketingCampaign
<h2>Create Campaign</h2>
<form asp-action="Create">
<div>
<label asp-for="CampaignName"></label>
<input asp-for="CampaignName" />
<span asp-validation-for="CampaignName"></span>
</div>
<div>
<label asp-for="Description"></label>
<textarea asp-for="Description"></textarea>
<span asp-validation-for="Description"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/MarketingCampaign/Edit.cshtml
@model MarketingCampaign
<h2>Edit Campaign</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="CampaignId" />
<div>
<label asp-for="CampaignName"></label>
<input asp-for="CampaignName" />
<span asp-validation-for="CampaignName"></span>
</div>
<div>
<label asp-for="Description"></label>
<textarea asp-for="Description"></textarea>
<span asp-validation-for="Description"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/MarketingCampaign/Delete.cshtml
@model MarketingCampaign
<h2>Delete Campaign</h2>
<div>
<h4>Are you sure you want to delete this campaign?</h4>
<div>
<h4>@Model.CampaignName</h4>
<p>Description: @Model.Description</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="CampaignId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
10. Feedback Views
Views/Feedback/Index.cshtml
@model IEnumerable<Feedback>
<h2>Feedbacks</h2>
<a asp-action="Create">Create New Feedback</a>
<table>
<thead>
<tr>
<th>Feedback Title</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var feedback in Model)
{
<tr>
<td>@feedback.Title</td>
<td>
<a asp-action="Details" asp-route-id="@feedback.FeedbackId">Details</a> |
<a asp-action="Edit" asp-route-id="@feedback.FeedbackId">Edit</a> |
<a asp-action="Delete" asp-route-id="@feedback.FeedbackId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Feedback/Details.cshtml
@model Feedback
<h2>Feedback Details</h2>
<div>
<h4>@Model.Title</h4>
<p>@Model.Content</p>
<a asp-action="Edit" asp-route-id="@Model.FeedbackId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/Feedback/Create.cshtml
@model Feedback
<h2>Create Feedback</h2>
<form asp-action="Create">
<div>
<label asp-for="Title"></label>
<input asp-for="Title" />
<span asp-validation-for="Title"></span>
</div>
<div>
<label asp-for="Content"></label>
<textarea asp-for="Content"></textarea>
<span asp-validation-for="Content"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Feedback/Edit.cshtml
@model Feedback
<h2>Edit Feedback</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="FeedbackId" />
<div>
<label asp-for="Title"></label>
<input asp-for="Title" />
<span asp-validation-for="Title"></span>
</div>
<div>
<label asp-for="Content"></label>
<textarea asp-for="Content"></textarea>
<span asp-validation-for="Content"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/Feedback/Delete.cshtml
@model Feedback
<h2>Delete Feedback</h2>
<div>
<h4>Are you sure you want to delete this feedback?</h4>
<div>
<h4>@Model.Title</h4>
<p>@Model.Content</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="FeedbackId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
11. Attendance Report Views
Views/AttendanceReport/Index.cshtml
@model IEnumerable<AttendanceReport>
<h2>Attendance Reports</h2>
<a asp-action="Create">Create New Report</a>
<table>
<thead>
<tr>
<th>Event Name</th>
<th>Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var report in Model)
{
<tr>
<td>@report.Event Name</td>
<td>@report.Date.ToShortDateString()</td>
<td>
<a asp-action="Details" asp-route-id="@report.ReportId">Details</a> |
<a asp-action="Edit" asp-route-id="@report.ReportId">Edit</a> |
<a asp-action="Delete" asp-route-id="@report.ReportId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/AttendanceReport/Details.cshtml
@model AttendanceReport
<h2>Attendance Report Details</h2>
<div>
<h4>Event: @Model.EventName</h4>
<p>Date: @Model.Date.ToShortDateString()</p>
<p>Attendees: @Model.AttendeeCount</p>
<a asp-action="Edit" asp-route-id="@Model.ReportId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/AttendanceReport/Create.cshtml
@model AttendanceReport
<h2>Create Attendance Report</h2>
<form asp-action="Create">
<div>
<label asp-for="EventName"></label>
<input asp-for="EventName" />
<span asp-validation-for="EventName"></span>
</div>
<div>
<label asp-for="Date"></label>
<input asp-for="Date" type="date" />
<span asp-validation-for="Date"></span>
</div>
<div>
<label asp-for="AttendeeCount"></label>
<input asp-for="AttendeeCount" />
<span asp-validation-for="AttendeeCount"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/AttendanceReport/Edit.cshtml
@model AttendanceReport
<h2>Edit Attendance Report</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="ReportId" />
<div>
<label asp-for="EventName"></label>
<input asp-for="EventName" />
<span asp-validation-for="EventName"></span>
</div>
<div>
<label asp-for="Date"></label>
<input asp-for="Date" type="date" />
<span asp-validation-for="Date"></span>
</div>
<div>
<label asp-for="AttendeeCount"></label>
<input asp-for="AttendeeCount" />
<span asp-validation-for="AttendeeCount"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/AttendanceReport/Delete.cshtml
@model AttendanceReport
<h2>Delete Attendance Report</h2>
<div>
<h4>Are you sure you want to delete this report?</h4>
<div>
<h4>Event: @Model.EventName</h4>
<p>Date: @Model.Date.ToShortDateString()</p>
<p>Attendees: @Model.AttendeeCount</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="ReportId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
12. Financial Report Views
Views/FinancialReport/Index.cshtml
@model IEnumerable<FinancialReport>
<h2>Financial Reports</h2>
<a asp-action="Create">Create New Report</a>
<table>
<thead>
<tr>
<th>Report Title</th>
<th>Amount</th>
<th>Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var report in Model)
{
<tr>
<td>@report.Title</td>
<td>@report.Amount.ToString("C")</td>
<td>@report.Date.ToShortDateString()</td>
<td>
<a asp-action="Details" asp-route-id="@report.ReportId">Details</a> |
<a asp-action="Edit" asp-route-id="@report.ReportId">Edit</a> |
<a asp-action="Delete" asp-route-id="@report.ReportId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/FinancialReport/Details.cshtml
@model FinancialReport
<h2>Financial Report Details</h2>
<div>
<h4>@Model.Title</h4>
<p>Amount: @Model.Amount.ToString("C")</p>
<p>Date: @Model.Date.ToShortDateString()</p>
<a asp-action="Edit" asp-route-id="@Model.ReportId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/FinancialReport/Create.cshtml
@model FinancialReport
<h2>Create Financial Report</h2>
<form asp-action="Create">
<div>
<label asp-for="Title"></label>
<input asp-for="Title" />
<span asp-validation-for="Title"></span>
</div>
<div>
<label asp-for="Amount"></label>
<input asp-for="Amount" type="number" step="0.01" />
<span asp-validation-for="Amount"></span>
</div>
<div>
<label asp-for="Date"></label>
<input asp-for="Date" type="date" />
<span asp-validation-for="Date"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/FinancialReport/Edit.cshtml
@model FinancialReport
<h2>Edit Financial Report</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="ReportId" />
<div>
<label asp-for="Title"></label>
<input asp-for="Title" />
<span asp-validation-for="Title"></span>
</div>
<div>
<label asp-for="Amount"></label>
<input asp-for="Amount" type="number" step="0.01" />
<span asp-validation-for="Amount"></span>
</div>
<div>
<label asp-for="Date"></label>
<input asp-for="Date" type="date" />
<span asp-validation-for="Date"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/FinancialReport/Delete.cshtml
@model FinancialReport
<h2>Delete Financial Report</h2>
<div>
<h4>Are you sure you want to delete this report?</h4>
<div>
<h4>@Model.Title</h4>
<p>Amount: @Model.Amount.ToString("C")</p>
<p>Date: @Model.Date.ToShortDateString()</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="ReportId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
13. Performance Metric Views
Views/PerformanceMetric/Index.cshtml
@model IEnumerable<PerformanceMetric>
<h2>Performance Metrics</h2>
<a asp-action="Create">Create New Metric</a>
<table>
<thead>
<tr>
<th>Metric Name</th>
<th>Value</th>
<th>Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var metric in Model)
{
<tr>
<td>@metric.Name</td>
<td>@metric.Value</td>
<td>@metric.Date.ToShortDateString()</td>
<td>
<a asp-action="Details" asp-route-id="@metric.MetricId">Details</a> |
<a asp-action="Edit" asp-route-id="@metric.MetricId">Edit</a> |
<a asp-action="Delete" asp-route-id="@metric.MetricId">Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/PerformanceMetric/Details.cshtml
@model PerformanceMetric
<h2>Performance Metric Details</h2>
<div>
<h4>@Model.Name</h4>
<p>Value: @Model.Value</p>
<p>Date: @Model.Date.ToShortDateString()</p>
<a asp-action="Edit" asp-route-id="@Model.MetricId">Edit</a> |
<a asp-action="Index">Back to List</a>
</div>
Views/PerformanceMetric/Create.cshtml
@model PerformanceMetric
<h2>Create Performance Metric</h2>
<form asp-action="Create">
<div>
< label asp-for="Name"></label>
<input asp-for="Name" />
<span asp-validation-for="Name"></span>
</div>
<div>
<label asp-for="Value"></label>
<input asp-for="Value" />
<span asp-validation-for="Value"></span>
</div>
<div>
<label asp-for="Date"></label>
<input asp-for="Date" type="date" />
<span asp-validation-for="Date"></span>
</div>
<button type="submit">Create</button>
<a asp-action="Index">Cancel</a>
</form>
Views/PerformanceMetric/Edit.cshtml
@model PerformanceMetric
<h2>Edit Performance Metric</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="MetricId" />
<div>
<label asp-for="Name"></label>
<input asp-for="Name" />
<span asp-validation-for="Name"></span>
</div>
<div>
<label asp-for="Value"></label>
<input asp-for="Value" />
<span asp-validation-for="Value"></span>
</div>
<div>
<label asp-for="Date"></label>
<input asp-for="Date" type="date" />
<span asp-validation-for="Date"></span>
</div>
<button type="submit">Save</button>
<a asp-action="Index">Cancel</a>
</form>
Views/PerformanceMetric/Delete.cshtml
@model PerformanceMetric
<h2>Delete Performance Metric</h2>
<div>
<h4>Are you sure you want to delete this metric?</h4>
<div>
<h4>@Model.Name</h4>
<p>Value: @Model.Value</p>
<p>Date: @Model.Date.ToShortDateString()</p>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="MetricId" />
<button type="submit">Delete</button>
<a asp-action="Index">Cancel</a>
</form>
</div>
This completes the creation of view files for all controllers, allowing for full CRUD operations on the respective models. Each view follows a consistent structure, ensuring ease of use within your ASP.NET MVC application. You can now integrate these views with the controllers to provide a complete user interface for managing your data.
To create a dashboard page that displays consolidated data related to your project, we will follow these steps:
- Create a Dashboard ViewModel: This will hold the aggregated data from various repositories.
- Create a Dashboard Controller: This will fetch the data from the repositories and pass it to the view.
- Create the Dashboard View: This will display the consolidated data in a user-friendly format.
Step 1: Create a Dashboard ViewModel
First, we need to create a ViewModel that will hold the consolidated data for the dashboard.
Models/DashboardViewModel.cs
public class DashboardViewModel
{
public int TotalUsers { get; set; }
public int TotalRoles { get; set; }
public int TotalEvents { get; set; }
public int TotalVenues { get; set; }
public int TotalRegistrations { get; set; }
public int TotalTickets { get; set; }
public int TotalNotifications { get; set; }
public int TotalVendors { get; set; }
public int TotalMarketingCampaigns { get; set; }
public int TotalFeedbacks { get; set; }
public int TotalAttendanceReports { get; set; }
public int TotalFinancialReports { get; set; }
public int TotalPerformanceMetrics { get; set; }
}
Step 2: Create a Dashboard Controller
Next, we will create a controller that will fetch the necessary data from the repositories and pass it to the dashboard view.
Controllers/DashboardController.cs
public class DashboardController : Controller
{
private readonly IUserRepository _userRepository;
private readonly IRoleRepository _roleRepository;
private readonly IEventRepository _eventRepository;
private readonly IVenueRepository _venueRepository;
private readonly IRegistrationRepository _registrationRepository;
private readonly ITicketRepository _ticketRepository;
private readonly INotificationRepository _notificationRepository;
private readonly IVendorRepository _vendorRepository;
private readonly IMarketingCampaignRepository _campaignRepository;
private readonly IFeedbackRepository _feedbackRepository;
private readonly IAttendanceReportRepository _attendanceReportRepository;
private readonly IFinancialReportRepository _financialReportRepository;
private readonly IPerformanceMetricRepository _performanceMetricRepository;
public DashboardController(IUser Repository userRepository, IRoleRepository roleRepository,
IEventRepository eventRepository, IVenueRepository venueRepository,
IRegistrationRepository registrationRepository, ITicketRepository ticketRepository,
INotificationRepository notificationRepository, IVendorRepository vendorRepository,
IMarketingCampaignRepository campaignRepository, IFeedbackRepository feedbackRepository,
IAttendanceReportRepository attendanceReportRepository, IFinancialReportRepository financialReportRepository,
IPerformanceMetricRepository performanceMetricRepository)
{
_userRepository = userRepository;
_roleRepository = roleRepository;
_eventRepository = eventRepository;
_venueRepository = venueRepository;
_registrationRepository = registrationRepository;
_ticketRepository = ticketRepository;
_notificationRepository = notificationRepository;
_vendorRepository = vendorRepository;
_campaignRepository = campaignRepository;
_feedbackRepository = feedbackRepository;
_attendanceReportRepository = attendanceReportRepository;
_financialReportRepository = financialReportRepository;
_performanceMetricRepository = performanceMetricRepository;
}
public IActionResult Index()
{
var model = new DashboardViewModel
{
TotalUsers = _userRepository.GetAllUsers().Count(),
TotalRoles = _roleRepository.GetAllRoles().Count(),
TotalEvents = _eventRepository.GetAllEvents().Count(),
TotalVenues = _venueRepository.GetAllVenues().Count(),
TotalRegistrations = _registrationRepository.GetAllRegistrations().Count(),
TotalTickets = _ticketRepository.GetAllTickets().Count(),
TotalNotifications = _notificationRepository.GetAllNotifications().Count(),
TotalVendors = _vendorRepository.GetAllVendors().Count(),
TotalMarketingCampaigns = _campaignRepository.GetAllCampaigns().Count(),
TotalFeedbacks = _feedbackRepository.GetAllFeedbacks().Count(),
TotalAttendanceReports = _attendanceReportRepository.GetAllReports().Count(),
TotalFinancialReports = _financialReportRepository.GetAllReports().Count(),
TotalPerformanceMetrics = _performanceMetricRepository.GetAllMetrics().Count()
};
return View(model);
}
}
Step 3: Create the Dashboard View
Now, we will create the view that will display the dashboard data.
Views/Dashboard/Index.cshtml
@model DashboardViewModel
<h2>Dashboard</h2>
<div class="dashboard">
<div class="card">
<h3>Total Users</h3>
<p>@Model.TotalUsers</p>
</div>
<div class="card">
<h3>Total Roles</h3>
<p>@Model.TotalRoles</p>
</div>
<div class="card">
<h3>Total Events</h3>
<p>@Model.TotalEvents</p>
</div>
<div class="card">
<h3>Total Venues</h3>
<p>@Model.TotalVenues</p>
</div>
<div class="card">
<h3>Total Registrations</h3>
<p>@Model.TotalRegistrations</p>
</div>
<div class="card">
<h3>Total Tickets</h3>
<p>@Model.TotalTickets</p>
</div>
<div class="card">
<h3>Total Notifications</h3>
<p>@Model.TotalNotifications</p>
</div>
<div class="card">
<h3>Total Vendors</h3>
<p>@Model.TotalVendors</p>
</div>
<div class="card">
<h3>Total Marketing Campaigns</h3>
<p>@Model.TotalMarketingCampaigns</p>
</div>
<div class="card">
<h3>Total Feedbacks</h3>
<p>@Model.TotalFeedbacks</p>
</div>
<div class="card">
<h3>Total Attendance Reports</h3>
<p>@Model.TotalAttendanceReports</p>
</div>
<div class="card">
<h3>Total Financial Reports</h3>
<p>@Model.TotalFinancialReports</p>
</div>
<div class="card">
<h3>Total Performance Metrics</h3>
<p>@Model.TotalPerformanceMetrics</p>
</div>
</div>
<style>
.dashboard {
display: flex;
flex-wrap: wrap;
gap: 20px;
}
.card {
border: 1px solid #ccc;
border-radius: 8px;
padding: 20px;
width: 200px;
text-align: center;
box-shadow: 0 2px 5px rgba(0, 0, 0, 0.1);
}
h2 {
text-align: center;
}
</style>
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