private void btnRegistraMedico_Click(object sender, EventArgs e) { if (txtBoxUsuario.Text != String.Empty) { string user_delete = ConexaoDB.putAspas(txtBoxUsuario.Text); string SQLCommand = "DELETE FROM `controle_de_obitos`.`user_data` WHERE (`User_Name` = " + user_delete + ");"; ComandBD.ComandDeleteToBD(SQLCommand); txtBoxUsuario.Text = String.Empty; } }
private void btnExcluirDO_Click(object sender, EventArgs e) { if (txtNumeroDaDO.Text != String.Empty) { string do_delete = ConexaoDB.putAspas(txtNumeroDaDO.Text); string SQLCommand = "DELETE FROM `controle_de_obitos`.`declaracao_de_obitos` WHERE (`Numero_da_DO` = " + do_delete + ");"; ComandBD.ComandDeleteToBD(SQLCommand); txtNumeroDaDO.Text = String.Empty; } }
private void btnRegistraMedico_Click(object sender, EventArgs e) { if (txtBoxNomeDoPaciente.Text != String.Empty && txtBoxNumeroDaDO.Text != String.Empty) { string nome_delete = ConexaoDB.putAspas(txtBoxNomeDoPaciente.Text); string do_delete = ConexaoDB.putAspas(txtBoxNumeroDaDO.Text); string SQLCommand = "DELETE FROM `controle_de_obitos`.`obitos` WHERE (`Nome_Do_Paciente` = " + nome_delete + " && `DO_Number` = " + do_delete + " );"; ComandBD.ComandDeleteToBD(SQLCommand); txtBoxNomeDoPaciente.Text = String.Empty; txtBoxNumeroDaDO.Text = String.Empty; } else { MessageBox.Show("Preencha os dois campos!"); } }