public ActionResult GetSectionForm(int ActionID, int SectionID)
{
SectionModel model = new SectionModel();
if (ActionID == 2)
{
Tbl_FMRes_Section sectionTbl = (from a in BOSSDB.Tbl_FMRes_Section where a.SectionID == SectionID select a).FirstOrDefault();
model.SectionList.SectionTitle = sectionTbl.SectionTitle;
model.SectionList.FunctionID = GlobalFunction.ReturnEmptyInt(sectionTbl.FunctionID);
model.SectionList.DeptID = GlobalFunction.ReturnEmptyInt(sectionTbl.Tbl_FMRes_Function.Tbl_FMRes_Department.DeptID);
model.SectionList.SectionID = sectionTbl.SectionID;
var functionList = (from a in BOSSDB.Tbl_FMRes_Function where a.DeptID == model.SectionList.DeptID orderby a.FunctionTitle select a).ToList();
model.FunctionList = new SelectList(functionList, "FunctionID", "FunctionTitle");
}
else
{
model.SectionList.DeptID = (from a in BOSSDB.Tbl_FMRes_Department orderby a.DeptTitle select a.DeptID).FirstOrDefault();
var functionList = (from a in BOSSDB.Tbl_FMRes_Function where a.DeptID == model.SectionList.DeptID orderby a.FunctionTitle select a).ToList();
model.FunctionList = new SelectList(functionList, "FunctionID", "FunctionTitle");
}
model.DeptList = new SelectList(BOSSDB.Tbl_FMRes_Department, "DeptID", "DeptTitle");
model.DeptList = (from li in model.DeptList orderby li.Text select li).ToList();
model.ActionID = ActionID;
return(PartialView("SectionTab/_SectionForm", model));
}
public ActionResult ConfirmDeleteSection(int PrimaryID)
{
Tbl_FMRes_Section section = (from a in BOSSDB.Tbl_FMRes_Section where a.SectionID == PrimaryID select a).FirstOrDefault();
BOSSDB.Tbl_FMRes_Section.Remove(section);
BOSSDB.SaveChanges();
var result = "";
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteFunction(int PrimaryID)
{
Tbl_FMRes_Function functionTbl = (from a in BOSSDB.Tbl_FMRes_Function where a.FunctionID == PrimaryID select a).FirstOrDefault();
Tbl_FMRes_Section sectionRecord = (from a in BOSSDB.Tbl_FMRes_Section where a.FunctionID == PrimaryID select a).FirstOrDefault();
var confirmDelete = "";
if (functionTbl != null)
{
if (sectionRecord != null)
{
confirmDelete = "restricted";
}
else
{
confirmDelete = "false";
}
}
var result = new { confirmDelete = confirmDelete };
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteSection(int PrimaryID)
{
Tbl_FMRes_Section section = (from a in BOSSDB.Tbl_FMRes_Section where a.SectionID == PrimaryID select a).FirstOrDefault();
//Tbl_FMRes_Section sectionRecord = (from a in BOSSDB.Tbl_FMRes_Section where a.FunctionID == PrimaryID select a).FirstOrDefault();
var confirmDelete = "";
if (section != null)
{
//if (sectionRecord != null)
//{
// confirmDelete = "restricted";
//}
//else
//{
// confirmDelete = "false";
//}
confirmDelete = "false";
}
var result = new { confirmDelete = confirmDelete };
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult SaveSection(SectionModel model)
{
var isExist = "";
if (ModelState.IsValid)
{
var SectionTitle = GlobalFunction.RemoveSpaces(model.SectionList.SectionTitle);
var FunctionID = model.SectionList.FunctionID;
var SectionID = model.SectionList.SectionID;
var DeptID = model.SectionList.DeptID;
List <Tbl_FMRes_Section> sectionList = (from a in BOSSDB.Tbl_FMRes_Section where (a.FunctionID == FunctionID && a.Tbl_FMRes_Function.DeptID == DeptID) select a).ToList();
Tbl_FMRes_Section sectionRecord = (from a in BOSSDB.Tbl_FMRes_Section where a.SectionID == SectionID select a).FirstOrDefault();
var save = false;
if (sectionList.Count > 0)
{
foreach (var item in sectionList)
{
if (sectionRecord != null)
{
if (GlobalFunction.AutoCaps_RemoveSpaces(item.SectionTitle) == GlobalFunction.AutoCaps_RemoveSpaces(SectionTitle) && item.SectionID == sectionRecord.SectionID) // walang binago
{
save = true;
}
else if (GlobalFunction.AutoCaps_RemoveSpaces(item.SectionTitle) != GlobalFunction.AutoCaps_RemoveSpaces(SectionTitle) || item.SectionID == sectionRecord.SectionID) // may binago pero walang kaparehas
{
save = true;
}
else if (GlobalFunction.AutoCaps_RemoveSpaces(item.SectionTitle) == GlobalFunction.AutoCaps_RemoveSpaces(SectionTitle)) // may binago pero may kaparehas
{
save = false;
break;
}
}
else
{
if (GlobalFunction.AutoCaps_RemoveSpaces(item.SectionTitle) != GlobalFunction.AutoCaps_RemoveSpaces(SectionTitle)) // for adding
{
save = true;
}
else
{
save = false;
break;
}
}
}
}
else
{
save = true;
}
switch (save)
{
case true:
switch (model.ActionID)
{
case 1:
Tbl_FMRes_Section sectionAdd = new Tbl_FMRes_Section();
sectionAdd.SectionTitle = SectionTitle;
sectionAdd.FunctionID = FunctionID;
BOSSDB.Tbl_FMRes_Section.Add(sectionAdd);
BOSSDB.SaveChanges();
isExist = "false";
break;
case 2:
sectionRecord.SectionTitle = SectionTitle;
sectionRecord.FunctionID = FunctionID;
BOSSDB.Entry(sectionRecord);
BOSSDB.SaveChanges();
isExist = "justUpdate";
break;
}
break;
default:
isExist = "true";
break;
}
}
return(new JsonResult()
{
JsonRequestBehavior = JsonRequestBehavior.AllowGet,
Data = new { isExist = isExist }
});
}
