//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"));
}
