/// <summary> /// Gets all search log items /// </summary> /// <returns>Search log collection</returns> public static SearchLogCollection GetAllSearchLogs() { DBSearchLogCollection dbCollection = DBProviderManager <DBSearchLogProvider> .Provider.GetAllSearchLogs(); SearchLogCollection collection = DBMapping(dbCollection); return(collection); }
private static SearchLogCollection DBMapping(DBSearchLogCollection dbCollection) { if (dbCollection == null) return null; SearchLogCollection collection = new SearchLogCollection(); foreach (DBSearchLog dbItem in dbCollection) { SearchLog item = DBMapping(dbItem); collection.Add(item); } return collection; }
private static SearchLogCollection DBMapping(DBSearchLogCollection dbCollection) { if (dbCollection == null) { return(null); } SearchLogCollection collection = new SearchLogCollection(); foreach (DBSearchLog dbItem in dbCollection) { SearchLog item = DBMapping(dbItem); collection.Add(item); } return(collection); }
/// <summary> /// Gets all search log items /// </summary> /// <returns>Search log collection</returns> public override DBSearchLogCollection GetAllSearchLogs() { var result = new DBSearchLogCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_SearchLogLoadAll"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { var item = GetSearchLogFromReader(dataReader); result.Add(item); } } return(result); }
/// <summary> /// Gets all search log items /// </summary> /// <returns>Search log collection</returns> public override DBSearchLogCollection GetAllSearchLogs() { DBSearchLogCollection searchLogCollection = new DBSearchLogCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_SearchLogLoadAll"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBSearchLog searchLog = GetSearchLogFromReader(dataReader); searchLogCollection.Add(searchLog); } } return searchLogCollection; }