public string Get(string orderBy)
{
string parsedExpression = string.Empty;
string[] commaParts = orderBy.Split(',');
foreach (string commaSplit in commaParts)
{
string workingString = commaSplit.Trim();
if (string.IsNullOrEmpty(workingString))
{
throw new ArgumentException("Invalid ordering criteria. Code: 1");
}
workingString = workingString.Trim(',');
if (string.IsNullOrEmpty(workingString))
{
throw new ArgumentException("Invalid ordering criteria. Code: 2");
}
string[] sortPair = workingString.Split(' ');
if (sortPair.Length != 2)
{
throw new ArgumentException("Invalid ordering criteria. Code: 3");
}
if (!(sortPair[1] == "asc" || sortPair[1] == "desc"))
{
throw new ArgumentException("Invalid ordering criteria. Code: 4");
}
string parameterName = sortPair[0].Trim();
if (string.IsNullOrEmpty(parameterName))
{
throw new ArgumentException("Invalid ordering criteria. Code: 5");
}
string dbFieldName = _entityQueryWrapper.GetDbFieldName(parameterName);
if (string.IsNullOrEmpty(parameterName))
{
throw new ArgumentException("Invalid ordering criteria. Code: 6");
}
parsedExpression += string.Format(" {0} {1},", dbFieldName, sortPair[1]);
}
if (!string.IsNullOrEmpty(parsedExpression))
{
parsedExpression = "order by" + parsedExpression.TrimEnd(',');
}
return(parsedExpression);
}
public string GetExpression(FieldExpression expression, ref List <OleDbParameter> parameters)
{
return(" " + _entityQueryWrapper.GetDbFieldName(expression.FieldName) + " ");
}
