private static ForumCollection DBMapping(DBForumCollection dbCollection)
{
if (dbCollection == null)
return null;
ForumCollection collection = new ForumCollection();
foreach (DBForum dbItem in dbCollection)
{
Forum item = DBMapping(dbItem);
collection.Add(item);
}
return collection;
}
/// <summary>
/// Gets forums by group identifier
/// </summary>
/// <param name="ForumGroupID">The forum group identifier</param>
/// <returns>Forums</returns>
public override DBForumCollection GetAllForumsByGroupID(int ForumGroupID)
{
DBForumCollection forumCollection = new DBForumCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_Forums_ForumLoadAllByForumGroupID");
db.AddInParameter(dbCommand, "ForumGroupID", DbType.Int32, ForumGroupID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBForum forum = GetForumFromReader(dataReader);
forumCollection.Add(forum);
}
}
return forumCollection;
}
