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