public byte[] CreateNewStatusesReport(ObservableCollection <AccountsMainSet> accountsList)
{
byte[] resultPackage;
using (ExcelPackage p = new ExcelPackage())
{
p.Workbook.Worksheets.Add("Report");
var ws = p.Workbook.Worksheets[1];
ws.Cells[1, 1].Value = @"Номер п\п";
ws.Cells[1, 2].Value = "Объект";
ws.Cells[1, 3].Value = "Поставщик";
ws.Cells[1, 4].Value = "Номер счета";
ws.Cells[1, 5].Value = "Дата счета";
ws.Cells[1, 6].Value = "Сумма счета";
ws.Cells[1, 1, 1, 6].Style.Font.Bold = true;
var i = 1;
foreach (var account in accountsList)
{
ws.Cells[i + 1, 1].Value = i;
ws.Cells[i + 1, 2].Value = (account.AccountsStoreDetailsSets.Count > 1) ? "По списку" : ((account.AccountsStoreDetailsSets.Count == 0) ? "Не задан" : _storeService.GetStoreName(account.AccountsStoreDetailsSets.FirstOrDefault().AccountStore));
ws.Cells[i + 1, 3].Value = account.AccountCompany;
ws.Cells[i + 1, 4].Value = account.AccountNumber;
ws.Cells[i + 1, 5].Value = account.AccountDate.ToShortDateString();
ws.Cells[i + 1, 6].Value = account.AccountAmount;
i++;
}
for (int k = 1; k <= 6; k++)
{
ws.Column(k).AutoFit(k);
}
resultPackage = p.GetAsByteArray();
return(resultPackage);
}
}