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