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;
}
}
