public static void WriteSellsReports(ICollection<SellsReport> reports)
{
using (supermarketEntities sqlDB = new supermarketEntities())
{
List<int> ids = sqlDB.SellsReports.Select(x => x.ID).ToList();
foreach (var report in reports)
{
if (!ids.Contains(report.ID))
{
sqlDB.SellsReports.Add(report);
}
}
sqlDB.SaveChanges();
}
}
public static void WriteVendors(ICollection<Vendor> vendors)
{
using (supermarketEntities sqlDB = new supermarketEntities())
{
List<int> ids = sqlDB.Vendors.Select(x => x.ID).ToList();
foreach (var vendor in vendors)
{
if (!ids.Contains(vendor.ID))
{
sqlDB.Vendors.Add(vendor);
}
}
sqlDB.SaveChanges();
}
}
public static void WriteMesures(ICollection<Mesure> mesures)
{
using (supermarketEntities sqlDB = new supermarketEntities())
{
List<int> ids = sqlDB.Mesures.Select(x => x.ID).ToList();
foreach (var mesure in mesures)
{
if (!ids.Contains(mesure.ID))
{
sqlDB.Mesures.Add(mesure);
}
}
sqlDB.SaveChanges();
}
}
public static void WriteProducts(ICollection<Product> products)
{
using (supermarketEntities sqlDB = new supermarketEntities())
{
List<int> ids = sqlDB.Products.Select(x => x.ID).ToList();
foreach (var product in products)
{
if (!ids.Contains(product.ID))
{
sqlDB.Products.Add(product);
}
}
sqlDB.SaveChanges();
}
}
public static void WriteVendorExpenses(ICollection<Expenses> expenses)
{
using (supermarketEntities sqlDB = new supermarketEntities())
{
List<int> ids = sqlDB.Expenses.Select(x => x.ID).ToList();
foreach (var expens in expenses)
{
if (!ids.Contains(expens.ID))
{
sqlDB.Expenses.Add(expens);
}
}
sqlDB.SaveChanges();
}
}
