public IHttpActionResult PutVacancyLocation(int id, VacancyLocation vacancyLocation) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != vacancyLocation.ID) { return(BadRequest()); } db.Entry(vacancyLocation).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!VacancyLocationExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult GetVacancyLocation(int id) { VacancyLocation vacancyLocation = db.VacancyLocation.Find(id); if (vacancyLocation == null) { return(NotFound()); } return(Ok(vacancyLocation)); }
public IHttpActionResult PostVacancyLocation(VacancyLocation vacancyLocation) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.VacancyLocation.Add(vacancyLocation); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = vacancyLocation.ID }, vacancyLocation)); }
private void PopulateCountyId(VacancyLocation entity, Entities.VacancyLocation dbVacancyLocation) { if (!string.IsNullOrWhiteSpace(entity.Address?.County)) { dbVacancyLocation.CountyId = _getOpenConnection.QueryCached <int>(_cacheDuration, @" SELECT CountyId FROM dbo.County WHERE FullName = @CountyFullName", new { CountyFullName = entity.Address.County }).SingleOrDefault(); } }
public IHttpActionResult DeleteVacancyLocation(int id) { VacancyLocation vacancyLocation = db.VacancyLocation.Find(id); if (vacancyLocation == null) { return(NotFound()); } db.VacancyLocation.Remove(vacancyLocation); db.SaveChanges(); return(Ok(vacancyLocation)); }
private void MapCountyId(Entities.VacancyLocation dbVacancyLocation, VacancyLocation result) { // Not all the vacancies have CountyId (before being accepted by QA). // A multilocation vacancy (more than one location) doesn't have anything in the address fields. if (dbVacancyLocation.CountyId > 0) { result.Address.County = _getOpenConnection.QueryCached <string>(_cacheDuration, @" SELECT FullName FROM dbo.County WHERE CountyId = @CountyId", new { CountyId = dbVacancyLocation.CountyId }).SingleOrDefault(); } }
private void PopulateLocalAuthorityId(VacancyLocation entity, Entities.VacancyLocation dbVacancyLocation) { if (!string.IsNullOrWhiteSpace(entity.LocalAuthorityCode)) { dbVacancyLocation.LocalAuthorityId = _getOpenConnection.QueryCached <int>(_cacheDuration, @" SELECT LocalAuthorityId FROM dbo.LocalAuthority WHERE CodeName = @LocalAuthorityCode", new { entity.LocalAuthorityCode }).Single(); } else { dbVacancyLocation.LocalAuthorityId = null; } }
private void MapLocalAuthorityCode(Entities.VacancyLocation dbVacancyLocation, VacancyLocation result) { if (dbVacancyLocation.LocalAuthorityId.HasValue) { result.LocalAuthorityCode = _getOpenConnection.QueryCached <string>(_cacheDuration, @" SELECT CodeName FROM dbo.LocalAuthority WHERE LocalAuthorityId = @LocalAuthorityId", new { dbVacancyLocation.LocalAuthorityId }).Single(); } else { result.LocalAuthorityCode = null; } }