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 }
});
}
