public static void LoadTotalOrders()
{
DataTable tempBoughtItems = new DataTable();
tempBoughtItems = new DataTable();
tempBoughtItems.Columns.Add("Item", typeof(IItem));
tempBoughtItems.Columns.Add("Count", typeof(int));
int[] columnsString = new int[1] {
0
};
int[] columnNumber = new int[1] {
1
};
string[,] output = ExcelReader_NPOI.ReadAllXLSX("OrderStats.xlsx", columnsString, columnNumber, false);
for (int i = 0; i < output.GetLength(0); i++)
{
if (output[i, 0] != null)
{
float totalBought = float.Parse(output[i, 1]);
IItem item = null;
for (int j = 0; j < totalItems.Count; j++)
{
if (totalItems[j].EnglishName == output[i, 0])
{
item = totalItems[j];
break;
}
}
tempBoughtItems.Rows.Add(item, totalBought);
}
}
totalBoughtItems = tempBoughtItems;
}
public static void LoadItems()
{
totalItems = new List <IItem>();
int[] columnsString = new int[2] {
0, 1
};
int[] columnNumber = new int[1] {
2
};
string[,] output = ExcelReader_NPOI.ReadAllXLSX("FoodItems.xlsx", columnsString, columnNumber, true);
XSSFWorkbook footItemsBook = ExcelReader_NPOI.OpenXLSX("FoodItems.xlsx", true);
for (int i = 0; i < output.GetLength(0); i++)
{
float price = float.Parse(output[i, 2]);
if (price == -1)
{
float smallPrice = float.Parse(ExcelReader_NPOI.ReadSingleXLSXFromWorkBook(footItemsBook, i, 3, true));
float largePrice = float.Parse(ExcelReader_NPOI.ReadSingleXLSXFromWorkBook(footItemsBook, i, 4, true));
SizeItem item = new SizeItem(output[i, 0], output[i, 1], i + 1, smallPrice, largePrice);
totalItems.Add(item);
}
else if (price == -2)
{
float wholePrice = float.Parse(ExcelReader_NPOI.ReadSingleXLSXFromWorkBook(footItemsBook, i, 3, true));
float halfPrice = float.Parse(ExcelReader_NPOI.ReadSingleXLSXFromWorkBook(footItemsBook, i, 4, true));
float quarterPrice = float.Parse(ExcelReader_NPOI.ReadSingleXLSXFromWorkBook(footItemsBook, i, 5, true));
PieItem item = new PieItem(output[i, 0], output[i, 1], i + 1, wholePrice, halfPrice, quarterPrice);
//Console.WriteLine("seabass");
totalItems.Add(item);
}
else
{
Item item = new Item(output[i, 0], output[i, 1], i + 1, price);
totalItems.Add(item);
}
}
}