示例#1
0
        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 });
        }
示例#2
0
 /// <summary>
 /// Deprecated Method for adding a new object to the Dispenses EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
 /// </summary>
 public void AddToDispenses(Dispense dispense)
 {
     base.AddObject("Dispenses", dispense);
 }
示例#3
0
        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");
        }
示例#4
0
 /// <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;
 }