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); }
protected void btnSalvar_Click(object sender, EventArgs e) { this.questionario.Descricao = txtPergunta.Text; this.questionario.Tipo = cmb_tipo.SelectedValue; this.questionario.IdAssociacao = Int32.Parse(Session["AssociacaoID"].ToString()); try { string msg; if (this.questionario.idQuestionario != null && this.questionario.idQuestionario > 0) { questionarioBLL.update(this.questionario); msg = "Alterado com sucesso"; } else { this.questionario.idQuestionario = questionarioBLL.insert(this.questionario); msg = "Adicionado com sucesso"; } if (this.questionario.idQuestionario != null && this.questionario.idQuestionario > 0) { string formOptions = Request.Form["options[]"]; if (formOptions != null) { string[] opcoes = formOptions.Split(','); if (opcoes.Length > 0) { QuestionarioOpcaoBLL optBLL = new QuestionarioOpcaoBLL(); optBLL.delete(this.questionario); foreach (string opt in opcoes) { QuestionarioOpcaoType optType = new QuestionarioOpcaoType(); optType.IdQuestionario = this.questionario.idQuestionario; optType.Descricao = opt; optBLL.insert(optType); } } } Session["FlashMsg"] = msg; Session["FlashMsgType"] = "success"; } else { throw new Exception("Ocorreu um erro"); } } catch (Exception ex) { //Session["FlashMsg"] = ex.Message; Session["FlashMsg"] = "Ocorreu um erro"; Session["FlashMsgType"] = "danger"; } finally { } Response.Redirect(this.url_list); }
protected void btnSalvar_Click(object sender, EventArgs e) { this.questionario.Descricao = txtPergunta.Text; this.questionario.Tipo = cmb_tipo.SelectedValue; this.questionario.IdAssociacao = Int32.Parse(Session["AssociacaoID"].ToString()); try { string msg; if (this.questionario.idQuestionario != null && this.questionario.idQuestionario > 0) { questionarioBLL.update(this.questionario); msg = "Alterado com sucesso"; } else { this.questionario.idQuestionario = questionarioBLL.insert(this.questionario); msg = "Adicionado com sucesso"; } if (this.questionario.idQuestionario != null && this.questionario.idQuestionario > 0) { string formOptions = Request.Form["options[]"]; if (formOptions != null) { string[] opcoes = formOptions.Split(','); if (opcoes.Length > 0) { QuestionarioOpcaoBLL optBLL = new QuestionarioOpcaoBLL(); optBLL.delete(this.questionario); foreach (string opt in opcoes) { QuestionarioOpcaoType optType = new QuestionarioOpcaoType(); optType.IdQuestionario = this.questionario.idQuestionario; optType.Descricao = opt; optBLL.insert(optType); } } } Session["FlashMsg"] = msg; Session["FlashMsgType"] = "success"; } else { throw new Exception("Ocorreu um erro"); } } catch (Exception ex) { //Session["FlashMsg"] = ex.Message; Session["FlashMsg"] = "Ocorreu um erro"; Session["FlashMsgType"] = "danger"; } finally { } Response.Redirect(this.url_list); }