public int?UpdateSubMenuRoleStatus(ViewSubMenuRoleStatusUpdateModel 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("@SavedSubMenuRoleId", vmrolemodel.SaveId);
var result = con.Execute("UpdateSubMenuRoleStatus", 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")] ViewSubMenuRoleStatusUpdateModel viewMenuRoleStatusUpdateModel)
{
try
{
if (_role.UpdateSubMenuRoleStatus(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 }));
}
}
