private void btnExcel_Click(object sender, EventArgs e)
{
if (dgvItems.Rows.Count > 0)
{
ExportToExcel exportToExcel = new ExportToExcel();
exportToExcel.GenerateReport(m_items, m_billInfo);
//Message box confirmation to view the created PDF document.
if (MessageBox.Show("Do you want to view the Excel file?", "Excel File Created", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.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
}
}
else
{
MessageBox.Show("No invoice items found to generate the report!", "Export Cancelled",
MessageBoxButtons.OK);
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private async void ExcelExport_Click(object sender, RoutedEventArgs e)
{
MainGrid.IsHitTestVisible = false;
MainGrid.Opacity = 0.5;
progress.Visibility = Windows.UI.Xaml.Visibility.Visible;
await Dispatcher.RunAsync(Windows.UI.Core.CoreDispatcherPriority.Normal, (() =>
{
ExportToExcel exportToExcel = new ExportToExcel();
exportToExcel.GenerateReport(m_items, m_billInfo);
}));
MainGrid.IsHitTestVisible = true;
MainGrid.Opacity = 1;
progress.Visibility = Windows.UI.Xaml.Visibility.Collapsed;
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ExcelExport_Click(object sender, RoutedEventArgs e)
{
MainGrid.IsHitTestVisible = false;
MainGrid.Opacity = 0.5;
//progress.Visibility = Windows.UI.Xaml.Visibility.Visible;
//await Dispatcher.RunAsync(Windows.UI.Core.CoreDispatcherPriority.Normal, (() =>
//{
if (m_items.Count > 0)
{
ExportToExcel exportToExcel = new ExportToExcel();
exportToExcel.GenerateReport(m_items, m_billInfo);
}
else
{
MessageBox.Show("No invoice items found to generate the report!", "Export Cancelled");
}
//}));
MainGrid.IsHitTestVisible = true;
MainGrid.Opacity = 1;
//progress.Visibility = Windows.UI.Xaml.Visibility.Collapsed;
}
