public ActionResult ConfirmDelete(int PrimaryID) { Tbl_FMApprop_FundSource fundSource = (from a in BOSSDB.Tbl_FMApprop_FundSource where a.FundSourceID == PrimaryID select a).FirstOrDefault(); BOSSDB.Tbl_FMApprop_FundSource.Remove(fundSource); BOSSDB.SaveChanges(); var result = ""; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult DeleteFundSource(int PrimaryID) { Tbl_FMApprop_FundSource fSource = (from a in BOSSDB.Tbl_FMApprop_FundSource where a.FundSourceID == PrimaryID select a).FirstOrDefault(); var confirmDelete = ""; if (fSource != null) { confirmDelete = "false"; } var result = new { confirmDelete = confirmDelete }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult SaveFundSource(FundSourceModel model) { var isExist = ""; if (ModelState.IsValid) { var fundsourceTitle = model.FundSourceList.FundSourceTitle; fundsourceTitle = Regex.Replace(fundsourceTitle, @"\s\s+", ""); fundsourceTitle = Regex.Replace(fundsourceTitle, @"^\s+", ""); fundsourceTitle = Regex.Replace(fundsourceTitle, @"\s+$", ""); fundsourceTitle = new CultureInfo("en-US").TextInfo.ToTitleCase(fundsourceTitle); Tbl_FMApprop_FundSource checkFundsource = (from a in BOSSDB.Tbl_FMApprop_FundSource where (a.FundSourceTitle == fundsourceTitle) select a).FirstOrDefault(); if (model.ActionID == 1) { if (checkFundsource == null) { Tbl_FMApprop_FundSource fundsource = new Tbl_FMApprop_FundSource(); fundsource.FundSourceTitle = fundsourceTitle; fundsource.AppropSourceTypeID = model.AppropSourceTypeID; BOSSDB.Tbl_FMApprop_FundSource.Add(fundsource); BOSSDB.SaveChanges(); isExist = "false"; } else if (checkFundsource != null) { isExist = "true"; } } else if (model.ActionID == 2) { Tbl_FMApprop_FundSource fundS = (from a in BOSSDB.Tbl_FMApprop_FundSource where a.FundSourceID == model.FundSourceList.FundSourceID select a).FirstOrDefault(); List <Tbl_FMApprop_FundSource> fundsourcetitle = (from e in BOSSDB.Tbl_FMApprop_FundSource where e.FundSourceTitle == fundsourceTitle select e).ToList(); if (checkFundsource != null) { if (fundS.FundSourceTitle != fundsourceTitle && fundsourcetitle.Count >= 1) { isExist = "true"; } else { fundS.FundSourceTitle = fundsourceTitle; fundS.AppropSourceTypeID = model.AppropSourceTypeID; BOSSDB.Entry(fundS); BOSSDB.SaveChanges(); isExist = "justUpdate"; } } else if (checkFundsource == null) { fundS.FundSourceTitle = fundsourceTitle; fundS.AppropSourceTypeID = model.AppropSourceTypeID; BOSSDB.Entry(fundS); BOSSDB.SaveChanges(); isExist = "justUpdate"; } } } return(new JsonResult() { JsonRequestBehavior = JsonRequestBehavior.AllowGet, Data = new { isExist = isExist } }); }