public HttpResponseMessage InsertBreed(BreedRequestModel model)
{
if (ModelState.IsValid)
{
_breedService.InsertBreed(model);
return Request.CreateResponse(HttpStatusCode.OK, model);
}
else
return Request.CreateResponse(HttpStatusCode.BadRequest, ModelState);
}
public void InsertBreed(BreedRequestModel model)
{
Configuration rootConfig = WebConfigurationManager.OpenWebConfiguration("/DogVDog");
ConnectionStringSettings connString = rootConfig.ConnectionStrings.ConnectionStrings["DefaultConnection"];
SqlConnection conn = new SqlConnection(connString.ConnectionString);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "Breeds_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Breed", model.Breed);
if(model.Region != null)
cmd.Parameters.AddWithValue("@Region", model.Region);
else
cmd.Parameters.AddWithValue("@Region", DBNull.Value);
cmd.Parameters.AddWithValue("@IsCute", model.IsCute);
cmd.Parameters.AddWithValue("@MedicalIssues", model.MedicalIssues);
cmd.ExecuteNonQuery();
conn.Close();
}