public List <RoomScheduleViewModel> ViewRoomSchedule(int departmentId)
{
List <RoomScheduleViewModel> roomSchedules = new List <RoomScheduleViewModel>();
Query = "SELECT * FROM Courses WHERE DepartmentId = '" + departmentId + "'";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
while (Reader.Read())
{
RoomScheduleViewModel aRoomInfo = new RoomScheduleViewModel();
aRoomInfo.CourseId = Convert.ToInt32(Reader["Id"]);
aRoomInfo.CourseCode = Reader["Code"].ToString();
aRoomInfo.CourseName = Reader["Name"].ToString();
roomSchedules.Add(aRoomInfo);
}
Reader.Close();
Connection.Close();
return(roomSchedules);
}
public IActionResult Index(string roomName, DateTime dateTime, string view)
{
RoomScheduleViewModel roomReservationsViewModel = new RoomScheduleViewModel(roomName, view, dateTime, Schedule);
return(View(roomReservationsViewModel));
}
