public static void Query4(Database database, IProductsService srv)
{
var req = new GridRequestWithAdditionalPayload <TextSearchPayload>()
{
Skip = 2,
Take = 2,
Filter = new GridRequestFilter[]
{
new GridRequestFilter()
{
PropName = "ProductNumber",
Operand = "Contains",
JsonValue = "'-54'"
}
},
Sort = new GridRequestSort[]
{
new GridRequestSort()
{
PropName = "ProductId",
IsDescending = true
},
},
Payload = new TextSearchPayload()
{
TextSearch = "frame"
}
};
database.LogSQLToFile("B2DataGridRequests-query4-log.html", () =>
{
var result1 = srv.GetProductsForGrid(req).ToArray();
result1.SaveAsHtmlTableFile("B2DataGridRequests-query4-result.html");
});
}
public static void Query1(Database database, IProductsService srv)
{
var req = new GridRequestWithAdditionalPayload <TextSearchPayload>()
{
Skip = 3,
Take = 1,
Sort = new GridRequestSort[]
{
new GridRequestSort()
{
PropName = "ModelName",
IsDescending = true
},
new GridRequestSort()
{
PropName = "ProductNumber",
IsDescending = true
},
},
Payload = new TextSearchPayload()
{
TextSearch = "frame"
}
};
database.LogSQLToFile("B2DataGridRequests-query1-log.html", () =>
{
var result1 = srv.GetProductsForGrid(req).ToArray();
result1.SaveAsHtmlTableFile("B2DataGridRequests-query1-result.html");
});
}
public ProductGridRow[] GetProductsForGrid(GridRequestWithAdditionalPayload <TextSearchPayload> request)
{
var textSearch = request.Payload.TextSearch;
var query = _productRepo.ReadGridProducts(textSearch);
query = request.WrapQuery(query);
return(query.ToArray());
}
public static void Query3(Database database, IProductsService srv)
{
var req = new GridRequestWithAdditionalPayload <TextSearchPayload>()
{
Filter = new GridRequestFilter[]
{
new GridRequestFilter()
{
PropName = "ProductNumber",
Operand = "Contains",
JsonValue = "'FR-R92B'"
}
},
Payload = new TextSearchPayload()
};
database.LogSQLToFile("B2DataGridRequests-query3-log.html", () =>
{
var result1 = srv.GetProductsForGrid(req).ToArray();
result1.SaveAsHtmlTableFile("B2DataGridRequests-query3-result.html");
});
}
