public ActionResult DeleteAppropSource(int AppropriationID) { Tbl_FMApprop_AppropriationSource ASource = (from a in BOSSDB.Tbl_FMApprop_AppropriationSource where a.AppropriationID == AppropriationID select a).FirstOrDefault(); BOSSDB.Tbl_FMApprop_AppropriationSource.Remove(ASource); BOSSDB.SaveChanges(); var result = ""; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult SaveAppropSource(AppropSourceModel model) { var isExist = ""; if (ModelState.IsValid) { var appropDesc = model.AppropSourceList.Description; appropDesc = Regex.Replace(appropDesc, @"\s\s+", ""); appropDesc = Regex.Replace(appropDesc, @"^\s+", ""); appropDesc = Regex.Replace(appropDesc, @"\s+$", ""); appropDesc = new CultureInfo("en-US").TextInfo.ToTitleCase(appropDesc); Tbl_FMApprop_AppropriationSource checkApprop = (from a in BOSSDB.Tbl_FMApprop_AppropriationSource where (a.Description == model.AppropSourceList.Description) select a).FirstOrDefault(); if (model.ActionID == 1) { if (checkApprop == null) { Tbl_FMApprop_AppropriationSource appropS = new Tbl_FMApprop_AppropriationSource(); appropS.Description = appropDesc; appropS.FundSourceID = model.FundSourceID; appropS.BudgetYearID = model.BudgetYearID; BOSSDB.Tbl_FMApprop_AppropriationSource.Add(appropS); BOSSDB.SaveChanges(); isExist = "false"; } else if (checkApprop != null) { isExist = "true"; } } else if (model.ActionID == 2) { Tbl_FMApprop_AppropriationSource approp = (from a in BOSSDB.Tbl_FMApprop_AppropriationSource where a.AppropriationID == model.AppropSourceList.AppropriationID select a).FirstOrDefault(); List <Tbl_FMApprop_AppropriationSource> appropDescription = (from e in BOSSDB.Tbl_FMApprop_AppropriationSource where e.Description == appropDesc select e).ToList(); if (checkApprop != null) { if (approp.Description == appropDesc) { isExist = "justUpdate"; } else { if (approp.Description != appropDesc && appropDescription.Count >= 1) { isExist = "true"; } else { isExist = "justUpdate"; } } } else if (checkApprop == null) { isExist = "justUpdate"; } if (isExist == "justUpdate") { approp.Description = appropDesc; approp.FundSourceID = model.FundSourceID; approp.BudgetYearID = model.BudgetYearID; BOSSDB.Entry(approp); BOSSDB.SaveChanges(); } } } return(new JsonResult() { JsonRequestBehavior = JsonRequestBehavior.AllowGet, Data = new { isExist = isExist } }); }