public ActionResult ConfirmDelete(int PrimaryID)
{
Tbl_FMSignatory signatorii = (from a in BOSSDB.Tbl_FMSignatory where a.SignatoryID == PrimaryID select a).FirstOrDefault();
BOSSDB.Tbl_FMSignatory.Remove(signatorii);
BOSSDB.SaveChanges();
var result = "";
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteSignatory(int PrimaryID)
{
Tbl_FMSignatory signatoryTbl = (from a in BOSSDB.Tbl_FMSignatory where a.SignatoryID == PrimaryID select a).FirstOrDefault();
var confirmDelete = "";
if (signatoryTbl != null)
{
confirmDelete = "false";
}
var result = new { confirmDelete = confirmDelete };
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult DeletePosition(int PrimaryID)
{
Tbl_FMPosition poss = (from a in BOSSDB.Tbl_FMPosition where a.PositionID == PrimaryID select a).FirstOrDefault();
Tbl_FMSignatory sign = (from e in BOSSDB.Tbl_FMSignatory where e.PositionID == PrimaryID select e).FirstOrDefault();
var confirmDelete = "";
if (poss != null)
{
if (sign != null)
{
confirmDelete = "restricted";
}
else
{
confirmDelete = "false";
}
}
var result = new { confirmDelete = confirmDelete };
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult SaveSignatory(SignatoryModel model)
{
var isExist = "";
if (ModelState.IsValid)
{
var SigName = model.SignatoryList.SignatoryName;
SigName = Regex.Replace(SigName, @"\s\s+", "");
SigName = Regex.Replace(SigName, @"^\s+", "");
SigName = Regex.Replace(SigName, @"\s+$", "");
SigName = new CultureInfo("en-US").TextInfo.ToTitleCase(SigName);
Tbl_FMSignatory checkSig = (from a in BOSSDB.Tbl_FMSignatory where (a.SignatoryName == SigName) select a).FirstOrDefault();
if (model.ActionID == 1)
{
if (checkSig == null)
{
Tbl_FMSignatory signatori = new Tbl_FMSignatory();
signatori.SignatoryName = SigName;
signatori.PreferredName = model.SignatoryList.PreferredName;
signatori.PositionID = model.PositionID;
signatori.FunctionID = model.FunctionID;
signatori.Division = model.SignatoryList.Division;
signatori.isHead = model.SignatoryList.isHead;
signatori.isActive = model.SignatoryList.isActive;
BOSSDB.Tbl_FMSignatory.Add(signatori);
BOSSDB.SaveChanges();
isExist = "false";
}
else if (checkSig != null)
{
isExist = "true";
}
}
else if (model.ActionID == 2)
{
Tbl_FMSignatory signa = (from a in BOSSDB.Tbl_FMSignatory where a.SignatoryID == model.SignatoryList.SignatoryID select a).FirstOrDefault();
List <Tbl_FMSignatory> signatoriiName = (from e in BOSSDB.Tbl_FMSignatory where e.SignatoryName == SigName select e).ToList();
List <Tbl_FMSignatory> signatoriiPref = (from e in BOSSDB.Tbl_FMSignatory where e.PreferredName == model.SignatoryList.PreferredName select e).ToList();
if (checkSig != null)
{
if (signa.SignatoryName == SigName && signa.PreferredName == model.SignatoryList.PreferredName && signa.PositionID == model.PositionID)
{
isExist = "justUpdate";
}
else
{
if (signa.SignatoryName != SigName && signatoriiName.Count >= 1 || signa.PreferredName != SigName && signatoriiPref.Count >= 1)
{
isExist = "true";
}
else
{
isExist = "justUpdate";
}
}
}
else if (checkSig == null)
{
isExist = "justUpdate";
}
if (isExist == "justUpdate")
{
signa.SignatoryName = SigName;
signa.PreferredName = model.SignatoryList.PreferredName;
signa.PositionID = model.PositionID;
signa.FunctionID = model.FunctionID;
signa.Division = model.SignatoryList.Division;
signa.isHead = model.SignatoryList.isHead;
signa.isActive = model.SignatoryList.isActive;
BOSSDB.Entry(signa);
BOSSDB.SaveChanges();
}
}
}
return(new JsonResult()
{
JsonRequestBehavior = JsonRequestBehavior.AllowGet,
Data = new { isExist = isExist }
});
}
