public ActionResult ConfirmDeleteBrgyBankAccnt(int PrimaryID)
{
Tbl_FMBrgy_BrgyBankAccount BBA = (from a in BOSSDB.Tbl_FMBrgy_BrgyBankAccount where a.BrgyBankAccntID == PrimaryID select a).FirstOrDefault();
BOSSDB.Tbl_FMBrgy_BrgyBankAccount.Remove(BBA);
BOSSDB.SaveChanges();
var result = "";
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteBrgyBankAccnt(int PrimaryID)
{
Tbl_FMBrgy_BrgyBankAccount brgybnkaccnt = (from a in BOSSDB.Tbl_FMBrgy_BrgyBankAccount where a.BrgyBankAccntID == PrimaryID select a).FirstOrDefault();
var confirmDelete = "";
if (brgybnkaccnt != null)
{
confirmDelete = "false";
}
var result = new { confirmDelete = confirmDelete };
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult SaveBrgyBankAccnt(BrgyBankAccountModel model)
{
var isExist = "";
if (ModelState.IsValid)
{
var brgyid = model.BrgyID;
var bankaccntid = model.BankAccntID;
var brgybankaccntid = model.BrgyBankAccountList.BrgyBankAccntID;
Tbl_FMBrgy_BrgyBankAccount checkBBA = (from a in BOSSDB.Tbl_FMBrgy_BrgyBankAccount where (a.BrgyID == brgyid && a.BankAccntID == bankaccntid) select a).FirstOrDefault();
if (model.ActionID == 1)
{
if (checkBBA == null)
{
Tbl_FMBrgy_BrgyBankAccount brgyBAccnt = new Tbl_FMBrgy_BrgyBankAccount();
brgyBAccnt.BrgyID = brgyid;
brgyBAccnt.BankAccntID = bankaccntid;
BOSSDB.Tbl_FMBrgy_BrgyBankAccount.Add(brgyBAccnt);
BOSSDB.SaveChanges();
isExist = "false";
}
else if (checkBBA != null)
{
isExist = "true";
}
}
else if (model.ActionID == 2)
{
Tbl_FMBrgy_BrgyBankAccount updateBBA = (from a in BOSSDB.Tbl_FMBrgy_BrgyBankAccount where a.BrgyBankAccntID == brgybankaccntid select a).FirstOrDefault();
List <Tbl_FMBrgy_BrgyBankAccount> brgyidCount = (from e in BOSSDB.Tbl_FMBrgy_BrgyBankAccount where e.BrgyID == brgyid select e).ToList();
List <Tbl_FMBrgy_BrgyBankAccount> bnkaccntidCount = (from e in BOSSDB.Tbl_FMBrgy_BrgyBankAccount where e.BankAccntID == bankaccntid select e).ToList();
if (checkBBA != null)
{
if (updateBBA.BrgyID != brgyid && brgyidCount.Count >= 1 && updateBBA.BankAccntID != bankaccntid && bnkaccntidCount.Count >= 1)
{
isExist = "true";
}
else
{
isExist = "justUpdate";
}
}
else if (checkBBA == null)
{
isExist = "justUpdate";
}
if (isExist == "justUpdate")
{
updateBBA.BrgyID = brgyid;
updateBBA.BankAccntID = bankaccntid;
updateBBA.BrgyBankAccntID = brgybankaccntid;
BOSSDB.Entry(updateBBA);
BOSSDB.SaveChanges();
}
}
}
return(new JsonResult()
{
JsonRequestBehavior = JsonRequestBehavior.AllowGet,
Data = new { isExist = isExist }
});
}
