public static void StockRequestsToExcel(string filename = "stockRequests.xlsx")
{
string sheetName = "StockRequests";
List <StockRequest> requests = StockRequest.GetAllShelfRestockRequests();
var workbook = new XLWorkbook();
workbook.AddWorksheet(sheetName);
var ws = workbook.Worksheet(sheetName);
int row = 1;
ws.Cell("A" + row.ToString()).Value = "Name";
ws.Cell("B" + row.ToString()).Value = "Description";
ws.Cell("C" + row.ToString()).Value = "Quantity";
ws.Cell("D" + row.ToString()).Value = "QuantityInDepot";
ws.Cell("E" + row.ToString()).Value = "QuantityInStore";
row++;
foreach (StockRequest item in requests)
{
ws.Cell("A" + row.ToString()).Value = item.Name;
ws.Cell("B" + row.ToString()).Value = item.Description;
ws.Cell("C" + row.ToString()).Value = item.Quantity;
ws.Cell("D" + row.ToString()).Value = item.QuantityInDepot;
ws.Cell("E" + row.ToString()).Value = item.QuantityInStore;
row++;
}
workbook.SaveAs(filename);
}
public ShelfRestockRequests()
{
InitializeComponent();
List <StockRequest> requests = StockRequest.GetAllShelfRestockRequests();
shelfRestockView.Items.Clear();
foreach (StockRequest request in requests)
{
shelfRestockView.Items.Add(new ListViewItem(new[] { "[WIP, in later phase]", request.Name, request.Description, request.Quantity.ToString() }));
}
}
