public ActionResult Index(string LabName, string LabDesc, int[] room, string LabNum)
{
Laboratory f = new Laboratory();
f.LaboratoryName = LabName;
f.LaboratoryDesc = LabDesc;
f.LaboratoryContact = LabNum;
con.AddToLaboratories(f);
con.SaveChanges();
if (room != null)
{
foreach (var Room in room)
{
Laboratory_Room a = new Laboratory_Room();
a.LaboratoryId = f.LaboratoryId;
var x = (from y in con.Rooms
where y.RoomId == Room
select y.RoomId).FirstOrDefault();
a.RoomId = x;
con.AddToLaboratory_Room(a);
con.SaveChanges();
}
}
return(RedirectToAction("Index", "Admin"));
}
public ActionResult Laboratory(itmmLaboratory model, int[] room)
{
Laboratory f = new Laboratory();
f.LaboratoryName = model.labname;
f.LaboratoryDesc = model.labdesc;
f.LaboratoryContact = model.labcontact;
f.inactive = 0;
con.AddToLaboratories(f);
con.SaveChanges();
if (room != null)
{
foreach (var Room in room)
{
Laboratory_Room a = new Laboratory_Room();
a.LaboratoryId = f.LaboratoryId;
var x = (from y in con.Rooms
where y.RoomId == Room
select y.RoomId).FirstOrDefault();
a.RoomId = x;
con.AddToLaboratory_Room(a);
con.SaveChanges();
}
}
return(RedirectToAction("Laboratory", "AdminBold"));
}
public ActionResult EditLaboratory(itmmLaboratory model, int[] room)
{
// get lab object
var x = (from y in con.Laboratories
where y.LaboratoryId == model.labid
select y).FirstOrDefault();
// get all rooms linked to the lab
var z = from y in con.Laboratory_Room
where y.LaboratoryId == model.labid
select y;
x.LaboratoryName = model.labname;
x.LaboratoryDesc = model.labdesc;
x.LaboratoryContact = model.labcontact;
foreach (var _z in z)
{
con.DeleteObject(_z);
}
try
{
foreach (var _room in room)
{
Laboratory_Room a = new Laboratory_Room();
var c = (from y in con.Rooms
where y.RoomId == _room
select y.RoomId).FirstOrDefault();
a.RoomId = c;
a.LaboratoryId = model.labid;
con.AddToLaboratory_Room(a);
}
}
catch (Exception) { }
con.SaveChanges();
return(RedirectToAction("Laboratory", "AdminBold"));
}
public ActionResult EditLab(int LabId, string LabName, string LabDesc, int[] room, string LabNum)
{
var x = (from y in con.Laboratories
where y.LaboratoryId == LabId
select y).FirstOrDefault();
var z = from y in con.Laboratory_Room
where y.LaboratoryId == LabId
select y;
x.LaboratoryName = LabName;
x.LaboratoryDesc = LabDesc;
x.LaboratoryContact = LabNum;
foreach (var _z in z)
{
con.DeleteObject(_z);
}
try
{
foreach (var _room in room)
{
Laboratory_Room a = new Laboratory_Room();
var c = (from y in con.Rooms
where y.RoomId == _room
select y.RoomId).FirstOrDefault();
a.RoomId = c;
a.LaboratoryId = LabId;
con.AddToLaboratory_Room(a);
}
}
catch (Exception) { }
con.SaveChanges();
return(RedirectToAction("Index", "Admin"));
}
