private int CreateQuotationItemDetailTable(int count, OfficeOpenXml.ExcelWorksheet worksheet, List <QuotationItemDetailDto> quotationItemList)
{
var RowNumber = 29;
for (int i = 0; i < count; i++)
{
if (i < quotationItemList.Count)
{
worksheet.Cells[RowNumber, 1, RowNumber, 1].Value = quotationItemList[i].Style;
worksheet.Cells[RowNumber, 3, RowNumber, 3].Value = quotationItemList[i].Description;
worksheet.Cells[RowNumber, 4, RowNumber, 4].Value = quotationItemList[i].Quantity;
worksheet.Cells[RowNumber, 7, RowNumber, 7].Value = quotationItemList[i].UnitPrice;
}
RowNumber++;
}
var defaultItemrows = 26;
if (defaultItemrows > quotationItemList.Count)
{
worksheet.DeleteRow(56, 973, true);
}
else
{
var numberOfRowsToDelete = 1029 - (RowNumber + quotationItemList.Count);
worksheet.DeleteRow(RowNumber + quotationItemList.Count, numberOfRowsToDelete, true);
}
return(1);
}
public static ExcelWorksheet DeleteEndEmptyRows(this ExcelWorksheet ws)
{
while (ws.IsEndRowEmpty())
{
ws.DeleteRow(ws.Dimension.End.Row, 1);
}
return(ws);
}
private void InsertQuotationItemDetails(int count, OfficeOpenXml.ExcelWorksheet worksheet, List <QuotationItemDetailDto> quotationItemList, bool withDiscount)
{
var RowNumber = 29;
for (int i = 0; i < count; i++)
{
if (i < quotationItemList.Count)
{
worksheet.Cells[RowNumber, 1, RowNumber, 1].Value = quotationItemList[i].Style;
worksheet.Cells[RowNumber, 3, RowNumber, 3].Value = quotationItemList[i].Description;
worksheet.Cells[RowNumber, 4, RowNumber, 4].Value = quotationItemList[i].Quantity;
if (withDiscount)
{
worksheet.Cells[RowNumber, 7, RowNumber, 7].Value = quotationItemList[i].UnitPrice;
}
else
{
worksheet.Cells[RowNumber, 5, RowNumber, 5].Value = quotationItemList[i].UnitPrice;
}
}
RowNumber++;
}
var defaultItemrows = 26;
if (defaultItemrows > quotationItemList.Count)
{
var deleteFrom = 56;
worksheet.DeleteRow(deleteFrom, 973, true);
}
else
{
var numberOfRowsToDelete = 974 - (quotationItemList.Count - defaultItemrows);
worksheet.DeleteRow(RowNumber, numberOfRowsToDelete, true);
}
}