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();
            }
        }