public object GetActiveTest(int id) { SputumTest test = (from q in db.SputumTest where q.sputtest_id == id select q).FirstOrDefault(); return(test); }
public void UpdateTest(object o) { SputumTest b = o as SputumTest; SputumTest oldb = (from q in db.SputumTest where q.sputtest_id == b.sputtest_id select q).FirstOrDefault(); oldb.sputtest_inocul = b.sputtest_inocul; oldb.sputtest_scopy = b.sputtest_scopy; ChangeStateToClosed(oldb.sputtest_id); db.SaveChanges(); }
public void PlanNewTest(DateTime date, int pid) { SputumTest___Patient bl = new SputumTest___Patient(); bl.sptp_state = (from q in db.State where q.state_value == "заплановано" select q.state_id).FirstOrDefault(); bl.sptp_date = date; SputumTest test = new SputumTest(); db.SputumTest.Add(test); bl.sptp_patid = pid; bl.sptp_testid = test.sputtest_id; db.SputumTest___Patient.Add(bl); db.SaveChanges(); }
private void FillBlTest(SputumTest s) { if (skopTB.Text.Trim() != "") { s.sputtest_scopy = Convert.ToDouble(skopTB.Text.Replace('.', ',')); } else { s.sputtest_scopy = null; } if (inoTB.Text.Trim() != "") { s.sputtest_inocul = inoTB.Text; } else { s.sputtest_inocul = null; } }
public int DeleteTest(int id) { SputumTest___Patient bl = (from q in db.SputumTest___Patient where (q.sptp_id == id) select q).FirstOrDefault(); int testid = bl.sptp_testid; db.SputumTest___Patient.Remove(bl); db.SaveChanges(); SputumTest test = (from q in db.SputumTest where q.sputtest_id == testid select q).FirstOrDefault(); if (test != null) { db.SputumTest.Remove(test); db.SaveChanges(); } return(testid); }
public override void Plan(DateTime date) { try { SputumTest___Patient b = new SputumTest___Patient(); SputumTest test = new SputumTest(); ctx.SputumTest.Add(test); b.sptp_patid = pat.p_id; b.sptp_state = (from c in ctx.State where (c.state_value == "заплановано") select c.state_id).FirstOrDefault(); b.sptp_date = date.Date; b.sptp_testid = test.sputtest_id; ctx.SputumTest___Patient.Add(b); ctx.SaveChanges(); Renew(); } catch { MessageBox.Show("Помилка при плануванні"); } }
public SputumTestForm(int testid, DateTime date, mode _m) { InitializeComponent(); ctx = new TubDataBaseEntities(); m = _m; test = testid; sp = (from c in ctx.SputumTest where (c.sputtest_id == testid) select c).FirstOrDefault(); if (m == mode.Redact) { this.StatusL.Text = "Завершено " + date.ToShortDateString(); LoadTest(testid); } else if (m == mode.Create) { this.StatusL.Text = "Закінчити тест за " + date.ToShortDateString(); } else if (m == mode.Losed) { this.StatusL.Text = "Пропущений тест за " + date.ToShortDateString(); } }
public ActionResult UpdateSputumTest(SputumTest sputum) { HelperSelector.get(model.ViewName).UpdateTest(sputum); model.Single = null; return(redirect()); }