public static List <PostFacebookDAO> BuscarTodosPosts()
{
var query = "SELECT * FROM post";
var cmd = new MySqlCommand(query, Conexao.Connection);
var reader = cmd.ExecuteReader();
List <PostFacebookDAO> list = new List <PostFacebookDAO>();
while (reader.Read())
{
var data = reader["data"].ToString();
var post = new PostFacebookDAO
{
Id = int.Parse(reader["id_post"].ToString()),
IdPagina = int.Parse(reader["id_pagina"].ToString()),
IdCidade = int.Parse(reader["id_cidade"].ToString()),
id = reader["id_redesocial"].ToString(),
link = reader["link"].ToString(),
Data = DateTime.ParseExact(data, "dd/MM/yyyy HH:mm:ss", null),
message = reader["titulo"].ToString(),
};
list.Add(post);
}
Conexao.Connection.Close();
return(list);
}
public static List <PostFacebookDAO> BuscarPostsPagina(long idPagina, int ultimosDias = 0)
{
Conexao.Connection.Close();
var query = $"SELECT * FROM post WHERE id_pagina = {idPagina}";
if (ultimosDias > 0)
{
query += $" and data > now() - interval {ultimosDias} day";
}
var cmd = new MySqlCommand(query, Conexao.Connection);
var reader = cmd.ExecuteReader();
List <PostFacebookDAO> list = new List <PostFacebookDAO>();
while (reader.Read())
{
var data = reader["data"].ToString();
var post = new PostFacebookDAO
{
Id = int.Parse(reader["id_post"].ToString()),
IdPagina = int.Parse(reader["id_pagina"].ToString()),
IdCidade = int.Parse(reader["id_cidade"].ToString()),
id = reader["id_redesocial"].ToString(),
link = reader["link"].ToString(),
Data = DateTime.ParseExact(data, "dd/MM/yyyy HH:mm:ss", null),
message = reader["titulo"].ToString(),
};
list.Add(post);
}
Conexao.Connection.Close();
return(list);
}