/// <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;
}
