public ActionResult DeleteSector(int PrimaryID)
{
Tbl_FMSector_Sector sector = (from a in BOSSDB.Tbl_FMSector_Sector where a.SectorID == PrimaryID select a).FirstOrDefault();
Tbl_FMSector_SubSector subSector = (from a in BOSSDB.Tbl_FMSector_SubSector where a.SectorID == PrimaryID select a).FirstOrDefault();
Tbl_FMRes_Department dept = (from e in BOSSDB.Tbl_FMRes_Department where e.SectorID == PrimaryID select e).FirstOrDefault();
Tbl_FMRes_Function func = (from e in BOSSDB.Tbl_FMRes_Function where e.SectorID == PrimaryID select e).FirstOrDefault();
var confirmDelete = "";
if (sector != null)
{
if (dept != null || func != null)
{
confirmDelete = "restricted";
}
else if (subSector != null)
{
confirmDelete = "true";
}
else
{
confirmDelete = "false";
}
}
var result = new { confirmDelete = confirmDelete };
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult ConfirmDeleteSubFund(int PrimaryID)
{
Tbl_FMSector_SubSector subsector = (from a in BOSSDB.Tbl_FMSector_SubSector where a.SubSectorID == PrimaryID select a).FirstOrDefault();
BOSSDB.Tbl_FMSector_SubSector.Remove(subsector);
BOSSDB.SaveChanges();
var result = "";
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult SaveSubSector(SubSectorModel model)
{
var isExist = "";
if (ModelState.IsValid)
{
var SubSectorTitle = model.SubSectorList.SubSectorTitle;
//SubSectorTitle = Regex.Replace(SubSectorTitle, @"\s\s+", "");
////SubSectorTitle = Regex.Replace(SubSectorTitle, @"^\s+", "");
////SubSectorTitle = Regex.Replace(SubSectorTitle, @"\s+$", "");
SubSectorTitle = new CultureInfo("en-US").TextInfo.ToTitleCase(SubSectorTitle);
Tbl_FMSector_SubSector checksubSector = (from a in BOSSDB.Tbl_FMSector_SubSector where (a.SubSectorTitle == SubSectorTitle || a.SubSectorCode == model.SubSectorList.SubSectorCode) select a).FirstOrDefault();
if (model.ActionID == 1)
{
if (checksubSector == null)
{
Tbl_FMSector_SubSector subSector = new Tbl_FMSector_SubSector();
subSector.SectorID = model.SubSectorList.SectorID;
subSector.SubSectorTitle = SubSectorTitle;
subSector.SubSectorCode = model.SubSectorList.SubSectorCode;
BOSSDB.Tbl_FMSector_SubSector.Add(subSector);
BOSSDB.SaveChanges();
isExist = "false";
}
else if (checksubSector != null)
{
isExist = "true";
}
}
else if (model.ActionID == 2)
{
Tbl_FMSector_SubSector subSector = (from a in BOSSDB.Tbl_FMSector_SubSector where a.SubSectorID == model.SubSectorList.SubSectorID select a).FirstOrDefault();
if (checksubSector != null)
{
if (subSector.SubSectorTitle == SubSectorTitle && subSector.SubSectorCode == model.SubSectorList.SubSectorCode) //walang binago
{
subSector.SectorID = model.SubSectorList.SectorID;
subSector.SubSectorTitle = SubSectorTitle;
subSector.SubSectorCode = model.SubSectorList.SubSectorCode;
BOSSDB.Entry(subSector);
BOSSDB.SaveChanges();
isExist = "justUpdate";
}
else
{
isExist = "true";
}
}
else if (checksubSector == null)
{
subSector.SectorID = model.SubSectorList.SectorID;
subSector.SubSectorTitle = SubSectorTitle;
subSector.SubSectorCode = model.SubSectorList.SubSectorCode;
BOSSDB.Entry(subSector);
BOSSDB.SaveChanges();
isExist = "justUpdate";
}
}
}
return(new JsonResult()
{
JsonRequestBehavior = JsonRequestBehavior.AllowGet,
Data = new { isExist = isExist }
});
}
