public static ImportResult ImportVendors(IEnumerable<MySqlVendor> vendorsData)
{
var context = new MySqlSupermarketContext();
int inserted = 0;
int updated = 0;
foreach (var vendor in vendorsData)
{
var existingVendor = context.vendors.Where(v => v.Name == vendor.Name).FirstOrDefault();
if (existingVendor == null)
{
var newVendor = new MySqlVendor() { Name = vendor.Name, Expenses = vendor.Expenses };
context.vendors.Add(newVendor);
inserted++;
}
else
{
existingVendor.Expenses = vendor.Expenses;
updated++;
}
}
context.SaveChanges();
return new ImportResult() { Inserted = inserted, Updated = updated};
}
public static ImportResult ImportProducts(IEnumerable<MySqlProduct> productsData)
{
var context = new MySqlSupermarketContext();
int inserted = 0;
int updated = 0;
foreach (var product in productsData)
{
var existingProduct = context.products.Where(p => p.Name == product.Name).FirstOrDefault();
if (existingProduct == null)
{
var newProduct = new MySqlProduct()
{
Name = product.Name,
Incomes = product.Incomes,
Vendor = context.vendors.Where(v => v.Name == product.Vendor.Name).FirstOrDefault()
};
context.products.Add(newProduct);
inserted++;
}
else
{
existingProduct.Incomes = product.Incomes;
updated++;
}
}
context.SaveChanges();
return new ImportResult() { Inserted = inserted, Updated = updated };
}
private IEnumerable<VendorIncome> GetVendorsIncomesFromMySql()
{
var context = new MySqlSupermarketContext();
var vendorsIncomes = context.vendors
.Select(v => new VendorIncome()
{
VendorName = v.Name,
ProductIncomes = v.Products.Select(p => new ProductIncome()
{
ProductName = p.Name,
Income = p.Incomes
}).ToList()
}).ToList();
return vendorsIncomes;
}
private IEnumerable<VendorExpense> GetVendorExpensesFromMySql()
{
var context = new MySqlSupermarketContext();
var vendorExpenses = context.vendors
.Select(v => new VendorExpense()
{
VendorName = v.Name,
Expense = v.Expenses
}).ToList();
return vendorExpenses;
}