protected void WriteCsvRecords <TMapper, TModel>(CsvWriter csvWriter, TMapper mapper, ModelProperty[] modelProperties, TModel record)
where TMapper : ClassMap
{
List <object> values = new List <object>();
foreach (var modelProperty in modelProperties)
{
_valueProvider.GetFormattedValue(values, modelProperty.MethodInfo.GetValue(record));
}
WriteCsvRecords(csvWriter, values.ToArray());
}
protected void WriteExcelRecords <TMapper, TModel>(
Worksheet worksheet,
TMapper classMap,
ModelProperty[] modelProperties,
TModel record,
CellStyle recordStyle,
bool pivot = false)
where TMapper : ClassMap
where TModel : class
{
int currentRow = GetCurrentRow(worksheet);
int column = 0;
if (pivot)
{
// If we have pivoted then we need to move one column in, as the header is in column 1.
column = 1;
}
List <object> values = new List <object>();
foreach (ModelProperty modelProperty in modelProperties)
{
_valueProvider.GetFormattedValue(values, modelProperty.MethodInfo.GetValue(record), classMap, modelProperty);
}
worksheet.Cells.ImportObjectArray(values.ToArray(), currentRow, column, pivot);
if (recordStyle != null)
{
worksheet.Cells.CreateRange(currentRow, column, pivot ? values.Count : 1, pivot ? 1 : values.Count).ApplyStyle(recordStyle.Style, recordStyle.StyleFlag);
}
if (pivot)
{
currentRow += values.Count;
}
else
{
currentRow++;
}
SetCurrentRow(worksheet, currentRow);
}
protected void WriteExcelRecords <TMapper, TModel>(Worksheet worksheet, TMapper classMap, IEnumerable <TModel> records, CellStyle headerStyle, CellStyle recordStyle, bool pivot = false)
where TMapper : ClassMap
where TModel : class
{
int currentRow = GetCurrentRow(worksheet);
ModelProperty[] modelProperties = classMap.MemberMaps.OrderBy(x => x.Data.Index).Select(x => new ModelProperty(x.Data.Names.Names.ToArray(), (PropertyInfo)x.Data.Member)).ToArray();
string[] names = modelProperties.SelectMany(x => x.Names).ToArray();
worksheet.Cells.ImportObjectArray(names, currentRow, 0, pivot);
if (headerStyle != null)
{
worksheet.Cells.CreateRange(currentRow, 0, pivot ? names.Length : 1, pivot ? 1 : names.Length).ApplyStyle(headerStyle.Style, headerStyle.StyleFlag);
}
int column = 0, localRow = currentRow;
if (pivot)
{
// If we have pivoted then we need to move one column in, as the header is in column 1.
column = 1;
}
else
{
currentRow++;
localRow++;
}
foreach (TModel record in records)
{
int widestColumn = 1;
foreach (var modelProperty in modelProperties)
{
List <object> values = new List <object>();
_valueProvider.GetFormattedValue(values, modelProperty.MethodInfo.GetValue(record), classMap, modelProperty);
worksheet.Cells.ImportObjectArray(values.ToArray(), localRow, column, false);
if (recordStyle != null)
{
worksheet.Cells.CreateRange(localRow, column, 1, values.Count).ApplyStyle(recordStyle.Style, recordStyle.StyleFlag);
}
if (pivot)
{
localRow++;
}
else
{
column += values.Count;
}
if (values.Count > widestColumn)
{
widestColumn = values.Count;
}
}
if (pivot)
{
column += widestColumn;
localRow = currentRow;
}
}
if (pivot)
{
currentRow += names.Length;
}
else
{
currentRow += records.Count();
}
SetCurrentRow(worksheet, currentRow);
}