private DBSearchLog GetSearchLogFromReader(IDataReader dataReader) { DBSearchLog searchLog = new DBSearchLog(); searchLog.SearchLogID = NopSqlDataHelper.GetInt(dataReader, "SearchLogID"); searchLog.SearchTerm = NopSqlDataHelper.GetString(dataReader, "SearchTerm"); searchLog.CustomerID = NopSqlDataHelper.GetInt(dataReader, "CustomerID"); searchLog.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn"); return searchLog; }
private DBSearchLog GetSearchLogFromReader(IDataReader dataReader) { var item = new DBSearchLog(); item.SearchLogId = NopSqlDataHelper.GetInt(dataReader, "SearchLogID"); item.SearchTerm = NopSqlDataHelper.GetString(dataReader, "SearchTerm"); item.CustomerId = NopSqlDataHelper.GetInt(dataReader, "CustomerID"); item.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn"); return(item); }
private DBSearchLog GetSearchLogFromReader(IDataReader dataReader) { DBSearchLog searchLog = new DBSearchLog(); searchLog.SearchLogID = NopSqlDataHelper.GetInt(dataReader, "SearchLogID"); searchLog.SearchTerm = NopSqlDataHelper.GetString(dataReader, "SearchTerm"); searchLog.CustomerID = NopSqlDataHelper.GetInt(dataReader, "CustomerID"); searchLog.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn"); return(searchLog); }
private static SearchLog DBMapping(DBSearchLog dbItem) { if (dbItem == null) return null; SearchLog item = new SearchLog(); item.SearchLogID = dbItem.SearchLogID; item.SearchTerm = dbItem.SearchTerm; item.CustomerID = dbItem.CustomerID; item.CreatedOn = dbItem.CreatedOn; return item; }
/// <summary> /// Gets a search log item /// </summary> /// <param name="searchLogId">The search log item identifier</param> /// <returns>Search log item</returns> public override DBSearchLog GetSearchLogById(int searchLogId) { DBSearchLog item = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_SearchLogLoadByPrimaryKey"); db.AddInParameter(dbCommand, "SearchLogID", DbType.Int32, searchLogId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { item = GetSearchLogFromReader(dataReader); } } return(item); }
/// <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); }
/// <summary> /// Inserts a search log item /// </summary> /// <param name="SearchTerm">The search term</param> /// <param name="CustomerID">The customer identifier</param> /// <param name="CreatedOn">The date and time of instance creation</param> /// <returns>Search log item</returns> public override DBSearchLog InsertSearchLog(string SearchTerm, int CustomerID, DateTime CreatedOn) { DBSearchLog searchLog = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_SearchLogInsert"); db.AddOutParameter(dbCommand, "SearchLogID", DbType.Int32, 0); db.AddInParameter(dbCommand, "SearchTerm", DbType.String, SearchTerm); db.AddInParameter(dbCommand, "CustomerID", DbType.Int32, CustomerID); db.AddInParameter(dbCommand, "CreatedOn", DbType.DateTime, CreatedOn); if (db.ExecuteNonQuery(dbCommand) > 0) { int SearchLogID = Convert.ToInt32(db.GetParameterValue(dbCommand, "@SearchLogID")); searchLog = GetSearchLogByID(SearchLogID); } return(searchLog); }