/// <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 ExcelWriteTest()
{
IQuickBooksData itemTable = new ItemDataTable();
IQuickBooksData soTable = new SODataTable();
itemTable.BuildTable();
soTable.BuildTable();
using (excelDoc = new ExcelDoc())
{
excelDoc.Open();
excelDoc.InStreamData();
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");
excelDoc.Write(minMaxDt);
}
}