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