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