Project Introduction
The Job Portal Project is designed to connect job seekers with employers by providing a comprehensive platform for job listings, applications, and company profiles. Built using ASP.NET and SQL Server, this application aims to streamline the recruitment process for both job seekers and employers. The system will allow users to create profiles, upload resumes, apply for jobs, and receive notifications about job opportunities. Employers can post job openings, manage applications, and view company profiles, enhancing the overall efficiency of the hiring process.
Project Objectives
- To create a secure user authentication system for managing user accounts and roles.
- To enable job seekers to create profiles, upload resumes, and apply for jobs.
- To allow employers to post job openings and manage applications effectively.
- To facilitate the creation of company profiles to attract potential candidates.
- To implement a notification system to keep users informed about job applications and opportunities.
- To collect feedback from users to improve the platform's functionality and user experience.
- To provide subscription plans for employers to enhance their visibility and access to job seekers.
- To manage payments for subscription plans and ensure secure transactions.
Project Modules
- User Management Module: Handles user registration, login, and role management.
- Job Management Module: Allows employers to post, edit, and delete job listings.
- Resume Management Module: Enables job seekers to upload and manage their resumes.
- Application Management Module: Facilitates the application process for job seekers and tracks application status.
- Company Profile Module: Manages company profiles, including descriptions and websites.
- Notification Module: Sends notifications to users regarding job applications and new job postings.
- Feedback Module: Collects user feedback and ratings to improve the platform.
- Subscription Management Module: Manages subscription plans for employers and tracks payments.
- Payment Management Module: Handles payment processing for subscription plans.
SQL Server Database Tables
-- Users Table
CREATE TABLE Users (
UserId INT PRIMARY KEY IDENTITY(1,1),
Username NVARCHAR(50) NOT NULL UNIQUE,
PasswordHash NVARCHAR(255) NOT NULL,
Email NVARCHAR(100) NOT NULL UNIQUE,
Phone NVARCHAR(15),
RoleId INT,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (RoleId) REFERENCES Roles(RoleId)
);
-- Roles Table
CREATE TABLE Roles (
RoleId INT PRIMARY KEY IDENTITY(1,1),
RoleName NVARCHAR(50) NOT NULL UNIQUE
);
-- Jobs Table
CREATE TABLE Jobs (
JobId INT PRIMARY KEY IDENTITY(1,1),
EmployerId INT,
JobTitle NVARCHAR(100) NOT NULL,
JobDescription NVARCHAR(MAX),
JobType NVARCHAR(50), -- e.g., Full-time, Part-time, Contract
Location NVARCHAR(100),
Salary DECIMAL(10, 2),
PostedDate DATETIME DEFAULT GETDATE(),
ExpirationDate DATETIME,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (EmployerId) REFERENCES Users(UserId)
);
-- Resumes Table
CREATE TABLE Resumes (
ResumeId INT PRIMARY KEY IDENTITY(1,1),
JobSeekerId INT,
ResumeFile NVARCHAR(255) NOT NULL, -- Path to the resume file
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (JobSeekerId) REFERENCES Users(UserId)
);
-- Applications Table
CREATE TABLE Applications (
ApplicationId INT PRIMARY KEY IDENTITY(1,1),
JobId INT,
JobSeekerId INT,
ApplicationDate DATETIME DEFAULT GETDATE(),
Status NVARCHAR(20) DEFAULT 'Pending', -- e.g., Pending, Accepted, Rejected
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (JobId) REFERENCES Jobs(JobId),
FOREIGN KEY (JobSeekerId) REFERENCES Users(UserId)
);
-- CompanyProfiles Table
CREATE TABLE CompanyProfiles (
CompanyId INT PRIMARY KEY IDENTITY(1,1),
EmployerId INT,
CompanyName NVARCHAR(100) NOT NULL,
Description NVARCHAR(MAX),
Website NVARCHAR(255),
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (EmployerId) REFERENCES Users(UserId)
);
-- Notifications Table
CREATE TABLE Notifications (
NotificationId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
Message NVARCHAR(MAX),
IsRead BIT DEFAULT 0,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- Feedback Table
CREATE TABLE Feedbacks (
FeedbackId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
Comments NVARCHAR(MAX),
Rating INT CHECK (Rating >= 1 AND Rating <= 5),
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- SubscriptionPlans Table
CREATE TABLE SubscriptionPlans (
PlanId INT PRIMARY KEY IDENTITY(1,1),
PlanName NVARCHAR(100) NOT NULL,
Price DECIMAL(10, 2) NOT NULL,
DurationInDays INT NOT NULL, -- Duration of the subscription
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE()
);
-- Payments Table
CREATE TABLE Payments (
PaymentId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
PlanId INT,
Amount DECIMAL(10, 2) NOT NULL,
PaymentDate DATETIME DEFAULT GETDATE(),
PaymentMethod NVARCHAR(50), -- e.g., Credit Card, PayPal
Status NVARCHAR(20) DEFAULT 'Completed',
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId),
FOREIGN KEY (PlanId) REFERENCES SubscriptionPlans(PlanId)
);
Explanation of Tables
Users: Stores user information, including credentials and roles (e.g., job seeker, employer).
Roles: Defines different roles within the system (e.g., admin, job seeker, employer).
Jobs: Contains job postings, including details such as title, description, type, location, and salary.
Resumes: Manages resumes uploaded by job seekers, including file paths.
Applications: Records job applications submitted by job seekers, tracking the status of each application.
CompanyProfiles: Stores information about employers, including company name, description, and website.
Notifications: Manages notifications sent to users, indicating important updates or messages.
Feedback: Collects user feedback regarding the platform, including ratings and comments.
SubscriptionPlans: Defines various subscription plans available for employers, including pricing and duration.
Payments: Records payment transactions made by users for subscription plans, including payment method and status.
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 Phone { get; set; }
public int? RoleId { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Role
{
public int RoleId { get; set; }
public string RoleName { get; set; }
}
public class Job
{
public int JobId { get; set; }
public int? EmployerId { get; set; }
public string JobTitle { get; set; }
public string JobDescription { get; set; }
public string JobType { get; set; }
public string Location { get; set; }
public decimal Salary { get; set; }
public DateTime PostedDate { get; set; }
public DateTime? ExpirationDate { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Resume
{
public int ResumeId { get; set; }
public int JobSeekerId { get; set; }
public string ResumeFile { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Application
{
public int ApplicationId { get; set; }
public int JobId { get; set; }
public int JobSeekerId { get; set; }
public DateTime ApplicationDate { get; set; }
public string Status { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class CompanyProfile
{
public int CompanyId { get; set; }
public int EmployerId { get; set; }
public string CompanyName { get; set; }
public string Description { get; set; }
public string Website { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Notification
{
public int NotificationId { get; set; }
public int UserId { get; set; }
public string Message { get; set; }
public bool IsRead { get; set; }
public DateTime CreatedAt { get; set; }
}
public class Feedback
{
public int FeedbackId { get; set; }
public int UserId { get; set; }
public string Comments { get; set; }
public int Rating { get; set; }
public DateTime CreatedAt { get; set; }
}
public class SubscriptionPlan
{
public int PlanId { get; set; }
public string PlanName { get; set; }
public decimal Price { get; set; }
public int DurationInDays { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Payment
{
public int PaymentId { get; set; }
public int UserId { get; set; }
public int PlanId { get; set; }
public decimal Amount { get; set; }
public DateTime PaymentDate { get; set; }
public string PaymentMethod { get; set; }
public string Status { get; set; }
public DateTime CreatedAt { get; set; }
}
Step 2: Create Repositories
Next, we will create a generic repository interface and a concrete implementation for each model. Here’s an example of how to implement a repository for the User model:
Generic Repository Interface
public interface IRepository<T>
{
IEnumerable<T> GetAll();
T GetById(int id);
void Add(T entity);
void Update(T entity);
void Delete(int id);
}
User Repository Implementation
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
public class UserRepository : IRepository<User>
{
private readonly string _connectionString;
public UserRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<User> GetAll()
{
var users = new List<User>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Users", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
users.Add(new User
{
UserId = (int)reader["User Id"],
Username = reader["Username"].ToString(),
PasswordHash = reader["PasswordHash"].ToString(),
Email = reader["Email"].ToString(),
Phone = reader["Phone"]?.ToString(),
RoleId = reader["RoleId"] as int?,
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(),
Phone = reader["Phone"]?.ToString(),
RoleId = reader["RoleId"] as int?,
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, Phone, RoleId) VALUES (@Username, @PasswordHash, @Email, @Phone, @RoleId)", connection);
command.Parameters.AddWithValue("@Username", user.Username);
command.Parameters.AddWithValue("@PasswordHash", user.PasswordHash);
command.Parameters.AddWithValue("@Email", user.Email);
command.Parameters.AddWithValue("@Phone", user.Phone);
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, Phone = @Phone, RoleId = @RoleId, UpdatedAt = GETDATE() WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", user.UserId);
command.Parameters.AddWithValue("@Username", user.Username);
command.Parameters.AddWithValue("@PasswordHash", user.PasswordHash);
command.Parameters.AddWithValue("@Email", user.Email);
command.Parameters.AddWithValue("@Phone", user.Phone);
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 pattern can be replicated for other models such as Role, Job, Resume, etc., by creating similar repository classes for each model. Each repository will implement the IRepository
public class RoleRepository : IRepository
{
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()
});
}
}
}
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()
};
}
}
}
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 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();
}
}
}
public class JobRepository : IRepository {
private readonly string _connectionString;
public JobRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Job> GetAll()
{
var jobs = new List<Job>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Jobs", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
jobs.Add(new Job
{
JobId = (int)reader["JobId"],
EmployerId = reader["EmployerId"] as int?,
JobTitle = reader["JobTitle"].ToString(),
JobDescription = reader["JobDescription"].ToString(),
JobType = reader["JobType"].ToString(),
Location = reader["Location"].ToString(),
Salary = (decimal)reader["Salary"],
PostedDate = (DateTime)reader["PostedDate"],
ExpirationDate = reader["ExpirationDate"] as DateTime?,
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return jobs;
}
public Job GetById(int id)
{
Job job = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Jobs WHERE JobId = @JobId", connection);
command.Parameters.AddWithValue("@JobId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
job = new Job
{
JobId = (int)reader["JobId"],
EmployerId = reader["EmployerId"] as int?,
JobTitle = reader["JobTitle"].ToString(),
JobDescription = reader["JobDescription"].ToString(),
JobType = reader["JobType"].ToString(),
Location = reader["Location"].ToString(),
Salary = (decimal)reader["Salary"],
PostedDate = (DateTime)reader["PostedDate"],
ExpirationDate = reader["ExpirationDate"] as DateTime?,
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime) reader["UpdatedAt"]
};
}
}
}
return job;
}
public void Add(Job job)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Jobs (EmployerId, JobTitle, JobDescription, JobType, Location, Salary) VALUES (@EmployerId, @JobTitle, @JobDescription, @JobType, @Location, @Salary)", connection);
command.Parameters.AddWithValue("@EmployerId", job.EmployerId);
command.Parameters.AddWithValue("@JobTitle", job.JobTitle);
command.Parameters.AddWithValue("@JobDescription", job.JobDescription);
command.Parameters.AddWithValue("@JobType", job.JobType);
command.Parameters.AddWithValue("@Location", job.Location);
command.Parameters.AddWithValue("@Salary", job.Salary);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Job job)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Jobs SET EmployerId = @EmployerId, JobTitle = @JobTitle, JobDescription = @JobDescription, JobType = @JobType, Location = @Location, Salary = @Salary, UpdatedAt = GETDATE() WHERE JobId = @JobId", connection);
command.Parameters.AddWithValue("@JobId", job.JobId);
command.Parameters.AddWithValue("@EmployerId", job.EmployerId);
command.Parameters.AddWithValue("@JobTitle", job.JobTitle);
command.Parameters.AddWithValue("@JobDescription", job.JobDescription);
command.Parameters.AddWithValue("@JobType", job.JobType);
command.Parameters.AddWithValue("@Location", job.Location);
command.Parameters.AddWithValue("@Salary", job.Salary);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Jobs WHERE JobId = @JobId", connection);
command.Parameters.AddWithValue("@JobId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
This pattern can be extended to other entities like Resume, Application, CompanyProfile, Notification, Feedback, SubscriptionPlan, and Payment by creating similar repository classes for each. Each repository will encapsulate the data access logic specific to its model, promoting separation of concerns and making the codebase easier to maintain.
public class ResumeRepository : IRepository<Resume>
{
private readonly string _connectionString;
public ResumeRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Resume> GetAll()
{
var resumes = new List<Resume>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Resumes", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
resumes.Add(new Resume
{
ResumeId = (int)reader["ResumeId"],
JobSeekerId = (int)reader["JobSeekerId"],
ResumeFile = reader["ResumeFile"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return resumes;
}
public Resume GetById(int id)
{
Resume resume = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Resumes WHERE ResumeId = @ResumeId", connection);
command.Parameters.AddWithValue("@ResumeId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
resume = new Resume
{
ResumeId = (int)reader["ResumeId"],
JobSeekerId = (int)reader["JobSeekerId"],
ResumeFile = reader["ResumeFile"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return resume;
}
public void Add(Resume resume)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Resumes (JobSeekerId, ResumeFile) VALUES (@JobSeekerId, @ResumeFile)", connection);
command.Parameters.AddWithValue("@JobSeekerId", resume.JobSeekerId);
command.Parameters.AddWithValue("@ResumeFile", resume.ResumeFile);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Resume resume)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Resumes SET JobSeekerId = @JobSeekerId, ResumeFile = @ResumeFile, UpdatedAt = GETDATE() WHERE ResumeId = @ResumeId", connection);
command.Parameters.AddWithValue("@ResumeId", resume.ResumeId);
command.Parameters.AddWithValue("@JobSeekerId", resume.JobSeekerId);
command.Parameters.AddWithValue("@ResumeFile", resume.ResumeFile);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Resumes WHERE ResumeId = @ResumeId", connection);
command.Parameters.AddWithValue("@ResumeId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
public class ApplicationRepository : IRepository<Application>
{
private readonly string _connectionString;
public ApplicationRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Application> GetAll()
{
var applications = new List<Application>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Applications", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
applications.Add(new Application
{
ApplicationId = (int)reader["ApplicationId"],
JobId = (int)reader["JobId"],
JobSeekerId = (int)reader["JobSeekerId"],
ApplicationDate = (DateTime)reader["ApplicationDate"],
Status = reader["Status"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return applications;
}
public Application GetById(int id)
{
Application application = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Applications WHERE ApplicationId = @ApplicationId", connection);
command.Parameters.AddWithValue("@ApplicationId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
application = new Application
{
ApplicationId = (int)reader["ApplicationId"],
JobId = (int)reader["JobId"],
JobSeekerId = (int)reader["JobSeekerId"],
ApplicationDate = (DateTime)reader["ApplicationDate"],
Status = reader["Status"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return application;
}
public void Add(Application application)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Applications (JobId, JobSeekerId, ApplicationDate, Status) VALUES (@JobId, @JobSeekerId, @ApplicationDate, @Status)", connection);
command.Parameters.AddWithValue("@JobId", application.JobId);
command.Parameters.AddWithValue("@JobSeekerId", application.JobSeekerId);
command.Parameters.AddWithValue("@ApplicationDate", application.ApplicationDate);
command.Parameters.AddWithValue("@Status", application.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Application application)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Applications SET JobId = @JobId, JobSeekerId = @JobSeekerId, ApplicationDate = @ApplicationDate, Status = @Status, UpdatedAt = GETDATE() WHERE ApplicationId = @ApplicationId", connection);
command.Parameters.AddWithValue("@ApplicationId", application.ApplicationId);
command.Parameters.AddWithValue("@JobId", application.JobId);
command.Parameters.AddWithValue("@JobSeekerId", application.JobSeekerId);
command.Parameters.AddWithValue("@ApplicationDate", application.ApplicationDate);
command.Parameters.AddWithValue("@Status", application.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Applications WHERE ApplicationId = @ApplicationId", connection);
command.Parameters.AddWithValue("@ApplicationId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
public class CompanyProfileRepository : IRepository<CompanyProfile>
{
private readonly string _connectionString;
public CompanyProfileRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<CompanyProfile> GetAll()
{
var companyProfiles = new List<CompanyProfile>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM CompanyProfiles", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
companyProfiles.Add(new CompanyProfile
{
CompanyId = (int)reader["CompanyId"],
EmployerId = (int)reader["EmployerId"],
CompanyName = reader["CompanyName"].ToString(),
Description = reader["Description"].ToString(),
Website = reader["Website"]?.ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return companyProfiles;
}
public CompanyProfile GetById(int id)
{
CompanyProfile companyProfile = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM CompanyProfiles WHERE CompanyId = @CompanyId", connection);
command.Parameters.AddWithValue("@CompanyId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
companyProfile = new CompanyProfile
{
CompanyId = (int)reader["CompanyId"],
EmployerId = (int)reader["EmployerId"],
CompanyName = reader["CompanyName"].ToString(),
Description = reader["Description"].ToString(),
Website = reader["Website"]?.ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return companyProfile;
}
public void Add(CompanyProfile companyProfile)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO CompanyProfiles (EmployerId, CompanyName, Description, Website) VALUES (@EmployerId, @CompanyName, @Description, @Website)", connection);
command.Parameters.AddWithValue("@EmployerId", companyProfile.EmployerId);
command.Parameters.AddWithValue("@CompanyName", companyProfile.CompanyName);
command.Parameters.AddWithValue("@Description", companyProfile.Description);
command.Parameters.AddWithValue("@Website", companyProfile.Website );
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(CompanyProfile companyProfile)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE CompanyProfiles SET EmployerId = @EmployerId, CompanyName = @CompanyName, Description = @Description, Website = @Website, UpdatedAt = GETDATE() WHERE CompanyId = @CompanyId", connection);
command.Parameters.AddWithValue("@CompanyId", companyProfile.CompanyId);
command.Parameters.AddWithValue("@EmployerId", companyProfile.EmployerId);
command.Parameters.AddWithValue("@CompanyName", companyProfile.CompanyName);
command.Parameters.AddWithValue("@Description", companyProfile.Description);
command.Parameters.AddWithValue("@Website", companyProfile.Website);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM CompanyProfiles WHERE CompanyId = @CompanyId", connection);
command.Parameters.AddWithValue("@CompanyId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
public class NotificationRepository : IRepository<Notification>
{
private readonly string _connectionString;
public NotificationRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Notification> GetAll()
{
var notifications = new List<Notification>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Notifications", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
notifications.Add(new Notification
{
NotificationId = (int)reader["NotificationId"],
UserId = (int)reader["User Id"],
Message = reader["Message"].ToString(),
IsRead = (bool)reader["IsRead"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
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) VALUES (@User Id, @Message)", connection);
command.Parameters.AddWithValue("@User Id", notification.UserId);
command.Parameters.AddWithValue("@Message", notification.Message);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Notification notification)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Notifications SET UserId = @User Id, Message = @Message, IsRead = @IsRead, UpdatedAt = GETDATE() WHERE NotificationId = @NotificationId", connection);
command.Parameters.AddWithValue("@NotificationId", notification.NotificationId);
command.Parameters.AddWithValue("@User Id", notification.UserId);
command.Parameters.AddWithValue("@Message", notification.Message);
command.Parameters.AddWithValue("@IsRead", notification.IsRead);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Notifications WHERE NotificationId = @NotificationId", connection);
command.Parameters.AddWithValue("@NotificationId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
public class 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 Feedbacks", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
feedbacks.Add(new Feedback
{
FeedbackId = (int)reader["FeedbackId"],
UserId = (int)reader["User Id"],
Comments = reader["Comments"].ToString(),
Rating = (int)reader["Rating"],
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 Feedbacks 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"],
Comments = reader["Comments"].ToString(),
Rating = (int)reader["Rating"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return feedback;
}
public void Add(Feedback feedback)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Feedbacks (User Id, Comments, Rating) VALUES (@User Id, @Comments, @Rating)", connection);
command.Parameters.AddWithValue("@User Id", feedback.UserId);
command.Parameters.AddWithValue("@Comments", feedback.Comments);
command.Parameters.AddWithValue("@Rating", feedback.Rating);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Feedback feedback)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Feedbacks SET UserId = @User Id, Comments = @Comments, Rating = @Rating, UpdatedAt = GETDATE() WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@FeedbackId", feedback.FeedbackId);
command.Parameters.AddWithValue("@User Id", feedback.UserId);
command.Parameters.AddWithValue("@Comments", feedback.Comments);
command.Parameters.AddWithValue("@Rating", feedback.Rating);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Feedbacks WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@FeedbackId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
public class SubscriptionPlanRepository : IRepository<SubscriptionPlan>
{
private readonly string _connectionString;
public SubscriptionPlanRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<SubscriptionPlan> GetAll()
{
var plans = new List<SubscriptionPlan>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM SubscriptionPlans", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
plans.Add(new SubscriptionPlan
{
PlanId = (int)reader["PlanId"],
PlanName = reader["PlanName"].ToString(),
Price = (decimal)reader["Price"],
DurationInDays = (int)reader["DurationInDays"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return plans;
}
public SubscriptionPlan GetById(int id)
{
SubscriptionPlan plan = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM SubscriptionPlans WHERE PlanId = @PlanId", connection);
command.Parameters.AddWithValue("@PlanId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
plan = new SubscriptionPlan
{
PlanId = (int)reader["PlanId"],
PlanName = reader["PlanName"].ToString(),
Price = (decimal)reader["Price"],
DurationInDays = (int)reader["DurationInDays"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return plan;
}
public void Add(SubscriptionPlan plan)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO SubscriptionPlans (PlanName, Price, DurationInDays) VALUES (@PlanName, @Price, @DurationInDays)", connection);
command.Parameters.AddWithValue("@PlanName", plan.PlanName);
command.Parameters.AddWithValue("@Price", plan.Price);
command.Parameters.AddWithValue("@DurationInDays", plan.DurationInDays);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(SubscriptionPlan plan)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE SubscriptionPlans SET PlanName = @PlanName, Price = @Price, DurationInDays = @DurationInDays, UpdatedAt = GETDATE() WHERE PlanId = @PlanId", connection);
command.Parameters.AddWithValue("@PlanId", plan.PlanId);
command.Parameters.AddWithValue("@PlanName", plan.PlanName);
command.Parameters.AddWithValue("@Price", plan.Price);
command.Parameters.AddWithValue("@DurationInDays", plan.DurationInDays);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM SubscriptionPlans WHERE PlanId = @PlanId", connection);
command.Parameters.AddWithValue("@PlanId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
public class PaymentRepository : IRepository<Payment>
{
private readonly string _connectionString;
public PaymentRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Payment> GetAll()
{
var payments = new List<Payment>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Payments", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
payments.Add(new Payment
{
PaymentId = (int)reader["PaymentId"],
UserId = (int)reader["User Id"],
PlanId = (int)reader["PlanId"],
Amount = (decimal)reader["Amount"],
PaymentDate = (DateTime)reader["PaymentDate"],
PaymentMethod = reader["PaymentMethod"].ToString(),
Status = reader["Status"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return payments;
}
public Payment GetById(int id)
{
Payment payment = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Payments WHERE PaymentId = @PaymentId", connection);
command.Parameters.AddWithValue("@PaymentId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
payment = new Payment
{
PaymentId = (int)reader["PaymentId"],
UserId = (int)reader["User Id"],
PlanId = (int)reader["PlanId"],
Amount = (decimal)reader["Amount"],
PaymentDate = (DateTime)reader["PaymentDate"],
PaymentMethod = reader["PaymentMethod"].ToString(),
Status = reader["Status"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return payment;
}
public void Add(Payment payment)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Payments (User Id, PlanId, Amount, PaymentDate, PaymentMethod, Status) VALUES (@User Id, @PlanId, @Amount, @PaymentDate, @PaymentMethod, @Status)", connection);
command.Parameters.AddWithValue("@User Id", payment.UserId);
command.Parameters.AddWithValue("@PlanId", payment.PlanId);
command.Parameters.AddWithValue("@Amount", payment.Amount);
command.Parameters.AddWithValue("@PaymentDate", payment.PaymentDate);
command.Parameters.AddWithValue("@PaymentMethod", payment.PaymentMethod);
command.Parameters.AddWithValue("@Status", payment.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Payment payment)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Payments SET UserId = @User Id, PlanId = @PlanId, Amount = @Amount, PaymentDate = @PaymentDate, PaymentMethod = @PaymentMethod, Status = @Status, UpdatedAt = GETDATE() WHERE PaymentId = @PaymentId", connection);
command.Parameters.AddWithValue("@PaymentId", payment.PaymentId);
command.Parameters .AddWithValue("@User Id", payment.UserId);
command.Parameters.AddWithValue("@PlanId", payment.PlanId);
command.Parameters.AddWithValue("@Amount", payment.Amount);
command.Parameters.AddWithValue("@PaymentDate", payment.PaymentDate);
command.Parameters.AddWithValue("@PaymentMethod", payment.PaymentMethod);
command.Parameters.AddWithValue("@Status", payment.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Payments WHERE PaymentId = @PaymentId", connection);
command.Parameters.AddWithValue("@PaymentId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Creating Controllers
To create controllers for each repository in an ASP.NET MVC application, we will follow the standard MVC pattern. Each controller will handle HTTP requests, interact with the corresponding repository, and return views or data as needed.
Below are example controllers for each of the repositories we created earlier. Each controller will include basic CRUD operations (Create, Read, Update, Delete).
UserController
using System.Web.Mvc;
public class UserController : Controller
{
private readonly UserRepository _userRepository;
public UserController()
{
_userRepository = new UserRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var users = _userRepository.GetAll();
return View(users);
}
public ActionResult Details(int id)
{
var user = _userRepository.GetById(id);
return View(user);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(User user)
{
if (ModelState.IsValid)
{
_userRepository.Add(user);
return RedirectToAction("Index");
}
return View(user);
}
public ActionResult Edit(int id)
{
var user = _userRepository.GetById(id);
return View(user);
}
[HttpPost]
public ActionResult Edit(User user)
{
if (ModelState.IsValid)
{
_userRepository.Update(user);
return RedirectToAction("Index");
}
return View(user);
}
public ActionResult Delete(int id)
{
var user = _userRepository.GetById(id);
return View(user);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_userRepository.Delete(id);
return RedirectToAction("Index");
}
}
RoleController
using System.Web.Mvc;
public class RoleController : Controller
{
private readonly RoleRepository _roleRepository;
public RoleController()
{
_roleRepository = new RoleRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var roles = _roleRepository.GetAll();
return View(roles);
}
public ActionResult Details(int id)
{
var role = _roleRepository.GetById(id);
return View(role);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Role role)
{
if (ModelState.IsValid)
{
_roleRepository.Add(role);
return RedirectToAction("Index");
}
return View(role);
}
public ActionResult Edit(int id)
{
var role = _roleRepository.GetById(id);
return View(role);
}
[HttpPost]
public ActionResult Edit(Role role)
{
if (ModelState.IsValid)
{
_roleRepository.Update(role);
return RedirectToAction("Index");
}
return View(role);
}
public ActionResult Delete(int id)
{
var role = _roleRepository.GetById(id);
return View(role);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_roleRepository.Delete(id);
return RedirectToAction("Index");
}
}
JobController
using System.Web.Mvc;
public class JobController : Controller
{
private readonly JobRepository _jobRepository;
public JobController()
{
_jobRepository = new JobRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var jobs = _jobRepository.GetAll();
return View(jobs);
}
public ActionResult Details(int id)
{
var job = _jobRepository.GetById(id);
return View(job);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Job job)
{
if (ModelState.IsValid)
{
_jobRepository.Add(job);
return RedirectToAction("Index");
}
return View(job);
}
public ActionResult Edit(int id)
{
var job = _jobRepository.GetById(id);
return View(job);
}
[HttpPost]
public ActionResult Edit(Job job)
{
if (ModelState.IsValid)
{
_jobRepository.Update(job);
return RedirectToAction("Index");
}
return View(job);
}
public ActionResult Delete(int id)
{
var job = _jobRepository.GetById(id);
return View(job);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_jobRepository.Delete(id);
return RedirectToAction("Index");
}
}
ResumeController
using System.Web.Mvc;
public class ResumeController : Controller
{
private readonly ResumeRepository _resumeRepository;
public ResumeController()
{
_resumeRepository = new ResumeRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var resumes = _resumeRepository.GetAll();
return View(resumes);
}
public ActionResult Details(int id)
{
var resume = _resumeRepository.GetById(id);
return View(resume);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Resume resume)
{
if (ModelState.IsValid)
{
_resumeRepository.Add(resume);
return RedirectToAction("Index");
}
return View(resume);
}
public ActionResult Edit(int id)
{
var resume = _resumeRepository.GetById(id);
return View(resume);
}
[HttpPost]
public ActionResult Edit(Resume resume)
{
if (ModelState.IsValid)
{
_resumeRepository.Update(resume);
return RedirectToAction("Index");
}
return View(resume);
}
public ActionResult Delete(int id)
{
var resume = _resumeRepository.GetById(id);
return View(resume);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_resumeRepository.Delete(id);
return RedirectToAction("Index");
}
}
ApplicationController
using System.Web.Mvc;
public class ApplicationController : Controller
{
private readonly ApplicationRepository _applicationRepository;
public ApplicationController()
{
_applicationRepository = new ApplicationRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var applications = _applicationRepository.GetAll();
return View(applications);
}
public ActionResult Details(int id)
{
var application = _applicationRepository.GetById(id);
return View(application);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Application application)
{
if (ModelState.IsValid)
{
_applicationRepository.Add(application);
return RedirectToAction("Index");
}
return View(application);
}
public ActionResult Edit(int id)
{
var application = _applicationRepository.GetById(id);
return View(application);
}
[HttpPost]
public ActionResult Edit(Application application)
{
if (ModelState.IsValid)
{
_applicationRepository.Update(application);
return RedirectToAction("Index");
}
return View(application);
}
public ActionResult Delete(int id)
{
var application = _applicationRepository.GetById(id);
return View(application);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_applicationRepository.Delete(id);
return RedirectToAction("Index");
}
}
CompanyProfileController
using System.Web.Mvc;
public class CompanyProfileController : Controller
{
private readonly CompanyProfileRepository _companyProfileRepository;
public CompanyProfileController()
{
_companyProfileRepository = new CompanyProfileRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var companyProfiles = _companyProfileRepository.GetAll();
return View(companyProfiles);
}
public ActionResult Details(int id)
{
var companyProfile = _companyProfileRepository.GetById(id);
return View(companyProfile);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(CompanyProfile companyProfile)
{
if (ModelState.IsValid)
{
_companyProfileRepository.Add(companyProfile);
return RedirectToAction("Index");
}
return View(companyProfile);
}
public ActionResult Edit(int id)
{
var companyProfile = _companyProfileRepository.GetById(id);
return View(companyProfile);
}
[HttpPost]
public ActionResult Edit(CompanyProfile companyProfile)
{
if (ModelState.IsValid)
{
_companyProfileRepository.Update(companyProfile);
return RedirectToAction("Index");
}
return View(companyProfile);
}
public ActionResult Delete(int id)
{
var companyProfile = _companyProfileRepository.GetById(id);
return View(companyProfile);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_companyProfileRepository.Delete(id);
return RedirectToAction("Index");
}
}
NotificationController
using System.Web.Mvc;
public class NotificationController : Controller
{
private readonly NotificationRepository _notificationRepository;
public NotificationController()
{
_notificationRepository = new NotificationRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var notifications = _notificationRepository.GetAll();
return View(notifications);
}
public ActionResult Details(int id)
{
var notification = _notificationRepository.GetById(id);
return View(notification);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Notification notification)
{
if (ModelState.IsValid)
{
_notificationRepository.Add(notification);
return RedirectToAction("Index");
}
return View (notification);
}
public ActionResult Edit(int id)
{
var notification = _notificationRepository.GetById(id);
return View(notification);
}
[HttpPost]
public ActionResult Edit(Notification notification)
{
if (ModelState.IsValid)
{
_notificationRepository.Update(notification);
return RedirectToAction("Index");
}
return View(notification);
}
public ActionResult Delete(int id)
{
var notification = _notificationRepository.GetById(id);
return View(notification);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_notificationRepository.Delete(id);
return RedirectToAction("Index");
}
}
FeedbackController
using System.Web.Mvc;
public class FeedbackController : Controller
{
private readonly FeedbackRepository _feedbackRepository;
public FeedbackController()
{
_feedbackRepository = new FeedbackRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var feedbacks = _feedbackRepository.GetAll();
return View(feedbacks);
}
public ActionResult Details(int id)
{
var feedback = _feedbackRepository.GetById(id);
return View(feedback);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Feedback feedback)
{
if (ModelState.IsValid)
{
_feedbackRepository.Add(feedback);
return RedirectToAction("Index");
}
return View(feedback);
}
public ActionResult Edit(int id)
{
var feedback = _feedbackRepository.GetById(id);
return View(feedback);
}
[HttpPost]
public ActionResult Edit(Feedback feedback)
{
if (ModelState.IsValid)
{
_feedbackRepository.Update(feedback);
return RedirectToAction("Index");
}
return View(feedback);
}
public ActionResult Delete(int id)
{
var feedback = _feedbackRepository.GetById(id);
return View(feedback);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_feedbackRepository.Delete(id);
return RedirectToAction("Index");
}
}
SubscriptionPlanController
using System.Web.Mvc;
public class SubscriptionPlanController : Controller
{
private readonly SubscriptionPlanRepository _subscriptionPlanRepository;
public SubscriptionPlanController()
{
_subscriptionPlanRepository = new SubscriptionPlanRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var plans = _subscriptionPlanRepository.GetAll();
return View(plans);
}
public ActionResult Details(int id)
{
var plan = _subscriptionPlanRepository.GetById(id);
return View(plan);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(SubscriptionPlan plan)
{
if (ModelState.IsValid)
{
_subscriptionPlanRepository.Add(plan);
return RedirectToAction("Index");
}
return View(plan);
}
public ActionResult Edit(int id)
{
var plan = _subscriptionPlanRepository.GetById(id);
return View(plan);
}
[HttpPost]
public ActionResult Edit(SubscriptionPlan plan)
{
if (ModelState.IsValid)
{
_subscriptionPlanRepository.Update(plan);
return RedirectToAction("Index");
}
return View(plan);
}
public ActionResult Delete(int id)
{
var plan = _subscriptionPlanRepository.GetById(id);
return View(plan);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_subscriptionPlanRepository.Delete(id);
return RedirectToAction("Index");
}
}
PaymentController
using System.Web.Mvc;
public class PaymentController : Controller
{
private readonly PaymentRepository _paymentRepository;
public PaymentController()
{
_paymentRepository = new PaymentRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var payments = _paymentRepository.GetAll();
return View(payments);
}
public ActionResult Details(int id)
{
var payment = _paymentRepository.GetById(id);
return View(payment);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Payment payment)
{
if (ModelState.IsValid)
{
_paymentRepository.Add(payment);
return RedirectToAction("Index");
}
return View(payment);
}
public ActionResult Edit(int id)
{
var payment = _paymentRepository.GetById(id);
return View(payment);
}
[HttpPost]
public ActionResult Edit(Payment payment)
{
if (ModelState.IsValid)
{
_paymentRepository.Update(payment);
return RedirectToAction("Index");
}
return View(payment);
}
public ActionResult Delete(int id)
{
var payment = _paymentRepository.GetById(id);
return View(payment);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_paymentRepository.Delete(id);
return RedirectToAction("Index");
}
}
These controllers provide a basic structure for handling CRUD operations for each entity in your application. You can further enhance them by adding validation, error handling, and other features as needed.
Creating Views
Creating views for each of the controllers involves creating Razor view files that correspond to the actions in the controllers. Below, I will provide a basic structure for the views for each controller, including the Index, Details, Create, Edit, and Delete views.
User Views
Views/User/Index.cshtml
@model IEnumerable<YourNamespace.Models.User>
@{
ViewBag.Title = "Users";
}
<h2>Users</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.First().Username)
</th>
<th>
@Html.DisplayNameFor(model => model.First().Email)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var user in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => user.Username)</td>
<td>@Html.DisplayFor(modelItem => user.Email)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = user.UserId }) |
@Html.ActionLink("Details", "Details", new { id = user.UserId }) |
@Html.ActionLink("Delete", "Delete", new { id = user.UserId })
</td>
</tr>
}
</tbody>
</table>
Views/User/Details.cshtml
@model YourNamespace.Models.User
@{
ViewBag.Title = "User Details";
}
<h2>User Details</h2>
<div>
<h4>User</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Username)
</dt>
<dd>
@Html.DisplayFor(model => model.Username)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Email)
</dt>
<dd>
@Html.DisplayFor(model => model.Email)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Phone)
</dt>
<dd>
@Html.DisplayFor(model => model.Phone)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.UserId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/User/Create.cshtml
@model YourNamespace.Models.User
@{
ViewBag.Title = "Create User";
}
<h2>Create User</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>User</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Username, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Username, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Username, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Email, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Email, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Email, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.PasswordHash, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.PasswordHash, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.PasswordHash, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/User/Edit.cshtml
@model YourNamespace.Models.User
@{
ViewBag.Title = "Edit User";
}
<h2>Edit User</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>User</h4>
<hr />
@Html.HiddenFor(model => model.UserId)
<div class="form-group">
@Html.LabelFor(model => model.Username, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Username, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Username, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Email, htmlAttributes: new { @class = "control -label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Email, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Email, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/User/Delete.cshtml
@model YourNamespace.Models.User
@{
ViewBag.Title = "Delete User";
}
<h2>Delete User</h2>
<div>
<h4>User</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Username)
</dt>
<dd>
@Html.DisplayFor(model => model.Username)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Email)
</dt>
<dd>
@Html.DisplayFor(model => model.Email)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(model => model.UserId)
<div>
<input type="submit" value="Delete" class="btn btn-danger" /> |
@Html.ActionLink("Back to List", "Index")
</div>
}
Role Views
Views/Role/Index.cshtml
@model IEnumerable<YourNamespace.Models.Role>
@{
ViewBag.Title = "Roles";
}
<h2>Roles</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.First().RoleName)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var role in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => role.RoleName)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = role.RoleId }) |
@Html.ActionLink("Details", "Details", new { id = role.RoleId }) |
@Html.ActionLink("Delete", "Delete", new { id = role.RoleId })
</td>
</tr>
}
</tbody>
</table>
Views/Role/Details.cshtml
@model YourNamespace.Models.Role
@{
ViewBag.Title = "Role Details";
}
<h2>Role Details</h2>
<div>
<h4>Role</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.RoleName)
</dt>
<dd>
@Html.DisplayFor(model => model.RoleName)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.RoleId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/Role/Create.cshtml
@model YourNamespace.Models.Role
@{
ViewBag.Title = "Create Role";
}
<h2>Create Role</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Role</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.RoleName, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.RoleName, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.RoleName, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Role/Edit.cshtml
@model YourNamespace.Models.Role
@{
ViewBag.Title = "Edit Role";
}
<h2>Edit Role</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4> Role</h4>
<hr />
@Html.HiddenFor(model => model.RoleId)
<div class="form-group">
@Html.LabelFor(model => model.RoleName, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.RoleName, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.RoleName, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Role/Delete.cshtml
@model YourNamespace.Models.Role
@{
ViewBag.Title = "Delete Role";
}
<h2>Delete Role</h2>
<div>
<h4>Role</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.RoleName)
</dt>
<dd>
@Html.DisplayFor(model => model.RoleName)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(model => model.RoleId)
<div>
<input type="submit" value="Delete" class="btn btn-danger" /> |
@Html.ActionLink("Back to List", "Index")
</div>
}
Job Views
Views/Job/Index.cshtml
@model IEnumerable<YourNamespace.Models.Job>
@{
ViewBag.Title = "Jobs";
}
<h2>Jobs</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.First().JobTitle)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var job in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => job.JobTitle)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = job.JobId }) |
@Html.ActionLink("Details", "Details", new { id = job.JobId }) |
@Html.ActionLink("Delete", "Delete", new { id = job.JobId })
</td>
</tr>
}
</tbody>
</table>
Views/Job/Details.cshtml
@model YourNamespace.Models.Job
@{
ViewBag.Title = "Job Details";
}
<h2>Job Details</h2>
<div>
<h4>Job</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.JobTitle)
</dt>
<dd>
@Html.DisplayFor(model => model.JobTitle)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Description)
</dt>
<dd>
@Html.DisplayFor(model => model.Description)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.JobId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/Job/Create.cshtml
@model YourNamespace.Models.Job
@{
ViewBag.Title = "Create Job";
}
<h2>Create Job</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Job</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.JobTitle, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.JobTitle, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.JobTitle, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Description, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Description, new { htmlAttributes = new { @class = "form-control " } })
@Html.ValidationMessageFor(model => model.Description, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Job/Edit.cshtml
@model YourNamespace.Models.Job
@{
ViewBag.Title = "Edit Job";
}
<h2>Edit Job</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Job</h4>
<hr />
@Html.HiddenFor(model => model.JobId)
<div class="form-group">
@Html.LabelFor(model => model.JobTitle, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.JobTitle, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.JobTitle, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Description, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Description, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Description, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Job/Delete.cshtml
@model YourNamespace.Models.Job
@{
ViewBag.Title = "Delete Job";
}
<h2>Delete Job</h2>
<div>
<h4>Job</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.JobTitle)
</dt>
<dd>
@Html.DisplayFor(model => model.JobTitle)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Description)
</dt>
<dd>
@Html.DisplayFor(model => model.Description)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(model => model.JobId)
<div>
<input type="submit" value="Delete" class="btn btn-danger" /> |
@Html.ActionLink("Back to List", "Index")
</div>
}
Resume Views
Views/Resume/Index.cshtml
@model IEnumerable<YourNamespace.Models.Resume>
@{
ViewBag.Title = "Resumes";
}
<h2>Resumes</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.First().ResumeTitle)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var resume in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => resume.ResumeTitle)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = resume.ResumeId }) |
@Html.ActionLink("Details", "Details", new { id = resume.ResumeId }) |
@Html.ActionLink("Delete", "Delete", new { id = resume.ResumeId })
</td>
</tr>
}
</tbody>
</table>
Views/Resume/Details.cshtml
@model YourNamespace.Models.Resume
@{
ViewBag.Title = "Resume Details";
}
<h2>Resume Details</h2>
<div>
<h4>Resume</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.ResumeTitle)
</dt>
<dd>
@Html.DisplayFor(model => model.ResumeTitle)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Content)
</dt>
<dd>
@Html.DisplayFor(model => model.Content)
</dd </dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.ResumeId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/Resume/Create.cshtml
@model YourNamespace.Models.Resume
@{
ViewBag.Title = "Create Resume";
}
<h2>Create Resume</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Resume</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.ResumeTitle, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.ResumeTitle, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.ResumeTitle, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Content, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Content, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Content, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Resume/Edit.cshtml
@model YourNamespace.Models.Resume
@{
ViewBag.Title = "Edit Resume";
}
<h2>Edit Resume</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Resume</h4>
<hr />
@Html.HiddenFor(model => model.ResumeId)
<div class="form-group">
@Html.LabelFor(model => model.ResumeTitle, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.ResumeTitle, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.ResumeTitle, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Content, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Content, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Content, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Resume/Delete.cshtml
@model YourNamespace.Models.Resume
@{
ViewBag.Title = "Delete Resume";
}
<h2>Delete Resume</h2>
<div>
<h4>Resume</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.ResumeTitle)
</dt>
<dd>
@Html.DisplayFor(model => model.ResumeTitle)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Content)
</dt>
<dd>
@Html.DisplayFor(model => model.Content)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(model => model.ResumeId)
<div>
<input type="submit" value="Delete" class="btn btn-danger" /> |
@Html.ActionLink("Back to List", "Index")
</div>
}
Application Views
Views/Application/Index.cshtml
@model IEnumerable<YourNamespace.Models.Application>
@{
ViewBag.Title = "Applications";
}
<h2>Applications</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.First().ApplicationTitle)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var application in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => application.ApplicationTitle)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = application.ApplicationId }) |
@Html.ActionLink("Details", "Details", new { id = application.ApplicationId }) |
@Html.ActionLink("Delete", "Delete", new { id = application.ApplicationId })
</td>
</tr>
}
</tbody>
</table>
Views/Application/Details.cshtml
@model YourNamespace.Models.Application
@{
ViewBag.Title = "Application Details";
}
<h2>Application Details</h2>
<div>
<h4>Application</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.ApplicationTitle)
</dt>
<dd>
@Html.DisplayFor(model => model.ApplicationTitle)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Description)
</dt>
<dd>
@Html.DisplayFor(model => model.Description)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.ApplicationId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/Application/Create.cshtml
@model YourNamespace.Models.Application
@{
ViewBag.Title = "Create Application";
}
<h2>Create Application</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Application</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.ApplicationTitle, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.ApplicationTitle, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.ApplicationTitle, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Description, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Description, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Description, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Application/Edit.cshtml
@model YourNamespace.Models.Application
@{
ViewBag.Title = "Edit Application";
}
<h2>Edit Application</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Application</h4>
<hr />
@Html.HiddenFor(model => model.ApplicationId)
<div class="form-group">
@Html.LabelFor(model => model.ApplicationTitle, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.ApplicationTitle, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.ApplicationTitle, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Description, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Description, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Description, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Application/Delete.cshtml
@model YourNamespace.Models.Application
@{
ViewBag.Title = "Delete Application";
}
<h2>Delete Application</h2>
<div>
<h4>Application</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.ApplicationTitle)
</dt>
<dd>
@Html.DisplayFor(model => model.ApplicationTitle)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Description)
</dt>
<dd>
@Html.DisplayFor(model => model.Description)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(model => model.ApplicationId)
<div>
<input type="submit" value="Delete" class="btn btn-danger" /> |
@Html.ActionLink("Back to List", "Index")
</div>
}
CompanyProfile Views
Views/CompanyProfile/Index.cshtml
@model IEnumerable<YourNamespace.Models.CompanyProfile>
@{
ViewBag.Title = "Company Profiles";
}
<h2>Company Profiles</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.First().CompanyName)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var companyProfile in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => companyProfile.CompanyName)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = companyProfile.CompanyProfileId }) |
@Html.ActionLink("Details", "Details", new { id = companyProfile.CompanyProfileId }) |
@Html.ActionLink("Delete", "Delete", new { id = companyProfile.CompanyProfileId })
</td>
</tr>
}
</tbody>
</table>
Views/CompanyProfile/Details.cshtml
@model YourNamespace.Models.CompanyProfile
@{
ViewBag.Title = "Company Profile Details";
}
<h2>Company Profile Details</h2>
<div>
<h4>Company Profile</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.CompanyName)
</dt>
<dd>
@Html.DisplayFor(model => model.CompanyName)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Description)
</dt>
<dd>
@Html.DisplayFor(model => model.Description)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.CompanyProfileId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/CompanyProfile/Create.cshtml
@model YourNamespace.Models.CompanyProfile
@{
ViewBag.Title = "Create Company Profile";
}
<h2>Create Company Profile</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Company Profile</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.CompanyName, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.CompanyName, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.CompanyName, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Description, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Description, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Description, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/CompanyProfile/Edit.cshtml
@model YourNamespace.Models.CompanyProfile
@{
ViewBag.Title = "Edit Company Profile";
}
<h2>Edit Company Profile</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Company Profile</h4>
<hr />
@Html.HiddenFor(model => model.CompanyProfileId)
<div class="form-group">
@Html.LabelFor(model => model.CompanyName, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.CompanyName, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.CompanyName, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Description, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Description, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Description, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/CompanyProfile/Delete.cshtml
@model YourNamespace.Models.CompanyProfile
@{
ViewBag.Title = "Delete Company Profile";
}
<h2>Delete Company Profile</h2>
<div>
<h4>Company Profile</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.CompanyName)
</dt>
<dd>
@Html.DisplayFor(model => model.CompanyName)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Description)
</dt>
<dd>
@Html.DisplayFor(model => model.Description)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(model => model.CompanyProfileId)
<div>
<input type="submit" value="Delete" class="btn btn-danger" /> |
@Html.ActionLink("Back to List", "Index")
</div>
}
Notification Views
Views/Notification/Index.cshtml
@model IEnumerable<YourNamespace.Models.Notification>
@{
ViewBag.Title = "Notifications";
}
<h2>Notifications</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.First().Message)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var notification in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => notification.Message)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = notification.NotificationId }) |
@Html.ActionLink("Details", "Details", new { id = notification.NotificationId }) |
@Html.ActionLink("Delete", "Delete", new { id = notification.NotificationId })
</td>
</tr>
}
</tbody>
</table>
Views/Notification/Details.cshtml
@model YourNamespace.Models.Notification
@{
ViewBag.Title = "Notification Details";
}
<h2>Notification Details</h2>
<div>
<h4>Notification</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Message)
</dt>
<dd>
@Html.DisplayFor(model => model.Message)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.NotificationId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/Notification/Create.cshtml
@model YourNamespace.Models.Notification
@{
ViewBag.Title = "Create Notification";
}
<h2>Create Notification</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Notification</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Message, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Message, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Message, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Notification/Edit.cshtml
@model YourNamespace.Models.Notification
@{
ViewBag.Title = "Edit Notification";
}
<h2>Edit Notification</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Notification</h4>
<hr />
@Html.HiddenFor(model => model.NotificationId)
<div class="form-group">
@Html.LabelFor(model => model.Message, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Message, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Message, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Notification/Delete.cshtml
@model YourNamespace.Models.Notification
@{
ViewBag.Title = "Delete Notification";
}
<h2>Delete Notification</h2>
<div>
<h4>Notification</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Message)
</dt>
<dd>
@Html.DisplayFor(model => model.Message)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(model => model.NotificationId)
<div>
<input type="submit" value="Delete" class="btn btn-danger" /> |
@Html.ActionLink("Back to List", "Index")
</div>
}
Feedback Views
Views/Feedback/Index.cshtml
@model IEnumerable<YourNamespace.Models.Feedback>
@{
ViewBag.Title = "Feedbacks";
}
<h2>Feedbacks</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.First().Comment)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var feedback in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => feedback.Comment)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = feedback.FeedbackId }) |
@Html.ActionLink("Details", "Details", new { id = feedback.FeedbackId }) |
@Html.ActionLink("Delete", "Delete", new { id = feedback.FeedbackId })
</td>
</tr>
}
</tbody>
</table>
Views/Feedback/Details.cshtml
@model YourNamespace.Models.Feedback
@{
ViewBag.Title = "Feedback Details";
}
<h2>Feedback Details</h2>
<div>
<h4>Feedback</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Comment)
</dt>
<dd>
@Html.DisplayFor(model => model.Comment)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.FeedbackId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/Feedback/Create.cshtml
@model YourNamespace.Models.Feedback
@{
ViewBag.Title = "Create Feedback";
}
<h2>Create Feedback</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Feedback</h4>
<hr />
<div class="form-group">
@Html .LabelFor(model => model.Comment, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Comment, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Comment, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Feedback/Edit.cshtml
@model YourNamespace.Models.Feedback
@{
ViewBag.Title = "Edit Feedback";
}
<h2>Edit Feedback</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Feedback</h4>
<hr />
@Html.HiddenFor(model => model.FeedbackId)
<div class="form-group">
@Html.LabelFor(model => model.Comment, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Comment, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Comment, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Feedback/Delete.cshtml
@model YourNamespace.Models.Feedback
@{
ViewBag.Title = "Delete Feedback";
}
<h2>Delete Feedback</h2>
<div>
<h4>Feedback</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Comment)
</dt>
<dd>
@Html.DisplayFor(model => model.Comment)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(model => model.FeedbackId)
<div>
<input type="submit" value="Delete" class="btn btn-danger" /> |
@Html.ActionLink("Back to List", "Index")
</div>
}
SubscriptionPlan Views
Views/SubscriptionPlan/Index.cshtml
@model IEnumerable<YourNamespace.Models.SubscriptionPlan>
@{
ViewBag.Title = "Subscription Plans";
}
<h2>Subscription Plans</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.First().PlanName)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var plan in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => plan.PlanName)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = plan.SubscriptionPlanId }) |
@Html.ActionLink("Details", "Details", new { id = plan.SubscriptionPlanId }) |
@Html.ActionLink("Delete", "Delete", new { id = plan.SubscriptionPlanId })
</td>
</tr>
}
</tbody>
</table>
Views/SubscriptionPlan/Details.cshtml
@model YourNamespace.Models.SubscriptionPlan
@{
ViewBag.Title = "Subscription Plan Details";
}
<h2>Subscription Plan Details</h2>
<div>
<h4>Subscription Plan</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.PlanName)
</dt>
<dd>
@Html.DisplayFor(model => model.PlanName)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Price)
</dt>
<dd>
@Html.DisplayFor(model => model.Price)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.SubscriptionPlanId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/SubscriptionPlan/Create.cshtml
@model YourNamespace.Models.SubscriptionPlan
@{
ViewBag.Title = "Create Subscription Plan";
}
<h2>Create Subscription Plan</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Subscription Plan</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.PlanName, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.PlanName, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.PlanName, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Price, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Price, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Price, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/SubscriptionPlan/Edit.cshtml
@model YourNamespace.Models.SubscriptionPlan
@{
ViewBag.Title = "Edit Subscription Plan";
}
<h2>Edit Subscription Plan</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Subscription Plan</h4>
<hr />
@Html.HiddenFor(model => model.SubscriptionPlanId)
<div class="form-group">
@Html.LabelFor(model => model.PlanName, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.PlanName, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.PlanName, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Price, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Price, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Price, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/SubscriptionPlan/Delete.cshtml
@model YourNamespace.Models.SubscriptionPlan
@{
ViewBag.Title = "Delete Subscription Plan";
}
<h2>Delete Subscription Plan</h2>
<div>
<h4>Subscription Plan</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.PlanName)
</dt>
<dd>
@Html.DisplayFor(model => model.PlanName)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Price)
</dt>
<dd>
@Html.DisplayFor(model => model.Price)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(model => model.SubscriptionPlanId)
<div>
<input type="submit" value="Delete" class="btn btn-danger" /> |
@Html.ActionLink("Back to List", "Index")
</div>
}
Payment Views
Views/Payment/Index.cshtml
@model IEnumerable<YourNamespace.Models.Payment>
@{
ViewBag.Title = "Payments";
}
<h2>Payments</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.First().Amount)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var payment in Model)
{
<tr>
<td>@Html.DisplayFor(modelItem => payment.Amount)</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = payment.PaymentId }) |
@Html.ActionLink("Details", "Details", new { id = payment.PaymentId }) |
@Html.ActionLink("Delete", "Delete", new { id = payment.PaymentId })
</td>
</tr>
}
</tbody>
</table>
Views/Payment/Details.cshtml
@model YourNamespace.Models.Payment
@{
ViewBag.Title = "Payment Details";
}
<h2>Payment Details</h2>
<div>
<h4>Payment</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Amount)
</dt>
<dd>
@Html.DisplayFor(model => model.Amount)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Date)
</dt>
<dd>
@Html.DisplayFor(model => model.Date)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.PaymentId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/Payment/Create.cshtml
@model YourNamespace.Models.Payment
@{
ViewBag.Title = "Create Payment";
}
<h2>Create Payment</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Payment</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Amount, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Amount, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Amount, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Date, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Date, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Date, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Payment/Edit.cshtml
@model YourNamespace.Models.Payment
@{
ViewBag.Title = "Edit Payment";
}
<h2>Edit Payment</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Payment</h4>
<hr />
@Html.HiddenFor(model => model.PaymentId)
<div class="form-group">
@Html.LabelFor(model => model.Amount, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Amount, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Amount, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Date, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Date, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Date, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Payment/Delete.cshtml
@model YourNamespace.Models.Payment
@{
ViewBag.Title = "Delete Payment";
}
<h2>Delete Payment</h2>
<div>
<h4>Payment</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Amount)
</dt>
<dd>
@Html.DisplayFor(model => model.Amount)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Date)
</dt>
<dd>
@Html.DisplayFor(model => model.Date)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
@Html.HiddenFor(model => model.PaymentId)
<div>
<input type="submit" value="Delete" class="btn btn-danger" /> |
@Html.ActionLink("Back to List", "Index")
</div>
}
These views provide a basic structure for handling CRUD operations for each entity in your application. You can further enhance them by adding validation, error handling, and other features as needed.
Creating a Dashboard Page
Creating a dashboard page in an ASP.NET MVC application involves aggregating data from various models and displaying it in a user-friendly format. Below, I will outline how to create a simple dashboard that consolidates data from the Users, Jobs, Applications, CompanyProfiles, Notifications, Feedbacks, SubscriptionPlans, and Payments models.
Step 1: Create a Dashboard ViewModel
First, we need to create a ViewModel that will hold the consolidated data for the dashboard.
Models/DashboardViewModel.cs
public class DashboardViewModel
{
public int TotalUsers { get; set; }
public int TotalJobs { get; set; }
public int TotalApplications { get; set; }
public int TotalCompanyProfiles { get; set; }
public int TotalNotifications { get; set; }
public int TotalFeedbacks { get; set; }
public int TotalSubscriptionPlans { get; set; }
public decimal TotalPayments { get; set; }
}
Step 2: Create a Dashboard Controller
Next, we will create a controller that will fetch the necessary data and pass it to the dashboard view.
Controllers/DashboardController.cs
using System.Web.Mvc;
using YourNamespace.Models; // Adjust the namespace accordingly
public class DashboardController : Controller
{
private readonly UserRepository _userRepository;
private readonly JobRepository _jobRepository;
private readonly ApplicationRepository _applicationRepository;
private readonly CompanyProfileRepository _companyProfileRepository;
private readonly NotificationRepository _notificationRepository;
private readonly FeedbackRepository _feedbackRepository;
private readonly SubscriptionPlanRepository _subscriptionPlanRepository;
private readonly PaymentRepository _paymentRepository;
public DashboardController()
{
_userRepository = new UserRepository("YourConnectionStringHere");
_jobRepository = new JobRepository("YourConnectionStringHere");
_applicationRepository = new ApplicationRepository("YourConnectionStringHere");
_companyProfileRepository = new CompanyProfileRepository("YourConnectionStringHere");
_notificationRepository = new NotificationRepository("YourConnectionStringHere");
_feedbackRepository = new FeedbackRepository("YourConnectionStringHere");
_subscriptionPlanRepository = new SubscriptionPlanRepository("YourConnectionStringHere");
_paymentRepository = new PaymentRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var dashboardViewModel = new DashboardViewModel
{
TotalUsers = _userRepository.GetAll().Count(),
TotalJobs = _jobRepository.GetAll().Count(),
TotalApplications = _applicationRepository.GetAll().Count(),
TotalCompanyProfiles = _companyProfileRepository.GetAll().Count(),
TotalNotifications = _notificationRepository.GetAll().Count(),
TotalFeedbacks = _feedbackRepository.GetAll().Count(),
TotalSubscriptionPlans = _subscriptionPlanRepository.GetAll().Count(),
TotalPayments = _paymentRepository.GetAll().Sum(p => p.Amount)
};
return View(dashboardViewModel);
}
}
Step 3: Create the Dashboard View
Now, we will create a view to display the dashboard data.
Views/Dashboard/Index.cshtml
@model YourNamespace.Models.DashboardViewModel
@{
ViewBag.Title = "Dashboard";
}
<h2>Dashboard</h2>
<div class="row">
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Total Users</div>
<div class="panel-body">
<h3>@Model.TotalUsers</h3>
</div>
</div>
</div>
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Total Jobs</div>
<div class="panel-body">
<h3>@Model.TotalJobs</h3>
</div>
</div>
</div>
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Total Applications</div>
<div class="panel-body">
<h3>@Model.TotalApplications</h3>
</div>
</div>
</div>
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Total Company Profiles</div>
<div class="panel-body">
<h3>@Model.TotalCompanyProfiles</h3>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Total Notifications</div>
<div class="panel-body">
<h3>@Model.TotalNotifications</h3>
</div>
</div>
</div>
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Total Feedbacks</div>
<div class="panel-body">
<h3>@Model.TotalFeedbacks</h3>
</div>
</div>
</div>
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Total Subscription Plans</div>
<div class="panel-body">
<h3>@Model.TotalSubscriptionPlans</h3>
</div>
</div>
</div>
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Total Payments</div>
<div class="panel-body">
<h3>@Model.TotalPayments.ToString("C")</h3>
</div>
</div>
</div>
</div>
Step 4: Update the Route Configuration
Ensure that the dashboard route is accessible by updating your route configuration if necessary.
RouteConfig.cs
public class RouteConfig
{
public static void RegisterRoutes(RouteCollection routes)
{
routes.IgnoreRoute("{resource}.axd/{*pathInfo}");
routes.MapRoute(
name: "Dashboard",
url: "Dashboard",
defaults: new { controller = "Dashboard", action = "Index" }
);
routes.MapRoute(
name: "Default",
url: "{controller}/{action}/{id}",
defaults: new { controller = "Home", action = "Index", id = UrlParameter.Optional }
);
}
}
Step 5: Access the Dashboard
You can now access the dashboard by navigating to /Dashboard in your web application. The dashboard will display consolidated data related to users, jobs, applications, company profiles, notifications, feedbacks, subscription plans, and payments.
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