private static ForumGroupCollection DBMapping(DBForumGroupCollection dbCollection) { if (dbCollection == null) return null; ForumGroupCollection collection = new ForumGroupCollection(); foreach (DBForumGroup dbItem in dbCollection) { ForumGroup item = DBMapping(dbItem); collection.Add(item); } return collection; }
/// <summary> /// Gets all forum groups /// </summary> /// <returns>Forum groups</returns> public override DBForumGroupCollection GetAllForumGroups() { DBForumGroupCollection forumGroupCollection = new DBForumGroupCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_Forums_GroupLoadAll"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBForumGroup forumGroup = GetForumGroupFromReader(dataReader); forumGroupCollection.Add(forumGroup); } } return forumGroupCollection; }