private void ChangeStateToClosed(int id)
{
Consult___Patient bp = (from q in db.Consult___Patient
where q.cp_consid == id
select q).FirstOrDefault();
bp.cp_state = (from q in db.State
where q.state_value == "завершено"
select q.state_id).FirstOrDefault();
db.SaveChanges();
}
public void PlanNewTest(DateTime date, int pid)
{
Consult___Patient bl = new Consult___Patient();
bl.cp_state = (from q in db.State
where q.state_value == "заплановано"
select q.state_id).FirstOrDefault();
bl.cp_date = date;
Consultation test = new Consultation();
db.Consultation.Add(test);
bl.cp_patid = pid;
bl.cp_consid = test.cons_id;
db.Consult___Patient.Add(bl);
db.SaveChanges();
}
public int DeleteTest(int id)
{
Consult___Patient bl = (from q in db.Consult___Patient
where (q.cp_id == id)
select q).FirstOrDefault();
int testid = bl.cp_consid;
db.Consult___Patient.Remove(bl);
db.SaveChanges();
Consultation test = (from q in db.Consultation
where q.cons_id == testid
select q).FirstOrDefault();
if (test != null)
{
db.Consultation.Remove(test);
db.SaveChanges();
}
return(testid);
}
public override void Plan(DateTime date)
{
try
{
Consult___Patient b = new Consult___Patient();
Consultation test = new Consultation();
test.cons_type = (int)doc.SelectedValue;
ctx.Consultation.Add(test);
b.cp_patid = pat.p_id;
b.cp_state = (from c in ctx.State where (c.state_value == "заплановано") select c.state_id).FirstOrDefault();
b.cp_date = date.Date;
b.cp_consid = test.cons_id;
ctx.Consult___Patient.Add(b);
ctx.SaveChanges();
Renew();
}
catch
{
MessageBox.Show("Помилка при плануванні");
}
}
