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));
        }