예제 #1
0
        public JsonResult AddEligibleAgency(string plan, int agencyId)
        {
            LoadSession();

            var jsr = new JsonServerResponse();
            jsr.Error = _rtpRepository.AddAgencyToTimePeriod(plan, agencyId, CurrentSessionApplicationState.CurrentProgram);
            return Json(jsr);
        }
예제 #2
0
        public JsonResult DropEligibleAgency(string plan, int agencyId)
        {
            LoadSession();

            var jsr = new JsonServerResponse();
            jsr.Error = _rtpRepository.DropAgencyFromTimePeriod(plan, agencyId, CurrentSessionApplicationState.CurrentProgram);
            if (!jsr.Error.Equals(""))
            {
                jsr.Error = "That agency sponsors projects in the current Plan. They can not be removed.";
            }
            return Json(jsr);
        }
예제 #3
0
 public JsonResult AddCycle(string plan, int cycleId)
 {
     var jsr = new JsonServerResponse();
     jsr.Error = _rtpRepository.AddCycleToTimePeriod(plan, cycleId);
     return Json(jsr);
 }
 public JsonResult GetPlanReportGroupingCategoryDetails(int id)
 {
     try
     {
         var result = _rtpProjectRepository.GetPlanReportGroupingCategoryDetails(id);
         return Json(result);
     }
     catch (Exception ex)
     {
         JsonServerResponse jsr = new JsonServerResponse();
         jsr.Error = ex.Message;
         return Json(jsr);
     }
 }
예제 #5
0
        public JsonResult AddEligibleFundingResource(string timePeriod, int fundingResourceId)
        {
            LoadSessionData();

            var jsr = new JsonServerResponse();
            jsr.Error = _surveyRepository.AddFundingResourceToTimePeriod(_surveyRepository.GetYearId(timePeriod, DRCOG.Domain.Enums.TimePeriodType.Survey), fundingResourceId);
            return Json(jsr);
        }
예제 #6
0
        /// <summary>
        /// Error handler, returning a JsonServerResponse2 object within a JsonResult object.
        /// </summary>
        /// <param name="errorLogged">if set to <c>true</c> [error logged].</param>
        /// <param name="clientErrorMessage">The client error message.</param>
        /// <param name="includeBoilerPlateMessage">if set to <c>true</c> [include boiler plate message].</param>
        /// <returns></returns>
        protected JsonResult HandleErrorJson(bool errorLogged, string clientErrorMessage, bool includeBoilerPlateMessage)
        {
            JsonServerResponse response = new JsonServerResponse();
            string boilerPlateMsg = "We're sorry, an unexpected error has occurred while attempting to process your request.";
            string errorLogMsg = "The error has been logged.";

            StringBuilder sb = new StringBuilder();
            if (!string.IsNullOrEmpty(clientErrorMessage))
            {
                sb.AppendLine(clientErrorMessage.Trim());
            }
            if (includeBoilerPlateMessage)
            {
                sb.AppendLine(boilerPlateMsg);
            }
            if (errorLogged)
            {
                sb.AppendLine(errorLogMsg);
            }

            response.Error = sb.ToString();

            return Json(response, this.JsonResultContentType);
        }
 public JsonResult AddCurrent2Agency(string tipYear, int projectVersionID, int agencyId)
 {
     var jsr = new JsonServerResponse();
     jsr.Error = _rtpProjectRepository.AddAgencyToTIPProject(projectVersionID, agencyId, false);
     return Json(jsr);
 }
예제 #8
0
 public JsonResult CreateProject(string projectName, string facilityName, string tipYear, int sponsorOrganizationId, int amendmentTypeId)
 {
     JsonServerResponse jsr = new JsonServerResponse();
     int projectVersionId = 0;
     try
     {
         projectVersionId = _tipRepository.CreateProject(projectName, facilityName, tipYear, sponsorOrganizationId, amendmentTypeId);
     }
     catch (Exception ex)
     {
         jsr.Error = "An error occured creating the TIP";
         return Json(jsr);
     }
     return Json(projectVersionId);
 }
예제 #9
0
        public JsonResult CreateTip(int startYear, int endYear, int offset)
        {
            JsonServerResponse jsr = new JsonServerResponse();
            string newTipYear = startYear.ToString() + "-" + endYear.ToString();
            try
            {
                _tipRepository.CreateTip(newTipYear, offset);
                jsr.Data = true;
            }
            catch (Exception ex)
            {
                jsr.Error = "An error occured creating the TIP";
                //_logService.Warn("Create new TIP failed for TipYear='" + newTipYear + "'");
            }

            return Json(jsr);
        }
예제 #10
0
        public JsonResult DropEligibleImprovementType(string timePeriod, int improvementTypeId)
        {
            LoadSessionData();

            var jsr = new JsonServerResponse();
            jsr.Error = _surveyRepository.DropImprovementTypeFromTimePeriod(timePeriod, improvementTypeId, DRCOG.Domain.Enums.ApplicationState.Survey) ? "" : "The improvementType is used in the current Survey. It can not be removed.";
            //if (!jsr.Error.Equals(""))
            //{
            //    jsr.Error = "The improvementType is used in the current Survey. It can not be removed.";
            //}
            return Json(jsr);
        }
예제 #11
0
 public JsonResult UpdateAgencies(string tipYear, List<int> added, List<int> removed)
 {
     if (added == null)
     {
         added = new List<int>();
     }
     if (removed == null)
     {
         removed = new List<int>();
     }
     //Send the two lists of ID's to the Repo
     try
     {
         _tipRepository.UpdateEligibleAgencies(tipYear, added, removed);
         JsonServerResponse jsr = new JsonServerResponse();
         jsr.Data = true;
         return Json(jsr);
     }
     catch (Exception ex)
     {
         JsonServerResponse jsr = new JsonServerResponse();
         jsr.Error = ex.Message;
         return Json(jsr);
     }
 }
예제 #12
0
        public JsonResult DropEligibleFundingResource(string timePeriod, int fundingResourceId)
        {
            LoadSessionData();

            var jsr = new JsonServerResponse();
            jsr.Error = _surveyRepository.DropFundingResourceFromTimePeriod(_surveyRepository.GetYearId(timePeriod, DRCOG.Domain.Enums.TimePeriodType.Survey), fundingResourceId, DRCOG.Domain.Enums.ApplicationState.Survey) ? "" : "The funding resource is used in the current Survey. It can not be removed.";
            return Json(jsr);
        }
예제 #13
0
        public JsonResult DropEligibleAgency(string timePeriod, int agencyId)
        {
            LoadSessionData();

            var jsr = new JsonServerResponse();
            jsr.Error = _surveyRepository.DropAgencyFromTimePeriod(timePeriod, agencyId, DRCOG.Domain.Enums.ApplicationState.Survey);
            if (!jsr.Error.Equals(""))
            {
                jsr.Error = "That agency sponsors projects in the current Survey. They can not be removed.";
            }
            return Json(jsr);
        }
예제 #14
0
        public JsonResult AddEligibleImprovementType(string timePeriod, int improvementTypeId)
        {
            LoadSessionData();

            var jsr = new JsonServerResponse();
            jsr.Error = _surveyRepository.AddImprovementTypeToTimePeriod(timePeriod, improvementTypeId, DRCOG.Domain.Enums.ApplicationState.Survey);
            return Json(jsr);
        }
예제 #15
0
 /// <summary>
 /// Gets ProjectTypeId from ImprovementTypeId
 /// </summary>
 /// <param name="guid"></param>
 /// <returns></returns>
 protected JsonResult GetImprovementTypeMatch(int id, ITransportationRepository repo)
 {
     IList<SqlParameter> sqlParms = new List<SqlParameter>();
     sqlParms.Add(new SqlParameter() { SqlDbType = SqlDbType.Int, ParameterName = "@Id", Value = id });
     try
     {
         //var result = RtpProjectRepository.GetLookupSingle<String>("dbo.Lookup_GetProjectTypeByImprovementTypeId", "Value", sqlParms);
         var result = repo.GetLookupCollection("dbo.Lookup_GetProjectTypeByImprovementTypeId", "Id", "Value", sqlParms);
         return Json(new { id = result.First().Key, value = result.First().Value });
     }
     catch (Exception ex)
     {
         JsonServerResponse jsr = new JsonServerResponse();
         jsr.Error = ex.Message;
         return Json(jsr);
     }
 }
예제 #16
0
 public JsonResult DropEligibleAgency(string tipYear, int agencyId)
 {
     var jsr = new JsonServerResponse();
     jsr.Error = _tipRepository.DropAgencyFromTimePeriod(tipYear, agencyId, Enums.ApplicationState.TIP);
     //TODO: Translate this to make sure it is not a SQL Error. Do this or handle it client side?
     if (!jsr.Error.Equals(""))
     {
         jsr.Error = "That agency sponsors projects in the current TIP. They can not be removed.";
     }
     return Json(jsr);
 }
예제 #17
0
        /// <summary>
        /// Gets ImprovementTypeId from ProjectTypeId
        /// </summary>
        /// <param name="guid"></param>
        /// <returns></returns>
        protected JsonResult GetProjectTypeMatch(int id, ITransportationRepository repo)
        {
            var result = new List<SelectListItem>();

            IList<SqlParameter> sqlParms = new List<SqlParameter>();
            sqlParms.Add(new SqlParameter("@Id", id));
            try
            {
                var items = repo.GetLookupCollection("[dbo].[Lookup_GetImprovementTypesByProjectId]", "Id", "Value", sqlParms);
                items.ToList().ForEach(x => { result.Add(new SelectListItem { Text = x.Value, Value = x.Key.ToString() }); });
                return Json(new { data = result });
            }
            catch (Exception ex)
            {
                JsonServerResponse jsr = new JsonServerResponse();
                jsr.Error = ex.Message;
                return Json(jsr);
            }
        }
예제 #18
0
 public JsonResult AddEligibleAgency(string tipYear, int agencyId)
 {
     var jsr = new JsonServerResponse();
     jsr.Error = _tipRepository.AddAgencyToTimePeriod(tipYear, agencyId, Enums.ApplicationState.TIP);
     return Json(jsr);
 }
예제 #19
0
        /// <summary>
        /// Session timeout error handler, returning a JsonServerResponse2 object within a JsonResult object.
        /// </summary>
        /// <param name="includeBoilerPlateMessage">if set to <c>true</c> [include boiler plate message].</param>
        /// <returns></returns>
        protected JsonResult HandleSessionTimeoutErrorJson(bool includeBoilerPlateMessage)
        {
            JsonServerResponse response = new JsonServerResponse();
            string boilerPlateMsg = "Your session has expired. You must log into the application again.";

            StringBuilder sb = new StringBuilder();
            if (includeBoilerPlateMessage)
            {
                sb.AppendLine(boilerPlateMsg);
            }
            response.Error = sb.ToString();
            response.SessionError = true;

            return Json(response, this.JsonResultContentType);
        }
예제 #20
0
 public JsonResult CreateProject(string projectName, string facilityName, string plan, int sponsorOrganizationId, int? cycleId)
 {
     JsonServerResponse jsr = new JsonServerResponse();
     int projectVersionId = 0;
     try
     {
         projectVersionId = _rtpRepository.CreateProject(projectName, facilityName, plan, sponsorOrganizationId, cycleId);
     }
     catch (Exception ex)
     {
         jsr.Error = "An error occured creating the RTP Project";
         //_logService.Warn("Create new TIP Project failed for ProjectName='" + projectName + "'");
         return Json(jsr);
     }
     return new JsonResult
     {
         Data = projectVersionId
     };
 }
예제 #21
0
 public JsonResult DropCurrent2Agency(string tipYear, int projectVersionID, int agencyId)
 {
     var jsr = new JsonServerResponse();
     jsr.Error = _rtpProjectRepository.DropAgencyFromTIP(projectVersionID, agencyId);
     return Json(jsr);
 }
예제 #22
0
        public JsonResult DropCycle(int cycleId)
        {
            LoadSession();

            var jsr = new JsonServerResponse();
            jsr.Error = _rtpRepository.RemoveCycleFromTimePeriod(cycleId);
            if (!jsr.Error.Equals(""))
            {
                jsr.Error = "Cycle is in use in the current Plan. It can not be removed.";
            }
            return Json(jsr);
        }
예제 #23
0
 public JsonResult UpdateAgencies(string projectVersionID, List<int> added, List<int> removed)
 {
     if (added == null)
     {
         added = new List<int>();
     }
     if (removed == null)
     {
         removed = new List<int>();
     }
     //Send the two lists of ID's to the Repo
     try
     {
         _rtpProjectRepository.UpdateCurrentSponsors(projectVersionID, added, removed);
         JsonServerResponse jsr = new JsonServerResponse();
         jsr.Data = true;
         return Json(jsr);
     }
     catch (Exception ex)
     {
         JsonServerResponse jsr = new JsonServerResponse();
         jsr.Error = ex.Message;
         return Json(jsr);
     }
 }
예제 #24
0
        public JsonResult AddEligibleAgency(string timePeriod, int agencyId)
        {
            LoadSessionData();

            var jsr = new JsonServerResponse();
            jsr.Error = _surveyRepository.AddAgencyToTimePeriod(timePeriod, agencyId, DRCOG.Domain.Enums.ApplicationState.Survey);
            return Json(jsr);
        }