public ActionResult DeleteFund(int PrimaryID)
{
Tbl_FMFund_Fund fund = (from a in BOSSDB.Tbl_FMFund_Fund where a.FundID == PrimaryID select a).FirstOrDefault();
Tbl_FMFund_SubFund subFund = (from a in BOSSDB.Tbl_FMFund_SubFund where a.FundID == PrimaryID select a).FirstOrDefault();
Tbl_FMRes_Department dept = (from e in BOSSDB.Tbl_FMRes_Department where e.FundID == PrimaryID select e).FirstOrDefault();
var confirmDelete = "";
if (fund != null)
{
if (dept != null)
{
confirmDelete = "restricted";
}
else if (subFund != null)
{
confirmDelete = "true";
}
else
{
confirmDelete = "false";
}
}
var result = new { confirmDelete = confirmDelete };
return(Json(result, JsonRequestBehavior.AllowGet));
}
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 ConfirmDeleteDept(int PrimaryID)
{
Tbl_FMRes_Department deptTbl = (from a in BOSSDB.Tbl_FMRes_Department where a.DeptID == PrimaryID select a).FirstOrDefault();
BOSSDB.Tbl_FMRes_Department.Remove(deptTbl);
BOSSDB.SaveChanges();
var result = "";
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteDept(int PrimaryID)
{
Tbl_FMRes_Department deptTbl = (from a in BOSSDB.Tbl_FMRes_Department where a.DeptID == PrimaryID select a).FirstOrDefault();
Tbl_FMRes_Function functTbl = (from a in BOSSDB.Tbl_FMRes_Function where a.DeptID == PrimaryID select a).FirstOrDefault();
var confirmDelete = "";
if (deptTbl != null)
{
if (functTbl != null)
{
confirmDelete = "restricted";
}
else
{
confirmDelete = "false";
}
}
var result = new { confirmDelete = confirmDelete };
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteOfficeType(int PrimaryID)
{
Tbl_FMOfficeType officetype = (from a in BOSSDB.Tbl_FMOfficeType where a.OfficeTypeID == PrimaryID select a).FirstOrDefault();
Tbl_FMRes_Department dept = (from e in BOSSDB.Tbl_FMRes_Department where e.OfficeTypeID == PrimaryID select e).FirstOrDefault();
Tbl_FMRes_Function func = (from e in BOSSDB.Tbl_FMRes_Function where e.OfficeTypeID == PrimaryID select e).FirstOrDefault();
var confirmDelete = "";
if (officetype != null)
{
if (dept != null || func != null)
{
confirmDelete = "restricted";
}
else
{
confirmDelete = "false";
}
}
var result = new { confirmDelete = confirmDelete };
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult SaveDept(DepartmentModel model)
{
var isExist = "";
if (ModelState.IsValid)
{
var deptTitle = GlobalFunction.RemoveSpaces(model.DepartmentList.DeptTitle);
var deptAbbrv = GlobalFunction.RemoveSpaces(model.DepartmentList.DeptAbbrv);
var DeptOfficeCode = GlobalFunction.RemoveSpaces(model.DepartmentList.DeptOfficeCode);
var RCcode = GlobalFunction.RemoveSpaces(model.DepartmentList.RCcode);
var fundID = model.DepartmentList.FundID;
var sectorID = model.DepartmentList.SectorID;
var officeTypeID = model.DepartmentList.OfficeTypeID;
int?subSectorID = model.DepartmentList.SubSectorID;
if (subSectorID == 000 || subSectorID == 0)
{
subSectorID = null;
}
else
{
subSectorID = model.DepartmentList.SubSectorID;
}
List <Tbl_FMRes_Department> deptFields = (from a in BOSSDB.Tbl_FMRes_Department where (a.FundID == fundID && a.SectorID == sectorID) && (a.SubSectorID == subSectorID && a.OfficeTypeID == officeTypeID) select a).ToList();
Tbl_FMRes_Department deptTbl = (from a in BOSSDB.Tbl_FMRes_Department where a.DeptID == model.DepartmentList.DeptID select a).FirstOrDefault();
var save = false;
if (deptFields.Count > 0)
{
foreach (var item in deptFields)
{
if (deptTbl != null)
{
if (GlobalFunction.AutoCaps_RemoveSpaces(item.DeptTitle) == GlobalFunction.AutoCaps_RemoveSpaces(deptTitle) &&
GlobalFunction.AutoCaps_RemoveSpaces(item.DeptOfficeCode) == GlobalFunction.AutoCaps_RemoveSpaces(DeptOfficeCode) &&
item.DeptID == deptTbl.DeptID) // walang binago
{
save = true;
}
else if (GlobalFunction.AutoCaps_RemoveSpaces(item.DeptTitle) != GlobalFunction.AutoCaps_RemoveSpaces(deptTitle) &&
GlobalFunction.AutoCaps_RemoveSpaces(item.DeptOfficeCode) != GlobalFunction.AutoCaps_RemoveSpaces(DeptOfficeCode) || item.DeptID == deptTbl.DeptID) // may binago pero walang kaparehas
{
save = true;
}
else if (GlobalFunction.AutoCaps_RemoveSpaces(item.DeptTitle) == GlobalFunction.AutoCaps_RemoveSpaces(deptTitle) ||
GlobalFunction.AutoCaps_RemoveSpaces(item.DeptOfficeCode) == GlobalFunction.AutoCaps_RemoveSpaces(DeptOfficeCode)) // may binago pero may kaparehas
{
save = false;
break;
}
}
else
{
if (GlobalFunction.AutoCaps_RemoveSpaces(item.DeptTitle) != GlobalFunction.AutoCaps_RemoveSpaces(deptTitle) &&
GlobalFunction.AutoCaps_RemoveSpaces(item.DeptOfficeCode) != GlobalFunction.AutoCaps_RemoveSpaces(DeptOfficeCode)) // for adding
{
save = true;
}
else
{
save = false;
break;
}
}
}
}
else
{
save = true;
}
switch (save)
{
case true:
switch (model.ActionID)
{
case 1:
Tbl_FMRes_Department deptTblAdd = new Tbl_FMRes_Department();
deptTblAdd.DeptTitle = deptTitle;
deptTblAdd.DeptAbbrv = deptAbbrv;
deptTblAdd.DeptOfficeCode = DeptOfficeCode;
deptTblAdd.RCcode = RCcode;
deptTblAdd.FundID = fundID;
deptTblAdd.SectorID = sectorID;
deptTblAdd.SubSectorID = subSectorID;
deptTblAdd.OfficeTypeID = officeTypeID;
BOSSDB.Tbl_FMRes_Department.Add(deptTblAdd);
BOSSDB.SaveChanges();
isExist = "false";
break;
case 2:
deptTbl.DeptTitle = deptTitle;
deptTbl.DeptAbbrv = deptAbbrv;
deptTbl.DeptOfficeCode = DeptOfficeCode;
deptTbl.RCcode = RCcode;
deptTbl.FundID = fundID;
deptTbl.SectorID = sectorID;
deptTbl.SubSectorID = subSectorID;
deptTbl.OfficeTypeID = officeTypeID;
BOSSDB.Entry(deptTbl);
BOSSDB.SaveChanges();
isExist = "justUpdate";
break;
}
break;
default:
isExist = "true";
break;
}
}
return(new JsonResult()
{
JsonRequestBehavior = JsonRequestBehavior.AllowGet,
Data = new { isExist = isExist }
});
}
