private void CommitToDatabase(List <ChannelAdvisorSale> sales)
{
using (var db = new CheapeesEntities())
{
foreach (var sale in sales)
{
if (db.MerchantFulfilledSales.Local.Count(o => (o.Invoice.Equals(sale.Invoice) && o.Sku.Equals(sale.SKU))) == 0 && db.MerchantFulfilledSales.Count(o => (o.Invoice.Equals(sale.Invoice) && o.Sku.Equals(sale.SKU))) == 0)
{
MerchantFulfilledSale dbSale = new MerchantFulfilledSale();
dbSale.Invoice = sale.Invoice;
dbSale.Marketplace = sale.Marketplace;
dbSale.OrderTime = sale.OrderTime;
dbSale.Quantity = sale.Quantity;
dbSale.Sku = sale.SKU;
dbSale.UnitPrice = sale.UnitPrice;
db.MerchantFulfilledSales.Add(dbSale);
}
}
db.SaveChanges();
}
}
private void CommitToDatabase(List<ChannelAdvisorSale> sales)
{
using (var db = new CheapeesEntities())
{
foreach (var sale in sales)
{
if (db.MerchantFulfilledSales.Local.Count(o => (o.Invoice.Equals(sale.Invoice) && o.Sku.Equals(sale.SKU))) == 0 && db.MerchantFulfilledSales.Count(o => (o.Invoice.Equals(sale.Invoice) && o.Sku.Equals(sale.SKU))) == 0)
{
MerchantFulfilledSale dbSale = new MerchantFulfilledSale();
dbSale.Invoice = sale.Invoice;
dbSale.Marketplace = sale.Marketplace;
dbSale.OrderTime = sale.OrderTime;
dbSale.Quantity = sale.Quantity;
dbSale.Sku = sale.SKU;
dbSale.UnitPrice = sale.UnitPrice;
db.MerchantFulfilledSales.Add(dbSale);
}
}
db.SaveChanges();
}
}
