Ejemplo n.º 1
0
        public HttpResponseMessage PutUpdateRentalLocation(int id, RentalLocationUpdateRequest rentalLocationUpdate)
        {
            if (rentalLocationUpdate == null)
            {
                ModelState.AddModelError("", "Missing body data");
            }
            else if (id != rentalLocationUpdate.Id)
            {
                ModelState.AddModelError("id", "ID in URL does not match ID in body");
            }

            if (!ModelState.IsValid)
            {
                return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
            }

            rentalLocationService.UpdateRentalLocation(rentalLocationUpdate);

            return(Request.CreateResponse(HttpStatusCode.OK));
        }
        public void UpdateRentalLocation(RentalLocationUpdateRequest request)
        {
            using (var con = GetConnection())
            {
                var cmd = con.CreateCommand();
                cmd.CommandText = "RentalLocations_Update";
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.AddWithValue("@Id", request.Id);
                cmd.Parameters.AddWithValue("@LocationName", request.LocationName);
                cmd.Parameters.AddWithValue("@Street", request.Street);
                cmd.Parameters.AddWithValue("@City", request.City);
                cmd.Parameters.AddWithValue("@State", request.State);
                cmd.Parameters.AddWithValue("@Zip", request.Zip);
                cmd.Parameters.AddWithValue("@Phone", request.Phone);
                cmd.Parameters.AddWithValue("@Country", request.Country);
                cmd.Parameters.AddWithValue("@Lat", request.Lat);
                cmd.Parameters.AddWithValue("@Long", request.Long);

                cmd.ExecuteNonQuery();
            }
        }