private void UpdatePatient()
{
var pat = ctx.Patients.Where(c => c.p_id == patient.p_id).FirstOrDefault();
LoadFormInPatient(pat);
ctx.SaveChanges();
MessageBox.Show("Зміни збережено");
}
private void DeletePatientBut_Click(object sender, EventArgs e)
{
ctx.Dispose();
ctx = new TubDataBaseEntities();
ctx.Patients.Load();
DialogResult d = MessageBox.Show("Ви впевнені, що бажаєте видалити цього пацієнта?", "Видалення", MessageBoxButtons.YesNo);
if (d == DialogResult.Yes)
{
var p = (from c in ctx.Patients where (c.p_id == patient.p_id) select c).FirstOrDefault();
int a = (from c in ctx.BlTest___Patient where (c.bltp_patid == patient.p_id) select c).Count() +
(from c in ctx.UrTest__Patient where (c.utp_patid == patient.p_id) select c).Count() +
(from c in ctx.HepTest___Patient where (c.htp_patid == patient.p_id) select c).Count() +
(from c in ctx.SputumTest___Patient where (c.sptp_patid == patient.p_id) select c).Count() +
(from c in ctx.Consult___Patient where (c.cp_patid == patient.p_id) select c).Count();
if (a == 0)
{
ctx.Patients.Remove(p);
ctx.SaveChanges();
MessageBox.Show("Пацієнта видалено");
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("До пацієнта прив'язані аналізи, видаляти заборонено");
}
}
}
private void SetLosed()
{
int st = (from c in ctx.State where (c.state_value == "заплановано") select c.state_id).FirstOrDefault();
var query = (from c in ctx.BlTest___Patient where (c.bltp_date < DateTime.Today.Date && c.bltp_state == st) select c).ToList();
foreach (var q in query)
{
q.bltp_state = (from c in ctx.State where (c.state_value == "пропущено") select c.state_id).FirstOrDefault();
}
ctx.SaveChanges();
}
private void OKClicked()
{
try
{
if (m == mode.Create)
{
FillUrTest(ur);
var q = (from c in ctx.UrTest__Patient where (c.utp_testid == test) select c).FirstOrDefault();
q.utp_state = (from c in ctx.State where (c.state_value == "завершено") select c.state_id).FirstOrDefault();
ctx.SaveChanges();
this.DialogResult = DialogResult.OK;
}
else
{
FillUrTest(ur);
ctx.SaveChanges();
this.DialogResult = DialogResult.OK;
}
}
catch
{
MessageBox.Show("Введено неправильну інформацію");
}
}