public List<News> GetAllNews()
{
List<News> list = new List<News>();
using (SqlCommand cmd = GetCommand("getAllNews", CommandType.StoredProcedure))
{
News news = new News();
using (SqlDataReader dr = ExeDataReader(cmd))
{
if (dr.HasRows)
{
while (dr.Read())
{
list.Add(news.NewsIDatareader(dr));
}
}
}
news = null;
}
return list;
}
public List<News> GetNewsByID(string id)
{
List<News> list = new List<News>();
using (SqlCommand cmd = GetCommand("getNewsByID", CommandType.StoredProcedure))
{
AddParameter(cmd, "@ID", Convert.ToInt32(id));
News news = new News();
using (SqlDataReader dr = ExeDataReader(cmd))
{
if (dr.HasRows)
{
while (dr.Read())
{
list.Add(news.NewsIDatareader(dr));
}
}
}
news = null;
}
return list;
}
public List<News> SearchNewsByTitle(string title)
{
List<News> list = new List<News>();
using (SqlCommand cmd = GetCommand("SearchNewsByTitle", CommandType.StoredProcedure))
{
AddParameter(cmd, "@Title", title);
News news = new News();
using (SqlDataReader dr = ExeDataReader(cmd))
{
if (dr.HasRows)
{
while (dr.Read())
{
list.Add(news.NewsIDatareader(dr));
}
}
}
news = null;
}
return list;
}
