public bool AddOption(PollOption info)
{
bool result = false;
try
{
result = WritePollOption(ProceduresNames.PollOptionAdd, info, true);
}
catch (Exception error)
{
throw error;
}
return result;
}
protected void btnSubmitAnswer_Click(object sender, EventArgs e)
{
try
{
bool succeeded = false;
PollOption option = new PollOption();
option.TextAr = txtAnswerAr.Text.Trim();
option.TextEn = txtAnswerEn.Text.Trim();
if (updateOption)
{
string[] idInfo = txtAnswerID.Value.Split(',');
if (!string.IsNullOrEmpty(Request.QueryString["ID"]))
{
option.ID = Convert.ToInt32(idInfo[0]);
succeeded = pollOperator.UpdateOption(option);
}
else
{
succeeded = true;
}
if (succeeded)
{
optionsList[Convert.ToInt32(idInfo[1])] = option;
}
updateOption = false;
ViewState["updatePollOption"] = updateOption;
}
else
{
if (!string.IsNullOrEmpty(Request.QueryString["ID"]))
{
option.PollID = Convert.ToInt32(Request.QueryString["ID"]);
succeeded = pollOperator.AddOption(option);
}
else
{
succeeded = true;
}
if (succeeded)
{
optionsList.Add(option);
}
}
Session["PollOptionsList"] = optionsList;
BindGrid();
txtAnswerID.Value = string.Empty;
txtAnswerAr.Text = string.Empty;
txtAnswerEn.Text = string.Empty;
AnswersTable.Style[HtmlTextWriterStyle.Display] = "none";
}
catch
{
Response.Redirect(Utility.AppendQueryString(PagesPathes.ErrorPage, new KeyValue(CommonStrings.BackUrl, CommonStrings.AdminDefault)));
}
}
private bool WritePollOption(string ProcedureName, PollOption info, bool IsNew)
{
bool result = false;
try
{
SqlCommand command = new SqlCommand(ProcedureName, this.Connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue(string.Concat(CommonStrings.AtSymbol, PollOption.TableColumns.TextAr), info.TextAr);
command.Parameters.AddWithValue(string.Concat(CommonStrings.AtSymbol, PollOption.TableColumns.TextEn), info.TextEn);
if (IsNew)
{
command.Parameters.Add(string.Concat(CommonStrings.AtSymbol, PollOption.CommonColumns.ID), SqlDbType.Int);
command.Parameters[string.Concat(CommonStrings.AtSymbol, PollOption.CommonColumns.ID)].Direction = ParameterDirection.Output;
command.Parameters.AddWithValue(string.Concat(CommonStrings.AtSymbol, PollOption.TableColumns.PollID), info.PollID);
}
else
{
command.Parameters.AddWithValue(string.Concat(CommonStrings.AtSymbol, PollOption.CommonColumns.ID), info.ID);
}
this.OpenConnection();
command.ExecuteNonQuery();
if (IsNew)
{
info.ID = Convert.ToInt32(command.Parameters[string.Concat(CommonStrings.AtSymbol, PollOption.CommonColumns.ID)].Value);
}
result = true;
}
catch (Exception error)
{
throw error;
}
finally
{
this.CloseConnection();
}
return result;
}
private void ReadOptionsList(SqlDataReader reader, List<PollOption> infoList, bool? IsArabic)
{
try
{
PollOption option = null;
if (!IsArabic.HasValue)
{
while (reader.Read())
{
option = new PollOption();
option.ID = Convert.ToInt32(reader[PollOption.CommonColumns.ID]);
option.PollID = Convert.ToInt32(reader[PollOption.TableColumns.PollID]);
option.TextAr = Convert.ToString(reader[PollOption.TableColumns.TextAr]);
option.TextEn = Convert.ToString(reader[PollOption.TableColumns.TextEn]);
option.Votes = Convert.ToInt32(reader[PollOption.TableColumns.Votes]);
option.Percentage = Convert.ToDecimal(reader[PollOption.TableColumns.Percentage]);
infoList.Add(option);
}
}
else
{
if (IsArabic.Value)
{
while (reader.Read())
{
option = new PollOption();
option.ID = Convert.ToInt32(reader[PollOption.CommonColumns.ID]);
option.PollID = Convert.ToInt32(reader[PollOption.TableColumns.PollID]);
option.TextAr = Convert.ToString(reader[PollOption.TableColumns.TextAr]);
option.Votes = Convert.ToInt32(reader[PollOption.TableColumns.Votes]);
option.Percentage = Convert.ToDecimal(reader[PollOption.TableColumns.Percentage]);
infoList.Add(option);
}
}
else
{
while (reader.Read())
{
option = new PollOption();
option.ID = Convert.ToInt32(reader[PollOption.CommonColumns.ID]);
option.PollID = Convert.ToInt32(reader[PollOption.TableColumns.PollID]);
option.TextEn = Convert.ToString(reader[PollOption.TableColumns.TextEn]);
option.Votes = Convert.ToInt32(reader[PollOption.TableColumns.Votes]);
option.Percentage = Convert.ToDecimal(reader[PollOption.TableColumns.Percentage]);
infoList.Add(option);
}
}
}
}
catch (Exception error)
{
throw error;
}
}
public bool UpdateOption(PollOption info)
{
bool result = false;
try
{
result = WritePollOption(ProceduresNames.PollOptionUpdate, info, false);
}
catch (Exception error)
{
throw error;
}
return result;
}
