using FastReport;
using System.Data;
using System.Windows;

namespace ExportTo
{
    /// <summary>
    /// Interaction logic for MainWindow.xaml
    /// </summary>
    public partial class MainWindow : Window
    {
        private DataSet dataSet;
        
        public MainWindow()
        {
            InitializeComponent();
            CreateDataSet();
        }

        private void CreateDataSet()
        {
            // create simple dataset with one table
            dataSet = new DataSet();

            DataTable table = new DataTable();
            table.TableName = "Employees";
            dataSet.Tables.Add(table);

            table.Columns.Add("ID", typeof(int));
            table.Columns.Add("Name", typeof(string));

            table.Rows.Add(1, "Andrew Fuller");
            table.Rows.Add(2, "Nancy Davolio");
            table.Rows.Add(3, "Margaret Peacock");
        }

        private Report GetReport()
        {
            // create report instance
            var report = new Report();

            // load the existing report
            report.Load("report.frx");

            // register the dataset
            report.RegisterData(dataSet);

            // run the report
            report.Prepare();

            return report;
        }

        private void ExportToPDF_Dialog(object sender, RoutedEventArgs e)
        {
            using (var report = GetReport())
            {
                // create export instance
                var export = new FastReport.Export.Pdf.PDFExport();
                // export using dialog
                export.Export(report);
            }
        }

        private void ExportToPDF_Silent(object sender, RoutedEventArgs e)
        {
            using (var report = GetReport())
            {
                // create export instance
                var export = new FastReport.Export.Pdf.PDFExport();
                // export to file
                report.Export(export, "result.pdf");
            }
        }

        private void ExportToHTML_Dialog(object sender, RoutedEventArgs e)
        {
            using (var report = GetReport())
            {
                // create export instance
                var export = new FastReport.Export.Html.HTMLExport();
                // export using dialog
                export.Export(report);
            }
        }

        private void ExportToHTML_Silent(object sender, RoutedEventArgs e)
        {
            using (var report = GetReport())
            {
                // create export instance
                var export = new FastReport.Export.Html.HTMLExport();
                // export to file
                report.Export(export, "result.html");
            }
        }

        private void ExportToExcel_Dialog(object sender, RoutedEventArgs e)
        {
            using (var report = GetReport())
            {
                // create export instance
                var export = new FastReport.Export.OoXML.Excel2007Export();
                // export using dialog
                export.Export(report);
            }
        }

        private void ExportToExcel_Silent(object sender, RoutedEventArgs e)
        {
            using (var report = GetReport())
            {
                // create export instance
                var export = new FastReport.Export.OoXML.Excel2007Export();
                // export to file
                report.Export(export, "result.xlsx");
            }
        }
    }
}