public FileContentResult ListExcel(IDbConnection connection, WaresFileListRequest request)
{
var data = List(connection, request).Entities;
var report = new DynamicDataReport(data, request.IncludeColumns, typeof(Columns.WaresFileColumns));
var bytes = new ReportRepository().Render(report);
return(ExcelContentResult.Create(bytes, "WaresFile_" +
DateTime.Now.ToString("ddMMyyyy_HHmmss") + ".xlsx"));
}
public ListResponse <MyRow> List(IDbConnection connection,
WaresFileListRequest request)
{
var user = (UserDefinition)Authorization.UserDefinition;
int tn = user.TenantId;
var data = connection.Query <MyRow>("usp_WaresFile",
param: new
{
dateFrom = request.StartDate,
dateTill = request.EndDate,
waresid = request.WaresID,
shopid = request.ShopID,
Tenant = tn
},
commandType: CommandType.StoredProcedure);
var response = new ListResponse <MyRow>();
response.Entities = (List <MyRow>)data;
return(response);
}
public ListResponse <MyRow> List(IDbConnection connection, WaresFileListRequest request)
{
return(new MyRepository().List(connection, request));
}
