void bg_DoWork(object sender, DoWorkEventArgs e) { mainmaenu.Dispatcher.Invoke(System.Windows.Threading.DispatcherPriority.Normal, new Action( delegate() { mainmaenu.IsEnabled = false; grdLeftMenu.IsEnabled = false; grdMain.IsEnabled = false; })); Header = e.Argument.ToString(); if (Messages == null) { Messages = e.Argument.ToString(); } switch (e.Argument.ToString()) { case ("Pricing Level"): switch (Process) { case ("btnImportFromTally"): dtbl = spTally.GetPriceLevel(); break; case ("btnImportFromExcel"): dtbl = spExcell.GetPriceLevel(); break; case ("btnExportExcel"): dtbl = spOpenmiracleExport.PricingLevelToExcel(); break; case ("btnExcellFormat"): if (GetPath()) { spGenerateExcel.PricingLevel(myFolderBrowserDialog.SelectedPath); } break; default: break; } break; case ("Customer"): switch (Process) { case ("btnImportFromTally"): dtbl = spTally.GetCustomer(); break; case ("btnImportFromExcel"): dtbl = spExcell.GetCustomer(); break; case ("btnExportExcel"): dtbl = spOpenmiracleExport.CustomerExportToExcel(); break; case ("btnExcellFormat"): if (GetPath()) { spGenerateExcel.Customer(myFolderBrowserDialog.SelectedPath); } break; default: break; } break; case ("Supplier"): switch (Process) { case ("btnImportFromTally"): dtbl = spTally.GetSupplier(); break; case ("btnImportFromExcel"): dtbl = spExcell.GetSupplier(); break; case ("btnExportExcel"): dtbl = spOpenmiracleExport.SupplierExportToExcel(); break; case ("btnExcellFormat"): if (GetPath()) { spGenerateExcel.Supplier(myFolderBrowserDialog.SelectedPath); } break; default: break; } break; case ("Account Groups"): switch (Process) { case ("btnImportFromTally"): dtbl = spTally.GetAccountGroup(); break; case ("btnImportFromExcel"): dtbl = spExcell.GetAccountGroup(); break; case ("btnExportExcel"): dtbl = spOpenmiracleExport.AccountGroupExportToExcel(); break; case ("btnExcellFormat"): if (GetPath()) { spGenerateExcel.AccountGroup(myFolderBrowserDialog.SelectedPath); } break; default: break; } break; case ("Account Ledgers"): switch (Process) { case ("btnImportFromTally"): dtbl = spTally.GetAccountLedger(); break; case ("btnImportFromExcel"): dtbl = spExcell.GetAccountLedger(); break; case ("btnExportExcel"): dtbl = spOpenmiracleExport.AccountLegderExportToExcel(); break; case ("btnExcellFormat"): if (GetPath()) { spGenerateExcel.AccountLeger(myFolderBrowserDialog.SelectedPath); } break; default: break; } break; case ("Product Groups"): switch (Process) { case ("btnImportFromTally"): dtbl = spTally.GetProductGroup(); break; case ("btnImportFromExcel"): dtbl = spExcell.GetProductGroup(); break; case ("btnExportExcel"): dtbl = spOpenmiracleExport.ProductGroupExportToExcel(); break; case ("btnExcellFormat"): if (GetPath()) { spGenerateExcel.ProductGroup(myFolderBrowserDialog.SelectedPath); } break; default: break; } break; case ("Units"): switch (Process) { case ("btnImportFromTally"): dtbl = spTally.GetUnit(); break; case ("btnImportFromExcel"): dtbl = spExcell.GetUnit(); break; case ("btnExportExcel"): dtbl = spOpenmiracleExport.UnitExportToExcel(); break; case ("btnExcellFormat"): if (GetPath()) { spGenerateExcel.Unit(myFolderBrowserDialog.SelectedPath); } break; default: break; } break; case ("Godowns"): switch (Process) { case ("btnImportFromTally"): dtbl = spTally.GetGodown(); break; case ("btnImportFromExcel"): dtbl = spExcell.GetGodown(); break; case ("btnExportExcel"): dtbl = spOpenmiracleExport.GodownExportToExcel(); break; case ("btnExcellFormat"): if (GetPath()) { spGenerateExcel.Godown(myFolderBrowserDialog.SelectedPath); } break; default: break; } break; case ("Products"): switch (Process) { case ("btnImportFromTally"): dtbl = spTally.GetProduct(); break; case ("btnImportFromExcel"): dtbl = spExcell.GetProduct(); break; case ("btnExportExcel"): dtbl = spOpenmiracleExport.ProductExportTOExcel(); break; case ("btnExcellFormat"): if (GetPath()) { spGenerateExcel.Product(myFolderBrowserDialog.SelectedPath); } break; default: break; } break; case ("Batches"): switch (Process) { case ("btnImportFromTally"): dtbl = spTally.GetBatch(); break; case ("btnImportFromExcel"): dtbl = spExcell.GetBatch(); break; case ("btnExportExcel"): dtbl = spOpenmiracleExport.BatchExportToExcel(); break; case ("btnExcellFormat"): if (GetPath()) { spGenerateExcel.Batch(myFolderBrowserDialog.SelectedPath); } break; default: break; } break; case ("Currency"): switch (Process) { case ("btnImportFromTally"): dtbl = spTally.GetCurrency(); break; case ("btnImportFromExcel"): dtbl = spExcell.GetCurrency(); break; case ("btnExportExcel"): dtbl = spOpenmiracleExport.CurrencyExportToexcel(); break; case ("btnExcellFormat"): if (GetPath()) { spGenerateExcel.Currency(myFolderBrowserDialog.SelectedPath); } break; default: break; } break; case ("Voucher Type"): switch (Process) { case ("btnImportFromTally"): dtbl = spTally.GetVoucherType(); break; case ("btnImportFromExcel"): dtbl = spExcell.GetVoucherType(); break; case ("btnExportExcel"): dtbl = spOpenmiracleExport.VoucherTypeExportToExcel(); break; case ("btnExcellFormat"): if (GetPath()) { spGenerateExcel.Vochertype(myFolderBrowserDialog.SelectedPath); } break; default: break; } break; case ("SalesMan"): switch (Process) { case ("btnImportFromTally"): dtbl = spTally.GetSalesMen(); break; case ("btnImportFromExcel"): dtbl = spExcell.GetSalesMen(); break; case ("btnExportExcel"): dtbl = spOpenmiracleExport.SalesManExportToExcel(); break; case ("btnExcellFormat"): if (GetPath()) { spGenerateExcel.SalesMan(myFolderBrowserDialog.SelectedPath); } break; default: break; } break; case ("Stock"): switch (Process) { case ("btnImportFromTally"): dtbl = spTally.GetStock(); break; case ("btnImportFromExcel"): dtbl = spExcell.GetStock(); break; case ("btnExportExcel"): dtbl = spOpenmiracleExport.StockExportToExcel(); break; case ("btnExcellFormat"): if (GetPath()) { spGenerateExcel.Stock(myFolderBrowserDialog.SelectedPath); } break; default: break; } break; } }