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