// POST api/contacts public HttpResponseMessage Post([FromBody] Contact contact) { try { var conn = WebApiConfig.GetMySqlConnection(); var command = conn.CreateCommand(); command.CommandText = @"INSERT INTO contacts (`id`, `isFavorite`, `first`, `last`, `dob`, `phone`, `gender`, `rel`, `des`) VALUES (NULL, 0, @first, @last, @dob, @phone, @gender, @rel, @des)"; ContactMapper.GetParametersFromContact(command, contact); conn.Open(); try { if (command.ExecuteNonQuery() != 1) { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } catch { throw; } } catch { return(Request.CreateResponse(HttpStatusCode.InternalServerError)); } return(Request.CreateResponse(HttpStatusCode.OK)); }
// PUT api/contacts/5 public HttpResponseMessage Put(int id, [FromBody] Contact contact) { try { var conn = WebApiConfig.GetMySqlConnection(); var command = conn.CreateCommand(); command.CommandText = @"UPDATE contacts SET first=@first, last=@last, dob=@dob, phone=@phone, gender=@gender, rel=@rel, des=@des WHERE id=@id" ; command.Parameters.AddWithValue("@id", id); ContactMapper.GetParametersFromContact(command, contact); conn.Open(); try { if (command.ExecuteNonQuery() != 1) { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } catch { throw; } } catch { return(Request.CreateResponse(HttpStatusCode.InternalServerError)); } return(Request.CreateResponse(HttpStatusCode.OK)); }