int PopulateInvoiceGoodsList() { int goodsCount = 0; Worksheet currentSheet = Workbook.Worksheets[0]; for (int i = 0; i < invoiceGoods.Count; ++i) { if (invoiceGoods[i].Quantity > 0) { int currentRowIndex = goodsStartRow + goodsCount; Row currentRow = currentSheet.Rows[currentRowIndex]; InvoiceInMemoryData item = invoiceGoods[i]; currentRow[1].Value = item.ProductName; currentRow[2].Value = item.Quantity; currentRow[3].Value = item.Price; currentRow[4].Value = item.Discount; if ((goodsCount % 2) != 0) { SetRangeFillColor(currentSheet.Range.FromLTRB(1, currentRowIndex, 5, currentRowIndex), goodsEvenColor); } ++goodsCount; if (goodsCount >= maxItemsInInvoice) { break; } } } return(goodsCount); }
public void AddGoods(InvoiceInMemoryData value) { invoiceGoods.Add(value); }