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");
}
/// <summary>
/// Deprecated Method for adding a new object to the Laboratory_Room EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToLaboratory_Room(Laboratory_Room laboratory_Room)
{
base.AddObject("Laboratory_Room", laboratory_Room);
}
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");
}
/// <summary>
/// Create a new Laboratory_Room object.
/// </summary>
/// <param name="laboratory_RoomId">Initial value of the Laboratory_RoomId property.</param>
/// <param name="laboratoryId">Initial value of the LaboratoryId property.</param>
/// <param name="roomId">Initial value of the RoomId property.</param>
public static Laboratory_Room CreateLaboratory_Room(global::System.Int32 laboratory_RoomId, global::System.Int32 laboratoryId, global::System.Int32 roomId)
{
Laboratory_Room laboratory_Room = new Laboratory_Room();
laboratory_Room.Laboratory_RoomId = laboratory_RoomId;
laboratory_Room.LaboratoryId = laboratoryId;
laboratory_Room.RoomId = roomId;
return laboratory_Room;
}
