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