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