public int?UpdateRoleStatus(ViewMenuRoleStatusUpdateModel vmrolemodel) { try { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DatabaseConnection"].ConnectionString)) { con.Open(); SqlTransaction trans = con.BeginTransaction(); var param = new DynamicParameters(); param.Add("@Status", vmrolemodel.Status); param.Add("@SavedMenuRoleId", vmrolemodel.SaveId); var result = con.Execute("Usp_UpdateRoleStatus", param, trans, 0, CommandType.StoredProcedure); if (result > 0) { trans.Commit(); } else { trans.Rollback(); } return(result); } } catch (Exception) { throw; } }
public JsonResult UpdateRole([Bind(Include = "SaveId,Status")] ViewMenuRoleStatusUpdateModel viewMenuRoleStatusUpdateModel) { try { if (_role.UpdateRoleStatus(viewMenuRoleStatusUpdateModel) > 0) { return(Json(new { Result = "OK" })); } else { return(Json(new { Result = "ERROR", Message = "" })); } } catch (Exception ex) { return(Json(new { Result = "ERROR", Message = ex.Message })); } }