public static void ImportExpensesFromXml() { var expenses = ReadXML.GetObjects("..\\..\\..\\Vendors-Expenses.xml"); using (var context = new SuperMarketContext()) { foreach (var expense in expenses) { context.Expenses.Add(new Expense { VendorName = expense.Item1, Month = expense.Item2, Value = expense.Item3 }); } context.SaveChanges(); } }
private static void InsertToDB(Location location, Date date, Sale sale) { SuperMarketContext supermarketDb = new SuperMarketContext(); int dateId = supermarketDb.Dates.Where(x => x.SaleDate == date.SaleDate).Select(x => x.DateId).FirstOrDefault(); int locationId = supermarketDb.Locations.Where(x => x.Name == location.Name).Select(x => x.LocationId).FirstOrDefault(); if ((dateId == 0) && (locationId == 0)) { supermarketDb.Dates.Add(new Date() { SaleDate = date.SaleDate }); supermarketDb.Locations.Add(new Location() { Name = location.Name }); } else if (dateId == 0) { supermarketDb.Dates.Add(new Date() { SaleDate = date.SaleDate }); sale.LocationId = locationId; } else if (locationId == 0) { supermarketDb.Locations.Add(new Location() { Name = location.Name }); sale.DateId = dateId; } else { sale.DateId = dateId; sale.LocationId = locationId; } supermarketDb.Sales.Add(sale); supermarketDb.SaveChanges(); }