private void ChangeStateToClosed(int id)
{
UrTest__Patient bp = (from q in db.UrTest__Patient where q.utp_testid == id select q).FirstOrDefault();
bp.utp_state = (from q in db.State where q.state_value == "завершено" select q.state_id).FirstOrDefault();
db.SaveChanges();
}
public void PlanNewTest(DateTime date, int pid)
{
UrTest__Patient ur = new UrTest__Patient();
ur.utp_state = (from q in db.State
where q.state_value == "заплановано"
select q.state_id).FirstOrDefault();
ur.utp_date = date;
UrineTest test = new UrineTest();
db.UrineTest.Add(test);
ur.utp_patid = pid;
ur.utp_testid = test.urtest_id;
db.UrTest__Patient.Add(ur);
db.SaveChanges();
}
public int DeleteTest(int id)
{
UrTest__Patient ur = (from q in db.UrTest__Patient
where (q.utp_id == id)
select q).FirstOrDefault();
int testid = ur.utp_testid ?? default(int);
db.UrTest__Patient.Remove(ur);
db.SaveChanges();
UrineTest test = (from q in db.UrineTest
where q.urtest_id == testid
select q).FirstOrDefault();
if (test != null)
{
db.UrineTest.Remove(test);
db.SaveChanges();
}
return(testid);
}
public override void Plan(DateTime date)
{
try
{
UrTest__Patient u = new UrTest__Patient();
UrineTest test = new UrineTest();
ctx.UrineTest.Add(test);
u.utp_patid = pat.p_id;
u.utp_state = (from c in ctx.State where (c.state_value == "заплановано") select c.state_id).FirstOrDefault();
u.utp_date = date.Date;
u.utp_testid = test.urtest_id;
ctx.UrTest__Patient.Add(u);
ctx.SaveChanges();
Renew();
}
catch
{
MessageBox.Show("Помилка при плануванні");
}
}
