private void updatePacientTool_Click(object sender, EventArgs e)
{
UpdatePacienti updatePacienti = new UpdatePacienti();
Consultatii consultatii = new Consultatii();
//Daca este in baza de date, atunci o sa fie sters
updatePacienti.CNPMP = (string)((DataRowView)mPacientiBindingSource.Current)["CNP"];
updatePacienti.NumeMP = (string)((DataRowView)mPacientiBindingSource.Current)["Nume"];
updatePacienti.PrenumeMP = (string)((DataRowView)mPacientiBindingSource.Current)["Prenume"];
updatePacienti.DataNasteriiMP = Convert.ToDateTime(((DataRowView)mPacientiBindingSource.Current)["DataNasterii"]);
updatePacienti.VarstaMP = (int)((DataRowView)mPacientiBindingSource.Current)["Varsta"];
updatePacienti.AdresaMP = (string)((DataRowView)mPacientiBindingSource.Current)["Adresa"];
updatePacienti.IstoricBoliMP = (string)((DataRowView)mPacientiBindingSource.Current)["IstoricBoli"];
updatePacienti.DataInscrieriiMP = Convert.ToDateTime(((DataRowView)mPacientiBindingSource.Current)["DataInscrierii"]);
if (updatePacienti.ShowDialog() == DialogResult.OK)
{
mPacientiTableAdapter.UpdateQuery(updatePacienti.CNPMP, updatePacienti.NumeMP, updatePacienti.PrenumeMP, updatePacienti.DataNasteriiMP, updatePacienti.VarstaMP, updatePacienti.AdresaMP, updatePacienti.IstoricBoliMP, updatePacienti.DataInscrieriiMP);
consultatiiTableAdapter.UpdateQueryCons(updatePacienti.CNPMP, updatePacienti.NumeMP + " " + updatePacienti.PrenumeMP);
raportStergereTableAdapter.UpdateQueryStergere(updatePacienti.CNPMP, updatePacienti.NumeMP + " " + updatePacienti.PrenumeMP);
mPacientiTableAdapter.Fill(familieMDataSet.MPacienti);
}
else
{
updatePacienti.Hide();
}
}
private void btnStergere_Click(object sender, EventArgs e)
{
Dashboard dashboard = new Dashboard();
Consultatii consultatii = new Consultatii();
//Verific daca este validat CNP
if (txtCNPS.TextLength != 13)
{
txtCNPS.Focus();
errorCNPS.SetError(txtCNPS, "CNP trebuie sa contina 13 numere!");
}
//Verific daca exista CNP in tabela Pacienti, daca exista il sterg si il adaug in tabelul de rapoarte
else if (txtCNPS.TextLength == 13 && mPacientiTableAdapter.DeleteCNP(CNPS) > 0 && raportStergereTableAdapter.SelectCNPS(familieMDataSet.RaportStergere, CNPS) == 0)
{
DialogResult = DialogResult.OK;
raportStergereTableAdapter.Insert(CNPS, NumeComplet, DataCurenta, Motive);
raportStergereTableAdapter.Fill(familieMDataSet.RaportStergere);
}
//Daca acesta nu exista, o sa afisez un mesaj de eroare
else if (txtCNPS.TextLength == 13 && mPacientiTableAdapter.DeleteCNP(CNPS) == 0 && raportStergereTableAdapter.SelectCNPS(familieMDataSet.RaportStergere, CNPS) == 0)
{
DialogResult = DialogResult.Cancel;
MessageBox.Show("Nu exista acest CNP in baza de date");
}
else if (txtCNPS.TextLength == 13 && mPacientiTableAdapter.DeleteCNP(CNPS) == 0 && raportStergereTableAdapter.SelectCNPS(familieMDataSet.RaportStergere, CNPS) > 0)
{
mPacientiTableAdapter.Fill(familieMDataSet.MPacienti);
DialogResult = DialogResult.Cancel;
MessageBox.Show("Acest pacient " + txtCNPS.Text + " a mai fost sters din baza de date, nu-l mai introducem in tabelul Raport");
}
}
private void showToolConsultatii_Click(object sender, EventArgs e)
{
Consultatii consultatii = new Consultatii();
consultatii.CNPC = (string)((DataRowView)mPacientiBindingSource.Current)["CNP"];
consultatii.NumeCompletC = (string)((DataRowView)mPacientiBindingSource.Current)["Nume"] + " " + (string)((DataRowView)mPacientiBindingSource.Current)["Prenume"];
if (consultatii.ShowDialog() == DialogResult.OK)
{
MessageBox.Show("Consultatia a fost adaugata cu succes");
consultatii.Show();
}
}
