public ActionResult Fine(int TableId, int EquipmentId, int ClassId, string Barcode) { Liability a = new Liability(); a.Equipment = (from y in con.Equipments where y.EquipmentId == EquipmentId select y.Make).FirstOrDefault(); a.StudenInfotId = (from y in con.Tables where y.TableId == TableId select y.StudentId).FirstOrDefault(); a.Fine = "To be Determined"; a.Status = "Unsettled"; a.Barcode = Barcode; a.LaboratoryId = (from y in con.Classes where y.ClassId == ClassId select y.LabId).FirstOrDefault(); con.AddToLiabilities(a); Dispense b = new Dispense(); var x = (from y in con.Dispenses where y.EquipmentId == EquipmentId && y.TableId == TableId && y.ClassId == ClassId select y).FirstOrDefault(); x.Status = "liability"; con.SaveChanges(); return RedirectToAction("ViewEquipment", "Staff", new { TableId = TableId, ClassId = ClassId }); }
/// <summary> /// Deprecated Method for adding a new object to the Dispenses EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToDispenses(Dispense dispense) { base.AddObject("Dispenses", dispense); }
public ActionResult DispenseFinal(int TableId, int[] EquipmentId, int ClassId) { var labid = getLabId(); foreach (var item in EquipmentId) { Dispense a = new Dispense(); a.TableId = TableId; a.ClassId = ClassId; a.EquipmentId = item; con.AddToDispenses(a); var x = (from y in con.Laboratory_Equipment where y.Borrowed == null && y.LaboratoryId == labid && y.EquipmentId == item select y).FirstOrDefault(); x.Borrowed = 1; } con.SaveChanges(); return RedirectToAction("Dispense"); }
/// <summary> /// Create a new Dispense object. /// </summary> /// <param name="dispenseId">Initial value of the DispenseId property.</param> public static Dispense CreateDispense(global::System.Int32 dispenseId) { Dispense dispense = new Dispense(); dispense.DispenseId = dispenseId; return dispense; }