/// <summary>
/// Load data to form
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public ActionResult AjaxHandler(JQueryDataTableParamModel param)
{
var users = _accountService.GetAllUsers();
IEnumerable <ApplicationUser> filteredUsers;
//Check whether the Categories should be filtered by keyword
if (!string.IsNullOrEmpty(param.sSearch))
{
//Used if particulare columns are filtered
//var nameFilter = Convert.ToString(Request["sSearch_1"]);
//var addressFilter = Convert.ToString(Request["sSearch_2"]);
//var townFilter = Convert.ToString(Request["sSearch_3"]);
//Optionally check whether the columns are searchable at all
//var isNameSearchable = Convert.ToBoolean(Request["bSearchable_1"]);
//var isAddressSearchable = Convert.ToBoolean(Request["bSearchable_2"]);
//var isTownSearchable = Convert.ToBoolean(Request["bSearchable_3"]);
filteredUsers = _accountService.GetAllUsers().Where(aa => aa.UserName.ToLower().Contains(param.sSearch.ToLower()));
// .Where(c => isNameSearchable && c.CategoriesName.ToLower().Contains(param.sSearch.ToLower()));
}
else
{
filteredUsers = users;
}
var isUsernameSort = Convert.ToBoolean(Request["bSortable_1"]);
//var isAddressSortable = Convert.ToBoolean(Request["bSortable_2"]);
//var isTownSortable = Convert.ToBoolean(Request["bSortable_3"]);
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
Func <ApplicationUser, string> orderingFunction = (c => c.UserName);
var sortDirection = Request["sSortDir_0"]; // asc or desc
if (sortDirection == "asc")
{
filteredUsers = filteredUsers.OrderBy(orderingFunction);
}
else
{
filteredUsers = filteredUsers.OrderByDescending(orderingFunction);
}
var displayedUsers = filteredUsers.Skip(param.iDisplayStart).Take(param.iDisplayLength);
var result = from c in displayedUsers select new[] { c.Id, c.UserName, c.Email, c.PhoneNumber };
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = users.Count(),
iTotalDisplayRecords = filteredUsers.Count(),
aaData = result
},
JsonRequestBehavior.AllowGet));
}
public IActionResult GetAllUsers(int page = 1)
{
if (ModelState.IsValid)
{
return(Ok(_accountServices.GetAllUsers(page)));
}
return(NotFound());
}
public ActionResult Add()
{
var ListUser = AccountService.GetAllUsers();
var ListRole = AccountService.GetAllRoles();
ViewBag.ListUser = ListUser;
ViewBag.ListRole = ListRole;
return(View());
}
public IEnumerable <UserShortViewModel> GetAllUsers()
{
return(_main.GetAllUsers().Select(i => new UserShortViewModel(i)));
}