Maars.Sorting 1.1.0

sorting

Sorting package for .net core application to do auto sorting columns on SQL/Any Queriers from Entity framework

Sorting any fields

format query string in the format of

http://localhost/products?sort=name_asc;code_dsc

Setup in .net core Starupt

services.AddMvc(config =>
{
    config.Filters.Add(typeof(PaginationFilter));
    config.Filters.Add(typeof(SortingFilter));
});           

Usage on entity framework Decorate controller

[HttpGet]
[SwaggerResponse((int)HttpStatusCode.OK, Type = typeof(IList<Standard>))]
public IActionResult GetStandards([FromQuery] PaginationParams paginationParams,
    SortingInfo sortingInfo)
{
    var list = Service.GetList(paginationParams, sortingInfo);
    return Ok(list);
}

Decorate in Service Ensure Extensions included : using Maars.Sorting;

public override IEnumerable<Standard> GetList(PaginationParams paginationParams, SortingInfo sortingInfo)
{
    var query = Context.Standard.GetList(paginationParams).IncludeOrderBy(sortingInfo)
        .AsNoTracking();
    return query;
}

If you need additonal default filter Add it with parameter

public override IEnumerable<Standard> GetList(PaginationParams paginationParams, SortingInfo sortingInfo)
{
    sortingInfo.Add(nameof(Standard.Code), Sorting.Asc);
    var query = Context.Standard.GetList(paginationParams).IncludeOrderBy(sortingInfo)
        .AsNoTracking();
    return query;
}