public JsonResult Delete(ADM_DEF_BANK bnk)
{
ADM_DEF_BANK data = db.ADM_DEF_BANK.Find(bnk.CODE);
db.ADM_DEF_BANK.Remove(data);
db.SaveChanges();
return(Json(JsonRequestBehavior.AllowGet));
}
public JsonResult Add(ADM_DEF_BANK bnkObj)
{
SqlConnection con = new SqlConnection(connectionstring);
SqlCommand cmd = new SqlCommand("", con);
cmd.CommandText = "SELECT MAX(CODE) FROM ADM_DEF_BANK";
con.Open();
var code = Convert.ToInt32(cmd.ExecuteScalar());
con.Close();
code = code + 1;
bnkObj.CODE = code;
db.ADM_DEF_BANK.Add(bnkObj);
db.SaveChanges();
return(Json(JsonRequestBehavior.AllowGet));
}
public JsonResult Update(ADM_DEF_BANK bank)
{
ADM_DEF_BANK def = db.ADM_DEF_BANK.Find(bank.CODE);
def.CODE = bank.CODE;
def.DESC = bank.DESC;
def.EMAIL = bank.EMAIL;
def.ABRV = bank.ABRV;
def.ADD = bank.ADD;
def.AUTH_BY = bank.AUTH_BY;
def.AUTH_DATE = bank.AUTH_DATE;
def.AUTH_REMARKS = bank.AUTH_REMARKS;
def.AUTH_STATUS = bank.AUTH_STATUS;
def.BAL_REF_CODE = bank.BAL_REF_CODE;
def.FBL_REF_CODE = bank.FBL_REF_CODE;
def.TRF_REF_CODE = bank.TRF_REF_CODE;
def.INACTIVE_IMS = bank.INACTIVE_IMS;
def.INACTIVE_LMS = bank.INACTIVE_LMS;
def.INACTIVE_MFL = bank.INACTIVE_MFL;
def.UAN = bank.UAN;
db.SaveChanges();
return(Json(JsonRequestBehavior.AllowGet));
}
