public static Articles GetArticleFromDb(NpgsqlConnection connection, int id)
{
var reader = connection.GetDataFromDb($@"SELECT * FROM ARTICLES WHERE id = '{id}'");
var articles = new Articles();
if (reader.Read())
{
articles = ArticlesDAO.MadeNewArticleObject(reader);
}
reader.Close();
return(articles);
}
public static List <Articles> GetAllArticles(NpgsqlConnection connection)
{
var reader = connection.GetDataFromDb($@"SELECT * FROM ARTICLES ORDER BY DATE_CREATE DESC");
var articles = new List <Articles>();
while (reader.Read())
{
articles.Add(ArticlesDAO.MadeNewArticleObject(reader));
}
reader.Close();
return(articles);
}