public JsonResult Delete(ADM_DEF_BRANCH bnk) { ADM_DEF_BRANCH data = db.ADM_DEF_BRANCH.Find(bnk.CODE); db.ADM_DEF_BRANCH.Remove(data); db.SaveChanges(); return(Json(JsonRequestBehavior.AllowGet)); }
public JsonResult Add(ADM_DEF_BRANCH bnkObj) { SqlConnection con = new SqlConnection(connectionstring); SqlCommand cmd = new SqlCommand("", con); cmd.CommandText = "SELECT MAX(CODE) FROM ADM_DEF_BRANCH"; 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_BRANCH.Add(bnkObj); db.SaveChanges(); return(Json(JsonRequestBehavior.AllowGet)); }
public JsonResult Update(ADM_DEF_BRANCH bank) { ADM_DEF_BRANCH def = db.ADM_DEF_BRANCH.Find(bank.CODE); def.CODE = bank.CODE; def.DESC = bank.DESC; def.ABRV = bank.ABRV; def.CITY_CODE = bank.CITY_CODE; def.HDBR_CD = bank.HDBR_CD; def.ADDRESS = bank.ADDRESS; def.PHONE = bank.PHONE; def.EMAIL = bank.EMAIL; def.MANAGER = bank.MANAGER; 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)); }