public void InStreamDataTest() { excelDoc = new ExcelDoc(); excelDoc.Open(); excelDoc.InStreamData(); excelDoc.Close(); StringBuilder sb = new StringBuilder(); foreach (KeyValuePair <string, ExcelPartNumber> kvp in excelDoc.partNumList) { sb.AppendLine(kvp.Key + " " + kvp.Value.restockSODate + " " + kvp.Value.bracketsPerSheet); } System.IO.File.WriteAllText(@"\\msw-fp1\user$\wchan\Documents\InventoryManagementAppTest\Part Numbers.txt", sb.ToString()); }
/// <summary> /// Opens the specified filepath for reading /// </summary> /// <returns></returns> public void OpenExcelReader() { if (ExcelDoc != null) { ExcelDoc.Close(); ExcelDoc.Dispose(); } if (ExcelStream != null) { ExcelStream.Close(); ExcelStream.Dispose(); } ExcelStream = System.IO.File.Open(ExcelFilePath, FileMode.Open, FileAccess.Read); ExcelDoc = DocumentFormat.OpenXml.Packaging.SpreadsheetDocument.Open(ExcelStream, false); }
public void PolyMinMaxTest() { QuickBooksDataTable itemTable = new ItemDataTable(); QuickBooksDataTable soTable = new SODataTable(); itemTable.BuildTable(); soTable.BuildTable(); using (excelDoc = new ExcelDoc()) { excelDoc.Open(); excelDoc.InStreamData(); excelDoc.Close(); DataTable minMaxDt = new DataTable().BuildTable(soTable, itemTable, excelDoc.partNumList); minMaxDt.Write(@"\\msw-fp1\user$\wchan\Documents\Visual Studio 2015\Projects\InventoryManagementApp\InventoryManagementApp\bin\Debug\Test\PolyMinMax.csv"); } }
public void ProcessRaceReport(RaceReport raceReport) { var currentReportsRace = _raceService.GetRace(raceReport.Race.Id.Value); _context.Races.Attach(currentReportsRace); raceReport.Race = currentReportsRace; CheckForPersonalBests(raceReport); ProcessIndividualResults(raceReport); var datestring = currentReportsRace.Date.ToShortDateString(); var path = Path.Combine(System.Web.HttpContext.Current.Server.MapPath("~/content/excelfiles/"), currentReportsRace.RaceName + datestring.Replace('/', '-') + ".xlsx"); ExcelDoc ex = new ExcelDoc(); ex.CreateNewFile(); WriteNameColumn(ex, raceReport); WriteTimeColumn(ex, raceReport); WritePlaceColumn(ex, raceReport); ex.SaveAs(path); ex.Close(); FileStream fs = new FileStream(path, FileMode.Open, FileAccess.Read); BinaryReader reader = new BinaryReader(fs); RaceReportBinary binary = new RaceReportBinary { RaceId = raceReport.Race.Id, Data = reader.ReadBytes((Int32)fs.Length), FileName = currentReportsRace.RaceName + datestring.Replace('/', '-') + ".xlsx" }; var reportindb = _context.RaceReports.SingleOrDefault(r => r.FileName == binary.FileName); if (reportindb == null) { _context.RaceReports.Add(binary); } else { reportindb.FileName = binary.FileName; reportindb.Data = binary.Data; } try { _context.SaveChanges(); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { System.Diagnostics.Debug.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { System.Diagnostics.Debug.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } fs.Close(); reader.Close(); System.IO.File.Delete(path); }
/// <summary> /// Closes the Excel Document /// </summary> public void Close() { excelDoc.Close(); }