public JsonResult Delete(ADM_DEF_BANK_BR bnk) { ADM_DEF_BANK_BR data = db.ADM_DEF_BANK_BR.Find(bnk.CODE); db.ADM_DEF_BANK_BR.Remove(data); db.SaveChanges(); return(Json(JsonRequestBehavior.AllowGet)); }
public JsonResult Add(ADM_DEF_BANK_BR bnkObj) { SqlConnection con = new SqlConnection(connectionstring); SqlCommand cmd = new SqlCommand("", con); cmd.CommandText = "SELECT MAX(CODE) FROM ADM_DEF_BANK_BR"; con.Open(); var code = cmd.ExecuteScalar(); if (code == DBNull.Value) { code = 0; } con.Close(); code = Convert.ToInt32(code) + 1; bnkObj.CODE = Convert.ToDecimal(code); db.ADM_DEF_BANK_BR.Add(bnkObj); db.SaveChanges(); return(Json(JsonRequestBehavior.AllowGet)); }
public JsonResult Update(ADM_DEF_BANK_BR bank) { ADM_DEF_BANK_BR def = db.ADM_DEF_BANK_BR.Find(bank.CODE); def.BANK_CODE = bank.BANK_CODE; def.CODE = bank.CODE; def.DESC = bank.DESC; def.ADDRESS = bank.ADDRESS; def.PHONE = bank.PHONE; def.FAX = bank.FAX; def.MANAGER = bank.MANAGER; def.TELE = bank.TELE; 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.INACTIVE_IMS = bank.INACTIVE_IMS; def.INACTIVE_LMS = bank.INACTIVE_LMS; def.INACTIVE_MFL = bank.INACTIVE_MFL; db.SaveChanges(); return(Json(JsonRequestBehavior.AllowGet)); }