public ActionResult Generate(int id)
{
var section = _context
.Sections
.Include(s => s.Department)
.Include(s => s.AssignedLectureRoom
.Building)
.Include(s => s.AssignedLabRoom
.Building)
.Include(s => s.CourseOfferings
.Select(c => c.Instructor))
.Include(s => s.CourseOfferings
.Select(c => c.Course))
.Include(s => s.LabGroups
.Select(x => x.Room.Building))
.Single(s => s.Id == id);
var semester = _context
.AcademicSemesters
.Include(s => s.AcademicYear)
.Single(s => s.CurrentSemester);
var viewModel = new ViewScheduleViewModel
{
Section = section,
AcademicSemester = semester
};
return(View("ViewSchedule", viewModel));
}
public List <ViewScheduleViewModel> ViewSchedule(int departmentId)
{
query = "SELECT * FROM SaveCoursesTable WHERE departmentId=" + departmentId;
Command = new SqlCommand(query, Connection);
List <ViewScheduleViewModel> ScheduleList = new List <ViewScheduleViewModel>();
Connection.Open();
Reader = Command.ExecuteReader();
while (Reader.Read())
{
ViewScheduleViewModel schedule = new ViewScheduleViewModel();
schedule.CourseId = Convert.ToInt32(Reader["Id"]);
schedule.CourseCode = Reader["Code"].ToString();
schedule.Name = Reader["Name"].ToString();
ScheduleList.Add(schedule);
}
Connection.Close();
// room and day time
foreach (ViewScheduleViewModel schedule in ScheduleList)
{
query = "SELECT * FROM ViewClassSchedule WHERE CourseId=" + schedule.CourseId + "AND Allocate=1";
Command = new SqlCommand(query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
schedule.ScheduleInFo = "";
while (Reader.Read())
{
schedule.ScheduleInFo += "R.No : ";
schedule.ScheduleInFo += Reader["RoomNo"];
schedule.ScheduleInFo += ", ";
schedule.ScheduleInFo += Reader["Day"];
schedule.ScheduleInFo += ", ";
schedule.ScheduleInFo += Reader["FromTime"];
schedule.ScheduleInFo += " - ";
schedule.ScheduleInFo += Reader["ToTime"];
schedule.ScheduleInFo += "; ";
}
if (schedule.ScheduleInFo == "")
{
schedule.ScheduleInFo = "Not Scheduled Yet";
}
Reader.Close();
Connection.Close();
}
return(ScheduleList);
}
