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