//Delete Signature Table public ActionResult DeleteSignature(FM_SignatoriesModel model, int SignatoriesID) { SignatoriesTable tblSignatories = (from e in TOSSDB.SignatoriesTables where e.SignatoriesID == SignatoriesID select e).FirstOrDefault(); TOSSDB.SignatoriesTables.Remove(tblSignatories); TOSSDB.SaveChanges(); return(RedirectToAction("Index")); }
//Get Signature Data public ActionResult Get_UpdateSignatories(FM_SignatoriesModel model, int SignatoriesID) { SignatoriesTable tblSignatories = (from e in TOSSDB.SignatoriesTables where e.SignatoriesID == SignatoriesID select e).FirstOrDefault(); model.getSignatoriesColumns.SignatoriesID = tblSignatories.SignatoriesID; model.getSignatoriesColumns.SignatoriesName = tblSignatories.SignatoriesName; model.DepartmentTempID = tblSignatories.DepartmentID; model.PositionTempID = tblSignatories.PositionID; model.isDeptHeads = tblSignatories.IsDeptHead; return(PartialView("_SignatoriesUpdate", model)); }
//Update Signature Data public ActionResult UpdateSignatories(FM_SignatoriesModel model) { SignatoriesTable tblSignatories = (from e in TOSSDB.SignatoriesTables where e.SignatoriesID == model.getSignatoriesColumns.SignatoriesID select e).FirstOrDefault(); tblSignatories.SignatoriesName = model.getSignatoriesColumns.SignatoriesName; tblSignatories.PositionID = model.PositionID; tblSignatories.DepartmentID = model.DepartmentID; tblSignatories.IsDeptHead = model.isDeptHeads; TOSSDB.Entry(tblSignatories); TOSSDB.SaveChanges(); return(PartialView("_SignatoriesUpdate", model)); }
//Add Signatories public JsonResult AddSignatories(FM_SignatoriesModel model) { SignatoriesTable tblSignatories = new SignatoriesTable(); tblSignatories.SignatoriesName = GlobalFunction.ReturnEmptyString(model.getSignatoriesColumns.SignatoriesName); tblSignatories.PositionID = GlobalFunction.ReturnEmptyInt(model.PositionID); tblSignatories.DepartmentID = GlobalFunction.ReturnEmptyInt(model.DepartmentID); tblSignatories.IsDeptHead = GlobalFunction.ReturnEmptyBool(model.isDeptHeads); TOSSDB.SignatoriesTables.Add(tblSignatories); TOSSDB.SaveChanges(); return(Json(tblSignatories)); }
//Update Signature Data public ActionResult UpdateSignatories(FM_SignatoriesModel model) { SignatoriesTable tblSignatories = (from e in TOSSDB.SignatoriesTables where e.SignatoriesID == model.getSignatoriesColumns.SignatoriesID select e).FirstOrDefault(); tblSignatories.SignatoriesName = GlobalFunction.ReturnEmptyString(model.getSignatoriesColumns.SignatoriesName); tblSignatories.PreferredName = GlobalFunction.ReturnEmptyString(model.getSignatoriesColumns.PreferredName); tblSignatories.PositionID = GlobalFunction.ReturnEmptyInt(model.PositionID); tblSignatories.DepartmentID = GlobalFunction.ReturnEmptyInt(model.DepartmentID); tblSignatories.IsDeptHead = GlobalFunction.ReturnEmptyBool(model.isDeptHeads); tblSignatories.FunctionID = GlobalFunction.ReturnEmptyInt(model.FunctionID); tblSignatories.DivisionName = GlobalFunction.ReturnEmptyString(model.getSignatoriesColumns.DivisionName); tblSignatories.isActive = GlobalFunction.ReturnEmptyBool(model.isActive); TOSSDB.Entry(tblSignatories); TOSSDB.SaveChanges(); return(PartialView("_SignatoriesUpdate", model)); }