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; }