public HttpResponseMessage PostCreateRentalCar(RentalCarCreateRequest rentalCar)
{
if (rentalCar == null)
{
ModelState.AddModelError("", "Missing body data");
}
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
int newRentalCarId = rentalCarsService.CreateRentalCar(rentalCar);
string responseString = "New Rental Car ID: " + newRentalCarId;
return(Request.CreateResponse(HttpStatusCode.OK, responseString));
}
public int CreateRentalCar(RentalCarCreateRequest request)
{
using (var con = GetConnection())
{
var cmd = con.CreateCommand();
cmd.CommandText = "RentalCars_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Make", request.Make);
cmd.Parameters.AddWithValue("@Model", request.Model);
cmd.Parameters.AddWithValue("@Year", request.Year);
cmd.Parameters.AddWithValue("@CarType", request.CarType);
cmd.Parameters.AddWithValue("@VIN", request.VIN);
cmd.Parameters.AddWithValue("@Color", request.Color);
cmd.Parameters.Add("@Id", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@Id"].Value);
}
}
