public static void Execute()
{
string topPath = @"../../../../WritingFiles/";
string jsonPath = @"../../../../WritingFiles/JSON/";
Directory.Delete(topPath, true);
Directory.CreateDirectory(topPath);
Directory.CreateDirectory(jsonPath);
SuperMarketEntities dbContext = new SuperMarketEntities();
using (dbContext)
{
dbContext.Database.ExecuteSqlCommand("DELETE FROM SalesReports");
dbContext.Database.ExecuteSqlCommand("DELETE FROM Locations");
dbContext.Database.ExecuteSqlCommand("DELETE FROM Products");
dbContext.Database.ExecuteSqlCommand("DELETE FROM VendorExpenses");
dbContext.Database.ExecuteSqlCommand("DELETE FROM Vendors");
dbContext.Database.ExecuteSqlCommand("DELETE FROM Measures");
dbContext.Database.ExecuteSqlCommand("DBCC CHECKIDENT (SalesReports, reseed, 0)");
dbContext.Database.ExecuteSqlCommand("DBCC CHECKIDENT (Locations, reseed, 0)");
dbContext.Database.ExecuteSqlCommand("DBCC CHECKIDENT (Products, reseed, 0)");
dbContext.Database.ExecuteSqlCommand("DBCC CHECKIDENT (VendorExpenses, reseed, 0)");
dbContext.Database.ExecuteSqlCommand("DBCC CHECKIDENT (Vendors, reseed, 0)");
dbContext.Database.ExecuteSqlCommand("DBCC CHECKIDENT (Measures, reseed, 0)");
dbContext.SaveChanges();
}
}
public static void PopulateVendorExpensesInSQL()
{
SuperMarketEntities dbContext = new SuperMarketEntities();
List<VendorExpense> vendorExpenses = XMLDataTransefer.GetVendorExpenses();
using(dbContext)
{
VendorExpens currReport = null;
foreach (var vendorExpnese in vendorExpenses)
{
for (int itemIdex = 0; itemIdex < vendorExpnese.MonthDates.Count; itemIdex++)
{
currReport = new VendorExpens();
currReport.VendorID = vendorExpnese.VendorID;
currReport.MonthDate = vendorExpnese.MonthDates[itemIdex];
currReport.Expnenses = vendorExpnese.Expenses[itemIdex];
dbContext.VendorExpenses.Add(currReport);
}
}
dbContext.SaveChanges();
}
}
public static void PopulateMeasures()
{
Measure currMeasure = null;
using (DataSender.dbContext = new SuperMarketEntities())
{
foreach (var measure in DataSender.measures)
{
currMeasure = new Measure();
currMeasure.MeasureID = measure.MeasureID;
currMeasure.Name = measure.Name;
dbContext.Measures.Add(currMeasure);
dbContext.SaveChanges();
}
}
}
public static void PopulateVendors()
{
Vendor currVendor = null;
using (DataSender.dbContext = new SuperMarketEntities())
{
foreach (var vendor in DataSender.vendors)
{
currVendor = new Vendor();
currVendor.VendorID = vendor.VendorID;
currVendor.VendorName = vendor.Name;
dbContext.Vendors.Add(currVendor);
dbContext.SaveChanges();
}
}
}
public static void PopulateProducts()
{
Product currProduct = null;
using (DataSender.dbContext = new SuperMarketEntities())
{
foreach (var product in DataSender.products)
{
currProduct = new Product();
currProduct.ProductID = product.ProductID;
currProduct.ProductName = product.Name;
currProduct.MeasureID = product.MeasureID;
currProduct.BasePrice = product.BasePrice;
currProduct.VendorID = product.VendorID;
dbContext.Products.Add(currProduct);
dbContext.SaveChanges();
}
}
}
