/// <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"); model.Surveys = GetPlanSurveys(GetYearId(year, Enums.TimePeriodType.PlanYear)); //Enums.RTPCycleStatus rtpCycleStatus = model.RtpStatus.IsCurrent ? Enums.RTPCycleStatus.Active : Enums.RTPCycleStatus.Pending; //model.RtpSummary.Cycle = GetAmendmentDetails(sm.TimePeriodId, rtpCycleStatus); return model; }
/// <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> /// 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; }