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