/// <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;
}
