public static string Execute() { var productsCatalogDb = new ProductsCatalogData(); var storeDb = new StoresData(); var productsCatalogEntries = productsCatalogDb.Products.All(); int countOfAddedProducts = 0; foreach (var catalogProduct in productsCatalogEntries) { storeDb.Products.Add(new StoreProduct() { Price = catalogProduct.Price, ProductCode = catalogProduct.ProductCode, Quantity = catalogProduct.Quantity, Status = catalogProduct.Status }); countOfAddedProducts++; } storeDb.SaveChanges(); return countOfAddedProducts + " products added to the store database"; }
public static string Execute() { var productsCatalogDb = new ProductsCatalogData(); var storeDb = new StoresData(); var productsCatalogEntries = productsCatalogDb.Products.All(); int countOfAddedProducts = 0; foreach (var catalogProduct in productsCatalogEntries) { storeDb.Products.Add(new StoreProduct() { Price = catalogProduct.Price, ProductCode = catalogProduct.ProductCode, Quantity = catalogProduct.Quantity, Status = catalogProduct.Status }); countOfAddedProducts++; } storeDb.SaveChanges(); return(countOfAddedProducts + " products added to the store database"); }
public static string Execute() { var db = new StoresData(); var jsonWriter = new JsonSalesReportWriter(db.Sales, db.Products); string reportDirectory = Directory.GetCurrentDirectory() + "\\Sales Reports"; jsonWriter.WriteData(reportDirectory); return "Json reports generated at location:\r\n" + reportDirectory; }
public static string Execute() { var storeDb = new StoresData(); var pdfWriter = new PdfTopSoldProductsTableWriter(storeDb.Sales); string reportDirectory = Directory.GetCurrentDirectory(); pdfWriter.WriteData(reportDirectory); return "PDF report written at follow location:\r\n" + reportDirectory; }
public static string Execute() { var storeDb = new StoresData(); var pdfWriter = new PdfTopSoldProductsTableWriter(storeDb.Sales); string reportDirectory = Directory.GetCurrentDirectory(); pdfWriter.WriteData(reportDirectory); return("PDF report written at follow location:\r\n" + reportDirectory); }
public static string Execute() { var db = new StoresData(); var jsonWriter = new JsonSalesReportWriter(db.Sales, db.Products); string reportDirectory = Directory.GetCurrentDirectory() + "\\Sales Reports"; jsonWriter.WriteData(reportDirectory); return("Json reports generated at location:\r\n" + reportDirectory); }
public static string Execute() { var storesDb = new StoresData(); var excelReader = new ExcelSalesReader(storesDb.Sales, storesDb.Products); var zipParser = new ZipParser("../../../Jan 2015 Report.zip", new List <string>() { ".xls" }, excelReader); zipParser.Parse(true); storesDb.SaveChanges(); return("Excels imported"); }