public static List <ComentarioFacebookDAO> BuscarTodosComentariosComLocalidade(string localidade)
{
var query = $"SELECT * FROM comentario WHERE mensagem like '%{localidade} %'";
var cmd = new MySqlCommand(query, Conexao.Connection);
var reader = cmd.ExecuteReader();
var comentarios = new List <ComentarioFacebookDAO>();
while (reader.Read())
{
var c = new ComentarioFacebookDAO
{
message = reader["mensagem"].ToString(),
IdCidade = long.Parse(reader["id_cidade"].ToString()),
IdPagina = long.Parse(reader["id_pagina"].ToString()),
IdPost = long.Parse(reader["id_post"].ToString()),
//IdRespondido = long.Parse(reader["id_comentario_respondido"].ToString()),
IdComentario = long.Parse(reader["id_comentario"].ToString()),
id = reader["id_redesocial"].ToString(),
created_time = reader["data"].ToString(),
like_count = int.Parse(reader["like_count"].ToString()),
from = new From
{
id = reader["id_autor"].ToString(),
name = reader["nome_autor"].ToString()
},
Hash = reader["hash_mensagem"].ToString()
};
comentarios.Add(c);
}
Conexao.Connection.Close();
return(comentarios);
}
public static List <ComentarioFacebookDAO> BuscarTodosComentariosDaCidade(CidadeDAO cidade, int ultimosDias = 0)
{
var query = $"SELECT * FROM comentario WHERE id_cidade = {cidade.Id}";
if (ultimosDias > 0)
{
query += $" AND data > now() - interval {ultimosDias} day";
}
var cmd = new MySqlCommand(query, Conexao.Connection);
var reader = cmd.ExecuteReader();
var comentarios = new List <ComentarioFacebookDAO>();
while (reader.Read())
{
var c = new ComentarioFacebookDAO
{
message = reader["mensagem"].ToString(),
IdCidade = long.Parse(reader["id_cidade"].ToString()),
IdPagina = long.Parse(reader["id_pagina"].ToString()),
IdPost = long.Parse(reader["id_post"].ToString()),
//IdRespondido = long.Parse(reader["id_comentario_respondido"].ToString()),
IdComentario = long.Parse(reader["id_comentario"].ToString()),
id = reader["id_redesocial"].ToString(),
created_time = reader["data"].ToString(),
like_count = int.Parse(reader["like_count"].ToString()),
from = new From
{
id = reader["id_autor"].ToString(),
name = reader["nome_autor"].ToString()
},
Hash = reader["hash_mensagem"].ToString()
};
comentarios.Add(c);
}
Conexao.Connection.Close();
return(comentarios);
}
