/// <summary>
/// Otwarcie okna dialogowego do wybrania pliku XLS
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void OpenFile_Click(object sender, RoutedEventArgs e)
{
//otwarcie okna dialogowego
Service.FileDialog dialog = new Service.FileDialog();
string FileName = dialog.OpenDialog();
//otwarcie pliku XLS
FileStream fileStream = new FileStream(FileName, FileMode.Open, FileAccess.Read);
ExcelParser xlsManager = new ExcelParser(fileStream);
//parsowanie pliku xls
List <ExcelContent> fileContent = new List <ExcelContent>();
fileContent = xlsManager.ParseExcel();
//dodanie wyniku parsowania do kolekcji
ExcelFiles.Add(new ExcelFile()
{
FileName = FileName,
Content = fileContent
});
excelContent.ItemsSource = rows;
FileList.Items.Refresh();
}
public List <ExcelContent> Transformfile()
{
if (HttpContext.Current.Request.Files.Count == 0)
{
throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Plik jest wymagany."));
}
Stream filename = HttpContext.Current.Request.Files[0].InputStream;
ExcelParser mmMaker = new ExcelParser(filename);
List <ExcelContent> parsedContent = mmMaker.ParseExcel();
return(parsedContent);
}
static void Main()
{
InitModules.PopulateProducts();
Console.WriteLine("Parsing excel reports...");
var excelReports = ExcelParser.ParseExcel(path);
Console.WriteLine("Inserting sales reports...");
foreach (var report in excelReports)
{
DBManager.InsertSalesReports(report);
}
Console.WriteLine("Generating pdf aggregated sales report.");
DatabaseToPdfWriter pdfWriter = new DatabaseToPdfWriter();
var reports = DBManager.RetrieveReports();
pdfWriter.GeneratePDFAggregatedSalesReports(reports, "..\\..\\Report.pdf");
Console.WriteLine("Generating sales by vendor XML file...");
DatabaseToXmlWriter xmlWriter = new DatabaseToXmlWriter();
xmlWriter.GenerateSalesReportByVendor(DBManager.RetrieveReportByVendors(), "..\\..\\Sales-by-Vendors-report.xml");
XmlParser xmlParser = new XmlParser();
DBManager.InsertVendorExpenses(xmlParser.ParseFile("..\\..\\Vendors-Expenses.xml"));
Console.WriteLine("Inserting data in MongoDb...");
Manager mongoManager = new Manager("mongodb://localhost");
mongoManager.AddProducts(DBManager.GetMonthlyProducts());
Console.WriteLine("Generating .xls file...");
DBManager.RetrieveProductReport();
DatabaseToExcelWriter.CreateExcelTable(DBManager.RetrieveTotalReport(DateTime.Now));
}