public void SetReorederDataOfStudy(StudyModel study)
{
string query = $@"
update Studies set IdRepeatEmployee={study.IdRepeatEmployee}, IdStatus={(long)StatusTypeEnum.ReOrdered},
ReasonForRepeat={BaseDAO.SetString(study.ReasonForRepeat)}, Actual={BaseDAO.SetBool(false)},
DateOfEnd={BaseDAO.SetDate(DateTime.Now)}
where IdStudy={study.IdStudy}
";
BaseDAO.InsertOrUpdate(query, false);
}
public void UpdateStudy(StudyModel study)
{
string query = $@"
update Studies set IdEmployee={study.IdDoctor}, IdStatus={study.IdStatus}, DateOfStudy={BaseDAO.SetDate(study.DateOfStudy)},
ReasonForRepeat={BaseDAO.SetString(study.ReasonForRepeat)}, Actual={BaseDAO.SetBool(study.Actual)},
PreviousId={BaseDAO.SetNullableLong(study.PreviousId)}, DateOfEnd={BaseDAO.SetDate(study.DateOfEnd)},
IdRepeatEmployee={BaseDAO.SetNullableLong(study.IdRepeatEmployee)}
where IdStudy={study.IdStudy}
";
BaseDAO.InsertOrUpdate(query, false);
}
public void InsertVerify(VerificationModel v)
{
string query = $@"
insert into Verifications(IdResult, IdEmployee, DateOfVerification, Description, Positive)
values({v.IdResult},{v.IdEmployee},{BaseDAO.SetDate(DateTime.Now)},{BaseDAO.SetString(v.Description)}, {BaseDAO.SetBool(v.Positive)});
";
BaseDAO.InsertOrUpdate(query, false);
}
public void UpdateUser(UserModel u)
{
string query = $@"
update Users set Password = {BaseDAO.SetString(u.Password)}, DateOfChange = {BaseDAO.SetDate(DateTime.Now)}, InUse = {BaseDAO.SetBool(u.InUse)}
where IdUser = {u.IdUser};
";
BaseDAO.InsertOrUpdate(query, false);
}
