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