public void GetSortDirectionIfDirectionIsEmpty()
{
_query.Direction = string.Empty;
var sut = new QueryData(_query, _validColumns, _clauseFactory, "My Table");
Assert.Equal("ASC", sut.GetSortDirection());
}
public void GetSortDirectionIfDirectionIs_DESC()
{
_query.Direction = "DESC";
var sut = new QueryData(_query, _validColumns, _clauseFactory, "My Table");
Assert.Equal("DESC", sut.GetSortDirection());
}
public override string ToString()
{
var column = _queryData.GetSortColumn();
var direction = _queryData.GetSortDirection();
if (string.IsNullOrWhiteSpace(column))
{
return(string.Empty);
}
return(direction == "ASC"
? $"ORDER BY CASE WHEN {column} IS NULL THEN 1 ELSE 0 END, {column}"
: $"ORDER BY {column} DESC");
}
