Project Introduction
The Office Management System is designed to streamline the administrative functions of an office by providing a comprehensive platform for managing users, assets, inventory, documents, meetings, tasks, attendance, and notifications. Built using ASP.NET and SQL Server, this application aims to enhance productivity and organization within the office environment. The system will allow users to efficiently manage their daily tasks, track attendance, handle documents, and facilitate communication among team members.
Project Objectives
- To create a secure user authentication system for managing user accounts and roles.
- To enable users to manage office assets and track their status.
- To maintain an inventory of items and their quantities within the office.
- To facilitate document management, including uploads and access control.
- To organize meetings and track their details, including participants and agendas.
- To manage tasks assigned to users and monitor their progress.
- To track employee attendance and generate reports on attendance records.
- To collect feedback from users to improve the system's functionality and user experience.
- To implement a notification system to keep users informed about important updates and tasks.
Project Modules
- User Management Module: Handles user registration, login, and role management.
- Asset Management Module: Manages office assets, including tracking and status updates.
- Inventory Management Module: Facilitates the management of inventory items and their quantities.
- Document Management Module: Manages the upload, storage, and retrieval of documents.
- Meeting Management Module: Organizes meetings, including scheduling and participant management.
- Task Management Module: Allows users to create, assign, and track tasks.
- Attendance Management Module: Tracks employee attendance and generates attendance reports.
- Report Generation Module: Generates reports on various office activities and metrics.
- Feedback Module: Collects user feedback to enhance the system.
- Notification Module: Sends notifications to users regarding important updates and tasks.
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 Assets Table
CREATE TABLE Assets (
AssetId INT PRIMARY KEY IDENTITY(1,1),
AssetName NVARCHAR(100) NOT NULL,
AssetType NVARCHAR(50) NOT NULL,
PurchaseDate DATETIME NOT NULL,
Status NVARCHAR(20) NOT NULL, -- e.g., Available, In Use, Maintenance
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE()
);
-- Create InventoryItems Table
CREATE TABLE InventoryItems (
InventoryItemId INT PRIMARY KEY IDENTITY(1,1),
ItemName NVARCHAR(100) NOT NULL,
Quantity INT NOT NULL,
Location NVARCHAR(100),
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE()
);
-- Create Documents Table
CREATE TABLE Documents (
DocumentId INT PRIMARY KEY IDENTITY(1,1),
DocumentName NVARCHAR(100) NOT NULL,
DocumentType NVARCHAR(50) NOT NULL,
UploadedBy INT NOT NULL,
UploadedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (UploadedBy) REFERENCES Users(UserId)
);
-- Create Meetings Table
CREATE TABLE Meetings (
MeetingId INT PRIMARY KEY IDENTITY(1,1),
MeetingTitle NVARCHAR(100) NOT NULL,
MeetingDate DATETIME NOT NULL,
CreatedBy INT NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (CreatedBy) REFERENCES Users(UserId)
);
-- Create Tasks Table
CREATE TABLE Tasks (
TaskId INT PRIMARY KEY IDENTITY(1,1),
TaskTitle NVARCHAR(100) NOT NULL,
AssignedTo INT NOT NULL,
DueDate DATETIME NOT NULL,
Status NVARCHAR(20) NOT NULL, -- e.g., Pending, Completed
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (AssignedTo) REFERENCES Users(UserId)
);
-- Create Attendance Table
CREATE TABLE Attendance (
AttendanceId INT PRIMARY KEY IDENTITY(1,1),
UserId INT NOT NULL,
AttendanceDate DATETIME NOT NULL,
Status NVARCHAR(20) NOT NULL, -- e.g., Present, Absent
CreatedAt 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(),
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(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- Create Notifications Table
CREATE TABLE Notifications (
NotificationId INT PRIMARY KEY IDENTITY(1,1),
UserId INT NOT NULL,
Message NVARCHAR(255) NOT NULL,
IsRead BIT NOT NULL DEFAULT 0,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
Explanation of Tables
Users: Stores user information, including their role.
Roles: Defines different roles (e.g., Admin, Employee) in the system.
Assets: Manages office assets, including their status and purchase date.
InventoryItems: Tracks inventory items available in the office.
Documents: Stores documents uploaded by users.
Meetings: Records meetings scheduled by users.
Tasks: Manages tasks assigned to users, including their status and due dates.
Attendance: Tracks user attendance, including presence status.
Reports: Allows users to generate reports related to their activities and tasks.
Feedback: Collects user feedback on the office management system.
Notifications: Stores notifications for users regarding tasks, meetings, and other updates.
Creating a Model and Repository Pattern
To create a model and repository pattern using ADO.NET for the provided SQL Server tables in an ASP.NET application, we will follow these steps:
Step 1: Create 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 Asset
{
public int AssetId { get; set; }
public string AssetName { get; set; }
public string AssetType { get; set; }
public DateTime PurchaseDate { get; set; }
public string Status { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class InventoryItem
{
public int InventoryItemId { get; set; }
public string ItemName { get; set; }
public int Quantity { get; set; }
public string Location { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Document
{
public int DocumentId { get; set; }
public string DocumentName { get; set; }
public string DocumentType { get; set; }
public int UploadedBy { get; set; }
public DateTime UploadedAt { get; set; }
}
public class Meeting
{
public int MeetingId { get; set; }
public string MeetingTitle { get; set; }
public DateTime MeetingDate { get; set; }
public int CreatedBy { get; set; }
public DateTime CreatedAt { get; set; }
}
public class Task
{
public int TaskId { get; set; }
public string TaskTitle { get; set; }
public int AssignedTo { get; set; }
public DateTime DueDate { get; set; }
public string Status { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Attendance
{
public int AttendanceId { get; set; }
public int UserId { get; set; }
public DateTime AttendanceDate { get; set; }
public string Status { get; set; }
public DateTime CreatedAt { 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 class Feedback
{
public int FeedbackId { get; set; }
public int UserId { get; set; }
public string FeedbackContent { get; set; }
public DateTime CreatedAt { get; set; }
}
public class Notification
{
public int NotificationId { get; set; }
public int UserId { get; set; }
public string Message { get; set; }
public bool IsRead { get; set; }
public DateTime CreatedAt { get; set; }
}
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();
}
}
}
This structure can be replicated for other entities like Role, Asset, InventoryItem, etc., by creating corresponding repository classes that implement the IRepository<T> interface. Each repository will handle CRUD operations specific to its entity, ensuring a clean separation of concerns and maintainability in your ASP.NET application.
Sure! Below are the repository implementations for the remaining models: Role, Asset, InventoryItem, Document, Meeting, Task, Attendance, Report, Feedback, and Notification. Each repository will implement the IRepository<T> interface, similar to the User Repository.
RoleRepository
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();
}
}
}
AssetRepository
public class AssetRepository : IRepository<Asset>
{
private readonly string _connectionString;
public AssetRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Asset> GetAll()
{
var assets = new List<Asset>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Assets", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
assets.Add(new Asset
{
AssetId = (int)reader["AssetId"],
AssetName = reader["AssetName"].ToString(),
AssetType = reader["AssetType"].ToString(),
PurchaseDate = (DateTime)reader["PurchaseDate"],
Status = reader["Status"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return assets;
}
public Asset GetById(int id)
{
Asset asset = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Assets WHERE AssetId = @AssetId", connection);
command.Parameters.AddWithValue("@AssetId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
asset = new Asset
{
AssetId = (int)reader["AssetId"],
AssetName = reader["AssetName"].ToString(),
AssetType = reader["AssetType"].ToString(),
PurchaseDate = (DateTime)reader["PurchaseDate"],
Status = reader["Status"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return asset;
}
public void Add(Asset asset)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Assets (AssetName, AssetType, PurchaseDate, Status) VALUES (@AssetName, @AssetType, @PurchaseDate, @Status)", connection);
command.Parameters.AddWithValue("@AssetName", asset.AssetName);
command.Parameters.AddWithValue("@AssetType", asset.AssetType);
command.Parameters.AddWith Value("@PurchaseDate", asset.PurchaseDate);
command.Parameters.AddWithValue("@Status", asset.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Asset asset)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Assets SET AssetName = @AssetName, AssetType = @AssetType, PurchaseDate = @PurchaseDate, Status = @Status, UpdatedAt = GETDATE() WHERE AssetId = @AssetId", connection);
command.Parameters.AddWithValue("@AssetId", asset.AssetId);
command.Parameters.AddWithValue("@AssetName", asset.AssetName);
command.Parameters.AddWithValue("@AssetType", asset.AssetType);
command.Parameters.AddWithValue("@PurchaseDate", asset.PurchaseDate);
command.Parameters.AddWithValue("@Status", asset.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Assets WHERE AssetId = @AssetId", connection);
command.Parameters.AddWithValue("@AssetId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
InventoryItemRepository
public class InventoryItemRepository : IRepository<InventoryItem>
{
private readonly string _connectionString;
public InventoryItemRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<InventoryItem> GetAll()
{
var items = new List<InventoryItem>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM InventoryItems", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
items.Add(new InventoryItem
{
InventoryItemId = (int)reader["InventoryItemId"],
ItemName = reader["ItemName"].ToString(),
Quantity = (int)reader["Quantity"],
Location = reader["Location"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return items;
}
public InventoryItem GetById(int id)
{
InventoryItem item = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM InventoryItems WHERE InventoryItemId = @InventoryItemId", connection);
command.Parameters.AddWithValue("@InventoryItemId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
item = new InventoryItem
{
InventoryItemId = (int)reader["InventoryItemId"],
ItemName = reader["ItemName"].ToString(),
Quantity = (int)reader["Quantity"],
Location = reader["Location"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return item;
}
public void Add(InventoryItem item)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO InventoryItems (ItemName, Quantity, Location) VALUES (@ItemName, @Quantity, @Location)", connection);
command.Parameters.AddWithValue("@ItemName", item.ItemName);
command.Parameters.AddWithValue("@Quantity", item.Quantity);
command.Parameters.AddWithValue("@Location", item.Location);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(InventoryItem item)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE InventoryItems SET ItemName = @ItemName, Quantity = @Quantity, Location = @Location, UpdatedAt = GETDATE() WHERE InventoryItemId = @InventoryItemId", connection);
command.Parameters.AddWithValue("@InventoryItemId", item.InventoryItemId);
command.Parameters.AddWithValue("@ItemName", item.ItemName);
command.Parameters.AddWithValue("@Quantity", item.Quantity);
command.Parameters.AddWithValue("@Location", item.Location);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM InventoryItems WHERE InventoryItemId = @InventoryItemId", connection);
command.Parameters.AddWithValue("@InventoryItemId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
DocumentRepository
public class DocumentRepository : IRepository<Document>
{
private readonly string _connectionString;
public DocumentRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Document> GetAll()
{
var documents = new List<Document>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Documents", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
documents.Add(new Document
{
DocumentId = (int)reader["DocumentId"],
DocumentName = reader["DocumentName"].ToString(),
DocumentType = reader["DocumentType"].ToString(),
UploadedBy = (int)reader["UploadedBy"],
UploadedAt = (DateTime)reader["UploadedAt"]
});
}
}
}
return documents;
}
public Document GetById(int id)
{
Document document = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Documents WHERE DocumentId = @DocumentId", connection);
command.Parameters.AddWithValue("@DocumentId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
document = new Document
{
DocumentId = (int)reader["DocumentId"],
DocumentName = reader["DocumentName"].ToString(),
DocumentType = reader["DocumentType"].ToString(),
UploadedBy = (int)reader["UploadedBy"],
UploadedAt = (DateTime)reader["UploadedAt"]
};
}
}
}
return document;
}
public void Add(Document document)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Documents (DocumentName, DocumentType, UploadedBy) VALUES (@DocumentName, @DocumentType, @UploadedBy)", connection);
command.Parameters.AddWithValue("@DocumentName", document.DocumentName);
command.Parameters.AddWithValue("@DocumentType", document.DocumentType);
command.Parameters.AddWithValue("@UploadedBy", document.UploadedBy);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Document document)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Documents SET DocumentName = @DocumentName, DocumentType = @DocumentType, UploadedBy = @UploadedBy WHERE DocumentId = @DocumentId", connection);
command.Parameters.AddWithValue("@DocumentId", document.DocumentId);
command.Parameters.AddWithValue("@DocumentName", document.DocumentName);
command.Parameters.AddWithValue("@DocumentType", document.DocumentType);
command.Parameters.AddWithValue("@UploadedBy", document.UploadedBy);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Documents WHERE DocumentId = @DocumentId", connection);
command.Parameters.AddWithValue("@DocumentId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
MeetingRepository
public class MeetingRepository : IRepository<Meeting>
{
private readonly string _connectionString;
public MeetingRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Meeting> GetAll()
{
var meetings = new List<Meeting>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Meetings", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
meetings.Add(new Meeting
{
MeetingId = (int)reader["MeetingId"],
MeetingTitle = reader["MeetingTitle"].ToString(),
MeetingDate = (DateTime)reader["MeetingDate"],
CreatedBy = (int)reader["CreatedBy"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return meetings;
}
public Meeting GetById(int id)
{
Meeting meeting = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Meetings WHERE MeetingId = @MeetingId", connection);
command.Parameters.AddWithValue("@MeetingId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
meeting = new Meeting
{
MeetingId = (int)reader["MeetingId"],
MeetingTitle = reader["MeetingTitle"].ToString(),
MeetingDate = (DateTime) reader["MeetingDate"],
CreatedBy = (int)reader["CreatedBy"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return meeting;
}
public void Add(Meeting meeting)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Meetings (MeetingTitle, MeetingDate, CreatedBy) VALUES (@MeetingTitle, @MeetingDate, @CreatedBy)", connection);
command.Parameters.AddWithValue("@MeetingTitle", meeting.MeetingTitle);
command.Parameters.AddWithValue("@MeetingDate", meeting.MeetingDate);
command.Parameters.AddWithValue("@CreatedBy", meeting.CreatedBy);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Meeting meeting)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Meetings SET MeetingTitle = @MeetingTitle, MeetingDate = @MeetingDate, CreatedBy = @CreatedBy WHERE MeetingId = @MeetingId", connection);
command.Parameters.AddWithValue("@MeetingId", meeting.MeetingId);
command.Parameters.AddWithValue("@MeetingTitle", meeting.MeetingTitle);
command.Parameters.AddWithValue("@MeetingDate", meeting.MeetingDate);
command.Parameters.AddWithValue("@CreatedBy", meeting.CreatedBy);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Meetings WHERE MeetingId = @MeetingId", connection);
command.Parameters.AddWithValue("@MeetingId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
TaskRepository
public class TaskRepository : IRepository<Task>
{
private readonly string _connectionString;
public TaskRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Task> GetAll()
{
var tasks = new List<Task>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Tasks", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
tasks.Add(new Task
{
TaskId = (int)reader["TaskId"],
TaskTitle = reader["TaskTitle"].ToString(),
AssignedTo = (int)reader["AssignedTo"],
DueDate = (DateTime)reader["DueDate"],
Status = reader["Status"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return tasks;
}
public Task GetById(int id)
{
Task task = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Tasks WHERE TaskId = @TaskId", connection);
command.Parameters.AddWithValue("@TaskId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
task = new Task
{
TaskId = (int)reader["TaskId"],
TaskTitle = reader["TaskTitle"].ToString(),
AssignedTo = (int)reader["AssignedTo"],
DueDate = (DateTime)reader["DueDate"],
Status = reader["Status"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return task;
}
public void Add(Task task)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Tasks (TaskTitle, AssignedTo, DueDate, Status) VALUES (@TaskTitle, @AssignedTo, @DueDate, @Status)", connection);
command.Parameters.AddWithValue("@TaskTitle", task.TaskTitle);
command.Parameters.AddWithValue("@AssignedTo", task.AssignedTo);
command.Parameters.AddWithValue("@DueDate", task.DueDate);
command.Parameters.AddWithValue("@Status", task.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Task task)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Tasks SET TaskTitle = @TaskTitle, AssignedTo = @AssignedTo, DueDate = @DueDate, Status = @Status, UpdatedAt = GETDATE() WHERE TaskId = @TaskId", connection);
command.Parameters.AddWithValue("@TaskId", task.TaskId);
command.Parameters.AddWithValue("@TaskTitle", task.TaskTitle);
command.Parameters.AddWithValue("@AssignedTo", task.AssignedTo);
command.Parameters.AddWithValue("@DueDate", task.DueDate);
command.Parameters.AddWithValue("@Status", task.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Tasks WHERE TaskId = @TaskId", connection);
command.Parameters.AddWithValue("@TaskId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
AttendanceRepository
public class AttendanceRepository : IRepository<Attendance>
{
private readonly string _connectionString;
public AttendanceRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Attendance> GetAll()
{
var attendances = new List<Attendance>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Attendance", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
attendances.Add(new Attendance
{
AttendanceId = (int)reader["AttendanceId"],
UserId = (int)reader["User Id"],
AttendanceDate = (DateTime)reader["AttendanceDate"],
Status = reader["Status"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return attendances;
}
public Attendance GetById(int id)
{
Attendance attendance = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Attendance WHERE AttendanceId = @AttendanceId", connection);
command.Parameters.AddWithValue("@AttendanceId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
attendance = new Attendance
{
AttendanceId = (int)reader["AttendanceId"],
UserId = (int)reader["User Id"],
AttendanceDate = (DateTime)reader["AttendanceDate"],
Status = reader["Status"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return attendance;
}
public void Add(Attendance attendance)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Attendance (User Id, AttendanceDate, Status) VALUES (@User Id, @AttendanceDate, @Status)", connection);
command.Parameters.AddWithValue("@User Id", attendance.UserId);
command.Parameters.AddWithValue("@AttendanceDate", attendance.AttendanceDate);
command.Parameters.AddWithValue("@Status", attendance.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Attendance attendance)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Attendance SET UserId = @User Id, AttendanceDate = @AttendanceDate, Status = @Status WHERE AttendanceId = @AttendanceId", connection);
command.Parameters.AddWithValue("@AttendanceId", attendance.AttendanceId);
command.Parameters.AddWithValue("@User Id", attendance.UserId);
command.Parameters.AddWithValue("@AttendanceDate", attendance.AttendanceDate);
command.Parameters.AddWithValue("@Status", attendance.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Attendance WHERE AttendanceId = @AttendanceId", connection);
command.Parameters.AddWithValue("@AttendanceId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
ReportRepository
public class ReportRepository : IRepository<Report>
{
private readonly string _connectionString;
public ReportRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Report> GetAll()
{
var reports = new List<Report>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Reports", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
reports.Add(new Report
{
ReportId = (int)reader["ReportId"],
UserId = (int)reader["User Id"],
ReportDate = (DateTime)reader["ReportDate"],
ReportContent = reader["ReportContent"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return reports;
}
public Report GetById(int id)
{
Report report = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Reports WHERE ReportId = @ReportId", connection);
command.Parameters.AddWithValue("@ReportId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
report = new Report
{
ReportId = (int)reader["ReportId"],
UserId = (int)reader["User Id"],
ReportDate = (DateTime)reader["ReportDate"],
ReportContent = reader["ReportContent"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return report;
}
public void Add(Report report)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Reports (User Id, ReportDate, ReportContent) VALUES (@User Id, @ReportDate, @ReportContent)", connection);
command.Parameters.AddWithValue("@User Id", report.UserId);
command.Parameters.AddWithValue("@ReportDate", report.ReportDate);
command.Parameters.AddWithValue("@ReportContent", report.ReportContent);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Report report)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Reports SET UserId = @User Id, ReportDate = @ReportDate, ReportContent = @ReportContent WHERE ReportId = @ReportId", connection);
command.Parameters.AddWithValue("@ReportId", report.ReportId);
command.Parameters.AddWithValue("@User Id", report.UserId);
command.Parameters.AddWithValue("@ReportDate", report.ReportDate);
command.Parameters.AddWithValue("@ReportContent", report.ReportContent);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Reports WHERE ReportId = @ReportId", connection);
command.Parameters.AddWithValue("@ReportId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
FeedbackRepository
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"]
});
}
}
}
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"]
};
}
}
}
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 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();
}
}
}
NotificationRepository
public class NotificationRepository : IRepository<Notification>
{
private readonly string _connectionString;
public NotificationRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Notification> GetAll()
{
var notifications = new List<Notification>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Notifications", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
notifications.Add(new Notification
{
NotificationId = (int)reader["NotificationId"],
UserId = (int)reader["User Id"],
Message = reader["Message"].ToString(),
IsRead = (bool)reader["IsRead"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return notifications;
}
public Notification GetById(int id)
{
Notification notification = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Notifications WHERE NotificationId = @NotificationId", connection);
command.Parameters.AddWithValue("@NotificationId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
notification = new Notification
{
NotificationId = (int)reader["NotificationId"],
UserId = (int)reader["User Id"],
Message = reader["Message"].ToString(),
IsRead = (bool)reader["IsRead"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return notification;
}
public void Add(Notification notification)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Notifications (User Id, Message, IsRead) VALUES (@User Id, @Message, @IsRead)", connection);
command.Parameters.AddWithValue("@User Id", notification.UserId);
command.Parameters.AddWithValue("@Message", notification.Message);
command.Parameters.AddWithValue("@IsRead", notification.IsRead);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Notification notification)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Notifications SET UserId = @User Id, Message = @Message, IsRead = @IsRead WHERE NotificationId = @NotificationId", connection);
command.Parameters.AddWithValue("@NotificationId", notification.NotificationId);
command.Parameters.AddWithValue("@User Id", notification.UserId);
command.Parameters.AddWithValue("@Message", notification.Message);
command.Parameters.AddWithValue("@IsRead", notification.IsRead);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Notifications WHERE NotificationId = @NotificationId", connection);
command.Parameters.AddWithValue("@NotificationId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
This completes the repository implementations for all the models. Each repository follows the same pattern, ensuring consistency and maintainability across your ASP.NET application.
To create controllers for each repository in an ASP.NET MVC application, we will follow the standard pattern of creating a controller for each entity. Each controller will handle HTTP requests, interact with the corresponding repository, and return views or data as needed.
Below are the controller implementations for each of the repositories: User , Role, Asset, InventoryItem, Document, Meeting, Task, Attendance, Report, Feedback, and Notification.
Base Controller
First, let's create a base controller that can be inherited by all other controllers. This will help in managing common functionalities like dependency injection for the repositories.
using Microsoft.AspNetCore.Mvc;
public class BaseController : Controller
{
protected readonly string _connectionString;
public BaseController(string connectionString)
{
_connectionString = connectionString;
}
}
Controllers
UserController
public class UserController : BaseController
{
private readonly UserRepository _userRepository;
public UserController(string connectionString) : base(connectionString)
{
_userRepository = new UserRepository(connectionString);
}
public IActionResult Index()
{
var users = _userRepository.GetAll();
return View(users);
}
public IActionResult Details(int id)
{
var user = _userRepository.GetById(id);
return View(user);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(User user)
{
if (ModelState.IsValid)
{
_userRepository.Add(user);
return RedirectToAction(nameof(Index));
}
return View(user);
}
public IActionResult Edit(int id)
{
var user = _userRepository.GetById(id);
return View(user);
}
[HttpPost]
public IActionResult Edit(User user)
{
if (ModelState.IsValid)
{
_userRepository.Update(user);
return RedirectToAction(nameof(Index));
}
return View(user);
}
public IActionResult Delete(int id)
{
var user = _userRepository.GetById(id);
return View(user);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_userRepository.Delete(id);
return RedirectToAction(nameof(Index));
}
}
RoleController
public class RoleController : BaseController
{
private readonly RoleRepository _roleRepository;
public RoleController(string connectionString) : base(connectionString)
{
_roleRepository = new RoleRepository(connectionString);
}
public IActionResult Index()
{
var roles = _roleRepository.GetAll();
return View(roles);
}
public IActionResult Details(int id)
{
var role = _roleRepository.GetById(id);
return View(role);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Role role)
{
if (ModelState.IsValid)
{
_roleRepository.Add(role);
return RedirectToAction(nameof(Index));
}
return View(role);
}
public IActionResult Edit(int id)
{
var role = _roleRepository.GetById(id);
return View(role);
}
[HttpPost]
public IActionResult Edit(Role role)
{
if (ModelState.IsValid)
{
_roleRepository.Update(role);
return RedirectToAction(nameof(Index));
}
return View(role);
}
public IActionResult Delete(int id)
{
var role = _roleRepository.GetById(id);
return View(role);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_roleRepository.Delete(id);
return RedirectToAction(nameof(Index));
}
}
AssetController
public class AssetController : BaseController
{
private readonly AssetRepository _assetRepository;
public AssetController(string connectionString) : base(connectionString)
{
_assetRepository = new AssetRepository(connectionString);
}
public IActionResult Index()
{
var assets = _assetRepository.GetAll();
return View(assets);
}
public IActionResult Details(int id)
{
var asset = _assetRepository.GetById(id);
return View(asset);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Asset asset)
{
if (ModelState.IsValid)
{
_assetRepository.Add(asset);
return RedirectToAction(nameof(Index));
}
return View(asset);
}
public IActionResult Edit(int id)
{
var asset = _assetRepository.GetById(id);
return View(asset);
}
[HttpPost]
public IActionResult Edit(Asset asset)
{
if (ModelState.IsValid)
{
_assetRepository.Update(asset);
return RedirectToAction(nameof(Index));
}
return View(asset);
}
public IActionResult Delete(int id)
{
var asset = _assetRepository.GetById(id);
return View(asset);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_assetRepository.Delete(id);
return RedirectToAction(nameof(Index));
}
}
InventoryItemController
public class InventoryItemController : BaseController
{
private readonly InventoryItemRepository _inventoryItemRepository;
public InventoryItemController(string connectionString) : base(connectionString)
{
_inventoryItemRepository = new InventoryItemRepository(connectionString);
}
public IActionResult Index()
{
var items = _inventoryItemRepository.GetAll();
return View(items);
}
public IActionResult Details(int id)
{
var item = _inventoryItemRepository.GetById(id);
return View(item);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(InventoryItem item)
{
if (ModelState.IsValid)
{
_inventoryItemRepository.Add(item);
return RedirectToAction(nameof(Index));
}
return View(item);
}
public IActionResult Edit(int id)
{
var item = _inventoryItemRepository.GetById(id);
return View(item);
}
[HttpPost]
public IActionResult Edit(InventoryItem item)
{
if (ModelState.IsValid)
{
_inventoryItemRepository.Update(item);
return RedirectToAction(nameof(Index));
}
return View(item);
}
public IActionResult Delete(int id)
{
var item = _inventoryItemRepository.GetById(id);
return View(item);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_inventoryItemRepository.Delete(id);
return RedirectToAction(nameof(Index));
}
}
DocumentController
public class DocumentController : BaseController
{
private readonly DocumentRepository _documentRepository;
public DocumentController(string connectionString) : base(connectionString)
{
_documentRepository = new DocumentRepository(connectionString);
}
public IActionResult Index()
{
var documents = _documentRepository.GetAll();
return View(documents);
}
public IActionResult Details(int id)
{
var document = _documentRepository.GetById(id);
return View(document);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Document document)
{
if (ModelState.IsValid)
{
_documentRepository.Add(document);
return RedirectToAction(nameof(Index));
}
return View(document);
}
public IActionResult Edit(int id)
{
var document = _documentRepository.GetById(id);
return View(document);
}
[HttpPost]
public IActionResult Edit(Document document)
{
if (ModelState.IsValid)
{
_documentRepository.Update(document);
return RedirectToAction(nameof(Index));
}
return View(document);
}
public IActionResult Delete(int id)
{
var document = _documentRepository.GetById(id);
return View(document);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_documentRepository.Delete(id);
return RedirectToAction(nameof(Index));
}
}
MeetingController
public class MeetingController : BaseController
{
private readonly MeetingRepository _meetingRepository;
public MeetingController(string connectionString) : base(connectionString)
{
_meetingRepository = new MeetingRepository(connectionString);
}
public IActionResult Index()
{
var meetings = _meetingRepository.GetAll();
return View(meetings);
}
public IActionResult Details(int id)
{
var meeting = _meetingRepository.GetById(id);
return View(meeting);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Meeting meeting)
{
if (ModelState.IsValid)
{
_meetingRepository.Add(meeting);
return RedirectToAction(nameof(Index));
}
return View(meeting);
}
public IActionResult Edit(int id)
{
var meeting = _meetingRepository.GetById(id);
return View(meeting);
}
[HttpPost]
public IActionResult Edit(Meeting meeting)
{
if (ModelState.IsValid)
{
_meetingRepository.Update(meeting);
return RedirectToAction(nameof(Index));
}
return View(meeting);
}
public IActionResult Delete(int id)
{
var meeting = _meetingRepository.GetById(id);
return View(meeting);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_meetingRepository.Delete(id);
return RedirectToAction(nameof(Index));
}
}
TaskController
public class TaskController : BaseController
{
private readonly TaskRepository _taskRepository;
public TaskController(string connectionString) : base(connectionString)
{
_taskRepository = new TaskRepository(connectionString);
}
public IActionResult Index()
{
var tasks = _taskRepository.GetAll();
return View(tasks);
}
public IActionResult Details(int id)
{
var task = _taskRepository.GetById(id);
return View(task);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Task task)
{
if (ModelState.IsValid)
{
_taskRepository.Add(task);
return RedirectToAction(nameof(Index));
}
return View(task);
}
public IActionResult Edit(int id)
{
var task = _taskRepository.GetById(id);
return View(task);
}
[HttpPost]
public IActionResult Edit(Task task)
{
if (ModelState.IsValid)
{
_taskRepository.Update(task);
return RedirectToAction(nameof(Index));
}
return View(task);
}
public IActionResult Delete(int id)
{
var task = _taskRepository.GetById(id);
return View(task);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_taskRepository.Delete(id);
return RedirectToAction(nameof(Index));
}
}
AttendanceController
public class AttendanceController : BaseController
{
private readonly AttendanceRepository _attendanceRepository;
public AttendanceController(string connectionString) : base(connectionString)
{
_attendanceRepository = new AttendanceRepository(connectionString);
}
public IActionResult Index()
{
var attendances = _attendanceRepository.GetAll();
return View(attendances);
}
public IActionResult Details(int id)
{
var attendance = _attendanceRepository.GetById(id);
return View(attendance);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Attendance attendance)
{
if (ModelState.IsValid)
{
_attendanceRepository.Add(attendance);
return RedirectToAction(nameof(Index));
}
return View(attendance);
}
public IActionResult Edit(int id)
{
var attendance = _attendanceRepository.GetById(id);
return View(attendance);
}
[HttpPost]
public IActionResult Edit(Attendance attendance)
{
if (ModelState.IsValid)
{
_attendanceRepository.Update(attendance);
return RedirectToAction(nameof(Index));
}
return View(attendance);
}
public IActionResult Delete(int id)
{
var attendance = _attendanceRepository.GetById(id);
return View(attendance);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_attendanceRepository.Delete(id);
return RedirectToAction(nameof(Index));
}
}
ReportController
public class ReportController : BaseController
{
private readonly ReportRepository _reportRepository;
public ReportController(string connectionString) : base(connectionString)
{
_reportRepository = new ReportRepository(connectionString);
}
public IActionResult Index()
{
var reports = _reportRepository.GetAll();
return View(reports);
}
public IActionResult Details(int id)
{
var report = _reportRepository.GetById(id);
return View(report);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Report report)
{
if (ModelState.IsValid)
{
_reportRepository.Add(report);
return RedirectToAction(nameof(Index));
}
return View(report);
}
public IActionResult Edit(int id)
{
var report = _reportRepository.GetById(id);
return View(report);
}
[HttpPost]
public IActionResult Edit(Report report)
{
if (ModelState.IsValid)
{
_reportRepository.Update(report);
return RedirectToAction(nameof(Index));
}
return View(report);
}
public IActionResult Delete(int id)
{
var report = _reportRepository.GetById(id);
return View(report);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_reportRepository.Delete(id);
return RedirectToAction(nameof(Index));
}
}
FeedbackController
public class FeedbackController : BaseController
{
private readonly FeedbackRepository _feedbackRepository;
public FeedbackController(string connectionString) : base(connectionString)
{
_feedbackRepository = new FeedbackRepository(connectionString);
}
public IActionResult Index()
{
var feedbacks = _feedbackRepository.GetAll();
return View(feedbacks);
}
public IActionResult Details(int id)
{
var feedback = _feedbackRepository.GetById(id);
return View(feedback);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Feedback feedback)
{
if (ModelState.IsValid)
{
_feedbackRepository.Add(feedback);
return RedirectToAction(nameof(Index));
}
return View(feedback);
}
public IActionResult Edit(int id)
{
var feedback = _feedbackRepository.GetById(id);
return View(feedback);
}
[HttpPost]
public IActionResult Edit(Feedback feedback)
{
if (ModelState.IsValid)
{
_feedbackRepository.Update(feedback);
return RedirectToAction(nameof(Index));
}
return View(feedback);
}
public IActionResult Delete(int id)
{
var feedback = _feedbackRepository.GetById(id);
return View(feedback);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_feedbackRepository.Delete(id);
return RedirectToAction(nameof(Index));
}
}
NotificationController
public class NotificationController : BaseController
{
private readonly NotificationRepository _notificationRepository;
public NotificationController(string connectionString) : base(connectionString)
{
_notificationRepository = new NotificationRepository(connectionString);
}
public IActionResult Index()
{
var notifications = _notificationRepository.GetAll();
return View(notifications);
}
public IActionResult Details(int id)
{
var notification = _notificationRepository.GetById(id);
return View(notification);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Notification notification)
{
if (ModelState.IsValid)
{
_notificationRepository.Add(notification);
return RedirectToAction(nameof(Index));
}
return View(notification);
}
public IActionResult Edit(int id)
{
var notification = _notificationRepository.GetById(id);
return View(notification);
}
[HttpPost]
public IActionResult Edit(Notification notification)
{
if (ModelState.IsValid)
{
_notificationRepository.Update(notification);
return RedirectToAction(nameof(Index));
}
return View(notification);
}
public IActionResult Delete(int id)
{
var notification = _notificationRepository.GetById(id);
return View(notification);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_notificationRepository.Delete(id);
return RedirectToAction(nameof(Index));
}
}
This completes the controller implementations for all the repositories. Each controller follows the same pattern, ensuring consistency and maintainability across your ASP.NET application. Each action method corresponds to the CRUD operations, allowing for easy management of the respective entities.
Creating Views
Creating views for each controller in an ASP.NET MVC application involves creating Razor view files that correspond to the actions in the controllers. Below, I will provide a basic structure for the views for each controller: User, Role, Asset, InventoryItem, Document, Meeting, Task, Attendance, Report, Feedback, and Notification.
Folder Structure
Assuming you have a standard ASP.NET MVC project structure, the views for each controller will be placed in their respective folders under the Views directory. The folder structure will look like this:
/Views
/User
Index.cshtml
Details.cshtml
Create.cshtml
Edit.cshtml
Delete.cshtml
/Role
Index.cshtml
Details.cshtml
Create.cshtml
Edit.cshtml
Delete.cshtml
/Asset
Index.cshtml
Details.cshtml
Create.cshtml
Edit.cshtml
Delete.cshtml
/InventoryItem
Index.cshtml
Details.cshtml
Create.cshtml
Edit.cshtml
Delete.cshtml
/Document
Index.cshtml
Details.cshtml
Create.cshtml
Edit.cshtml
Delete.cshtml
/Meeting
Index.cshtml
Details.cshtml
Create.cshtml
Edit.cshtml
Delete.cshtml
/Task
Index.cshtml
Details.cshtml
Create.cshtml
Edit.cshtml
Delete.cshtml
/Attendance
Index.cshtml
Details.cshtml
Create.cshtml
Edit.cshtml
Delete.cshtml
/Report
Index.cshtml
Details.cshtml
Create.cshtml
Edit.cshtml
Delete.cshtml
/Feedback
Index.cshtml
Details.cshtml
Create.cshtml
Edit.cshtml
Delete.cshtml
/Notification
Index.cshtml
Details.cshtml
Create.cshtml
Edit.cshtml
Delete.cshtml
Example Views
Below are example views for each action in the User controller. You can replicate this structure for the other controllers by changing the model type and the relevant fields.
User Views
1. Index.cshtml
@model IEnumerable<User>
@{
ViewBag.Title = "Users";
}
<h2>Users</h2>
<p>
<a asp-action="Create" class="btn btn-primary">Create New User</a>
</p>
<table class="table">
<thead>
<tr>
<th>Username</th>
<th>Email</th>
<th>First Name</th>
<th>Last Name</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var user in Model)
{
<tr>
<td>@user.Username</td>
<td>@user.Email</td>
<td>@user.FirstName</td>
<td>@user.LastName</td>
<td>
<a asp-action="Details" asp-route-id="@user.UserId" class="btn btn-info">Details</a>
<a asp-action="Edit" asp-route-id="@user.UserId" class="btn btn-warning">Edit</a>
<a asp-action="Delete" asp-route-id="@user.UserId" class="btn btn-danger">Delete</a>
</td>
</tr>
}
</tbody>
</table>
2. Details.cshtml
@model 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>
<a asp-action="Edit" asp-route-id="@Model.UserId" class="btn btn-warning">Edit</a>
<a asp-action="Index" class="btn btn-default">Back to List</a>
</div>
3. Create.cshtml
@model User
@{
ViewBag.Title = "Create User";
}
<h2>Create User</h2>
<form asp-action="Create">
<div class="form-group">
<label asp-for="Username" class="control-label"></label>
<input asp-for="Username" class="form-control" />
<span asp-validation-for="Username" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="PasswordHash" class="control-label"></label>
<input asp-for="PasswordHash" class="form-control" />
<span asp-validation-for="PasswordHash" class="text-danger"></ span>
</div>
<div class="form-group">
<label asp-for="Email" class="control-label"></label>
<input asp-for="Email" class="form-control" />
<span asp-validation-for="Email" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="FirstName" class="control-label"></label>
<input asp-for="FirstName" class="form-control" />
<span asp-validation-for="FirstName" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="LastName" class="control-label"></label>
<input asp-for="LastName" class="form-control" />
<span asp-validation-for="LastName" class="text-danger"></span>
</div>
<div>
<input type="submit" value="Create" class="btn btn-primary" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
4. Edit.cshtml
@model User
@{
ViewBag.Title = "Edit User";
}
<h2>Edit User</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="User Id" />
<div class="form-group">
<label asp-for="Username" class="control-label"></label>
<input asp-for="Username" class="form-control" />
<span asp-validation-for="Username" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Email" class="control-label"></label>
<input asp-for="Email" class="form-control" />
<span asp-validation-for="Email" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="FirstName" class="control-label"></label>
<input asp-for="FirstName" class="form-control" />
<span asp-validation-for="FirstName" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="LastName" class="control-label"></label>
<input asp-for="LastName" class="form-control" />
<span asp-validation-for="LastName" class="text-danger"></span>
</div>
<div>
<input type="submit" value="Save" class="btn btn-primary" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
5. Delete.cshtml
@model User
@{
ViewBag.Title = "Delete User";
}
<h2>Delete User</h2>
<div>
<h4>User</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Username)
</dt>
<dd>
@Html.DisplayFor(model => model.Username)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Email)
</dt>
<dd>
@Html.DisplayFor(model => model.Email)
</dd>
</dl>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="User Id" />
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
Replicating for Other Controllers
You can replicate the above structure for the other controllers (Role, Asset, InventoryItem, Document, Meeting, Task, Attendance, Report, Feedback, and Notification) by changing the model type and the relevant fields in each view file. Ensure that the action names and routes correspond to the respective controller actions.
This will provide a complete set of views for managing each entity in your application, allowing users to perform CRUD operations seamlessly.
Creating Remaining Views
Below are the Razor views for the remaining controllers: Role, Asset, InventoryItem, Document, Meeting, Task, Attendance, Report, Feedback, and Notification. Each set of views will follow the same structure as the User views provided earlier.
Role Views
1. Index.cshtml
@model IEnumerable<Role>
@{
ViewBag.Title = "Roles";
}
<h2>Roles</h2>
<p>
<a asp-action="Create" class="btn btn-primary">Create New Role</a>
</p>
<table class="table">
<thead>
<tr>
<th>Role Name</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var role in Model)
{
<tr>
<td>@role.RoleName</td>
<td>
<a asp-action="Details" asp-route-id="@role.RoleId" class="btn btn-info">Details</a>
<a asp-action="Edit" asp-route-id="@role.RoleId" class="btn btn-warning">Edit</a>
<a asp-action="Delete" asp-route-id="@role.RoleId" class="btn btn-danger">Delete</a>
</td>
</tr>
}
</tbody>
</table>
2. Details.cshtml
@model Role
@{
ViewBag.Title = "Role Details";
}
<h2>Role Details</h2>
<div>
<h4>Role</h4>
<hr />
<dl class="dl-horizontal">
<dt>@Html.DisplayNameFor(model => model.RoleName)</dt>
<dd>@Html.DisplayFor(model => model.RoleName)</dd>
</dl>
</div>
<div>
<a asp-action="Edit" asp-route-id="@Model.RoleId" class="btn btn-warning">Edit</a>
<a asp-action="Index" class="btn btn-default">Back to List</a>
</div>
3. Create.cshtml
@model Role
@{
ViewBag.Title = "Create Role";
}
<h2>Create Role</h2>
<form asp-action="Create">
<div class="form-group">
<label asp-for="RoleName" class="control-label"></label>
<input asp-for="RoleName" class="form-control" />
<span asp-validation-for="RoleName" class="text-danger"></span>
</div>
<div>
<input type="submit" value="Create" class="btn btn-primary" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
4. Edit.cshtml
@model Role
@{
ViewBag.Title = "Edit Role";
}
<h2>Edit Role</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="RoleId" />
<div class="form-group">
<label asp-for="RoleName" class="control-label"></label>
<input asp-for="RoleName" class="form-control" />
<span asp-validation-for="RoleName" class="text-danger"></span>
</div>
<div>
<input type="submit" value="Save" class="btn btn-primary" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
5. Delete.cshtml
@model Role
@{
ViewBag.Title = "Delete Role";
}
<h2>Delete Role</h2>
<div>
<h4>Role</h4>
<hr />
<dl class="dl-horizontal">
<dt>@Html.DisplayNameFor(model => model.RoleName)</dt>
<dd>@Html.DisplayFor(model => model.RoleName)</dd>
</dl>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="RoleId" />
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
Asset Views
1. Index.cshtml
@model IEnumerable<Asset>
@{
ViewBag.Title = "Assets";
}
<h2>Assets</h2>
<p>
<a asp-action="Create" class="btn btn-primary">Create New Asset</a>
</p>
<table class="table">
<thead>
<tr>
<th>Asset Name</th>
<th>Asset Type</th>
<th>Purchase Date</th>
<th>Status</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var asset in Model)
{
<tr>
<td>@asset.AssetName</td>
<td>@asset.AssetType</td>
<td>@asset.PurchaseDate.ToShortDateString()</td>
<td>@asset.Status</td>
<td>
<a asp-action="Details" asp-route-id="@asset.AssetId" class="btn btn-info">Details</a>
<a asp-action="Edit" asp-route-id="@asset.AssetId" class="btn btn-warning">Edit</a>
<a asp-action="Delete" asp-route-id="@asset.Asset Id" class="btn btn-danger">Delete</a>
</td>
</tr>
}
</tbody>
</table>
2. Details.cshtml
@model Asset
@{
ViewBag.Title = "Asset Details";
}
<h2>Asset Details</h2>
<div>
<h4>Asset</h4>
<hr />
<dl class="dl-horizontal">
<dt>@Html.DisplayNameFor(model => model.AssetName)</dt>
<dd>@Html.DisplayFor(model => model.AssetName)</dd>
<dt>@Html.DisplayNameFor(model => model.AssetType)</dt>
<dd>@Html.DisplayFor(model => model.AssetType)</dd>
<dt>@Html.DisplayNameFor(model => model.PurchaseDate)</dt>
<dd>@Html.DisplayFor(model => model.PurchaseDate.ToShortDateString())</dd>
<dt>@Html.DisplayNameFor(model => model.Status)</dt>
<dd>@Html.DisplayFor(model => model.Status)</dd>
</dl>
</div>
<div>
<a asp-action="Edit" asp-route-id="@Model.AssetId" class="btn btn-warning">Edit</a>
<a asp-action="Index" class="btn btn-default">Back to List</a>
</div>
3. Create.cshtml
@model Asset
@{
ViewBag.Title = "Create Asset";
}
<h2>Create Asset</h2>
<form asp-action="Create">
<div class="form-group">
<label asp-for="AssetName" class="control-label"></label>
<input asp-for="AssetName" class="form-control" />
<span asp-validation-for="AssetName" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="AssetType" class="control-label"></label>
<input asp-for="AssetType" class="form-control" />
<span asp-validation-for="AssetType" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="PurchaseDate" class="control-label"></label>
<input asp-for="PurchaseDate" class="form-control" type="date" />
<span asp-validation-for="PurchaseDate" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Status" class="control-label"></label>
<input asp-for="Status" class="form-control" />
<span asp-validation-for="Status" class="text-danger"></span>
</div>
<div>
<input type="submit" value="Create" class="btn btn-primary" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
4. Edit.cshtml
@model Asset
@{
ViewBag.Title = "Edit Asset";
}
<h2>Edit Asset</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="AssetId" />
<div class="form-group">
<label asp-for="AssetName" class="control-label"></label>
<input asp-for="AssetName" class="form-control" />
<span asp-validation-for="AssetName" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="AssetType" class="control-label"></label>
<input asp-for="AssetType" class="form-control" />
<span asp-validation-for="AssetType" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="PurchaseDate" class="control-label"></label>
<input asp-for="PurchaseDate" class="form-control" type="date" />
<span asp-validation-for="PurchaseDate" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Status" class="control-label"></label>
<input asp-for="Status" class="form-control" />
<span asp-validation-for="Status" class="text-danger"></span>
</div>
<div>
<input type="submit" value="Save" class="btn btn-primary" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
5. Delete.cshtml
@model Asset
@{
ViewBag.Title = "Delete Asset";
}
<h2>Delete Asset</h2>
<div>
<h4>Asset</h4>
<hr />
<dl class="dl-horizontal">
<dt>@Html.DisplayNameFor (model => model.AssetName)</dt>
<dd>@Html.DisplayFor(model => model.AssetName)</dd>
<dt>@Html.DisplayNameFor(model => model.AssetType)</dt>
<dd>@Html.DisplayFor(model => model.AssetType)</dd>
<dt>@Html.DisplayNameFor(model => model.PurchaseDate)</dt>
<dd>@Html.DisplayFor(model => model.PurchaseDate.ToShortDateString())</dd>
<dt>@Html.DisplayNameFor(model => model.Status)</dt>
<dd>@Html.DisplayFor(model => model.Status)</dd>
</dl>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="AssetId" />
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
InventoryItem Views
1. Index.cshtml
@model IEnumerable<InventoryItem>
@{
ViewBag.Title = "Inventory Items";
}
<h2>Inventory Items</h2>
<p>
<a asp-action="Create" class="btn btn-primary">Create New Inventory Item</a>
</p>
<table class="table">
<thead>
<tr>
<th>Item Name</th>
<th>Quantity</th>
<th>Location</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
<td>@item.ItemName</td>
<td>@item.Quantity</td>
<td>@item.Location</td>
<td>
<a asp-action="Details" asp-route-id="@item.InventoryItemId" class="btn btn-info">Details</a>
<a asp-action="Edit" asp-route-id="@item.InventoryItemId" class="btn btn-warning">Edit</a>
<a asp-action="Delete" asp-route-id="@item.InventoryItemId" class="btn btn-danger">Delete</a>
</td>
</tr>
}
</tbody>
</table>
2. Details.cshtml
@model InventoryItem
@{
ViewBag.Title = "Inventory Item Details";
}
<h2>Inventory Item Details</h2>
<div>
<h4>Inventory Item</h4>
<hr />
<dl class="dl-horizontal">
<dt>@Html.DisplayNameFor(model => model.ItemName)</dt>
<dd>@Html.DisplayFor(model => model.ItemName)</dd>
<dt>@Html.DisplayNameFor(model => model.Quantity)</dt>
<dd>@Html.DisplayFor(model => model.Quantity)</dd>
<dt>@Html.DisplayNameFor(model => model.Location)</dt>
<dd>@Html.DisplayFor(model => model.Location)</dd>
</dl>
</div>
<div>
<a asp-action="Edit" asp-route-id="@Model.InventoryItemId" class="btn btn-warning">Edit</a>
<a asp-action="Index" class="btn btn-default">Back to List</a>
</div>
3. Create.cshtml
@model InventoryItem
@{
ViewBag.Title = "Create Inventory Item";
}
<h2>Create Inventory Item</h2>
<form asp-action="Create">
<div class="form-group">
<label asp-for="ItemName" class="control-label"></label>
<input asp-for="ItemName" class="form-control" />
<span asp-validation-for="ItemName" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Quantity" class="control-label"></label>
<input asp-for="Quantity" class="form-control" />
<span asp-validation-for="Quantity" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Location" class="control-label"></label>
<input asp-for="Location" class="form-control" />
<span asp-validation-for="Location" class="text-danger"></span>
</div>
<div>
<input type="submit" value="Create" class="btn btn-primary" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
4. Edit.cshtml
@model InventoryItem
@{
ViewBag.Title = "Edit Inventory Item";
}
<h2>Edit Inventory Item</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="InventoryItemId" />
<div class="form-group">
<label asp -for="ItemName" class="control-label"></label>
<input asp-for="ItemName" class="form-control" />
<span asp-validation-for="ItemName" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Quantity" class="control-label"></label>
<input asp-for="Quantity" class="form-control" />
<span asp-validation-for="Quantity" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Location" class="control-label"></label>
<input asp-for="Location" class="form-control" />
<span asp-validation-for="Location" class="text-danger"></span>
</div>
<div>
<input type="submit" value="Save" class="btn btn-primary" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
5. Delete.cshtml
@model InventoryItem
@{
ViewBag.Title = "Delete Inventory Item";
}
<h2>Delete Inventory Item</h2>
<div>
<h4>Inventory Item</h4>
<hr />
<dl class="dl-horizontal">
<dt>@Html.DisplayNameFor(model => model.ItemName)</dt>
<dd>@Html.DisplayFor(model => model.ItemName)</dd>
<dt>@Html.DisplayNameFor(model => model.Quantity)</dt>
<dd>@Html.DisplayFor(model => model.Quantity)</dd>
<dt>@Html.DisplayNameFor(model => model.Location)</dt>
<dd>@Html.DisplayFor(model => model.Location)</dd>
</dl>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="InventoryItemId" />
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
Document Views
1. Index.cshtml
@model IEnumerable<Document>
@{
ViewBag.Title = "Documents";
}
<h2>Documents</h2>
<p>
<a asp-action="Create" class="btn btn-primary">Create New Document</a>
</p>
<table class="table">
<thead>
<tr>
<th>Document Title</th>
<th>Upload Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var document in Model)
{
<tr>
<td>@document.Title</td>
<td>@document.UploadDate.ToShortDateString()</td>
<td>
<a asp-action="Details" asp-route-id="@document.DocumentId" class="btn btn-info">Details</a>
<a asp-action="Edit" asp-route-id="@document.DocumentId" class="btn btn-warning">Edit</a>
<a asp-action="Delete" asp-route-id="@document.DocumentId" class="btn btn-danger">Delete</a>
</td>
</tr>
}
</tbody>
</table>
2. Details.cshtml
@model Document
@{
ViewBag.Title = "Document Details";
}
<h2>Document Details</h2>
<div>
<h4>Document</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.UploadDate)</dt>
<dd>@Html.DisplayFor(model => model.UploadDate.ToShortDateString())</dd>
</dl>
</div>
<div>
<a asp-action="Edit" asp-route-id="@Model.DocumentId" class="btn btn-warning">Edit</a>
<a asp-action="Index" class="btn btn-default">Back to List</a>
</div>
3. Create.cshtml
@model Document
@{
ViewBag.Title = "Create Document";
}
<h2>Create Document</h2>
<form asp-action="Create">
<div class="form-group">
<label asp-for="Title" class="control-label"></label>
<input asp-for="Title" class="form-control" />
<span asp-validation-for="Title" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="UploadDate" class="control-label"></label>
<input asp-for="UploadDate" class="form-control" type="date" />
<span asp-validation-for="UploadDate" class="text-danger"></span>
</div>
<div>
<input type="submit" value="Create" class="btn btn-primary" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
4. Edit.cshtml
@model Document
@{
ViewBag.Title = "Edit Document";
}
<h2>Edit Document</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="DocumentId" />
<div class="form-group">
<label asp-for="Title" class="control-label"></label>
<input asp-for="Title" class="form-control" />
<span asp-validation-for="Title" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="UploadDate" class="control-label"></label>
<input asp-for="UploadDate" class="form-control" type="date" />
<span asp-validation-for="UploadDate" class="text-danger"></span>
</div>
<div>
<input type="submit" value="Save" class="btn btn-primary" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
5. Delete.cshtml
@model Document
@{
ViewBag.Title = "Delete Document";
}
<h2>Delete Document</h2>
<div>
<h4>Document</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.UploadDate)</dt>
<dd>@Html.DisplayFor(model => model.UploadDate.ToShortDateString())</dd>
</dl>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="DocumentId" />
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
Meeting Views
1. Index.cshtml
@model IEnumerable<Meeting>
@{
ViewBag.Title = "Meetings";
}
<h2>Meetings</h2>
<p>
<a asp-action="Create" class="btn btn-primary">Create New Meeting</a>
</p>
<table class="table">
<thead>
<tr>
<th>Meeting Title</th>
<th>Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var meeting in Model)
{
<tr>
<td>@meeting.Title</td>
<td>@meeting.Date.ToShortDateString()</td>
<td>
<a asp-action="Details" asp-route-id="@meeting.MeetingId" class="btn btn-info">Details</a>
<a asp-action="Edit" asp-route-id="@meeting.MeetingId" class="btn btn-warning">Edit</a>
<a asp-action="Delete" asp-route-id="@meeting.MeetingId" class="btn btn-danger">Delete</a>
</td>
</tr>
}
</tbody>
</table>
2. Details.cshtml
@model Meeting
@{
ViewBag.Title = "Meeting Details";
}
<h2>Meeting Details</h2>
<div>
<h4>Meeting</h4>
<hr />
<dl class="dl-horizontal">
<dt>@Html.DisplayNameFor(model => model.Title)</dt>
<dd>@Html.DisplayFor(model => model.Title)</dd>
<dt>@Html.DisplayNameFor(model => model.Date)</dt>
<dd>@Html.DisplayFor(model => model.Date.ToShortDateString())</dd>
</dl>
</div>
<div>
<a asp-action="Edit" asp-route-id="@Model.MeetingId" class="btn btn-warning">Edit</a>
<a asp-action="Index" class="btn btn-default">Back to List</a>
</div>
3. Create.cshtml
@model Meeting
@{
ViewBag.Title = "Create Meeting";
}
<h2>Create Meeting</h2>
<form asp-action="Create">
<div class="form-group">
<label asp-for="Title" class="control-label"></label>
<input asp-for="Title" class="form-control" />
<span asp-validation-for="Title" class="text -danger"></span>
</div>
<div class="form-group">
<label asp-for="Date" class="control-label"></label>
<input asp-for="Date" class="form-control" type="date" />
<span asp-validation-for="Date" class="text-danger"></span>
</div>
<div>
<input type="submit" value="Create" class="btn btn-primary" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
4. Edit.cshtml
@model Meeting
@{
ViewBag.Title = "Edit Meeting";
}
<h2>Edit Meeting</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="MeetingId" />
<div class="form-group">
<label asp-for="Title" class="control-label"></label>
<input asp-for="Title" class="form-control" />
<span asp-validation-for="Title" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Date" class="control-label"></label>
<input asp-for="Date" class="form-control" type="date" />
<span asp-validation-for="Date" class="text-danger"></span>
</div>
<div>
<input type="submit" value="Save" class="btn btn-primary" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
5. Delete.cshtml
@model Meeting
@{
ViewBag.Title = "Delete Meeting";
}
<h2>Delete Meeting</h2>
<div>
<h4>Meeting</h4>
<hr />
<dl class="dl-horizontal">
<dt>@Html.DisplayNameFor(model => model.Title)</dt>
<dd>@Html.DisplayFor(model => model.Title)</dd>
<dt>@Html.DisplayNameFor(model => model.Date)</dt>
<dd>@Html.DisplayFor(model => model.Date.ToShortDateString())</dd>
</dl>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="MeetingId" />
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
Task Views
1. Index.cshtml
@model IEnumerable<Task>
@{
ViewBag.Title = "Tasks";
}
<h2>Tasks</h2>
<p>
<a asp-action="Create" class="btn btn-primary">Create New Task</a>
</p>
<table class="table">
<thead>
<tr>
<th>Task Title</th>
<th>Due Date</th>
<th>Status</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var task in Model)
{
<tr>
<td>@task.Title</td>
<td>@task.DueDate.ToShortDateString()</td>
<td>@task.Status</td>
<td>
<a asp-action="Details" asp-route-id="@task.TaskId" class="btn btn-info">Details</a>
<a asp-action="Edit" asp-route-id="@task.TaskId" class="btn btn-warning">Edit</a>
<a asp-action="Delete" asp-route-id="@task.TaskId" class="btn btn-danger">Delete</a>
</td>
</tr>
}
</tbody>
</table>
2. Details.cshtml
@model Task
@{
ViewBag.Title = "Task Details";
}
<h2>Task Details</h2>
<div>
<h4>Task</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.DueDate)</dt>
<dd>@Html.DisplayFor(model => model.DueDate.ToShortDateString())</dd>
<dt>@Html.DisplayNameFor(model => model.Status)</dt>
<dd>@Html.DisplayFor(model => model.Status)</dd>
</dl>
</div>
<div>
<a asp-action="Edit" asp-route-id="@Model.TaskId" class="btn btn-warning">Edit</a>
<a asp-action="Index" class="btn btn-default">Back to List</a>
</div>
3. Create.cshtml
@model Task
@{
ViewBag.Title = "Create Task";
}
<h2>Create Task</h2>
<form asp-action="Create">
<div class="form-group">
<label asp-for="Title" class="control-label"></label>
<input asp-for="Title" class="form-control" />
<span asp-validation-for="Title" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="DueDate" class="control-label"></label>
<input asp-for="DueDate" class="form-control" type="date" />
<span asp-validation-for="DueDate" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Status" class="control-label"></label>
<input asp-for="Status" class="form-control" />
<span asp-validation-for="Status" class="text-danger"></span>
</div>
<div>
<input type="submit" value="Create" class="btn btn-primary" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
4. Edit.cshtml
@model Task
@{
ViewBag.Title = "Edit Task";
}
<h2>Edit Task</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="TaskId" />
<div class="form-group">
<label asp-for="Title" class="control-label"></label>
<input asp-for="Title" class="form-control" />
<span asp-validation-for="Title" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="DueDate" class="control-label"></label>
<input asp-for="DueDate" class="form-control" type="date" />
<span asp-validation-for="DueDate" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Status" class="control-label"></label>
<input asp-for="Status" class="form-control" />
<span asp-validation-for="Status" class="text-danger"></span>
</div>
<div>
<input type="submit" value="Save" class="btn btn-primary" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
5. Delete.cshtml
@model Task
@{
ViewBag.Title = "Delete Task";
}
<h2>Delete Task</h2>
<div>
<h4>Task</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.DueDate)</dt>
<dd>@Html.DisplayFor(model => model.DueDate.ToShortDateString())</dd>
<dt>@Html.DisplayNameFor(model => model.Status)</dt>
<dd>@Html.DisplayFor(model => model.Status)</dd>
</dl>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="TaskId" />
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
Attendance Views
1. Index.cshtml
@model IEnumerable<Attendance>
@{
ViewBag.Title = "Attendance Records";
}
<h2>Attendance Records</h2>
<p>
<a asp-action="Create" class="btn btn-primary">Create New Attendance Record</a>
</p>
<table class="table">
<thead>
<tr>
<th>Employee Name</th>
<th>Date</th>
<th>Status</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var attendance in Model)
{
<tr>
<td>@attendance.EmployeeName</td>
<td>@attendance.Date.ToShortDateString()</td>
<td>@attendance.Status</td>
<td>
<a asp-action="Details" asp-route-id="@attendance.AttendanceId" class="btn btn-info">Details</a>
<a asp-action="Edit" asp-route-id="@attendance.AttendanceId" class="btn btn-warning">Edit</a>
<a asp-action="Delete" asp-route-id="@attendance .AttendanceId" class="btn btn-danger">Delete</a>
</td>
</tr>
}
</tbody>
</table>
2. Details.cshtml
@model Attendance
@{
ViewBag.Title = "Attendance Details";
}
<h2>Attendance Details</h2>
<div>
<h4>Attendance Record</h4>
<hr />
<dl class="dl-horizontal">
<dt>@Html.DisplayNameFor(model => model.EmployeeName)</dt>
<dd>@Html.DisplayFor(model => model.EmployeeName)</dd>
<dt>@Html.DisplayNameFor(model => model.Date)</dt>
<dd>@Html.DisplayFor(model => model.Date.ToShortDateString())</dd>
<dt>@Html.DisplayNameFor(model => model.Status)</dt>
<dd>@Html.DisplayFor(model => model.Status)</dd>
</dl>
</div>
<div>
<a asp-action="Edit" asp-route-id="@Model.AttendanceId" class="btn btn-warning">Edit</a>
<a asp-action="Index" class="btn btn-default">Back to List</a>
</div>
3. Create.cshtml
@model Attendance
@{
ViewBag.Title = "Create Attendance Record";
}
<h2>Create Attendance Record</h2>
<form asp-action="Create">
<div class="form-group">
<label asp-for="EmployeeName" class="control-label"></label>
<input asp-for="EmployeeName" class="form-control" />
<span asp-validation-for="EmployeeName" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Date" class="control-label"></label>
<input asp-for="Date" class="form-control" type="date" />
<span asp-validation-for="Date" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Status" class="control-label"></label>
<input asp-for="Status" class="form-control" />
<span asp-validation-for="Status" class="text-danger"></span>
</div>
<div>
<input type="submit" value="Create" class="btn btn-primary" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
4. Edit.cshtml
@model Attendance
@{
ViewBag.Title = "Edit Attendance Record";
}
<h2>Edit Attendance Record</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="AttendanceId" />
<div class="form-group">
<label asp-for="EmployeeName" class="control-label"></label>
<input asp-for="EmployeeName" class="form-control" />
<span asp-validation-for="EmployeeName" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Date" class="control-label"></label>
<input asp-for="Date" class="form-control" type="date" />
<span asp-validation-for="Date" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Status" class="control-label"></label>
<input asp-for="Status" class="form-control" />
<span asp-validation-for="Status" class="text-danger"></span>
</div>
<div>
<input type="submit" value="Save" class="btn btn-primary" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
5. Delete.cshtml
@model Attendance
@{
ViewBag.Title = "Delete Attendance Record";
}
<h2>Delete Attendance Record</h2>
<div>
<h4>Attendance Record</h4>
<hr />
<dl class="dl-horizontal">
<dt>@Html.DisplayNameFor(model => model.EmployeeName)</dt>
<dd>@Html.DisplayFor(model => model.EmployeeName)</dd>
<dt>@Html.DisplayNameFor(model => model.Date)</dt>
<dd>@Html.DisplayFor(model => model.Date.ToShortDateString())</dd>
<dt>@Html.DisplayNameFor(model => model.Status)</dt>
<dd>@Html.DisplayFor(model => model.Status)</dd>
</dl>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="AttendanceId" />
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
<a asp-action="Index" class="btn btn-default">Cancel </a>
</div>
</form>
Report Views
1. Index.cshtml
@model IEnumerable<Report>
@{
ViewBag.Title = "Reports";
}
<h2>Reports</h2>
<p>
<a asp-action="Create" class="btn btn-primary">Create New Report</a>
</p>
<table class="table">
<thead>
<tr>
<th>Report Title</th>
<th>Created Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var report in Model)
{
<tr>
<td>@report.Title</td>
<td>@report.CreatedDate.ToShortDateString()</td>
<td>
<a asp-action="Details" asp-route-id="@report.ReportId" class="btn btn-info">Details</a>
<a asp-action="Edit" asp-route-id="@report.ReportId" class="btn btn-warning">Edit</a>
<a asp-action="Delete" asp-route-id="@report.ReportId" class="btn btn-danger">Delete</a>
</td>
</tr>
}
</tbody>
</table>
2. Details.cshtml
@model 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.CreatedDate)</dt>
<dd>@Html.DisplayFor(model => model.CreatedDate.ToShortDateString())</dd>
</dl>
</div>
<div>
<a asp-action="Edit" asp-route-id="@Model.ReportId" class="btn btn-warning">Edit</a>
<a asp-action="Index" class="btn btn-default">Back to List</a>
</div>
3. Create.cshtml
@model Report
@{
ViewBag.Title = "Create Report";
}
<h2>Create Report</h2>
<form asp-action="Create">
<div class="form-group">
<label asp-for="Title" class="control-label"></label>
<input asp-for="Title" class="form-control" />
<span asp-validation-for="Title" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="CreatedDate" class="control-label"></label>
<input asp-for="CreatedDate" class="form-control" type="date" />
<span asp-validation-for="CreatedDate" class="text-danger"></span>
</div>
<div>
<input type="submit" value="Create" class="btn btn-primary" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
4. Edit.cshtml
@model Report
@{
ViewBag.Title = "Edit Report";
}
<h2>Edit Report</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="ReportId" />
<div class="form-group">
<label asp-for="Title" class="control-label"></label>
<input asp-for="Title" class="form-control" />
<span asp-validation-for="Title" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="CreatedDate" class="control-label"></label>
<input asp-for="CreatedDate" class="form-control" type="date" />
<span asp-validation-for="CreatedDate" class="text-danger"></span>
</div>
<div>
<input type="submit" value="Save" class="btn btn-primary" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
5. Delete.cshtml
@model 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.CreatedDate)</dt>
<dd>@Html.DisplayFor(model => model.CreatedDate.ToShortDateString())</dd>
</dl>
</div>
<form asp-action=" Delete">
<input type="hidden" asp-for="ReportId" />
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
Feedback Views
1. Index.cshtml
@model IEnumerable<Feedback>
@{
ViewBag.Title = "Feedback";
}
<h2>Feedback</h2>
<p>
<a asp-action="Create" class="btn btn-primary">Create New Feedback</a>
</p>
<table class="table">
<thead>
<tr>
<th>Feedback Title</th>
<th>Submitted Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var feedback in Model)
{
<tr>
<td>@feedback.Title</td>
<td>@feedback.SubmittedDate.ToShortDateString()</td>
<td>
<a asp-action="Details" asp-route-id="@feedback.FeedbackId" class="btn btn-info">Details</a>
<a asp-action="Edit" asp-route-id="@feedback.FeedbackId" class="btn btn-warning">Edit</a>
<a asp-action="Delete" asp-route-id="@feedback.FeedbackId" class="btn btn-danger">Delete</a>
</td>
</tr>
}
</tbody>
</table>
2. Details.cshtml
@model Feedback
@{
ViewBag.Title = "Feedback Details";
}
<h2>Feedback Details</h2>
<div>
<h4>Feedback</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.SubmittedDate)</dt>
<dd>@Html.DisplayFor(model => model.SubmittedDate.ToShortDateString())</dd>
<dt>@Html.DisplayNameFor(model => model.Content)</dt>
<dd>@Html.DisplayFor(model => model.Content)</dd>
</dl>
</div>
<div>
<a asp-action="Edit" asp-route-id="@Model.FeedbackId" class="btn btn-warning">Edit</a>
<a asp-action="Index" class="btn btn-default">Back to List</a>
</div>
3. Create.cshtml
@model Feedback
@{
ViewBag.Title = "Create Feedback";
}
<h2>Create Feedback</h2>
<form asp-action="Create">
<div class="form-group">
<label asp-for="Title" class="control-label"></label>
<input asp-for="Title" class="form-control" />
<span asp-validation-for="Title" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Content" class="control-label"></label>
<textarea asp-for="Content" class="form-control"></textarea>
<span asp-validation-for="Content" class="text-danger"></span>
</div>
<div>
<input type="submit" value="Create" class="btn btn-primary" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
4. Edit.cshtml
@model Feedback
@{
ViewBag.Title = "Edit Feedback";
}
<h2>Edit Feedback</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="FeedbackId" />
<div class="form-group">
<label asp-for="Title" class="control-label"></label>
<input asp-for="Title" class="form-control" />
<span asp-validation-for="Title" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Content" class="control-label"></label>
<textarea asp-for="Content" class="form-control"></textarea>
<span asp-validation-for="Content" class="text-danger"></span>
</div>
<div>
<input type="submit" value="Save" class="btn btn-primary" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
5. Delete.cshtml
@model Feedback
@{
ViewBag.Title = "Delete Feedback";
}
<h2>Delete Feedback</h2>
<div>
<h4>Feedback</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.SubmittedDate)</dt>
<dd>@Html.DisplayFor(model => model.SubmittedDate.ToShortDateString())</dd>
<dt>@Html.DisplayNameFor(model => model.Content)</dt>
<dd>@Html.DisplayFor(model => model.Content)</dd>
</dl>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="FeedbackId" />
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
Notification Views
1. Index.cshtml
@model IEnumerable<Notification>
@{
ViewBag.Title = "Notifications";
}
<h2>Notifications</h2>
<p>
<a asp-action="Create" class="btn btn-primary">Create New Notification</a>
</p>
<table class="table">
<thead>
<tr>
<th>Notification Title</th>
<th>Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var notification in Model)
{
<tr>
<td>@notification.Title</td>
<td>@notification.Date.ToShortDateString()</td>
<td>
<a asp-action="Details" asp-route-id="@notification.NotificationId" class="btn btn-info">Details</a>
<a asp-action="Edit" asp-route-id="@notification.NotificationId" class="btn btn-warning">Edit</a>
<a asp-action="Delete" asp-route-id="@notification.NotificationId" class="btn btn-danger">Delete</a>
</td>
</tr>
}
</tbody>
</table>
2. Details.cshtml
@model 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.Date)</dt>
<dd>@Html.DisplayFor(model => model.Date.ToShortDateString())</dd>
<dt>@Html.DisplayNameFor(model => model.Content)</dt>
<dd>@Html.DisplayFor(model => model.Content)</dd>
</dl>
</div>
<div>
<a asp-action="Edit" asp-route-id="@Model.NotificationId" class="btn btn-warning">Edit</a>
<a asp-action="Index" class="btn btn-default">Back to List</a>
</div>
3. Create.cshtml
@model Notification
@{
ViewBag.Title = "Create Notification";
}
<h2>Create Notification</h2>
<form asp-action="Create">
<div class="form-group">
<label asp-for="Title" class="control-label"></label>
<input asp-for="Title" class="form-control" />
<span asp-validation-for="Title" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Content" class="control-label"></label>
<textarea asp-for="Content" class="form-control"></textarea>
<span asp-validation-for="Content" class="text-danger"></span>
</div>
<div>
<input type="submit" value="Create" class="btn btn-primary" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
4. Edit.cshtml
@model Notification
@{
ViewBag.Title = "Edit Notification";
}
<h2>Edit Notification</h2>
<form asp-action="Edit">
<input type="hidden" asp-for="NotificationId" />
<div class="form-group">
<label asp-for="Title" class="control-label"></label>
<input asp-for="Title" class="form-control" />
<span asp-validation-for="Title" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Content" class="control-label"></label>
<textarea asp-for="Content" class="form-control"></textarea>
<span asp-validation-for="Content" class="text-danger"></span>
</div>
<div>
<input type="submit" value="Save" class="btn btn-primary" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
5. Delete.cshtml
@model 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.Date)</dt>
<dd>@Html.DisplayFor(model => model.Date.ToShortDateString())</dd>
<dt>@Html.DisplayNameFor(model => model.Content)</dt>
<dd>@Html.DisplayFor(model => model.Content)</dd>
</dl>
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="NotificationId" />
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
<a asp-action="Index" class="btn btn-default">Cancel</a>
</div>
</form>
This completes the creation of all the view files for the specified controllers: User, Role, Asset, InventoryItem, Document, Meeting, Task, Attendance, Report, Feedback, and Notification. Each controller has its corresponding views for CRUD operations, following the same structure and conventions. You can now implement these views in your ASP.NET MVC application to facilitate user interactions with the respective entities.
Creating a Dashboard Page
Creating a dashboard page in an ASP.NET MVC application involves designing a view that consolidates data from various models and displays it in a user-friendly manner. The dashboard can include statistics, charts, and summaries of the data related to users, roles, assets, tasks, meetings, attendance, reports, feedback, and notifications.
Step 1: Create a Dashboard Controller
First, create a new controller called DashboardController. This controller will fetch the necessary data from the repositories and pass it to the view.
using Microsoft.AspNetCore.Mvc;
public class DashboardController : Controller
{
private readonly UserRepository _userRepository;
private readonly RoleRepository _roleRepository;
private readonly AssetRepository _assetRepository;
private readonly TaskRepository _taskRepository;
private readonly MeetingRepository _meetingRepository;
private readonly AttendanceRepository _attendanceRepository;
private readonly ReportRepository _reportRepository;
private readonly FeedbackRepository _feedbackRepository;
private readonly NotificationRepository _notificationRepository;
public DashboardController(string connectionString)
{
_userRepository = new UserRepository(connectionString);
_roleRepository = new RoleRepository(connectionString);
_assetRepository = new AssetRepository(connectionString);
_taskRepository = new TaskRepository(connectionString);
_meetingRepository = new MeetingRepository(connectionString);
_attendanceRepository = new AttendanceRepository(connectionString);
_reportRepository = new ReportRepository(connectionString);
_feedbackRepository = new FeedbackRepository(connectionString);
_notificationRepository = new NotificationRepository(connectionString);
}
public IActionResult Index()
{
var dashboardData = new DashboardViewModel
{
UserCount = _userRepository.GetAll().Count(),
RoleCount = _roleRepository.GetAll().Count(),
AssetCount = _assetRepository.GetAll().Count(),
TaskCount = _taskRepository.GetAll().Count(),
MeetingCount = _meetingRepository.GetAll().Count(),
AttendanceCount = _attendanceRepository.GetAll().Count(),
ReportCount = _reportRepository.GetAll().Count(),
FeedbackCount = _feedbackRepository.GetAll().Count(),
NotificationCount = _notificationRepository.GetAll().Count()
};
return View(dashboardData);
}
}
Step 2: Create a Dashboard ViewModel
Create a ViewModel to hold the data that will be displayed on the dashboard.
public class DashboardViewModel
{
public int UserCount { get; set; }
public int RoleCount { get; set; }
public int AssetCount { get; set; }
public int TaskCount { get; set; }
public int MeetingCount { get; set; }
public int AttendanceCount { get; set; }
public int ReportCount { get; set; }
public int FeedbackCount { get; set; }
public int NotificationCount { get; set; }
}
Step 3: Create the Dashboard View
Create a new view called Index.cshtml under the Views/Dashboard folder. This view will display the consolidated data.
@model DashboardViewModel
@{
ViewBag.Title = "Dashboard";
}
<h2>Dashboard</h2>
<div class="row">
<div class="col-md-3">
<div class="card text-white bg-primary mb-3">
<div class="card-header">Users</div>
<div class="card-body">
<h5 class="card-title">@Model.UserCount</h5>
<p class="card-text">Total number of users in the system.</p>
</div>
</div>
</div>
<div class="col-md-3">
<div class="card text-white bg-success mb-3">
<div class="card-header">Roles</div>
<div class="card-body">
<h5 class="card-title">@Model.RoleCount</h5>
<p class="card-text">Total number of roles defined.</p>
</div>
</div>
</div>
<div class="col-md-3">
<div class="card text-white bg-info mb-3">
<div class="card-header">Assets</div>
<div class="card-body">
<h5 class="card-title">@Model.AssetCount</h5>
<p class="card-text">Total number of assets managed.</p>
</div>
</div>
</div>
<div class="col-md-3">
<div class="card text-white bg-warning mb-3">
<div class="card-header">Tasks</div>
<div class="card-body">
<h5 class="card-title">@Model.TaskCount</h5>
<p class="card-text">Total number of tasks assigned.</p>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-md-3">
<div class="card text-white bg-danger mb-3">
<div class="card-header">Meetings</div>
<div class="card-body">
<h5 class="card-title">@Model.MeetingCount</h5>
<p class="card-text">Total number of meetings scheduled.</p>
</div>
</div>
</div>
<div class="col-md-3">
<div class="card text-white bg-secondary mb-3">
<div class="card-header">Attendance</div>
<div class="card-body">
<h5 class="card-title">@Model.AttendanceCount</h5>
<p class="card-text ">Total attendance records logged.</p>
</div>
</div>
</div>
<div class="col-md-3">
<div class="card text-white bg-light mb-3">
<div class="card-header">Reports</div>
<div class="card-body">
<h5 class="card-title">@Model.ReportCount</h5>
<p class="card-text">Total number of reports generated.</p>
</div>
</div>
</div>
<div class="col-md-3">
<div class="card text-white bg-dark mb-3">
<div class="card-header">Feedback</div>
<div class="card-body">
<h5 class="card-title">@Model.FeedbackCount</h5>
<p class="card-text">Total feedback received from users.</p>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-md-3">
<div class="card text-white bg-info mb-3">
<div class="card-header">Notifications</div>
<div class="card-body">
<h5 class="card-title">@Model.NotificationCount</h5>
<p class="card-text">Total notifications sent to users.</p>
</div>
</div>
</div>
</div>
Step 4: Update the Routing
Make sure to add a route for the dashboard in your Startup.cs or Program.cs file, depending on your ASP.NET Core version.
app.UseEndpoints(endpoints =>
{
endpoints.MapControllerRoute(
name: "default",
pattern: "{controller=Dashboard}/{action=Index}/{id?}");
});
Step 5: Access the Dashboard
You can now access the dashboard by navigating to /Dashboard in your web application. This page will display consolidated data related to the project, providing a quick overview of key metrics and statistics.
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