private void BtnAltAluno_Click_1(object sender, EventArgs e) { var matsel = this.dtGrdMat.CurrentRow.Cells[0].Value.ToString(); formAluno formAlunoAlt = new formAluno(); StringBuilder cQuery = new StringBuilder(); cQuery.Append("SELECT *, Convert(datetime,datamat) AS DATAMAT, Case WHEN tipoplano = '1' THEN '1 - Mensal' Else '2 - Anual' END AS PLANO FROM aluno WHERE idAluno = '" + matsel + "' "); Database.engineDb conn1 = new Database.engineDb(); DataSet ds = conn1.RetornaDataSet(cQuery.ToString()); formAlunoAlt.mskID.Text = ds.Tables[0].Rows[0].ItemArray[0].ToString(); formAlunoAlt.txtNome.Text = ds.Tables[0].Rows[0].ItemArray[1].ToString(); formAlunoAlt.txtCPF.Text = ds.Tables[0].Rows[0].ItemArray[2].ToString(); formAlunoAlt.txtRG.Text = ds.Tables[0].Rows[0].ItemArray[3].ToString(); formAlunoAlt.cmbUF.Text = ds.Tables[0].Rows[0].ItemArray[4].ToString(); formAlunoAlt.txtCidade.Text = ds.Tables[0].Rows[0].ItemArray[5].ToString(); formAlunoAlt.txtCEP.Text = ds.Tables[0].Rows[0].ItemArray[6].ToString(); formAlunoAlt.txtBairro.Text = ds.Tables[0].Rows[0].ItemArray[7].ToString(); formAlunoAlt.txtEndereco.Text = ds.Tables[0].Rows[0].ItemArray[8].ToString(); formAlunoAlt.dtMatricula.Text = ds.Tables[0].Rows[0].ItemArray[12].ToString(); formAlunoAlt.txtPlano.Text = ds.Tables[0].Rows[0].ItemArray[13].ToString(); formAlunoAlt.dtMatricula.Enabled = false; formAlunoAlt.txtPlano.Enabled = false; formAlunoAlt.ShowDialog(); }
private void BtnExcAluno_Click(object sender, EventArgs e) { var matsel = this.dtGrdMat.CurrentRow.Cells[0].Value.ToString(); StringBuilder cQuery = new StringBuilder(); cQuery.Append("SELECT MAX(situacao) FROM pagamento WHERE idAluno = '" + matsel + "' "); Database.engineDb conn1 = new Database.engineDb(); DataSet ds = conn1.RetornaDataSet(cQuery.ToString()); var verifpgto = ds.Tables[0].Rows[0].ItemArray[0].ToString(); if (Convert.ToInt32(verifpgto) == 1) { StringBuilder cQuery1 = new StringBuilder(); cQuery1.Append("DELETE FROM pagamento WHERE idAluno = '" + matsel + "' " + "DELETE FROM aluno WHERE idAluno = '" + matsel + "'" + "DELETE FROM ferias WHERE idAluno = '" + matsel + "'"); Database.engineDb conn2 = new Database.engineDb(); DataSet ds1 = conn1.RetornaDataSet(cQuery1.ToString()); MessageBox.Show("Aluno excluído com sucesso!"); } else { MessageBox.Show("Não será possível excluir o aluno pois possui título baixado!"); } }
public void BtnGrv_Click(object sender, EventArgs e) { DateTime dataatual = Convert.ToDateTime(dtMatricula.Text); string competencia = dataatual.Year.ToString() + dataatual.Month.ToString(); if (inserir) { string cPlano = this.txtPlano.SelectedItem.ToString().Substring(0, 1); StringBuilder cQuery = new StringBuilder(); cQuery.Append("INSERT INTO [dbo].[aluno] ([idAluno],[nome],[cpf],[rg],[uf],[cidade],[cep],[bairro],[endereco],[tipoplano],[datamat],[biometria])" + "VALUES ('" + Convert.ToInt32(mskID.Text) + "', '" + txtNome.Text + "', '" + txtCPF.Text + "', '" + txtRG.Text + "', '" + cmbUF.Text + "', '" + txtCidade.Text + "', '" + txtCEP.Text + "', '" + txtBairro.Text + "','" + txtEndereco.Text + "','" + cPlano + "', '" + Convert.ToDateTime(dtMatricula.Text) + "','')" + "INSERT INTO[dbo].[pagamento]([idCompetencia],[vencimento],[pagamento],[situacao],[idAluno])" + "VALUES('" + competencia + "','" + Convert.ToDateTime(dtMatricula.Text) + "','','1','" + Convert.ToInt32(mskID.Text) + "')"); //+txtEndereco.Text + "', '" + txtPlano.Items + "', '" + Convert.ToDateTime(dtMatricula.Text) + "','')"); Database.engineDb conn1 = new Database.engineDb(); DataSet ds = conn1.RetornaDataSet(cQuery.ToString()); MessageBox.Show("Aluno matriculado com sucesso!"); this.txtNome.Clear(); this.txtCPF.Clear(); this.txtRG.Clear(); this.txtCidade.Clear(); this.txtCEP.Clear(); this.txtBairro.Clear(); this.txtEndereco.Clear(); this.Close(); } else { StringBuilder cQuery = new StringBuilder(); cQuery.Append(" UPDATE aluno SET nome = '" + txtNome.Text + "', cpf = '" + txtCPF.Text + "', rg = '" + txtRG.Text + "', uf = '" + cmbUF.Text + "', cidade = '" + txtCidade.Text + "', cep = '" + txtCEP.Text + "', bairro = '" + txtBairro.Text + "', endereco ='" + txtEndereco.Text + "' FROM aluno WHERE idAluno =" + Convert.ToInt32(mskID.Text)); Database.engineDb conn = new Database.engineDb(); DataSet ds1 = conn.RetornaDataSet(cQuery.ToString()); MessageBox.Show("Aluno alterado com sucesso!"); this.txtNome.Clear(); this.txtCPF.Clear(); this.txtRG.Clear(); this.txtCidade.Clear(); this.txtCEP.Clear(); this.txtBairro.Clear(); this.txtEndereco.Clear(); this.Close(); gerAluno.ActiveForm.Refresh(); } }
private void BtnIncAluno_Click(object sender, EventArgs e) { formAluno formAlunoInc = new formAluno(); StringBuilder cQuery = new StringBuilder(); cQuery.Append("SELECT MAX(idAluno) + 1 as ID FROM aluno"); Database.engineDb conn1 = new Database.engineDb(); DataSet ds = conn1.RetornaDataSet(cQuery.ToString()); formAlunoInc.mskID.Text = ds.Tables[0].Rows[0].ItemArray[0].ToString(); formAlunoInc.txtNome.Clear(); formAlunoInc.txtCPF.Clear(); formAlunoInc.txtRG.Clear(); //formAlunoInc.cmbUF.Items(); formAlunoInc.txtCidade.Clear(); formAlunoInc.txtCEP.Clear(); formAlunoInc.txtBairro.Clear(); formAlunoInc.txtEndereco.Clear(); //formAlunoInc.dtMatricula //formAlunoInc.txtPlano.Clear(); formAlunoInc.inserir = true; formAlunoInc.ShowDialog(); }
private void BtnPgto_Click(object sender, EventArgs e) { var matsel = this.dtGrdMat.CurrentRow.Cells[0].Value.ToString(); formManutPgto formManutPgto = new formManutPgto(); StringBuilder cQuery = new StringBuilder(); cQuery.Append("SELECT aluno.idAluno,aluno.nome,pagamento.idCompetencia, pagamento.vencimento, pagamento.pagamento, " + "Case WHEN aluno.tipoplano = '1' THEN '1 - Mensal' Else '2 - Anual' END AS PLANO," + "Case WHEN pagamento.situacao = '1' THEN 'Regular'" + " WHEN DATEDIFF(DAY, CONVERT(DATE, pagamento.vencimento), pagamento.pagamento) < 0 AND pagamento.situacao = '1' THEN 'Vencido' " + " WHEN pagamento.situacao = '1' THEN 'Pago' END AS Situação " + "FROM pagamento INNER JOIN aluno on " + "pagamento.idAluno = aluno.idAluno " + "WHERE pagamento.idAluno ='" + matsel + "'"); Database.engineDb conn1 = new Database.engineDb(); DataSet ds = conn1.RetornaDataSet(cQuery.ToString()); formManutPgto.popularGrid(cQuery.ToString()); formManutPgto.txtMat.Text = ds.Tables[0].Rows[0].ItemArray[0].ToString(); formManutPgto.txtNomeAluno.Text = ds.Tables[0].Rows[0].ItemArray[1].ToString(); formManutPgto.txtPlano.Text = ds.Tables[0].Rows[0].ItemArray[5].ToString(); formManutPgto.ShowDialog(); }