protected void exportToExcelAlternate_Click(object sender, EventArgs e) { int tableNumber = Convert.ToInt32(excelTable.Value); DateTime startDate = Convert.ToDateTime(dropDownStartDateMonth.SelectedValue + "/1/" + dropDownStartDateYear.SelectedValue); int yearDiff = Convert.ToInt32(dropDownFlashYearSelectedValue.Value) - startDate.Year; startDate = startDate.AddYears(yearDiff); string market = (String.IsNullOrEmpty(dropDownMarket.SelectedValue) ? "" : dropDownMarket.SelectedItem.Text); string companyId = (String.IsNullOrEmpty(dropDownCompany.SelectedValue) ? "1" : dropDownCompany.SelectedValue); WebCommon.WriteDebugMessage(string.Format("Billings Flash - Project X - (Alternate report) Exported by: {0}", Security.GetCurrentUserId)); OnlineFlashWithoutSubTotalReport flashReport = new OnlineFlashWithoutSubTotalReport(FlashReportResults, GetSumFields(), startDate, market, companyId); WebCommon.ExportHtmlToExcel("OnlineFlashReport", flashReport.GenerateReportExcelExport(true, 1)); }
protected void exportToExcelAlternate_Click(object sender, EventArgs e) { int tableNumber = Convert.ToInt32(excelTable.Value); DateTime startDate = Convert.ToDateTime(dropDownStartDateMonth.SelectedValue + "/1/" + dropDownStartDateYear.SelectedValue); /* if (dropDownFlashYear.Visible) { startDate = Convert.ToDateTime(dropDownFlashYear.SelectedValue + "/1/" + dropDownFlashYear.SelectedValue); } */ string market = (String.IsNullOrEmpty(dropDownMarket.SelectedValue) ? "" : dropDownMarket.SelectedItem.Text); string companyId = (String.IsNullOrEmpty(dropDownCompany.SelectedValue) ? "1" : dropDownCompany.SelectedValue); OnlineFlashWithoutSubTotalReport flashReport = new OnlineFlashWithoutSubTotalReport(FlashReportResults, GetSumFields(), startDate, market, companyId); WebCommon.ExportHtmlToExcel("OnlineFlashReport", flashReport.GenerateReportExcelExport(true, 1)); }