public JsonResult Delete(int id) { using (anhthaiEntities db = new anhthaiEntities()) { SVR_VERSION emp = db.SVR_VERSION.Where(x => x.VERSION_NO == id).FirstOrDefault <SVR_VERSION>(); db.SVR_VERSION.Remove(emp); db.SaveChanges(); return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet)); } }
///////////////////getbyid///////////////////////// public JsonResult GetVersionById(int VERSION_NO) { SVR_VERSION model = db.SVR_VERSION.Where(x => x.VERSION_NO == VERSION_NO).SingleOrDefault(); string value = string.Empty; value = JsonConvert.SerializeObject(model, Formatting.Indented, new JsonSerializerSettings { ReferenceLoopHandling = ReferenceLoopHandling.Ignore }); return(Json(value, JsonRequestBehavior.AllowGet)); }
public JsonResult SaveDataInDatabase(SVR_VERSION model) { var result = false; try { String a = model.VERSION_NO.ToString(); if (model.VERSION_NO > 0) { SVR_VERSION ver = db.SVR_VERSION.SingleOrDefault(x => x.VERSION_NO == model.VERSION_NO); ver.BUMON_ID = model.BUMON_ID; ver.TYPE_SEND = model.TYPE_SEND; ver.FROM_DATE = model.FROM_DATE; ver.TO_DATE = model.TO_DATE; ver.INSERT_DATE = model.INSERT_DATE; ver.INSERT_USER = model.INSERT_USER; ver.UPDATE_DATE = model.UPDATE_DATE; ver.UPDATE_USER = model.UPDATE_USER; ver.DEL_FLAG = model.DEL_FLAG; //ver.BUMON_NAME = model.BUMON_NAME; /////code de phat sinh loi tai day db.SaveChanges(); result = true; return(Json(new { result, success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet)); } else { SVR_VERSION ver = new SVR_VERSION(); ver.BUMON_ID = model.BUMON_ID; ver.TYPE_SEND = model.TYPE_SEND; ver.FROM_DATE = model.FROM_DATE; ver.TO_DATE = model.TO_DATE; ver.INSERT_DATE = model.INSERT_DATE; ver.INSERT_USER = model.INSERT_USER; ver.UPDATE_DATE = model.UPDATE_DATE; ver.UPDATE_USER = model.UPDATE_USER; ver.DEL_FLAG = model.DEL_FLAG; //ver.BUMON_NAME = model.BUMON_NAME; db.SVR_VERSION.Add(ver); db.SaveChanges(); result = true; return(Json(new { result, success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { throw ex; } //return Json(result, JsonRequestBehavior.AllowGet); }