/// <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);
}
/// <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 the specified poll option
/// </summary>
public override bool UpdateOption(PollOptionDetails option)
{
using (SqlConnection cn = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("tbh_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>
/// 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("tbh_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);
}
}
/// <summary>
/// Updates the specified poll option
/// </summary>
public override bool UpdateOption(PollOptionDetails option)
{
using (SqlConnection cn = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("tbh_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>
/// 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("tbh_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;
}
}
