public ReviewCollection FetchByQuery(Query qry)
{
ReviewCollection coll = new ReviewCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
/// <summary>
/// Fetch by product id.
/// </summary>
/// <param name="productId">The product id.</param>
/// <returns></returns>
public ReviewCollection FetchByProductId(int productId)
{
ReviewCollection reviewCollection = new ReviewCollection().
Where(Review.Columns.ProductId, Comparison.Equals, productId).
Load();
return(reviewCollection);
}
public ReviewCollection FetchAll()
{
ReviewCollection coll = new ReviewCollection();
Query qry = new Query(Review.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
/// <summary>
/// Fetches by product id and user id.
/// </summary>
/// <param name="productId">The product id.</param>
/// <param name="userId">The user id.</param>
/// <returns></returns>
public Review FetchByProductIdAndUserId(int productId, string userId)
{
Review review = null;
ReviewCollection reviewCollection = new ReviewCollection().
Where(Review.Columns.ProductId, productId).
Where(Review.Columns.CreatedBy, userId).
Load();
if (reviewCollection.Count > 0)
{
review = reviewCollection[0];
}
return(review);
}
public ReviewCollection FetchByID(object ReviewId)
{
ReviewCollection coll = new ReviewCollection().Where("ReviewId", ReviewId).Load();
return(coll);
}