public FileContentResult ListExcel(IDbConnection connection, ListRequest request)
{
var fields = MyRow.Fields;
//request.IncludeColumns.Clear();
//request.IncludeColumns.Add(fields.ProjectType.PropertyName);
//request.IncludeColumns.Add(fields.PurposeTypeId.PropertyName);
//request.IncludeColumns.Add(fields.PriceType.PropertyName);
//request.IncludeColumns.Add(fields.TrxHeaderId.PropertyName);
//request.IncludeColumns.Add(fields.TenantId.PropertyName);
//request.IncludeColumns.Add(fields.SiteTypeVal.PropertyName);
//request.IncludeColumns.Add(fields.AreaName.PropertyName);
//request.IncludeColumns.Add(fields.ShelterOutdoor.PropertyName);
//request.IncludeColumns.Add(fields.KWHType.PropertyName);
//request.IncludeColumns.Add(fields.PoNumber.PropertyName);
//request.IncludeColumns.Add(fields.PONumberVersion.PropertyName);
//request.IncludeColumns.Add(fields.InputPONumberDate.PropertyName);
//request.IncludeColumns.Add(fields.BoqTotalAmount.PropertyName);
//request.IncludeColumns.Add(fields.SiteId.PropertyName);
//request.IncludeColumns.Add(fields.SiteName.PropertyName);
//request.IncludeColumns.Add(fields.VendorName.PropertyName);
//request.IncludeColumns.Add(fields.RefTrxId.PropertyName);
var data = List(connection, request).Entities;
var report = new DynamicDataReport(data, request.IncludeColumns, typeof(Columns.TbKtpReport));
var bytes = new ReportRepository().Render(report);
return(ExcelContentResult.Create(bytes, MyRow.Fields.AliasName.ToString() + "_" + DateTime.Now.ToString("ddMMyyyy_HHmmss") + ".xlsx"));
}
public FileContentResult ListExcel(IDbConnection connection, TransactionListRequest request)
{
var data = List(connection, request).Entities;
var report = new DynamicDataReport(data, request.IncludeColumns, typeof(Columns.TransactionColumns));
var bytes = new ReportRepository().Render(report);
return(ExcelContentResult.Create(bytes, "TransactionList_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx"));
}
public FileContentResult ListExcel(IDbConnection connection, ListRequest request)
{
var data = List(connection, request).Entities;
var report = new DynamicDataReport(data, request.IncludeColumns, typeof(Columns.ConcessioneColumns), HttpContext.RequestServices);
var bytes = ReportRepository.Render(report);
return(ExcelContentResult.Create(bytes, "Concessioni_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx"));
}
public FileContentResult ListExcel(IDbConnection connection, ListRequest request)
{
var data = List(connection, request).Entities;
var report = new DynamicDataReport(data, request.IncludeColumns, typeof(Columns.TitleColumns));
var bytes = new ReportRepository().Render(report);
var reportName = $"{GetType().Name.Replace("Controller", string.Empty)}_";
return(ExcelContentResult.Create(bytes, reportName + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx"));
}
public FileContentResult ListExcel(IDbConnection connection, ListRequest request)
{
var data = List(connection, request).Entities;
var cols = request.IncludeColumns.Where(p => p != MyRow.Fields.ReusedCount.Name);
var report = new DynamicDataReport(data, cols, typeof(Columns.IdCardColumns));
var bytes = new ReportRepository().Render(report);
return(ExcelContentResult.Create(bytes, "IdCard_" +
DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx"));
}
/// <summary>
/// Lists the excel.
/// </summary>
/// <param name="connection">The connection.</param>
/// <param name="request">The request.</param>
/// <returns>Excel file</returns>
public FileContentResult ListExcel(IDbConnection connection, ListRequest request)
{
var data = List(connection, request).Entities;
var report = new DynamicDataReport(data, request.IncludeColumns,
typeof(GraduateThesisManager.ModuleCourses.Columns.ModulesColumns));
var bytes = new ReportRepository().Render(report);
return(ExcelContentResult.Create(bytes, "ModulesList_" +
DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx"));
}
//Not done
public ActionResult ListReport(IDbConnection connection, CommonReportRequest request)
{
var entities = List(connection, request).Entities;
var report = new DynamicDataReport(entities, request.IncludeColumns, typeof(Columns.ProductColumns));
var reportTitle = typeof(MyRow).CustomAttributes.Where(q => q.AttributeType.Name == "DisplayNameAttribute").FirstOrDefault().ConstructorArguments[0].Value.ToString();
//var htmlText = new _Ext.Reports.ReportGenerator().RenderHtml(report, typeof(Columns.PmsMeetingdiffCommitteDetailColumns), typeof(List<PmsMeetingdiffCommitteDetailRow>));
var htmlText = new _Ext.Reports.ReportGenerator().RenderHtml(report);
var data = new CommonReportModel(connection, request);
data.ReportBody = htmlText;
data.ReportTitle = reportTitle;
return(View(MVC.Views.Common.Reporting.GridExport.CommonReport, data));
}
