public IPdfReportData CreatePdfReport(Report model)
{
var report = new PdfReport();
report.DocumentPreferences(doc =>
{
doc.RunDirection(PdfRunDirection.RightToLeft);
doc.Orientation(model.ReportType == "r2"
? PageOrientation.Landscape
: PageOrientation.Portrait);
doc.PageSize(PdfPageSize.A4);
});
report.DefaultFonts(font =>
{
font.Path(AppPath.ApplicationPath
+ @"\Content\fonts\mirza-font\Mirza.ttf",
Environment.GetEnvironmentVariable("SystemRoot")
+ @"\fonts\tahoma.ttf");
font.Size(10);
});
report.PagesFooter(footer =>
footer.DefaultFooter(string.Format("تاریخ تهیه گزارش:{0} - تهیه کننده:{1}",
PersianDateTime.Now.ToString
(PersianDateTimeFormat.FullDateFullTime),
_userRepository.GetUser(HttpContext.Current.User.Identity.Name,
int.Parse(CookieEncryptor.Decrypt(HttpContext.Current.Request.Cookies["LabRequest-Cookie"].Value)))
.PersonFamily)));
report.MainTableTemplate(template =>
template.BasicTemplate(BasicTemplate.SilverTemplate));
switch (model.ReportType)
{
case "r1":
{
report.PagesHeader(header =>
{
header.CacheHeader(true);
header.XHtmlHeader(rptHeader =>
{
rptHeader.PageHeaderProperties(new XHeaderBasicProperties
{
RunDirection = PdfRunDirection.RightToLeft,
ShowBorder = true
});
rptHeader.AddPageHeader(pageHeader =>
{
const string message = "گزارش نتایج درخواستها";
var photo = AppPath.ApplicationPath + @"\Content\images\bipc.png";
var image = string.Format("<img src='{0}' height='100px' width='150px'/>", photo);
return string.Format(@"<table style='font-family:Mirza;width:100%;font-size:14pt;text-align:center'>
<tr>
<td>{0}</td>
</tr>
<tr>
<td>{1}</td>
</tr>
</table>", image, message);
});
rptHeader.GroupHeaderProperties(new XHeaderBasicProperties
{
RunDirection = PdfRunDirection.RightToLeft,
ShowBorder = true,
SpacingBeforeTable = 10f
});
rptHeader.AddGroupHeader(groupHeader =>
{
var data = groupHeader.NewGroupInfo;
var pcode = data.GetSafeStringValueOf<TestResultReport>(x => x.Pcode);
var unit = data.GetSafeStringValueOf<TestResultReport>(x => x.ApplicantName);
var request = data.GetSafeStringValueOf<TestResultReport>(x => x.RequestNameDes);
var sample = data.GetSafeStringValueOf<TestResultReport>(x => x.SampleName);
var date = data.GetSafeStringValueOf<TestResultReport>(x => x.ExeDate);
return string.Format(@"<table style='width:100%;font-size:10pt;font-family:Mirza'>
<tr>
<td style='font-family:tahoma'>{0}</td>
<td>شماره پیگیری:</td>
<td style='font-family:tahoma'>{1}</td>
<td>عنوان درخواست:</td>
</tr>
<tr>
<td style='font-family:tahoma'>{2}</td>
<td>درخواست کننده:</td>
<td style='font-family:tahoma'>{3}'</td>
<td>نام نمونه:</td>
</tr>
<tr>
<td style='font-family:tahoma'>{4}</td>
<td>تاریخ انجام درخواست:</td>
</tr>
</table>",
!string.IsNullOrEmpty(pcode) ? pcode : string.Empty,
!string.IsNullOrEmpty(request) ? request : string.Empty,
!string.IsNullOrEmpty(unit) ? unit : string.Empty,
!string.IsNullOrEmpty(sample) ? sample : string.Empty,
!string.IsNullOrEmpty(date) ? date : string.Empty);
});
});
});
report.MainTablePreferences(table =>
{
table.ColumnsWidthsType(TableColumnWidthType.Relative);
table.NumberOfDataRowsPerPage(0);
table.GroupsPreferences(new GroupsPreferences
{
GroupType = GroupType.HideGroupingColumns,
RepeatHeaderRowPerGroup = true,
ShowOneGroupPerPage = true,
SpacingBeforeAllGroupsSummary = 5f,
NewGroupAvailableSpacingThreshold = 300,
SpacingAfterAllGroupsSummary = 5f
});
table.SpacingAfter(4f);
});
report.MainTableDataSource(datasource =>
{
datasource.StronglyTypedList
(_reportrepository.TestResult
(model, PersianDateTime.Now.Year.ToString()));
});
report.MainTableColumns(columns =>
{
columns.AddColumn(column =>
{
column.PropertyName("rowNo");
column.IsRowNumber(true);
column.IsVisible(true);
column.Order(0);
column.Width(1);
column.HeaderCell("#");
});
columns.AddColumn(column =>
{
column.PropertyName<TestResultReport>(x => x.Pcode);
column.IsVisible(true);
column.Order(1);
column.Width(3);
column.HeaderCell("شماره پیگیری");
column.Group((g1, g2) => g1.ToString() == g2.ToString());
});
columns.AddColumn(column =>
{
column.PropertyName<TestResultReport>(x => x.OutputName);
column.IsVisible(true);
column.Order(2);
column.Width(3);
column.HeaderCell("نام خروجی");
});
columns.AddColumn(column =>
{
column.PropertyName<TestResultReport>(x => x.OutputValue);
column.IsVisible(true);
column.Order(3);
column.Width(3);
column.HeaderCell("نتیجه آزمایش");
});
columns.AddColumn(column =>
{
column.PropertyName<TestResultReport>(x => x.MeasurDes);
column.IsVisible(true);
column.Order(4);
column.Width(3);
column.HeaderCell("واحد اندازه گیری");
});
});
break;
}
case "r2":
{
report.PagesHeader(header => header.DefaultHeader(defaultheader =>
{
//header.CacheHeader(false);
defaultheader.Message("لیست نتایج آزمایشهای انجام شده");
defaultheader.ImagePath(AppPath.ApplicationPath + @"Content\images\bipc.png");
defaultheader.RunDirection(PdfRunDirection.RightToLeft);
}));
report.MainTablePreferences(table =>
{
table.ColumnsWidthsType(TableColumnWidthType.Relative);
table.NumberOfDataRowsPerPage(0);
table.GroupsPreferences(new GroupsPreferences
{
GroupType = GroupType.HideGroupingColumns,
RepeatHeaderRowPerGroup = false,
ShowOneGroupPerPage = false,
SpacingBeforeAllGroupsSummary = 1f,
NewGroupAvailableSpacingThreshold = 150,
SpacingAfterAllGroupsSummary = 1f
});
table.SpacingAfter(1f);
});
report.MainTableDataSource(datasource =>
{
datasource.StronglyTypedList
(_reportrepository.TestResultlist(model,
PersianDateTime.Now.Year.ToString()));
});
report.MainTableColumns(columns =>
{
columns.AddColumn(column =>
{
column.PropertyName<UserTestResultListReport>(p => p.RowNumber);
//column.PropertyName("rowNo");
//column.IsRowNumber(true);
column.IsVisible(true);
column.Order(0);
column.Width(1);
column.HeaderCell("#");
});
columns.AddColumn(column =>
{
column.PropertyName<UserTestResultListReport>(p => p.OutputName);
column.IsRowNumber(false);
column.IsVisible(true);
column.Order(1);
column.Width(3);
column.HeaderCell("نام خروجی");
});
columns.AddColumn(column =>
{
column.PropertyName<UserTestResultListReport>(p => p.Spec);
column.IsRowNumber(false);
column.IsVisible(true);
column.Order(2);
column.Width(2);
column.HeaderCell("SPEC");
});
columns.AddColumn(column =>
{
column.PropertyName<UserTestResultListReport>(p => p.OutputValue);
column.IsRowNumber(false);
column.IsVisible(true);
column.Order(3);
column.Width(2);
column.HeaderCell("نتیجه آزمایش");
});
columns.AddColumn(column =>
{
column.PropertyName<UserTestResultListReport>(p => p.Des);
column.IsRowNumber(false);
column.IsVisible(true);
column.Order(4);
column.Width(2);
column.HeaderCell("واحد اندازه گیری");
});
columns.AddColumn(column =>
{
column.PropertyName<UserTestResultListReport>(p => p.SampleEName);
column.IsRowNumber(false);
column.IsVisible(true);
column.Order(5);
column.Width(2);
column.HeaderCell("نام نمونه");
});
columns.AddColumn(column =>
{
column.PropertyName<UserTestResultListReport>(p => p.ExeDate);
column.IsRowNumber(false);
column.IsVisible(true);
column.Order(6);
column.Width(2);
column.HeaderCell("تاریخ انجام");
});
columns.AddColumn(column =>
{
column.PropertyName<UserTestResultListReport>(p => p.ConfirmDate);
column.IsRowNumber(false);
column.IsVisible(true);
column.Order(7);
column.Width(2);
column.HeaderCell("تاریخ تایید تست");
});
columns.AddColumn(column =>
{
column.PropertyName<UserTestResultListReport>(p => p.ConfirmTime);
column.IsRowNumber(false);
column.IsVisible(true);
column.Order(8);
column.Width(2);
column.HeaderCell("ساعت تایید تست");
});
columns.AddColumn(column =>
{
column.PropertyName<UserTestResultListReport>(p => p.Pcode);
column.IsRowNumber(false);
column.IsVisible(true);
column.Order(9);
column.Width(3);
column.HeaderCell("کد پیگیری");
});
columns.AddColumn(column =>
{
column.PropertyName<UserTestResultListReport>(p => p.TestOutputId);
column.IsRowNumber(false);
column.IsVisible(false);
column.Group((g1, g2) => Convert.ToInt32(g1) == Convert.ToInt32(g2));
});
});
break;
}
case "r3":
{
report.PagesHeader(header => header.DefaultHeader(defaultheader =>
{
header.CacheHeader(false);
defaultheader.Message("لیست وضعیت تستهای درخواست شده");
defaultheader.ImagePath(AppPath.ApplicationPath + @"Content\images\bipc.png");
defaultheader.RunDirection(PdfRunDirection.RightToLeft);
}));
report.MainTablePreferences(table =>
{
table.ColumnsWidthsType(TableColumnWidthType.Relative);
table.NumberOfDataRowsPerPage(0);
table.GroupsPreferences(new GroupsPreferences
{
GroupType = GroupType.HideGroupingColumns,
RepeatHeaderRowPerGroup = false,
ShowOneGroupPerPage = false,
//SpacingBeforeAllGroupsSummary = 1f,
//NewGroupAvailableSpacingThreshold = 150,
//SpacingAfterAllGroupsSummary = 1f
});
table.SpacingAfter(1f);
});
report.MainTableDataSource(datasource =>
{
datasource.StronglyTypedList
(_reportrepository.TestStatusList(model,
PersianDateTime.Now.Year.ToString()));
});
report.MainTableColumns(columns =>
{
columns.AddColumn(column =>
{
column.PropertyName<UserTestStatuslist>(p => p.RowNumber);
//column.PropertyName("rowNo");
column.IsRowNumber(true);
column.IsVisible(false);
column.Order(0);
column.Width(1);
column.HeaderCell("#");
});
columns.AddColumn(column =>
{
column.PropertyName<UserTestStatuslist>(p => p.ApplicantName);
column.IsRowNumber(false);
column.IsVisible(true);
column.Order(1);
column.Width(2);
column.HeaderCell("واحد درخواست کننده");
});
columns.AddColumn(column =>
{
column.PropertyName<UserTestStatuslist>(p => p.SampleName);
column.IsRowNumber(false);
column.IsVisible(true);
column.Order(2);
column.Width(3);
column.HeaderCell("نام نمونه");
});
columns.AddColumn(column =>
{
column.PropertyName<UserTestStatuslist>(p => p.RequestDate);
column.IsRowNumber(false);
column.IsVisible(true);
column.Order(3);
column.Width(2);
column.HeaderCell("تاریخ درخواست");
});
columns.AddColumn(column =>
{
column.PropertyName<UserTestStatuslist>(p => p.TestState);
column.IsRowNumber(false);
column.IsVisible(true);
column.Order(4);
column.Width(1);
column.HeaderCell("وضعیت");
});
columns.AddColumn(column =>
{
column.PropertyName<UserTestStatuslist>(p => p.Pcode);
column.IsRowNumber(false);
column.IsVisible(true);
column.Order(5);
column.Width(3);
column.HeaderCell("کد پیگیری");
});
columns.AddColumn(column =>
{
column.PropertyName<UserTestStatuslist>(p => p.LaboratoryId);
column.IsRowNumber(false);
column.IsVisible(false);
column.Order(6);
column.Width(2);
column.HeaderCell("شماره لابراتوار");
column.Group(true,
(g1, g2) => g1.ToString() == g2.ToString());
});
columns.AddColumn(column =>
{
column.PropertyName<UserTestStatuslist>(p => p.UnitId);
column.IsRowNumber(false);
column.IsVisible(false);
column.Order(5);
column.Width(2);
column.HeaderCell("کد واحد");
column.Group(true, (h1, h2) => h1.ToString() == h2.ToString());
});
});
break;
}
case "r4":
{
report.PagesHeader(header =>
{
header.CacheHeader(true);
header.XHtmlHeader(rptHeader =>
{
rptHeader.PageHeaderProperties(new XHeaderBasicProperties
{
RunDirection = PdfRunDirection.RightToLeft,
ShowBorder = true
});
rptHeader.AddPageHeader(pageHeader =>
{
const string message = "درخواستهای انجام شده شرکتها";
var photo = AppPath.ApplicationPath + @"\Content\images\bipc.png";
var image = string.Format("<img src='{0}' height='100px' width='150px'/>", photo);
return string.Format(@"<table style='font-family:Mirza;width:100%;font-size:14pt;text-align:center'>
<tr>
<td>{0}</td>
</tr>
<tr>
<td>{1}</td>
</tr>
</table>", image, message);
});
rptHeader.GroupHeaderProperties(new XHeaderBasicProperties
{
RunDirection = PdfRunDirection.RightToLeft,
ShowBorder = true,
SpacingBeforeTable = 20f
});
rptHeader.AddGroupHeader(groupHeader =>
{
var data = groupHeader.NewGroupInfo;
var pcode = data.GetSafeStringValueOf<UserCompanyOperation>(x => x.Des);
var unit = data.GetSafeStringValueOf<UserCompanyOperation>(x => x.ApplicantName);
return string.Format(@"<table style='width:30%;font-size:10pt;font-family:Mirza'>
<tr>
<td style='font-family:tahoma'>{0}</td>
<td>واحد:</td>
<td style='font-family:tahoma'>{1}</td>
<td>شرکت:</td>
</tr>
</table>",
!string.IsNullOrEmpty(unit) ? unit : string.Empty,
!string.IsNullOrEmpty(pcode) ? pcode : string.Empty);
});
});
});
report.MainTablePreferences(table =>
{
table.ColumnsWidthsType(TableColumnWidthType.Relative);
table.NumberOfDataRowsPerPage(0);
table.GroupsPreferences(new GroupsPreferences
{
GroupType = GroupType.HideGroupingColumns,
RepeatHeaderRowPerGroup = false,
ShowOneGroupPerPage = false,
SpacingBeforeAllGroupsSummary = 1f,
NewGroupAvailableSpacingThreshold = 150,
SpacingAfterAllGroupsSummary = 1f
});
table.SpacingAfter(1f);
});
report.MainTableDataSource(datasource =>
{
datasource.StronglyTypedList
(_reportrepository.CompanyOperationList(model,
PersianDateTime.Now.Year.ToString()));
});
report.MainTableSummarySettings(summarySettings =>
{
summarySettings.OverallSummarySettings("مجموع:");
//summarySettings.PreviousPageSummarySettings("Previous Page Summary");
//summarySettings.PageSummarySettings("Page Summary");
});
report.MainTableColumns(columns =>
{
columns.AddColumn(column =>
{
column.PropertyName<UserCompanyOperation>(p => p.RowNumber);
//column.PropertyName("rowNo");
column.IsRowNumber(true);
column.IsVisible(true);
column.Order(0);
column.Width(1);
column.HeaderCell("#");
});
columns.AddColumn(column =>
{
column.PropertyName<UserCompanyOperation>(p => p.Pcode);
column.IsRowNumber(false);
column.IsVisible(true);
column.Order(1);
column.Width(3);
column.HeaderCell("کد پیگیری");
});
columns.AddColumn(column =>
{
column.PropertyName<UserCompanyOperation>(p => p.TestName);
column.IsRowNumber(false);
column.IsVisible(true);
column.Order(2);
column.Width(2);
column.HeaderCell("نام تست");
});
columns.AddColumn(column =>
{
column.PropertyName<UserCompanyOperation>(p => p.SampleName);
column.IsRowNumber(false);
column.IsVisible(true);
column.Order(3);
column.Width(2);
column.HeaderCell("نام نمونه");
});
columns.AddColumn(column =>
{
column.PropertyName<UserCompanyOperation>(p => p.Description);
column.IsRowNumber(false);
column.IsVisible(true);
column.Order(4);
column.Width(1);
column.HeaderCell("واحد اندازه گیری");
});
columns.AddColumn(column =>
{
column.PropertyName<UserCompanyOperation>(p => p.Price);
column.IsRowNumber(false);
column.IsVisible(true);
column.Order(5);
column.Width(2);
column.HeaderCell("قیمت");
//column.ColumnItemsTemplate(template =>
//{
// template.TextBlock();
// template.DisplayFormatFormula(obj => obj == null ? string.Empty : string.Format("{0:n0}", obj));
//});
column.AggregateFunction(aggregateFunction =>
{
aggregateFunction.NumericAggregateFunction(AggregateFunction.Sum);
aggregateFunction.DisplayFormatFormula(obj => obj == null ? string.Empty : string.Format("{0:n0}", obj));
});
});
columns.AddColumn(column =>
{
column.PropertyName<UserCompanyOperation>(p => p.CompanyId);
column.IsRowNumber(false);
column.IsVisible(false);
column.Order(6);
column.Width(2);
//column.HeaderCell("قیمت");
column.Group((g1, g2) => g1.ToString() == g2.ToString());
});
columns.AddColumn(column =>
{
column.PropertyName<UserCompanyOperation>(p => p.ApplicantName);
column.IsRowNumber(false);
column.IsVisible(false);
column.Order(7);
column.Width(2);
//column.HeaderCell("قیمت");
column.Group((g1, g2) => g1.ToString() == g2.ToString());
});
});
break;
}
}
report.MainTableEvents(
events =>
events.DataSourceIsEmpty("اطلاعات جهت نمایش یافت نشد دوباره امتحان کنید"));
report.Export(export => export.ToExcel());
//var fileName = string.Format("گزارش-{0}.pdf", Guid.NewGuid().ToString("N"));
report.Encrypt(encrypt =>
{
encrypt.WithPassword("secret");
encrypt.WithPermissions(new DocumentPermissions
{
AllowAssembly = false,
AllowCopy = false,
AllowDegradedPrinting = false,
AllowFillIn = false,
AllowModifyAnnotations = false,
AllowModifyContents = false,
AllowPrinting = false,
AllowScreenReaders = false
});
});
var fileName = string.Format("Report-{0}.pdf", Guid.NewGuid());
return report.Generate(data =>
{
fileName = HttpUtility.UrlEncode(fileName, Encoding.UTF8);
data.FlushInBrowser(fileName, FlushType.Inline);
});
#region code comment
//events.MainTableCreated(args =>
// {
// var infoTable = new PdfGrid(numColumns: 1)
// {
// WidthPercentage = 100
// };
// infoTable.AddSimpleRow(
// (cellData, properties) =>
// {
// cellData.Value = "Show data before the main table ...";
// properties.PdfFont = events.PdfFont;
// properties.RunDirection = PdfRunDirection.LeftToRight;
// });
// var table = infoTable.AddBorderToTable(borderColor: BaseColor.LIGHT_GRAY, spacingBefore: 10f);
// table.SpacingAfter = 10f;
// args.PdfDoc.Add(table);
// });
//events.ShouldSkipRow(args =>
//{
// var rowData = args.TableRowData;
// //var previousTableRowData = args.PreviousTableRowData;
// var description = rowData.FirstOrDefault(x => x.PropertyName == "Description");
// if (description != null &&
// description.PropertyValue.ToSafeString() == "Description Description ... 1")
// {
// return true; // don't render this row.
// }
// return false;
//});
//var pageNumber = 0;
//events.ShouldSkipHeader(args =>
//{
// pageNumber++;
// if (pageNumber == 2)
// {
// return true; // don't render this header row.
// }
// return false;
//});
//events.ShouldSkipFooter(args =>
//{
// if (pageNumber == 2)
// {
// return true; // don't render this footer row.
// }
// return false;
//});
//events.MainTableAdded(maintable =>
//{
// var infoTable = new PdfGrid(numColumns: 2) { WidthPercentage = 80, SpacingAfter = 50, SpacingBefore = 50 };
// infoTable.AddSimpleRow(
// (cellData, properties) =>
// {
// cellData.Value = "میثم";
// properties.ShowBorder = false;
// properties.BorderWidth = 0;
// properties.BorderWidth = 000;
// properties.PdfFont = events.PdfFont;
// properties.RunDirection = PdfRunDirection.RightToLeft;
// },
// (cellData, properties) =>
// {
// cellData.Value = "سامورایی";
// properties.ShowBorder = false;
// properties.BorderWidth = 0;
// properties.BorderWidth = 000;
// properties.PdfFont = events.PdfFont;
// properties.RunDirection = PdfRunDirection.RightToLeft;
// }
// );
// maintable.PdfDoc.Add(infoTable.AddBorderToTable());
//});
#endregion
}
/// <summary>
/// ctor.
/// </summary>
/// <param name="pdfReport"></param>
public ExportToBuilder(PdfReport pdfReport)
{
_pdfReport = pdfReport;
if (_pdfReport.DataBuilder.CustomExportSettings == null)
_pdfReport.DataBuilder.CustomExportSettings = new List<IDataExporter>();
}
/// <summary>
/// ctor.
/// </summary>
/// <param name="pdfReport"></param>
public MainTablePreferencesBuilder(PdfReport pdfReport)
{
_pdfReport = pdfReport;
}
/// <summary>
/// ctor.
/// </summary>
/// <param name="pdfReport"></param>
public MainTableTemplateBuilder(PdfReport pdfReport)
{
_pdfReport = pdfReport;
}
/// <summary>
/// ctor.
/// </summary>
/// <param name="pdfReport"></param>
public SignedFileBuilder(PdfReport pdfReport)
{
_pdfReport = pdfReport;
_digitalSignature = new Signature();
}
public byte[] CreatePdfReport()
{
var pdfReportData = new PdfReport().DocumentPreferences(doc =>
{
doc.RunDirection(PdfRunDirection.LeftToRight);
doc.Orientation(PageOrientation.Portrait);
doc.PageSize(PdfPageSize.A4);
doc.DocumentMetadata(new DocumentMetadata { Author = "Vahid", Application = "PdfRpt", Keywords = "Test", Subject = "Test Rpt", Title = "Test" });
doc.Compression(new CompressionSettings
{
EnableCompression = true,
EnableFullCompression = true
});
})
.DefaultFonts(fonts =>
{
fonts.Path(Path.Combine(Environment.GetEnvironmentVariable("SystemRoot"), "fonts\\tahoma.ttf"),
Path.Combine(Environment.GetEnvironmentVariable("SystemRoot"), "fonts\\verdana.ttf"));
fonts.Size(9);
fonts.Color(Color.Black);
})
.PagesFooter(footer =>
{
footer.DefaultFooter(DateTime.Now.ToString("MM/dd/yyyy"));
})
.PagesHeader(header =>
{
header.CacheHeader(cache: true); // It's a default setting to improve the performance.
header.DefaultHeader(defaultHeader =>
{
defaultHeader.RunDirection(PdfRunDirection.LeftToRight);
defaultHeader.ImagePath(Path.Combine(AppPath.ApplicationPath, "Images\\01.png"));
defaultHeader.Message("Our new rpt.");
});
})
.MainTableSummarySettings(summarySettings =>
{
summarySettings.OverallSummarySettings("Summary");
summarySettings.PreviousPageSummarySettings("Previous Page Summary");
summarySettings.PageSummarySettings("Page Summary");
})
.MainTableTemplate(template =>
{
template.BasicTemplate(BasicTemplate.ClassicTemplate);
})
.MainTablePreferences(table =>
{
table.ColumnsWidthsType(TableColumnWidthType.Relative);
})
.MainTableDataSource(dataSource =>
{
var listOfRows = new List<User>();
for (int i = 0; i < 200; i++)
{
listOfRows.Add(new User { Id = i, LastName = "Last Name " + i, Name = "Name " + i, Balance = i + 1000 });
}
dataSource.StronglyTypedList(listOfRows);
})
.MainTableColumns(columns =>
{
columns.AddColumn(column =>
{
column.PropertyName("rowNo");
column.IsRowNumber(true);
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.IsVisible(true);
column.Order(0);
column.Width(1);
column.HeaderCell("#");
});
columns.AddColumn(column =>
{
column.PropertyName<User>(x => x.Id);
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.IsVisible(true);
column.Order(1);
column.Width(2);
column.HeaderCell("Id");
});
columns.AddColumn(column =>
{
column.PropertyName<User>(x => x.Name);
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.IsVisible(true);
column.Order(2);
column.Width(3);
column.HeaderCell("Name");
});
columns.AddColumn(column =>
{
column.PropertyName<User>(x => x.LastName);
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.IsVisible(true);
column.Order(3);
column.Width(3);
column.HeaderCell("Last Name");
});
columns.AddColumn(column =>
{
column.PropertyName<User>(x => x.Balance);
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.IsVisible(true);
column.Order(4);
column.Width(2);
column.HeaderCell("Balance");
column.ColumnItemsTemplate(template =>
{
template.TextBlock();
template.DisplayFormatFormula(obj => obj == null || string.IsNullOrEmpty(obj.ToString())
? string.Empty : string.Format("{0:n0}", obj));
});
column.AggregateFunction(aggregateFunction =>
{
aggregateFunction.NumericAggregateFunction(AggregateFunction.Sum);
aggregateFunction.DisplayFormatFormula(obj => obj == null || string.IsNullOrEmpty(obj.ToString())
? string.Empty : string.Format("{0:n0}", obj));
});
});
})
.MainTableEvents(events =>
{
events.DataSourceIsEmpty(message: "There is no data available to display.");
events.DocumentClosing(args =>
{
// close the document without closing the underlying stream
//args.PdfWriter.CloseStream = false;
//args.PdfDoc.Close();
//args.PdfStreamOutput.Position = 0;
//var pdf = ((MemoryStream)args.PdfStreamOutput).ToArray();
});
})
.Export(export =>
{
export.ToExcel();
export.ToXml();
})
.Generate(data => data.AsPdfStream(new MemoryStream())); // An in-memory pdf file
return ((MemoryStream)pdfReportData.PdfStreamOutput).ToArray();
}
/// <summary>
/// ctor.
/// </summary>
/// <param name="pdfReport"></param>
public PagesHeaderBuilder(PdfReport pdfReport)
{
_pdfReport = pdfReport;
_font = new GenericFontProvider(_pdfReport.DataBuilder.PdfFont);
}
/// <summary>
/// ctor.
/// </summary>
/// <param name="pdfReport"></param>
public MainTablePreferencesBuilder(PdfReport pdfReport)
{
_pdfReport = pdfReport;
}
/// <summary>
/// ctor.
/// </summary>
/// <param name="pdfReport"></param>
public DocumentPreferencesBuilder(PdfReport pdfReport)
{
_pdfReport = pdfReport;
}
/// <summary>
/// ctor.
/// </summary>
/// <param name="pdfReport"></param>
public DocumentPreferencesBuilder(PdfReport pdfReport)
{
_pdfReport = pdfReport;
}
/// <summary>
/// ctor.
/// </summary>
/// <param name="pdfReport"></param>
public PagesHeaderBuilder(PdfReport pdfReport)
{
_pdfReport = pdfReport;
_font = new GenericFontProvider(_pdfReport.DataBuilder.PdfFont);
}
public IPdfReportData CreatePdfReport()
{
var report = new PdfReport();
report.DocumentPreferences(doc =>
{
doc.RunDirection(PdfRunDirection.LeftToRight);
doc.Orientation(PageOrientation.Portrait);
doc.PageSize(PdfPageSize.A4);
doc.DocumentMetadata(new DocumentMetadata { Author = "Vios", Application = "PdfRpt", Keywords = "IList Rpt.", Subject = "Test Rpt", Title = "Test" });
doc.Compression(new CompressionSettings
{
EnableCompression = true,
EnableFullCompression = true
});
doc.PrintingPreferences(new PrintingPreferences
{
ShowPrintDialogAutomatically = true
});
}
);
report.DefaultFonts(fonts =>
{
fonts.Path(System.IO.Path.Combine(Environment.GetEnvironmentVariable("SystemRoot"), "fonts\\arial.ttf"),
System.IO.Path.Combine(Environment.GetEnvironmentVariable("SystemRoot"), "fonts\\verdana.ttf"));
fonts.Size(9);
fonts.Color(System.Drawing.Color.Black);
});
report.PagesFooter(footer =>
{
footer.DefaultFooter(DateTime.Now.ToString("MM/dd/yyyy"));
});
report.PagesHeader(header =>
{
header.DefaultHeader(defaultHeader =>
{
defaultHeader.RunDirection(PdfRunDirection.LeftToRight);
defaultHeader.ImagePath(System.IO.Path.Combine(AppPath.ApplicationPath, "Images\\01.png"));
defaultHeader.Message("Our new rpt.");
});
});
report.MainTableTemplate(template =>
{
template.BasicTemplate(BasicTemplate.ClassicTemplate);
});
report.MainTablePreferences(table =>
{
table.ColumnsWidthsType(TableColumnWidthType.Relative);
table.NumberOfDataRowsPerPage(15);
});
report.MainTableDataSource(dataSource =>
{
var listOfRows = new List<User>();
for (int i = 0; i < 200; i++)
{
listOfRows.Add(new User { Id = i, LastName = "LastName " + i, Name = "Name " + i, Balance = i + 1000 });
}
dataSource.StronglyTypedList(listOfRows);
});
report.MainTableSummarySettings(summarySettings =>
{
summarySettings.OverallSummarySettings("Summary");
summarySettings.PreviousPageSummarySettings("Previous Page Summary");
summarySettings.PageSummarySettings("Page Summary");
});
report.MainTableColumns(columns =>
{
columns.AddColumn(column =>
{
column.PropertyName("rowNo");
column.IsRowNumber(true);
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.IsVisible(true);
column.Order(0);
column.Width(1);
column.HeaderCell("#");
});
columns.AddColumn(column =>
{
column.PropertyName<User>(x => x.Id);
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.IsVisible(true);
column.Order(1);
column.Width(2);
column.HeaderCell("Id");
});
columns.AddColumn(column =>
{
column.PropertyName<User>(x => x.Name);
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.IsVisible(true);
column.Order(2);
column.Width(3);
column.HeaderCell("Name", horizontalAlignment: HorizontalAlignment.Left);
column.Font(font =>
{
font.Size(10);
font.Color(System.Drawing.Color.Brown);
});
});
columns.AddColumn(column =>
{
column.PropertyName<User>(x => x.LastName);
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.IsVisible(true);
column.Order(3);
column.Width(3);
column.HeaderCell("Last Name");
});
columns.AddColumn(column =>
{
column.PropertyName<User>(x => x.Balance);
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.IsVisible(true);
column.Order(4);
column.Width(2);
column.HeaderCell("Balance");
column.ColumnItemsTemplate(template =>
{
template.TextBlock();
template.DisplayFormatFormula(obj => obj == null ? string.Empty : string.Format("{0:n0}", obj));
});
column.AggregateFunction(aggregateFunction =>
{
aggregateFunction.NumericAggregateFunction(AggregateFunction.Sum);
aggregateFunction.DisplayFormatFormula(obj => obj == null ? string.Empty : string.Format("{0:n0}", obj));
});
});
});
report.MainTableEvents(events =>
{
events.DataSourceIsEmpty(message: "There is no data available to display.");
});
report.Export(export =>
{
export.ToExcel();
export.ToCsv();
export.ToXml();
});
var reportHlp = report.Generate(data => data.AsPdfFile(string.Format("{0}\\Pdf\\RptTDSample-{1}.pdf", AppPath.ApplicationPath, Guid.NewGuid().ToString("N"))));
//return report as IPdfReportData;
return reportHlp;
}
/// <summary>
/// ctor.
/// </summary>
/// <param name="pdfReport"></param>
public FileBuilder(PdfReport pdfReport)
{
_pdfReport = pdfReport;
}
/// <summary>
/// ctor.
/// </summary>
/// <param name="pdfReport"></param>
public MainTableEventsBuilder(PdfReport pdfReport)
{
_pdfReport = pdfReport;
_font = new GenericFontProvider(_pdfReport.DataBuilder.PdfFont);
}
/// <summary>
/// ctor.
/// </summary>
/// <param name="pdfReport"></param>
public SignedFileBuilder(PdfReport pdfReport)
{
_pdfReport = pdfReport;
_digitalSignature = new Signature();
}
/// <summary>
/// ctor.
/// </summary>
/// <param name="pdfReport"></param>
public MainTableEventsBuilder(PdfReport pdfReport)
{
_pdfReport = pdfReport;
_font = new GenericFontProvider(_pdfReport.DataBuilder.PdfFont);
}
/// <summary>
/// ctor.
/// </summary>
/// <param name="pdfReport"></param>
public FileBuilder(PdfReport pdfReport)
{
_pdfReport = pdfReport;
}
public byte[] CreatePdfReport(OrderViewModel order, string fileName)
{
var pdfReportData = new PdfReport().DocumentPreferences(doc =>
{
doc.RunDirection(PdfRunDirection.LeftToRight);
doc.Orientation(PageOrientation.Portrait);
doc.PageSize(PdfPageSize.A4);
doc.DocumentMetadata(new DocumentMetadata { Author = "Contoso Sports League", Application = "Contoso.Apps.SportsLeague", Subject = "Contoso Sports League Store Receipt", Title = "Receipt" });
doc.Compression(new CompressionSettings
{
EnableCompression = true,
EnableFullCompression = true
});
})
.DefaultFonts(fonts =>
{
fonts.Path(System.IO.Path.Combine(Environment.GetEnvironmentVariable("SystemRoot"), "fonts\\arial.ttf"),
System.IO.Path.Combine(Environment.GetEnvironmentVariable("SystemRoot"), "fonts\\verdana.ttf"));
fonts.Size(9);
fonts.Color(System.Drawing.Color.Black);
})
.PagesFooter(footer =>
{
footer.DefaultFooter(DateTime.Now.ToString("MM/dd/yyyy"));
})
.PagesHeader(header =>
{
header.CacheHeader(cache: true); // It's a default setting to improve the performance.
header.DefaultHeader(defaultHeader =>
{
defaultHeader.RunDirection(PdfRunDirection.LeftToRight);
defaultHeader.ImagePath(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), "Images\\logo.png"));
defaultHeader.Message("Contoso Sports League - Purchase Receipt");
});
})
.MainTableTemplate(template =>
{
template.BasicTemplate(BasicTemplate.ClassicTemplate);
})
.MainTablePreferences(table =>
{
table.ColumnsWidthsType(TableColumnWidthType.Relative);
})
.MainTableDataSource(dataSource =>
{
dataSource.StronglyTypedList(order.OrderDetails);
})
.MainTableSummarySettings(summarySettings =>
{
summarySettings.OverallSummarySettings("Summary");
summarySettings.PreviousPageSummarySettings("Previous Page Summary");
summarySettings.PageSummarySettings("Page Summary");
})
.MainTableColumns(columns =>
{
columns.AddColumn(column =>
{
column.PropertyName<OrderDetailViewModel>(o => o.ProductName);
column.CellsHorizontalAlignment(HorizontalAlignment.Left);
column.IsVisible(true);
column.Order(0);
column.Width(4);
column.HeaderCell("Product");
});
columns.AddColumn(column =>
{
column.PropertyName<OrderDetailViewModel>(o => o.Quantity);
column.CellsHorizontalAlignment(HorizontalAlignment.Right);
column.IsVisible(true);
column.Order(1);
column.Width(1);
column.HeaderCell("Quantity");
});
columns.AddColumn(column =>
{
column.PropertyName<OrderDetailViewModel>(o => o.UnitPrice);
column.CellsHorizontalAlignment(HorizontalAlignment.Right);
column.IsVisible(true);
column.Order(2);
column.Width(2);
column.HeaderCell("Unit Price");
column.ColumnItemsTemplate(template =>
{
template.TextBlock();
template.DisplayFormatFormula(obj => obj == null || string.IsNullOrEmpty(obj.ToString())
? string.Empty : string.Format("{0:c}", obj));
});
});
columns.AddColumn(column =>
{
column.PropertyName<OrderDetailViewModel>(o => o.Cost);
column.CellsHorizontalAlignment(HorizontalAlignment.Right);
column.IsVisible(true);
column.Order(3);
column.Width(2);
column.HeaderCell("Total");
column.ColumnItemsTemplate(template =>
{
template.TextBlock();
template.DisplayFormatFormula(obj => obj == null || string.IsNullOrEmpty(obj.ToString())
? string.Empty : string.Format("{0:c}", obj));
});
});
})
.MainTableEvents(events =>
{
events.DataSourceIsEmpty(message: "There are no purchased items to display.");
events.MainTableAdded(args =>
{
var total = order.Total;
var summaryTable = new PdfGrid(args.Table.RelativeWidths); // Create a clone of the MainTable's structure
summaryTable.WidthPercentage = args.Table.WidthPercentage;
summaryTable.SpacingBefore = args.Table.SpacingBefore;
summaryTable.AddSimpleRow(
null, null,
(data, cellProperties) =>
{
data.Value = "Total";
cellProperties.PdfFont = args.PdfFont;
cellProperties.HorizontalAlignment = HorizontalAlignment.Right;
},
(data, cellProperties) =>
{
data.Value = string.Format("{0:c}", total);
cellProperties.PdfFont = args.PdfFont;
cellProperties.BorderColor = BaseColor.LIGHT_GRAY;
cellProperties.ShowBorder = true;
});
args.PdfDoc.Add(summaryTable);
});
})
.Export(export =>
{
export.ToExcel();
})
.Generate(data => data.AsPdfStream(new MemoryStream()));
return ((MemoryStream)pdfReportData.PdfStreamOutput).ToArray();
}
public IPdfReportData CreateReport(int purchaseorderId = 0)
{
//int purchaseorderIdHlp = 4003;
decimal dUnitPrice = 0;
decimal dQty = 0;
decimal dAmount = 0;
string szConnectionString = ConfigurationManager.ConnectionStrings["TimelyDepotContext"].ToString();
string szProviderName = ConfigurationManager.ConnectionStrings["TimelyDepotContext"].ProviderName;
string szSql = "";
//szSql = string.Format("SELECT TOP (100) PERCENT InvoiceId, Quantity, ShipQuantity, BackOrderQuantity, ItemID, Sub_ItemID, Description, Tax, UnitPrice, ItemPosition, ItemOrder " +
// "FROM InvoiceDetail WHERE (InvoiceId = {0}) ORDER BY ItemPosition, ItemOrder", purchaseorderId.ToString());
szSql = string.Format("SELECT TOP (100) PERCENT PurchaseOrderId, ItemID, Sub_ItemID, Description, Quantity, UnitPrice, VendorReference, ItemPosition, ItemOrder " +
"FROM PurchasOrderDetail WHERE (PurchaseOrderId = {0}) ORDER BY ItemPosition, ItemOrder", purchaseorderId.ToString());
var report = new PdfReport();
//Document preferences
report.DocumentPreferences(doc =>
{
doc.RunDirection(PdfRunDirection.LeftToRight);
doc.Orientation(PageOrientation.Portrait);
doc.PageSize(PdfPageSize.A4);
doc.DocumentMetadata(new DocumentMetadata { Author = "Vios", Application = "PdfRpt", Keywords = "IList Rpt.", Subject = "Purchase Order Report", Title = "Invoice" });
doc.Compression(new CompressionSettings
{
EnableCompression = true,
EnableFullCompression = true
});
doc.PrintingPreferences(new PrintingPreferences
{
ShowPrintDialogAutomatically = true
});
}
);
//Fonts
report.DefaultFonts(fonts =>
{
fonts.Path(System.IO.Path.Combine(Environment.GetEnvironmentVariable("SystemRoot"), "fonts\\arial.ttf"),
System.IO.Path.Combine(Environment.GetEnvironmentVariable("SystemRoot"), "fonts\\verdana.ttf"));
fonts.Size(10);
fonts.Color(System.Drawing.Color.Black);
});
//The footer
report.PagesFooter(footer =>
{
var date = DateTime.Now.ToString("MM/dd/yyyy");
footer.InlineFooter(inlineFooter =>
{
inlineFooter.FooterProperties(new FooterBasicProperties
{
PdfFont = footer.PdfFont,
HorizontalAlignment = HorizontalAlignment.Center,
RunDirection = PdfRunDirection.LeftToRight,
SpacingBeforeTable = 30,
TotalPagesCountTemplateHeight = 9,
TotalPagesCountTemplateWidth = 50
});
inlineFooter.AddPageFooter(data =>
{
return createFooter(footer, date, data);
});
});
});
// The Header
report.PagesHeader(header =>
{
header.InlineHeader(inlineheader =>
{
inlineheader.AddPageHeader(data =>
{
return createPOHeader(header, purchaseorderId);
});
});
});
//Main table
report.MainTableTemplate(template =>
{
template.BasicTemplate(BasicTemplate.TimelyDepoTemplate);
});
report.MainTablePreferences(table =>
{
table.ColumnsWidthsType(TableColumnWidthType.Relative);
table.NumberOfDataRowsPerPage(15);
});
//Main data
report.MainTableDataSource(dataSource =>
{
{
dataSource.GenericDataReader(
providerName: szProviderName,
connectionString: szConnectionString,
sql: szSql
);
}
});
//Summary main Data
//report.MainTableSummarySettings(summarySettings =>
//{
// summarySettings.OverallSummarySettings("Summary");
// summarySettings.PreviousPageSummarySettings("Previous Page Summary");
// summarySettings.PageSummarySettings("Page Summary");
//});
// Required Columns and formats
report.MainTableColumns(columns =>
{
columns.AddColumn(column =>
{
column.PropertyName("rowNo");
column.IsRowNumber(true);
column.CellsHorizontalAlignment(HorizontalAlignment.Left);
column.IsVisible(true);
column.Order(0);
column.Width(1);
column.HeaderCell("#");
column.IsVisible(false);
});
columns.AddColumn(column =>
{
column.PropertyName("PurchaseOrderId");
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.Order(1);
column.Width(1);
column.HeaderCell("Purchase Order Id");
column.IsVisible(false);
});
columns.AddColumn(column =>
{
column.PropertyName("ItemID");
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.Order(2);
column.Width(1);
column.HeaderCell("ItemID");
column.IsVisible(false);
});
columns.AddColumn(column =>
{
column.PropertyName("Sub_ItemID");
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.Order(3);
column.Width(2);
column.HeaderCell("Our Item #");
column.IsVisible(true);
});
columns.AddColumn(column =>
{
column.PropertyName("Description");
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.Order(3);
column.Width(6);
column.HeaderCell("Description");
column.IsVisible(true);
});
columns.AddColumn(column =>
{
column.PropertyName("VendorReference");
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.Order(5);
column.Width(2);
column.HeaderCell("Your Item");
column.IsVisible(true);
});
columns.AddColumn(column =>
{
column.PropertyName("Quantity");
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.Order(6);
column.Width(0.75f);
column.HeaderCell("Req. Qty");
column.IsVisible(true);
});
columns.AddColumn(column =>
{
column.PropertyName("UnitPrice");
column.CellsHorizontalAlignment(HorizontalAlignment.Right);
column.Order(7);
column.Width(1);
column.HeaderCell("Unit Price");
column.IsVisible(true);
column.ColumnItemsTemplate(template =>
{
template.TextBlock();
template.DisplayFormatFormula(obj => obj == null ? string.Empty : string.Format("{0:n2}", obj));
});
});
columns.AddColumn(column =>
{
column.PropertyName("CF1");
column.HeaderCell("Ext. Amount");
column.Width(1);
column.CellsHorizontalAlignment(HorizontalAlignment.Right);
column.ColumnItemsTemplate(template =>
{
template.TextBlock();
template.DisplayFormatFormula(obj => obj == null ? string.Empty : string.Format("{0:n2}", obj));
});
column.CalculatedField(list =>
{
if (list == null)
{
return string.Empty;
}
if (list.GetValueOf("UnitPrice") == null)
{
dUnitPrice = 0;
}
else
{
dUnitPrice = Convert.ToDecimal(list.GetValueOf("UnitPrice"));
}
if (list.GetValueOf("Quantity") == null)
{
dQty = 0;
}
else
{
dQty = Convert.ToDecimal(list.GetValueOf("Quantity"));
}
dAmount = dQty * dUnitPrice;
return dAmount;
});
//column.AggregateFunction(aggregateFunction =>
//{
// aggregateFunction.NumericAggregateFunction(AggregateFunction.Sum);
// aggregateFunction.DisplayFormatFormula(obj => obj == null ? string.Empty : string.Format("{0:n2}", obj));
//});
column.Order(8);
column.IsVisible(true);
});
});
//Main table Events
report.MainTableEvents(events =>
{
events.DataSourceIsEmpty(message: "There is no data available to display.");
events.MainTableAdded(args =>
{
//var data = args.LastOverallAggregateValueOf<Order>(y => y.Price);
//var msg = "Total: " + data + ", " + long.Parse(data, NumberStyles.AllowThousands, CultureInfo.InvariantCulture).NumberToText(Language.English);
//var infoTable = new PdfGrid(numColumns: 1)
//{
// WidthPercentage = 100
//};
//infoTable.AddSimpleRow(
// (cellData, properties) =>
// {
// cellData.Value = "Show data after the main table ...";
// properties.PdfFont = events.PdfFont;
// properties.RunDirection = PdfRunDirection.LeftToRight;
// });
//infoTable.AddSimpleRow(
// (cellData, properties) =>
// {
// cellData.Value = msg;
// properties.PdfFont = events.PdfFont;
// properties.RunDirection = PdfRunDirection.LeftToRight;
// });
//args.PdfDoc.Add(infoTable.AddBorderToTable(borderColor: BaseColor.LIGHT_GRAY, spacingBefore: 25f));
//PdfPTable salesamounttb = GetSalesAmountData(purchaseorderIdHlp);
PdfPTable POamounttb = GetPOAmountData(purchaseorderId);
args.PdfDoc.Add(POamounttb);
});
//events.PageTableAdded(args =>
//{
// PdfPTable salesamounttb = GetSalesAmountData(purchaseorderIdHlp);
// args.PdfDoc.Add(salesamounttb);
//});
});
//Export report
report.Export(export =>
{
export.ToExcel();
export.ToCsv();
export.ToXml();
});
//var reportHlp = report.Generate(data => data.AsPdfFile(string.Format("{0}\\Pdf\\InvoiceReport-{1}.pdf", AppPath.ApplicationPath, Guid.NewGuid().ToString("N"))));
var reportHlp = report.Generate(data => data.AsPdfFile(string.Format("{0}\\Pdf\\POReport-{1}.pdf", AppPath.ApplicationPath, purchaseorderId.ToString())));
return reportHlp;
}
/// <summary>
/// ctor.
/// </summary>
/// <param name="pdfReport"></param>
public DefaultHeaderProviderBuilder(PdfReport pdfReport)
{
_pdfReport = pdfReport;
_defaultHeaderProvider = new DefaultHeaderProvider { PdfFont = _pdfReport.DataBuilder.PdfFont };
}
/// <summary>
/// ctor.
/// </summary>
/// <param name="pdfReport"></param>
public MainTableDataSourceBuilder(PdfReport pdfReport)
{
_pdfReport = pdfReport;
}
/// <summary>
/// ctor.
/// </summary>
/// <param name="pdfReport"></param>
public DefaultFontsBuilder(PdfReport pdfReport)
{
_pdfReport = pdfReport;
}
public IPdfReportData CreateReport02(string szReportFolderPath, HttpResponseBase Response, int Invoiceid = 0)
{
decimal dUnitPrice = 0;
decimal dQty = 0;
decimal dAmount = 0;
string szConnectionString = ConfigurationManager.ConnectionStrings["TimelyDepotContext"].ToString();
string szProviderName = ConfigurationManager.ConnectionStrings["TimelyDepotContext"].ProviderName;
string szSql = "";
string szFilePath = "";
szSql = string.Format("SELECT TOP (100) PERCENT InvoiceId, Quantity, ShipQuantity, BackOrderQuantity, ItemID, Sub_ItemID, Description, Tax, UnitPrice, ItemPosition, ItemOrder " +
"FROM InvoiceDetail WHERE (InvoiceId = {0}) ORDER BY ItemPosition, ItemOrder", Invoiceid.ToString());
var report = new PdfReport();
//Document preferences
report.DocumentPreferences(doc =>
{
doc.RunDirection(PdfRunDirection.LeftToRight);
doc.Orientation(PageOrientation.Portrait);
doc.PageSize(PdfPageSize.A4);
doc.DocumentMetadata(new DocumentMetadata { Author = "Vios", Application = "PdfRpt", Keywords = "IList Rpt.", Subject = "Invoice Report", Title = "Invoice" });
doc.Compression(new CompressionSettings
{
EnableCompression = true,
EnableFullCompression = true
});
doc.PrintingPreferences(new PrintingPreferences
{
ShowPrintDialogAutomatically = true
});
}
);
//Fonts
report.DefaultFonts(fonts =>
{
string szFontsPath = System.IO.Path.Combine(szReportFolderPath, "fonts\\arial.ttf");
string szFontsPath2 = System.IO.Path.Combine(szReportFolderPath, "fonts\\verdana.ttf");
fonts.Path(szFontsPath, szFontsPath2);
//fonts.Path(System.IO.Path.Combine(Environment.GetEnvironmentVariable("SystemRoot"), "fonts\\arial.ttf"),
// System.IO.Path.Combine(Environment.GetEnvironmentVariable("SystemRoot"), "fonts\\verdana.ttf"));
fonts.Size(9);
fonts.Color(System.Drawing.Color.Black);
});
//The footer
report.PagesFooter(footer =>
{
var date = DateTime.Now.ToString("MM/dd/yyyy");
footer.InlineFooter(inlineFooter =>
{
inlineFooter.FooterProperties(new FooterBasicProperties
{
PdfFont = footer.PdfFont,
HorizontalAlignment = HorizontalAlignment.Center,
RunDirection = PdfRunDirection.LeftToRight,
SpacingBeforeTable = 30,
TotalPagesCountTemplateHeight = 9,
TotalPagesCountTemplateWidth = 50
});
inlineFooter.AddPageFooter(data =>
{
return createFooter(footer, date, data);
});
});
});
// The Header
report.PagesHeader(header =>
{
header.InlineHeader(inlineheader =>
{
inlineheader.AddPageHeader(data =>
{
return createHeader(header, Invoiceid);
});
});
});
//Main table
report.MainTableTemplate(template =>
{
template.BasicTemplate(BasicTemplate.TimelyDepoTemplate);
});
report.MainTablePreferences(table =>
{
table.ColumnsWidthsType(TableColumnWidthType.Relative);
table.NumberOfDataRowsPerPage(15);
});
//Main data
report.MainTableDataSource(dataSource =>
{
//var listOfRows = new List<User>();
//for (int i = 0; i < 10; i++)
//{
// listOfRows.Add(new User { Id = i, LastName = "LastName " + i, Name = "Name " + i, Balance = i + 1000 });
//}
//var listOfRows = new List<InvoiceDetail>();
//qryDetails = db.InvoiceDetails.Where(sldt => sldt.InvoiceId == Invoiceid);
//if (qryDetails.Count() > 0)
//{
// foreach (var item in qryDetails)
// {
// listOfRows.Add(item);
// }
//}
//dataSource.StronglyTypedList(listOfRows);
{
dataSource.GenericDataReader(
providerName: szProviderName,
connectionString: szConnectionString,
sql: szSql
);
}
});
//Summary main Data
//report.MainTableSummarySettings(summarySettings =>
//{
// summarySettings.OverallSummarySettings("Summary");
// summarySettings.PreviousPageSummarySettings("Previous Page Summary");
// summarySettings.PageSummarySettings("Page Summary");
//});
// Required Columns and formats
report.MainTableColumns(columns =>
{
columns.AddColumn(column =>
{
column.PropertyName("rowNo");
column.IsRowNumber(true);
column.CellsHorizontalAlignment(HorizontalAlignment.Left);
column.IsVisible(true);
column.Order(0);
column.Width(1);
column.HeaderCell("#");
column.IsVisible(false);
});
columns.AddColumn(column =>
{
column.PropertyName("InvoiceId");
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.Order(1);
column.Width(1);
column.HeaderCell("Invoice Id");
column.IsVisible(false);
});
columns.AddColumn(column =>
{
column.PropertyName("Quantity");
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.Order(2);
column.Width(0.75f);
column.HeaderCell("Req. Qty");
column.IsVisible(true);
});
columns.AddColumn(column =>
{
column.PropertyName("ShipQuantity");
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.Order(3);
column.Width(0.75f);
column.HeaderCell("Ship Qty");
column.IsVisible(true);
});
columns.AddColumn(column =>
{
column.PropertyName("BackOrderQuantity");
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.Order(4);
column.Width(0.75f);
column.HeaderCell("B.O. Qty");
column.IsVisible(true);
});
columns.AddColumn(column =>
{
column.PropertyName("ItemID");
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.Order(5);
column.Width(1);
column.HeaderCell("ItemID");
column.IsVisible(false);
});
columns.AddColumn(column =>
{
column.PropertyName("Sub_ItemID");
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.Order(6);
column.Width(2);
column.HeaderCell("ItemID No.");
column.IsVisible(true);
});
columns.AddColumn(column =>
{
column.PropertyName("Description");
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.Order(7);
column.Width(4);
column.HeaderCell("Description");
column.IsVisible(true);
});
columns.AddColumn(column =>
{
column.PropertyName("Tax");
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.Order(8);
column.Width(0.5f);
column.HeaderCell("Tax");
column.IsVisible(false);
});
columns.AddColumn(column =>
{
column.PropertyName("UnitPrice");
column.CellsHorizontalAlignment(HorizontalAlignment.Right);
column.Order(9);
column.Width(1);
column.HeaderCell("Unit Price");
column.IsVisible(true);
column.ColumnItemsTemplate(template =>
{
template.TextBlock();
template.DisplayFormatFormula(obj => obj == null ? string.Empty : string.Format("{0:n2}", obj));
});
});
columns.AddColumn(column =>
{
column.PropertyName("CF1");
column.HeaderCell("Ext. Amount");
column.Width(1);
column.CellsHorizontalAlignment(HorizontalAlignment.Right);
column.ColumnItemsTemplate(template =>
{
template.TextBlock();
template.DisplayFormatFormula(obj => obj == null ? string.Empty : string.Format("{0:n2}", obj));
});
column.CalculatedField(list =>
{
if (list == null)
{
return string.Empty;
}
if (list.GetValueOf("UnitPrice") == null)
{
dUnitPrice = 0;
}
else
{
dUnitPrice = Convert.ToDecimal(list.GetValueOf("UnitPrice"));
}
if (list.GetValueOf("Quantity") == null)
{
dQty = 0;
}
else
{
dQty = Convert.ToDecimal(list.GetValueOf("Quantity"));
}
dAmount = dQty * dUnitPrice;
return dAmount;
});
//column.AggregateFunction(aggregateFunction =>
//{
// aggregateFunction.NumericAggregateFunction(AggregateFunction.Sum);
// aggregateFunction.DisplayFormatFormula(obj => obj == null ? string.Empty : string.Format("{0:n2}", obj));
//});
column.Order(10);
column.IsVisible(true);
});
});
//report.MainTableColumns(columns =>
//{
// columns.AddColumn(column =>
// {
// column.PropertyName("rowNo");
// column.IsRowNumber(true);
// column.CellsHorizontalAlignment(HorizontalAlignment.Center);
// column.IsVisible(true);
// column.Order(0);
// column.Width(1);
// column.HeaderCell("#");
// });
// columns.AddColumn(column =>
// {
// column.PropertyName<User>(x => x.Id);
// column.CellsHorizontalAlignment(HorizontalAlignment.Center);
// column.IsVisible(true);
// column.Order(1);
// column.Width(2);
// column.HeaderCell("Id");
// });
// columns.AddColumn(column =>
// {
// column.PropertyName<User>(x => x.Name);
// column.CellsHorizontalAlignment(HorizontalAlignment.Center);
// column.IsVisible(true);
// column.Order(2);
// column.Width(3);
// column.HeaderCell("Name");
// });
// columns.AddColumn(column =>
// {
// column.PropertyName<User>(x => x.LastName);
// column.CellsHorizontalAlignment(HorizontalAlignment.Center);
// column.IsVisible(true);
// column.Order(3);
// column.Width(3);
// column.HeaderCell("Last Name");
// });
// columns.AddColumn(column =>
// {
// column.PropertyName<User>(x => x.Balance);
// column.CellsHorizontalAlignment(HorizontalAlignment.Center);
// column.IsVisible(true);
// column.Order(4);
// column.Width(2);
// column.HeaderCell("Balance");
// column.ColumnItemsTemplate(template =>
// {
// template.TextBlock();
// template.DisplayFormatFormula(obj => obj == null ? string.Empty : string.Format("{0:n0}", obj));
// });
// column.AggregateFunction(aggregateFunction =>
// {
// aggregateFunction.NumericAggregateFunction(AggregateFunction.Sum);
// aggregateFunction.DisplayFormatFormula(obj => obj == null ? string.Empty : string.Format("{0:n0}", obj));
// });
// });
// columns.AddColumn(column =>
// {
// column.PropertyName<User>(x => x.Id);
// column.CellsHorizontalAlignment(HorizontalAlignment.Center);
// column.IsVisible(true);
// column.Order(5);
// column.Width(2);
// column.HeaderCell("QRCode");
// column.ColumnItemsTemplate(itemsTemplate =>
// {
// itemsTemplate.InlineField(inlineField =>
// {
// inlineField.RenderCell(cellData =>
// {
// var data = cellData.Attributes.RowData.TableRowData;
// var id = data.GetSafeStringValueOf<User>(x => x.Id);
// var qrcode = new BarcodeQRCode(id, 1, 1, null);
// var image = qrcode.GetImage();
// var mask = qrcode.GetImage();
// mask.MakeMask();
// image.ImageMask = mask; // making the background color transparent
// var pdfCell = new PdfPCell(image, fit: false);
// return pdfCell;
// });
// });
// });
// });
//});
//Main table Events
report.MainTableEvents(events =>
{
events.DataSourceIsEmpty(message: "There is no data available to display.");
events.MainTableAdded(args =>
{
//var data = args.LastOverallAggregateValueOf<Order>(y => y.Price);
//var msg = "Total: " + data + ", " + long.Parse(data, NumberStyles.AllowThousands, CultureInfo.InvariantCulture).NumberToText(Language.English);
//var infoTable = new PdfGrid(numColumns: 1)
//{
// WidthPercentage = 100
//};
//infoTable.AddSimpleRow(
// (cellData, properties) =>
// {
// cellData.Value = "Show data after the main table ...";
// properties.PdfFont = events.PdfFont;
// properties.RunDirection = PdfRunDirection.LeftToRight;
// });
//infoTable.AddSimpleRow(
// (cellData, properties) =>
// {
// cellData.Value = msg;
// properties.PdfFont = events.PdfFont;
// properties.RunDirection = PdfRunDirection.LeftToRight;
// });
//args.PdfDoc.Add(infoTable.AddBorderToTable(borderColor: BaseColor.LIGHT_GRAY, spacingBefore: 25f));
PdfPTable salesamounttb = GetSalesAmountData(Invoiceid);
args.PdfDoc.Add(salesamounttb);
});
});
//Export report
report.Export(export =>
{
export.ToExcel();
export.ToCsv();
export.ToXml();
});
//szFilePath = string.Format("{0}\\InvoiceReport-{1}.pdf", szReportFolderPath, Invoiceid.ToString());
//var szHlp = AppPath.ApplicationPath;
//var reportHlp = report.Generate(data => data.AsPdfFile(string.Format("{0}\\Pdf\\InvoiceReport-{1}.pdf", AppPath.ApplicationPath, Guid.NewGuid().ToString("N"))));
//var reportHlp = report.Generate(data => data.AsPdfFile(string.Format("{0}\\Pdf\\InvoiceReport-{1}.pdf", AppPath.ApplicationPath, Invoiceid.ToString())));
//var reportHlp = report.Generate(data => data.AsPdfFile(string.Format("{0}Pdf\\InvoiceReport-{1}.pdf", AppPath.ApplicationPath, Invoiceid.ToString())));
//var reportHlp = report.Generate(data => data.AsPdfFile(szFilePath));
//var reportHlp = report.Generate(data => data.AsPdfFile(string.Format("{0}\\Pdf\\InvoiceReport-{1}.pdf", AppPath.ApplicationPath, Invoiceid.ToString())));
//var reportHlp = report.Generate02(data => data.AsPdfFile(string.Format("{0}\\Pdf\\InvoiceReport-{1}.pdf", AppPath.ApplicationPath, Invoiceid.ToString())), Response);
var reportHlp = report.Generate02(null, Response);
return reportHlp;
}