private DBPoll GetPollFromReader(IDataReader dataReader) { var item = new DBPoll(); item.PollId = NopSqlDataHelper.GetInt(dataReader, "PollID"); item.LanguageId = NopSqlDataHelper.GetInt(dataReader, "LanguageID"); item.Name = NopSqlDataHelper.GetString(dataReader, "Name"); item.SystemKeyword = NopSqlDataHelper.GetString(dataReader, "SystemKeyword"); item.Published = NopSqlDataHelper.GetBoolean(dataReader, "Published"); item.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder"); return(item); }
private DBPoll GetPollFromReader(IDataReader dataReader) { DBPoll poll = new DBPoll(); poll.PollID = NopSqlDataHelper.GetInt(dataReader, "PollID"); poll.LanguageID = NopSqlDataHelper.GetInt(dataReader, "LanguageID"); poll.Name = NopSqlDataHelper.GetString(dataReader, "Name"); poll.SystemKeyword = NopSqlDataHelper.GetString(dataReader, "SystemKeyword"); poll.Published = NopSqlDataHelper.GetBoolean(dataReader, "Published"); poll.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder"); return(poll); }
/// <summary> /// Gets a poll /// </summary> /// <param name="SystemKeyword">Poll system keyword</param> /// <returns>Poll</returns> public override DBPoll GetPollBySystemKeyword(string SystemKeyword) { DBPoll poll = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_PollLoadBySystemKeyword"); db.AddInParameter(dbCommand, "SystemKeyword", DbType.String, SystemKeyword); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { poll = GetPollFromReader(dataReader); } } return(poll); }
/// <summary> /// Updates the poll /// </summary> /// <param name="PollID">The poll identifier</param> /// <param name="LanguageID">The language identifier</param> /// <param name="Name">The name</param> /// <param name="SystemKeyword">The system keyword</param> /// <param name="Published">A value indicating whether the entity is published</param> /// <param name="DisplayOrder">The display order</param> /// <returns>Poll</returns> public override DBPoll UpdatePoll(int PollID, int LanguageID, string Name, string SystemKeyword, bool Published, int DisplayOrder) { DBPoll poll = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_PollUpdate"); db.AddInParameter(dbCommand, "PollID", DbType.Int32, PollID); db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, LanguageID); db.AddInParameter(dbCommand, "Name", DbType.String, Name); db.AddInParameter(dbCommand, "SystemKeyword", DbType.String, SystemKeyword); db.AddInParameter(dbCommand, "Published", DbType.Boolean, Published); db.AddInParameter(dbCommand, "DisplayOrder", DbType.Int32, DisplayOrder); if (db.ExecuteNonQuery(dbCommand) > 0) { poll = GetPollByID(PollID); } return(poll); }
/// <summary> /// Gets poll collection /// </summary> /// <param name="LanguageID">Language identifier. 0 if you want to get all news</param> /// <param name="PollCount">Poll count to load. 0 if you want to get all polls</param> /// <param name="showHidden">A value indicating whether to show hidden records</param> /// <returns>Poll collection</returns> public override DBPollCollection GetPolls(int LanguageID, int PollCount, bool showHidden) { DBPollCollection pollCollection = new DBPollCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_PollLoadAll"); db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, LanguageID); db.AddInParameter(dbCommand, "PollCount", DbType.Int32, PollCount); db.AddInParameter(dbCommand, "ShowHidden", DbType.Boolean, showHidden); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBPoll poll = GetPollFromReader(dataReader); pollCollection.Add(poll); } } return(pollCollection); }
/// <summary> /// Updates the poll /// </summary> /// <param name="pollId">The poll identifier</param> /// <param name="languageId">The language identifier</param> /// <param name="name">The name</param> /// <param name="systemKeyword">The system keyword</param> /// <param name="published">A value indicating whether the entity is published</param> /// <param name="displayOrder">The display order</param> /// <returns>Poll</returns> public override DBPoll UpdatePoll(int pollId, int languageId, string name, string systemKeyword, bool published, int displayOrder) { DBPoll item = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_PollUpdate"); db.AddInParameter(dbCommand, "PollID", DbType.Int32, pollId); db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, languageId); db.AddInParameter(dbCommand, "Name", DbType.String, name); db.AddInParameter(dbCommand, "SystemKeyword", DbType.String, systemKeyword); db.AddInParameter(dbCommand, "Published", DbType.Boolean, published); db.AddInParameter(dbCommand, "DisplayOrder", DbType.Int32, displayOrder); if (db.ExecuteNonQuery(dbCommand) > 0) { item = GetPollById(pollId); } return(item); }
/// <summary> /// Gets a poll /// </summary> /// <param name="PollID">The poll identifier</param> /// <returns>Poll</returns> public override DBPoll GetPollByID(int PollID) { DBPoll poll = null; if (PollID == 0) { return(poll); } Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_PollLoadByPrimaryKey"); db.AddInParameter(dbCommand, "PollID", DbType.Int32, PollID); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { poll = GetPollFromReader(dataReader); } } return(poll); }