public JsonResult Delete(ADM_DEF_RM bnk)
{
ADM_DEF_RM data = db.ADM_DEF_RM.Find(bnk.CODE);
db.ADM_DEF_RM.Remove(data);
db.SaveChanges();
return(Json(JsonRequestBehavior.AllowGet));
}
public JsonResult Add(ADM_DEF_RM bnkObj)
{
SqlConnection con = new SqlConnection(connectionstring);
SqlCommand cmd = new SqlCommand("", con);
cmd.CommandText = "SELECT MAX(CODE) FROM ADM_DEF_RM";
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_RM.Add(bnkObj);
db.SaveChanges();
return(Json(JsonRequestBehavior.AllowGet));
}
public JsonResult Update(ADM_DEF_RM bank)
{
ADM_DEF_RM def = db.ADM_DEF_RM.Find(bank.CODE);
def.CODE = bank.CODE;
def.BRANCH_CODE = bank.BRANCH_CODE;
def.EMP_CODE = bank.EMP_CODE;
def.DESIG = bank.DESIG;
def.NAME = bank.NAME;
def.PHONE = bank.PHONE;
def.EMAIL = bank.EMAIL;
def.MOBILE = bank.MOBILE;
def.SIGN = bank.SIGN;
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));
}