public List <ViewScheduleInfo> GetAllInfo()
{
string query = "SELECT * FROM GetScheduleInfo";
Command = new SqlCommand(query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List <ViewScheduleInfo> allInfo = new List <ViewScheduleInfo>();
while (Reader.Read())
{
ViewScheduleInfo scheduleInfo = new ViewScheduleInfo();
scheduleInfo.DepartmentId = (int)Reader["Id"];
scheduleInfo.CourseCode = Reader["CourseCode"].ToString();
scheduleInfo.CourseName = Reader["CourseName"].ToString();
scheduleInfo.ScheduleInfo = Reader["Schedule Info"].ToString();
if (scheduleInfo.ScheduleInfo == "")
{
scheduleInfo.ScheduleInfo = "Not Schedule Yet";
}
allInfo.Add(scheduleInfo);
}
Reader.Close();
Connection.Close();
return(allInfo);
}
public ActionResult ScheduleInfo(ViewScheduleInfo aScheduleInfo)
{
ViewBag.Departments = aDepartmentManager.GetAllDepartments();
return(View());
}
