public ActionResult SaveAccntType(AccountTypeModel model)
{
var isExist = "";
if (ModelState.IsValid)
{
var accntType = model.AccntTypeList.AccntType;
Tbl_FMBank_AccountType checkAccntType = (from a in BOSSDB.Tbl_FMBank_AccountType where (a.AccntType == accntType) select a).FirstOrDefault();
if (model.ActionID == 1)
{
if (checkAccntType == null)
{
Tbl_FMBank_AccountType AT = new Tbl_FMBank_AccountType();
AT.AccntType = accntType;
BOSSDB.Tbl_FMBank_AccountType.Add(AT);
BOSSDB.SaveChanges();
isExist = "false";
}
else if (checkAccntType != null)
{
isExist = "true";
}
}
else if (model.ActionID == 2)
{
Tbl_FMBank_AccountType AType = (from a in BOSSDB.Tbl_FMBank_AccountType where a.AccntTypeID == model.AccntTypeList.AccntTypeID select a).FirstOrDefault();
List <Tbl_FMBank_AccountType> acctypeCount = (from e in BOSSDB.Tbl_FMBank_AccountType where e.AccntType == accntType select e).ToList();
if (checkAccntType != null)
{
if (AType.AccntType != accntType && acctypeCount.Count >= 1)
{
isExist = "true";
}
else
{
isExist = "justUpdate";
}
}
else if (checkAccntType == null)
{
isExist = "justUpdate";
}
if (isExist == "justUpdate")
{
AType.AccntType = accntType;
BOSSDB.Entry(AType);
BOSSDB.SaveChanges();
}
}
}
return(new JsonResult()
{
JsonRequestBehavior = JsonRequestBehavior.AllowGet,
Data = new { isExist = isExist }
});
}
public ActionResult ConfirmDeleteAccntType(int PrimaryID)
{
Tbl_FMBank_AccountType acctype = (from a in BOSSDB.Tbl_FMBank_AccountType where a.AccntTypeID == PrimaryID select a).FirstOrDefault();
BOSSDB.Tbl_FMBank_AccountType.Remove(acctype);
BOSSDB.SaveChanges();
var result = "";
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteAccntType(int PrimaryID)
{
Tbl_FMBank_AccountType AccntType = (from a in BOSSDB.Tbl_FMBank_AccountType where a.AccntTypeID == PrimaryID select a).FirstOrDefault();
Tbl_FMBank_BankAccounts bankaccnt = (from a in BOSSDB.Tbl_FMBank_BankAccounts where a.AccntTypeID == PrimaryID select a).FirstOrDefault();
var confirmDelete = "";
if (AccntType != null)
{
if (bankaccnt != null)
{
confirmDelete = "true";
}
else
{
confirmDelete = "false";
}
}
var result = new { confirmDelete = confirmDelete };
return(Json(result, JsonRequestBehavior.AllowGet));
}
