//Add Check Maintenance public JsonResult AddCheckMaintenance(FM_Disbursement_CheckMaintenance model) { CheckMaintenanceTable tblCheckMaintenance = new CheckMaintenanceTable(); tblCheckMaintenance.CheckInvntID = model.CheckMaintenanceInventoryID; tblCheckMaintenance.DateIssued = model.getCheckMaintenancecolumns.DateIssued; tblCheckMaintenance.ConsumedValue = model.CheckMaintenanceQuantityID; TOSSDB.CheckMaintenanceTables.Add(tblCheckMaintenance); TOSSDB.SaveChanges(); CheckInventoryTable tblAccountablechkInventory = (from e in TOSSDB.CheckInventoryTables where e.CheckInvntID == model.CheckMaintenanceInventoryID select e).FirstOrDefault(); if (tblAccountablechkInventory.IsIssued == false) { tblAccountablechkInventory.IsIssued = true; } else { tblAccountablechkInventory.IsIssued = false; } TOSSDB.Entry(tblAccountablechkInventory); TOSSDB.SaveChanges(); return(Json("")); }
public FM_Disbursement_CheckMaintenance() { getCheckMaintenanceType = new List <CheckMaintenanceTable>(); getCheckMaintenancecolumns = new CheckMaintenanceTable(); getCheckMaintenanceList = new List <CheckMaintenanceList>(); globalClasses = new GlobalClasses(); }
//Get Update Check Maintenance public ActionResult Get_UpdateCheckMaintenance(FM_Disbursement_CheckMaintenance model, int CheckMainteID) { CheckMaintenanceTable tblCheckMaintenance = (from e in TOSSDB.CheckMaintenanceTables where e.CheckMainteID == CheckMainteID select e).FirstOrDefault(); model.getCheckMaintenancecolumns.CheckMainteID = tblCheckMaintenance.CheckMainteID; model.CheckMaintenanceBankIDTemp = tblCheckMaintenance.CheckInvntID; return(PartialView("CheckMaintenance/_UpdateCheckMaintenance", model)); }
//Update Check Maintenance //Delete Check Maintenance public ActionResult DeleteCheckMaintenance(FM_Disbursement_CheckMaintenance model, int CheckMainteID) { CheckMaintenanceTable tblCheckMaintenance = (from e in TOSSDB.CheckMaintenanceTables where e.CheckMainteID == CheckMainteID select e).FirstOrDefault(); TOSSDB.CheckMaintenanceTables.Remove(tblCheckMaintenance); TOSSDB.SaveChanges(); CheckInventoryTable tblAccountablechkInventory = (from e in TOSSDB.CheckInventoryTables where e.IsIssued == true select e).FirstOrDefault(); if (tblAccountablechkInventory.IsIssued == true) { tblAccountablechkInventory.IsIssued = false; } else { tblAccountablechkInventory.IsIssued = true; } TOSSDB.Entry(tblAccountablechkInventory); TOSSDB.SaveChanges(); return(RedirectToAction("Index")); }