public IEnumerable <itemDetails> GetItemDetails()
{
string fileName = String.Format(@"C:\Users\ska338\react-redux-starter\files\Student.xlsx");
var genList = new List <itemDetails>();
using (SpreadsheetDocument spreadSheetDocument = SpreadsheetDocument.Open(fileName, false))
{
WorkbookPart workbookPart = spreadSheetDocument.WorkbookPart;
IEnumerable <Sheet> sheets = spreadSheetDocument.WorkbookPart.Workbook.GetFirstChild <Sheets>().Elements <Sheet>();
string relationshipId = sheets.First().Id.Value;
WorksheetPart worksheetPart = (WorksheetPart)spreadSheetDocument.WorkbookPart.GetPartById(relationshipId);
Worksheet workSheet = worksheetPart.Worksheet;
SheetData sheetData = workSheet.GetFirstChild <SheetData>();
IEnumerable <Row> rows = sheetData.Descendants <Row>();
var i = 0;
foreach (Row row in rows)
{
if (i != 0 && row != null)
{
List <Cell> cells = row.Descendants <Cell>().ToList();
var itemDetails = new itemDetails();
itemDetails.toothNumber = Convert.ToInt32(cells[0].InnerText.ToString());
itemDetails.itemCode = cells[1].InnerText.ToString();
itemDetails.price = Convert.ToDecimal(cells[2].InnerText.ToString());
genList.Add(itemDetails);
}
i++;
}
}
return(genList);
}
private void SetUpShop(Collision col)
{
//find object in children
itemDetails iD = col.gameObject.GetComponentInChildren <itemDetails>();
costOfItems += iD.itemValue;
moneyObject.SetActive(true);
showPrice.SetText("Price:\n\n{0}", costOfItems);
moneyObject.transform.position = payOutLocation.transform.position;
stuffToSell.Add(col.gameObject);
}
private void OnCollisionExit(Collision collision)
{
if (collision.gameObject.tag == purchaseTagString)
{
stuffToSell.Remove(collision.gameObject);
itemDetails iD = collision.gameObject.GetComponentInChildren <itemDetails>();
costOfItems -= iD.itemValue;
showPrice.SetText("Price:\n\n{0}", costOfItems);
}
if (stuffToSell.Count == 0)
{
moneyObject.SetActive(false);
}
}