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;
        }
    }
Beispiel #4
0
        public double GetSampleArea(int sampleID)
        {
            DataTable dt = new LaneSample().GetLaneSampleDetails(sampleID);

            return((dt.Rows.Count > 0) ? double.Parse(dt.Rows[0]["area"].ToString()) : 0);
        }