public bool ResolveMessage(Guid sosId, ResolveUpdate resolveMessage) { if (resolveMessage == null) { return(false); } MySqlConnection conn = null; try { conn = ConnectionManager.GetConnection(); MySqlCommand cmd = new MySqlCommand(UPDATE_SOS_MESSAGE, conn); cmd.Parameters.AddWithValue("@guid", sosId); cmd.Parameters.AddWithValue("@last_update", resolveMessage.LastUpdate); cmd.Parameters.AddWithValue("@lat", resolveMessage.Lat); cmd.Parameters.AddWithValue("@longi", resolveMessage.Longi); cmd.Parameters.AddWithValue("@is_resolved", true); int numOfRows = cmd.ExecuteNonQuery(); if (numOfRows == 1) { return(true); } } catch (MySql.Data.MySqlClient.MySqlException ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } return(false); }
public HttpResponseMessage Resolve(string id, [FromBody] string value) { HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Conflict, id); try { ResolveUpdate resolveUpdate = JsonConvert.DeserializeObject <ResolveUpdate>(value); bool result = new SosMessageDAO().ResolveMessage(Guid.Parse(id), resolveUpdate); if (result) { response = Request.CreateResponse(HttpStatusCode.OK, resolveUpdate.LastUpdate); response.Headers.Location = new Uri(Request.RequestUri, string.Format("sos/{0}", id)); return(response); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex); } return(response); }