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