/// <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");
}
}
