public NewsArticle(int id)
{
NewsArticleDTO = new NewsArticleDTO();
NewsArticleDTO.Id = id;
try
{
using (var connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["MySQLConnection"].ConnectionString))
{
connection.Open();
using (var command = new MySqlCommand(string.Format("SELECT * FROM NewsArticle WHERE Id = {0}", id), connection))
{
var reader = command.ExecuteReader();
reader.Read();
if (reader.IsDBNull(1) == false)
{
NewsArticleDTO.Date = reader.GetDateTime(1);
}
else
{
NewsArticleDTO.Date = DateTime.Now;
}
if (reader.IsDBNull(2) == false)
{
NewsArticleDTO.Title = reader.GetString(2);
}
else
{
NewsArticleDTO.Title = null;
}
if (reader.IsDBNull(3) == false)
{
NewsArticleDTO.Body = reader.GetString(3);
}
else
{
NewsArticleDTO.Body = null;
}
reader.Close();
}
}
}
catch (MySqlException e)
{
//TODO: log error
}
}
public NewsArticle(int id)
{
GetConnection();
NewsArticleDTO = new NewsArticleDTO();
NewsArticleDTO.Id = id;
try
{
var cmd = new MySqlCommand();
cmd.Connection = _connection;
cmd.CommandText = string.Format("SELECT * FROM NewsArticle WHERE Id = {0}", id);
var reader = cmd.ExecuteReader();
try
{
reader.Read();
if (reader.IsDBNull(1) == false)
NewsArticleDTO.Date = reader.GetDateTime(1);
else
NewsArticleDTO.Date = DateTime.Now;
if (reader.IsDBNull(2) == false)
NewsArticleDTO.Title = reader.GetString(2);
else
NewsArticleDTO.Title = null;
if (reader.IsDBNull(3) == false)
NewsArticleDTO.Body = reader.GetString(3);
else
NewsArticleDTO.Body = null;
reader.Close();
}
catch (MySqlException e)
{
//TODO: log error
reader.Close();
}
}
catch (MySqlException e)
{
//TODO: log error
}
_connection.Close();
}
public IList <NewsArticleDTO> Get()
{
IList <NewsArticleDTO> newsArticles = new List <NewsArticleDTO>();
try
{
using (var connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["MySQLConnection"].ConnectionString))
{
connection.Open();
using (var command = new MySqlCommand(string.Format("SELECT * FROM NewsArticle ORDER BY Id DESC"), connection))
{
var reader = command.ExecuteReader();
while (reader.Read())
{
var newsArticle = new NewsArticleDTO();
if (reader.IsDBNull(0) == false)
{
newsArticle.Id = reader.GetInt32(0);
}
else
{
newsArticle.Date = DateTime.Now;
}
if (reader.IsDBNull(1) == false)
{
newsArticle.Date = reader.GetDateTime(1);
}
else
{
newsArticle.Date = DateTime.Now;
}
if (reader.IsDBNull(2) == false)
{
newsArticle.Title = reader.GetString(2);
}
else
{
newsArticle.Title = null;
}
if (reader.IsDBNull(3) == false)
{
newsArticle.Body = reader.GetString(3);
}
else
{
newsArticle.Body = null;
}
newsArticles.Add(newsArticle);
}
}
}
}
catch (MySqlException e)
{
//TODO: log error
}
return(newsArticles);
}
public IList<NewsArticleDTO> Get()
{
GetConnection();
IList<NewsArticleDTO> newsArticles = new List<NewsArticleDTO>();
try
{
var cmd = new MySqlCommand();
cmd.Connection = _connection;
cmd.CommandText = string.Format("SELECT * FROM NewsArticle ORDER BY Id DESC");
var reader = cmd.ExecuteReader();
try
{
while (reader.Read())
{
var newsArticle = new NewsArticleDTO();
if (reader.IsDBNull(0) == false)
newsArticle.Id = reader.GetInt32(0);
else
newsArticle.Date = DateTime.Now;
if (reader.IsDBNull(1) == false)
newsArticle.Date = reader.GetDateTime(1);
else
newsArticle.Date = DateTime.Now;
if (reader.IsDBNull(2) == false)
newsArticle.Title = reader.GetString(2);
else
newsArticle.Title = null;
if (reader.IsDBNull(3) == false)
newsArticle.Body = reader.GetString(3);
else
newsArticle.Body = null;
newsArticles.Add(newsArticle);
}
reader.Close();
}
catch (MySqlException e)
{
//TODO: log error
reader.Close();
}
}
catch (MySqlException e)
{
//TODO: log error
}
_connection.Close();
return newsArticles;
}
