public HttpResponseMessage PutUpdateRentalCar(int id, RentalCarUpdateRequest updateRequest) { if (updateRequest == null) { ModelState.AddModelError("", "Missing body data"); } else if (id != updateRequest.Id) { ModelState.AddModelError("id", "ID in URL does not match ID in body"); } if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } rentalCarsService.UpdateRentalCar(updateRequest); return(Request.CreateResponse(HttpStatusCode.OK)); }
public void UpdateRentalCar(RentalCarUpdateRequest request) { using (var con = GetConnection()) { var cmd = con.CreateCommand(); cmd.CommandText = "RentalCars_Update"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id", request.Id); cmd.Parameters.AddWithValue("@Make", request.Make); cmd.Parameters.AddWithValue("@Model", request.Model); cmd.Parameters.AddWithValue("@Year", request.Year); cmd.Parameters.AddWithValue("@Color", request.Color); cmd.Parameters.AddWithValue("@CarType", request.CarType); cmd.Parameters.AddWithValue("@VIN", request.VIN); cmd.ExecuteNonQuery(); } }