public string RoleDelete(TRoleModel mdl) { try { string ret = ""; var res = db.PTRoleDelete( mdl.IDRole, mdl.UserLastMaintenance, Convert.ToDateTime(mdl.DateLastMaintenance) ).FirstOrDefault(); if (res.Error == 0 || res.Error == null) { var retSplit = res.Pesan.Split('|'); ret = TranslateMessageClass.TranslateMessage(retSplit[0], Resources.Resource.RoleLabelRoleName, retSplit[1]); ret = "1"; } else { ret = "Err|" + res.Pesan; ret = "0"; } return(ret); } catch (Exception err) { return("Err|" + err.InnerException.Message); } }
//[ValidateAntiForgeryToken] public ActionResult Create(TRoleModel mdl) { mdl.UserEntry = Session["IDUser"].ToString(); mdl.DateEntry = DateTime.Now.ToString(CultureInfo.CreateSpecificCulture("en-US").DateTimeFormat); mdl.UserLastMaintenance = Session["IDUser"].ToString(); mdl.DateLastMaintenance = DateTime.Now.ToString(CultureInfo.CreateSpecificCulture("en-US").DateTimeFormat); mdl.Discontinue = false; if (ModelState.IsValid) { string ret = ""; try { Role = new TRoleClass(); ret = Role.RoleInsert(mdl); return(Json(new { result = ret })); } catch (Exception err) { ret = "Err|" + err.Message; return(Json(new { result = ret })); } } else { var ret = "Err|" + "Error In Model Validation"; //note robby return error when execute method create return(Json(new { result = ret })); //return View(mdl); } }
public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Role = new TRoleClass(); var res = Role.RoleSelectById(id).FirstOrDefault(); if (res == null) { return(HttpNotFound()); } TRoleModel mdl = new TRoleModel(); mdl.IDRole = res.IDRole; mdl.Rolename = res.Rolename; mdl.RoleDesc = res.RoleDesc; mdl.Discontinue = res.Discontinue; mdl.UserEntry = res.UserEntry; mdl.DateEntry = ConvertDate.convert_date(res.DateEntry); mdl.UserLastMaintenance = res.UserLastMaintenance; mdl.DateLastMaintenance = ConvertDate.convert_date(res.DateLastMaintenance); ViewBag.historyKeyword = Request["historyKeyword"]; ViewBag.historyDiscontinue = Request["historyDiscontinue"]; return(View(mdl)); }
//[ValidateAntiForgeryToken] public ActionResult Edit(TRoleModel mdl) { var CUI = Session["CurrentUICulture"].ToString(); DateTime DateEntry = Convert.ToDateTime(mdl.DateEntry, CultureInfo.CreateSpecificCulture(CUI)); mdl.DateEntry = DateEntry.ToString(CultureInfo.CreateSpecificCulture("en-US").DateTimeFormat); mdl.UserLastMaintenance = Session["IDUser"].ToString(); mdl.DateLastMaintenance = DateTime.Now.ToString(CultureInfo.CreateSpecificCulture("en-US").DateTimeFormat); if (ModelState.IsValid) { string ret = ""; try { Role = new TRoleClass(); ret = Role.RoleUpdate(mdl); return(Json(new { result = ret })); } catch (Exception err) { ret = "Err|" + err.Message; return(Json(new { result = ret })); } } else { var ret = "Err|" + "Error In Model Validation"; //note robby return error when execute method create return(Json(new { result = ret })); //return View(mdl); } }
public string RoleInsert(TRoleModel mdl) { try { string ret = ""; var res = db.PTRoleInsert( mdl.Rolename, mdl.RoleDesc, mdl.Discontinue, mdl.UserEntry, Convert.ToDateTime(mdl.DateEntry), mdl.UserLastMaintenance, Convert.ToDateTime(mdl.DateLastMaintenance) ).FirstOrDefault(); if (res.Error == 0 || res.Error == null) { var retSplit = res.Pesan.Split('|'); ret = TranslateMessageClass.TranslateMessage(retSplit[0], Resources.Resource.RoleLabelRoleName, retSplit[1]); ret = "1"; } else { ret = "Err|" + res.Pesan; ret = "0"; } return(ret); } catch (Exception err) { string ErrMsg = ""; if (err.GetType().Name == "EntityCommandExecutionException") { var SqlErr = err.InnerException as SqlException; if (SqlErr.Number == 52627) { var ErrSplit = SqlErr.Message.Split('|'); ErrMsg = TranslateMessageClass.TranslateMessage(ErrSplit[0], Resources.Resource.LabelRole, ErrSplit[1]); } } else { ErrMsg = err.InnerException.Message; } return("0"); } }