public ProductRatingCollection FetchAll()
{
ProductRatingCollection coll = new ProductRatingCollection();
Query qry = new Query(ProductRating.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
/// <summary>
/// Gets the user's rating for a products
/// </summary>
/// <param name="userName"></param>
/// <param name="productID"></param>
/// <returns></returns>
public static int GetUserRating(string userName, int productID)
{
int iOut = -1;
ProductRating rating = new ProductRating();
rating.UserName = Utility.GetUserName();
rating.ProductID = productID;
IDataReader rdr = ProductRating.Find(rating);
ProductRatingCollection coll = new ProductRatingCollection();
coll.Load(rdr);
rdr.Close();
if (coll.Count > 0)
{
iOut = coll[0].Rating;
}
return(iOut);
}
public ProductRatingCollection FetchByQuery(Query qry)
{
ProductRatingCollection coll = new ProductRatingCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
public ProductRatingCollection FetchByID(object ProductRatingId)
{
ProductRatingCollection coll = new ProductRatingCollection().Where("ProductRatingId", ProductRatingId).Load();
return coll;
}
