public bool ExportDataMaster(ObservableCollection <MasterEntity> masterlist, string FileName)
        {
            IExportDataDAL exportdata = new ExportDataDAL();

            if (masterlist != null)
            {
                int       i  = 0;
                DataSet   ds = new DataSet();
                DataTable dt = new DataTable();
                foreach (var item in masterlist)
                {
                    if (item.IsCheckedMaster == true)
                    {
                        switch (item.ID)
                        {
                        case 1:
                            customerdetail = exportdata.GetCustomerDetailList();
                            dt             = ToDataTable(customerdetail);
                            i = 0;
                            break;

                        case 2:
                            supplierdetail = exportdata.GetSupplierDetailList();
                            dt             = ToDataTable(supplierdetail);
                            i = 0;
                            break;

                        case 3:
                            pandsdetail = exportdata.GetPandSDetailList();
                            dt          = ToDataTable(pandsdetail);
                            i           = 0;
                            break;

                        case 4:
                            accountdetail = exportdata.GetAccountDetailList();
                            dt            = ToDataTable(accountdetail);
                            i             = 0;
                            break;

                        case 5:
                            taxcodesrates = exportdata.GetTaxCodeRatelList();
                            dt            = ToDataTable(taxcodesrates);
                            i             = 0;
                            break;

                        case 7:
                            trialbalancedetail = exportdata.GetTrialBalanceDetailList();
                            dt = ToDataTable(trialbalancedetail);
                            i  = 0;
                            break;

                        case 8:
                            profitandlossdetail = exportdata.GetProfitandLossDetailList();
                            dt = ToDataTable(profitandlossdetail);
                            i  = 0;
                            break;

                        case 9:
                            balancesheetdetail = exportdata.GetBalanceSheetDetailList();
                            dt = ToDataTable(balancesheetdetail);
                            i  = 0;
                            break;
                        }
                        if (i == 0)
                        {
                            ds.Tables.Add(dt);
                        }
                        i++;
                    }
                }
                if (ds != null)
                {
                    ExportToExcel(ds, FileName);
                }
            }
            return(true);
        }