public JsonResult GetClassAndRoomScheduleByDepartment(int departmentId) { var courses = courseManager.GetAllCourses(); List <ClassScheduleInfo> schedule = classroomManager.GetAllClassScheduleInfo(); List <ClassScheduleInfo> classSchedule2 = new List <ClassScheduleInfo>(); foreach (var course in courses) { ClassScheduleInfo classSchedule = new ClassScheduleInfo(); classSchedule.CourseId = course.Id; classSchedule.CourseCode = course.Code; classSchedule.CourseName = course.Name; classSchedule.DepartmentId = course.DepartmentId; foreach (var data in schedule) { if (data.CourseId == course.Id) { classSchedule.ScheduleDetails += data.ScheduleDetails; } } if (classSchedule.ScheduleDetails == null) { classSchedule.ScheduleDetails = "Not Scheduled yet"; } classSchedule2.Add(classSchedule); } List <ClassScheduleInfo> selectedDepartmentSchedule = classSchedule2.Where(d => d.DepartmentId == departmentId).ToList(); return(Json(selectedDepartmentSchedule)); }
public List <ClassScheduleInfo> GetAllClassScheduleInfo() { List <ClassScheduleInfo> classScheduleInfos = classroomGateway.GetAllClassScheduleInfo(); List <ClassScheduleInfo> classScheduleInfos2 = new List <ClassScheduleInfo>(); foreach (var schedule in classScheduleInfos) { ClassScheduleInfo classSchedule = new ClassScheduleInfo(); classSchedule.CourseId = schedule.CourseId; classSchedule.CourseCode = schedule.CourseCode; classSchedule.CourseName = schedule.CourseName; classSchedule.DepartmentId = schedule.DepartmentId; classSchedule.DepartmentName = schedule.DepartmentName; classSchedule.RoomNo = schedule.RoomNo; classSchedule.DayCode = schedule.DayCode; classSchedule.DayName = schedule.DayName; classSchedule.FromTime = schedule.FromTime; classSchedule.ToTime = schedule.ToTime; if (classSchedule.RoomNo == "N/A" && classSchedule.DayCode == "N/A" && classSchedule.DayName == "N/A" && classSchedule.FromTime == "N/A" && classSchedule.ToTime == "N/A") { classSchedule.ScheduleDetails = "Not Scheduled Yet"; } else { classSchedule.ScheduleDetails = "R.No: " + schedule.RoomNo + ", " + schedule.DayCode + ", " + schedule.FromTime + " - " + schedule.ToTime + ";<br/>"; } classScheduleInfos2.Add(classSchedule); } return(classScheduleInfos2); }
public List <ClassScheduleInfo> GetAllClassScheduleInfo() { Qurey = "SELECT * FROM classScheduleInfo WHERE status=@status"; Command = new SqlCommand(Qurey, Connection); Command.Parameters.AddWithValue("@status", "active"); List <ClassScheduleInfo> classScheduleInfos = new List <ClassScheduleInfo>(); Connection.Open(); Reader = Command.ExecuteReader(); while (Reader.Read()) { ClassScheduleInfo classSchedule = new ClassScheduleInfo(); if (Reader["departmentId"] == DBNull.Value) { classSchedule.DepartmentId = 0; } else { classSchedule.DepartmentId = Convert.ToInt32(Reader["departmentId"]); } if (Reader["courseId"] == DBNull.Value) { classSchedule.CourseId = 0; } else { classSchedule.CourseId = Convert.ToInt32(Reader["courseId"]); } if (Reader["departmentName"] == DBNull.Value) { classSchedule.DepartmentName = "N/A"; } else { classSchedule.DepartmentName = Reader["departmentName"].ToString(); } if (Reader["courseCode"] == DBNull.Value) { classSchedule.CourseCode = "N/A"; } else { classSchedule.CourseCode = Reader["courseCode"].ToString(); } if (Reader["courseName"] == DBNull.Value) { classSchedule.CourseName = "N/A"; } else { classSchedule.CourseName = Reader["courseName"].ToString(); } if (Reader["roomNo"] == DBNull.Value) { classSchedule.RoomNo = "N/A"; } else { classSchedule.RoomNo = Reader["roomNo"].ToString(); } if (Reader["dayCode"] == DBNull.Value) { classSchedule.DayCode = "N/A"; } else { classSchedule.DayCode = Reader["dayCode"].ToString(); } if (Reader["dayName"] == DBNull.Value) { classSchedule.DayName = "N/A"; } else { classSchedule.DayName = Reader["dayName"].ToString(); } if (Reader["fromTime"] == DBNull.Value) { classSchedule.FromTime = "N/A"; } else { classSchedule.FromTime = Reader["fromTime"].ToString(); } if (Reader["toTime"] == DBNull.Value) { classSchedule.ToTime = "N/A"; } else { classSchedule.ToTime = Reader["toTime"].ToString(); } classScheduleInfos.Add(classSchedule); } Reader.Close(); Connection.Close(); return(classScheduleInfos); }