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("Помилка при плануванні"); } }