public HttpResponseMessage GetAll()
{
try
{
List <Amigo> lstAmigos = new List <Amigo>();
Amigo amigo = new Amigo();
lstAmigos = amigo.listarTodos();
//using (SqlConnection connection = new SqlConnection(this.ConnectionString))
//{
// connection.Open();
// using (SqlCommand command = new SqlCommand())
// {
// command.Connection = connection;
// command.CommandText = "select nome, latitude, longitude from amigo";
// SqlDataReader reader = command.ExecuteReader();
// while (reader.Read())
// {
// Amigo amigo = new Amigo()
// {
// nome = reader["nome"] == DBNull.Value ? string.Empty : reader["nome"].ToString(),
// longitude = reader["longitude"] == DBNull.Value ? 0: float.Parse(reader["longitude"].ToString()),
// latitude = reader["latitude"] == DBNull.Value ? 0 : float.Parse(reader["longitude"].ToString())
// };
// lstAmigos.Add(amigo);
// }
// }
// connection.Close();
//}
return(Request.CreateResponse(HttpStatusCode.OK, lstAmigos.ToArray()));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}