/// <summary>
/// Initializes a new instance of the <see cref="GetSalesTransactionsProcedure"/> class.
/// </summary>
/// <param name="request">The request message.</param>
public GetSalesTransactionsProcedure(GetSalesTransactionDataRequest request)
{
this.request = request;
}
private static EntityDataServiceResponse <SalesOrder> GetSalesTransaction(GetSalesTransactionDataRequest request)
{
ThrowIf.Null(request, "request");
ThrowIf.Null(request.QueryResultSettings, "request.QueryResultSettings");
ThrowIf.Null(request.SearchCriteria, "request.SearchCriteria");
var query = new SqlPagedQuery(request.QueryResultSettings)
{
From = SearchSalesOrdersFunctionTemplate,
};
if (request.QueryResultSettings.Sorting == null || request.QueryResultSettings.Sorting.Count == 0)
{
query.OrderBy = new SortingInfo(CreatedDateTimeColumn, true).ToString();
}
var whereClauses = new List <string>();
BuildWhereClauseForItemIdBarcodeSerialNumber(request.SearchCriteria, query, whereClauses, request.RequestContext.Runtime.Configuration.DatabaseProvider.GetDatabaseQueryBuilder());
BuildSearchOrderWhereClause(request.SearchCriteria, query, whereClauses);
query.Where = string.Join(" AND ", whereClauses);
string customerName = "\"\"";
if (!string.IsNullOrEmpty(request.SearchCriteria.CustomerFirstName) || !string.IsNullOrEmpty(request.SearchCriteria.CustomerLastName))
{
customerName = request.SearchCriteria.CustomerFirstName == null ? "\"" + request.SearchCriteria.CustomerLastName + "\"" : "\"" + request.SearchCriteria.CustomerFirstName + "*" + (request.SearchCriteria.CustomerLastName ?? string.Empty) + "\"";
}
query.Parameters["@nvc_CustomerName"] = customerName;
PagedResult <SalesOrder> transactions;
using (SqlServerDatabaseContext sqlServerDatabaseContext = new SqlServerDatabaseContext(request))
{
transactions = sqlServerDatabaseContext.ReadEntity <SalesOrder>(query);
}
return(new EntityDataServiceResponse <SalesOrder>(transactions));
}
private static EntityDataServiceResponse <SalesOrder> GetSalesTransaction(GetSalesTransactionDataRequest request)
{
GetSalesTransactionsProcedure getSalesTransactionsProcedure = new GetSalesTransactionsProcedure(request);
return(getSalesTransactionsProcedure.Execute());
}
