public async static Task UpdateProductProcessTaskAsync([QueueTrigger("product")] ProductMessage message)
{
var builder = new ConfigurationBuilder();
builder.Add(new JsonConfigurationSource("config.json"));
var config = builder.Build();
var connectionString = config["Data:DefaultConnection:ConnectionString"];
using (var context = new PartsUnlimitedContext(connectionString))
{
var dbProductList = await context.Products.ToListAsync();
foreach (var queueProduct in message.ProductList)
{
var dbProduct = dbProductList.SingleOrDefault(x => x.SkuNumber == queueProduct.SkuNumber);
if (dbProduct != null)
{
dbProduct.Inventory = queueProduct.Inventory;
dbProduct.LeadTime = queueProduct.LeadTime;
}
}
await context.SaveChangesAsync(CancellationToken.None);
}
}
public async static Task UpdateProductProcessTaskAsync([QueueTrigger("product")] ProductMessage message)
{
using (var context = new PartsUnlimitedContext())
{
var dbProductList = await context.Products.ToListAsync();
foreach (var queueProduct in message.ProductList)
{
var dbProduct = dbProductList.SingleOrDefault(x => x.SkuNumber == queueProduct.SkuNumber);
if (dbProduct != null)
{
dbProduct.Inventory = queueProduct.Inventory;
dbProduct.LeadTime = queueProduct.LeadTime;
}
}
await context.SaveChangesAsync(CancellationToken.None);
}
}