private static ActivityLogTypeCollection DBMapping(DBActivityLogTypeCollection dbCollection) { if (dbCollection == null) return null; var collection = new ActivityLogTypeCollection(); foreach (var dbItem in dbCollection) { var item = DBMapping(dbItem); collection.Add(item); } return collection; }
/// <summary> /// Gets all activity log type items /// </summary> /// <returns>Activity log type collection</returns> public override DBActivityLogTypeCollection GetAllActivityTypes() { var result = new DBActivityLogTypeCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ActivityLogTypeLoadAll"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { var item = GetActivityLogTypeFromReader(dataReader); result.Add(item); } } return(result); }