/// <summary> /// Update the Project Info in the database /// </summary> /// <param name="model"></param> public void UpdateProjectInfo(InfoModel model) { using (SqlCommand command = new SqlCommand("[RTP].[UpdateProjectVersionInfo]") { CommandType = CommandType.StoredProcedure }) { command.Parameters.AddWithValue("@PROJECTVERSIONID", model.ProjectVersionId); command.Parameters.AddWithValue("@TIMEPERIOD", model.RtpYear); command.Parameters.AddWithValue("@PROJECTID", model.ProjectId); command.Parameters.AddWithValue("@PROJECTNAME", model.ProjectName); command.Parameters.AddWithValue("@ProjectTypeID", model.ProjectTypeId); command.Parameters.AddWithValue("@SPONSORID", model.SponsorId != null ? (object)model.SponsorId.Value : (object)DBNull.Value); command.Parameters.AddWithValue("@SPONSORCONTACTID", model.SponsorContactId != null ? (object)model.SponsorContactId.Value : (object)DBNull.Value); command.Parameters.AddWithValue("@ADMINLEVELID", model.AdministrativeLevelId != null ? (object)model.AdministrativeLevelId.Value : (object)DBNull.Value); command.Parameters.AddWithValue("@IMPTYPEID", model.ImprovementTypeId != null ? (object)model.ImprovementTypeId.Value : (object)DBNull.Value); command.Parameters.AddWithValue("@TRANSTYPEID", model.TransportationTypeId != null ? (object)model.TransportationTypeId.Value : (object)DBNull.Value); command.Parameters.AddWithValue("@SelectionAgencyID", model.SelectionAgencyId != null ? (object)model.SelectionAgencyId.Value : (object)DBNull.Value); command.Parameters.AddWithValue("@SPONSORNOTES", model.SponsorNotes); command.Parameters.AddWithValue("@DRCOGNOTES", model.DRCOGNotes); command.Parameters.AddWithValue("@RegionallySignificant", model.IsRegionallySignificant != null ? (object)model.IsRegionallySignificant.Value : (object)DBNull.Value); this.ExecuteNonQuery(command); } }
protected IDictionary<int, string> AvailableSponsorContacts(InfoModel info) { if (info.SponsorId.HasValue) { return GetSponsorContacts(info.SponsorId.Value); } return null; }
/// <summary> /// Get a RtpProjectVersionInfoModel. This is the model behind the /// Info Tab /// </summary> /// <param name="versionId"></param> /// <param name="tipYear"></param> /// <returns></returns> public InfoModel GetProjectInfo(int versionId, string year) { //throw new NotImplementedException(); InfoModel result = null; using (SqlCommand command = new SqlCommand("[RTP].[GetProjectVersionInfo]") { CommandType = CommandType.StoredProcedure }) { command.Parameters.AddWithValue("@RtpYear", year); command.Parameters.AddWithValue("@RtpProjectVersion", versionId); command.Parameters.AddWithValue("@IsActive", 1); using (IDataReader rdr = ExecuteReader(command)) { if (rdr.Read()) { result = new InfoModel(); result.AdministrativeLevelId = rdr["AdministrativeLevelID"] != DBNull.Value ? (int?)rdr["AdministrativeLevelID"] : null; result.DRCOGNotes = rdr["DRCOGNotes"].ToString(); result.ImprovementTypeId = rdr["ImprovementTypeId"] != DBNull.Value ? (int?)rdr["ImprovementTypeId"] : null; result.PoolMasterVersionID = rdr["PoolMasterVersionID"] != DBNull.Value ? (int?)rdr["PoolMasterVersionID"] : null; result.ProjectId = rdr["ProjectID"] != DBNull.Value ? (int?)rdr["ProjectID"] : null; result.ProjectName = rdr["ProjectName"].ToString(); result.ProjectTypeId = rdr["ProjectTypeID"] != DBNull.Value ? (int?)rdr["ProjectTypeID"] : null; result.ProjectType = rdr["ProjectType"].ToString(); result.ProjectVersionId = rdr["ProjectVersionID"] != DBNull.Value ? (int)rdr["ProjectVersionID"] : default(int); result.SponsorContactId = rdr["SponsorContactID"] != DBNull.Value ? (int?)rdr["SponsorContactID"] : null; result.SponsorId = rdr["SponsorID"] != DBNull.Value ? (int?)rdr["SponsorID"] : null; result.SponsorNotes = rdr["SponsorNotes"].ToString(); result.RtpId = rdr["RtpId"].ToString(); result.RtpYear = rdr["RtpYear"].ToString(); result.TransportationTypeId = rdr["TransportationTypeID"] != DBNull.Value ? (int?)rdr["TransportationTypeID"] : null; result.SelectionAgencyId = rdr["SelectionAgencyID"] != DBNull.Value ? (int?)rdr["SelectionAgencyID"] : null; result.IsRegionallySignificant = rdr["RegionalSignificance"] != DBNull.Value ? (bool)rdr["RegionalSignificance"] : false; } } } return result; }