Exemplo n.º 1
0
        public JsonResult AddSegment(SegmentModel model)
        {
            int segmentId = 0;

            try
            {
                segmentId = _surveyRepository.AddSegment(model);
                if (segmentId == 0)
                    throw new Exception("Returned 0 on projectVersionId" + model.ProjectVersionId);

            }
            catch (Exception ex)
            {
                return Json(new { error = "Changes could not be stored. An error has been logged." });
            }
            return Json(new { message = "Segment successfully added.", segmentId = segmentId });
        }
Exemplo n.º 2
0
        public JsonResult UpdateSegment(SegmentModel model)
        {
            try
            {
                XMLService xml = new XMLService(_surveyRepository);
                if (!String.IsNullOrEmpty(model.LRSRecord))
                {

                    string data = xml.GenerateXml(xml.GetScheme((int)SchemeName.LRSProjects), new LRSRecord() { Columns = model.LRSRecord.ToDictionary(',') });

                    model.LRSxml = data;
                }
                else model.LRSxml = xml.GenerateXml(null, null);

                _surveyRepository.UpdateSegment(model);
            }
            catch (Exception ex)
            {
                return Json(new { message = "Changes could not be stored. An error has been logged." });
            }
            return Json(new { message = "Segment successfully updated." });
        }
Exemplo n.º 3
0
 public JsonResult UpdateSegmentSummary(SegmentModel model)
 {
     try
     {
         _surveyRepository.UpdateSegmentSummary(model);
     }
     catch (Exception ex)
     {
         return Json(new { error = "Changes could not be stored. An error has been logged." });
     }
     return Json(new { message = "Segment successfully updated." });
 }
Exemplo n.º 4
0
        //private IDictionary<int, string> GetPlanScenarios(List<SqlParameter> sqlParams)
        //{
        //    return GetLookupCollection("[RTP].[GetPlanScenarios]", "NetworkID", "Scenario", sqlParams);
        //}
        //public IDictionary<int, string> GetPlanScenariosByCycleId(int cycleId)
        //{
        //    List<SqlParameter> sqlParams = new List<SqlParameter>();
        //    sqlParams.Add(new SqlParameter("@CycleId", cycleId));
        //    return GetPlanScenarios(sqlParams);
        //}
        //public IDictionary<int, string> GetPlanScenariosForCurrentCycle(int planYearId)
        //{
        //    var cycle = GetCurrentCycle(planYearId); //GetAmendmentDetails(planYearId, RTPCycleStatus.Active);
        //    List<SqlParameter> sqlParams = new List<SqlParameter>();
        //    sqlParams.Add(new SqlParameter("@CycleId", cycle.Id));
        //    sqlParams.Add(new SqlParameter("@PlanYearId", planYearId));
        //    return GetPlanScenarios(sqlParams);
        //}
        //public IDictionary<int, string> GetPlanScenariosByCycle(string cycle)
        //{
        //    List<SqlParameter> sqlParams = new List<SqlParameter>();
        //    sqlParams.Add(new SqlParameter("@Cycle", cycle));
        //    return GetPlanScenarios(sqlParams);
        //}
        //public IDictionary<int, string> GetPlanScenariosByOpenYear(string openYear)
        //{
        //    List<SqlParameter> sqlParams = new List<SqlParameter>();
        //    sqlParams.Add(new SqlParameter("@OpenYear", openYear));
        //    return GetPlanScenarios(sqlParams);
        //}
        //public IDictionary<int, string> GetPlanScenarios(int planYearId)
        //{
        //    List<SqlParameter> sqlParams = new List<SqlParameter>();
        //    sqlParams.Add(new SqlParameter("@PlanYearId", planYearId));
        //    return GetPlanScenarios(sqlParams);
        //}
        //public Cycle GetAmendmentDetails(int timePeriodId, Enums.RTPCycleStatus status)
        //{
        //    return GetCycleDetails(timePeriodId, status);
        //}
        //public ICollection<CycleAmendment> GetCollectionOfCycles(int timePeriodId)
        //{
        //    return GetCollectionOfCycles(timePeriodId, null);
        //}
        //public ICollection<CycleAmendment> GetCollectionOfCycles(int timePeriodId, Enums.RTPCycleStatus? status)
        //{
        //    SqlCommand cmd = new SqlCommand("[RTP].[GetCurrentPlanCycle]");
        //    cmd.CommandType = CommandType.StoredProcedure;
        //    cmd.Parameters.AddWithValue("@TimePeriodId", timePeriodId);
        //    if (status.HasValue)
        //    {
        //        cmd.Parameters.AddWithValue("@StatusId", (int)status);
        //    }
        //    var result = new List<CycleAmendment>();
        //    CycleAmendment cycle = null;
        //    using (IDataReader rdr = this.ExecuteReader(cmd))
        //    {
        //        while (rdr.Read())
        //        {
        //            cycle = new CycleAmendment()
        //            {
        //                Id = rdr["id"] != DBNull.Value ? rdr["id"].ToString().SmartParse<int>() : default(int)
        //                ,
        //                Name = rdr["cycle"].ToString()
        //                ,
        //                StatusId = rdr["statusId"].ToString().SmartParseDefault<int>(default(int))
        //            };
        //            cycle.Status = StringEnum.GetStringValue((Enums.RTPCycleStatus)cycle.StatusId);
        //            result.Add(cycle);
        //        }
        //    }
        //    return result;
        //}
        //public CycleAmendment GetCurrentCycle(int timePeriodId)
        //{
        //    var cycles = GetCollectionOfCycles(timePeriodId);
        //    var value = (CycleAmendment)cycles.SingleOrDefault(x => x.StatusId == (int)Enums.RTPCycleStatus.Active) ?? (CycleAmendment)cycles.SingleOrDefault(x => x.StatusId == (int)Enums.RTPCycleStatus.Pending);
        //    return value ?? new CycleAmendment();
        //}
        //public Cycle GetCycleDetails(int timePeriodId)
        //{
        //    return GetCycleDetails(timePeriodId, Enums.RTPCycleStatus.Active);
        //}
        //public Cycle GetCycleDetails(int timePeriodId, Enums.RTPCycleStatus status)
        //{
        //    SqlCommand cmd = new SqlCommand("[RTP].[GetCurrentPlanCycle]");
        //    cmd.CommandType = CommandType.StoredProcedure;
        //    cmd.Parameters.AddWithValue("@TimePeriodId", timePeriodId);
        //    cmd.Parameters.AddWithValue("@StatusId", (int)status);
        //    var result = new Cycle();
        //    using (IDataReader rdr = this.ExecuteReader(cmd))
        //    {
        //        if (rdr.Read())
        //        {
        //            result.Id = rdr["id"] != DBNull.Value ? rdr["id"].ToString().SmartParse<int>() : default(int);
        //            result.Name = rdr["cycle"].ToString();
        //            result.StatusId = rdr["statusId"].ToString().SmartParseDefault<int>(default(int));
        //        }
        //    }
        //    return result;
        //}
        ///// <summary>
        ///// Populate view model for Plan List
        ///// </summary>
        ///// <returns></returns>
        //public RtpListViewModel GetRtpListViewModel()
        //{
        //    RtpListViewModel model = new RtpListViewModel();
        //    SqlCommand cmd = new SqlCommand("[RTP].[GetPrograms]");
        //    cmd.CommandType = CommandType.StoredProcedure;
        //    IList<RtpStatusModel> rtpPrograms = new List<RtpStatusModel>();
        //    RtpStatusModel sm = null;
        //    using (IDataReader rdr = this.ExecuteReader(cmd))
        //    {
        //        //be sure we got a reader
        //        while (rdr.Read())
        //        {
        //            sm = new RtpStatusModel();
        //            sm.ProgramId = (int)rdr["ProgramId"];
        //            sm.TimePeriodId = Convert.ToInt32(rdr["TimePeriodId"]);
        //            sm.Plan = rdr["TimePeriod"].ToString();
        //            sm.Adoption = rdr["AdoptionDate"] != DBNull.Value ? (DateTime?)rdr["AdoptionDate"] : null;
        //            sm.CDOTAction = rdr["CDOTActionDate"] != DBNull.Value ? (DateTime?)rdr["CDOTActionDate"] : null;
        //            sm.LastAmended = rdr["LastAmendmentDate"] != DBNull.Value ? (DateTime?)rdr["LastAmendmentDate"] : null;
        //            sm.PublicHearing = rdr["PublicHearingDate"] != DBNull.Value ? (DateTime?)rdr["PublicHearingDate"] : null;
        //            sm.USDOTApproval = rdr["USDOTApprovalDate"] != DBNull.Value ? (DateTime?)rdr["USDOTApprovalDate"] : null;
        //            sm.Notes = rdr["Notes"].ToString();
        //            //sm.IsCurrent = (bool)rdr["Current"];
        //            //sm.IsPending = (bool)rdr["Pending"];
        //            //sm.IsPrevious = (bool)rdr["Previous"];
        //            sm.RtpSummary = GetSummary(sm.Plan);
        //            rtpPrograms.Add(sm);
        //        }
        //    }
        //    model.RTPs = rtpPrograms;
        //    return model;
        //}
        //#region IRtpRepository Members
        ///// <summary>
        ///// Create a new RTP Plan
        ///// </summary>
        ///// <param name="startYear"></param>
        ///// <param name="endYear"></param>
        ///// <param name="offset"></param>
        ///// <returns></returns>
        //public void CreateRtp(string timePeriod)
        //{
        //    SqlCommand cmd = new SqlCommand("[RTP].[CreatePlan]");
        //    cmd.CommandType = CommandType.StoredProcedure;
        //    cmd.Parameters.AddWithValue("@TimePeriod ", timePeriod);
        //    cmd.Parameters.AddWithValue("@StatusId ", Enums.RtpTimePeriodStatus.New);
        //    this.ExecuteNonQuery(cmd);
        //}
        //public void SetPlanCurrent(int timePeriodId)
        //{
        //    SqlCommand cmd = new SqlCommand("[RTP].[SetPlanCurrent]");
        //    cmd.CommandType = CommandType.StoredProcedure;
        //    cmd.Parameters.AddWithValue("@TimePeriodId", timePeriodId);
        //    this.ExecuteNonQuery(cmd);
        //}
        //public int CreateCategory(string categoryName, string shortName, string description, string plan)
        //{
        //    SqlCommand cmd = new SqlCommand("[RTP].[CreateCategory]");
        //    cmd.CommandType = CommandType.StoredProcedure;
        //    cmd.Parameters.AddWithValue("@TimePeriod", plan);
        //    cmd.Parameters.AddWithValue("@CategoryName", categoryName);
        //    cmd.Parameters.AddWithValue("@ShortName", shortName);
        //    cmd.Parameters.AddWithValue("@Description", description);
        //    SqlParameter outParam = new SqlParameter("@CategoryId", SqlDbType.Int);
        //    outParam.Direction = ParameterDirection.Output;
        //    cmd.Parameters.Add(outParam);
        //    this.ExecuteNonQuery(cmd);
        //    return (int)cmd.Parameters["@CategoryId"].Value;
        //}
        //public IList<RtpSummary> GetRestoreProjectList(int timePeriodId)
        //{
        //    IList<RtpSummary> list = new List<RtpSummary>();
        //    try
        //    {
        //        using (SqlCommand command = new SqlCommand("[RTP].[GetRestoreProjectList]") { CommandType = CommandType.StoredProcedure })
        //        {
        //            command.Parameters.AddWithValue("@TimePeriodId", timePeriodId);
        //            using (IDataReader rdr = this.ExecuteReader(command))
        //            {
        //                while (rdr.Read())
        //                {
        //                    RtpSummary summary = new RtpSummary()
        //                    {
        //                        ProjectId = rdr["ProjectId"] != DBNull.Value ? rdr["ProjectId"].ToString().SmartParseDefault(default(int)) : default(int)
        //                        ,
        //                        RTPYearTimePeriodID = rdr["TimePeriodId"] != DBNull.Value ? rdr["TimePeriodId"].ToString().SmartParseDefault(default(short)) : default(short)
        //                        ,
        //                        RtpYear = rdr["TimePeriod"].ToString()
        //                        ,
        //                        ProjectVersionId = rdr["ProjectVersionId"] != DBNull.Value ? rdr["ProjectVersionId"].ToString().SmartParseDefault(default(int)) : default(int)
        //                        ,
        //                        ProjectName = rdr["ProjectName"].ToString()
        //                        ,
        //                        LastAmendmentDate = rdr["AmendmentDate"] != DBNull.Value ? rdr["AmendmentDate"].ToString().SmartParseDefault<DateTime>(DateTime.MinValue) : DateTime.MinValue
        //                        ,
        //                        AmendmentStatusId = rdr["ProjectVersionId"] != DBNull.Value ? rdr["ProjectVersionId"].ToString().SmartParseDefault(default(int)) : default(int)
        //                        ,
        //                        AmendmentStatus = rdr["AmendmentStatus"].ToString()
        //                    };
        //                    list.Add(summary);
        //                }
        //            }
        //        }
        //    }
        //    catch
        //    {
        //    }
        //    return list;
        //}
        //public IList<RtpSummary> GetAmendableProjects(int timePeriodId)
        //{
        //    IList<RtpSummary> list = new List<RtpSummary>();
        //    try
        //    {
        //        using (SqlCommand command = new SqlCommand("[RTP].[GetProjects]") { CommandType = CommandType.StoredProcedure })
        //        {
        //            command.Parameters.AddWithValue("@YearID", timePeriodId);
        //            //command.Parameters.AddWithValue("@AmendmentStatusID", (int)RTPAmendmentStatus.Pending);
        //            using (IDataReader rdr = this.ExecuteReader(command))
        //            {
        //                while (rdr.Read())
        //                {
        //                    RtpSummary summary = new RtpSummary()
        //                    {
        //                        SponsorAgency = rdr["Sponsor"].ToString()
        //                        ,
        //                        ProjectName = rdr["ProjectName"].ToString()
        //                        ,
        //                        RtpYear = rdr["RtpYear"].ToString()
        //                        ,
        //                        ProjectVersionId = rdr["RTPProjectVersionId"] != DBNull.Value ? rdr["RTPProjectVersionId"].ToString().SmartParseDefault(default(int)) : default(int)
        //                    };
        //                    list.Add(summary);
        //                }
        //            }
        //        }
        //    }
        //    catch
        //    {
        //    }
        //    return list;
        //}
        ///// <summary>
        ///// 
        ///// </summary>
        ///// <param name="id"></param>
        ///// <returns></returns>
        //public StatusViewModel GetRtpStatusViewModel(string year)
        //{
        //    int intOut;
        //    StatusViewModel model = new StatusViewModel();
        //    SqlCommand cmd = new SqlCommand("[RTP].[GetStatus]");
        //    cmd.CommandType = CommandType.StoredProcedure;
        //    cmd.Parameters.Add(new SqlParameter("@YEAR", SqlDbType.NVarChar));
        //    cmd.Parameters[0].Value = year;
        //    model.RtpSummary.RtpYear = year;
        //    var sm = new RtpStatusModel();
        //    using (IDataReader rdr = this.ExecuteReader(cmd))
        //    {
        //        if (rdr.Read())
        //        {
        //            sm.ProgramId = (int)rdr["ProgramId"];
        //            sm.TimePeriodId = Convert.ToInt32(rdr["TimePeriodId"]);
        //            sm.Plan = rdr["TimePeriod"].ToString();
        //            sm.Adoption = rdr["AdoptionDate"] != DBNull.Value ? (DateTime?)rdr["AdoptionDate"] : null;
        //            //sm.EPAApproval = rdr["USEPAApprovalDate"] != DBNull.Value ? (DateTime?)rdr["USEPAApprovalDate"] : null;
        //            //sm.GovernorApproval = rdr["GovernorApprovalDate"] != DBNull.Value ? (DateTime?)rdr["GovernorApprovalDate"] : null;
        //            sm.LastAmended = rdr["LastAmendmentDate"] != DBNull.Value ? (DateTime?)rdr["LastAmendmentDate"] : null;
        //            sm.PublicHearing = rdr["PublicHearingDate"] != DBNull.Value ? (DateTime?)rdr["PublicHearingDate"] : null;
        //            sm.CDOTAction = rdr["CDOTActionDate"] != DBNull.Value ? (DateTime?)rdr["CDOTActionDate"] : null;
        //            sm.USDOTApproval = rdr["USDOTApprovalDate"] != DBNull.Value ? (DateTime?)rdr["USDOTApprovalDate"] : null;
        //            sm.Notes = rdr["Notes"].ToString();
        //            //sm.IsCurrent = (bool)rdr["Current"];
        //            //sm.IsPending = (bool)rdr["Pending"];
        //            //sm.IsPrevious = (bool)rdr["Previous"];
        //            sm.BaseYearId = rdr["BaseYearId"] != DBNull.Value ? (Int32.TryParse(rdr["BaseYearId"].ToString(), out intOut) ? Int32.Parse(rdr["BaseYearId"].ToString()) : 0)  : 0;
        //            sm.BaseYear = rdr["BaseYear"] != DBNull.Value ? rdr["BaseYear"].ToString() : String.Empty;
        //            sm.Description = rdr["Description"].ToString();
        //            model.RtpSummary.Cycle = new Cycle()
        //            {
        //                Id = rdr["CycleId"].ToString().SmartParseDefault<int>(default(int))
        //                ,
        //                Name = rdr["CycleName"].ToString()
        //                ,
        //                StatusId = rdr["CycleStatusId"].ToString().SmartParseDefault<int>(default(int))
        //                ,
        //                Status = rdr["CycleStatus"].ToString()
        //            };
        //        }
        //    }
        //    model.RtpStatus = sm;
        //    List<SqlParameter> sqlParams = new List<SqlParameter>();
        //    sqlParams.Add(new SqlParameter("@TimePeriodTypeID", Enums.TimePeriodType.Year));
        //    model.AvailableYears = GetLookupCollection("[dbo].[Lookup_GetTimePeriodsByTypeId]", "Value", "Label", sqlParams);
        //    sqlParams = new List<SqlParameter>();
        //    sqlParams.Add(new SqlParameter("@TimePeriodId", sm.TimePeriodId));
        //    model.CurrentPlanCycles = GetLookupCollection("[RTP].[GetCurrentPlanCycles]", "id", "cycle", sqlParams);
        //    sqlParams = new List<SqlParameter>();
        //    sqlParams.Add(new SqlParameter("@TimePeriodId", sm.TimePeriodId));
        //    model.PlanUnusedCycles = GetLookupCollection("[RTP].[GetNextCycleKeys]", "id", "cycle", sqlParams);
        //    model.AvailableCycles = GetLookupCollection("[RTP].[GetAvailablePlanCycles]", "id", "cycle");
        //    //Enums.RTPCycleStatus rtpCycleStatus = model.RtpStatus.IsCurrent ? Enums.RTPCycleStatus.Active : Enums.RTPCycleStatus.Pending;
        //    //model.RtpSummary.Cycle = GetAmendmentDetails(sm.TimePeriodId, rtpCycleStatus);
        //    return model;
        //}
        //public String SetActiveCycle(int cycleId, int timePeriodId)
        //{
        //    string result = "";
        //    SqlCommand cmd = new SqlCommand("[RTP].[SetActiveCycle]");
        //    cmd.CommandType = CommandType.StoredProcedure;
        //    cmd.Parameters.AddWithValue("@CycleId", cycleId);
        //    cmd.Parameters.AddWithValue("@TimePeriodId", timePeriodId);
        //    //cmd.Parameters.AddWithValue("@CycleStatus", RTPCycleStatus.);
        //    try
        //    {
        //        this.ExecuteNonQuery(cmd);
        //    }
        //    catch (Exception ex)
        //    {
        //        result = ex.Message;
        //    }
        //    return result;
        //}
        //public String UpdateTimePeriodCycleOrder(string cycles)
        //{
        //    string result = String.Empty;
        //    var modifiedOrder = new List<int>(GetModifiedArrayIndexes(cycles));
        //    int position = 0;
        //    if (modifiedOrder.Count > 0)
        //    {
        //        using (TransactionScope ts = new TransactionScope())
        //        {
        //            foreach (var item in modifiedOrder)
        //            {
        //                if (!UpdateCycleSort((int)item, ++position))
        //                {
        //                    //error = true;
        //                    throw new Exception("Sort Exception");
        //                }
        //            }
        //            ts.Complete();
        //        }
        //    }
        //    return result;
        //}
        //private bool UpdateCycleSort(int cycleId, int order)
        //{
        //    SqlCommand cmd = new SqlCommand("[RTP].[UpdateCycleSort]");
        //    cmd.CommandType = CommandType.StoredProcedure;
        //    cmd.Parameters.AddWithValue("@CycleId", cycleId);
        //    cmd.Parameters.AddWithValue("@Order", order);
        //    SqlParameter sqlout = new SqlParameter("@error",SqlDbType.Bit);
        //    sqlout.Direction = ParameterDirection.Output;
        //    cmd.Parameters.Add(sqlout);
        //    try
        //    {
        //        this.ExecuteNonQuery(cmd);
        //        if((bool)cmd.Parameters["@error"].Value)
        //            return false;
        //        return true;
        //    }
        //    catch (Exception ex)
        //    {
        //        Debug.WriteLine(ex.Message);
        //    }
        //    return false;
        //}
        //private IEnumerable<int> GetModifiedArrayIndexes(string positions)
        //{
        //    IEnumerable<string> values = positions.Split(new char[] { ',' });
        //    foreach (var position in values)
        //    {
        //        yield return Convert.ToInt32(position.Replace("cycle_", ""));
        //    }
        //}
        ///// <summary>
        ///// Update the RTP Status in the database
        ///// </summary>
        ///// <param name="model"></param>
        //public void UpdateRtpStatus(RtpStatusModel model)
        //{
        //    SqlCommand cmd = new SqlCommand("[RTP].[UpdateRtpStatus]");
        //    cmd.CommandType = CommandType.StoredProcedure;
        //    cmd.Parameters.AddWithValue("@PROGRAMID", model.ProgramId);
        //    cmd.Parameters.AddWithValue("@TIMEPERIODID", model.TimePeriodId);
        //    cmd.Parameters.AddWithValue("@YEAR", model.Plan);
        //    cmd.Parameters.AddWithValue("@BaseYearId", model.BaseYearId > 0 ? (object)model.BaseYearId : 0);
        //    //cmd.Parameters.AddWithValue("@CURRENT", model.IsCurrent);
        //    //cmd.Parameters.AddWithValue("@PENDING", model.IsPending);
        //    //cmd.Parameters.AddWithValue("@PREVIOUS", model.IsPrevious);
        //    cmd.Parameters.AddWithValue("@NOTES", model.Notes);
        //    cmd.Parameters.AddWithValue("@Description", model.Description);
        //    cmd.Parameters.AddWithValue("@ADOPTIONDATE", model.Adoption != null ? (object)model.Adoption.Value : (object)DBNull.Value);
        //    //cmd.Parameters.AddWithValue("@GOVAPPROVALDATE ", model.GovernorApproval != null ? (object)model.GovernorApproval.Value : (object)DBNull.Value);
        //    cmd.Parameters.AddWithValue("@PUBLICHEARINGDATE", model.PublicHearing != null ? (object)model.PublicHearing.Value : (object)DBNull.Value);
        //    cmd.Parameters.AddWithValue("@DOTDATE", model.USDOTApproval != null ? (object)model.USDOTApproval.Value : (object)DBNull.Value);
        //    cmd.Parameters.AddWithValue("@CDOTDATE", model.CDOTAction != null ? (object)model.CDOTAction.Value : (object)DBNull.Value);
        //    //cmd.Parameters.AddWithValue("@EPADATE ", model.EPAApproval != null ? (object)model.EPAApproval.Value : (object)DBNull.Value);
        //    this.ExecuteNonQuery(cmd);
        //}
        ///// <summary>
        ///// Add a cycle to a TimePeriod
        ///// </summary>
        ///// <param name="timePeriodId"></param>
        ///// <param name="cycleId"></param>
        //public string AddCycleToTimePeriod(string timePeriod, int cycleId)
        //{
        //    string result = "";
        //    SqlCommand cmd = new SqlCommand("[RTP].[AddCycleToTimePeriod]");
        //    cmd.CommandType = CommandType.StoredProcedure;
        //    cmd.Parameters.AddWithValue("@TimePeriodId", GetYearId(timePeriod));
        //    cmd.Parameters.AddWithValue("@CycleId", cycleId);
        //    cmd.Parameters.AddWithValue("@StatusId", Enums.RTPCycleStatus.Inactive);
        //    try
        //    {
        //        this.ExecuteNonQuery(cmd);
        //    }
        //    catch (Exception ex)
        //    {
        //        result = ex.Message;
        //    }
        //    return result;
        //}
        ///// <summary>
        ///// Remove a Cycle from TimePeriod
        ///// </summary>
        ///// <param name="cycleId"></param>
        //public string RemoveCycleFromTimePeriod(int cycleId)
        //{
        //    string result = "";
        //    SqlCommand cmd = new SqlCommand("[RTP].[RemoveCycleFromTimePeriod]");
        //    cmd.CommandType = CommandType.StoredProcedure;
        //    cmd.Parameters.AddWithValue("@CycleId", cycleId);
        //    cmd.Parameters.AddWithValue("@StatusId", Enums.RTPCycleStatus.New);
        //    try
        //    {
        //        this.ExecuteNonQuery(cmd);
        //    }
        //    catch (Exception ex)
        //    {
        //        result = ex.Message;
        //    }
        //    return result;
        //}
        //public string UpdateTimePeriodStatusId(int timePeriodId, int statusId)
        //{
        //    string result = "";
        //    SqlCommand cmd = new SqlCommand("[dbo].[UpdateTimePeriodStatusId]");
        //    cmd.CommandType = CommandType.StoredProcedure;
        //    cmd.Parameters.AddWithValue("@TimePeriodId", timePeriodId);
        //    cmd.Parameters.AddWithValue("@StatusId", statusId);
        //    try
        //    {
        //        this.ExecuteNonQuery(cmd);
        //    }
        //    catch (Exception ex)
        //    {
        //        result = ex.Message;
        //    }
        //    return result;
        //}
        ///// <summary>
        ///// Create a Cycle
        ///// </summary>
        ///// <param name="cycle"></param>
        //public string CreateCycle(string cycle)
        //{
        //    string result = "";
        //    SqlCommand cmd = new SqlCommand("[RTP].[CreateCycle]");
        //    cmd.CommandType = CommandType.StoredProcedure;
        //    cmd.Parameters.AddWithValue("@Cycle", cycle);
        //    try
        //    {
        //        this.ExecuteNonQuery(cmd);
        //    }
        //    catch (Exception ex)
        //    {
        //        result = ex.Message;
        //    }
        //    return result;
        //}
        //public string UpdateCycleName(int cycleId, string cycle)
        //{
        //    string result = String.Empty;
        //    SqlCommand cmd = new SqlCommand("[RTP].[UpdateCycleName]");
        //    cmd.CommandType = CommandType.StoredProcedure;
        //    cmd.Parameters.AddWithValue("@CycleId", cycleId);
        //    cmd.Parameters.AddWithValue("@Cycle", cycle);
        //    try
        //    {
        //        this.ExecuteNonQuery(cmd);
        //    }
        //    catch (Exception ex)
        //    {
        //        result = ex.Message;
        //    }
        //    return result;
        //}
        /// <summary>
        /// Create a new Project in the database
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int CreateProject(string projectName, string facilityName, int timePeriodId, int sponsorOrganizationId, int sponsorContactId, int improvementTypeId, string startAt, string endAt)
        {
            int retval = default(int);
            try
            {
                using (TransactionScope ts = new TransactionScope())
                {
                    using (SqlCommand command = new SqlCommand("[Survey].[CreateProject]") { CommandType = CommandType.StoredProcedure })
                    {
                        command.Parameters.AddWithValue("@ProjectName", projectName);
                        command.Parameters.AddWithValue("@SponsorOrganizationId", sponsorOrganizationId);
                        if (!sponsorContactId.Equals(default(int))) command.Parameters.AddWithValue("@SponsorContactId", sponsorContactId);
                        command.Parameters.AddWithValue("@FacilityName", facilityName);
                        command.Parameters.AddWithValue("@TimePeriodId", timePeriodId);
                        //command.Parameters.AddWithValue("@AmendmentStatusId", (int)Enums.RTPAmendmentStatus.Pending);
                        command.Parameters.AddWithValue("@VersionStatusId", (int)DRCOG.Domain.Enums.SurveyVersionStatus.Pending);
                        //command.Parameters.AddWithValue("@SponsorContactId", sponsorContactId);
                        command.Parameters.AddWithValue("@UpdateStatusId", (int)DRCOG.Domain.Enums.SurveyUpdateStatus.Edited);
                        command.Parameters.AddWithValue("@ImprovementTypeId", improvementTypeId);

                        //command.Parameters.AddWithValue("@ActionStatusId", default(int));
                        //command.Parameters.AddWithValue("@AmendmentTypeId", (int)AmendmentType.Administrative);
                        SqlParameter outParam = new SqlParameter("@ProjectVersionId", SqlDbType.Int);
                        outParam.Direction = ParameterDirection.Output;
                        command.Parameters.Add(outParam);
                        this.ExecuteNonQuery(command);
                        retval = (int)command.Parameters["@ProjectVersionId"].Value;
                    }
                    if (retval.Equals(default(int))) throw new Exception("ProjectVersionId was not returned");

                    SegmentModel segmentModel = new SegmentModel()
                    {
                        ProjectVersionId = retval
                        ,
                        FacilityName = facilityName
                        ,
                        StartAt = startAt
                        ,
                        EndAt = endAt
                    };
                    int segmentid = this.AddSegment(segmentModel);
                    if (segmentid.Equals(default(int))) throw new Exception("Segment was not created");
                    ts.Complete();
                }
            }
            catch (Exception exc)
            {

            }

            return retval;
        }
Exemplo n.º 5
0
        public void UpdateSegmentSummary(SegmentModel model)
        {
            using (SqlCommand command = new SqlCommand("[dbo].[UpdateSegmentSummary]") { CommandType = CommandType.StoredProcedure })
            {
                command.Parameters.AddWithValue("@SegmentId", model.SegmentId);
                command.Parameters.AddWithValue("@FacilityName", model.FacilityName != null ? (object)model.FacilityName.ToString() : (object)DBNull.Value);
                command.Parameters.AddWithValue("@StartAt", model.StartAt != null ? (object)model.StartAt.ToString() : (object)DBNull.Value);
                command.Parameters.AddWithValue("@EndAt", model.EndAt != null ? (object)model.EndAt.ToString() : (object)DBNull.Value);
                command.Parameters.AddWithValue("@NetworkId", model.NetworkId > 0 ? model.NetworkId : (object)DBNull.Value);
                command.Parameters.AddWithValue("@OpenYear", model.OpenYear > 0 ? model.OpenYear : (object)DBNull.Value);
                command.Parameters.AddWithValue("@LanesBase", model.LanesBase);
                command.Parameters.AddWithValue("@LanesFuture", model.LanesFuture);

                this.ExecuteNonQuery(command);
            }
        }
Exemplo n.º 6
0
        public void UpdateSegment(SegmentModel model)
        {
            using (SqlCommand command = new SqlCommand("[dbo].[UpdateSegment]") { CommandType = CommandType.StoredProcedure })
            {
                command.Parameters.AddWithValue("@SegmentId", model.SegmentId);
                command.Parameters.AddWithValue("@FacilityName", model.FacilityName != null ? (object)model.FacilityName.ToString() : (object)DBNull.Value);
                command.Parameters.AddWithValue("@StartAt", model.StartAt != null ? (object)model.StartAt.ToString() : (object)DBNull.Value);
                command.Parameters.AddWithValue("@EndAt", model.EndAt != null ? (object)model.EndAt.ToString() : (object)DBNull.Value);
                command.Parameters.AddWithValue("@NetworkId", model.NetworkId > 0 ? model.NetworkId : (object)DBNull.Value);
                command.Parameters.AddWithValue("@ImprovementTypeId", model.ImprovementTypeId > 0 ? model.ImprovementTypeId : (object)DBNull.Value);
                command.Parameters.AddWithValue("@PlanFacilityTypeId", model.PlanFacilityTypeId > 0 ? model.PlanFacilityTypeId : (object)DBNull.Value);
                command.Parameters.AddWithValue("@ModelingFacilityTypeId", model.ModelingFacilityTypeId > 0 ? model.ModelingFacilityTypeId : (object)DBNull.Value);
                command.Parameters.AddWithValue("@OpenYear", model.OpenYear > 0 ? model.OpenYear : (object)DBNull.Value);
                command.Parameters.AddWithValue("@LanesBase", model.LanesBase > 0 ? model.LanesBase : (object)DBNull.Value);
                command.Parameters.AddWithValue("@LanesFuture", model.LanesFuture > 0 ? model.LanesFuture : (object)DBNull.Value);
                command.Parameters.AddWithValue("@SpacesBase", model.SpacesBase > 0 ? model.SpacesBase : (object)DBNull.Value);
                command.Parameters.AddWithValue("@SpacesFuture", model.SpacesFuture > 0 ? model.SpacesFuture : (object)DBNull.Value);
                command.Parameters.AddWithValue("@AssignmentStatusId", model.AssignmentStatusID > 0 ? model.AssignmentStatusID : (object)DBNull.Value);
                command.Parameters.AddWithValue("@Length", model.Length > 0 ? model.Length : (object)DBNull.Value);
                command.Parameters.AddWithValue("@ModelingCheck", model.ModelingCheck);

                if (!String.IsNullOrEmpty(model.LRSxml))
                {
                    byte[] encodedString = System.Text.Encoding.UTF8.GetBytes(model.LRSxml);
                    MemoryStream ms = new MemoryStream(encodedString);
                    ms.Flush();
                    ms.Position = 0;

                    XmlDocument xml = new XmlDocument();
                    xml.Load(ms);

                    using (XmlNodeReader xnr = new XmlNodeReader(xml))
                    {
                        command.Parameters.Add("@xml", SqlDbType.Xml).Value = new SqlXml(xnr);
                        //command.Parameters.AddWithValue("@xml", !String.IsNullOrEmpty(model.LRSxml) ? model.LRSxml : (object)DBNull.Value);
                        command.Parameters.AddWithValue("@xmlSchemeId", !String.IsNullOrEmpty(model.LRSxml) ? (int)SchemeName.LRSProjects : (object)DBNull.Value);
                    }
                }

                this.ExecuteNonQuery(command);
            }
        }
Exemplo n.º 7
0
 public SegmentModel GetSegmentDetails(int segmentId)
 {
     DataTable data;
     using (SqlCommand command = new SqlCommand("[dbo].[GetSegment]") { CommandType = CommandType.StoredProcedure })
     {
         command.Parameters.AddWithValue("@SegmentId", segmentId);
         data = this.ExecuteDataTable(command);
     }
     SegmentModel model;
     DataRow row = data.Rows[0];
     model = new SegmentModel()
     {
         SegmentId = segmentId
         ,
         FacilityName = row["FacilityName"].ToString()
         ,
         StartAt = row["StartAt"].ToString()
         ,
         EndAt = row["EndAt"].ToString()
         ,
         NetworkId = row["NetworkId"].ToString().SmartParse<int>()
         ,
         ImprovementTypeId = row["ImprovementTypeId"].ToString().SmartParse<int>()
         ,
         PlanFacilityTypeId = row["PlanFacilityTypeId"].ToString().SmartParse<int>()
         ,
         OpenYear = row["OpenYear"].ToString().SmartParse<short>()
         ,
         LanesBase = row["LanesBase"].ToString().SmartParse<short>()
         ,
         LanesFuture = row["LanesFuture"].ToString().SmartParse<short>()
         ,
         SpacesBase = row["SpacesBase"].ToString().SmartParse<short>()
         ,
         SpacesFuture = row["SpacesFuture"].ToString().SmartParse<short>()
         ,
         AssignmentStatusID = row["AssignmentStatusID"].ToString().SmartParse<int>()
         ,
         Length = row["Length"].ToString().SmartParseDefault(default(decimal))
         ,
         ModelingCheck = row["ModelingCheck"].ToString().SmartParseDefault(default(bool))
         ,
         LRSObjectID = row["LRSObjectID"].ToString().SmartParse<int>()
     };
     return model;
 }
Exemplo n.º 8
0
        public Int32 AddSegment(SegmentModel model)
        {
            int retval = default(int);
            using (SqlCommand command = new SqlCommand("[dbo].[AddSegment]") { CommandType = CommandType.StoredProcedure })
            {
                command.Parameters.AddWithValue("@ProjectVersionId", model.ProjectVersionId);
                command.Parameters.AddWithValue("@FacilityName", model.FacilityName != null ? (object)model.FacilityName.ToString() : (object)DBNull.Value);
                command.Parameters.AddWithValue("@StartAt", model.StartAt != null ? (object)model.StartAt.ToString() : (object)DBNull.Value);
                command.Parameters.AddWithValue("@EndAt", model.EndAt != null ? (object)model.EndAt.ToString() : (object)DBNull.Value);
                command.Parameters.AddWithValue("@ImprovementTypeId", model.ImprovementTypeId > 0 ? model.ImprovementTypeId : (object)DBNull.Value);
                command.Parameters.AddWithValue("@PlanFacilityTypeId", model.PlanFacilityTypeId > 0 ? model.PlanFacilityTypeId : (object)DBNull.Value);
                command.Parameters.AddWithValue("@OpenYear", model.OpenYear > 0 ? model.OpenYear : (object)DBNull.Value);
                command.Parameters.AddWithValue("@LanesBase", model.LanesBase > 0 ? model.LanesBase : (object)DBNull.Value);
                command.Parameters.AddWithValue("@LanesFuture", model.LanesFuture > 0 ? model.LanesFuture : (object)DBNull.Value);
                command.Parameters.AddWithValue("@SpacesFuture", model.SpacesFuture > 0 ? model.SpacesFuture : (object)DBNull.Value);
                command.Parameters.AddWithValue("@AssignmentStatusId", model.AssignmentStatusID > 0 ? model.AssignmentStatusID : (object)DBNull.Value);
                command.Parameters.AddWithValue("@Length", model.Length > 0 ? model.Length : (object)DBNull.Value);

                SqlParameter outParam = new SqlParameter("@SegmentId", SqlDbType.Int);
                outParam.Direction = ParameterDirection.Output;
                command.Parameters.Add(outParam);

                this.ExecuteNonQuery(command);
                retval = (int)command.Parameters["@SegmentId"].Value;
            }
            return retval;
        }