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 });