public ActionResult Schedule()
{
ScheduleVM model = new ScheduleVM();
using (var ctx = new CSEntities())
{
model.ScheduleList = (from t in ctx.ScheduleLists select t).ToList();
// model.ScheduleUser = ctx.ScheduleUserFunc(Convert.ToInt32(Session["ID"])).ToList();
model.ScheduleUser = ctx.ScheduleForAllUser(Convert.ToInt32(Session["ID"])).ToList();
//model.TeacherList = (from t in ctx.Teachers select t.Person.LName).ToList();
//model.CourseList = (from t in ctx.Courses where t.Closed == false select t.Name).ToList();
//TEST PART
// Drop Down List For Teachers
model.TeacherList = (from t in ctx.Teachers select t).ToList();
List <SelectListItem> itemsT = new List <SelectListItem>();
foreach (var item in model.TeacherList)
{
itemsT.Add(new SelectListItem {
Value = item.ID.ToString(), Text = item.Person.FName + " " + item.Person.LName
});
}
model.ValuesT = itemsT;
// Drop Down List For Courses
model.CoursesList = (from c in ctx.CoursesLists select c).ToList();
List <SelectListItem> itemsC = new List <SelectListItem>();
foreach (var item in model.CoursesList)
{
itemsC.Add(new SelectListItem {
Value = item.ID.ToString(), Text = item.Name
});
}
model.ValuesC = itemsC;
// Drop Down List For Classes
model.ClassList = (from t in ctx.ClassRooms select t).ToList();
List <SelectListItem> itemsCl = new List <SelectListItem>();
foreach (var item in model.ClassList)
{
itemsCl.Add(new SelectListItem {
Value = item.ID.ToString(), Text = item.ClassNumber
});
}
model.ValuesCl = itemsCl;
//END
}
return(View(model));
}
