public Types.QuestionariosType select(int id_associacao, int id_empresa) { MySqlConnection con = new MySqlConnection(Dados.StringConexao); string SQL = "SELECT * FROM questionario q WHERE id_associacao = @id_associacao"; MySqlCommand cmd = new MySqlCommand(SQL, con); cmd.Parameters.AddWithValue("@id_associacao", id_associacao); con.Open(); MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); Types.QuestionariosType types = new Types.QuestionariosType(); QuestionarioRespostaDAL dalResposta = new QuestionarioRespostaDAL(); while (dr.Read()) { Types.QuestionarioType type = new Types.QuestionarioType(); type.idQuestionario = Int32.Parse(dr["id_questionario"].ToString()); type.IdAssociacao = Int32.Parse(dr["id_associacao"].ToString()); type.Tipo = dr["tipo"].ToString(); type.Descricao = dr["descricao"].ToString(); if (id_empresa > 0) { type.Respostas = dalResposta.select(Convert.ToInt32(id_empresa), type.idQuestionario); } types.Add(type); } return(types); }
public Types.QuestionariosType select(int id_associacao, int id_empresa) { MySqlConnection con = new MySqlConnection(Dados.StringConexao); string SQL = "SELECT * FROM questionario q WHERE id_associacao = @id_associacao"; MySqlCommand cmd = new MySqlCommand(SQL, con); cmd.Parameters.AddWithValue("@id_associacao",id_associacao); con.Open(); MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); Types.QuestionariosType types = new Types.QuestionariosType(); QuestionarioRespostaDAL dalResposta = new QuestionarioRespostaDAL(); while (dr.Read()) { Types.QuestionarioType type = new Types.QuestionarioType(); type.idQuestionario = Int32.Parse(dr["id_questionario"].ToString()); type.IdAssociacao = Int32.Parse(dr["id_associacao"].ToString()); type.Tipo = dr["tipo"].ToString(); type.Descricao = dr["descricao"].ToString(); if (id_empresa > 0) { type.Respostas = dalResposta.select(Convert.ToInt32(id_empresa), type.idQuestionario); } types.Add(type); } return types; }
protected void Page_Load(object sender, EventArgs e) { int id = Convert.ToInt32(Request.QueryString["id"]); try { if ( id > 0) { BLL.EmpresaBLL BLL = new BLL.EmpresaBLL(); DadosEmpresa = BLL.selectRecord(id); if (DadosEmpresa.IdAssociacao != Master.SessionAssociacaoId) throw new Exception("IdAssociacao invalido"); BLL.QuestionarioBLL QuestBLL = new BLL.QuestionarioBLL(); RespostasQuestionario = QuestBLL.select(DadosEmpresa.IdAssociacao, DadosEmpresa.IdEmpresa); } else { throw new Exception("No id"); } } catch (Exception) { Session["FlashMsg"] = "Ocorreu um erro"; Session["FlashMsgType"] = "danger"; Response.Redirect("~/Painel/Empresas.aspx"); } this.DataBind(); }