public void Search()
{
DataSet dsExtract = new DataSet();
dsExtract = rptCanadaBonusExtractGet();
Dictionary <string, string> fields = new Dictionary <string, string>(dsExtract.Tables[0].Rows.Count);
foreach (DataColumn column in dsExtract.Tables[0].Columns)
{
fields.Add(column.ColumnName, column.ColumnName);
}
MicrosoftOfficeUtility.ExportData(dsExtract, monthText + " " + yearText + " Canada Extract", fields, OfficeExportType.Excel);
}
protected void Search()
{
FormToDataBind();
if (Excel.Checked)
{
Dictionary <string, string> revenueEntryFields = new Dictionary <string, string>();
revenueEntryFields.Add("BonusPlan", "Bonus Plan");
revenueEntryFields.Add("CreateDT", "Create Date");
revenueEntryFields.Add("EffectiveDT", "Effective Date");
revenueEntryFields.Add("RevenueEntryType", "Revenue Entry Type");
revenueEntryFields.Add("LedgerEntry", "Ledger Entry");
MicrosoftOfficeUtility.ExportData(objRevenueEntryType.RevenueEntrySearch(), "Bonus Code Query Report", revenueEntryFields, OfficeExportType.Excel);
}
else
{
SearchResultGrid.Text = objRevenueEntryType.SearchResultGrid();
}
}