/// <summary>
/// Update the Project Info in the database
/// </summary>
/// <param name="model"></param>
public void UpdateProjectInfo(InfoModel model)
{
using (SqlCommand command = new SqlCommand("[TIP].[UpdateProjectVersionInfo]") { CommandType = CommandType.StoredProcedure })
{
//model.Adoption != null ? (object)model.Adoption.Value : (object)DBNull.Value
command.Parameters.AddWithValue("@PROJECTVERSIONID", model.ProjectVersionId);
command.Parameters.AddWithValue("@TIPYEAR", model.TipYear);
command.Parameters.AddWithValue("@PROJECTID", model.ProjectId);
command.Parameters.AddWithValue("@PROJECTNAME", model.ProjectName);
command.Parameters.AddWithValue("@ProjectTypeID", model.ProjectTypeId);
//SponsorID is not stored - it's an attribute of the sponsor contact. -DB No, you are wrong. Unrelated concept. -DD
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("@ProjectPoolID", model.ProjectPoolId != null ? (object)model.ProjectPoolId.Value : (object)DBNull.Value);
command.Parameters.AddWithValue("@ISPOOLMASTER", model.IsPoolMaster != null ? (object)model.IsPoolMaster.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);
command.Parameters.AddWithValue("@StipId", model.STIPID);
this.ExecuteNonQuery(command);
}
}
protected IDictionary<int, string> AvailableSponsorContacts(InfoModel info)
{
if (info.SponsorId.HasValue)
{
return GetSponsorContacts(info.SponsorId.Value);
}
return null;
}
/// <summary>
/// Get a TipProjectVersionInfoModel. 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 tipYear)
{
InfoModel result = null;
using (SqlCommand command = new SqlCommand("[TIP].[GetProjectVersionInfo]") { CommandType = CommandType.StoredProcedure })
{
command.Parameters.AddWithValue("@TipYear", tipYear);
command.Parameters.AddWithValue("@TipProjectVersion", 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.ProjectVersionId = rdr["ProjectVersionID"] != DBNull.Value ? (int?)rdr["ProjectVersionID"] : null;
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.TipId = rdr["TipId"].ToString();
result.TipYear = rdr["TipYear"].ToString();
result.TransportationTypeId = rdr["TransportationTypeID"] != DBNull.Value ? (int?)rdr["TransportationTypeID"] : null;
result.SelectionAgencyId = rdr["SelectionAgencyID"] != DBNull.Value ? (int?)rdr["SelectionAgencyID"] : null;
result.ProjectPoolId = rdr["ProjectPoolId"] != DBNull.Value ? (int?)rdr["ProjectPoolId"] : null;
result.IsRegionallySignificant = rdr["RegionalSignificance"] != DBNull.Value ? (bool)rdr["RegionalSignificance"] : false;
result.LocationMapId = rdr["LocationMapID"].ToString().SmartParseDefault<int>(default(int));
result.STIPID = rdr["STIPId"].ToString();
}
}
}
return result;
}
