示例#1
0
        private void weekley_sparepart_report_menu_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                // string filePath = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);


                // if (DBManager.ExportToPdf(DBManager.SelectForSparepartPurchase(), filePath+"\\weekley sparepart report.pdf"))
                // {
                //     MessageBox.Show("Succefully written to"+filePath +" \\weekley sparepart report.pdf", "Success", MessageBoxButton.OK, MessageBoxImage.Information);
                // }
                // else
                // {
                //     MessageBox.Show("Error Occured when Creating the pdf", "Error", MessageBoxButton.OK, MessageBoxImage.Error);

                //}

                if (Home.printDatatableToExcel("Weekley Sparepart Purchase", "sparepart_purchase", DBManager.SelectForSparepartPurchase()))
                {
                    myMessageBox mm = new myMessageBox("Exported to Excel Successfully", "Success", "Ok", 0);
                    mm.ShowDialog();
                }
                else
                {
                    myMessageBox mm = new myMessageBox("Error Occured", "Error", "Ok", 1);
                    mm.ShowDialog();
                }
            }
            catch
            {
            }
        }