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