Exemple #1
0
        private DBPollAnswer GetPollAnswerFromReader(IDataReader dataReader)
        {
            DBPollAnswer pollAnswer = new DBPollAnswer();

            pollAnswer.PollAnswerID = NopSqlDataHelper.GetInt(dataReader, "PollAnswerID");
            pollAnswer.PollID       = NopSqlDataHelper.GetInt(dataReader, "PollID");
            pollAnswer.Name         = NopSqlDataHelper.GetString(dataReader, "Name");
            pollAnswer.Count        = NopSqlDataHelper.GetInt(dataReader, "Count");
            pollAnswer.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
            return(pollAnswer);
        }
Exemple #2
0
        private DBPollAnswer GetPollAnswerFromReader(IDataReader dataReader)
        {
            var item = new DBPollAnswer();

            item.PollAnswerId = NopSqlDataHelper.GetInt(dataReader, "PollAnswerID");
            item.PollId       = NopSqlDataHelper.GetInt(dataReader, "PollID");
            item.Name         = NopSqlDataHelper.GetString(dataReader, "Name");
            item.Count        = NopSqlDataHelper.GetInt(dataReader, "Count");
            item.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
            return(item);
        }
Exemple #3
0
        /// <summary>
        /// Updates the poll answer
        /// </summary>
        /// <param name="PollAnswerID">The poll answer identifier</param>
        /// <param name="PollID">The poll identifier</param>
        /// <param name="Name">The poll answer name</param>
        /// <param name="Count">The current count</param>
        /// <param name="DisplayOrder">The display order</param>
        /// <returns>Poll answer</returns>
        public override DBPollAnswer UpdatePollAnswer(int PollAnswerID, int PollID, string Name, int Count, int DisplayOrder)
        {
            DBPollAnswer pollAnswer = null;
            Database     db         = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
            DbCommand    dbCommand  = db.GetStoredProcCommand("Nop_PollAnswerUpdate");

            db.AddInParameter(dbCommand, "PollAnswerID", DbType.Int32, PollAnswerID);
            db.AddInParameter(dbCommand, "PollID", DbType.Int32, PollID);
            db.AddInParameter(dbCommand, "Name", DbType.String, Name);
            db.AddInParameter(dbCommand, "Count", DbType.Int32, Count);
            db.AddInParameter(dbCommand, "DisplayOrder", DbType.Int32, DisplayOrder);
            if (db.ExecuteNonQuery(dbCommand) > 0)
            {
                pollAnswer = GetPollAnswerByID(PollAnswerID);
            }

            return(pollAnswer);
        }
Exemple #4
0
        /// <summary>
        /// Gets a poll answers by poll identifier
        /// </summary>
        /// <param name="PollID">Poll identifier</param>
        /// <returns>Poll answer collection</returns>
        public override DBPollAnswerCollection GetPollAnswersByPollID(int PollID)
        {
            DBPollAnswerCollection pollAnswerCollection = new DBPollAnswerCollection();
            Database  db        = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
            DbCommand dbCommand = db.GetStoredProcCommand("Nop_PollAnswerLoadByPollID");

            db.AddInParameter(dbCommand, "PollID", DbType.Int32, PollID);
            using (IDataReader dataReader = db.ExecuteReader(dbCommand))
            {
                while (dataReader.Read())
                {
                    DBPollAnswer pollAnswer = GetPollAnswerFromReader(dataReader);
                    pollAnswerCollection.Add(pollAnswer);
                }
            }

            return(pollAnswerCollection);
        }
Exemple #5
0
        /// <summary>
        /// Updates the poll answer
        /// </summary>
        /// <param name="pollAnswerId">The poll answer identifier</param>
        /// <param name="pollId">The poll identifier</param>
        /// <param name="name">The poll answer name</param>
        /// <param name="count">The current count</param>
        /// <param name="displayOrder">The display order</param>
        /// <returns>Poll answer</returns>
        public override DBPollAnswer UpdatePollAnswer(int pollAnswerId,
                                                      int pollId, string name, int count, int displayOrder)
        {
            DBPollAnswer item      = null;
            Database     db        = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
            DbCommand    dbCommand = db.GetStoredProcCommand("Nop_PollAnswerUpdate");

            db.AddInParameter(dbCommand, "PollAnswerID", DbType.Int32, pollAnswerId);
            db.AddInParameter(dbCommand, "PollID", DbType.Int32, pollId);
            db.AddInParameter(dbCommand, "Name", DbType.String, name);
            db.AddInParameter(dbCommand, "Count", DbType.Int32, count);
            db.AddInParameter(dbCommand, "DisplayOrder", DbType.Int32, displayOrder);
            if (db.ExecuteNonQuery(dbCommand) > 0)
            {
                item = GetPollAnswerById(pollAnswerId);
            }

            return(item);
        }
Exemple #6
0
        /// <summary>
        /// Gets a poll answer
        /// </summary>
        /// <param name="PollAnswerID">Poll answer identifier</param>
        /// <returns>Poll answer</returns>
        public override DBPollAnswer GetPollAnswerByID(int PollAnswerID)
        {
            DBPollAnswer pollAnswer = null;

            if (PollAnswerID == 0)
            {
                return(pollAnswer);
            }
            Database  db        = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
            DbCommand dbCommand = db.GetStoredProcCommand("Nop_PollAnswerLoadByPrimaryKey");

            db.AddInParameter(dbCommand, "PollAnswerID", DbType.Int32, PollAnswerID);
            using (IDataReader dataReader = db.ExecuteReader(dbCommand))
            {
                if (dataReader.Read())
                {
                    pollAnswer = GetPollAnswerFromReader(dataReader);
                }
            }
            return(pollAnswer);
        }