static void Main(string[] args)
{
Console.Util.SetSize();
Console.Util.SetTitle();
System.Console.CursorVisible = false;
Excel.FinishedGoods finishedGoods = new Excel.FinishedGoods();
CSV.Common requiredFiles = new CSV.Common();
if (requiredFiles.AllFilesReady == false)
{
throw new Exception("File loading error");
}
System.Console.SetCursorPosition(0, 30);
CSV.Tableau tableau = new CSV.Tableau();
System.Console.Write("Customer: ");
System.Console.CursorVisible = true;
ConsoleKey key = System.Console.ReadKey().Key;
System.Console.CursorTop = System.Console.CursorTop - 1;
System.Console.Write(new string(' ', System.Console.WindowWidth));
switch (key)
{
case ConsoleKey.D1:
CreateExternalCOA(tableau.FileContents, requiredFiles, finishedGoods, Excel.Workbook.CustomerName.TaylorFarmsTennessee);
break;
case ConsoleKey.NumPad1:
CreateExternalCOA(tableau.FileContents, requiredFiles, finishedGoods, Excel.Workbook.CustomerName.TaylorFarmsTennessee);
break;
case ConsoleKey.D2:
CreateExternalCOA(tableau.FileContents, requiredFiles, finishedGoods, Excel.Workbook.CustomerName.Latitude36);
break;
case ConsoleKey.NumPad2:
CreateExternalCOA(tableau.FileContents, requiredFiles, finishedGoods, Excel.Workbook.CustomerName.Latitude36);
break;
case ConsoleKey.D3:
CreateInternalCOA(requiredFiles, finishedGoods, Excel.Workbook.CustomerName.KootenaiAndCheese);
break;
case ConsoleKey.NumPad3:
CreateInternalCOA(requiredFiles, finishedGoods, Excel.Workbook.CustomerName.KootenaiAndCheese);
break;
default:
break;
}
}
static void CreateInternalCOA(CSV.Common common, Excel.FinishedGoods finishedGoods, Excel.Workbook.CustomerName customerName)
{
string input;
int daysBackToInclude;
do
{
System.Console.SetCursorPosition(0, 30);
System.Console.Write(new string(' ', System.Console.WindowWidth));
System.Console.SetCursorPosition(0, 30);
System.Console.Write("Days before " + DateTime.Now.ToShortDateString() + ": ");
input = System.Console.ReadLine();
} while (int.TryParse(input, out daysBackToInclude) == false);
// A string is used as the hashset can't easily differentiate arrays with matching contents
HashSet <string> set = new HashSet <string>();
foreach (List <string> line in common.DelimitedMicroResults)
{
for (int i = 0; i < daysBackToInclude; i++)
{
if (line[5] == DateTime.Now.AddDays(i * -1).ToString("M/d/yy") || line[5] == DateTime.Now.AddDays(i * -1).ToShortDateString())
{
if (line[16] == "K1")
{
if (line[10].Contains('/') || line[10].Contains('\\'))
{
char[] delimit = { '/', '\\' };
string reformattedEntry = line[10].Split(delimit)[0];
reformattedEntry += " & ";
reformattedEntry += line[10].Split(delimit)[1];
set.Add(Convert.ToDateTime(line[9]).ToString("M-d-yy") + "," + reformattedEntry);
}
else
{
set.Add(Convert.ToDateTime(line[9]).ToString("M-d-yy") + "," + line[10]);
}
}
}
}
}
foreach (string productAndDateCombo in set)
{
Excel.Workbook workbook = new Excel.Workbook(common.DelimitedTitrationResults, common.DelimitedMicroResults, customerName, finishedGoods.Contents, common.Recipes,
Excel.Workbook.CustomerType.Internal);
workbook.InternalCOAData = productAndDateCombo.Split(new char[] { ',' });
Thread thread = new Thread(workbook.Generate);
thread.Start();
}
}
static void CreateExternalCOA(List <List <List <string> > > tableauData, CSV.Common common, Excel.FinishedGoods finishedGoods, Excel.Workbook.CustomerName customerName)
{
foreach (List <List <string> > order in tableauData)
{
Excel.Workbook workbook = new Excel.Workbook(common.DelimitedTitrationResults, common.DelimitedMicroResults, customerName, finishedGoods.Contents, common.Recipes,
Excel.Workbook.CustomerType.External);
workbook.TableauData = order;
Thread thread = new Thread(workbook.Generate);
thread.Start();
}
}