public QuestionarioOpcoesType getOptions(QuestionarioType questionario)
{
QuestionarioOpcaoBLL bll = new QuestionarioOpcaoBLL();
QuestionarioOpcoesType opcoes = bll.select(questionario);
return(opcoes);
}
public QuestionarioOpcoesType getOptions(QuestionarioType questionario)
{
QuestionarioOpcaoBLL bll = new QuestionarioOpcaoBLL();
QuestionarioOpcoesType opcoes = bll.select(questionario);
return opcoes;
}
public void createInput(QuestionarioType questionario)
{
Response.Write("<label for='" + questionario.idQuestionario + "'>" + questionario.Descricao + "</label>");
if (questionario.TipoIsMultiple)
{
Trabalho.Types.QuestionarioOpcoesType ops = getOptions(questionario);
Response.Write("<div class='form-inline'>");
foreach (Trabalho.Types.QuestionarioOpcaoType op in ops)
{
Response.Write("<label for='" + op.idOpcaoQuestionario + "'>" + op.Descricao + "</label>");
Response.Write("<input " +
(questionario.Respostas.hasValue(op.Descricao) ? "checked='checked' " : "") +
"type='" + questionario.TipoFormat + "' " +
"name='" + questionario.idQuestionario + "' " +
"id='" + op.idOpcaoQuestionario + "' " +
"value='" + op.Descricao + "' " +
"/>");
}
Response.Write("</div>");
}
else
{
string resposta = "";
if (questionario.Respostas.ToArray().Length > 0)
{
resposta = questionario.Respostas[0].Valor;
}
Response.Write("<input class='form-control " + questionario.TipoFormat.ToLower() + "' value='" + resposta + "' type='" + questionario.TipoFormat + "' name='" + questionario.idQuestionario + "' id='" + questionario.idQuestionario + "' >");
}
}
public void createInput(QuestionarioType questionario)
{
Response.Write("<label for='" + questionario.idQuestionario + "'>" + questionario.Descricao + "</label>");
if (questionario.TipoIsMultiple)
{
Trabalho.Types.QuestionarioOpcoesType ops = getOptions(questionario);
Response.Write("<div class='form-inline'>");
foreach (Trabalho.Types.QuestionarioOpcaoType op in ops)
{
Response.Write("<label for='" + op.idOpcaoQuestionario + "'>" + op.Descricao + "</label>");
Response.Write("<input "+
(questionario.Respostas.hasValue(op.Descricao) ? "checked='checked' " : "") +
"type='" + questionario.TipoFormat + "' "+
"name='" + questionario.idQuestionario + "' " +
"id='" + op.idOpcaoQuestionario + "' " +
"value='" + op.Descricao + "' " +
"/>");
}
Response.Write("</div>");
}
else
{
string resposta = "";
if (questionario.Respostas.ToArray().Length > 0) {
resposta = questionario.Respostas[0].Valor;
}
Response.Write("<input class='form-control " + questionario.TipoFormat.ToLower() + "' value='" + resposta + "' type='" + questionario.TipoFormat + "' name='" + questionario.idQuestionario + "' id='" + questionario.idQuestionario + "' >");
}
}
private void _insert(QuestionarioType questionario)
{
QuestionarioRespostasType respostas = questionario.Respostas;
foreach (QuestionarioRespostaType resposta in respostas)
{
string SQL = "INSERT INTO resposta_empresa " +
"( " +
"id_questionario, " +
"id_empresa, " +
"resposta " +
") " +
"VALUES " +
"( " +
"@id_questionario, " +
"@id_empresa, " +
"@resposta " +
")";
MySqlCommand cmd = new MySqlCommand(SQL, _con);
cmd.Transaction = _transaction;
cmd.Parameters.AddWithValue("@id_questionario", resposta.idQuestionario);
cmd.Parameters.AddWithValue("@id_empresa", resposta.idEmpresa);
cmd.Parameters.AddWithValue("@resposta", resposta.Valor);
try
{
cmd.ExecuteNonQuery();
}
finally{}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
int id = Convert.ToInt32(Request.QueryString["id"]);
QuestionarioBLL questionarioBLL = new QuestionarioBLL();
QuestionarioType questionario = questionarioBLL.selectRecord(id);
if (questionario.idQuestionario != null && questionario.idQuestionario > 0 && questionario.IdAssociacao == Int32.Parse(Session["AssociacaoID"].ToString()))
{
QuestionarioOpcaoBLL opcaoBLL = new QuestionarioOpcaoBLL();
opcaoBLL.delete(questionario);
questionarioBLL.delete(questionario);
Session["FlashMsg"] = "Apagado com sucesso";
Session["FlashMsgType"] = "success";
}
else
{
throw new Exception("Id invalido");
}
}
catch (Exception ex)
{
Session["FlashMsg"] = "Ocorreu um erro ao apagar";
Session["FlashMsgType"] = "danger";
}
Response.Redirect("~/Painel/Questionario.aspx");
}
public void createSelect(QuestionarioType questionario)
{
Response.Write("<label for='" + questionario.idQuestionario + "'>" + questionario.Descricao + "</label>");
Response.Write("<select class='form-control' name='" + questionario.idQuestionario + "' id='" + questionario.idQuestionario + "' >");
if (questionario.TipoIsMultiple)
{
Trabalho.Types.QuestionarioOpcoesType ops = getOptions(questionario);
foreach (Trabalho.Types.QuestionarioOpcaoType op in ops)
{
Response.Write("<option value='" + op.Descricao + "' " + (questionario.Respostas.hasValue(op.Descricao) ? "selected='selected'" : "") + " >" + op.Descricao + "</options>");
}
}
Response.Write("</select>");
}
public void createSelect(QuestionarioType questionario)
{
Response.Write("<label for='" + questionario.idQuestionario + "'>" + questionario.Descricao + "</label>");
Response.Write("<select class='form-control' name='" + questionario.idQuestionario + "' id='" + questionario.idQuestionario + "' >");
if (questionario.TipoIsMultiple)
{
Trabalho.Types.QuestionarioOpcoesType ops = getOptions(questionario);
foreach (Trabalho.Types.QuestionarioOpcaoType op in ops)
{
Response.Write("<option value='" + op.Descricao + "' "+(questionario.Respostas.hasValue(op.Descricao) ? "selected='selected'" : "") +" >" + op.Descricao + "</options>");
}
}
Response.Write("</select>");
}
public void delete(QuestionarioType questionario)
{
MySqlConnection con = new MySqlConnection(Dados.StringConexao);
string SQL = "DELETE FROM opcao_questionario " +
"WHERE id_questionario = @id";
MySqlCommand cmd = new MySqlCommand(SQL, con);
cmd.Parameters.AddWithValue("@id", questionario.idQuestionario);
try
{
con.Open();
cmd.ExecuteNonQuery();
}
finally
{
con.Close();
}
}
public void delete(QuestionarioType questionario)
{
MySqlConnection con = new MySqlConnection(Dados.StringConexao);
string SQL = "DELETE FROM opcao_questionario " +
"WHERE id_questionario = @id";
MySqlCommand cmd = new MySqlCommand(SQL, con);
cmd.Parameters.AddWithValue("@id", questionario.idQuestionario);
try
{
con.Open();
cmd.ExecuteNonQuery();
}
finally
{
con.Close();
}
}
public bool save(QuestionarioType questionario, int id_empresa)
{
try {
_con.Open();
_transaction = _con.BeginTransaction();
_delete(id_empresa, questionario.idQuestionario);
_insert(questionario);
_transaction.Commit();
}catch (Exception error) {
_transaction.Rollback();
_con.Close();
throw error;
}finally{
_con.Close();
}
return(true);
}
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);
}
public bool save(QuestionarioType questionario, int id_empresa)
{
try {
_con.Open();
_transaction = _con.BeginTransaction();
_delete(id_empresa, questionario.idQuestionario);
_insert(questionario);
_transaction.Commit();
}catch(Exception error){
_transaction.Rollback();
_con.Close();
throw error;
}finally{
_con.Close();
}
return true;
}
private void _insert(QuestionarioType questionario)
{
QuestionarioRespostasType respostas = questionario.Respostas;
foreach (QuestionarioRespostaType resposta in respostas) {
string SQL = "INSERT INTO resposta_empresa " +
"( " +
"id_questionario, " +
"id_empresa, " +
"resposta " +
") " +
"VALUES " +
"( " +
"@id_questionario, " +
"@id_empresa, " +
"@resposta " +
")";
MySqlCommand cmd = new MySqlCommand(SQL, _con);
cmd.Transaction = _transaction;
cmd.Parameters.AddWithValue("@id_questionario", resposta.idQuestionario);
cmd.Parameters.AddWithValue("@id_empresa", resposta.idEmpresa);
cmd.Parameters.AddWithValue("@resposta", resposta.Valor);
try
{
cmd.ExecuteNonQuery();
}
finally{}
}
}
public bool save(QuestionarioType questionario, int idEmpresa)
{
QuestionarioRespostaDAL dal = new QuestionarioRespostaDAL();
return(dal.save(questionario, idEmpresa));
}
public bool save(QuestionarioType questionario, int idEmpresa)
{
QuestionarioRespostaDAL dal = new QuestionarioRespostaDAL();
return dal.save(questionario, idEmpresa);
}
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();
}
