public void Put(LocationModel model) { try { ProjectRepository.UpdateProjectLocationModel(model); } catch (Exception ex) { Logger.WarnException("Could not update TIP Project Location", ex); throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.ExpectationFailed) { ReasonPhrase = ex.Message }); } }
/// <summary> /// Store the Location model attributes - Facility Name and Limits ONLY /// </summary> /// <param name="model"></param> public void UpdateProjectLocationModel(LocationModel model) { using (SqlCommand command = new SqlCommand("[TIP].[UpdateProjectLocation]") { CommandType = CommandType.StoredProcedure }) { //model.Adoption != null ? (object)model.Adoption.Value : (object)DBNull.Value command.Parameters.AddWithValue("@PROJECTVERSIONID", model.ProjectVersionId); command.Parameters.AddWithValue("@FACILITYNAME", model.FacilityName); command.Parameters.AddWithValue("@LIMITS", model.Limits); command.Parameters.AddWithValue("@CDOTRegionId", model.CdotRegionId); command.Parameters.AddWithValue("@AffectedProjectDelaysLocationId", model.AffectedProjectDelaysLocationId); this.ExecuteNonQuery(command); } }
/// <summary> /// Get the Location Model /// </summary> /// <param name="versionId"></param> /// <param name="tipYear"></param> /// <returns></returns> public LocationModel GetProjectLocationModel(int versionId, string tipYear) { LocationModel result = null; using (SqlCommand command = new SqlCommand("[TIP].[GetProjectLocation]") { CommandType = CommandType.StoredProcedure }) { command.Parameters.AddWithValue("@PROJECTVERSIONID", versionId); command.Parameters.AddWithValue("@TIPYEAR", tipYear); using (IDataReader rdr = ExecuteReader(command)) { if (rdr.Read()) { result = new LocationModel(); result.FacilityName = rdr["FacilityName"].ToString(); result.Limits = rdr["Limits"].ToString(); result.ProjectVersionId = versionId; result.TipYear = tipYear; result.ProjectName = rdr["ProjectName"].ToString(); result.ProjectId = rdr["ProjectId"] != DBNull.Value ? (int?)rdr["ProjectId"] : null; result.LocationMapId = rdr["LocationMapID"].ToString().SmartParseDefault<int>(default(int)); result.CdotRegionId = rdr["CDOTRegionId"].ToString().SmartParseDefault<int>(default(int)); result.AffectedProjectDelaysLocationId = rdr["AffectedProjectDelaysLocationId"].ToString().SmartParseDefault<int>(default(int)); } } } return result; }