public void Execute(ref StagingPerson person) { Parameters.AddWithValue("@DateOfBirth", person.DateOfBirth); Parameters.AddWithValue("@Email", person.Email); Parameters.AddWithValue("@EncounterImportID", person.EncounterImportID); Parameters.AddWithValue("@FileID", person.FileID); Parameters.AddWithValue("@FirstName", person.FirstName); Parameters.AddWithValue("@Gender", person.Gender); Parameters.AddWithValue("@Income", person.Income); Parameters.AddWithValue("@JobID", person.JobID); Parameters.AddWithValue("@LastName", person.LastName); Parameters.AddWithValue("@LastNameSuffix", person.LastNameSuffix); Parameters.AddWithValue("@MiddleInitial", person.MiddleInitial); Parameters.AddWithValue("@PatientNumber", person.PatientNumber); Parameters.AddWithValue("@PersonID", person.PersonID); Parameters.AddWithValue("@Phone", person.Phone); Parameters.AddWithValue("@Title", person.Title); ExecuteNonQuery(); }
public StagingPerson Clone() { StagingPerson result = new StagingPerson(); result.Staging_PersonID = this.Staging_PersonID; result.FileID = this.FileID; result.JobID = this.JobID; result.PersonID = this.PersonID; result.PatientNumber = this.PatientNumber; result.Title = this.Title; result.FirstName = this.FirstName; result.MiddleInitial = this.MiddleInitial; result.LastName = this.LastName; result.LastNameSuffix = this.LastNameSuffix; result.DateOfBirth = this.DateOfBirth; result.Gender = this.Gender; result.Phone = this.Phone; result.Email = this.Email; result.Income = this.Income; result.EncounterImportID = this.EncounterImportID; result.PersonHash = this.PersonHash; return result; }
public void StagingPersonSave(ref StagingPerson person) { spAddStagingPerson proc = new spAddStagingPerson(this.ConnectionString); proc.Execute(ref person); }
public StagingPerson GetPersonValues(Job job) { StagingPerson result = new StagingPerson() { FirstName = this.FirstName, MiddleInitial = GetMiddleInitial().ToString(), LastName = this.LastName, LastNameSuffix = this.LastNameSuffix, Title = this.Title, DateOfBirth = this.DateOfBirth, PatientNumber = this.PatientNumber, Gender = MapGender().ToString(), Phone = this.Phone, Email = this.Email, FileID = job.FileID, JobID = job.JobID, EncounterImportID = this.EncounterImportID }; return result; }