Example #1
0
        public DataTable GetMunicIntersectsMaintenanceBudget(double?budget, string municName, bool udiDesc, bool udiAsc, bool priority, bool areasOnly)
        {
            if (budget == null)
            {
                return(new DataTable());
            }

            DataTable dt = new MaintenancePriorities().GetMaintenancePrioritiesForMainStreetIntersectReport(municName, udiDesc, udiAsc, priority);

            return(PrepareIntersectionsMaintenanceBudget(budget, dt, areasOnly));
        }
Example #2
0
        public DataTable GetMainStreetSectionsMaintenanceBudget(double?budget, int mainStID, bool udiDesc, bool udiAsc, bool priority, bool areasOnly)
        {
            if (budget == null)
            {
                return(new DataTable());
            }

            DataTable dt = new MaintenancePriorities().GetMaintenancePrioritiesForMainStreetReport(mainStID, udiDesc, udiAsc, priority);

            return(PrepareSectionsMaintenanceBudget(budget, dt, areasOnly));
        }
Example #3
0
        public DataTable GetDistrictMaintenanceBudget(double?budget, string distName, bool udiDesc, bool udiAsc, bool priority, bool areasOnly)
        {
            //DataTable dt; int surveyNum,
            //if (surveyNum == 0)
            //{
            //    dt = survey.GetLastSurveyForRoadsNetwork(0, "", distName, "", false, false, true, false, 0, false, false);
            //    if (dt.Rows.Count == 0)
            //        return new DataTable();
            //    else
            //        surveyNum = int.Parse(dt.Rows[0]["SURVEY_NO"].ToString());
            //}

            //dt = new MaintenancePriorities().GetMaintenancePrioritiesForDistrictReport(distName, surveyNum, udiDesc, udiAsc, priority);
            DataTable dt = new MaintenancePriorities().GetMaintenancePrioritiesForRegionsReport(distName, udiDesc, udiAsc, priority, RegionReportLevel.District);

            return(PrepareSecondaryStreetsRegionsMaintenceBudget(budget, dt, areasOnly));
        }
Example #4
0
        public DataTable GetRegionMaintenanceBudget(double?budget, int regionID, bool udiDesc, bool udiAsc, bool priority, bool areasOnly)
        {
            //  int surveyNum,  surveyNum,
            //DataTable dt;
            //if (surveyNum == 0)
            //{
            //    dt = survey.GetLastSurveyForRoadsNetwork(regionID, "", "", "", true, false, false, false, 0, false, false);
            //    if (dt.Rows.Count == 0)
            //        return new DataTable();

            //    surveyNum = int.Parse(dt.Rows[0]["SURVEY_NO"].ToString());
            //}

            DataTable dt = new MaintenancePriorities().GetMaintenancePrioritiesForRegionsReport(regionID.ToString(), udiDesc, udiAsc, priority, RegionReportLevel.Region);

            return(PrepareSecondaryStreetsRegionsMaintenceBudget(budget, dt, areasOnly));
        }
Example #5
0
        public DataTable GetMunicMaintenanceBudget(double?budget, string municName, bool udiDesc, bool udiAsc, bool priority, bool areasOnly)
        {
            DataTable dt = new MaintenancePriorities().GetMaintenancePrioritiesForRegionsReport(municName, udiDesc, udiAsc, priority, RegionReportLevel.Municipality);

            return(PrepareSecondaryStreetsRegionsMaintenceBudget(budget, dt, areasOnly));
        }