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