/// <summary>
///
/// </summary>
/// <param name="billInfo"></param>
public AddressDialog(BillingInformation billInfo)
{
this.InitializeComponent();
//var bounds = Window.Current.Bounds;
//this.Height = bounds.Height;
info = billInfo;
this.DataContext = info;
}
/// <summary>
/// Export the UI data to Word document.
/// </summary>
/// <param name="invoiceItems">The InvoiceItems.</param>
/// <param name="billInfo">The BillingInformation.</param>
/// <param name="totalDue">The TotalDue.</param>
public void CreateWord(IList <InvoiceItem> invoiceItems, BillingInformation billInfo, double totalDue)
{
//Load Template document stream
Assembly assembly = typeof(ExportWord).Assembly;
Stream inputStream = assembly.GetManifestResourceStream("Invoice.Assets.Template.docx");
//Create instance
WordDocument document = new WordDocument();
//Open Template document
document.Open(inputStream, FormatType.Word2013);
//Dispose input stream
inputStream.Dispose();
//Set Clear Fields to false
document.MailMerge.ClearFields = false;
//Create Mail Merge Data Table
MailMergeDataTable mailMergeDataTable = new MailMergeDataTable("Invoice", invoiceItems);
//Executes mail merge using the data generated in the app.
document.MailMerge.ExecuteGroup(mailMergeDataTable);
//Mail Merge Billing information
string[] fieldNames = { "Name", "Address", "Date", "InvoiceNumber", "DueDate", "TotalDue" };
string[] fieldValues = { billInfo.Name, billInfo.Address, billInfo.Date.ToString("d"), billInfo.InvoiceNumber, billInfo.DueDate.ToString("d"), totalDue.ToString("#,###.00", CultureInfo.InvariantCulture) };
document.MailMerge.Execute(fieldNames, fieldValues);
//Create Output file in Document library location
document.Save("Invoice.docx", FormatType.Word2013);
//Save as Docx format
//Message box confirmation to view the created PDF document.
if (MessageBox.Show("Do you want to view the Word file?", "Word Document Created",
MessageBoxButton.YesNo, MessageBoxImage.Information) == MessageBoxResult.Yes)
{
//Launching the PDF file using the default Application.[Acrobat Reader]
#if !NETCORE
System.Diagnostics.Process.Start("Invoice.docx");
#else
ProcessStartInfo psi = new ProcessStartInfo
{
FileName = "cmd",
WindowStyle = ProcessWindowStyle.Hidden,
UseShellExecute = false,
CreateNoWindow = true,
Arguments = "/c start Invoice.docx"
};
Process.Start(psi);
#endif
//this.Close();
}
//Close instance
document.Close();
}
public void GenerateReport(IList <InvoiceItem> items, BillingInformation billInfo)
{
Assembly assembly = typeof(ExportToExcel).Assembly;
Stream inputStream = assembly.GetManifestResourceStream("Invoice.Assets.InvoiceTemplate.xlsx");
ExcelEngine excelEngine = new ExcelEngine();
IWorkbook book = excelEngine.Excel.Workbooks.Open(inputStream);
inputStream.Dispose();
//Create Template Marker Processor
ITemplateMarkersProcessor marker = book.CreateTemplateMarkersProcessor();
//Binding the business object with the marker.
marker.AddVariable("InvoiceItem", items);
marker.AddVariable("BillInfo", billInfo);
marker.AddVariable("Company", billInfo);
//Applies the marker.
marker.ApplyMarkers(UnknownVariableAction.Skip);
book.SaveAs("Invoice.xlsx");
//Save as Docx format
//Message box confirmation to view the created PDF document.
if (MessageBox.Show("Do you want to view the Excel file?", "Excel Document Created",
MessageBoxButton.YesNo, MessageBoxImage.Information) == MessageBoxResult.Yes)
{
//Launching the PDF file using the default Application.[Acrobat Reader]
#if !NETCORE
System.Diagnostics.Process.Start("Invoice.xlsx");
#else
ProcessStartInfo psi = new ProcessStartInfo
{
FileName = "cmd",
WindowStyle = ProcessWindowStyle.Hidden,
UseShellExecute = false,
CreateNoWindow = true,
Arguments = "/c start Invoice.xlsx"
};
Process.Start(psi);
#endif
//this.Close();
}
book.Close();
excelEngine.Dispose();
}
public void GenerateReport(IList <InvoiceItem> items, BillingInformation billInfo)
{
Assembly assembly = typeof(ExportToExcel).Assembly;
Stream inputStream = assembly.GetManifestResourceStream("syncfusion.invoice.wpf.Assets.InvoiceTemplate.xlsx");
ExcelEngine excelEngine = new ExcelEngine();
IWorkbook book = excelEngine.Excel.Workbooks.Open(inputStream);
inputStream.Dispose();
//Create Template Marker Processor
ITemplateMarkersProcessor marker = book.CreateTemplateMarkersProcessor();
//Binding the business object with the marker.
marker.AddVariable("InvoiceItem", items);
marker.AddVariable("BillInfo", billInfo);
marker.AddVariable("Company", billInfo);
//Applies the marker.
marker.ApplyMarkers(UnknownVariableAction.Skip);
book.SaveAs("Invoice.xlsx");
//Save as Docx format
//Message box confirmation to view the created PDF document.
if (MessageBox.Show("Do you want to view the Excel file?", "Excel Document Created",
MessageBoxButton.YesNo, MessageBoxImage.Information) == MessageBoxResult.Yes)
{
//Launching the PDF file using the default Application.[Acrobat Reader]
System.Diagnostics.Process process = new System.Diagnostics.Process();
process.StartInfo = new System.Diagnostics.ProcessStartInfo("Invoice.xlsx")
{
UseShellExecute = true
};
process.Start();
}
book.Close();
excelEngine.Dispose();
}
/// <summary>
/// Creates PDF
/// </summary>
public void CreatePDF(IList <InvoiceItem> dataSource, BillingInformation billInfo, double totalDue)
{
PdfDocument document = new PdfDocument();
document.PageSettings.Orientation = PdfPageOrientation.Portrait;
document.PageSettings.Margins.All = 50;
PdfPage page = document.Pages.Add();
PdfGraphics g = page.Graphics;
PdfTextElement element = new PdfTextElement(@"Syncfusion Software
2501 Aerial Center Parkway
Suite 200 Morrisville, NC 27560 USA
Tel +1 888.936.8638 Fax +1 919.573.0306");
element.Font = new PdfStandardFont(PdfFontFamily.TimesRoman, 12);
element.Brush = new PdfSolidBrush(new PdfColor(0, 0, 0));
PdfLayoutResult result = element.Draw(page, new RectangleF(0, 0, page.Graphics.ClientSize.Width / 2, 200));
Assembly assembly = typeof(PdfExport).Assembly;
Stream imgStream = assembly.GetManifestResourceStream("Invoice.Assets.SyncfusionLogo.jpg");
PdfImage img = PdfImage.FromStream(imgStream);
page.Graphics.DrawImage(img, new RectangleF(g.ClientSize.Width - 200, result.Bounds.Y, 190, 45));
PdfFont subHeadingFont = new PdfStandardFont(PdfFontFamily.TimesRoman, 14);
g.DrawRectangle(new PdfSolidBrush(new PdfColor(34, 83, 142)), new RectangleF(0, result.Bounds.Bottom + 40, g.ClientSize.Width, 30));
element = new PdfTextElement("INVOICE " + billInfo.InvoiceNumber.ToString(), subHeadingFont);
element.Brush = PdfBrushes.White;
result = element.Draw(page, new PointF(10, result.Bounds.Bottom + 48));
string currentDate = "DATE " + billInfo.Date.ToString("d");
SizeF textSize = subHeadingFont.MeasureString(currentDate);
g.DrawString(currentDate, subHeadingFont, element.Brush, new PointF(g.ClientSize.Width - textSize.Width - 10, result.Bounds.Y));
element = new PdfTextElement("BILL TO ", new PdfStandardFont(PdfFontFamily.TimesRoman, 12));
element.Brush = new PdfSolidBrush(new PdfColor(34, 83, 142));
result = element.Draw(page, new PointF(10, result.Bounds.Bottom + 25));
g.DrawLine(new PdfPen(new PdfColor(34, 83, 142), 0.70f), new PointF(0, result.Bounds.Bottom + 3), new PointF(g.ClientSize.Width, result.Bounds.Bottom + 3));
element = new PdfTextElement(billInfo.Name, new PdfStandardFont(PdfFontFamily.TimesRoman, 11));
element.Brush = new PdfSolidBrush(new PdfColor(0, 0, 0));
result = element.Draw(page, new RectangleF(10, result.Bounds.Bottom + 5, g.ClientSize.Width / 2, 100));
element = new PdfTextElement(billInfo.Address, new PdfStandardFont(PdfFontFamily.TimesRoman, 11));
element.Brush = new PdfSolidBrush(new PdfColor(0, 0, 0));
result = element.Draw(page, new RectangleF(10, result.Bounds.Bottom + 3, g.ClientSize.Width / 2, 100));
PdfGrid grid = new PdfGrid();
grid.DataSource = ConvertToDataTable(dataSource);
PdfGridCellStyle cellStyle = new PdfGridCellStyle();
cellStyle.Borders.All = PdfPens.White;
PdfGridRow header = grid.Headers[0];
PdfGridCellStyle headerStyle = new PdfGridCellStyle();
headerStyle.Borders.All = new PdfPen(new PdfColor(34, 83, 142));
headerStyle.BackgroundBrush = new PdfSolidBrush(new PdfColor(34, 83, 142));
headerStyle.TextBrush = PdfBrushes.White;
headerStyle.Font = new PdfStandardFont(PdfFontFamily.TimesRoman, 12f, PdfFontStyle.Regular);
for (int i = 0; i < header.Cells.Count; i++)
{
if (i == 0)
{
header.Cells[i].StringFormat = new PdfStringFormat(PdfTextAlignment.Left, PdfVerticalAlignment.Middle);
}
else
{
header.Cells[i].StringFormat = new PdfStringFormat(PdfTextAlignment.Right, PdfVerticalAlignment.Middle);
}
}
header.Cells[0].Value = "ITEM";
header.Cells[1].Value = "QUANTITY";
header.Cells[2].Value = "RATE";
header.Cells[3].Value = "TAXES";
header.Cells[4].Value = "AMOUNT";
header.ApplyStyle(headerStyle);
grid.Columns[0].Width = 180;
cellStyle.Borders.Bottom = new PdfPen(new PdfColor(34, 83, 142), 0.70f);
cellStyle.Font = new PdfStandardFont(PdfFontFamily.TimesRoman, 11f);
cellStyle.TextBrush = new PdfSolidBrush(new PdfColor(0, 0, 0));
foreach (PdfGridRow row in grid.Rows)
{
row.ApplyStyle(cellStyle);
for (int i = 0; i < row.Cells.Count; i++)
{
PdfGridCell cell = row.Cells[i];
if (i == 0)
{
cell.StringFormat = new PdfStringFormat(PdfTextAlignment.Left, PdfVerticalAlignment.Middle);
}
else
{
cell.StringFormat = new PdfStringFormat(PdfTextAlignment.Right, PdfVerticalAlignment.Middle);
}
if (i > 1)
{
if (cell.Value.ToString().Contains("$"))
{
cell.Value = cell.Value.ToString();
}
else
{
if (cell.Value is double)
{
cell.Value = "$" + ((double)cell.Value).ToString("#,###.00", CultureInfo.InvariantCulture);
}
else
{
cell.Value = "$" + cell.Value.ToString();
}
}
}
}
}
PdfGridLayoutFormat layoutFormat = new PdfGridLayoutFormat();
layoutFormat.Layout = PdfLayoutType.Paginate;
PdfGridLayoutResult gridResult = grid.Draw(page, new RectangleF(new PointF(0, result.Bounds.Bottom + 40), new SizeF(g.ClientSize.Width, g.ClientSize.Height - 100)), layoutFormat);
float pos = 0.0f;
for (int i = 0; i < grid.Columns.Count - 1; i++)
{
pos += grid.Columns[i].Width;
}
PdfFont font = new PdfStandardFont(PdfFontFamily.TimesRoman, 12f, PdfFontStyle.Bold);
gridResult.Page.Graphics.DrawString("TOTAL DUE", font, new PdfSolidBrush(new PdfColor(34, 83, 142)), new RectangleF(new PointF(pos, gridResult.Bounds.Bottom + 10), new SizeF(grid.Columns[3].Width - pos, 20)), new PdfStringFormat(PdfTextAlignment.Right));
gridResult.Page.Graphics.DrawString("Thank you for your business!", new PdfStandardFont(PdfFontFamily.TimesRoman, 12), new PdfSolidBrush(new PdfColor(0, 0, 0)), new PointF(pos - 210, gridResult.Bounds.Bottom + 60));
pos += grid.Columns[4].Width;
gridResult.Page.Graphics.DrawString("$" + totalDue.ToString("#,###.00", CultureInfo.InvariantCulture), font, new PdfSolidBrush(new PdfColor(0, 0, 0)), new RectangleF(pos, gridResult.Bounds.Bottom + 10, grid.Columns[4].Width - pos, 20), new PdfStringFormat(PdfTextAlignment.Right));
document.Save("Invoice.pdf");
//Message box confirmation to view the created PDF document.
if (MessageBox.Show("Do you want to view the PDF file?", "PDF File Created",
MessageBoxButton.YesNo, MessageBoxImage.Information) == MessageBoxResult.Yes)
{
//Launching the PDF file using the default Application.[Acrobat Reader]
#if !NETCORE
System.Diagnostics.Process.Start("Invoice.pdf");
#else
ProcessStartInfo psi = new ProcessStartInfo
{
FileName = "cmd",
WindowStyle = ProcessWindowStyle.Hidden,
UseShellExecute = false,
CreateNoWindow = true,
Arguments = "/c start Invoice.pdf"
};
Process.Start(psi);
#endif
//this.Close();
}
//else
// Exit
//this.Close();
document.Close(true);
}