private static async Task UpsertDocumentAsync <T>(T item, string collectionName, string id)
{
var documentClientDetails = await DocumentDbClientFactory.GetDocumentClientAsync("ChallengeAggregates", collectionName);
var documentCollectionLink = UriFactory.CreateDocumentCollectionUri("ChallengeAggregates", collectionName);
await documentClientDetails.DocumentClient.UpsertDocumentAsync(documentCollectionLink, item);
}
private static async Task ProcessOrders()
{
var fetchImportedOrdersTask = FetchImportedOrdersAsync();
var fetchLiveOrdersTask = FetchLiveOrdersAsync();
await Task.WhenAll(fetchImportedOrdersTask, fetchLiveOrdersTask);
var importedOrders = fetchImportedOrdersTask.Result;
var liveOrders = fetchLiveOrdersTask.Result;
// Process product score data and distributor score data in parallel
await Task.WhenAll(
Task.Run(ProcessProductScoreData),
Task.Run(ProcessDistributorScoreData));
async Task <IEnumerable <ImportOrderItem> > FetchImportedOrdersAsync()
{
var documentClientDetails = await DocumentDbClientFactory.GetDocumentClientAsync("ChallengeDatabase", "OrderHeaderDetails");
var ratingsQuery = documentClientDetails.DocumentClient
.CreateDocumentQuery <ImportOrderItem>(documentClientDetails.DocumentCollectionLink)
.AsDocumentQuery();
var orders = new List <ImportOrderItem>();
while (ratingsQuery.HasMoreResults)
{
var results = await ratingsQuery.ExecuteNextAsync <ImportOrderItem>();
orders.AddRange(results);
}
return(orders);
}
async Task <IEnumerable <LiveOrderItem> > FetchLiveOrdersAsync()
{
var documentClientDetails = await DocumentDbClientFactory.GetDocumentClientAsync("Challenge7DB", "Challenge7Orders");
var ratingsQuery = documentClientDetails.DocumentClient
.CreateDocumentQuery <LiveOrderItem>(documentClientDetails.DocumentCollectionLink)
.AsDocumentQuery();
var orders = new List <LiveOrderItem>();
while (ratingsQuery.HasMoreResults)
{
var results = await ratingsQuery.ExecuteNextAsync <LiveOrderItem>();
orders.AddRange(results);
}
return(orders);
}
async Task ProcessDistributorScoreData()
{
var groupedImportedOrdersByDistributor = importedOrders.SelectMany(ioi => ioi.Order)
.GroupBy(o => new { o.locationName, o.ponumber })
.Select(o => new SalesByDistributor()
{
Id = o.Key.ponumber,
Distributor = o.Key.locationName,
PointOfSale = o.Key.ponumber,
TotalQuantitySold = o.Sum(li => li.lineitems.Sum(a => a.quantity)),
TotalSales = o.Sum(li => li.lineitems.Sum(a => a.totalcost)),
});
var groupedLiveOrdersByDistributor = liveOrders
.GroupBy(h => new { h.header.locationName, h.header.salesNumber })
.Select(o => new SalesByDistributor()
{
Id = o.Key.salesNumber,
Distributor = o.Key.locationName,
PointOfSale = o.Key.salesNumber,
TotalQuantitySold = o.Sum(li => li.details.Sum(a => Int32.Parse(a.quantity))),
TotalSales = o.Sum(li => li.details.Sum(a => (float)Decimal.Parse(a.totalCost))),
});
var distributorResults = groupedLiveOrdersByDistributor.GroupJoin(groupedImportedOrdersByDistributor, o => o.Distributor, o => o.Distributor, (a, b) => new SalesByDistributor()
{
Id = a.Id,
Distributor = a.Distributor,
PointOfSale = a.PointOfSale,
TotalQuantitySold = a.TotalQuantitySold + b.Sum(c => c.TotalQuantitySold),
TotalSales = a.TotalSales + b.Sum(c => c.TotalSales),
});
foreach (var distributorResult in distributorResults)
{
await UpsertDocumentAsync(distributorResult, "DistributorScore", distributorResult.Id);
}
}
async Task ProcessProductScoreData()
{
var groupedImportedOrdersByProduct = importedOrders.SelectMany(ioi => ioi.Order)
.SelectMany(o => o.lineitems)
.GroupBy(li => new { productId = li.productid, productName = li.productname })
.Select(o => new SalesByProduct()
{
Id = o.Key.productId,
ProductId = o.Key.productId,
ProductName = o.Key.productName,
TotalQuantitySold = o.Sum(li => li.quantity),
TotalSales = o.Sum(li => li.totalcost),
});
var groupedLiveOrdersByProduct = liveOrders.SelectMany(loi => loi.details)
.GroupBy(li => new { li.productId, li.productName })
.Select(o => new SalesByProduct()
{
Id = o.Key.productId,
ProductId = o.Key.productId,
ProductName = o.Key.productName,
TotalQuantitySold = o.Sum(li => Int32.Parse(li.quantity)),
TotalSales = o.Sum(li => (float)Decimal.Parse(li.totalCost)),
});
var productResults = groupedLiveOrdersByProduct.GroupJoin(groupedImportedOrdersByProduct, o => o.ProductId, o => o.ProductId, (a, b) => new SalesByProduct()
{
Id = a.Id,
ProductId = a.ProductId,
ProductName = a.ProductName,
TotalQuantitySold = a.TotalQuantitySold + b.Sum(c => c.TotalQuantitySold),
TotalSales = a.TotalSales + b.Sum(c => c.TotalSales),
});
foreach (var productResult in productResults)
{
await UpsertDocumentAsync(productResult, "ProductScore", productResult.Id);
}
}
}
