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