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