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 DeleteSubFund(int SubFundID) { Tbl_FMFund_SubFund subFundOne = (from a in BOSSDB.Tbl_FMFund_SubFund where a.SubFundID == SubFundID select a).FirstOrDefault(); BOSSDB.Tbl_FMFund_SubFund.Remove(subFundOne); BOSSDB.SaveChanges(); var result = ""; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult SaveSubFund(SubFundModel model) { var isExist = ""; if (ModelState.IsValid) { var subfundTitle = model.SubFundList.SubFundTitle; subfundTitle = new CultureInfo("en-US").TextInfo.ToTitleCase(subfundTitle); Tbl_FMFund_SubFund checksubFund = (from a in BOSSDB.Tbl_FMFund_SubFund where (a.SubFundTitle == model.SubFundList.SubFundTitle) select a).FirstOrDefault(); if (model.ActionID == 1) { if (checksubFund == null) { Tbl_FMFund_SubFund sfund = new Tbl_FMFund_SubFund(); sfund.SubFundTitle = subfundTitle; sfund.FundID = model.SubFundList.FundID; BOSSDB.Tbl_FMFund_SubFund.Add(sfund); BOSSDB.SaveChanges(); isExist = "false"; } else if (checksubFund != null) { isExist = "true"; } } else if (model.ActionID == 2) { Tbl_FMFund_SubFund subfund = (from a in BOSSDB.Tbl_FMFund_SubFund where a.SubFundID == model.SubFundList.SubFundID select a).FirstOrDefault(); List <Tbl_FMFund_SubFund> subfundTitlelist = (from e in BOSSDB.Tbl_FMFund_SubFund where e.SubFundTitle == subfundTitle select e).ToList(); if (checksubFund != null) { if (subfund.SubFundTitle == subfundTitle && subfund.SubFundID == model.SubFundList.SubFundID && subfund.FundID == model.SubFundList.FundID) { subfund.SubFundTitle = subfundTitle; subfund.FundID = GlobalFunction.ReturnEmptyInt(model.SubFundList.FundID); BOSSDB.Entry(subfund); BOSSDB.SaveChanges(); isExist = "justUpdate"; } else { if (subfund.SubFundTitle != subfundTitle && subfundTitlelist.Count >= 1) { isExist = "true"; } else { subfund.SubFundTitle = subfundTitle; subfund.FundID = GlobalFunction.ReturnEmptyInt(model.SubFundList.FundID); BOSSDB.Entry(subfund); BOSSDB.SaveChanges(); isExist = "justUpdate"; } } } else if (checksubFund == null) { subfund.SubFundTitle = subfundTitle; subfund.FundID = model.SubFundList.FundID; BOSSDB.Entry(subfund); BOSSDB.SaveChanges(); isExist = "justUpdate"; } } } return(new JsonResult() { JsonRequestBehavior = JsonRequestBehavior.AllowGet, Data = new { isExist = isExist } }); }