/// <summary>
/// Updates the last modified information for a role
/// </summary>
private ListRoleModel UpdateLastModified(ListRoleModel roleModel)
{
var auditRecord = (new AuditFactory()).Get(Constants.Audits.RoleTableName, roleModel.RoleId);
roleModel.LastModifiedOn = auditRecord.ModifiedOn;
roleModel.LastModifiedBy = (new UserFactory()).GetUserById(auditRecord.ModifiedBy).FullName();
return(roleModel);
}
public ActionResult ListRoles(string filter, int?page)
{
try
{
filter = filter ?? "";
page = page ?? 1;
// Get default pagesize
var pageSize = int.Parse(ConfigurationManager.AppSettings["PAGE_SIZE"]);
// Create SQL parameters
var pFilter = new SqlParameter("filter", filter);
var pPageIndex = new SqlParameter("pageIndex", page);
var pPageSize = new SqlParameter("pageSize", pageSize);
var pItemCount = new SqlParameter("itemCount", System.Data.SqlDbType.Int, 4);
pPageIndex.Direction = System.Data.ParameterDirection.InputOutput;
pItemCount.Direction = System.Data.ParameterDirection.Output;
// Search users
var roles = db.Database.SqlQuery <Role>(@"EXEC [dbo].[usp_searchRoles]
@filter,
@pageIndex OUT,
@pageSize,
@itemCount OUT",
pFilter,
pPageIndex,
pPageSize,
pItemCount).ToList();
// Create view model
var totalItems = (int)pItemCount.Value;
var pager = new Pager(totalItems, (int)pPageIndex.Value, pageSize);
var model = new ListRoleModel {
Filter = filter, Items = roles, Pager = pager
};
return(View(model));
}
catch (Exception ex)
{
EventWriter.WriteEventLog("SystemController - ListRoles: " + ex.ToString());
}
// Create empty model
return(View());
}
public ActionResult Index(BaseModel condition)
{
int errorId = CheckRole(_roles);
if (errorId < 0)
{
return(Redirect(errorId));
}
ListRoleModel model = new ListRoleModel();
int totalRecord = 0;
model.ListRole = role.List(condition.SearchText, condition.Page, condition.PageSize, condition.State, out totalRecord);
condition.TotalRecord = totalRecord;
model.Condition = condition;
Paging(condition.Page, totalRecord);
return(View(model));
}
