public MemoryStream ExportByForm(string formId)
{
using (ExcelGenerator excel = new ExcelGenerator())
{
var form = _formService.Get(formId);
var formDatas = Get(m => m.FormId == formId);
excel.AddRow(row =>
{
foreach (var item in form.FormFields)
{
row.AppendCell(item.DisplayName);
}
});
foreach (var data in formDatas)
{
excel.AddRow(row =>
{
foreach (var item in Get(data.ID).Form.FormFields)
{
row.AppendCell(item.DisplayValue());
}
});
}
return(excel.ToMemoryStream());
}
}
public MemoryStream Export(int id)
{
using (ExcelGenerator excel = new ExcelGenerator())
{
FormData formData = Get(id);
excel.AddRow(row =>
{
foreach (var item in formData.Form.FormFields)
{
row.AppendCell(item.DisplayName);
}
});
excel.AddRow(row =>
{
foreach (var item in formData.Form.FormFields)
{
row.AppendCell(item.DisplayValue());
}
});
return(excel.ToMemoryStream());
}
}
public byte[] GetAllUsersExcel()
{
var applicationUsers = _usersDbSet
.Include(user => user.WorkingHours)
.Include(user => user.JobPosition)
.Where(user => user.OrganizationId == 2)
.ToList();
using (var printer = new ExcelGenerator("Users"))
{
printer.CenterColumns(2, 6);
printer.AddHeaderRow(HeaderRow());
foreach (var user in applicationUsers)
{
printer.AddRow(UserToUserRow(user));
}
return(printer.Generate());
}
}
