public static DataTable QueryRole(RoleQueryFilter filter, out int dataCount)
{
CustomDataCommand command = DataCommandManager.
CreateCustomDataCommandFromConfig("Query_Vendor_Role");
using (DynamicQuerySqlBuilder builder = new DynamicQuerySqlBuilder(
command.CommandText, command, filter, !string.IsNullOrWhiteSpace(filter.SortFields) ? filter.SortFields : "SysNo DESC"))
{
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"RoleName", DbType.String,
"@RoleName", QueryConditionOperatorType.LeftLike,
filter.RoleName);
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"Status", DbType.AnsiStringFixedLength,
"@Status", QueryConditionOperatorType.Equal,
filter.Status);
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"ManufacturerSysNo", DbType.AnsiStringFixedLength,
"@ManufacturerSysNo", QueryConditionOperatorType.Equal,
filter.ManufacturerSysNo);
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"VendorSysNo", DbType.AnsiStringFixedLength,
"@VendorSysNo", QueryConditionOperatorType.Equal,
filter.VendorSysNo);
command.CommandText = builder.BuildQuerySql();
var dt = command.ExecuteDataTable("Status", typeof(RoleStatus));
dataCount = Convert.ToInt32(command.GetParameterValue("@TotalCount"));
return(dt);
}
}
/// <summary>
/// Xem danh sách quyền theo filter:
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public async Task <PaginatedList <RoleResponse> > GetRoleByFilterAsync(RoleQueryFilter filter)
{
var dataResponse = new List <RoleResponse>();
dataResponse.AddRange(_roleManager.Roles.Select(x => new RoleResponse
{
RoleName = x.Name,
Id = x.Id,
Description = x.Description
}).ToList());
if (!string.IsNullOrEmpty(filter.RoleName))
{
dataResponse = dataResponse.Where(x => x.RoleName.ToLower().Contains(filter.RoleName.ToLower())).ToList();
}
if (!string.IsNullOrEmpty(filter.Description))
{
dataResponse = dataResponse.Where(x => x.Description.ToLower().Contains(filter.Description.ToLower())).ToList();
}
if (!filter.PageSize.HasValue && !filter.PageNumber.HasValue)
{
return(await PaginatedList <RoleResponse> .CreateAsync(dataResponse));
}
return(await PaginatedList <RoleResponse> .CreateAsync(dataResponse, filter.PageNumber.Value, filter.PageSize.Value));
}
public ActionResult QueryRoleData()
{
RoleQueryFilter filter = BuildQueryFilterEntity <RoleQueryFilter>();
filter.VendorSysNo = UserAuthHelper.GetCurrentUser().SellerSysNo;
var result = UserService.QueryRole(filter);
return(AjaxGridJson(result));
}
public PagedList <Role> GetRoles(RoleQueryFilter filters)
{
filters.PageNumber = filters.PageNumber == 0 ? _paginationOptions.DefaultPageNumber : filters.PageNumber;
filters.PageSize = filters.PageSize == 0 ? _paginationOptions.DefaultPageSize : filters.PageSize;
var roles = _unitOfWork.RoleRepository.GetAll();
if (filters.Name != null)
{
roles = roles.Where(x => x.Name == filters.Name);
}
var pagedRoles = PagedList <Role> .Create(roles, filters.PageNumber, filters.PageSize);
return(pagedRoles);
}
public IActionResult GetRoles([FromQuery] RoleQueryFilter filters)
{
var roles = _roleService.GetRoles(filters);
var rolesDtos = _mapper.Map <IEnumerable <RoleDto> >(roles);
var metadata = new Metadata
{
TotalCount = roles.TotalCount,
PageSize = roles.PageSize,
CurrentPage = roles.CurrentPage,
TotalPages = roles.TotalPages,
HasNextPage = roles.HasNextPage,
HasPreviousPage = roles.HasPreviousPage
};
var response = new ApiResponse <IEnumerable <RoleDto> >(rolesDtos)
{
Meta = metadata
};
Response.Headers.Add("X-Pagination", JsonConvert.SerializeObject(metadata));
return(Ok(response));
}
public IActionResult GetRoles([FromQuery] RoleQueryFilter filters)
{
//obtengo la collection de role
var response = _role.Get(filters);
//HATEOAS AND HYPERMEDIA
response.Data.ForEach(x =>
{
x.Links = new List <Link>()
{
new Link {
Rel = "Update-role", Method = "PUT", Href = Url.Link(nameof(UpdateRole), new { id = x.RoleId })
}
};
});
// response.Links=new List<Link>(){
// new Link{Rel="Create-role",Method="POST",Href=Url.Link(nameof(AddRole), new { })},
// new Link{Rel="Next",Method="GET",Href=Url.Link(nameof(GetRoles), new {CurrentPage=response.Navegation.Next})},
// new Link{Rel="Previeus",Method="GET",Href=Url.Link(nameof(GetRoles), new { CurrentPage=response.Navegation.Previous})}
// };
return(Ok(response));
}
public Uri GetRolePaginationUri(RoleQueryFilter filter, string actionUrl)
{
string baseUrl = $"{_baseUri}{actionUrl}";
return(new Uri(baseUrl));
}
public static dynamic QueryRoleDatatable(RoleQueryFilter filter)
{
int count = 0;
return(UserDA.QueryRole(filter, out count));
}
public static QueryResult QueryRole(RoleQueryFilter filter)
{
int count = 0;
return(new QueryResult(UserDA.QueryRole(filter, out count), filter, count));
}
