protected SqlQueryAndBinds ApplySortField(SqlQueryAndBinds source, FilterSortDto sort)
{
if (sort.IsDescending)
{
source.SqlQuery += $@" ORDER BY {sort.ColumnName} Desc";
}
else
{
source.SqlQuery += $@" ORDER BY {sort.ColumnName} ASC";
}
return(source);
}
protected virtual SqlQueryAndBinds ApplySort(SqlQueryAndBinds source, FilterSortDto sort)
{
sort ??= new FilterSortDto
{
ColumnName = nameof(BaseModel.DateCreated),
IsDescending = true
};
return(sort.ColumnName switch
{
nameof(BaseModel.DateCreated) => ApplySortField(source, sort),
nameof(BaseModel.IsActive) => ApplySortField(source, sort),
nameof(BaseModel.DateDelete) => ApplySortField(source, sort),
_ => source
});
