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)); }