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