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