public ActionResult ConfirmDelete(int PrimaryID)
{
Tbl_FMPosition positionTbl = (from e in BOSSDB.Tbl_FMPosition where e.PositionID == PrimaryID select e).FirstOrDefault();
BOSSDB.Tbl_FMPosition.Remove(positionTbl);
BOSSDB.SaveChanges();
var result = "";
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 SavePosition(PositionModel model)
{
var isExist = "";
if (ModelState.IsValid)
{
var postitle = model.PositionList.PositionTitle;
postitle = new CultureInfo("en-US").TextInfo.ToTitleCase(postitle);
model.PositionList.PositionCode = new CultureInfo("en-US").TextInfo.ToUpper(model.PositionList.PositionCode);
Tbl_FMPosition checkpos = (from a in BOSSDB.Tbl_FMPosition where (a.PositionTitle == postitle || a.PositionCode == model.PositionList.PositionCode) select a).FirstOrDefault();
if (model.ActionID == 1)
{
if (checkpos == null)
{
Tbl_FMPosition position = new Tbl_FMPosition();
position.PositionTitle = postitle;
position.PositionCode = model.PositionList.PositionCode;
BOSSDB.Tbl_FMPosition.Add(position);
BOSSDB.SaveChanges();
isExist = "false";
}
else if (checkpos != null)
{
isExist = "true";
}
}
else if (model.ActionID == 2)
{
Tbl_FMPosition position = (from a in BOSSDB.Tbl_FMPosition where a.PositionID == model.PositionList.PositionID select a).FirstOrDefault();
List <Tbl_FMPosition> positiontitle = (from e in BOSSDB.Tbl_FMPosition where e.PositionTitle == postitle select e).ToList();
List <Tbl_FMPosition> positioncode = (from e in BOSSDB.Tbl_FMPosition where e.PositionCode == model.PositionList.PositionCode select e).ToList();
if (checkpos != null)
{
if (position.PositionTitle == postitle && position.PositionCode == model.PositionList.PositionCode)
{
position.PositionTitle = postitle;
position.PositionCode = model.PositionList.PositionCode;
BOSSDB.Entry(position);
BOSSDB.SaveChanges();
isExist = "justUpdate";
}
else
{
if (position.PositionTitle != postitle && positiontitle.Count >= 1 || position.PositionCode != model.PositionList.PositionCode && positioncode.Count >= 1)
{
isExist = "true";
}
else
{
position.PositionTitle = postitle;
position.PositionCode = model.PositionList.PositionCode;
BOSSDB.Entry(position);
BOSSDB.SaveChanges();
isExist = "justUpdate";
}
}
}
else if (checkpos == null)
{
position.PositionTitle = postitle;
position.PositionCode = model.PositionList.PositionCode;
BOSSDB.Entry(position);
BOSSDB.SaveChanges();
isExist = "justUpdate";
}
}
}
return(new JsonResult()
{
JsonRequestBehavior = JsonRequestBehavior.AllowGet,
Data = new { isExist = isExist }
});
}
