protected void gvLaneSamples_SelectedIndexChanged(object sender, EventArgs e) { try { lblDistressFeedback.Text = ""; lblFeedback.Text = ""; if (gvLaneSamples.SelectedValue != null) { lblFeedback.Text = ""; lblDistressFeedback.Text = ""; pnlSurvey.Visible = true; pnlDistressDetails.Visible = false; int sampleID = int.Parse(gvLaneSamples.SelectedValue.ToString()); bool sampleHasSurveys = new DistressSurvey().SampleHasSurveys(sampleID); bool sampleAreaReady = LaneSample.SampleReadyForDistressEntry(sampleID); if (sampleAreaReady) { if (sampleHasSurveys) { radNewSurvey.Checked = false; radOldSurvey.Checked = true; radOldSurvey_CheckedChanged(sender, e); } else { radOldSurvey.Checked = false; radNewSurvey.Checked = true; radNewSurvey_CheckedChanged(sender, e); } } else { pnlSurvey.Visible = false; lblFeedback.Text = Feedback.NonReadySample(); } } else { pnlSurvey.Visible = false; } } catch (Exception ex) { lblFeedback.Text = ex.Message; } }
protected void btnShowReport_Click(object sender, EventArgs e) { try { lblFeedback.Text = ""; if (string.IsNullOrEmpty(ddlMainStreets.SelectedValue) || ddlMainStreets.SelectedValue == "0") { throw new Exception(Feedback.NoMainStreetSelected()); } if (radLaneSamples.Checked) { DataTable dt = new LaneSample().AdvancedSearch(int.Parse(ddlMainStreets.SelectedValue)); if (dt.Rows.Count > 0) { Session.Add("type", "radLaneSamples"); Session.Add("ReportData", dt); string url = "ViewSamplesInfoReport.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true); } else { lblFeedback.Text = Feedback.NoData(); } } else if (radIntersectSamples.Checked) { DataTable dt = new IntersectionSamples().AdvancedSearch(int.Parse(ddlMainStreets.SelectedValue)); if (dt.Rows.Count > 0) { Session.Add("type", "radIntersectSamples"); Session.Add("ReportData", dt); string url = "ViewSamplesInfoReport.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true); } else { lblFeedback.Text = Feedback.NoData(); } } } catch (Exception ex) { lblFeedback.Text = ex.Message; } }
protected void btnShowReport_Click(object sender, EventArgs e) { try { lblFeedback.Text = ""; string formType = radDetailsForm.Checked ? "Details" : (radSurveyForm.Checked ? "Survey" : "Map"); DataTable dt = new DataTable(); if ((radSection.Checked || radIntersects.Checked) && (ddlMainStreets.SelectedValue == "0" || string.IsNullOrEmpty(ddlMainStreets.SelectedValue))) { throw new Exception(Feedback.NoMainStreetSelected()); } else if (radRegions.Checked && (ddlRegions.SelectedValue == "0" || string.IsNullOrEmpty(ddlRegions.SelectedValue))) { throw new Exception(Feedback.NoRegionSelected()); } if (radSection.Checked) { if (radSurveyForm.Checked) { dt = new LaneSample().AdvancedSearch(int.Parse(ddlMainStreets.SelectedValue)); } else if (radDetailsForm.Checked) { dt = new MainStreetSection().GetMainStSectionsFullInfo(int.Parse(ddlMainStreets.SelectedValue)); } else if (radSectionMap.Checked) { dt = new MainStreetSection().GetMainStreetSections(int.Parse(ddlMainStreets.SelectedValue)); } if (dt.Rows.Count > 0) { Session.Add("ReportData", dt); Session.Add("option", "radSection"); Session.Add("type", formType); string url = "ViewSurveyingFormsReport.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true); } else { lblFeedback.Text = Feedback.NoData(); } } else if (radIntersects.Checked) { if (radSurveyForm.Checked) { dt = new IntersectionSamples().GetIntersectionSamplesByMainStreet(int.Parse(ddlMainStreets.SelectedValue)); } else if (radDetailsForm.Checked) { dt = new Intersection().GetMainStIntersectionsFullInfo(int.Parse(ddlMainStreets.SelectedValue)); } if (dt.Rows.Count > 0) { Session.Add("ReportData", dt); Session.Add("option", "radIntersects"); Session.Add("type", formType); string url = "ViewSurveyingFormsReport.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true); } else { lblFeedback.Text = Feedback.NoData(); } } else if (radRegions.Checked) { dt = new SecondaryStreets().GetRegionSecondaryStreetsFullInfoNEW(int.Parse(ddlRegions.SelectedValue)); if (dt.Rows.Count > 0) { Session.Add("ReportData", dt); Session.Add("option", "radRegions"); Session.Add("type", formType); string url = "ViewSurveyingFormsReport.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true); } else { lblFeedback.Text = Feedback.NoData(); } } } catch (Exception ex) { lblFeedback.Text = ex.Message; } }
public double GetSampleArea(int sampleID) { DataTable dt = new LaneSample().GetLaneSampleDetails(sampleID); return((dt.Rows.Count > 0) ? double.Parse(dt.Rows[0]["area"].ToString()) : 0); }