public HttpResponseMessage Post(SettingsCreate req)
{
if (req == null)
{
ModelState.AddModelError("Null", "Model cannot be null");
}
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
int id = _settingsService.Create(req);
return(Request.CreateResponse(HttpStatusCode.OK, new ItemResponse <int>
{
Item = id
}));
}
public int Create(SettingsCreate req)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "Settings_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SearchTerm", req.Term);
cmd.Parameters.AddWithValue("@Radius", req.Radius);
cmd.Parameters.AddWithValue("@Price", req.Price);
cmd.Parameters.AddWithValue("@OpenNow", req.OpenNow);
cmd.Parameters.AddWithValue("@Location", req.Location);
cmd.Parameters.Add("@Id", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
int id = (int)cmd.Parameters["@Id"].Value;
return(id);
}
}
