Project Introduction
The Bus Reservation System is designed to facilitate the management of bus schedules, bookings, and user interactions. Built using ASP.NET and SQL Server, this system aims to provide a seamless experience for users looking to book bus tickets, manage their bookings, and provide feedback. The application will streamline operations for bus operators and enhance the overall travel experience for passengers.
Project Objectives
- To create a user-friendly interface for users to register, log in, and manage their bookings.
- To implement a secure authentication system for users with different roles (e.g., admin, user).
- To manage bus schedules, routes, and capacities effectively.
- To enable users to book tickets, view their booking history, and make payments.
- To collect user feedback and generate reports for service improvement.
- To send notifications to users regarding their bookings and system updates.
Project Modules
- User Management Module: Handles user registration, login, and role management.
- Bus Management Module: Manages bus details, including bus numbers, capacities, and types.
- Route Management Module: Facilitates the creation and management of bus routes.
- Schedule Management Module: Manages bus schedules, including departure and arrival times.
- Booking Management Module: Allows users to book tickets and manage their bookings.
- Payment Management Module: Handles payment processing for bookings.
- Ticket Management Module: Manages ticket details, including seat assignments.
- Feedback Module: Collects user feedback for service improvement.
- Reporting Module: Generates reports on bookings, feedback, and user activity.
- Notification Module: Sends notifications to users regarding their bookings and updates.
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
);
-- Buses Table
CREATE TABLE Buses (
BusId INT PRIMARY KEY IDENTITY(1,1),
BusNumber NVARCHAR(20) NOT NULL UNIQUE,
Capacity INT NOT NULL,
Type NVARCHAR(50),
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE()
);
-- Routes Table
CREATE TABLE Routes (
RouteId INT PRIMARY KEY IDENTITY(1,1),
StartLocation NVARCHAR(100) NOT NULL,
EndLocation NVARCHAR(100) NOT NULL,
Distance DECIMAL(10, 2),
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE()
);
-- Schedules Table
CREATE TABLE Schedules (
ScheduleId INT PRIMARY KEY IDENTITY(1,1),
BusId INT,
RouteId INT,
DepartureTime DATETIME NOT NULL,
ArrivalTime DATETIME NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (BusId) REFERENCES Buses(BusId),
FOREIGN KEY (RouteId) REFERENCES Routes(RouteId)
);
-- Bookings Table
CREATE TABLE Bookings (
BookingId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
ScheduleId INT,
BookingDate DATETIME DEFAULT GETDATE(),
TotalAmount DECIMAL(10, 2),
Status NVARCHAR(20) DEFAULT 'Pending',
FOREIGN KEY (User Id) REFERENCES Users(UserId),
FOREIGN KEY (ScheduleId) REFERENCES Schedules(ScheduleId)
);
-- Payments Table
CREATE TABLE Payments (
PaymentId INT PRIMARY KEY IDENTITY(1,1),
BookingId INT,
PaymentDate DATETIME DEFAULT GETDATE(),
Amount DECIMAL(10, 2),
PaymentMethod NVARCHAR(50),
Status NVARCHAR(20) DEFAULT 'Pending',
FOREIGN KEY (BookingId) REFERENCES Bookings(BookingId)
);
-- Tickets Table
CREATE TABLE Tickets (
TicketId INT PRIMARY KEY IDENTITY(1,1),
BookingId INT,
SeatNumber NVARCHAR(10),
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (BookingId) REFERENCES Bookings(BookingId)
);
-- Feedback Table
CREATE TABLE Feedbacks (
FeedbackId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
FeedbackText NVARCHAR(MAX),
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- Reports Table
CREATE TABLE Reports (
ReportId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
ReportText NVARCHAR(MAX),
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) 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)
);
Explanation of Tables
Users: Stores user information, including their role.
Roles: Defines different roles (e.g., Admin, User) in the system.
Buses: Contains details about the buses available for booking.
Routes: Defines the routes that buses will take, including start and end locations.
Schedules: Links buses to routes and defines their departure and arrival times.
Bookings: Records user bookings for specific schedules.
Payments: Tracks payment information related to bookings.
Tickets: Stores ticket information for each booking, including seat numbers.
Feedbacks: Allows users to provide feedback on their experience.
Reports: Enables users to report issues or concerns.
Notifications: Manages notifications sent to users.
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 Model Classes
Here are the model classes for each table:
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 Bus
{
public int BusId { get; set; }
public string BusNumber { get; set; }
public int Capacity { get; set; }
public string Type { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Route
{
public int RouteId { get; set; }
public string StartLocation { get; set; }
public string EndLocation { get; set; }
public decimal Distance { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Schedule
{
public int ScheduleId { get; set; }
public int BusId { get; set; }
public int RouteId { get; set; }
public DateTime DepartureTime { get; set; }
public DateTime ArrivalTime { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Booking
{
public int BookingId { get; set; }
public int UserId { get; set; }
public int ScheduleId { get; set; }
public DateTime BookingDate { get; set; }
public decimal TotalAmount { get; set; }
public string Status { get; set; }
}
public class Payment
{
public int PaymentId { get; set; }
public int BookingId { get; set; }
public DateTime PaymentDate { get; set; }
public decimal Amount { get; set; }
public string PaymentMethod { get; set; }
public string Status { get; set; }
}
public class Ticket
{
public int TicketId { get; set; }
public int BookingId { get; set; }
public string SeatNumber { get; set; }
public DateTime CreatedAt { get; set; }
}
public class Feedback
{
public int FeedbackId { get; set; }
public int UserId { get; set; }
public string FeedbackText { get; set; }
public DateTime CreatedAt { get; set; }
}
public class Report
{
public int ReportId { get; set; }
public int UserId { get; set; }
public string ReportText { get; set; }
public DateTime CreatedAt { get; set; }
}
public class Notification
{
public int NotificationId { get; set; }
public int UserId { get; set; }
public string Message { get; set; }
public bool IsRead { get; set; }
public DateTime CreatedAt { get; set; }
}
Step 2: Create Repository Interfaces
Define interfaces for each repository:
public interface IUserRepository
{
User GetUser ById(int userId);
IEnumerable<User> GetAllUsers();
void AddUser (User user);
void UpdateUser (User user);
void DeleteUser (int userId);
}
public interface IRoleRepository
{
Role GetRoleById(int roleId);
IEnumerable<Role> GetAllRoles();
void AddRole(Role role);
void UpdateRole(Role role);
void DeleteRole(int roleId);
}
// Repeat for other entities (Bus, Route, Schedule, Booking, Payment, Ticket, Feedback, Report, Notification)
Step 3: Implement Repository Classes
Here is an example implementation for the User Repository using ADO.NET:
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
public class UserRepository : IUserRepository
{
private readonly string _connectionString;
public UserRepository(string connectionString)
{
_connectionString = connectionString;
}
public User Get User ById(int userId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Users WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", userId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new User
{
UserId = (int)reader["User Id"],
Username = reader["Username"].ToString(),
PasswordHash = reader["PasswordHash"].ToString(),
Email = reader["Email"].ToString(),
Phone = reader["Phone"]?.ToString(),
RoleId = reader["RoleId"] as int?,
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<User> GetAllUsers()
{
var users = new List<User>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Users", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
users.Add(new User
{
UserId = (int)reader["User Id"],
Username = reader["Username"].ToString(),
PasswordHash = reader["PasswordHash"].ToString(),
Email = reader["Email"].ToString(),
Phone = reader["Phone"]?.ToString(),
RoleId = reader["RoleId"] as int?,
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return users;
}
public void AddUser (User user)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Users (Username, PasswordHash, Email, Phone, RoleId) VALUES (@Username, @PasswordHash, @Email, @Phone, @RoleId)", connection);
command.Parameters.AddWithValue("@Username", user.Username);
command.Parameters.AddWithValue("@PasswordHash", user.PasswordHash);
command.Parameters.AddWithValue("@Email", user.Email);
command.Parameters.AddWithValue("@Phone", (object)user.Phone ?? DBNull.Value);
command.Parameters.AddWithValue("@RoleId", (object)user.RoleId ?? DBNull.Value);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateUser (User user)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Users SET Username = @Username, PasswordHash = @PasswordHash, Email = @Email, Phone = @Phone, RoleId = @RoleId, UpdatedAt = GETDATE() WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", user.UserId);
command.Parameters.AddWithValue("@Username", user.Username);
command.Parameters.AddWithValue("@PasswordHash", user.PasswordHash);
command.Parameters.AddWithValue("@Email", user.Email);
command.Parameters.AddWithValue("@Phone", (object)user.Phone ?? DBNull.Value);
command.Parameters.AddWithValue("@RoleId", (object)user.RoleId ?? DBNull.Value);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteUser (int userId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Users WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", userId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
// Repeat similar implementations for other repositories (RoleRepository, BusRepository, etc.)
public class RoleRepository : IRoleRepository
{
private readonly string _connectionString;
public RoleRepository(string connectionString)
{
_connectionString = connectionString;
}
public Role GetRoleById(int roleId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Roles WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", roleId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Role
{
RoleId = (int)reader["RoleId"],
RoleName = reader["RoleName"].ToString()
};
}
}
}
return null;
}
public IEnumerable<Role> GetAllRoles()
{
var roles = new List<Role>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Roles", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
roles.Add(new Role
{
RoleId = (int)reader["RoleId"],
RoleName = reader["RoleName"].ToString()
});
}
}
}
return roles;
}
public void AddRole(Role role)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Roles (RoleName) VALUES (@RoleName)", connection);
command.Parameters.AddWithValue("@RoleName", role.RoleName);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateRole(Role role)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Roles SET RoleName = @RoleName WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", role.RoleId);
command.Parameters.AddWithValue("@RoleName", role.RoleName);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteRole(int roleId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Roles WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", roleId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
// Implement similar repository classes for Bus, Route, Schedule, Booking, Payment, Ticket, Feedback, Report, and Notification.
public class BusRepository : IBusRepository
{
private readonly string _connectionString;
public BusRepository(string connectionString)
{
_connectionString = connectionString;
}
public Bus GetBusById(int busId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Buses WHERE BusId = @BusId", connection);
command.Parameters.AddWithValue("@BusId", busId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Bus
{
BusId = (int)reader["BusId"],
BusNumber = reader["BusNumber"].ToString(),
Capacity = (int)reader["Capacity"],
Type = reader["Type"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Bus> GetAllBuses()
{
var buses = new List<Bus>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Buses", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
buses.Add(new Bus
{
BusId = (int)reader["BusId"],
BusNumber = reader["BusNumber"].ToString(),
Capacity = (int)reader["Capacity"],
Type = reader["Type"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return buses;
}
public void AddBus(Bus bus)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Buses (BusNumber, Capacity, Type) VALUES (@BusNumber, @Capacity, @Type)", connection);
command.Parameters.AddWithValue("@BusNumber", bus.BusNumber);
command.Parameters.AddWithValue("@Capacity", bus.Capacity);
command.Parameters.AddWithValue("@Type", bus.Type);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateBus(Bus bus)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Buses SET BusNumber = @BusNumber, Capacity = @Capacity, Type = @Type, UpdatedAt = GETDATE() WHERE BusId = @BusId", connection);
command.Parameters.AddWithValue("@BusId", bus.BusId);
command.Parameters.AddWithValue("@BusNumber", bus.BusNumber);
command.Parameters.AddWithValue("@Capacity", bus.Capacity);
command.Parameters.AddWithValue("@Type", bus.Type);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteBus(int busId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Buses WHERE BusId = @BusId", connection);
command.Parameters.AddWithValue("@BusId", busId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
// Implement similar repository classes for Route, Schedule, Booking, Payment, Ticket, Feedback, Report, and Notification.
public class RouteRepository : IRouteRepository
{
private readonly string _connectionString;
public RouteRepository(string connectionString)
{
_connectionString = connectionString;
}
public Route GetRouteById(int routeId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Routes WHERE RouteId = @RouteId", connection);
command.Parameters.AddWithValue("@RouteId", routeId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Route
{
RouteId = (int)reader["RouteId"],
StartLocation = reader["StartLocation"].ToString(),
EndLocation = reader["EndLocation"].ToString(),
Distance = (decimal)reader["Distance"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Route> GetAllRoutes()
{
var routes = new List<Route>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Routes", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while ( reader.Read())
{
routes.Add(new Route
{
RouteId = (int)reader["RouteId"],
StartLocation = reader["StartLocation"].ToString(),
EndLocation = reader["EndLocation"].ToString(),
Distance = (decimal)reader["Distance"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return routes;
}
public void AddRoute(Route route)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Routes (StartLocation, EndLocation, Distance) VALUES (@StartLocation, @EndLocation, @Distance)", connection);
command.Parameters.AddWithValue("@StartLocation", route.StartLocation);
command.Parameters.AddWithValue("@EndLocation", route.EndLocation);
command.Parameters.AddWithValue("@Distance", route.Distance);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateRoute(Route route)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Routes SET StartLocation = @StartLocation, EndLocation = @EndLocation, Distance = @Distance, UpdatedAt = GETDATE() WHERE RouteId = @RouteId", connection);
command.Parameters.AddWithValue("@RouteId", route.RouteId);
command.Parameters.AddWithValue("@StartLocation", route.StartLocation);
command.Parameters.AddWithValue("@EndLocation", route.EndLocation);
command.Parameters.AddWithValue("@Distance", route.Distance);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteRoute(int routeId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Routes WHERE RouteId = @RouteId", connection);
command.Parameters.AddWithValue("@RouteId", routeId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
// Implement similar repository classes for Schedule, Booking, Payment, Ticket, Feedback, Report, and Notification.
public class ScheduleRepository : IScheduleRepository
{
private readonly string _connectionString;
public ScheduleRepository(string connectionString)
{
_connectionString = connectionString;
}
public Schedule GetScheduleById(int scheduleId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Schedules WHERE ScheduleId = @ScheduleId", connection);
command.Parameters.AddWithValue("@ScheduleId", scheduleId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Schedule
{
ScheduleId = (int)reader["ScheduleId"],
BusId = (int)reader["BusId"],
RouteId = (int)reader["RouteId"],
DepartureTime = (DateTime)reader["DepartureTime"],
ArrivalTime = (DateTime)reader["ArrivalTime"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Schedule> GetAllSchedules()
{
var schedules = new List<Schedule>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Schedules", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
schedules.Add(new Schedule
{
ScheduleId = (int)reader["ScheduleId"],
BusId = (int)reader["BusId"],
RouteId = (int)reader["RouteId"],
DepartureTime = (DateTime)reader["DepartureTime"],
ArrivalTime = (DateTime)reader["ArrivalTime"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return schedules;
}
public void AddSchedule(Schedule schedule)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Schedules (BusId, RouteId, DepartureTime, ArrivalTime) VALUES (@BusId, @RouteId, @DepartureTime, @ArrivalTime)", connection);
command.Parameters.AddWithValue("@BusId", schedule.BusId);
command.Parameters.AddWithValue("@RouteId", schedule.RouteId);
command.Parameters.AddWithValue("@DepartureTime", schedule.DepartureTime);
command.Parameters.AddWithValue("@ArrivalTime", schedule.ArrivalTime);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateSchedule(Schedule schedule)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Schedules SET BusId = @BusId, RouteId = @RouteId, DepartureTime = @DepartureTime, ArrivalTime = @ArrivalTime, UpdatedAt = GETDATE() WHERE ScheduleId = @ScheduleId", connection);
command.Parameters.AddWithValue("@ScheduleId", schedule.ScheduleId);
command.Parameters.AddWithValue("@BusId", schedule.BusId);
command.Parameters.AddWithValue("@RouteId", schedule.RouteId);
command.Parameters.AddWithValue("@DepartureTime", schedule.DepartureTime);
command.Parameters.AddWithValue("@ArrivalTime", schedule.ArrivalTime);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteSchedule(int scheduleId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Schedules WHERE ScheduleId = @ScheduleId", connection);
command.Parameters.AddWithValue("@ScheduleId", scheduleId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
// Implement similar repository classes for Booking, Payment, Ticket, Feedback, Report, and Notification.
public class BookingRepository : IBookingRepository
{
private readonly string _connectionString;
public BookingRepository(string connectionString)
{
_connectionString = connectionString;
}
public Booking GetBookingById(int bookingId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Bookings WHERE BookingId = @BookingId", connection);
command.Parameters.AddWithValue("@BookingId", bookingId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Booking
{
BookingId = (int)reader["BookingId"],
UserId = (int)reader["User Id"],
ScheduleId = (int)reader["ScheduleId"],
BookingDate = (DateTime)reader["BookingDate"],
TotalAmount = (decimal)reader["TotalAmount "],
Status = reader["Status"].ToString()
};
}
}
}
return null;
}
public IEnumerable<Booking> GetAllBookings()
{
var bookings = new List<Booking>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Bookings", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
bookings.Add(new Booking
{
BookingId = (int)reader["BookingId"],
UserId = (int)reader["User Id"],
ScheduleId = (int)reader["ScheduleId"],
BookingDate = (DateTime)reader["BookingDate"],
TotalAmount = (decimal)reader["TotalAmount"],
Status = reader["Status"].ToString()
});
}
}
}
return bookings;
}
public void AddBooking(Booking booking)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Bookings (User Id, ScheduleId, BookingDate, TotalAmount, Status) VALUES (@User Id, @ScheduleId, @BookingDate, @TotalAmount, @Status)", connection);
command.Parameters.AddWithValue("@User Id", booking.UserId);
command.Parameters.AddWithValue("@ScheduleId", booking.ScheduleId);
command.Parameters.AddWithValue("@BookingDate", booking.BookingDate);
command.Parameters.AddWithValue("@TotalAmount", booking.TotalAmount);
command.Parameters.AddWithValue("@Status", booking.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateBooking(Booking booking)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Bookings SET UserId = @User Id, ScheduleId = @ScheduleId, BookingDate = @BookingDate, TotalAmount = @TotalAmount, Status = @Status WHERE BookingId = @BookingId", connection);
command.Parameters.AddWithValue("@BookingId", booking.BookingId);
command.Parameters.AddWithValue("@User Id", booking.UserId);
command.Parameters.AddWithValue("@ScheduleId", booking.ScheduleId);
command.Parameters.AddWithValue("@BookingDate", booking.BookingDate);
command.Parameters.AddWithValue("@TotalAmount", booking.TotalAmount);
command.Parameters.AddWithValue("@Status", booking.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteBooking(int bookingId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Bookings WHERE BookingId = @BookingId", connection);
command.Parameters.AddWithValue("@BookingId", bookingId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
// Implement similar repository classes for Payment, Ticket, Feedback, Report, and Notification.
public class PaymentRepository : IPaymentRepository
{
private readonly string _connectionString;
public PaymentRepository(string connectionString)
{
_connectionString = connectionString;
}
public Payment GetPaymentById(int paymentId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Payments WHERE PaymentId = @PaymentId", connection);
command.Parameters.AddWithValue("@PaymentId", paymentId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Payment
{
PaymentId = (int)reader["PaymentId"],
BookingId = (int)reader["BookingId"],
PaymentDate = (DateTime)reader["PaymentDate"],
Amount = (decimal)reader["Amount"],
PaymentMethod = reader["PaymentMethod"].ToString(),
Status = reader["Status"].ToString()
};
}
}
}
return null;
}
public IEnumerable<Payment> GetAllPayments()
{
var payments = new List<Payment>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Payments", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
payments.Add(new Payment
{
PaymentId = (int)reader["PaymentId"],
BookingId = (int)reader["BookingId"],
PaymentDate = (DateTime)reader["PaymentDate"],
Amount = (decimal)reader["Amount"],
PaymentMethod = reader["PaymentMethod"].ToString(),
Status = reader["Status"].ToString()
});
}
}
}
return payments;
}
public void AddPayment(Payment payment)
{
using (var connection = new SqlConnection(_ connectionString))
{
var command = new SqlCommand("INSERT INTO Payments (BookingId, PaymentDate, Amount, PaymentMethod, Status) VALUES (@BookingId, @PaymentDate, @Amount, @PaymentMethod, @Status)", connection);
command.Parameters.AddWithValue("@BookingId", payment.BookingId);
command.Parameters.AddWithValue("@PaymentDate", payment.PaymentDate);
command.Parameters.AddWithValue("@Amount", payment.Amount);
command.Parameters.AddWithValue("@PaymentMethod", payment.PaymentMethod);
command.Parameters.AddWithValue("@Status", payment.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdatePayment(Payment payment)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Payments SET BookingId = @BookingId, PaymentDate = @PaymentDate, Amount = @Amount, PaymentMethod = @PaymentMethod, Status = @Status WHERE PaymentId = @PaymentId", connection);
command.Parameters.AddWithValue("@PaymentId", payment.PaymentId);
command.Parameters.AddWithValue("@BookingId", payment.BookingId);
command.Parameters.AddWithValue("@PaymentDate", payment.PaymentDate);
command.Parameters.AddWithValue("@Amount", payment.Amount);
command.Parameters.AddWithValue("@PaymentMethod", payment.PaymentMethod);
command.Parameters.AddWithValue("@Status", payment.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeletePayment(int paymentId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Payments WHERE PaymentId = @PaymentId", connection);
command.Parameters.AddWithValue("@PaymentId", paymentId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
// Implement similar repository classes for Ticket, Feedback, Report, and Notification.
public class TicketRepository : ITicketRepository
{
private readonly string _connectionString;
public TicketRepository(string connectionString)
{
_connectionString = connectionString;
}
public Ticket GetTicketById(int ticketId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Tickets WHERE TicketId = @TicketId", connection);
command.Parameters.AddWithValue("@TicketId", ticketId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Ticket
{
TicketId = (int)reader["TicketId"],
BookingId = (int)reader["BookingId"],
SeatNumber = reader["SeatNumber"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Ticket> GetAllTickets()
{
var tickets = new List<Ticket>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Tickets", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
tickets.Add(new Ticket
{
TicketId = (int)reader["TicketId"],
BookingId = (int)reader["BookingId"],
SeatNumber = reader["SeatNumber"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return tickets;
}
public void AddTicket(Ticket ticket)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Tickets (BookingId, SeatNumber, CreatedAt) VALUES (@BookingId, @SeatNumber, @CreatedAt)", connection);
command.Parameters.AddWithValue("@BookingId", ticket.BookingId);
command.Parameters.AddWithValue("@SeatNumber", ticket.SeatNumber);
command.Parameters.AddWithValue("@CreatedAt", ticket.CreatedAt);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateTicket(Ticket ticket)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Tickets SET BookingId = @BookingId, SeatNumber = @SeatNumber WHERE TicketId = @TicketId", connection);
command.Parameters.AddWithValue("@TicketId", ticket.TicketId);
command.Parameters.AddWithValue("@BookingId", ticket.BookingId);
command.Parameters.AddWithValue("@SeatNumber", ticket.SeatNumber);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteTicket(int ticketId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Tickets WHERE TicketId = @TicketId", connection);
command.Parameters.Add WithValue("@TicketId", ticketId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
// Implement similar repository classes for Feedback, Report, and Notification.
public class FeedbackRepository : IFeedbackRepository
{
private readonly string _connectionString;
public FeedbackRepository(string connectionString)
{
_connectionString = connectionString;
}
public Feedback GetFeedbackById(int feedbackId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Feedbacks WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@FeedbackId", feedbackId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Feedback
{
FeedbackId = (int)reader["FeedbackId"],
UserId = (int)reader["User Id"],
FeedbackText = reader["FeedbackText"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Feedback> GetAllFeedbacks()
{
var feedbacks = new List<Feedback>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Feedbacks", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
feedbacks.Add(new Feedback
{
FeedbackId = (int)reader["FeedbackId"],
UserId = (int)reader["User Id"],
FeedbackText = reader["FeedbackText"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return feedbacks;
}
public void AddFeedback(Feedback feedback)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Feedbacks (User Id, FeedbackText, CreatedAt) VALUES (@User Id, @FeedbackText, @CreatedAt)", connection);
command.Parameters.AddWithValue("@User Id", feedback.UserId);
command.Parameters.AddWithValue("@FeedbackText", feedback.FeedbackText);
command.Parameters.AddWithValue("@CreatedAt", feedback.CreatedAt);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateFeedback(Feedback feedback)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Feedbacks SET UserId = @User Id, FeedbackText = @FeedbackText WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@FeedbackId", feedback.FeedbackId);
command.Parameters.AddWithValue("@User Id", feedback.UserId);
command.Parameters.AddWithValue("@FeedbackText", feedback.FeedbackText);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteFeedback(int feedbackId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Feedbacks WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@FeedbackId", feedbackId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
// Implement similar repository classes for Report and Notification.
public class ReportRepository : IReportRepository
{
private readonly string _connectionString;
public ReportRepository(string connectionString)
{
_connectionString = connectionString;
}
public Report GetReportById(int reportId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Reports WHERE ReportId = @ReportId", connection);
command.Parameters.AddWithValue("@ReportId", reportId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Report
{
ReportId = (int)reader["ReportId"],
UserId = (int)reader["User Id"],
ReportText = reader["ReportText"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Report> GetAllReports()
{
var reports = new List<Report>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Reports", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
reports.Add(new Report
{
ReportId = (int)reader["ReportId"],
UserId = (int)reader["User Id"],
ReportText = reader["ReportText"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return reports;
}
public void AddReport(Report report)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Reports (User Id, ReportText, CreatedAt) VALUES (@User Id, @ReportText, @CreatedAt)", connection);
command.Parameters.AddWithValue("@User Id", report.UserId);
command.Parameters.AddWithValue("@ReportText", report.ReportText);
command.Parameters.AddWithValue("@CreatedAt", report.CreatedAt);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateReport(Report report)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Reports SET UserId = @User Id, ReportText = @ReportText WHERE ReportId = @ReportId", connection);
command.Parameters.AddWithValue("@ReportId", report.ReportId);
command.Parameters.AddWithValue("@User Id", report.UserId);
command.Parameters.AddWithValue("@ReportText", report.ReportText);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteReport(int reportId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Reports WHERE ReportId = @ReportId", connection);
command.Parameters.AddWithValue("@ReportId", reportId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
// Implement similar repository classes for Notification.
public class NotificationRepository : INotificationRepository
{
private readonly string _connectionString;
public NotificationRepository(string connectionString)
{
_connectionString = connectionString;
}
public Notification GetNotificationById(int notificationId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Notifications WHERE NotificationId = @NotificationId", connection);
command.Parameters.AddWithValue("@NotificationId", notificationId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Notification
{
NotificationId = (int)reader["NotificationId"],
UserId = (int)reader["User Id"],
Message = reader["Message"].ToString(),
IsRead = (bool)reader["IsRead"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public IEnumerable<Notification> GetAllNotifications()
{
var notifications = new List<Notification>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Notifications", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
notifications.Add(new Notification
{
NotificationId = (int)reader["NotificationId"],
UserId = (int)reader["User Id"],
Message = reader["Message"].ToString(),
IsRead = (bool)reader["IsRead"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return notifications;
}
public void AddNotification(Notification notification)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Notifications (User Id, Message, IsRead, CreatedAt) VALUES (@User Id, @Message, @IsRead, @CreatedAt)", connection);
command.Parameters.AddWithValue("@User Id", notification.UserId);
command.Parameters.AddWithValue("@Message", notification.Message);
command.Parameters.AddWithValue("@IsRead", notification.IsRead);
command.Parameters.AddWithValue("@CreatedAt", notification.CreatedAt);
connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateNotification(Notification notification)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Notifications SET UserId = @User Id, Message = @Message, IsRead = @IsRead WHERE NotificationId = @NotificationId", connection);
command.Parameters.AddWithValue("@NotificationId", notification.NotificationId);
command.Parameters.AddWithValue("@User Id", notification.UserId);
command.Parameters.AddWithValue("@Message", notification.Message);
command.Parameters.AddWithValue("@IsRead", notification.IsRead);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteNotification(int notificationId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Notifications WHERE NotificationId = @NotificationId", connection);
command.Parameters.AddWithValue("@NotificationId", notificationId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Creating Controllers
Creating controllers for each repository in an ASP.NET MVC application involves defining actions that correspond to the CRUD operations for each entity. Below, I'll provide an example of how to create controllers for the repositories you defined earlier (Users, Roles, Buses, Routes, Schedules, Bookings, Payments, Tickets, Feedbacks, Reports, and Notifications).
1. UsersController
Controllers/UsersController.cs
using System.Linq;
using System.Web.Mvc;
using YourNamespace.Models;
using YourNamespace.Repositories;
public class UsersController : Controller
{
private readonly IUserRepository _userRepository;
public UsersController()
{
_userRepository = new UserRepository("YourConnectionString");
}
public ActionResult Index()
{
var users = _userRepository.GetAllUsers();
return View(users);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(User user)
{
if (ModelState.IsValid)
{
_userRepository.AddUser (user);
return RedirectToAction("Index");
}
return View(user);
}
public ActionResult Edit(int id)
{
var user = _userRepository.GetUser ById(id);
return View(user);
}
[HttpPost]
public ActionResult Edit(User user)
{
if (ModelState.IsValid)
{
_userRepository.UpdateUser (user);
return RedirectToAction("Index");
}
return View(user);
}
public ActionResult Delete(int id)
{
var user = _userRepository.GetUser ById(id);
return View(user);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_userRepository.DeleteUser (id);
return RedirectToAction("Index");
}
}
2. RolesController
Controllers/RolesController.cs
using System.Linq;
using System.Web.Mvc;
using YourNamespace.Models;
using YourNamespace.Repositories;
public class RolesController : Controller
{
private readonly IRoleRepository _roleRepository;
public RolesController()
{
_roleRepository = new RoleRepository("YourConnectionString");
}
public ActionResult Index()
{
var roles = _roleRepository.GetAllRoles();
return View(roles);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Role role)
{
if (ModelState.IsValid)
{
_roleRepository.AddRole(role);
return RedirectToAction("Index");
}
return View(role);
}
public ActionResult Edit(int id)
{
var role = _roleRepository.GetRoleById(id);
return View(role);
}
[HttpPost]
public ActionResult Edit(Role role)
{
if (ModelState.IsValid)
{
_roleRepository.UpdateRole(role);
return RedirectToAction("Index");
}
return View(role);
}
public ActionResult Delete(int id)
{
var role = _roleRepository.GetRoleById(id);
return View(role);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_roleRepository.DeleteRole(id);
return RedirectToAction("Index");
}
}
3. BusesController
Controllers/BusesController.cs
using System.Linq;
using System.Web.Mvc;
using YourNamespace.Models;
using YourNamespace.Repositories;
public class BusesController : Controller
{
private readonly IBusRepository _busRepository;
public BusesController()
{
_busRepository = new BusRepository("YourConnectionString");
}
public ActionResult Index()
{
var buses = _busRepository.GetAllBuses();
return View(buses);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Bus bus)
{
if (ModelState.IsValid)
{
_busRepository.AddBus(bus);
return RedirectToAction("Index");
}
return View(bus);
}
public ActionResult Edit(int id)
{
var bus = _busRepository.GetBusById(id);
return View(bus);
}
[HttpPost]
public ActionResult Edit(Bus bus)
{
if (ModelState.IsValid)
{
_busRepository.UpdateBus(bus);
return RedirectToAction("Index");
}
return View(bus);
}
public ActionResult Delete(int id)
{
var bus = _busRepository.GetBusById(id);
return View(bus);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_busRepository.DeleteBus(id);
return RedirectToAction("Index");
}
}
4. RoutesController
Controllers/RoutesController.cs
using System.Linq;
using System.Web.Mvc;
using YourNamespace.Models;
using YourNamespace.Repositories;
public class RoutesController : Controller
{
private readonly IRouteRepository _routeRepository;
public RoutesController()
{
_routeRepository = new RouteRepository("YourConnectionString");
}
public ActionResult Index()
{
var routes = _routeRepository.GetAllRoutes();
return View(routes);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Route route)
{
if (ModelState.IsValid)
{
_routeRepository.AddRoute(route);
return RedirectToAction("Index");
}
return View(route);
}
public ActionResult Edit(int id)
{
var route = _routeRepository.GetRouteById(id);
return View(route);
}
[HttpPost]
public ActionResult Edit(Route route)
{
if (ModelState.IsValid)
{
_routeRepository.UpdateRoute(route);
return RedirectToAction("Index");
}
return View(route);
}
public ActionResult Delete(int id)
{
var route = _routeRepository.GetRouteById(id);
return View(route);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_routeRepository.DeleteRoute(id);
return RedirectToAction("Index");
}
}
5. SchedulesController
Controllers/SchedulesController.cs
using System.Linq;
using System.Web.Mvc;
using YourNamespace.Models;
using YourNamespace.Repositories;
public class SchedulesController : Controller
{
private readonly IScheduleRepository _scheduleRepository;
public SchedulesController()
{
_scheduleRepository = new ScheduleRepository("YourConnectionString");
}
public ActionResult Index()
{
var schedules = _scheduleRepository.GetAllSchedules();
return View(schedules);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Schedule schedule)
{
if (ModelState.IsValid)
{
_scheduleRepository.AddSchedule(schedule);
return RedirectToAction("Index");
}
return View(schedule);
}
public ActionResult Edit(int id)
{
var schedule = _scheduleRepository.GetScheduleById(id);
return View(schedule);
}
[HttpPost]
public ActionResult Edit(Schedule schedule)
{
if (ModelState.IsValid)
{
_scheduleRepository.UpdateSchedule(schedule);
return RedirectToAction("Index");
}
return View(schedule);
}
public ActionResult Delete(int id)
{
var schedule = _scheduleRepository.GetScheduleById(id);
return View(schedule);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_scheduleRepository.DeleteSchedule(id);
return RedirectToAction("Index");
}
}
6. BookingsController
Controllers/BookingsController.cs
using System.Linq;
using System.Web.Mvc;
using YourNamespace.Models;
using YourNamespace.Repositories;
public class BookingsController : Controller
{
private readonly IBookingRepository _bookingRepository;
public BookingsController()
{
_bookingRepository = new BookingRepository("YourConnectionString");
}
public ActionResult Index()
{
var bookings = _bookingRepository.GetAllBookings();
return View(bookings);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Booking booking)
{
if (ModelState.IsValid)
{
_bookingRepository.AddBooking(booking);
return RedirectToAction("Index");
}
return View(booking);
}
public ActionResult Edit(int id)
{
var booking = _bookingRepository.GetBookingById(id);
return View(booking);
}
[HttpPost]
public ActionResult Edit(Booking booking)
{
if (ModelState.IsValid)
{
_bookingRepository.UpdateBooking(booking);
return RedirectToAction("Index");
}
return View(booking);
}
public ActionResult Delete(int id)
{
var booking = _bookingRepository.GetBookingById(id);
return View(booking);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_bookingRepository.DeleteBooking(id);
return RedirectToAction("Index");
}
}
7. PaymentsController
Controllers/PaymentsController.cs
using System.Linq;
using System.Web.Mvc;
using YourNamespace.Models;
using YourNamespace.Repositories;
public class PaymentsController : Controller
{
private readonly IPaymentRepository _paymentRepository;
public PaymentsController()
{
_paymentRepository = new PaymentRepository("YourConnectionString");
}
public ActionResult Index()
{
var payments = _paymentRepository.GetAllPayments();
return View(payments);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Payment payment)
{
if (ModelState.IsValid)
{
_paymentRepository.AddPayment(payment);
return RedirectToAction("Index");
}
return View(payment);
}
public ActionResult Edit(int id)
{
var payment = _paymentRepository.GetPaymentById(id);
return View(payment);
}
[HttpPost]
public ActionResult Edit(Payment payment)
{
if (ModelState.IsValid)
{
_paymentRepository.UpdatePayment(payment);
return RedirectToAction("Index");
}
return View(payment);
}
public ActionResult Delete(int id)
{
var payment = _paymentRepository.GetPaymentById(id);
return View(payment);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_paymentRepository.DeletePayment(id);
return RedirectToAction("Index");
}
}
8. TicketsController
Controllers/TicketsController.cs
using System.Linq;
using System.Web.Mvc;
using YourNamespace.Models;
using YourNamespace.Repositories;
public class TicketsController : Controller
{
private readonly ITicketRepository _ticketRepository;
public TicketsController()
{
_ticketRepository = new TicketRepository("YourConnectionString");
}
public ActionResult Index()
{
var tickets = _ticketRepository.GetAllTickets();
return View(tickets);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Ticket ticket)
{
if (ModelState.IsValid)
{
_ticketRepository.AddTicket(ticket);
return RedirectToAction("Index");
}
return View(ticket);
}
public ActionResult Edit(int id)
{
var ticket = _ticketRepository.GetTicketById(id);
return View(ticket);
}
[HttpPost]
public ActionResult Edit(Ticket ticket)
{
if (ModelState.IsValid)
{
_ticketRepository.UpdateTicket(ticket);
return RedirectToAction("Index");
}
return View(ticket);
}
public ActionResult Delete(int id)
{
var ticket = _ticketRepository.GetTicketById(id);
return View(ticket);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_ticketRepository.DeleteTicket(id);
return RedirectToAction("Index");
}
}
9. FeedbacksController
Controllers/FeedbacksController.cs
using System.Linq;
using System.Web.Mvc;
using YourNamespace.Models;
using YourNamespace.Repositories;
public class FeedbacksController : Controller
{
private readonly IFeedbackRepository _feedbackRepository;
public FeedbacksController()
{
_feedbackRepository = new FeedbackRepository("YourConnectionString");
}
public ActionResult Index()
{
var feedbacks = _feedbackRepository.GetAllFeedbacks();
return View(feedbacks);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Feedback feedback)
{
if (ModelState.IsValid)
{
_feedbackRepository.AddFeedback(feedback);
return RedirectToAction("Index");
}
return View(feedback);
}
public ActionResult Edit(int id)
{
var feedback = _feedbackRepository.GetFeedbackById(id);
return View(feedback);
}
[HttpPost]
public ActionResult Edit(Feedback feedback)
{
if (ModelState.IsValid)
{
_feedbackRepository.UpdateFeedback(feedback);
return RedirectToAction("Index");
}
return View(feedback);
}
public ActionResult Delete(int id)
{
var feedback = _feedbackRepository.GetFeedbackById(id);
return View(feedback);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_feedbackRepository.DeleteFeedback(id);
return RedirectToAction("Index");
}
}
10. ReportsController
Controllers/ReportsController.cs
using System.Linq;
using System.Web.Mvc;
using YourNamespace.Models;
using YourNamespace.Repositories;
public class ReportsController : Controller
{
private readonly IReportRepository _reportRepository;
public ReportsController()
{
_reportRepository = new ReportRepository("YourConnectionString");
}
public ActionResult Index()
{
var reports = _reportRepository.GetAllReports();
return View(reports);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Report report)
{
if (ModelState.IsValid)
{
_reportRepository.AddReport(report);
return RedirectToAction("Index");
}
return View(report);
}
public ActionResult Edit(int id)
{
var report = _reportRepository.GetReportById(id);
return View(report);
}
[HttpPost]
public ActionResult Edit(Report report)
{
if (ModelState.IsValid)
{
_reportRepository.UpdateReport(report);
return RedirectToAction("Index");
}
return View(report);
}
public ActionResult Delete(int id)
{
var report = _reportRepository.GetReportById(id);
return View(report);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_reportRepository.DeleteReport(id);
return RedirectToAction("Index");
}
}
11. NotificationsController
Controllers/NotificationsController.cs
using System.Linq;
using System.Web.Mvc;
using YourNamespace.Models;
using YourNamespace.Repositories;
public class NotificationsController : Controller
{
private readonly INotificationRepository _notificationRepository;
public NotificationsController()
{
_notificationRepository = new NotificationRepository("YourConnectionString");
}
public ActionResult Index()
{
var notifications = _notificationRepository.GetAllNotifications();
return View(notifications);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Notification notification)
{
if (ModelState.IsValid)
{
_notificationRepository.AddNotification(notification);
return RedirectToAction("Index");
}
return View(notification);
}
public ActionResult Edit(int id)
{
var notification = _notificationRepository.GetNotificationById(id);
return View(notification);
}
[HttpPost]
public ActionResult Edit(Notification notification)
{
if (ModelState.IsValid)
{
_notificationRepository.UpdateNotification(notification);
return RedirectToAction("Index");
}
return View(notification);
}
public ActionResult Delete(int id)
{
var notification = _notificationRepository.GetNotificationById(id);
return View(notification);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_notificationRepository.DeleteNotification(id);
return RedirectToAction("Index");
}
}
Creating View Files
Creating view files for all the controllers in an ASP.NET MVC application involves creating Razor view files that correspond to the actions in your controllers. Below, I'll provide a basic structure for the views for each of the entities (Users, Roles, Buses, Routes, Schedules, Bookings, Payments, Tickets, Feedbacks, Reports, and Notifications).
1. Users Views
Views/Users/Index.cshtml
@model IEnumerable<YourNamespace.Models.User>
<h2>Users</h2>
<a href='@Url.Action("Create")'>Create New User</a>
<table>
<thead>
<tr>
<th>Username</th>
<th>Email</th>
<th>Phone</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var user in Model)
{
<tr>
<td>@user.Username</td>
<td>@user.Email</td>
<td>@user.Phone</td>
<td>
<a href='@Url.Action("Edit", new { id = user.UserId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = user.UserId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Users/Create.cshtml
@model YourNamespace.Models.User
<h2>Create User</h2>
@using (Html.BeginForm())
{
@Html.LabelFor(m => m.Username)
@Html.TextBoxFor(m => m.Username)
@Html.ValidationMessageFor(m => m.Username)
@Html.LabelFor(m => m.PasswordHash)
@Html.TextBoxFor(m => m.PasswordHash)
@Html.ValidationMessageFor(m => m.PasswordHash)
@Html.LabelFor(m => m.Email)
@Html.TextBoxFor(m => m.Email)
@Html.ValidationMessageFor(m => m.Email)
@Html.LabelFor(m => m.Phone)
@Html.TextBoxFor(m => m.Phone)
@Html.ValidationMessageFor(m => m.Phone)
<input type="submit" value="Create" />
}
Views/Users/Edit.cshtml
@model YourNamespace.Models.User
<h2>Edit User</h2>
@using (Html.BeginForm())
{
@Html.HiddenFor(m => m.UserId)
@Html.LabelFor(m => m.Username)
@Html.TextBoxFor(m => m.Username)
@Html.ValidationMessageFor(m => m.Username)
@Html.LabelFor(m => m.PasswordHash)
@Html.TextBoxFor(m => m.PasswordHash)
@Html.ValidationMessageFor(m => m.PasswordHash)
@Html.LabelFor(m => m.Email)
@Html.TextBoxFor(m => m.Email)
@Html.ValidationMessageFor(m => m.Email)
@Html.LabelFor(m => m.Phone)
@Html.TextBoxFor(m => m.Phone)
@Html.ValidationMessageFor(m => m.Phone)
<input type="submit" value="Save" />
}
Views/Users/Delete.cshtml
@model YourNamespace.Models.User
<h2>Delete User</h2>
<p>Are you sure you want to delete this user?</p>
<dl>
<dt>Username</dt>
<dd>@Model.Username</dd>
<dt>Email</dt>
<dd>@Model.Email</dd>
<dt>Phone</dt>
<dd>@Model.Phone</dd>
</dl>
@using (Html.BeginForm())
{
@Html.HiddenFor(m => m.UserId)
<input type="submit" value="Delete" />
}
<a href='@Url.Action("Index")'>Cancel</a>
2. Roles Views
Views/Roles/Index.cshtml
@model IEnumerable<YourNamespace.Models.Role>
<h2>Roles</h2>
<a href='@Url.Action("Create")'>Create New Role</a>
<table>
<thead>
<tr>
<th>Role Name</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var role in Model)
{
<tr>
<td>@role.RoleName</td>
<td>
<a href='@Url.Action("Edit", new { id = role.RoleId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = role.RoleId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Roles/Create.cshtml
@model YourNamespace.Models.Role
<h2>Create Role</h2>
@using (Html.BeginForm())
{
@Html.LabelFor(m => m.RoleName)
@Html.TextBoxFor(m => m.RoleName)
@Html.ValidationMessageFor(m => m.RoleName)
<input type="submit" value="Create" />
}
Views/Roles/Edit.cshtml
@model YourNamespace.Models.Role
<h2>Edit Role</h2>
@using (Html.BeginForm())
{
@Html.HiddenFor(m => m.RoleId)
@Html.LabelFor(m => m.RoleName)
@Html.TextBoxFor(m => m.RoleName)
@Html.ValidationMessageFor(m => m.RoleName)
<input type="submit" value="Save" />
}
Views/Roles/Delete.cshtml
@model YourNamespace.Models.Role
<h2>Delete Role</h2>
<p>Are you sure you want to delete this role?</p>
<dl>
<dt>Role Name</dt>
<dd>@Model.RoleName</dd>
</dl>
@using (Html.BeginForm())
{
@Html.HiddenFor(m => m.RoleId)
<input type="submit" value="Delete" />
}
<a href='@Url.Action("Index")'>Cancel</a>
3. Buses Views
Views/Buses/Index.cshtml
@model IEnumerable<YourNamespace.Models.Bus>
<h2>Buses</h2>
<a href='@Url.Action("Create")'>Create New Bus</a>
<table>
<thead>
<tr>
<th>Bus Number</th>
<th>Capacity</th>
<th>Type</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var bus in Model)
{
<tr>
<td>@bus.BusNumber</td>
<td>@bus.Capacity</td>
<td>@bus.Type</td>
<td>
<a href='@Url.Action("Edit", new { id = bus.BusId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = bus.BusId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Buses/Create.cshtml
@model YourNamespace.Models.Bus
<h2>Create Bus</h2>
@using (Html.BeginForm())
{
@Html.LabelFor(m => m.BusNumber)
@Html.TextBoxFor(m => m.BusNumber)
@Html.ValidationMessageFor(m => m.BusNumber)
@Html.LabelFor(m => m.Capacity)
@Html.TextBoxFor(m => m.Capacity)
@Html.ValidationMessageFor(m => m.Capacity)
@Html.LabelFor(m => m.Type)
@Html.TextBoxFor(m => m.Type)
@Html.ValidationMessageFor(m => m.Type)
<input type="submit" value="Create" />
}
Views/Buses/Edit.cshtml
@model YourNamespace.Models.Bus
<h2>Edit Bus</h2>
@using (Html.BeginForm())
{
@Html.HiddenFor(m => m.BusId)
@Html.LabelFor(m => m.BusNumber)
@Html.TextBoxFor(m => m.BusNumber)
@Html.ValidationMessageFor(m => m.BusNumber)
@Html.LabelFor(m => m.Capacity)
@Html.TextBoxFor(m => m.Capacity)
@Html.ValidationMessageFor(m => m.Capacity)
@Html.LabelFor(m => m.Type)
@Html.TextBoxFor(m => m.Type)
@Html.ValidationMessageFor(m => m.Type)
<input type="submit" value="Save" />
}
Views/Buses/Delete.cshtml
@model YourNamespace.Models.Bus
<h2>Delete Bus</h2>
<p>Are you sure you want to delete this bus?</p>
<dl>
<dt>Bus Number</dt>
<dd>@Model.BusNumber</dd>
<dt>Capacity</dt>
<dd>@Model.Capacity</dd>
<dt>Type</dt>
<dd>@Model.Type</dd>
</dl>
@using (Html.BeginForm())
{
@Html.HiddenFor(m => m.BusId)
<input type="submit" value="Delete" />
}
<a href='@Url.Action("Index")'>Cancel</a>
4. Routes Views
Views/Routes/Index.cshtml
@model IEnumerable<YourNamespace.Models.Route>
<h2>Routes</h2>
<a href='@Url.Action("Create")'>Create New Route</a>
<table>
<thead>
<tr>
<th>Start Location</th>
<th>End Location</th>
<th>Distance</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var route in Model)
{
<tr>
<td>@route.StartLocation</td>
<td>@route.EndLocation</td>
<td>@route.Distance</td>
<td>
<a href='@Url.Action("Edit", new { id = route.RouteId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = route.RouteId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Routes/Create.cshtml
@model YourNamespace.Models.Route
<h2>Create Route</h2>
@using (Html.BeginForm())
{
@Html.LabelFor(m => m.StartLocation)
@Html.TextBoxFor(m => m.StartLocation)
@Html.ValidationMessageFor(m => m.StartLocation)
@Html.LabelFor(m => m.EndLocation)
@Html.TextBoxFor(m => m.EndLocation)
@Html.ValidationMessageFor(m => m.EndLocation)
@Html.LabelFor(m => m.Distance)
@Html.TextBoxFor(m => m.Distance)
@Html.ValidationMessageFor(m => m.Distance)
<input type="submit" value="Create" />
}
Views/Routes/Edit.cshtml
@model YourNamespace.Models.Route
<h2>Edit Route</h2>
@using (Html.BeginForm())
{
@Html.HiddenFor(m => m.RouteId)
@Html.LabelFor(m => m.StartLocation)
@Html.TextBoxFor(m => m.StartLocation)
@Html.ValidationMessageFor(m => m.StartLocation)
@Html.LabelFor(m => m.EndLocation)
@Html.TextBoxFor(m => m.EndLocation)
@Html.ValidationMessageFor(m => m.EndLocation)
@Html.LabelFor(m => m.Distance)
@Html.TextBoxFor(m => m.Distance)
@Html.ValidationMessageFor(m => m.Distance)
<input type="submit" value="Save" />
}
Views/Routes/Delete.cshtml
@model YourNamespace.Models.Route
<h2>Delete Route</h2>
<p>Are you sure you want to delete this route?</p>
<dl>
<dt>Start Location</dt>
<dd>@Model.StartLocation</dd>
<dt>End Location</dt>
<dd>@Model.EndLocation</dd>
<dt>Distance</dt>
<dd>@Model.Distance</dd>
</dl>
@using (Html.BeginForm())
{
@Html.HiddenFor(m => m.RouteId)
<input type="submit" value="Delete" />
}
<a href='@Url.Action("Index")'>Cancel</a>
5. Schedules Views
Views/Schedules/Index.cshtml
@model IEnumerable<YourNamespace.Models.Schedule>
<h2>Schedules</h2>
<a href='@Url.Action("Create")'>Create New Schedule</a>
<table>
<thead>
<tr>
<th>Bus ID</th>
<th>Route ID</th>
<th>Departure Time</th>
<th>Arrival Time</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var schedule in Model)
{
<tr>
<td>@schedule.BusId</td>
<td>@schedule.RouteId</td>
<td>@schedule.DepartureTime</td>
<td>@schedule.ArrivalTime</td>
<td>
<a href='@Url.Action("Edit", new { id = schedule.ScheduleId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = schedule.ScheduleId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Schedules/Create.cshtml
@model YourNamespace.Models.Schedule
<h2>Create Schedule</h2>
@using (Html.BeginForm())
{
@Html.LabelFor(m => m.BusId)
@Html.TextBoxFor(m => m.BusId)
@Html.ValidationMessageFor(m => m.BusId)
@Html.LabelFor(m => m.RouteId)
@Html.TextBoxFor(m => m.RouteId)
@Html.ValidationMessageFor(m => m.RouteId)
@Html.LabelFor(m => m.DepartureTime)
@Html.TextBoxFor(m => m.DepartureTime, "{0:yyyy-MM-dd HH:mm:ss}")
@Html.ValidationMessageFor(m => m.DepartureTime)
@Html.LabelFor(m => m.ArrivalTime)
@Html.TextBoxFor(m => m.ArrivalTime, "{0:yyyy-MM-dd HH:mm:ss}")
@Html.ValidationMessageFor(m => m.ArrivalTime)
<input type="submit " value="Create" />
}
Views/Schedules/Edit.cshtml
@model YourNamespace.Models.Schedule
<h2>Edit Schedule</h2>
@using (Html.BeginForm())
{
@Html.HiddenFor(m => m.ScheduleId)
@Html.LabelFor(m => m.BusId)
@Html.TextBoxFor(m => m.BusId)
@Html.ValidationMessageFor(m => m.BusId)
@Html.LabelFor(m => m.RouteId)
@Html.TextBoxFor(m => m.RouteId)
@Html.ValidationMessageFor(m => m.RouteId)
@Html.LabelFor(m => m.DepartureTime)
@Html.TextBoxFor(m => m.DepartureTime, "{0:yyyy-MM-dd HH:mm:ss}")
@Html.ValidationMessageFor(m => m.DepartureTime)
@Html.LabelFor(m => m.ArrivalTime)
@Html.TextBoxFor(m => m.ArrivalTime, "{0:yyyy-MM-dd HH:mm:ss}")
@Html.ValidationMessageFor(m => m.ArrivalTime)
<input type="submit" value="Save" />
}
Views/Schedules/Delete.cshtml
@model YourNamespace.Models.Schedule
<h2>Delete Schedule</h2>
<p>Are you sure you want to delete this schedule?</p>
<dl>
<dt>Bus ID</dt>
<dd>@Model.BusId</dd>
<dt>Route ID</dt>
<dd>@Model.RouteId</dd>
<dt>Departure Time</dt>
<dd>@Model.DepartureTime</dd>
<dt>Arrival Time</dt>
<dd>@Model.ArrivalTime</dd>
</dl>
@using (Html.BeginForm())
{
@Html.HiddenFor(m => m.ScheduleId)
<input type="submit" value="Delete" />
}
<a href='@Url.Action("Index")'>Cancel</a>
6. Bookings Views
Views/Bookings/Index.cshtml
@model IEnumerable<YourNamespace.Models.Booking>
<h2>Bookings</h2>
<a href='@Url.Action("Create")'>Create New Booking</a>
<table>
<thead>
<tr>
<th>User ID</th>
<th>Schedule ID</th>
<th>Booking Date</th>
<th>Total Amount</th>
<th>Status</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var booking in Model)
{
<tr>
<td>@booking.UserId</td>
<td>@booking.ScheduleId</td>
<td>@booking.BookingDate</td>
<td>@booking.TotalAmount</td>
<td>@booking.Status</td>
<td>
<a href='@Url.Action("Edit", new { id = booking.BookingId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = booking.BookingId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Bookings/Create.cshtml
@model YourNamespace.Models.Booking
<h2>Create Booking</h2>
@using (Html.BeginForm())
{
@Html.LabelFor(m => m.UserId)
@Html.TextBoxFor(m => m.UserId)
@Html.ValidationMessageFor(m => m.UserId)
@Html.LabelFor(m => m.ScheduleId)
@Html.TextBoxFor(m => m.ScheduleId)
@Html.ValidationMessageFor(m => m.ScheduleId)
@Html.LabelFor(m => m.TotalAmount)
@Html.TextBoxFor(m => m.TotalAmount)
@Html.ValidationMessageFor(m => m.TotalAmount)
<input type="submit" value="Create" />
}
Views/Bookings/Edit.cshtml
@model YourNamespace.Models.Booking
<h2>Edit Booking</h2>
@using (Html.BeginForm())
{
@Html.HiddenFor(m => m.BookingId)
@Html.LabelFor(m => m.UserId)
@Html.TextBoxFor(m => m.UserId)
@Html.ValidationMessageFor(m => m.UserId)
@Html.LabelFor(m => m.ScheduleId)
@Html.TextBoxFor(m => m.ScheduleId)
@Html.ValidationMessageFor(m => m.ScheduleId)
@Html.LabelFor(m => m.TotalAmount)
@Html.TextBoxFor(m => m.TotalAmount)
@Html.ValidationMessageFor(m => m.TotalAmount)
<input type="submit" value="Save" />
}
Views/Bookings/Delete.cshtml
@model YourNamespace.Models.Booking
<h2>Delete Booking</h2>
<p> Are you sure you want to delete this booking?</p>
<dl>
<dt>User ID</dt>
<dd>@Model.UserId</dd>
<dt>Schedule ID</dt>
<dd>@Model.ScheduleId</dd>
<dt>Booking Date</dt>
<dd>@Model.BookingDate</dd>
<dt>Total Amount</dt>
<dd>@Model.TotalAmount</dd>
<dt>Status</dt>
<dd>@Model.Status</dd>
</dl>
@using (Html.BeginForm())
{
@Html.HiddenFor(m => m.BookingId)
<input type="submit" value="Delete" />
}
<a href='@Url.Action("Index")'>Cancel</a>
7. Payments Views
Views/Payments/Index.cshtml
@model IEnumerable<YourNamespace.Models.Payment>
<h2>Payments</h2>
<a href='@Url.Action("Create")'>Create New Payment</a>
<table>
<thead>
<tr>
<th>Booking ID</th>
<th>Payment Date</th>
<th>Amount</th>
<th>Payment Method</th>
<th>Status</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var payment in Model)
{
<tr>
<td>@payment.BookingId</td>
<td>@payment.PaymentDate</td>
<td>@payment.Amount</td>
<td>@payment.PaymentMethod</td>
<td>@payment.Status</td>
<td>
<a href='@Url.Action("Edit", new { id = payment.PaymentId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = payment.PaymentId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Payments/Create.cshtml
@model YourNamespace.Models.Payment
<h2>Create Payment</h2>
@using (Html.BeginForm())
{
@Html.LabelFor(m => m.BookingId)
@Html.TextBoxFor(m => m.BookingId)
@Html.ValidationMessageFor(m => m.BookingId)
@Html.LabelFor(m => m.Amount)
@Html.TextBoxFor(m => m.Amount)
@Html.ValidationMessageFor(m => m.Amount)
@Html.LabelFor(m => m.PaymentMethod)
@Html.TextBoxFor(m => m.PaymentMethod)
@Html.ValidationMessageFor(m => m.PaymentMethod)
<input type="submit" value="Create" />
}
Views/Payments/Edit.cshtml
@model YourNamespace.Models.Payment
<h2>Edit Payment</h2>
@using (Html.BeginForm())
{
@Html.HiddenFor(m => m.PaymentId)
@Html.LabelFor(m => m.BookingId)
@Html.TextBoxFor(m => m.BookingId)
@Html.ValidationMessageFor(m => m.BookingId)
@Html.LabelFor(m => m.Amount)
@Html.TextBoxFor(m => m.Amount)
@Html.ValidationMessageFor(m => m.Amount)
@Html.LabelFor(m => m.PaymentMethod)
@Html.TextBoxFor(m => m.PaymentMethod)
@Html.ValidationMessageFor(m => m.PaymentMethod)
<input type="submit" value="Save" />
}
Views/Payments/Delete.cshtml
@model YourNamespace.Models.Payment
<h2>Delete Payment</h2>
<p>Are you sure you want to delete this payment?</p>
<dl>
<dt>Booking ID</dt>
<dd>@Model.BookingId</dd>
<dt>Payment Date</dt>
<dd>@Model.PaymentDate</dd>
<dt>Amount</dt>
<dd>@Model.Amount</dd>
<dt>Payment Method</dt>
<dd>@Model.PaymentMethod</dd>
<dt>Status</dt>
<dd>@Model.Status</dd>
</dl>
@using (Html.BeginForm())
{
@Html.HiddenFor(m => m.PaymentId)
<input type="submit" value="Delete" />
}
<a href='@Url.Action("Index")'>Cancel</a>
8. Tickets Views
Views/Tickets/Index.cshtml
@model IEnumerable<YourNamespace.Models.Ticket>
<h2>Tickets</h2>
<a href='@Url.Action("Create")'>Create New Ticket</a>
<table>
<thead>
<tr>
<th>Booking ID</th>
<th>Seat Number</th>
<th>Created At</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var ticket in Model)
{
<tr>
<td>@ticket.BookingId</td>
<td>@ticket.SeatNumber</td>
<td>@ticket.CreatedAt</td>
<td>
<a href='@Url.Action("Edit", new { id = ticket.TicketId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = ticket.TicketId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Tickets/Create.cshtml
@model YourNamespace.Models.Ticket
<h2>Create Ticket</h2>
@using (Html.BeginForm())
{
@Html.LabelFor(m => m.BookingId)
@Html.TextBoxFor(m => m.BookingId)
@Html.ValidationMessageFor(m => m.BookingId)
@Html.LabelFor(m => m.SeatNumber)
@Html.TextBoxFor(m => m.SeatNumber)
@Html.ValidationMessageFor(m => m.SeatNumber)
<input type="submit" value="Create" />
}
Views/Tickets/Edit.cshtml
@model YourNamespace.Models.Ticket
<h2>Edit Ticket</h2>
@using (Html.BeginForm())
{
@Html.HiddenFor(m => m.TicketId)
@Html.LabelFor(m => m.BookingId)
@Html.TextBoxFor(m => m.BookingId)
@Html.ValidationMessageFor(m => m.BookingId)
@Html.LabelFor(m => m.SeatNumber)
@Html.TextBoxFor(m => m.SeatNumber)
@Html.ValidationMessageFor(m => m.SeatNumber)
<input type="submit" value="Save" />
}
Views/Tickets/Delete.cshtml
@model YourNamespace.Models.Ticket
<h2>Delete Ticket</h2>
<p>Are you sure you want to delete this ticket?</p>
<dl>
<dt>Booking ID</dt>
<dd>@Model.BookingId</dd>
<dt>Seat Number</dt>
<dd>@Model.SeatNumber</dd>
<dt>Created At</dt>
<dd>@Model.CreatedAt</dd>
</dl>
@using (Html.BeginForm())
{
@Html.HiddenFor(m => m.TicketId)
<input type="submit" value="Delete" />
}
<a href='@Url.Action("Index")'>Cancel</a>
9. Feedbacks Views
Views/Feedbacks/Index.cshtml
@model IEnumerable<YourNamespace.Models.Feedback>
<h2>Feedbacks</h2>
<a href='@Url.Action("Create")'>Create New Feedback</a>
<table>
<thead>
<tr>
<th>User ID</th>
<th>Feedback Text</th>
<th>Created At</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var feedback in Model)
{
<tr>
<td>@feedback.UserId</td>
<td>@feedback.FeedbackText</td>
<td>@feedback.CreatedAt</td>
<td>
<a href='@Url.Action("Edit", new { id = feedback.FeedbackId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = feedback.FeedbackId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Feedbacks/Create.cshtml
@model YourNamespace.Models.Feedback
<h2>Create Feedback</h2>
@using (Html.BeginForm())
{
@Html.LabelFor(m => m.UserId)
@Html.TextBoxFor(m => m.UserId)
@Html.ValidationMessageFor(m => m.UserId)
@Html.LabelFor(m => m.FeedbackText)
@Html.TextAreaFor(m => m.FeedbackText)
@Html.ValidationMessageFor(m => m.FeedbackText)
<input type="submit" value="Create" />
}
Views/Feedbacks/Edit.cshtml
@model YourNamespace.Models.Feedback
<h2>Edit Feedback</h2>
@using (Html.BeginForm())
{
@Html.HiddenFor(m => m.FeedbackId)
@Html.LabelFor(m => m.UserId)
@Html.TextBoxFor(m => m.UserId)
@Html.ValidationMessageFor(m => m.UserId)
@Html.LabelFor(m => m.FeedbackText)
@Html.TextAreaFor(m => m.FeedbackText)
@Html.ValidationMessageFor(m => m.FeedbackText)
<input type=" submit" value="Save" />
}
Views/Feedbacks/Delete.cshtml
@model YourNamespace.Models.Feedback
<h2>Delete Feedback</h2>
<p>Are you sure you want to delete this feedback?</p>
<dl>
<dt>User ID</dt>
<dd>@Model.UserId</dd>
<dt>Feedback Text</dt>
<dd>@Model.FeedbackText</dd>
<dt>Created At</dt>
<dd>@Model.CreatedAt</dd>
</dl>
@using (Html.BeginForm())
{
@Html.HiddenFor(m => m.FeedbackId)
<input type="submit" value="Delete" />
}
<a href='@Url.Action("Index")'>Cancel</a>
10. Reports Views
Views/Reports/Index.cshtml
@model IEnumerable<YourNamespace.Models.Report>
<h2>Reports</h2>
<a href='@Url.Action("Create")'>Create New Report</a>
<table>
<thead>
<tr>
<th>User ID</th>
<th>Report Text</th>
<th>Created At</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var report in Model)
{
<tr>
<td>@report.UserId</td>
<td>@report.ReportText</td>
<td>@report.CreatedAt</td>
<td>
<a href='@Url.Action("Edit", new { id = report.ReportId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = report.ReportId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Reports/Create.cshtml
@model YourNamespace.Models.Report
<h2>Create Report</h2>
@using (Html.BeginForm())
{
@Html.LabelFor(m => m.UserId)
@Html.TextBoxFor(m => m.UserId)
@Html.ValidationMessageFor(m => m.UserId)
@Html.LabelFor(m => m.ReportText)
@Html.TextAreaFor(m => m.ReportText)
@Html.ValidationMessageFor(m => m.ReportText)
<input type="submit" value="Create" />
}
Views/Reports/Edit.cshtml
@model YourNamespace.Models.Report
<h2>Edit Report</h2>
@using (Html.BeginForm())
{
@Html.HiddenFor(m => m.ReportId)
@Html.LabelFor(m => m.UserId)
@Html.TextBoxFor(m => m.UserId)
@Html.ValidationMessageFor(m => m.UserId)
@Html.LabelFor(m => m.ReportText)
@Html.TextAreaFor(m => m.ReportText)
@Html.ValidationMessageFor(m => m.ReportText)
<input type="submit" value="Save" />
}
Views/Reports/Delete.cshtml
@model YourNamespace.Models.Report
<h2>Delete Report</h2>
<p>Are you sure you want to delete this report?</p>
<dl>
<dt>User ID</dt>
<dd>@Model.UserId</dd>
<dt>Report Text</dt>
<dd>@Model.ReportText</dd>
<dt>Created At</dt>
<dd>@Model.CreatedAt</dd>
</dl>
@using (Html.BeginForm())
{
@Html.HiddenFor(m => m.ReportId)
<input type="submit" value="Delete" />
}
<a href='@Url.Action("Index")'>Cancel</a>
11. Notifications Views
Views/Notifications/Index.cshtml
@model IEnumerable<YourNamespace.Models.Notification>
<h2>Notifications</h2>
<a href='@Url.Action("Create")'>Create New Notification</a>
<table>
<thead>
<tr>
<th>User ID</th>
<th>Message</th>
<th>Is Read</th>
<th>Created At</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var notification in Model)
{
<tr>
<td>@notification.UserId</td>
<td>@notification.Message</td>
<td>@notification.IsRead</td>
<td>@notification.CreatedAt</td>
<td>
<a href='@Url.Action("Edit", new { id = notification.NotificationId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = notification.NotificationId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Notifications/Create.cshtml
@model YourNamespace.Models.Notification
<h2>Create Notification</h2>
@using (Html.BeginForm())
{
@Html.LabelFor(m => m.UserId)
@Html.TextBoxFor(m => m.UserId)
@Html.ValidationMessageFor(m => m.UserId)
@Html.LabelFor(m => m.Message)
@Html.TextAreaFor(m => m.Message)
@Html.ValidationMessageFor(m => m.Message)
@Html.LabelFor(m => m.IsRead)
@Html.CheckBoxFor(m => m.IsRead)
@Html.ValidationMessageFor(m => m.IsRead)
<input type="submit" value="Create" />
}
Views/Notifications/Edit.cshtml
@model YourNamespace.Models.Notification
<h2>Edit Notification</h2>
@using (Html.BeginForm())
{
@Html.HiddenFor(m => m.NotificationId)
@Html.LabelFor(m => m.UserId)
@Html.TextBoxFor(m => m.UserId)
@Html.ValidationMessageFor(m => m.UserId)
@Html.LabelFor(m => m.Message)
@Html.TextAreaFor(m => m.Message)
@Html.ValidationMessageFor(m => m.Message)
@Html.LabelFor(m => m.IsRead)
@Html.CheckBoxFor(m => m.IsRead)
@Html.ValidationMessageFor(m => m.IsRead)
<input type="submit" value="Save" />
}
Views/Notifications/Delete.cshtml
@model YourNamespace.Models.Notification
<h2>Delete Notification</h2>
<p>Are you sure you want to delete this notification?</p>
<dl>
<dt>User ID</dt>
<dd>@Model.UserId</dd>
<dt>Message</dt>
<dd>@Model.Message</dd>
<dt>Is Read</dt>
<dd>@Model.IsRead</dd>
<dt>Created At</dt>
<dd>@Model.CreatedAt</dd>
</dl>
@using (Html.BeginForm())
{
@Html.HiddenFor(m => m.NotificationId)
<input type="submit" value="Delete" />
}
<a href='@Url.Action("Index")'>Cancel</a>
Creating a Dashboard Page
Creating a dashboard page in an ASP.NET MVC application involves designing a view that consolidates and displays key metrics and data from various entities in your project. Below, I'll provide an example of how to create a dashboard page that displays consolidated data related to Users, Roles, Buses, Routes, Schedules, Bookings, Payments, Tickets, Feedbacks, Reports, and Notifications.
1. Dashboard View
Views/Dashboard/Index.cshtml
@model YourNamespace.ViewModels.DashboardViewModel
@{
ViewBag.Title = "Dashboard";
}
<h2>Dashboard</h2>
<div class="dashboard">
<div class="card">
<h3>Total Users</h3>
<p>@Model.TotalUsers</p>
</div>
<div class="card">
<h3>Total Roles</h3>
<p>@Model.TotalRoles</p>
</div>
<div class="card">
<h3>Total Buses</h3>
<p>@Model.TotalBuses</p>
</div>
<div class="card">
<h3>Total Routes</h3>
<p>@Model.TotalRoutes</p>
</div>
<div class="card">
<h3>Total Schedules</h3>
<p>@Model.TotalSchedules</p>
</div>
<div class="card">
<h3>Total Bookings</h3>
<p>@Model.TotalBookings</p>
</div>
<div class="card">
<h3>Total Payments</h3>
<p>@Model.TotalPayments</p>
</div>
<div class="card">
<h3>Total Tickets</h3>
<p>@Model.TotalTickets</p>
</div>
<div class="card">
<h3>Total Feedbacks</h3>
<p>@Model.TotalFeedbacks</p>
</div>
<div class="card">
<h3>Total Reports</h3>
<p>@Model.TotalReports</p>
</div>
<div class="card">
<h3>Total Notifications</h3>
<p>@Model.TotalNotifications</p>
</div>
</div>
<style>
.dashboard {
display: grid;
grid-template-columns: repeat(auto-fill, minmax(200px, 1fr));
gap: 20px;
}
.card {
background-color: #f8f9fa;
border: 1px solid #dee2e6;
border-radius: 5px;
padding: 20px;
text-align: center;
}
</style>
2. Dashboard ViewModel
Create a ViewModel to hold the consolidated data for the dashboard.
ViewModels/DashboardViewModel.cs
namespace YourNamespace.ViewModels
{
public class DashboardViewModel
{
public int TotalUsers { get; set; }
public int TotalRoles { get; set; }
public int TotalBuses { get; set; }
public int TotalRoutes { get; set; }
public int TotalSchedules { get; set; }
public int TotalBookings { get; set; }
public int TotalPayments { get; set; }
public int TotalTickets { get; set; }
public int TotalFeedbacks { get; set; }
public int TotalReports { get; set; }
public int TotalNotifications { get; set; }
}
}
3. Dashboard Controller
Create a controller action to populate the dashboard data.
Controllers/DashboardController.cs
using System.Linq;
using System.Web.Mvc;
using YourNamespace.Models;
using YourNamespace.ViewModels;
namespace YourNamespace.Controllers
{
public class DashboardController : Controller
{
private readonly YourDbContext _context;
public DashboardController()
{
_context = new YourDbContext();
}
public ActionResult Index()
{
var model = new DashboardViewModel
{
TotalUsers = _context.Users.Count(),
TotalRoles = _context.Roles.Count(),
TotalBuses = _context.Buses.Count(),
TotalRoutes = _context.Routes.Count(),
TotalSchedules = _context.Schedules.Count(),
TotalBookings = _context.Bookings.Count(),
TotalPayments = _context.Payments.Count(),
TotalTickets = _context.Tickets.Count(),
TotalFeedbacks = _context.Feedbacks.Count(),
TotalReports = _context.Reports.Count(),
TotalNotifications = _context.Notifications.Count()
};
return View(model);
}
}
}
4. Routing
Make sure to add a route for the dashboard in your RouteConfig.cs if you want to access it easily.
App_Start/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 }
);
}
}
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