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