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