public QuestionarioOpcoesType getOptions(QuestionarioType questionario) { QuestionarioOpcaoBLL bll = new QuestionarioOpcaoBLL(); QuestionarioOpcoesType opcoes = bll.select(questionario); return(opcoes); }
protected void Page_Load(object sender, EventArgs e) { this.url_list = "~/Painel/Questionario.aspx"; this.questionarioBLL = new QuestionarioBLL(); this.OpcoesQuestionario = new QuestionarioOpcoesType(); int id = Convert.ToInt32(Request.QueryString["id"]); if (id != null && id > 0) { this.questionario = this.questionarioBLL.selectRecord(id); if (questionario.idQuestionario != null && questionario.idQuestionario > 0) { if (!IsPostBack) { txtPergunta.Text = questionario.Descricao; cmb_tipo.SelectedValue = questionario.Tipo; } string[] exploded = questionario.Tipo.Split('_'); if (exploded[1] == "S") { QuestionarioOpcaoBLL bllOpcoes = new QuestionarioOpcaoBLL(); this.OpcoesQuestionario = bllOpcoes.select(questionario); } } else { Session["FlashMsg"] = "Id invalido"; Session["FlashMsgType"] = "danger"; Response.Redirect(this.url_list); } } else { this.questionario = new QuestionarioType(); } this.DataBind(); }
public QuestionarioOpcoesType select(QuestionarioType questionario) { MySqlConnection con = new MySqlConnection(Dados.StringConexao); string SQL = "SELECT * FROM opcao_questionario " + "WHERE id_questionario = @id"; MySqlCommand cmd = new MySqlCommand(SQL, con); cmd.Parameters.AddWithValue("@id", questionario.idQuestionario); con.Open(); MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); QuestionarioOpcoesType types = new QuestionarioOpcoesType(); while (dr.Read()) { QuestionarioOpcaoType type = new QuestionarioOpcaoType(); type.idOpcaoQuestionario = Int32.Parse(dr["id_opcao_questionario"].ToString()); type.IdQuestionario = Int32.Parse(dr["id_questionario"].ToString()); type.Descricao = dr["descricao"].ToString(); types.Add(type); } return types; }
public QuestionarioOpcoesType select(QuestionarioType questionario) { MySqlConnection con = new MySqlConnection(Dados.StringConexao); string SQL = "SELECT * FROM opcao_questionario " + "WHERE id_questionario = @id"; MySqlCommand cmd = new MySqlCommand(SQL, con); cmd.Parameters.AddWithValue("@id", questionario.idQuestionario); con.Open(); MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); QuestionarioOpcoesType types = new QuestionarioOpcoesType(); while (dr.Read()) { QuestionarioOpcaoType type = new QuestionarioOpcaoType(); type.idOpcaoQuestionario = Int32.Parse(dr["id_opcao_questionario"].ToString()); type.IdQuestionario = Int32.Parse(dr["id_questionario"].ToString()); type.Descricao = dr["descricao"].ToString(); types.Add(type); } return(types); }