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