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); }