public static void buscaListBox(ListBox lst, string busca)
{
lst.Items.Clear();
conexao conexao = new conexao();
try
{
conexao.conectar();
MySqlCommand cmd = new MySqlCommand("SELECT NOME_ALUNO,PRONTUARIO_ALUNO FROM ALUNO WHERE NOME_ALUNO LIKE ? ", conexao.bdConn);
cmd.Parameters.AddWithValue("@NOME_ALUNO", busca + "%");
MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.Default);
string texto;
while (dr.Read())
{
texto = dr[0].ToString();
texto = texto + "\t" + dr[1].ToString();
lst.Items.Add(texto);
}
}
catch (Exception e)
{
MessageBox.Show("Ocorreu o seguinte erro: " + e.Message, "ERRO");
}
finally
{
conexao.desconectar();
}
}
private void btnExcluir_Click(object sender, EventArgs e)
{
DialogResult iResposta = MessageBox.Show("Deseja excluir este aluno?", "Confirma Exclusao", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (iResposta == DialogResult.Yes)
{
try
{
conexao conexao = new conexao();
conexao.conectar();
MySqlCommand cmd = new MySqlCommand("call deletarAluno(?)", conexao.bdConn);
cmd.Parameters.AddWithValue("@id_aluno", txtId.Text);
cmd.ExecuteReader(CommandBehavior.SingleRow);
conexao.desconectar();
carregaListBox(lstAlunos);
inicial();
}
catch (Exception ex)
{
MessageBox.Show("Ocorreu o seguinte erro: " + ex.Message, "ERRO");
}
}
else
{
carregaListBox(lstAlunos);
inicial();
}
}
private void exibeDados(int prontuario, string nome)
{
conexao conexao = new conexao();
conexao.conectar();
MySqlCommand cmd = new MySqlCommand("SELECT * FROM ALUNO WHERE NOME_ALUNO=? AND id_aluno=?", conexao.bdConn);
cmd.Parameters.AddWithValue("@NOME_ALUNO", nome);
cmd.Parameters.AddWithValue("@id_aluno", prontuario);
MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.SingleRow);
if (dr.Read())
{
txtId.Text = Convert.ToString(dr[("ID_ALUNO")]);
txtNome.Text = Convert.ToString(dr[("NOME_ALUNO")]);
txtProntuario.Text = Convert.ToString(dr[("PRONTUARIO_ALUNO")]);
txtCurso.Text = Convert.ToString(dr[("CURSO_ALUNO")]);
txtEmail.Text = Convert.ToString(dr[("EMAIL_ALUNO")]);
txtCelular.Text = Convert.ToString(dr[("CELULAR_ALUNO")]);
txtTelefone.Text = Convert.ToString(dr[("TELEFONE_ALUNO")]);
}
dr.Close();
conexao.desconectar();
}
public void carregaListBox(ListBox lst)
{
lst.Items.Clear();
idAluno = 0;
conexao conexao = new conexao();
try
{
conexao.conectar();
MySqlCommand cmd = new MySqlCommand("SELECT * FROM ALUNO where status_aluno <> 2", conexao.bdConn);
MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.Default);
string texto;
while (dr.Read())
{
texto = dr[0].ToString();
texto = texto + "\t" + dr[1].ToString();
lst.Items.Add(texto);
}
}
catch (Exception e)
{
MessageBox.Show(Convert.ToString(e));
}
finally
{
conexao.desconectar();
}
}
private int nRep()
{
int i = 0;
conexao conexao = new conexao();
conexao.conectar();
MySqlCommand cmd = new MySqlCommand("select count(id_republica) from republica", conexao.bdConn);
MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.Default);
if (dr.Read())
{
i = Convert.ToInt32(dr[0]);
}
conexao.desconectar();
return(i);
}
public static void carregaListBox(ListBox lst)
{
conexao conexao = new conexao();
try
{
conexao.conectar();
MySqlCommand cmd = new MySqlCommand("SELECT NOME_ALUNO FROM ALUNO", conexao.bdConn);
MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.Default);
while (dr.Read())
{
lst.Items.Add(dr["NOME_ALUNO"]);
}
}
catch (Exception e)
{
MessageBox.Show(Convert.ToString(e));
}
finally
{
conexao.desconectar();
}
}
private void btnExcluir_Click(object sender, EventArgs e)
{
DialogResult iResposta = MessageBox.Show("Deseja excluir esta Republica?", "Confirma Exclusao", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (iResposta.ToString() == "Yes")
{
conexao conexao = new conexao();
conexao.conectar();
MySqlCommand cmd = new MySqlCommand("call deletarRepublica(?);", conexao.bdConn);
cmd.Parameters.AddWithValue("@id_republica", txtId.Text);
cmd.ExecuteReader(CommandBehavior.SingleRow);
conexao.desconectar();
carregaListBox(lstRepublica);
inicial();
}
else
{
carregaListBox(lstRepublica);
inicial();
}
}
private void btnAssociar_Click(object sender, EventArgs e)
{
conexao conexao = new conexao();
conexao.conectar();
MySqlCommand cmd;
try
{
cmd = new MySqlCommand("call inseriRelacao(?,?)", conexao.bdConn);
cmd.Parameters.AddWithValue("@aluno_id_aluno", txtAluno.Text);
cmd.Parameters.AddWithValue("@republica_id_republica", txtRepublica.Text);
cmd.ExecuteReader(CommandBehavior.SingleRow);
}
catch (Exception ex)
{
MessageBox.Show("Ocorreu o seguinte erro: " + ex.Message, "ERRO");
}
finally
{
conexao.desconectar();
inicial();
}
}
private void exibeDadosRep(int id)
{
conexao conexao = new conexao();
conexao.conectar();
MySqlCommand cmd = new MySqlCommand("SELECT * FROM REPUBLICA WHERE id_republica=?", conexao.bdConn);
cmd.Parameters.AddWithValue("@id_republica", id);
MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.SingleRow);
if (dr.Read())
{
txtNomeRep.Text = dr["NOME_REPUBLICA"].ToString();
txtAlunoResp.Text = dr["alunoResponsavel_republica"].ToString();
txtCapacidade.Text = dr["CAPACIDADE_REPUBLICA"].ToString();
txtVagas.Text = dr["VAGAS_REPUBLICA"].ToString();
txtTipo.Text = dr["TIPO_REPUBLICA"].ToString();
txtAluguel.Text = dr["preco_republica"].ToString();
txtDescricao.Text = dr["descricao_republica"].ToString();
txtRepublica.Text = dr["id_republica"].ToString();
}
dr.Close();
conexao.desconectar();
}