public ActionResult CreateAccessory(EquipmentAccessories objEquip)
{
EquipmentAccessories objNewEquip = new EquipmentAccessories();
objNewEquip.EquipID = objEquip.EquipID;
objNewEquip.AccessoryName = objEquip.AccessoryName;
objNewEquip.Manufacturer = objEquip.Manufacturer;
objNewEquip.PartNumber = objEquip.PartNumber;
objNewEquip.QuantityonHand = objEquip.QuantityonHand;
objNewEquip.SupplyQuantity = objEquip.SupplyQuantity;
objNewEquip.StatusID = 1;
objDbContext.EquipmentAccessorys.Add(objNewEquip);
objDbContext.SaveChanges();
return Json(new { data = "Success" });
}
public ActionResult EditAccessory(EquipmentAccessories objEquip)
{
EquipmentAccessories objNewEquip = (from p in objDbContext.EquipmentAccessorys
where p.AccessoryID == objEquip.AccessoryID
select p).FirstOrDefault();
objNewEquip.EquipID = objEquip.EquipID;
objNewEquip.AccessoryName = objEquip.AccessoryName;
objNewEquip.Manufacturer = objEquip.Manufacturer;
objNewEquip.PartNumber = objEquip.PartNumber;
objNewEquip.QuantityonHand = objEquip.QuantityonHand;
objNewEquip.SupplyQuantity = objEquip.SupplyQuantity;
objDbContext.SaveChanges();
return Json(new { data = "Success" });
}
public ActionResult GetEquipentAccessoryData(EquipmentAccessories objEquip)
{
var EquipmentsList = (from p in objDbContext.EquipmentAccessorys
where p.AccessoryID == objEquip.AccessoryID
select new {p.AccessoryName, p.equip.Equip_Name, p.PartNumber, p.SupplyQuantity, p.QuantityonHand, p.Manufacturer }).ToList();
return Json(EquipmentsList);
}
public ActionResult DeleteAccessory(EquipmentAccessories objEquip)
{
var USerlst = (from p in objDbContext.EquipmentAccessorys
where p.AccessoryID == objEquip.AccessoryID
select new { p.EquipID,p.AccessoryName, p.PartNumber, p.SupplyQuantity, p.QuantityonHand, p.Manufacturer, p.StatusID }).ToList()[0];
EquipmentAccessories usr = objDbContext.EquipmentAccessorys.Where(p => p.AccessoryID == objEquip.AccessoryID).First();
usr.StatusID = 2;
objDbContext.SaveChanges();
return Json(new { data = "Success" });
}