/// <summary> /// Builds the Min-Max DataTable. /// </summary> /// <returns>A DataTable representing all the QuickBooks Data to be written to the Min-Max Doc.</returns> public DataTable Analyze() { if (!excelDoc.excelObjSet) { excelDoc.SetExcelObjects(); } if (excelDoc.excelObjSet) { Log.WriteLine("...Analyzing Part Numbers..."); IQuickBooksData itemDataTable = new ItemDataTable(); IQuickBooksData salesOrderDataTable = new SODataTable(); excelDoc.InStreamData(); itemDataTable.BuildTable(); salesOrderDataTable.BuildTable(); minMaxDt = new DataTable().BuildTable(salesOrderDataTable, itemDataTable, excelDoc.partNumList); excelDoc.Write(minMaxDt); return(minMaxDt); } else { Log.WriteLine("Cannot Access Min-Max Document."); return(new DataTable()); } }
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()); }
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"); } }