/// <summary> /// Get review by id. /// </summary> /// <param name="reviewId">The review id.</param> /// <returns>The review.</returns> public Review GetById(int reviewId) { using (PlanetWrox.ReviewDataTable dtReview = new PlanetWrox.ReviewDataTable()) using (ReviewTableAdapter adpt = new ReviewTableAdapter()) { adpt.FillById(dtReview, reviewId); if (dtReview != null && dtReview.Rows.Count > 0) { Review review = (from drReview in dtReview select new Review { Id = drReview.Id, Title = drReview.Title, Summary = drReview.Summary, Body = !drReview.IsBodyNull() ? drReview.Body : string.Empty, GenreId = drReview.GenreId, Authorized = drReview.Authorized, CreateDateTime = drReview.CreateDateTime, UpdateDateTime = drReview.UpdateDateTime }).Single(); return review; } } return null; }
/// <summary> /// Get review by genre. /// </summary> /// <param name="genreId">The genre id.</param> /// <returns>The review collection.</returns> public IList<Review> GetByGenre(int genreId) { using (PlanetWrox.ReviewDataTable dtReview = new PlanetWrox.ReviewDataTable()) using (ReviewTableAdapter adpt = new ReviewTableAdapter()) { adpt.FillByGenre(dtReview, genreId); if (dtReview != null && dtReview.Rows.Count > 0) { IEnumerable<Review> reviews = from drReview in dtReview select new Review { Id = drReview.Id, Title = drReview.Title, Summary = drReview.Summary, Body = !drReview.IsBodyNull() ? drReview.Body : string.Empty, GenreId = drReview.GenreId, Authorized = drReview.Authorized, CreateDateTime = drReview.CreateDateTime, UpdateDateTime = drReview.UpdateDateTime }; return reviews.ToList(); } } return null; }