private void ChangeStateToClosed(int id)
{
BlTest___Patient bp = (from q in db.BlTest___Patient where q.bltp_testid == id select q).FirstOrDefault();
bp.bltp_state = (from q in db.State where q.state_value == "завершено" select q.state_id).FirstOrDefault();
db.SaveChanges();
}
public void PlanNewTest(DateTime date, int pid)
{
BlTest___Patient bl = new BlTest___Patient();
bl.bltp_state = (from q in db.State where q.state_value == "заплановано" select q.state_id).FirstOrDefault();
bl.bltp_date = date;
BloodTest test = new BloodTest();
db.BloodTest.Add(test);
bl.bltp_patid = pid;
bl.bltp_testid = test.bltest_id;
db.BlTest___Patient.Add(bl);
db.SaveChanges();
}
public int DeleteTest(int id)
{
BlTest___Patient bl = (from q in db.BlTest___Patient where (q.bltp_id == id) select q).FirstOrDefault();
int testid = bl.bltp_testid;
db.BlTest___Patient.Remove(bl);
db.SaveChanges();
BloodTest test = (from q in db.BloodTest where q.bltest_id == testid select q).FirstOrDefault();
if (test != null)
{
db.BloodTest.Remove(test);
db.SaveChanges();
}
return(testid);
}
public override void Plan(DateTime date)
{
try
{
BlTest___Patient b = new BlTest___Patient();
BloodTest test = new BloodTest();
ctx.BloodTest.Add(test);
b.bltp_patid = pat.p_id;
b.bltp_state = (from c in ctx.State where (c.state_value == "заплановано") select c.state_id).FirstOrDefault();
b.bltp_date = date.Date;
b.bltp_testid = test.bltest_id;
ctx.BlTest___Patient.Add(b);
ctx.SaveChanges();
Renew();
}
catch
{
MessageBox.Show("Помилка при плануванні");
}
}
