//private readonly DataTable data = new DataTable(Settings.Default.DataTableName, Settings.Default.DataTableNamespace); //private readonly string tempDir = Settings.Default.TemporaryDirectory; //private readonly string templateFile = Settings.Default.TempateFilePath; public bool ExportData(ObservableCollection <TransactionEntity> TransactionList, string FileName) { IExportDataDAL exportdata = new ExportDataDAL(); if (TransactionList != null) { int i = 0; DataSet ds = new DataSet(); DataTable dt = new DataTable(); foreach (var item in TransactionList) { if (item.IsChecked == true) { switch (item.ID) { //case 1: // salesquotation = exportdata.GetSalesQuotationsList(item.StartDate, item.EndDate); // dt = ToDataTable(salesquotation); // i = 0; // break; //case 2: // salesorder = exportdata.GetSalesOrdersList(item.StartDate, item.EndDate); // dt = ToDataTable(salesorder); // i = 0; // break; case 3: salesinvoice = exportdata.GetSalesInvoicesList(item.StartDate, item.EndDate); dt = ToDataTable(salesinvoice); i = 0; break; case 4: creditnotelist = exportdata.GetCreditNoteList(item.StartDate, item.EndDate); dt = ToDataTable(creditnotelist); i = 0; break; case 5: purchaseinvoices = exportdata.GetPurchaseInvoicesList(item.StartDate, item.EndDate); dt = ToDataTable(purchaseinvoices); break; case 6: debitnotelist = exportdata.GetDebitNoteList(item.StartDate, item.EndDate); dt = ToDataTable(debitnotelist); i = 0; break; case 7: pandssold = exportdata.GetPandSSoldList(item.StartDate, item.EndDate); dt = ToDataTable(pandssold); i = 0; break; case 8: pandspurchase = exportdata.GetPandSPurchaseList(item.StartDate, item.EndDate); dt = ToDataTable(pandspurchase); i = 0; break; case 9: gsttaxcollected = exportdata.GetGstTaxCollected(item.StartDate, item.EndDate); dt = ToDataTable(gsttaxcollected); i = 0; break; case 10: gsttaxpaid = exportdata.GetGstTaxPaid(item.StartDate, item.EndDate); dt = ToDataTable(gsttaxpaid); i = 0; break; case 11: gsttaxsummary = exportdata.GetGstTaxSummary(item.StartDate, item.EndDate); dt = ToDataTable(gsttaxsummary); i = 0; break; //case 9: // salesquotation = exportdata.GetCashBankStatement(item.StartDate, item.EndDate); // break; //case 10: // salesquotation = exportdata.GetGSTSummary(item.StartDate, item.EndDate); // break; //case 11: // salesquotation = exportdata.GetGSTCollectedDetails(item.StartDate, item.EndDate); // break; //case 12: // salesquotation = exportdata.GetGSTPaidDetails(item.StartDate, item.EndDate); // break; } if (i == 0) { ds.Tables.Add(dt); } i++; } } if (ds != null) { ExportToExcel(ds, FileName); } } //ExportToExcel<Book, Books> s = new ExportToExcel<Book, Books>(); //ICollectionView view = CollectionViewSource.GetDefaultView(dgBook.ItemsSource); //s.dataToPrint = (Books)view.SourceCollection; //s.GenerateReport(); return(true); }