/// <summary>
/// Справка за доказателства в ексел
/// </summary>
/// <param name="courtId"></param>
/// <param name="model"></param>
/// <returns></returns>
public byte[] CaseEvidenceSpr_ToExcel(int courtId, CaseEvidenceSprFilterVM model)
{
var caseEvidenceSprs = CaseEvidenceSpr(courtId, model).OrderBy(x => x.DateAccept).ToList();
var htmlTemplate = repo.AllReadonly <HtmlTemplate>()
.Where(x => x.Alias.ToUpper() == "Evidence".ToUpper())
.FirstOrDefault();
NPoiExcelService excelService = new NPoiExcelService(htmlTemplate.Content, 0);
excelService.rowIndex = (htmlTemplate.XlsDataRow ?? 0) - 1;
excelService.InsertList(
caseEvidenceSprs,
new List <Expression <Func <CaseEvidenceSprVM, object> > >()
{
x => x.RegNumber,
x => x.DateAccept,
x => x.FileNumber,
x => x.CaseGroupLabel,
x => x.CaseNumber,
x => x.NamePodsydim,
x => x.Description,
x => x.MovementsDateSend,
x => x.MovementsDateReceive,
x => x.Movements
}
);
return(excelService.ToArray());
}
