private TagRegistrationDto GetByPatientId(int patientId) { TagRegistrationDto result = new TagRegistrationDto(); MyDataSet ds = new MyDataSet(); ds.EnforceConstraints = false; DbTools.SelectQuery( FireBirdConnection.Connection, ds.TagRegistration, string.Format(UrgentAppQueries.TAGREGISTRATION_SELECT_BYPATIENTID, patientId)); result = baseMapper.BindData <TagRegistrationDto>(ds.TagRegistration); return(result); }
private void CheckForPKViolations(TagRegistrationDto tagRegistration) { var check = GetByTagId(tagRegistration.Tag_Id); if (check != null) { throw new ApplicationException(); } var tagCheck = tagTasks.GetById(tagRegistration.Tag_Id); if (tagCheck == null) { throw new ApplicationException(); } }
public void Create(TagRegistrationDto tagRegistration) { MyDataSet ds = new MyDataSet(); ds.EnforceConstraints = false; CheckForPKViolations(tagRegistration); string query = string.Format( UrgentAppQueries.TAGREGISTRATION_INSERT, tagRegistration.Id, tagRegistration.Tag_Id, tagRegistration.Patient_Id ); DbTools.ExecuteQuery( FireBirdConnection.Connection, query); }