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