public static void RefreshTests()
{
TubDataBaseEntities db = new TubDataBaseEntities();
List <BlTest___Patient> blood = (from q in db.BlTest___Patient
where q.State.state_value == "заплановано"
select q).ToList();
foreach (BlTest___Patient b in blood)
{
if (b.bltp_date.Date < DateTime.Now.Date)
{
b.bltp_state = (from q in db.State where q.state_value == "пропущено" select q.state_id).FirstOrDefault();
}
}
List <UrTest__Patient> urina = (from q in db.UrTest__Patient
where q.State.state_value == "заплановано"
select q).ToList();
foreach (UrTest__Patient u in urina)
{
if (u.utp_date.Date < DateTime.Now.Date)
{
u.utp_state = (from q in db.State where q.state_value == "пропущено" select q.state_id).FirstOrDefault();
}
}
List <HepTest___Patient> hepat = (from q in db.HepTest___Patient
where q.State.state_value == "заплановано"
select q).ToList();
foreach (HepTest___Patient h in hepat)
{
if (h.htp_date.Date < DateTime.Now.Date)
{
h.htp_state = (from q in db.State where q.state_value == "пропущено" select q.state_id).FirstOrDefault();
}
}
List <SputumTest___Patient> sputum = (from q in db.SputumTest___Patient
where q.State.state_value == "заплановано"
select q).ToList();
foreach (SputumTest___Patient s in sputum)
{
if (s.sptp_date.Date < DateTime.Now.Date)
{
s.sptp_state = (from q in db.State where q.state_value == "пропущено" select q.state_id).FirstOrDefault();
}
}
List <Consult___Patient> consult = (from q in db.Consult___Patient
where q.State.state_value == "заплановано"
select q).ToList();
foreach (Consult___Patient c in consult)
{
if (c.cp_date.Date < DateTime.Now.Date)
{
c.cp_state = (from q in db.State where q.state_value == "пропущено" select q.state_id).FirstOrDefault();
}
}
db.SaveChanges();
}
public ActionResult SinglePatientEdit(int p_id = 0)
{
db = new TubDataBaseEntities();
SelectList gender = new SelectList(db.Gender.ToList(), "gen_id", "gen_value");
ViewBag.Gender = gender;
SelectList diagnosis = new SelectList(db.Diagnosis, "diag_id", "diag_value");
ViewBag.Diagnosis = diagnosis;
SelectList type = new SelectList(db.Type, "type_id", "type_value");
ViewBag.Type = type;
SelectList bk = new SelectList(db.BK, "bk_id", "bk_value");
ViewBag.BK = bk;
SelectList dest = new SelectList(db.Destruction, "destr_id", "destr_value");
ViewBag.Destruction = dest;
Patients pat = (from p in db.Patients where (p.p_id == p_id) select p).FirstOrDefault();
if (pat == null)
{
return(HttpNotFound());
}
return(View(pat));
}
public override void Delete()
{
ctx = new TubDataBaseEntities();
ctx.BlTest___Patient.Load();
var b = (from c in ctx.BlTest___Patient where (c.bltp_id == ((BlTest___Patient)data.Current).bltp_id) select c).FirstOrDefault();
ctx.BlTest___Patient.Remove(b);
ctx.SaveChanges();
Renew();
}
public override void RenewWithDate(DateTime date)
{
int state = State();
ctx.Dispose();
ctx = new TubDataBaseEntities();
var bloodQuery = ctx.BlTest___Patient.Where(p => p.bltp_patid == pat.p_id && p.bltp_state == state && p.bltp_date == date.Date);
bloodQuery.Load();
data.DataSource = ctx.BlTest___Patient.Local.ToBindingList();
}
public override void Renew()
{
int state = State();
ctx.Dispose();
ctx = new TubDataBaseEntities();
var hepQuery = ctx.HepTest___Patient.Where(p => p.htp_patid == pat.p_id && p.htp_state == state);
hepQuery.Load();
data.DataSource = ctx.HepTest___Patient.Local.ToBindingList();
}
