/// <summary> /// Updates the specified poll option /// </summary> public override bool UpdateOption(PollOptionDetails option) { using (SqlConnection cn = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("wa_Polls_UpdateOption", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@OptionID", SqlDbType.Int).Value = option.ID; cmd.Parameters.Add("@OptionText", SqlDbType.NVarChar).Value = option.OptionText; cn.Open(); int ret = ExecuteNonQuery(cmd); return (ret == 1); } }
/// <summary> /// Returns a new PollOptionDetails instance filled with the DataReader's current record data /// </summary> protected virtual PollOptionDetails GetOptionFromReader(IDataReader reader) { PollOptionDetails option = new PollOptionDetails( (int)reader["OptionID"], (DateTime)reader["AddedDate"], reader["AddedBy"].ToString(), (int)reader["PollID"], reader["OptionText"].ToString(), (int)reader["Votes"], Convert.ToDouble(reader["Percentage"])); return option; }
/// <summary> /// Inserts a new poll option and returns its ID /// </summary> public override int InsertOption(PollOptionDetails option) { using (SqlConnection cn = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("wa_Polls_InsertOption", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = option.AddedDate; cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = option.AddedBy; cmd.Parameters.Add("@PollID", SqlDbType.Int).Value = option.PollID; cmd.Parameters.Add("@OptionText", SqlDbType.NVarChar).Value = option.OptionText; cmd.Parameters.Add("@OptionID", SqlDbType.Int).Direction = ParameterDirection.Output; cn.Open(); int ret = ExecuteNonQuery(cmd); return (int)cmd.Parameters["@OptionID"].Value; } }
public abstract bool UpdateOption(PollOptionDetails option);
public abstract int InsertOption(PollOptionDetails option);
/// <summary> /// Returns a Option object filled with the data taken from the input PollOptionDetails /// </summary> private static Option GetOptionFromPollOptionDetails(PollOptionDetails record) { if (record == null) return null; else { return new Option(record.ID, record.AddedDate, record.AddedBy, record.PollID, record.OptionText, record.Votes, record.Percentage); } }
/// <summary> /// Updates an existing option /// </summary> public static bool UpdateOption(int id, string optionText) { PollOptionDetails record = new PollOptionDetails(id, DateTime.Now, "", 0, optionText, 0, 0.0); bool ret = SiteProvider.Polls.UpdateOption(record); BizObject.PurgeCacheItems("polls_option"); return ret; }
/// <summary> /// Creates a new poll option /// </summary> public static int InsertOption(int pollID, string optionText) { PollOptionDetails record = new PollOptionDetails(0, DateTime.Now, BizObject.CurrentUserName, pollID, optionText, 0, 0.0); int ret = SiteProvider.Polls.InsertOption(record); BizObject.PurgeCacheItems("polls_poll_" + pollID.ToString()); BizObject.PurgeCacheItems("polls_option"); return ret; }