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