public News GetNewsById(int newsId) { var news = new News(); if (newsId > 0) { news = _newsRepository.GetNewsById(newsId); } else { //TODO:Haber yoktur } return news; }
public News GetNewsById(int newsId) { var dataRowNews = sqlHelper.GetDataRow("select * from News where Id=" + newsId); var news = new News { Id = Convert.ToInt32(dataRowNews["Id"].ToString()), Tittle = dataRowNews["Title"].ToString(), Description = dataRowNews["Description"].ToString(), ImageUrl = dataRowNews["ImageUrl"].ToString(), Author = dataRowNews["Author"].ToString(), Date = dataRowNews["NewsDate"].ToString() }; return news; }
public NewsCollection GetNewsForHomePage(byte maxNewsCount) { var newsCollection = new NewsCollection(); var dt = sqlHelper.GetDataTable("select top(" + maxNewsCount + ") * from News order by NewsDate desc "); if (dt.Rows.Count > 0) { for (var i = 0; i < dt.Rows.Count; i++) { var news = new News { Id = Convert.ToInt32(dt.Rows[i]["Id"].ToString()), Tittle = dt.Rows[i]["Title"].ToString(), Description = dt.Rows[i]["Description"].ToString(), ImageUrl = dt.Rows[i]["ImageUrl"].ToString(), Author = dt.Rows[i]["Author"].ToString(), Date = dt.Rows[i]["NewsDate"].ToString() }; newsCollection.Add(news); } } return newsCollection; }