public override System.Web.Mvc.ActionResult List(bool freeSend, bool deleted, string term, int page, int count, DomainClasses.Enums.Order order, DomainClasses.Enums.ProductOrderBy productOrderBy, long categoryId, DomainClasses.Enums.ProductType productType)
{
var callInfo = new T4MVC_System_Web_Mvc_ActionResult(Area, Name, ActionNames.List);
ModelUnbinderHelpers.AddRouteValues(callInfo.RouteValueDictionary, "freeSend", freeSend);
ModelUnbinderHelpers.AddRouteValues(callInfo.RouteValueDictionary, "deleted", deleted);
ModelUnbinderHelpers.AddRouteValues(callInfo.RouteValueDictionary, "term", term);
ModelUnbinderHelpers.AddRouteValues(callInfo.RouteValueDictionary, "page", page);
ModelUnbinderHelpers.AddRouteValues(callInfo.RouteValueDictionary, "count", count);
ModelUnbinderHelpers.AddRouteValues(callInfo.RouteValueDictionary, "order", order);
ModelUnbinderHelpers.AddRouteValues(callInfo.RouteValueDictionary, "productOrderBy", productOrderBy);
ModelUnbinderHelpers.AddRouteValues(callInfo.RouteValueDictionary, "categoryId", categoryId);
ModelUnbinderHelpers.AddRouteValues(callInfo.RouteValueDictionary, "productType", productType);
ListOverride(callInfo, freeSend, deleted, term, page, count, order, productOrderBy, categoryId, productType);
return(callInfo);
}
partial void ListOverride(T4MVC_System_Web_Mvc_ActionResult callInfo, bool freeSend, bool deleted, string term, int page, int count, DomainClasses.Enums.Order order, DomainClasses.Enums.ProductOrderBy productOrderBy, long categoryId, DomainClasses.Enums.ProductType productType);
public IList <UserViewModel> GetDataTable(out int total, string term, int page, int count, DomainClasses.Enums.Order order, UserOrderBy orderBy, UserSearchBy searchBy)
{
var selectedUsers = _users.AsNoTracking().Include(a => a.Role).AsQueryable();
if (!string.IsNullOrEmpty(term))
{
switch (searchBy)
{
case UserSearchBy.UserName:
selectedUsers = selectedUsers.Where(user => user.UserName.Contains(term)).AsQueryable();
break;
case UserSearchBy.RoleDescription:
selectedUsers = selectedUsers.Where(user => user.Role.Description.Contains(term)).AsQueryable();
break;
case UserSearchBy.Ip:
selectedUsers =
selectedUsers.Where(user => user.IP.Contains(term)).AsQueryable();
break;
}
}
if (order == DomainClasses.Enums.Order.Asscending)
{
switch (orderBy)
{
case UserOrderBy.UserName:
selectedUsers = selectedUsers.OrderBy(user => user.UserName).AsQueryable();
break;
case UserOrderBy.RegisterDate:
selectedUsers = selectedUsers.OrderBy(user => user.RegisterDate).AsQueryable();
break;
}
}
else
{
switch (orderBy)
{
case UserOrderBy.UserName:
selectedUsers = selectedUsers.OrderByDescending(user => user.UserName).AsQueryable();
break;
case UserOrderBy.RegisterDate:
selectedUsers = selectedUsers.OrderByDescending(user => user.RegisterDate).AsQueryable();
break;
}
}
var totalQuery = selectedUsers.FutureCount();
var selectQuery = selectedUsers.Skip((page - 1) * count).Take(count)
.Select(a => new UserViewModel
{
RegisterType = a.RegisterType == UserRegisterType.Active ? "Active" : "DeActie",
Baned = a.IsBaned,
Id = a.Id,
RoleDescritpion = a.Role.Description,
BanedDate = a.BanedDate,
Email = a.Email,
IP = a.IP,
LastLoginDate = a.LastLoginDate,
RegisterDate = a.RegisterDate,
UserName = a.UserName,
ProfessorData = a.ProfessorData,
StudentData = a.StudentData
}).Future();
total = totalQuery.Value;
var users = selectQuery.ToList();
return(users);
}
public IList <DetailsUserViewModel> GetDataTable(out int total, string term, int page, int count, DomainClasses.Enums.Order order, UserOrderBy orderBy, UserSearchBy searchBy)
{
var selectedUsers = _users.AsNoTracking().Include(a => a.Roles).AsQueryable();
//var selectedRole = _roleManager.FindRoleByName("");
if (!string.IsNullOrEmpty(term))
{
switch (searchBy)
{
case UserSearchBy.UserName:
selectedUsers = selectedUsers.Where(user => user.UserName.Contains(term)).AsQueryable();
break;
//case UserSearchBy.RoleDescription:
// selectedUsers = selectedUsers.Where(user => user.Role.Description.Contains(term)).AsQueryable();
// break;
case UserSearchBy.PhoneNumber:
selectedUsers =
selectedUsers.Where(user => user.PhoneNumber.Contains(term)).AsQueryable();
break;
}
}
if (order == Order.Asscending)
{
switch (orderBy)
{
case UserOrderBy.UserName:
selectedUsers = selectedUsers.OrderBy(user => user.UserName).AsQueryable();
break;
case UserOrderBy.PhoneNumber:
selectedUsers = selectedUsers.OrderBy(user => user.PhoneNumber).AsQueryable();
break;
case UserOrderBy.RoleDescription:
selectedUsers = selectedUsers.OrderBy(user => user.RegisterDate).AsQueryable();
break;
}
}
else
{
switch (orderBy)
{
case UserOrderBy.UserName:
selectedUsers = selectedUsers.OrderByDescending(user => user.UserName).AsQueryable();
break;
case UserOrderBy.PhoneNumber:
selectedUsers = selectedUsers.OrderBy(user => user.PhoneNumber).AsQueryable();
break;
case UserOrderBy.RoleDescription:
selectedUsers = selectedUsers.OrderByDescending(user => user.RegisterDate).AsQueryable();
break;
}
}
var totalQuery = selectedUsers.Count();
var selectQuery = selectedUsers.Skip((page - 1) * count).Take(count)
.ProjectTo <DetailsUserViewModel>(Market.AutoMapperConfig.Configuration.MapperConfiguration);
total = totalQuery;
return(selectQuery.ToList());
}
public override System.Web.Mvc.ActionResult List(string term, int pageNumber, int pageCount, DomainClasses.Enums.Order order, DomainClasses.Enums.UserOrderBy userOrderBy, DomainClasses.Enums.UserSearchBy userSearchBy)
{
var callInfo = new T4MVC_System_Web_Mvc_ActionResult(Area, Name, ActionNames.List);
ModelUnbinderHelpers.AddRouteValues(callInfo.RouteValueDictionary, "term", term);
ModelUnbinderHelpers.AddRouteValues(callInfo.RouteValueDictionary, "pageNumber", pageNumber);
ModelUnbinderHelpers.AddRouteValues(callInfo.RouteValueDictionary, "pageCount", pageCount);
ModelUnbinderHelpers.AddRouteValues(callInfo.RouteValueDictionary, "order", order);
ModelUnbinderHelpers.AddRouteValues(callInfo.RouteValueDictionary, "userOrderBy", userOrderBy);
ModelUnbinderHelpers.AddRouteValues(callInfo.RouteValueDictionary, "userSearchBy", userSearchBy);
ListOverride(callInfo, term, pageNumber, pageCount, order, userOrderBy, userSearchBy);
return(callInfo);
}
partial void ListOverride(T4MVC_System_Web_Mvc_ActionResult callInfo, string term, int pageNumber, int pageCount, DomainClasses.Enums.Order order, DomainClasses.Enums.UserOrderBy userOrderBy, DomainClasses.Enums.UserSearchBy userSearchBy);
