protected void btnShowReport_Click(object sender, EventArgs e) { try { if (radByAllinters122.Checked) { //if (radlOldSurveys.SelectedIndex == -1) // throw new Exception(Feedback.NoSurveyDateNum()); //int surveyNum = int.Parse(radlOldSurveys.SelectedValue); DataTable dt = new RuttingReport().GetAllIntersectionsRuttingReport(); //(surveyNum); Session.Add("option", "radByIntersects"); Session.Add("ReportData", dt); string url = "ViewRuttingReport.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true); } else { lblFeedback.Text = ""; if (!radByAllLanes.Checked && (ddlMainStreets.SelectedValue == "0" || string.IsNullOrEmpty(ddlMainStreets.SelectedValue))) { throw new Exception(Feedback.NoMainStreetSelected()); } //else // if (radlOldSurveys.SelectedIndex == -1) // throw new Exception(Feedback.NoSurveyDateNum()); //int surveyNum = int.Parse(radlOldSurveys.SelectedValue); surveyNum, DataTable dt = new RuttingReport().GetRuttingReportForMainStreet(ddlMainStreets.SelectedValue, radByAllLanes.Checked, radByIntersects.Checked); if (radByMainLanes.Checked) { Session.Add("option", "radByMainLanes"); Session.Add("ReportData", dt); string url = "ViewRuttingReport.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true); } else if (radByAllLanes.Checked) { Session.Add("option", "radByAllLanes"); Session.Add("ReportData", dt); string url = "ViewRuttingReport.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true); } else if (radByIntersects.Checked) { Session.Add("option", "radByIntersects"); Session.Add("ReportData", dt); string url = "ViewRuttingReport.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true); } } } catch (Exception ex) { lblFeedback.Text = ex.Message; } }
protected void btnShowReport_Click(object sender, EventArgs e) { try { if (radByAllinters122.Checked) { string sql = string.Format("SELECT * FROM RUTTING_INTERSECTIONS where SURVEY_NO={0} ORDER BY INTERSECTION_ORDER, INTER_NO, LANE ", int.Parse(radlOldSurveys.SelectedValue)); DataTable dt1 = new DataTable(); dt1 = db.ExecuteQuery(sql); Session.Add("option", "radByIntersects"); Session.Add("ReportData", dt1); string url = "ViewRuttingReport.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true); } else { lblFeedback.Text = ""; //string lang = Session["lang"].ToString(); if (!radByAllLanes.Checked && ddlMainStreets.SelectedValue == "0") { throw new Exception(Feedback.NoMainStreetSelected()); } else if (radlOldSurveys.SelectedIndex == -1) { throw new Exception(Feedback.NoSurveyDateNum()); } DataTable dt = new RuttingReport().GetRuttingReportForMainStreet(ddlMainStreets.SelectedValue, int.Parse(radlOldSurveys.SelectedValue), radByAllLanes.Checked, radByIntersects.Checked); if (radByMainLanes.Checked) { Session.Add("option", "radByMainLanes"); Session.Add("ReportData", dt); string url = "ViewRuttingReport.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true); } else if (radByAllLanes.Checked) { Session.Add("option", "radByAllLanes"); Session.Add("ReportData", dt); string url = "ViewRuttingReport.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true); } else if (radByIntersects.Checked) { Session.Add("option", "radByIntersects"); Session.Add("ReportData", dt); string url = "ViewRuttingReport.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true); } } } catch (Exception ex) { lblFeedback.Text = ex.Message; } }