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