Project Introduction
The Leave Management System is designed to streamline the process of managing employee leave requests within an organization. Built using ASP.NET and SQL Server, this application provides a user-friendly interface for employees to submit leave requests, track their leave balances, and receive notifications regarding the status of their requests. Additionally, it allows HR personnel to manage leave types, approve or reject requests, and generate reports on leave usage, ensuring efficient leave management and compliance with company policies.
Project Objectives
- To create a secure user authentication system for managing user accounts and roles.
- To enable employees to submit leave requests and track their status.
- To manage different types of leave and their associated policies.
- To maintain accurate leave balances for each employee based on their leave types.
- To implement a notification system to inform users about the status of their leave requests.
- To collect feedback from users to improve the system's functionality and user experience.
- To generate reports on leave usage and trends for management review.
- To provide a calendar view of leave events for better planning and resource allocation.
Project Modules
- User Management Module: Handles user registration, login, and role management.
- Leave Request Module: Allows employees to submit and manage their leave requests.
- Leave Type Management Module: Manages different types of leave and their descriptions.
- Leave Balance Management Module: Tracks and updates leave balances for employees.
- Notification Module: Sends notifications to users regarding leave request statuses.
- Report Generation Module: Generates reports on leave usage and employee leave trends.
- Calendar Module: Displays leave events in a calendar format for better visibility.
- Feedback Module: Collects user feedback to enhance the system.
- Company Policy Module: Manages company policies related to leave management.
SQL Server Database Tables
-- Create Users Table
CREATE TABLE Users (
UserId INT PRIMARY KEY IDENTITY(1,1),
Username NVARCHAR(50) NOT NULL UNIQUE,
PasswordHash NVARCHAR(256) NOT NULL,
Email NVARCHAR(100) NOT NULL UNIQUE,
FirstName NVARCHAR(50) NOT NULL,
LastName NVARCHAR(50) NOT NULL,
RoleId INT NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (RoleId) REFERENCES Roles(RoleId)
);
-- Create Roles Table
CREATE TABLE Roles (
RoleId INT PRIMARY KEY IDENTITY(1,1),
RoleName NVARCHAR(50) NOT NULL UNIQUE,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE()
);
-- Create LeaveTypes Table
CREATE TABLE LeaveTypes (
LeaveTypeId INT PRIMARY KEY IDENTITY(1,1),
LeaveTypeName NVARCHAR(50) NOT NULL UNIQUE,
Description NVARCHAR(255),
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE()
);
-- Create LeaveRequests Table
CREATE TABLE LeaveRequests (
LeaveRequestId INT PRIMARY KEY IDENTITY(1,1),
UserId INT NOT NULL,
LeaveTypeId INT NOT NULL,
StartDate DATETIME NOT NULL,
EndDate DATETIME NOT NULL,
Status NVARCHAR(20) NOT NULL, -- e.g., Pending, Approved, Rejected
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId),
FOREIGN KEY (LeaveTypeId) REFERENCES LeaveTypes(LeaveTypeId)
);
-- Create LeaveBalances Table
CREATE TABLE LeaveBalances (
LeaveBalanceId INT PRIMARY KEY IDENTITY(1,1),
UserId INT NOT NULL,
LeaveTypeId INT NOT NULL,
TotalLeaves INT NOT NULL,
UsedLeaves INT NOT NULL DEFAULT 0,
RemainingLeaves AS (TotalLeaves - UsedLeaves) PERSISTED,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId),
FOREIGN KEY (LeaveTypeId) REFERENCES LeaveTypes(LeaveTypeId)
);
-- Create Notifications Table
CREATE TABLE Notifications (
NotificationId INT PRIMARY KEY IDENTITY(1,1),
UserId INT NOT NULL,
Message NVARCHAR(255) NOT NULL,
IsRead BIT NOT NULL DEFAULT 0,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- Create Reports Table
CREATE TABLE Reports (
ReportId INT PRIMARY KEY IDENTITY(1,1),
UserId INT NOT NULL,
ReportDate DATETIME NOT NULL,
ReportContent NVARCHAR(MAX),
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- Create CalendarEvents Table
CREATE TABLE CalendarEvents (
CalendarEventId INT PRIMARY KEY IDENTITY(1,1),
UserId INT NOT NULL,
EventTitle NVARCHAR(100) NOT NULL,
EventDate DATETIME NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- Create Feedback Table
CREATE TABLE Feedback (
FeedbackId INT PRIMARY KEY IDENTITY(1,1),
UserId INT NOT NULL,
FeedbackContent NVARCHAR(MAX) NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- Create CompanyPolicies Table
CREATE TABLE CompanyPolicies (
PolicyId INT PRIMARY KEY IDENTITY(1,1),
PolicyTitle NVARCHAR(100) NOT NULL,
PolicyContent NVARCHAR(MAX) NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE()
);
Explanation of Tables
Users: Stores user information, including their role.
Roles: Defines different roles (e.g., Admin, Employee) in the system.
LeaveTypes: Contains different types of leave (e.g., Sick Leave, Vacation).
LeaveRequests: Records leave requests made by users.
LeaveBalances: Tracks the leave balance for each user per leave type.
Notifications: Stores notifications for users regarding their leave requests and other updates.
Reports: Allows users to generate reports related to their leave history and usage.
CalendarEvents: Manages events related to leave and other important dates for users.
Feedback: Collects user feedback on the leave management system.
CompanyPolicies: Contains policies related to leave and other HR guidelines.
Creating Model and Repository Pattern
To create a model and repository pattern using ADO.NET for the provided SQL Server tables in an ASP.NET application, we will follow these steps:
Step 1: Create Models
Here are the C# model classes for each of the tables:
public class User
{
public int UserId { get; set; }
public string Username { get; set; }
public string PasswordHash { get; set; }
public string Email { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
public int RoleId { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Role
{
public int RoleId { get; set; }
public string RoleName { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class LeaveType
{
public int LeaveTypeId { get; set; }
public string LeaveTypeName { get; set; }
public string Description { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class LeaveRequest
{
public int LeaveRequestId { get; set; }
public int UserId { get; set; }
public int LeaveTypeId { get; set; }
public DateTime StartDate { get; set; }
public DateTime EndDate { get; set; }
public string Status { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class LeaveBalance
{
public int LeaveBalanceId { get; set; }
public int UserId { get; set; }
public int LeaveTypeId { get; set; }
public int TotalLeaves { get; set; }
public int UsedLeaves { get; set; }
public int RemainingLeaves { 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; }
public DateTime UpdatedAt { get; set; }
}
public class Report
{
public int ReportId { get; set; }
public int UserId { get; set; }
public DateTime ReportDate { get; set; }
public string ReportContent { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class CalendarEvent
{
public int CalendarEventId { get; set; }
public int UserId { get; set; }
public string EventTitle { get; set; }
public DateTime EventDate { 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 string FeedbackContent { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class CompanyPolicy
{
public int PolicyId { get; set; }
public string PolicyTitle { get; set; }
public string PolicyContent { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
Step 2: Create Repositories
Next, we will create a generic repository interface and a concrete implementation for the User entity. You can create similar repositories for other entities.
IRepository Interface
public interface IRepository<T>
{
IEnumerable<T> GetAll();
T GetById(int id);
void Add(T entity);
void Update(T entity);
void Delete(int id);
}
UserRepository Implementation
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
public class UserRepository : IRepository<User>
{
private readonly string _connectionString;
public UserRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<User> GetAll()
{
var users = new List<User>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Users", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
users.Add(new User
{
UserId = (int)reader["User Id"],
Username = reader["Username"].ToString(),
PasswordHash = reader["PasswordHash"].ToString(),
Email = reader["Email"].ToString(),
FirstName = reader["FirstName"].ToString(),
LastName = reader["LastName"].ToString(),
RoleId = (int)reader["RoleId"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt });
}
}
}
return users;
}
public User GetById(int id)
{
User user = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Users WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
user = new User
{
UserId = (int)reader["User Id"],
Username = reader["Username"].ToString(),
PasswordHash = reader["PasswordHash"].ToString(),
Email = reader["Email"].ToString(),
FirstName = reader["FirstName"].ToString(),
LastName = reader["LastName"].ToString(),
RoleId = (int)reader["RoleId"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return user;
}
public void Add(User user)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Users (Username, PasswordHash, Email, FirstName, LastName, RoleId) VALUES (@Username, @PasswordHash, @Email, @FirstName, @LastName, @RoleId)", connection);
command.Parameters.AddWithValue("@Username", user.Username);
command.Parameters.AddWithValue("@PasswordHash", user.PasswordHash);
command.Parameters.AddWithValue("@Email", user.Email);
command.Parameters.AddWithValue("@FirstName", user.FirstName);
command.Parameters.AddWithValue("@LastName", user.LastName);
command.Parameters.AddWithValue("@RoleId", user.RoleId);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(User user)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Users SET Username = @Username, PasswordHash = @PasswordHash, Email = @Email, FirstName = @FirstName, LastName = @LastName, RoleId = @RoleId, UpdatedAt = GETDATE() WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", user.UserId);
command.Parameters.AddWithValue("@Username", user.Username);
command.Parameters.AddWithValue("@PasswordHash", user.PasswordHash);
command.Parameters.AddWithValue("@Email", user.Email);
command.Parameters.AddWithValue("@FirstName", user.FirstName);
command.Parameters.AddWithValue("@LastName", user.LastName);
command.Parameters.AddWithValue("@RoleId", user.RoleId);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Users WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
// You can create similar repository classes for other entities like Role, LeaveType, LeaveRequest, etc.
public class RoleRepository : IRepository<Role>
{
private readonly string _connectionString;
public RoleRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Role> GetAll()
{
var roles = new List<Role>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Roles", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
roles.Add(new Role
{
RoleId = (int)reader["RoleId"],
RoleName = reader["RoleName"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return roles;
}
public Role GetById(int id)
{
Role role = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Roles WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
role = new Role
{
RoleId = (int)reader["RoleId"],
RoleName = reader["RoleName"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return role;
}
public void Add(Role role)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Roles (RoleName) VALUES (@RoleName)", connection);
command.Parameters.AddWithValue("@RoleName", role.RoleName);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Role role)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Roles SET RoleName = @RoleName, UpdatedAt = GETDATE() WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", role.RoleId);
command.Parameters.AddWithValue("@RoleName", role.RoleName);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Roles WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
// Continue creating repositories for LeaveType, LeaveRequest, LeaveBalance, Notification, Report, CalendarEvent, Feedback, and CompanyPolicy similarly.
public class LeaveTypeRepository : IRepository<LeaveType>
{
private readonly string _connectionString;
public LeaveTypeRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<LeaveType> GetAll()
{
var leaveTypes = new List<LeaveType>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM LeaveTypes", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
leaveTypes.Add(new LeaveType
{
LeaveTypeId = (int)reader["LeaveTypeId"],
LeaveTypeName = reader["LeaveTypeName"].ToString(),
Description = reader["Description"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return leaveTypes;
}
public LeaveType GetById(int id)
{
LeaveType leaveType = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM LeaveTypes WHERE LeaveTypeId = @LeaveTypeId", connection);
command.Parameters.AddWithValue("@LeaveTypeId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
leaveType = new LeaveType
{
LeaveTypeId = (int)reader["LeaveTypeId"],
LeaveTypeName = reader["LeaveTypeName"].ToString(),
Description = reader["Description"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return leaveType;
}
public void Add(LeaveType leaveType)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO LeaveTypes (LeaveTypeName, Description) VALUES (@LeaveTypeName, @Description)", connection);
command.Parameters.AddWithValue("@LeaveTypeName", leaveType.LeaveTypeName);
command.Parameters.AddWithValue("@Description", leaveType.Description);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(LeaveType leaveType)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE LeaveTypes SET LeaveTypeName = @LeaveTypeName, Description = @Description, UpdatedAt = GETDATE() WHERE LeaveTypeId = @LeaveTypeId", connection);
command.Parameters.AddWithValue("@LeaveTypeId", leaveType.LeaveTypeId);
command.Parameters.AddWithValue("@LeaveTypeName", leaveType.LeaveTypeName);
command.Parameters.AddWithValue("@Description", leaveType.Description);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM LeaveTypes WHERE LeaveTypeId = @LeaveTypeId", connection);
command.Parameters.AddWithValue("@LeaveTypeId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
public class LeaveRequestRepository : IRepository<LeaveRequest>
{
private readonly string _connectionString;
public LeaveRequestRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<LeaveRequest> GetAll()
{
var leaveRequests = new List<LeaveRequest>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM LeaveRequests", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
leaveRequests.Add(new LeaveRequest
{
LeaveRequestId = (int)reader["LeaveRequestId"],
UserId = (int)reader["User Id"],
LeaveTypeId = (int)reader["LeaveTypeId"],
StartDate = (DateTime)reader["StartDate"],
EndDate = (DateTime)reader["EndDate"],
Status = reader["Status"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return leaveRequests;
}
public LeaveRequest GetById(int id)
{
LeaveRequest leaveRequest = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM LeaveRequests WHERE LeaveRequestId = @LeaveRequestId", connection);
command.Parameters.AddWithValue("@Leave RequestId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
leaveRequest = new LeaveRequest
{
LeaveRequestId = (int)reader["LeaveRequestId"],
UserId = (int)reader["User Id"],
LeaveTypeId = (int)reader["LeaveTypeId"],
StartDate = (DateTime)reader["StartDate"],
EndDate = (DateTime)reader["EndDate"],
Status = reader["Status"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return leaveRequest;
}
public void Add(LeaveRequest leaveRequest)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO LeaveRequests (User Id, LeaveTypeId, StartDate, EndDate, Status) VALUES (@User Id, @LeaveTypeId, @StartDate, @EndDate, @Status)", connection);
command.Parameters.AddWithValue("@User Id", leaveRequest.UserId);
command.Parameters.AddWithValue("@LeaveTypeId", leaveRequest.LeaveTypeId);
command.Parameters.AddWithValue("@StartDate", leaveRequest.StartDate);
command.Parameters.AddWithValue("@EndDate", leaveRequest.EndDate);
command.Parameters.AddWithValue("@Status", leaveRequest.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(LeaveRequest leaveRequest)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE LeaveRequests SET UserId = @User Id, LeaveTypeId = @LeaveTypeId, StartDate = @StartDate, EndDate = @EndDate, Status = @Status, UpdatedAt = GETDATE() WHERE LeaveRequestId = @LeaveRequestId", connection);
command.Parameters.AddWithValue("@LeaveRequestId", leaveRequest.LeaveRequestId);
command.Parameters.AddWithValue("@User Id", leaveRequest.UserId);
command.Parameters.AddWithValue("@LeaveTypeId", leaveRequest.LeaveTypeId);
command.Parameters.AddWithValue("@StartDate", leaveRequest.StartDate);
command.Parameters.AddWithValue("@EndDate", leaveRequest.EndDate);
command.Parameters.AddWithValue("@Status", leaveRequest.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM LeaveRequests WHERE LeaveRequestId = @LeaveRequestId", connection);
command.Parameters.AddWithValue("@LeaveRequestId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
// Continue creating repositories for LeaveBalance, Notification, Report, CalendarEvent, Feedback, and CompanyPolicy similarly.
public class LeaveBalanceRepository : IRepository<LeaveBalance>
{
private readonly string _connectionString;
public LeaveBalanceRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<LeaveBalance> GetAll()
{
var leaveBalances = new List<LeaveBalance>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM LeaveBalances", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
leaveBalances.Add(new LeaveBalance
{
LeaveBalanceId = (int)reader["LeaveBalanceId"],
UserId = (int)reader["User Id"],
LeaveTypeId = (int)reader["LeaveTypeId"],
TotalLeaves = (int)reader["TotalLeaves"],
UsedLeaves = (int)reader["UsedLeaves"],
RemainingLeaves = (int)reader["RemainingLeaves"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return leaveBalances;
}
public LeaveBalance GetById(int id)
{
LeaveBalance leaveBalance = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM LeaveBalances WHERE LeaveBalanceId = @LeaveBalanceId", connection);
command.Parameters.AddWithValue("@LeaveBalanceId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
leaveBalance = new LeaveBalance
{
LeaveBalanceId = (int)reader["LeaveBalanceId"],
UserId = (int)reader["User Id"],
LeaveTypeId = (int)reader["LeaveTypeId"],
TotalLeaves = (int)reader["TotalLeaves"],
UsedLeaves = (int)reader["UsedLeaves"],
RemainingLeaves = (int)reader["RemainingLeaves"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return leaveBalance;
}
public void Add(LeaveBalance leaveBalance)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO LeaveBalances (User Id, LeaveTypeId, TotalLeaves, UsedLeaves) VALUES (@User Id, @LeaveTypeId, @TotalLeaves, @UsedLeaves)", connection);
command.Parameters.AddWithValue("@User Id", leaveBalance.UserId);
command.Parameters.AddWithValue("@LeaveTypeId", leaveBalance.LeaveTypeId);
command.Parameters.AddWithValue("@TotalLeaves", leaveBalance.TotalLeaves);
command.Parameters.AddWithValue("@UsedLeaves", leaveBalance.UsedLeaves);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(LeaveBalance leaveBalance)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE LeaveBalances SET UserId = @User Id, LeaveTypeId = @LeaveTypeId, TotalLeaves = @TotalLeaves, UsedLeaves = @UsedLeaves, UpdatedAt = GETDATE() WHERE LeaveBalanceId = @LeaveBalanceId", connection);
command.Parameters.AddWithValue("@LeaveBalanceId", leaveBalance.LeaveBalanceId);
command.Parameters.AddWithValue("@User Id", leaveBalance.UserId);
command.Parameters.AddWithValue("@LeaveTypeId", leaveBalance.LeaveTypeId);
command.Parameters.AddWithValue("@TotalLeaves", leaveBalance.TotalLeaves);
command.Parameters.AddWithValue("@UsedLeaves", leaveBalance.UsedLeaves);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM LeaveBalances WHERE LeaveBalanceId = @LeaveBalanceId", connection);
command.Parameters.AddWithValue("@LeaveBalanceId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
public class NotificationRepository : IRepository<Notification>
{
private readonly string _connectionString;
public NotificationRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Notification> GetAll()
{
var notifications = new List<Notification>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Notifications", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
notifications.Add(new Notification
{
NotificationId = (int)reader["NotificationId"],
UserId = (int)reader ["User Id"],
Message = reader["Message"].ToString(),
IsRead = (bool)reader["IsRead"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return notifications;
}
public Notification GetById(int id)
{
Notification notification = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Notifications WHERE NotificationId = @NotificationId", connection);
command.Parameters.AddWithValue("@NotificationId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
notification = new Notification
{
NotificationId = (int)reader["NotificationId"],
UserId = (int)reader["User Id"],
Message = reader["Message"].ToString(),
IsRead = (bool)reader["IsRead"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return notification;
}
public void Add(Notification notification)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Notifications (User Id, Message, IsRead) VALUES (@User Id, @Message, @IsRead)", connection);
command.Parameters.AddWithValue("@User Id", notification.UserId);
command.Parameters.AddWithValue("@Message", notification.Message);
command.Parameters.AddWithValue("@IsRead", notification.IsRead);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Notification notification)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Notifications SET UserId = @User Id, Message = @Message, IsRead = @IsRead, UpdatedAt = GETDATE() WHERE NotificationId = @NotificationId", connection);
command.Parameters.AddWithValue("@NotificationId", notification.NotificationId);
command.Parameters.AddWithValue("@User Id", notification.UserId);
command.Parameters.AddWithValue("@Message", notification.Message);
command.Parameters.AddWithValue("@IsRead", notification.IsRead);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Notifications WHERE NotificationId = @NotificationId", connection);
command.Parameters.AddWithValue("@NotificationId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
public class ReportRepository : IRepository<Report>
{
private readonly string _connectionString;
public ReportRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Report> GetAll()
{
var reports = new List<Report>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Reports", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
reports.Add(new Report
{
ReportId = (int)reader["ReportId"],
UserId = (int)reader["User Id"],
ReportDate = (DateTime)reader["ReportDate"],
ReportContent = reader["ReportContent"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return reports;
}
public Report GetById(int id)
{
Report report = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Reports WHERE ReportId = @ReportId", connection);
command.Parameters.AddWithValue("@ReportId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
report = new Report
{
ReportId = (int)reader["ReportId"],
UserId = (int)reader["User Id"],
ReportDate = (DateTime)reader["ReportDate"],
ReportContent = reader["ReportContent"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return report;
}
public void Add(Report report)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Reports (User Id, ReportDate, ReportContent) VALUES (@User Id, @ReportDate, @ ReportContent)", connection);
command.Parameters.AddWithValue("@User Id", report.UserId);
command.Parameters.AddWithValue("@ReportDate", report.ReportDate);
command.Parameters.AddWithValue("@ReportContent", report.ReportContent);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Report report)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Reports SET UserId = @User Id, ReportDate = @ReportDate, ReportContent = @ReportContent, UpdatedAt = GETDATE() WHERE ReportId = @ReportId", connection);
command.Parameters.AddWithValue("@ReportId", report.ReportId);
command.Parameters.AddWithValue("@User Id", report.UserId);
command.Parameters.AddWithValue("@ReportDate", report.ReportDate);
command.Parameters.AddWithValue("@ReportContent", report.ReportContent);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Reports WHERE ReportId = @ReportId", connection);
command.Parameters.AddWithValue("@ReportId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
public class CalendarEventRepository : IRepository<CalendarEvent>
{
private readonly string _connectionString;
public CalendarEventRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<CalendarEvent> GetAll()
{
var calendarEvents = new List<CalendarEvent>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM CalendarEvents", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
calendarEvents.Add(new CalendarEvent
{
CalendarEventId = (int)reader["CalendarEventId"],
UserId = (int)reader["User Id"],
EventTitle = reader["EventTitle"].ToString(),
EventDate = (DateTime)reader["EventDate"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return calendarEvents;
}
public CalendarEvent GetById(int id)
{
CalendarEvent calendarEvent = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM CalendarEvents WHERE CalendarEventId = @CalendarEventId", connection);
command.Parameters.AddWithValue("@CalendarEventId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
calendarEvent = new CalendarEvent
{
CalendarEventId = (int)reader["CalendarEventId"],
UserId = (int)reader["User Id"],
EventTitle = reader["EventTitle"].ToString(),
EventDate = (DateTime)reader["EventDate"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return calendarEvent;
}
public void Add(CalendarEvent calendarEvent)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO CalendarEvents (User Id, EventTitle, EventDate) VALUES (@User Id, @EventTitle, @EventDate)", connection);
command.Parameters.AddWithValue("@User Id", calendarEvent.UserId);
command.Parameters.AddWithValue("@EventTitle", calendarEvent.EventTitle);
command.Parameters.AddWithValue("@EventDate", calendarEvent.EventDate);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(CalendarEvent calendarEvent)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE CalendarEvents SET UserId = @User Id, EventTitle = @EventTitle, EventDate = @EventDate, UpdatedAt = GETDATE() WHERE CalendarEventId = @CalendarEventId", connection);
command.Parameters.AddWithValue("@CalendarEventId", calendarEvent.CalendarEventId);
command.Parameters.AddWithValue("@User Id", calendarEvent.UserId);
command.Parameters.AddWithValue("@EventTitle", calendarEvent.EventTitle);
command.Parameters.AddWithValue("@EventDate", calendarEvent.EventDate);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM CalendarEvents WHERE CalendarEventId = @CalendarEventId", connection);
command.Parameters.AddWith Value("@CalendarEventId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
public class FeedbackRepository : IRepository<Feedback>
{
private readonly string _connectionString;
public FeedbackRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Feedback> GetAll()
{
var feedbacks = new List<Feedback>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Feedback", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
feedbacks.Add(new Feedback
{
FeedbackId = (int)reader["FeedbackId"],
UserId = (int)reader["User Id"],
FeedbackContent = reader["FeedbackContent"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return feedbacks;
}
public Feedback GetById(int id)
{
Feedback feedback = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Feedback WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@FeedbackId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
feedback = new Feedback
{
FeedbackId = (int)reader["FeedbackId"],
UserId = (int)reader["User Id"],
FeedbackContent = reader["FeedbackContent"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return feedback;
}
public void Add(Feedback feedback)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Feedback (User Id, FeedbackContent) VALUES (@User Id, @FeedbackContent)", connection);
command.Parameters.AddWithValue("@User Id", feedback.UserId);
command.Parameters.AddWithValue("@FeedbackContent", feedback.FeedbackContent);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Feedback feedback)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Feedback SET UserId = @User Id, FeedbackContent = @FeedbackContent, UpdatedAt = GETDATE() WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@FeedbackId", feedback.FeedbackId);
command.Parameters.AddWithValue("@User Id", feedback.UserId);
command.Parameters.AddWithValue("@FeedbackContent", feedback.FeedbackContent);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Feedback WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@FeedbackId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
public class CompanyPolicyRepository : IRepository<CompanyPolicy>
{
private readonly string _connectionString;
public CompanyPolicyRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<CompanyPolicy> GetAll()
{
var policies = new List<CompanyPolicy>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM CompanyPolicies", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
policies.Add(new CompanyPolicy
{
PolicyId = (int)reader["PolicyId"],
PolicyTitle = reader["PolicyTitle"].ToString(),
PolicyContent = reader["PolicyContent"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return policies;
}
public CompanyPolicy GetById(int id)
{
CompanyPolicy policy = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM CompanyPolicies WHERE PolicyId = @PolicyId", connection);
command.Parameters.AddWithValue("@PolicyId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
policy = new CompanyPolicy
{
PolicyId = (int)reader["PolicyId"],
PolicyTitle = reader["PolicyTitle"].ToString (),
PolicyContent = reader["PolicyContent"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return policy;
}
public void Add(CompanyPolicy policy)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO CompanyPolicies (PolicyTitle, PolicyContent) VALUES (@PolicyTitle, @PolicyContent)", connection);
command.Parameters.AddWithValue("@PolicyTitle", policy.PolicyTitle);
command.Parameters.AddWithValue("@PolicyContent", policy.PolicyContent);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(CompanyPolicy policy)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE CompanyPolicies SET PolicyTitle = @PolicyTitle, PolicyContent = @PolicyContent, UpdatedAt = GETDATE() WHERE PolicyId = @PolicyId", connection);
command.Parameters.AddWithValue("@PolicyId", policy.PolicyId);
command.Parameters.AddWithValue("@PolicyTitle", policy.PolicyTitle);
command.Parameters.AddWithValue("@PolicyContent", policy.PolicyContent);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM CompanyPolicies WHERE PolicyId = @PolicyId", connection);
command.Parameters.AddWithValue("@PolicyId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Creating Controllers
To create controllers for each repository in an ASP.NET MVC application, we will follow the standard MVC pattern. Each controller will handle HTTP requests, interact with the corresponding repository, and return views or data as needed.
Step 1: Create Controllers
Below are example controllers for each of the repositories we created earlier. Each controller will have basic CRUD operations.
UserController
using System.Web.Mvc;
public class UserController : Controller
{
private readonly UserRepository _userRepository;
public UserController()
{
// Replace with your actual connection string
string connectionString = "YourConnectionStringHere";
_userRepository = new UserRepository(connectionString);
}
public ActionResult Index()
{
var users = _userRepository.GetAll();
return View(users);
}
public ActionResult Details(int id)
{
var user = _userRepository.GetById(id);
return View(user);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(User user)
{
if (ModelState.IsValid)
{
_userRepository.Add(user);
return RedirectToAction("Index");
}
return View(user);
}
public ActionResult Edit(int id)
{
var user = _userRepository.GetById(id);
return View(user);
}
[HttpPost]
public ActionResult Edit(User user)
{
if (ModelState.IsValid)
{
_userRepository.Update(user);
return RedirectToAction("Index");
}
return View(user);
}
public ActionResult Delete(int id)
{
var user = _userRepository.GetById(id);
return View(user);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_userRepository.Delete(id);
return RedirectToAction("Index");
}
}
RoleController
using System.Web.Mvc;
public class RoleController : Controller
{
private readonly RoleRepository _roleRepository;
public RoleController()
{
string connectionString = "YourConnectionStringHere";
_roleRepository = new RoleRepository(connectionString);
}
public ActionResult Index()
{
var roles = _roleRepository.GetAll();
return View(roles);
}
public ActionResult Details(int id)
{
var role = _roleRepository.GetById(id);
return View(role);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Role role)
{
if (ModelState.IsValid)
{
_roleRepository.Add(role);
return RedirectToAction("Index");
}
return View(role);
}
public ActionResult Edit(int id)
{
var role = _roleRepository.GetById(id);
return View(role);
}
[HttpPost]
public ActionResult Edit(Role role)
{
if (ModelState.IsValid)
{
_roleRepository.Update(role);
return RedirectToAction("Index");
}
return View(role);
}
public ActionResult Delete(int id)
{
var role = _roleRepository.GetById(id);
return View(role);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_roleRepository.Delete(id);
return RedirectToAction("Index");
}
}
LeaveTypeController
using System.Web.Mvc;
public class LeaveTypeController : Controller
{
private readonly LeaveTypeRepository _leaveTypeRepository;
public LeaveTypeController()
{
string connectionString = "YourConnectionStringHere";
_leaveTypeRepository = new LeaveTypeRepository(connectionString);
}
public ActionResult Index()
{
var leaveTypes = _leaveTypeRepository.GetAll();
return View(leaveTypes);
}
public ActionResult Details(int id)
{
var leaveType = _leaveTypeRepository.GetById(id);
return View(leaveType);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(LeaveType leaveType)
{
if (ModelState.IsValid)
{
_leaveTypeRepository.Add(leaveType);
return RedirectToAction("Index");
}
return View(leaveType);
}
public ActionResult Edit(int id)
{
var leaveType = _leaveTypeRepository.GetById(id);
return View(leaveType);
}
[HttpPost]
public ActionResult Edit(LeaveType leaveType)
{
if (ModelState.IsValid)
{
_leaveTypeRepository.Update(leaveType);
return RedirectToAction("Index");
}
return View(leaveType);
}
public ActionResult Delete(int id)
{
var leaveType = _leaveTypeRepository.GetById(id);
return View(leaveType);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_leaveTypeRepository.Delete(id);
return RedirectToAction("Index");
}
}
LeaveRequestController
using System.Web.Mvc;
public class LeaveRequestController : Controller
{
private readonly LeaveRequestRepository _leaveRequestRepository;
public LeaveRequestController()
{
string connectionString = "YourConnectionStringHere";
_leaveRequestRepository = new LeaveRequestRepository(connectionString);
}
public ActionResult Index()
{
var leaveRequests = _leaveRequestRepository.GetAll();
return View(leaveRequests);
}
public ActionResult Details(int id)
{
var leaveRequest = _leaveRequestRepository.GetById(id);
return View(leaveRequest);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(LeaveRequest leaveRequest)
{
if (ModelState.IsValid)
{
_leaveRequestRepository.Add(leaveRequest);
return RedirectToAction("Index");
}
return View(leaveRequest);
}
public ActionResult Edit(int id)
{
var leaveRequest = _leaveRequestRepository.GetById(id);
return View(leaveRequest);
}
[HttpPost]
public ActionResult Edit(LeaveRequest leaveRequest)
{
if (ModelState.IsValid)
{
_leaveRequestRepository.Update(leaveRequest);
return RedirectToAction("Index");
}
return View(leaveRequest);
}
public ActionResult Delete(int id)
{
var leaveRequest = _leaveRequestRepository.GetById(id);
return View(leaveRequest);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_leaveRequestRepository.Delete(id);
return RedirectToAction("Index");
}
}
LeaveBalanceController
using System.Web.Mvc;
public class LeaveBalanceController : Controller
{
private readonly LeaveBalanceRepository _leaveBalanceRepository;
public LeaveBalanceController()
{
string connectionString = "YourConnectionStringHere";
_leaveBalanceRepository = new LeaveBalanceRepository(connectionString);
}
public ActionResult Index()
{
var leaveBalances = _leaveBalanceRepository.GetAll();
return View(leaveBalances);
}
public ActionResult Details(int id)
{
var leaveBalance = _leaveBalanceRepository.GetById(id);
return View(leaveBalance);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(LeaveBalance leaveBalance)
{
if (ModelState.IsValid)
{
_leaveBalanceRepository.Add(leaveBalance);
return RedirectToAction("Index");
}
return View(leaveBalance);
}
public ActionResult Edit(int id)
{
var leaveBalance = _leaveBalanceRepository.GetById(id);
return View(leaveBalance);
}
[HttpPost]
public ActionResult Edit(LeaveBalance leaveBalance)
{
if (ModelState.IsValid)
{
_leaveBalanceRepository.Update(leaveBalance);
return RedirectToAction("Index");
}
return View(leaveBalance);
}
public ActionResult Delete(int id)
{
var leaveBalance = _leaveBalanceRepository.GetById(id);
return View(leaveBalance);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_leaveBalanceRepository.Delete(id);
return RedirectToAction("Index");
}
}
NotificationController
using System.Web.Mvc;
public class NotificationController : Controller
{
private readonly NotificationRepository _notificationRepository;
public NotificationController()
{
string connectionString = "YourConnectionStringHere";
_notificationRepository = new NotificationRepository(connectionString);
}
public ActionResult Index()
{
var notifications = _notificationRepository.GetAll();
return View(notifications);
}
public ActionResult Details(int id)
{
var notification = _notificationRepository.GetById(id);
return View(notification);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Notification notification)
{
if (ModelState.IsValid)
{
_notificationRepository.Add(notification);
return RedirectToAction("Index");
}
return View(notification);
}
public ActionResult Edit(int id)
{
var notification = _notificationRepository.GetById(id);
return View(notification);
}
[HttpPost]
public ActionResult Edit(Notification notification)
{
if (ModelState.IsValid)
{
_notificationRepository.Update(notification);
return RedirectToAction("Index");
}
return View(notification);
}
public ActionResult Delete(int id)
{
var notification = _notificationRepository.GetById(id);
return View(notification);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_notificationRepository.Delete(id);
return RedirectToAction("Index");
}
}
ReportController
using System.Web.Mvc;
public class ReportController : Controller
{
private readonly ReportRepository _reportRepository;
public ReportController()
{
string connectionString = "YourConnectionStringHere";
_reportRepository = new ReportRepository(connectionString);
}
public ActionResult Index ()
{
var reports = _reportRepository.GetAll();
return View(reports);
}
public ActionResult Details(int id)
{
var report = _reportRepository.GetById(id);
return View(report);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Report report)
{
if (ModelState.IsValid)
{
_reportRepository.Add(report);
return RedirectToAction("Index");
}
return View(report);
}
public ActionResult Edit(int id)
{
var report = _reportRepository.GetById(id);
return View(report);
}
[HttpPost]
public ActionResult Edit(Report report)
{
if (ModelState.IsValid)
{
_reportRepository.Update(report);
return RedirectToAction("Index");
}
return View(report);
}
public ActionResult Delete(int id)
{
var report = _reportRepository.GetById(id);
return View(report);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_reportRepository.Delete(id);
return RedirectToAction("Index");
}
}
CalendarEventController
using System.Web.Mvc;
public class CalendarEventController : Controller
{
private readonly CalendarEventRepository _calendarEventRepository;
public CalendarEventController()
{
string connectionString = "YourConnectionStringHere";
_calendarEventRepository = new CalendarEventRepository(connectionString);
}
public ActionResult Index()
{
var calendarEvents = _calendarEventRepository.GetAll();
return View(calendarEvents);
}
public ActionResult Details(int id)
{
var calendarEvent = _calendarEventRepository.GetById(id);
return View(calendarEvent);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(CalendarEvent calendarEvent)
{
if (ModelState.IsValid)
{
_calendarEventRepository.Add(calendarEvent);
return RedirectToAction("Index");
}
return View(calendarEvent);
}
public ActionResult Edit(int id)
{
var calendarEvent = _calendarEventRepository.GetById(id);
return View(calendarEvent);
}
[HttpPost]
public ActionResult Edit(CalendarEvent calendarEvent)
{
if (ModelState.IsValid)
{
_calendarEventRepository.Update(calendarEvent);
return RedirectToAction("Index");
}
return View(calendarEvent);
}
public ActionResult Delete(int id)
{
var calendarEvent = _calendarEventRepository.GetById(id);
return View(calendarEvent);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_calendarEventRepository.Delete(id);
return RedirectToAction("Index");
}
}
FeedbackController
using System.Web.Mvc;
public class FeedbackController : Controller
{
private readonly FeedbackRepository _feedbackRepository;
public FeedbackController()
{
string connectionString = "YourConnectionStringHere";
_feedbackRepository = new FeedbackRepository(connectionString);
}
public ActionResult Index()
{
var feedbacks = _feedbackRepository.GetAll();
return View(feedbacks);
}
public ActionResult Details(int id)
{
var feedback = _feedbackRepository.GetById(id);
return View(feedback);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Feedback feedback)
{
if (ModelState.IsValid)
{
_feedbackRepository.Add(feedback);
return RedirectToAction("Index");
}
return View(feedback);
}
public ActionResult Edit(int id)
{
var feedback = _feedbackRepository.GetById(id);
return View(feedback);
}
[HttpPost]
public ActionResult Edit(Feedback feedback)
{
if (ModelState.IsValid)
{
_feedbackRepository.Update(feedback);
return RedirectToAction("Index");
}
return View(feedback);
}
public ActionResult Delete(int id)
{
var feedback = _feedbackRepository.GetById(id);
return View(feedback);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_feedbackRepository.Delete(id);
return RedirectToAction("Index");
}
}
CompanyPolicyController
using System.Web.Mvc;
public class CompanyPolicyController : Controller
{
private readonly CompanyPolicyRepository _companyPolicyRepository;
public CompanyPolicyController()
{
string connectionString = "YourConnectionStringHere";
_companyPolicyRepository = new CompanyPolicyRepository(connectionString);
public ActionResult Index()
{
var policies = _companyPolicyRepository.GetAll();
return View(policies);
}
public ActionResult Details(int id)
{
var policy = _companyPolicyRepository.GetById(id);
return View(policy);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(CompanyPolicy policy)
{
if (ModelState.IsValid)
{
_companyPolicyRepository.Add(policy);
return RedirectToAction("Index");
}
return View(policy);
}
public ActionResult Edit(int id)
{
var policy = _companyPolicyRepository.GetById(id);
return View(policy);
}
[HttpPost]
public ActionResult Edit(CompanyPolicy policy)
{
if (ModelState.IsValid)
{
_companyPolicyRepository.Update(policy);
return RedirectToAction("Index");
}
return View(policy);
}
public ActionResult Delete(int id)
{
var policy = _companyPolicyRepository.GetById(id);
return View(policy);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_companyPolicyRepository.Delete(id);
return RedirectToAction("Index");
}
}
Creating Views
This completes the creation of controllers for each repository in your ASP.NET MVC application. Each controller follows the standard CRUD operations, allowing you to manage the respective entities through views. You can now create corresponding views for each action in the controllers to provide a user interface for interacting with the data.
Creating Views for Each Controller
Creating views for each controller in an ASP.NET MVC application involves creating Razor view files that correspond to the actions in the controllers. Below, I will provide a basic structure for the views for each controller, including the Index, Details, Create, Edit, and Delete views.
Folder Structure
Assuming you have a standard MVC project structure, the views for each controller will be placed in their respective folders under the Views directory. For example, views for the User Controller will be in Views/User.
User Views
1. Index.cshtml
@model IEnumerable<YourNamespace.Models.User>
@{
ViewBag.Title = "Users";
}
<h2>Users</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.Username)
</th>
<th>
@Html.DisplayNameFor(model => model.Email)
</th>
<th>
@Html.DisplayNameFor(model => model.FirstName)
</th>
<th>
@Html.DisplayNameFor(model => model.LastName)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => item.Username)</td>
<td>@Html.DisplayFor(modelItem => item.Email)</td>
<td>@Html.DisplayFor(modelItem => item.FirstName)</td>
<td>@Html.DisplayFor(modelItem => item.LastName)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = item.UserId }) |
@Html.ActionLink("Details", "Details", new { id = item.UserId }) |
@Html.ActionLink("Delete", "Delete", new { id = item.UserId })
</td>
</tr>
}
</tbody>
</table>
2. Create.cshtml
@model YourNamespace.Models.User
@{
ViewBag.Title = "Create User";
}
<h2>Create User</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>User</h4>
<hr />
@Html.ValidationSummary(true, "", new { @class = "text-danger" })
<div class="form-group">
@Html.LabelFor(model => model.Username, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Username, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Username, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.PasswordHash, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.PasswordHash, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.PasswordHash, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Email, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Email, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Email, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.FirstName, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.FirstName, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.FirstName, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.LastName, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.LastName, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.LastName, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
3. Edit.cshtml
@model YourNamespace.Models.User
@{
ViewBag.Title = "Edit User";
}
<h2>Edit User</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>User</h4>
<hr />
@Html.ValidationSummary(true, "", new { @class = "text-danger" })
@Html.HiddenFor(model => model.User Id)
<div class="form-group">
@Html.LabelFor(model => model.Username, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Username, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Username, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Email, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Email, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Email, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.FirstName, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.FirstName, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.FirstName, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.LastName, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.LastName, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.LastName, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
4. Details.cshtml
@model YourNamespace.Models.User
@{
ViewBag.Title = "User Details";
}
<h2>User Details</h2>
<div>
<h4>User</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Username)
</dt>
<dd>
@Html.DisplayFor(model => model.Username)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Email)
</dt>
<dd>
@Html.DisplayFor(model => model.Email)
</dd>
<dt>
@Html.DisplayNameFor(model => model.FirstName)
</dt>
<dd>
@Html.DisplayFor(model => model.FirstName)
</dd>
<dt>
@Html.DisplayNameFor(model => model.LastName)
</dt>
<dd>
@Html.DisplayFor(model => model.LastName)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.UserId }) |
@Html.ActionLink("Back to List", "Index")
</div>
5. Delete.cshtml
@model YourNamespace.Models.User
@{
ViewBag.Title = "Delete User";
}
<h2>Delete User</h2>
<div>
<h4>User</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Username)
</dt>
<dd>
@Html.DisplayFor(model => model.Username)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Email)
</dt>
<dd>
@Html.DisplayFor(model => model.Email)
</dd>
<dt>
@Html.DisplayNameFor(model => model.FirstName)
</dt>
<dd>
@Html.DisplayFor(model => model.FirstName)
</dd>
<dt>
@Html.DisplayNameFor(model => model.LastName)
</dt>
<dd>
@Html.DisplayFor(model => model.LastName)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
<input type="hidden" name="id" value="@Model.UserId" />
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Cancel", "Index")
</div>
}
Role Views
1. Index.cshtml
@model IEnumerable<YourNamespace.Models.Role>
@{
ViewBag.Title = "Roles";
}
<h2>Roles</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.Name)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => item.Name)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = item.RoleId }) |
@Html.ActionLink("Details", "Details", new { id = item.RoleId }) |
@Html.ActionLink("Delete", "Delete", new { id = item.RoleId })
</td>
</tr>
}
</tbody>
</table>
2. Create.cshtml
@model YourNamespace.Models.Role
@{
ViewBag.Title = "Create Role";
}
<h2>Create Role</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Role</h4>
<hr />
@Html.ValidationSummary(true, "", new { @class = "text-danger" })
<div class="form-group">
@Html.LabelFor(model => model.Name, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Name, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Name, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
3. Edit.cshtml
@model YourNamespace.Models.Role
@{
ViewBag.Title = "Edit Role";
}
<h2>Edit Role</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Role</h4>
<hr />
@Html.ValidationSummary(true, "", new { @class = "text-danger" })
@Html.HiddenFor(model => model.RoleId)
<div class="form-group">
@Html.LabelFor(model => model.Name, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Name, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Name, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
4. Details.cshtml
@model YourNamespace.Models.Role
@{
ViewBag.Title = "Role Details";
}
<h2>Role Details</h2>
<div>
<h4>Role</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Name)
</dt>
<dd>
@Html.DisplayFor(model => model.Name)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.RoleId }) |
@Html.ActionLink("Back to List", "Index")
</div>
5. Delete.cshtml
@model YourNamespace.Models.Role
@{
ViewBag.Title = "Delete Role";
}
<h2>Delete Role</h2>
<div>
<h4>Role</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Name)
</dt>
<dd>
@Html.DisplayFor(model => model.Name)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
<input type="hidden" name="id" value="@Model.Role Id" />
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Cancel", "Index")
</div>
}
LeaveType Views
1. Index.cshtml
@model IEnumerable<YourNamespace.Models.LeaveType>
@{
ViewBag.Title = "Leave Types";
}
<h2>Leave Types</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.Name)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => item.Name)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = item.LeaveTypeId }) |
@Html.ActionLink("Details", "Details", new { id = item.LeaveTypeId }) |
@Html.ActionLink("Delete", "Delete", new { id = item.LeaveTypeId })
</td>
</tr>
}
</tbody>
</table>
2. Create.cshtml
@model YourNamespace.Models.LeaveType
@{
ViewBag.Title = "Create Leave Type";
}
<h2>Create Leave Type</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Leave Type</h4>
<hr />
@Html.ValidationSummary(true, "", new { @class = "text-danger" })
<div class="form-group">
@Html.LabelFor(model => model.Name, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Name, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Name, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
3. Edit.cshtml
@model YourNamespace.Models.LeaveType
@{
ViewBag.Title = "Edit Leave Type";
}
<h2>Edit Leave Type</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Leave Type</h4>
<hr />
@Html.ValidationSummary(true, "", new { @class = "text-danger" })
@Html.HiddenFor(model => model.LeaveTypeId)
<div class="form-group">
@Html.LabelFor(model => model.Name, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Name, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Name, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
4. Details.cshtml
@model YourNamespace.Models.LeaveType
@{
ViewBag.Title = "Leave Type Details";
}
<h2>Leave Type Details</h2>
<div>
<h4>Leave Type</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Name)
</dt>
<dd>
@Html.DisplayFor(model => model.Name)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.LeaveTypeId }) |
@Html.ActionLink("Back to List", "Index")
</div>
5. Delete.cshtml
@model YourNamespace.Models.LeaveType
@{
ViewBag.Title = "Delete Leave Type";
}
<h2>Delete Leave Type</h2>
<div>
<h4>Leave Type</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Name)
</dt>
<dd>
@Html.DisplayFor(model => model.Name)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
<input type="hidden" name="id" value="@Model.LeaveTypeId" />
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Cancel", "Index")
</div>
}
LeaveRequest Views
1. Index.cshtml
@model IEnumerable<YourNamespace.Models.LeaveRequest>
@{
ViewBag.Title = "Leave Requests";
}
<h2>Leave Requests</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.RequestDate)
</th>
<th>
@Html.DisplayNameFor(model => model.Status)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => item.RequestDate)</td>
<td>@Html.DisplayFor(modelItem => item.Status)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = item.LeaveRequestId }) |
@Html.ActionLink("Details", "Details", new { id = item.LeaveRequestId }) |
@Html.ActionLink("Delete", "Delete", new { id = item.LeaveRequestId })
</td>
</tr>
}
</tbody>
</table>
2. Create.cshtml
@model YourNamespace.Models.LeaveRequest
@{
ViewBag.Title = "Create Leave Request";
}
<h2>Create Leave Request</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Leave Request</h4>
<hr />
@Html.ValidationSummary(true, "", new { @class = "text-danger" })
<div class="form-group">
@Html.LabelFor(model => model.RequestDate, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.RequestDate, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.RequestDate, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Status, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Status, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Status, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
3. Edit.cshtml
@model YourNamespace.Models.LeaveRequest
@{
ViewBag.Title = "Edit Leave Request";
}
<h2>Edit Leave Request</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Leave Request</h4>
<hr />
@Html.ValidationSummary(true, "", new { @class = "text-danger" })
@Html.HiddenFor(model => model.LeaveRequestId)
<div class="form-group">
@Html.LabelFor(model => model.RequestDate, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.RequestDate, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.RequestDate, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Status, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Status, new { htmlAttributes = new { @ class = "form-control" } })
@Html.ValidationMessageFor(model => model.Status, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
4. Details.cshtml
@model YourNamespace.Models.LeaveRequest
@{
ViewBag.Title = "Leave Request Details";
}
<h2>Leave Request Details</h2>
<div>
<h4>Leave Request</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.RequestDate)
</dt>
<dd>
@Html.DisplayFor(model => model.RequestDate)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Status)
</dt>
<dd>
@Html.DisplayFor(model => model.Status)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.LeaveRequestId }) |
@Html.ActionLink("Back to List", "Index")
</div>
5. Delete.cshtml
@model YourNamespace.Models.LeaveRequest
@{
ViewBag.Title = "Delete Leave Request";
}
<h2>Delete Leave Request</h2>
<div>
<h4>Leave Request</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.RequestDate)
</dt>
<dd>
@Html.DisplayFor(model => model.RequestDate)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Status)
</dt>
<dd>
@Html.DisplayFor(model => model.Status)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
<input type="hidden" name="id" value="@Model.LeaveRequestId" />
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Cancel", "Index")
</div>
}
LeaveBalance Views
1. Index.cshtml
@model IEnumerable<YourNamespace.Models.LeaveBalance>
@{
ViewBag.Title = "Leave Balances";
}
<h2>Leave Balances</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.UserId)
</th>
<th>
@Html.DisplayNameFor(model => model.LeaveTypeId)
</th>
<th>
@Html.DisplayNameFor(model => model.Balance)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => item.UserId)</td>
<td>@Html.DisplayFor(modelItem => item.LeaveTypeId)</td>
<td>@Html.DisplayFor(modelItem => item.Balance)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = item.LeaveBalanceId }) |
@Html.ActionLink("Details", "Details", new { id = item.LeaveBalanceId }) |
@Html.ActionLink("Delete", "Delete", new { id = item.LeaveBalanceId })
</td>
</tr>
}
</tbody>
</table>
2. Create.cshtml
@model YourNamespace.Models.LeaveBalance
@{
ViewBag.Title = "Create Leave Balance";
}
<h2>Create Leave Balance</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Leave Balance</h4>
<hr />
@Html.ValidationSummary(true, "", new { @class = "text-danger" })
<div class="form-group">
@Html.LabelFor(model => model.UserId, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.UserId, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.UserId, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.LeaveTypeId, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.LeaveTypeId, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.LeaveTypeId, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Balance, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Balance, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Balance, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
3. Edit.cshtml
@model YourNamespace.Models.LeaveBalance
@{
ViewBag.Title = "Edit Leave Balance";
}
<h2>Edit Leave Balance</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Leave Balance</h4>
<hr />
@Html.ValidationSummary(true, "", new { @class = "text-danger" })
@Html.HiddenFor(model => model.LeaveBalanceId)
<div class="form-group">
@Html.LabelFor(model => model.UserId, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.UserId, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.UserId, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.LeaveTypeId, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.LeaveTypeId, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.LeaveTypeId, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Balance, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Balance, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Balance, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
4. Details.cshtml
@model YourNamespace.Models.LeaveBalance
@{
ViewBag.Title = "Leave Balance Details";
}
<h2>Leave Balance Details</h2>
<div>
<h4>Leave Balance</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.UserId)
</dt>
<dd>
@Html.DisplayFor(model => model.UserId)
</dd>
<dt>
@Html.DisplayNameFor(model => model.LeaveTypeId)
</dt>
<dd>
@Html.DisplayFor(model => model.LeaveTypeId)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Balance)
</dt>
<dd>
@Html.DisplayFor(model => model.Balance)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.LeaveBalanceId }) |
@Html.ActionLink("Back to List", "Index")
</div>
5. Delete.cshtml
@model YourNamespace.Models.LeaveBalance
@{
ViewBag.Title = "Delete Leave Balance";
}
<h2>Delete Leave Balance</h2>
<div>
<h4>Leave Balance</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.UserId)
</dt>
<dd>
@Html.DisplayFor(model => model.UserId)
</dd>
<dt>
@Html.DisplayNameFor(model => model.LeaveTypeId)
</dt>
<dd>
@Html.DisplayFor(model => model.LeaveTypeId)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Balance)
</dt>
<dd>
@Html.DisplayFor(model => model.Balance)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
<input type="hidden" name="id" value="@Model.LeaveBalanceId" />
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Cancel", "Index")
</div>
}
Notification Views
1. Index.cshtml
@model IEnumerable<YourNamespace.Models.Notification>
@{
ViewBag.Title = "Notifications";
}
<h2>Notifications</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.Title)
</th>
<th>
@Html.DisplayNameFor(model => model.Message)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => item.Title)</td>
<td>@Html.DisplayFor(modelItem => item.Message)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = item.NotificationId }) |
@Html.ActionLink("Details", "Details", new { id = item.NotificationId }) |
@Html.ActionLink("Delete", "Delete", new { id = item.NotificationId })
</td>
</tr>
}
</tbody>
</table>
2. Create.cshtml
@model YourNamespace.Models.Notification
@{
ViewBag.Title = "Create Notification";
}
<h2>Create Notification</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Notification</h4>
<hr />
@Html.ValidationSummary(true, "", new { @class = "text-danger" })
<div class="form-group">
@Html.LabelFor(model => model.Title, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Title, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Title, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Message, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Message, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Message, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
3. Edit.cshtml
@model YourNamespace.Models.Notification
@{
ViewBag.Title = "Edit Notification";
}
<h2>Edit Notification</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Notification</h4>
<hr />
@Html.ValidationSummary(true, "", new { @class = "text-danger" })
@Html.HiddenFor(model => model.NotificationId)
<div class="form-group">
@Html.LabelFor(model => model.Title, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Title, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Title, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Message, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Message, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Message, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
4. Details.cshtml
@model YourNamespace.Models.Notification
@{
ViewBag.Title = "Notification Details";
}
<h2>Notification Details</h2>
<div>
<h4>Notification</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Title)
</dt>
<dd>
@Html.DisplayFor(model => model.Title)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Message)
</dt>
<dd>
@Html.DisplayFor(model => model.Message)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.NotificationId }) |
@Html.ActionLink("Back to List", "Index")
</div>
5. Delete.cshtml
@model YourNamespace.Models.Notification
@{
ViewBag.Title = "Delete Notification";
}
<h2>Delete Notification</h2>
<div>
<h4>Notification</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Title)
</dt>
<dd>
@Html.DisplayFor(model => model.Title)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Message)
</dt>
<dd>
@Html.DisplayFor(model => model.Message)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
<input type="hidden" name="id" value="@Model.NotificationId" />
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Cancel", "Index")
</div>
}
Report Views
1. Index.cshtml
@model IEnumerable<YourNamespace.Models.Report>
@{
ViewBag.Title = "Reports";
}
<h2>Reports</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.Title)
</th>
<th>
@Html.DisplayNameFor(model => model.Content)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => item.Title)</td>
<td>@Html.DisplayFor(modelItem => item.Content)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = item.ReportId }) |
@Html.ActionLink("Details", "Details", new { id = item.ReportId }) |
@Html.ActionLink("Delete", "Delete", new { id = item.ReportId })
</td>
</tr>
}
</tbody>
</table>
2. Create.cshtml
@model YourNamespace.Models.Report
@{
ViewBag.Title = "Create Report";
}
<h2>Create Report</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Report</h4>
<hr />
@Html.ValidationSummary(true, "", new { @class = "text-danger" })
<div class="form-group">
@Html.LabelFor(model => model.Title, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Title, new { htmlAttributes = new { @class = "form -control" } })
@Html.ValidationMessageFor(model => model.Title, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Content, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Content, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Content, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
3. Edit.cshtml
@model YourNamespace.Models.Report
@{
ViewBag.Title = "Edit Report";
}
<h2>Edit Report</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Report</h4>
<hr />
@Html.ValidationSummary(true, "", new { @class = "text-danger" })
@Html.HiddenFor(model => model.ReportId)
<div class="form-group">
@Html.LabelFor(model => model.Title, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Title, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Title, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Content, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Content, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Content, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
4. Details.cshtml
@model YourNamespace.Models.Report
@{
ViewBag.Title = "Report Details";
}
<h2>Report Details</h2>
<div>
<h4>Report</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Title)
</dt>
<dd>
@Html.DisplayFor(model => model.Title)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Content)
</dt>
<dd>
@Html.DisplayFor(model => model.Content)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.ReportId }) |
@Html.ActionLink("Back to List", "Index")
</div>
5. Delete.cshtml
@model YourNamespace.Models.Report
@{
ViewBag.Title = "Delete Report";
}
<h2>Delete Report</h2>
<div>
<h4>Report</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Title)
</dt>
<dd>
@Html.DisplayFor(model => model.Title)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Content)
</dt>
<dd>
@Html.DisplayFor(model => model.Content)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
<input type="hidden" name="id" value="@Model.ReportId" />
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Cancel", "Index")
</div>
}
CalendarEvent Views
1. Index.cshtml
@model IEnumerable<YourNamespace.Models.CalendarEvent>
@{
ViewBag.Title = "Calendar Events";
}
<h2>Calendar Events</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.Title)
</th>
<th>
@Html.DisplayNameFor(model => model.StartDate)
</th>
<th>
@Html.DisplayNameFor(model => model.EndDate)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => item.Title)</td>
<td>@Html.DisplayFor(modelItem => item.StartDate)</td>
<td>@Html.DisplayFor(modelItem => item.EndDate)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = item.CalendarEventId }) |
@Html.ActionLink("Details", "Details", new { id = item.CalendarEventId }) |
@Html.ActionLink("Delete", "Delete", new { id = item.CalendarEventId })
</td>
</tr>
}
</tbody>
</table>
2. Create.cshtml
@model YourNamespace.Models.CalendarEvent
@{
ViewBag.Title = "Create Calendar Event";
}
<h2>Create Calendar Event</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Calendar Event</h4>
<hr />
@Html.ValidationSummary(true, "", new { @class = "text-danger" })
<div class="form-group">
@Html.LabelFor(model => model.Title, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Title, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Title, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.StartDate, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.StartDate, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.StartDate, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.EndDate, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.EndDate, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.EndDate, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
3. Edit.cshtml
@model YourNamespace.Models.CalendarEvent
@{
ViewBag.Title = "Edit Calendar Event";
}
<h2>Edit Calendar Event</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Calendar Event</h4>
<hr />
@Html.ValidationSummary(true, "", new { @class = "text-danger" })
@Html.HiddenFor(model => model.CalendarEventId)
<div class="form-group">
@Html.LabelFor(model => model.Title, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Title, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Title, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.StartDate, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.StartDate, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.StartDate, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html .LabelFor(model => model.EndDate, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.EndDate, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.EndDate, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
4. Details.cshtml
@model YourNamespace.Models.CalendarEvent
@{
ViewBag.Title = "Calendar Event Details";
}
<h2>Calendar Event Details</h2>
<div>
<h4>Calendar Event</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Title)
</dt>
<dd>
@Html.DisplayFor(model => model.Title)
</dd>
<dt>
@Html.DisplayNameFor(model => model.StartDate)
</dt>
<dd>
@Html.DisplayFor(model => model.StartDate)
</dd>
<dt>
@Html.DisplayNameFor(model => model.EndDate)
</dt>
<dd>
@Html.DisplayFor(model => model.EndDate)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.CalendarEventId }) |
@Html.ActionLink("Back to List", "Index")
</div>
5. Delete.cshtml
@model YourNamespace.Models.CalendarEvent
@{
ViewBag.Title = "Delete Calendar Event";
}
<h2>Delete Calendar Event</h2>
<div>
<h4>Calendar Event</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Title)
</dt>
<dd>
@Html.DisplayFor(model => model.Title)
</dd>
<dt>
@Html.DisplayNameFor(model => model.StartDate)
</dt>
<dd>
@Html.DisplayFor(model => model.StartDate)
</dd>
<dt>
@Html.DisplayNameFor(model => model.EndDate)
</dt>
<dd>
@Html.DisplayFor(model => model.EndDate)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
<input type="hidden" name="id" value="@Model.CalendarEventId" />
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Cancel", "Index")
</div>
}
Feedback Views
1. Index.cshtml
@model IEnumerable<YourNamespace.Models.Feedback>
@{
ViewBag.Title = "Feedbacks";
}
<h2>Feedbacks</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.UserId)
</th>
<th>
@Html.DisplayNameFor(model => model.Comment)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => item.UserId)</td>
<td>@Html.DisplayFor(modelItem => item.Comment)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = item.FeedbackId }) |
@Html.ActionLink("Details", "Details", new { id = item.FeedbackId }) |
@Html.ActionLink("Delete", "Delete", new { id = item.FeedbackId })
</td>
</tr>
}
</tbody>
</table>
2. Create.cshtml
@model YourNamespace.Models.Feedback
@{
ViewBag.Title = "Create Feedback";
}
<h2>Create Feedback</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Feedback</h4>
<hr />
@Html.ValidationSummary(true, "", new { @class = "text-danger" })
<div class="form-group">
@Html.LabelFor(model => model.UserId, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.UserId, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.UserId, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Comment, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Comment, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Comment, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
3. Edit.cshtml
@model YourNamespace.Models.Feedback
@{
ViewBag.Title = "Edit Feedback";
}
<h2>Edit Feedback</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Feedback</h4>
<hr />
@Html.ValidationSummary(true, "", new { @class = "text-danger" })
@Html.HiddenFor(model => model.FeedbackId)
<div class="form-group">
@Html.LabelFor(model => model.UserId, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.UserId, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.UserId, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Comment, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Comment, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Comment, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
4. Details.cshtml
@model YourNamespace.Models.Feedback
@{
ViewBag.Title = "Feedback Details";
}
<h2>Feedback Details</h2>
<div>
<h4>Feedback</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.UserId)
</dt>
<dd>
@Html.DisplayFor(model => model.UserId)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Comment)
</dt>
<dd>
@Html.DisplayFor(model => model.Comment)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.FeedbackId }) |
@Html.ActionLink("Back to List", "Index")
</div>
5. Delete.cshtml
@model YourNamespace.Models.Feedback
@{
ViewBag.Title = "Delete Feedback";
}
<h2>Delete Feedback</h2>
<div>
<h4>Feedback</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.UserId)
</dt>
<dd>
@Html.DisplayFor(model => model.UserId)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Comment)
</dt>
<dd>
@Html.DisplayFor(model => model.Comment)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
<input type="hidden" name="id" value="@Model.FeedbackId" />
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Cancel", "Index")
</div>
}
CompanyPolicy Views
1. Index.cshtml
CompanyPolicy Views
#### 1. Index.cshtml
@model IEnumerable<YourNamespace.Models.CompanyPolicy>
@{
ViewBag.Title = "Company Policies";
}
<h2>Company Policies</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.Title)
</th>
<th>
@Html.DisplayNameFor(model => model.Content)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => item.Title)</td>
<td>@Html.DisplayFor(modelItem => item.Content)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = item.CompanyPolicyId }) |
@Html.ActionLink("Details", "Details", new { id = item.CompanyPolicyId }) |
@Html.ActionLink("Delete", "Delete", new { id = item.CompanyPolicyId })
</td>
</tr>
}
</tbody>
</table>
2. Create.cshtml
@model YourNamespace.Models.CompanyPolicy
@{
ViewBag.Title = "Create Company Policy";
}
<h2>Create Company Policy</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Company Policy</h4>
<hr />
@Html.ValidationSummary(true, "", new { @class = "text-danger" })
<div class="form-group">
@Html.LabelFor(model => model.Title, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Title, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Title, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Content, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Content, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Content, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
3. Edit.cshtml
@model YourNamespace.Models.CompanyPolicy
@{
ViewBag.Title = "Edit Company Policy";
}
<h2>Edit Company Policy</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Company Policy</h4>
<hr />
@Html.ValidationSummary(true, "", new { @class = "text-danger" })
@Html.HiddenFor(model => model.CompanyPolicyId)
<div class="form-group">
@Html.LabelFor(model => model.Title, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Title, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Title, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Content, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Content, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Content, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
4. Details.cshtml
@model YourNamespace.Models.CompanyPolicy
@{
ViewBag.Title = "Company Policy Details";
}
<h2>Company Policy Details</h2>
<div>
<h4>Company Policy</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Title)
</dt>
<dd>
@Html.DisplayFor(model => model.Title)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Content)
</dt>
<dd>
@Html.DisplayFor(model => model.Content)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.CompanyPolicyId }) |
@Html.ActionLink("Back to List", "Index")
</div>
5. Delete.cshtml
@model YourNamespace.Models.CompanyPolicy
@{
ViewBag.Title = "Delete Company Policy";
}
<h2>Delete Company Policy</h2>
<div>
<h4>Company Policy</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Title)
</dt>
<dd>
@Html.DisplayFor(model => model.Title)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Content)
</dt>
<dd>
@Html.DisplayFor(model => model.Content)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
<input type="hidden" name="id" value="@Model.CompanyPolicyId" />
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Cancel", "Index")
</div>
}
Creating a Dashboard
Creating a dashboard page in an ASP.NET MVC application involves aggregating data from various models and displaying it in a user-friendly format. Below, I will outline how to create a simple dashboard that consolidates data related to users, roles, leave requests, leave balances, notifications, reports, calendar events, feedback, and company policies.
Step 1: Create a Dashboard ViewModel
First, we need to create a ViewModel that will hold the consolidated data for the dashboard.
public class DashboardViewModel
{
public int TotalUsers { get; set; }
public int TotalRoles { get; set; }
public int TotalLeaveRequests { get; set; }
public int TotalLeaveBalances { get; set; }
public int TotalNotifications { get; set; }
public int TotalReports { get; set; }
public int TotalCalendarEvents { get; set; }
public int TotalFeedbacks { get; set; }
public int TotalCompanyPolicies { get; set; }
}
Step 2: Create a Dashboard Controller
Next, we will create a controller that will fetch the necessary data and pass it to the dashboard view.
using System.Web.Mvc;
public class DashboardController : Controller
{
private readonly UserRepository _userRepository;
private readonly RoleRepository _roleRepository;
private readonly LeaveRequestRepository _leaveRequestRepository;
private readonly LeaveBalanceRepository _leaveBalanceRepository;
private readonly NotificationRepository _notificationRepository;
private readonly ReportRepository _reportRepository;
private readonly CalendarEventRepository _calendarEventRepository;
private readonly FeedbackRepository _feedbackRepository;
private readonly CompanyPolicyRepository _companyPolicyRepository;
public DashboardController()
{
string connectionString = "YourConnectionStringHere";
_userRepository = new UserRepository(connectionString);
_roleRepository = new RoleRepository(connectionString);
_leaveRequestRepository = new LeaveRequestRepository(connectionString);
_leaveBalanceRepository = new LeaveBalanceRepository(connectionString);
_notificationRepository = new NotificationRepository(connectionString);
_reportRepository = new ReportRepository(connectionString);
_calendarEventRepository = new CalendarEventRepository(connectionString);
_feedbackRepository = new FeedbackRepository(connectionString);
_companyPolicyRepository = new CompanyPolicyRepository(connectionString);
}
public ActionResult Index()
{
var model = new DashboardViewModel
{
TotalUsers = _userRepository.GetAll().Count(),
TotalRoles = _roleRepository.GetAll().Count(),
TotalLeaveRequests = _leaveRequestRepository.GetAll().Count(),
TotalLeaveBalances = _leaveBalanceRepository.GetAll().Count(),
TotalNotifications = _notificationRepository.GetAll().Count(),
TotalReports = _reportRepository.GetAll().Count(),
TotalCalendarEvents = _calendarEventRepository.GetAll().Count(),
TotalFeedbacks = _feedbackRepository.GetAll().Count(),
TotalCompanyPolicies = _companyPolicyRepository.GetAll().Count()
};
return View(model);
}
}
Step 3: Create the Dashboard View
Now, we will create the view for the dashboard. This view will display the consolidated data in a user-friendly format.
Create a new view file: Index.cshtml in Views/Dashboard
@model YourNamespace.ViewModels.DashboardViewModel
@{
ViewBag.Title = "Dashboard";
}
<h2>Dashboard</h2>
<div class="row">
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Total Users</div>
<div class="panel-body">
<h3>@Model.TotalUsers</h3>
</div>
</div>
</div>
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Total Roles</div>
<div class="panel-body">
<h3>@Model.TotalRoles</h3>
</div>
</div>
</div>
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Total Leave Requests</div>
<div class="panel-body">
<h3>@Model.TotalLeaveRequests</h3>
</div>
</div>
</div>
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Total Leave Balances</div>
<div class="panel-body">
<h3>@Model.TotalLeaveBalances</h3>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Total Notifications</div>
<div class="panel-body">
<h3>@Model.TotalNotifications</h3>
</div>
</div>
</div>
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Total Reports</div>
<div class="panel-body">
<h3>@Model.TotalReports</h3>
</div>
</div>
</div>
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Total Calendar Events</div>
<div class="panel-body">
<h3>@Model.TotalCalendarEvents</h3>
</div>
</div>
</div>
<div class="col-md-3">
<div class="panel panel-default">
<div class=" panel-heading">Total Feedbacks</div>
<div class="panel-body">
<h3>@Model.TotalFeedbacks</h3>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Total Company Policies</div>
<div class="panel-body">
<h3>@Model.TotalCompanyPolicies</h3>
</div>
</div>
</div>
</div>
Step 4: Update the Route Configuration
Ensure that the dashboard route is configured in your RouteConfig.cs file so that it can be accessed easily.
routes.MapRoute(
name: "Dashboard",
url: "Dashboard",
defaults: new { controller = "Dashboard", action = "Index" }
);
Step 5: Access the Dashboard
You can now access the dashboard by navigating to /Dashboard in your web application. The dashboard will display the consolidated data related to users, roles, leave requests, leave balances, notifications, reports, calendar events, feedback, and company policies.
This setup provides a clear overview of the project's status and allows for easy monitoring of key metrics. You can further enhance the dashboard by adding charts, graphs, or other visual elements to represent the data more effectively.
AI 
ASP.NET API 
ASP.NET CLI 
ASP.NET Core 
ASP.NET MVC 
ASP.NET Projects With Source Code 
ASP.NET Web Forms 
ASP.NET Web Pages 
AWS 
Angular 10 
Bash 
Bitcoin 
Blockchain 
C Tutorial 
C# 
CPP 
Chat GPT 
Cheat Sheet 
Cyber Security 
Dart 
Django 
Docker 
Ether.js 
Ethereum 
Flask 
Flask Projects With Source Code 
GEN AI 
Git 
Go Language 
Google Cloud Platform 
GraphQL 
Hardhat 
INI 
JSON 
Java 
JavaScript 
Kotlin 
Kubernetes 
LaTeX 
Laravel 
Laravel 10 E-Commerce Project 
Laravel 11 E-Commerce Project 
Laravel 9 E-Commerce Project 
Laravel 9 React Tutorial 
Laravel E-Commerce Project 
Laravel Home Services Project 
Laravel Projects With Source Code 
Laravel Tutorial Advanced 
Laravel Tutorial Beginners 
Livewire 
Markdown 
Matlab 
Metamask 
Microsoft Azure 
MongoDB Tutorial Advanced 
MongoDB Tutorial Beginners 
MySql Tutorial Advanced 
MySql Tutorial Beginners 
NextJS 
Node JS 
Node JS Projects With Source Code 
PHP Projects With Source Code 
PHP Tutorial Advanced 
PHP Tutorial Beginners 
Project Database Schema 
Python 
React JS 
Ruby 
Rust 
SQL Server Queries 
SQL Server Tutorial Advanced 
SQL Server Tutorial Beginners 
Sass 
Solidity 
Spring Boot 
Truffle 
TypeScript 
VueJS 
Web3.js 
WordPress Tutorial Advanced 
WordPress Tutorial Beginners 
YAML