public DownloadCollection FetchByQuery(Query qry)
{
DownloadCollection coll = new DownloadCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
/// <summary>
/// Fetches the associated downloads by product id and not for purchase.
/// </summary>
/// <param name="productId">The product id.</param>
/// <returns></returns>
public DownloadCollection FetchAssociatedDownloadsByProductIdAndNotForPurchase(int productId)
{
IDataReader reader = SPs.FetchAssociatedDownloadsByProductIdAndNotForPurchase(productId).GetReader();
DownloadCollection artifactCollection = new DownloadCollection();
artifactCollection.LoadAndCloseReader(reader);
return(artifactCollection);
}
/// <summary>
/// Fetches the available downloads by product id.
/// </summary>
/// <param name="productId">The product id.</param>
/// <returns></returns>
public DownloadCollection FetchAvailableDownloadsByProductId(int productId)
{
IDataReader reader = SPs.FetchAvailableDownloadsByProductId(productId).GetReader();
DownloadCollection artifactCollection = new DownloadCollection();
artifactCollection.LoadAndCloseReader(reader);
return(artifactCollection);
}
public DownloadCollection FetchPurchasedDownloadsByUserId(Guid userId)
{
IDataReader reader = SPs.FetchPurchasedDownloadsByUserId(userId).GetReader();
DownloadCollection downloadCollection = new DownloadCollection();
downloadCollection.LoadAndCloseReader(reader);
return(downloadCollection);
}
public DownloadCollection FetchAll()
{
DownloadCollection coll = new DownloadCollection();
Query qry = new Query(Download.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public DownloadCollection FetchByID(object DownloadId)
{
DownloadCollection coll = new DownloadCollection().Where("DownloadId", DownloadId).Load();
return(coll);
}