protected IMatched <SkipTake> getSkipTake(ParseState state, ExpressionFlags flags)
{
var skipTake = new SkipTake();
var noSkipMatch = state.Scan("^ /(|s|) /','", Color.Whitespace, Color.Structure);
if (noSkipMatch.If(out _, out var _exception))
{
}
public void TestSkipTakeInvalidPageNumberShouldReturnFirstForCurrentPage()
{
Pagination pagination = new Pagination(5, 10, 25);
SkipTake skipTake = pagination.ElementsToSkipAndTake();
Assert.AreEqual(0, skipTake.Skip);
Assert.AreEqual(10, skipTake.Take);
Assert.AreEqual(1, pagination.CurrentPage);
}
public void TestSkipTakeThirdPage()
{
Pagination pagination = new Pagination(3, 10, 25);
SkipTake skipTake = pagination.ElementsToSkipAndTake();
Assert.AreEqual(20, skipTake.Skip);
Assert.AreEqual(5, skipTake.Take);
Assert.AreEqual(3, pagination.CurrentPage);
}
public void TestSkipTakeFirstPage()
{
Pagination pagination = new Pagination(1, 10, 25);
SkipTake skipTake = pagination.ElementsToSkipAndTake();
Assert.AreEqual(0, skipTake.Skip);
Assert.AreEqual(10, skipTake.Take);
Assert.AreEqual(1, pagination.CurrentPage);
}
public ActionResult <IList <InvoiceDTO> > GetRecentInvoices(SkipTake skipTake)
{
string userId = User?.Identity?.Name;
if (string.IsNullOrEmpty(userId))
{
return(Forbid());
}
var invoices = InvoiceService.GetRecentInvoices(int.Parse(userId), skipTake.Skip, skipTake.Take);
return(invoices.Select((invoice) => new InvoiceDTO(invoice)).ToList());
}
public IObject this[SkipTake skipTake] => Objects.CollectionFunctions.skipTake(this, skipTake);
protected override Expression VisitMethodCall(MethodCallExpression expression)
{
Visit(expression.Arguments[0]);
switch (expression.Method.Name)
{
case "Select":
Select = SelectParser.Translate(expression.Arguments[1]);
// if it changes the return type make it known that this is a projection and should not be tracked in session
var inType = expression.Arguments[0].Type.GetGenericArguments()[0];
var outType = expression.Method.ReturnType.GetGenericArguments()[0];
ProjectAs = inType != outType ? outType : null;
break;
case "SingleOrDefault":
Execution = Translation.ExecutionSemantics.SingleOrDefault;
goto Take1;
case "Single":
Execution = Translation.ExecutionSemantics.Single;
goto Take1;
case "FirstOrDefault":
Execution = Translation.ExecutionSemantics.FirstOrDefault;
goto Take1;
case "First":
Execution = Translation.ExecutionSemantics.First;
goto Take1;
case "Take1":
Take1:
Top1 = true;
if (expression.Arguments.Count <= 1)
{
break;
}
goto Where;
case "Where":
Where:
var whereExpression = WhereParser.Translate(expression.Arguments[1]);
if (whereExpression == null)
{
break;
}
Where = Where != null
? new SqlBinaryExpression(SqlNodeType.And, Where, whereExpression)
: whereExpression;
break;
case "Skip":
Window = new SkipTake((int)((ConstantExpression)expression.Arguments[1]).Value, (Window as SkipTake)?.Take ?? 0);
break;
case "Take":
Window = new SkipTake((Window as SkipTake)?.Skip ?? 0, (int)((ConstantExpression)expression.Arguments[1]).Value);
break;
case "SkipToId":
Window = new SkipToId((string)((ConstantExpression)expression.Arguments[1]).Value, (int)((ConstantExpression)expression.Arguments[2]).Value);
break;
case "OfType":
ProjectAs = expression.Method.GetGenericArguments()[0];
break;
case "OrderBy":
case "ThenBy":
case "OrderByDescending":
case "ThenByDescending":
var direction = expression.Method.Name.Contains("Descending")
? SqlOrderingExpression.Directions.Descending
: SqlOrderingExpression.Directions.Ascending;
var orderByColumnExpression = OrderByVisitor.Translate(expression.Arguments[1]);
var orderingExpression = new SqlOrderingExpression(direction, orderByColumnExpression);
OrderBy = OrderBy != null
? new SqlOrderByExpression(OrderBy.Columns.Concat(orderingExpression))
: new SqlOrderByExpression(orderingExpression.AsEnumerable());
break;
default:
throw new NotSupportedException(string.Format("The method {0} is not supported", expression.Method.Name));
}
return(expression);
}
