public static void ExecuteTransferFromZipToMssql()
{
var sqlContext = new SupermarketsChainMssqlContext();
Console.WriteLine();
Console.WriteLine("Extracting data from reports...\n");
var zipManager = new ZipManager(Constants.SalesImportPath, sqlContext);
using (TransactionScope tran = new TransactionScope())
{
Console.WriteLine("\nSending data to SQL Server...");
zipManager.TransferData();
tran.Complete();
}
Console.WriteLine("Sales reports imported.");
}
public static void ExecuteTransferFromXmlToMssql()
{
var sqlContext = new SupermarketsChainMssqlContext();
Console.WriteLine();
Console.WriteLine("Extracting data from reports...\n");
var xmlManager = new XmlManager(Constants.XmlExpensesPath, sqlContext);
using (TransactionScope tran = new TransactionScope())
{
Console.WriteLine("\nSending data to SQL Server...");
xmlManager.TransferData();
tran.Complete();
}
Console.WriteLine("Sales reports imported.");
}
public XmlManager(string expensesImportPath, SupermarketsChainMssqlContext context)
{
this.ExpensesImportPath = expensesImportPath;
this.SqlMarketContext = context;
}
public XmlManager(string expensesImportPath, SupermarketsChainMssqlContext context)
{
this.ExpensesImportPath = expensesImportPath;
this.SqlMarketContext = context;
}
public ZipManager(string archivePath, SupermarketsChainMssqlContext context)
{
this.ArchivePath = archivePath;
this.SqlMarketContext = context;
}
public ZipManager(string archivePath, SupermarketsChainMssqlContext context)
{
this.ArchivePath = archivePath;
this.SqlMarketContext = context;
}