//protected LRS GetProjectLRS(int projectVersionId)
//{
// LRS result = new LRS();
// using (SqlCommand command = new SqlCommand("[RTP].[GetProjectLRS]") { CommandType = CommandType.StoredProcedure })
// {
// command.Parameters.AddWithValue("@ProjectVersionId", projectVersionId);
// using (IDataReader rdr = ExecuteReader(command))
// {
// if (rdr.Read())
// {
// result.RouteName = rdr["Routename"].ToString();
// result.BeginMeasure = rdr["BEGINMEASU"] != DBNull.Value ? (double)rdr["BEGINMEASU"] : default(double);
// result.EndMeasure = rdr["ENDMEASURE"] != DBNull.Value ? (double)rdr["ENDMEASURE"] : default(double);
// result.Comments = rdr["Comments"].ToString();
// result.Offset = rdr["Offset"] != DBNull.Value ? (int)rdr["Offset"] : default(int);
// }
// }
// }
// return result;
//}
/// <summary>
/// Update the project scope information in the database
/// </summary>
/// <remarks>Uses the [RTP].[UpdateProjectScope] stored proc.</remarks>
/// <param name="model"></param>
public void UpdateProjectScope(ScopeModel model)
{
using (SqlCommand command = new SqlCommand("[RTP].[UpdateProjectScope]") { CommandType = CommandType.StoredProcedure })
{
command.Parameters.AddWithValue("@ProjectVersionID", model.ProjectVersionId);
command.Parameters.AddWithValue("@ProjectDescription", model.ProjectDescription);
command.Parameters.AddWithValue("@ShortDescription", model.ShortDescription);
this.ExecuteNonQuery(command);
}
}
public ScopeModel GetScopeModel(int projectVersionId, string year)
{
ScopeModel result = null;
using (SqlCommand command = new SqlCommand("[RTP].[GetProjectScope]") { CommandType = CommandType.StoredProcedure })
{
command.Parameters.AddWithValue("@ProjectVersionId", projectVersionId);
command.Parameters.AddWithValue("@Year", year);
using (IDataReader rdr = ExecuteReader(command))
{
if (rdr.Read())
{
result = new ScopeModel();
result.BeginConstructionYear = rdr["BeginConstructionYear"] != DBNull.Value ? (int?)Convert.ToInt32(rdr["BeginConstructionYear"]) : null;
//result.OpenToPublicYear = rdr["EndConstructionYear"] != DBNull.Value ? (int?)Convert.ToInt32(rdr["EndConstructionYear"]) : null;
result.ProjectDescription = rdr["ProjectDescription"].ToString();
result.ShortDescription = rdr["ShortDescription"].ToString();
result.ProjectId = rdr["ProjectId"] != DBNull.Value ? (int?)rdr["ProjectId"] : null;
result.ProjectName = rdr["ProjectName"].ToString();
result.ProjectVersionId = rdr["ProjectVersionId"] != DBNull.Value ? (int)rdr["ProjectVersionId"] : default(int);
result.RtpYear = year;
}
}
}
return result;
}