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