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 ConfirmDelete(int PrimaryID)
{
Tbl_FMFund_Fund fund = (from a in BOSSDB.Tbl_FMFund_Fund where a.FundID == PrimaryID select a).FirstOrDefault();
BOSSDB.Tbl_FMFund_Fund.Remove(fund);
BOSSDB.SaveChanges();
var result = "";
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult SaveFund(FundModel model)
{
var isExist = "";
if (ModelState.IsValid)
{
var fundTitle = model.FundList.FundTitle;
fundTitle = new CultureInfo("en-US").TextInfo.ToTitleCase(fundTitle);
Tbl_FMFund_Fund checkFund = (from a in BOSSDB.Tbl_FMFund_Fund where (a.FundTitle == fundTitle || a.FundCode == model.FundList.FundCode) select a).FirstOrDefault();
if (model.ActionID == 1)
{
if (checkFund == null)
{
Tbl_FMFund_Fund fund = new Tbl_FMFund_Fund();
fund.FundTitle = fundTitle;
fund.FundCode = model.FundList.FundCode;
BOSSDB.Tbl_FMFund_Fund.Add(fund);
BOSSDB.SaveChanges();
isExist = "false";
}
else if (checkFund != null)
{
isExist = "true";
}
}
else if (model.ActionID == 2)
{
Tbl_FMFund_Fund fund = (from a in BOSSDB.Tbl_FMFund_Fund where a.FundID == model.FundList.FundID select a).FirstOrDefault();
List <Tbl_FMFund_Fund> fundTitlelist = (from e in BOSSDB.Tbl_FMFund_Fund where e.FundTitle == fundTitle select e).ToList();
List <Tbl_FMFund_Fund> fundCode = (from e in BOSSDB.Tbl_FMFund_Fund where e.FundCode == model.FundList.FundCode select e).ToList();
if (checkFund != null)
{
if (fund.FundTitle == fundTitle && fund.FundCode == model.FundList.FundCode)
{
fund.FundTitle = fundTitle;
fund.FundCode = model.FundList.FundCode;
BOSSDB.Entry(fund);
BOSSDB.SaveChanges();
isExist = "justUpdate";
}
else
{
if (fund.FundTitle != fundTitle && fundTitlelist.Count >= 1 || fund.FundCode != model.FundList.FundCode && fundCode.Count >= 1)
{
isExist = "true";
}
else
{
fund.FundTitle = fundTitle;
fund.FundCode = model.FundList.FundCode;
BOSSDB.Entry(fund);
BOSSDB.SaveChanges();
isExist = "justUpdate";
}
}
}
else if (checkFund == null)
{
fund.FundTitle = fundTitle;
fund.FundCode = model.FundList.FundCode;
BOSSDB.Entry(fund);
BOSSDB.SaveChanges();
isExist = "justUpdate";
}
}
}
return(new JsonResult()
{
JsonRequestBehavior = JsonRequestBehavior.AllowGet,
Data = new { isExist = isExist }
});
}
