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