private void adaugarePacient_Click(object sender, EventArgs e)
{
try
{
using (BDISPatients db = new BDISPatients())
{
Patients patient = new Patients();
patient.Nume = addTxtNume.Text;
patient.Prenume = addTxtPrenume.Text;
patient.CNP = long.Parse(addTxtCNP.Text);
patient.Adresa = addTxtAdresa.Text;
patient.Data_nasterii = addDateTime.Value;
patient.Varsta = byte.Parse(addTxtAge.Text);
patient.Email = addTxtEmail.Text;
patient.UID = Guid.NewGuid();
db.Patients.Add(patient);
if (db.SaveChanges() > 0)
{
MetroFramework.MetroMessageBox.Show(this, "Pacientul a fost adaugat cu succes.", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (Exception ex)
{
MetroFramework.MetroMessageBox.Show(this, ex.Message, "Pacientul nu a putut fi adaugat in baza de date.", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSearchPatient_Click(object sender, EventArgs e)
{
using (BDISPatients db = new BDISPatients())
{
var CNP = long.Parse(searchPacient.Text);
var data = from patient in db.Patients
where patient.CNP == CNP
select patient;
var user_UID = "";
foreach (var item in data)
{
user_UID = item.UID.ToString();
}
populateReport(user_UID);
if (data.Count() != 0)
{
this.patientSearchGrid.Visible = true;
this.reportViewer.Visible = true;
patientSearchGrid.DataSource = data.ToList();
}
else
{
MetroFramework.MetroMessageBox.Show(this, "Pacientul nu este in baza de date", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void updateButton_Click(object sender, EventArgs e)
{
using (BDISPatients db = new BDISPatients())
{
var CNP = long.Parse(searchPacient.Text);
var originalUser = db.Patients.FirstOrDefault(item => item.CNP == CNP);
var updatedUser = originalUser;
if (originalUser != null)
{
updatedUser.Nume = modTxtNume.Text;
updatedUser.Prenume = modTxtPrenume.Text;
updatedUser.Email = modTxtEmail.Text;
updatedUser.Adresa = modTxtAdresa.Text;
updatedUser.Data_nasterii = modDateTime.Value;
updatedUser.Varsta = byte.Parse(modTxtAge.Text);
db.Entry(originalUser).CurrentValues.SetValues(updatedUser);
if (db.SaveChanges() > 0)
{
MetroFramework.MetroMessageBox.Show(this, "Datele pacientului au fost actualizate cu succes.", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MetroFramework.MetroMessageBox.Show(this, "Datele pacientului nu au fost actualizate.", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
private void btnSearchPatient_Click(object sender, EventArgs e)
{
using (BDISPatients db = new BDISPatients())
{
var CNP = long.Parse(searchPacient.Text);
var data = from patient in db.Patients
where patient.CNP == CNP
select patient;
if (data.Count() != 0)
{
foreach (var item in data)
{
modTxtNume.Text = item.Nume;
modTxtPrenume.Text = item.Prenume;
modTxtEmail.Text = item.Email;
modTxtAdresa.Text = item.Adresa;
modDateTime.Value = item.Data_nasterii;
modTxtAge.Text = item.Varsta.ToString();
patientUID = item.UID;
}
}
else
{
MetroFramework.MetroMessageBox.Show(this, "Pacientul nu este in baza de date", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void btnCautarePacient_Click(object sender, EventArgs e)
{
using (BDISPatients db = new BDISPatients())
{
var CNP = long.Parse(patientSearchBox.Text);
var data = from patient in db.Patients
where patient.CNP == CNP
select patient;
if (data.Count() != 0)
{
this.patientSearchGrid.Visible = true;
patientSearchGrid.DataSource = data.ToList();
}
else
{
MetroFramework.MetroMessageBox.Show(this, "Pacientul nu este in baza de date", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void btnDeletePatient_Click(object sender, EventArgs e)
{
var CNP = long.Parse(patientSearchBox.Text);
using (BDISPatients db = new BDISPatients())
{
var patientToRemove = db.Patients.SingleOrDefault(x => x.CNP == CNP);
user_UID = patientToRemove.UID.ToString();
if (patientToRemove != null)
{
db.Patients.Remove(patientToRemove);
db.SaveChanges();
patientSearchGrid.Hide();
MetroFramework.MetroMessageBox.Show(this, "Pacientul a fost sters.", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
using (BDISAppMedicalConditions db = new BDISAppMedicalConditions())
{
db.MedicalConditions.RemoveRange(db.MedicalConditions.Where(x => x.Patient_UID == user_UID));
db.SaveChanges();
}
}
