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");
}
}
/// <summary>
/// Opens the Excel Document
/// </summary>
public void Open()
{
excelDoc.Open();
}
