/// <summary>
/// Gets forum subscriptions
/// </summary>
/// <param name="UserID">The user identifier</param>
/// <param name="ForumID">The forum identifier</param>
/// <param name="TopicID">The topic identifier</param>
/// <param name="PageSize">Page size</param>
/// <param name="PageIndex">Page index</param>
/// <param name="TotalRecords">Total records</param>
/// <returns>Forum subscriptions</returns>
public override DBForumSubscriptionCollection GetAllSubscriptions(int UserID, int ForumID,
int TopicID, int PageSize, int PageIndex, out int TotalRecords)
{
TotalRecords = 0;
DBForumSubscriptionCollection forumSubscriptionCollection = new DBForumSubscriptionCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_Forums_SubscriptionLoadAll");
db.AddInParameter(dbCommand, "UserID", DbType.Int32, UserID);
db.AddInParameter(dbCommand, "ForumID", DbType.Int32, ForumID);
db.AddInParameter(dbCommand, "TopicID", DbType.Int32, TopicID);
db.AddInParameter(dbCommand, "PageSize", DbType.Int32, PageSize);
db.AddInParameter(dbCommand, "PageIndex", DbType.Int32, PageIndex);
db.AddOutParameter(dbCommand, "TotalRecords", DbType.Int32, 0);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBForumSubscription forumSubscription = GetForumSubscriptionFromReader(dataReader);
forumSubscriptionCollection.Add(forumSubscription);
}
}
TotalRecords = Convert.ToInt32(db.GetParameterValue(dbCommand, "@TotalRecords"));
return forumSubscriptionCollection;
}
private static ForumSubscriptionCollection DBMapping(DBForumSubscriptionCollection dbCollection)
{
if (dbCollection == null)
return null;
ForumSubscriptionCollection collection = new ForumSubscriptionCollection();
foreach (DBForumSubscription dbItem in dbCollection)
{
ForumSubscription item = DBMapping(dbItem);
collection.Add(item);
}
return collection;
}
