public ActionResult EditSked(int SkedId)
{
try
{
//get class schedule
var a = (from y in con.Classes
where y.ClassId == SkedId
select y).FirstOrDefault();
itmmSchedule b = new itmmSchedule();
b.GroupNo = a.GroupNo;
b.CourseCode = a.CourseCode;
b.CourseDesc = a.CourseDescription;
b.Day = a.Day;
b.Schedule = a.Schedule;
b.Instructor = a.Instructor;
b.AvailableTable = Convert.ToInt32(a.AvailableTable);
int labid = getLabId();
//room list exclusive per lab
var x = from y in con.Laboratory_Room
where y.LaboratoryId == labid
orderby y.Room.RoomName
select y.Room;
ViewBag.RoomList = x;
return(View(b));
}catch (Exception) {
return(RedirectToAction("Schedule"));
}
}
public ActionResult Schedule(itmmSchedule a, string room)
{
Class b = new Class();
b.GroupNo = a.GroupNo;
b.CourseCode = a.CourseCode;
b.CourseDescription = a.CourseDesc;
b.Day = a.Day;
b.Schedule = a.Schedule;
b.Instructor = a.Instructor;
b.AvailableTable = a.AvailableTable;
b.Room = room;
b.LabId = getLabId();
for (int i = 1; i <= a.AvailableTable; i++)
{
Table c = new Table();
c.ClassId = b.ClassId;
c.TableNo = i;
con.AddToTables(c);
}
con.AddToClasses(b);
con.SaveChanges();
return(RedirectToAction("Schedule"));
}
public ActionResult EditSked(itmmSchedule a, string room, int SkedId)
{
var b = (from y in con.Classes
where y.ClassId == SkedId
select y).FirstOrDefault();
b.GroupNo = a.GroupNo;
b.CourseCode = a.CourseCode;
b.CourseDescription = a.CourseDesc;
b.Day = a.Day;
b.Schedule = a.Schedule;
b.Instructor = a.Instructor;
b.Room = room;
b.AvailableTable = a.AvailableTable;
con.SaveChanges();
return(RedirectToAction("Schedule"));
}
public ActionResult EditSked(itmmSchedule a, string room, int SkedId, int AvailableTable, string[] Days)
{
var b = (from y in con.Classes
where y.ClassId == SkedId
select y).FirstOrDefault();
b.GroupNo = a.GroupNo;
b.CourseCode = a.CourseCode;
b.CourseDescription = a.CourseDesc;
// b.Day = a.Day;
b.Day = FormatDays(Days);
b.Schedule = a.Schedule;
b.Instructor = a.Instructor;
b.Room = room;
b.AvailableTable = AvailableTable;
// 1. delete added tables
var x = from y in con.Tables
where y.ClassId == SkedId
select y;
foreach (var obj in x)
{
con.DeleteObject(obj);
}
// 2. adding tables again
int lastInsertedClassId = b.ClassId;
for (int i = 1; i <= AvailableTable; i++)
{
Table c = new Table();
c.ClassId = lastInsertedClassId;
c.TableNo = i;
con.AddToTables(c);
}
con.SaveChanges();
return(RedirectToAction("Schedule"));
}
