public void Execute(ref StagingEncounterFile encounter)
{
Parameters.AddWithValue("@AdmitDT",encounter.AdmitDT);
Parameters.AddWithValue("@AdmitType", encounter.AdmitType);
Parameters.AddWithValue("@AdmitTypeID", encounter.AdmitTypeID);
Parameters.AddWithValue("@AttendingPhysician", encounter.AttendingPhysician);
Parameters.AddWithValue("@ChapterID", encounter.ChapterID);
Parameters.AddWithValue("@ClientOrganizationID", encounter.ClientOrganizationID);
Parameters.AddWithValue("@Cost", encounter.Cost);
Parameters.AddWithValue("@DiagnosisCode", encounter.DiagnosisCode);
Parameters.AddWithValue("@DiagnosisCodeID", encounter.DiagnosisCodeID);
Parameters.AddWithValue("@DiagnosisCodeTypeID", encounter.DiagnosisCodeTypeID);
Parameters.AddWithValue("@DiagnosisType", encounter.DiagnosisType);
Parameters.AddWithValue("@DischargeDT", encounter.DischargeDT);
Parameters.AddWithValue("@EncounterAge", encounter.EncounterAge);
Parameters.AddWithValue("@EncounterID", encounter.EncounterID);
Parameters.AddWithValue("@EncounterImportID", encounter.EncounterImportID);
Parameters.AddWithValue("@EncounterNumber", encounter.EncounterNumber);
Parameters.AddWithValue("@EncounterTypeID", encounter.EncounterTypeID);
Parameters.AddWithValue("@Facility", encounter.Facility);
Parameters.AddWithValue("@FileID", encounter.FileID);
Parameters.AddWithValue("@Income", encounter.Income);
Parameters.AddWithValue("@JobID", encounter.JobID);
Parameters.AddWithValue("@PatientNumber", encounter.PatientNumber);
Parameters.AddWithValue("@PresentOnAdmission", encounter.PresentOnAdmission);
Parameters.AddWithValue("@ProcedureCode", encounter.ProcedureCode);
Parameters.AddWithValue("@ProcedureCodeID", encounter.ProcedureCodeID);
Parameters.AddWithValue("@ProcedureType", encounter.ProcedureType);
Parameters.AddWithValue("@ProcedureTypeID", encounter.ProcedureTypeID);
Parameters.AddWithValue("@ReAdmission", encounter.ReAdmission);
Parameters.AddWithValue("@ReferringPhysician", encounter.ReferringPhysician);
Parameters.AddWithValue("@SectionID", encounter.SectionID);
Parameters.AddWithValue("@Source", encounter.Source);
Parameters.AddWithValue("@SubSectionID", encounter.SubSectionID);
Parameters.AddWithValue("@TriageCode", encounter.TriageCode);
Parameters.AddWithValue("@TriageCodeID", encounter.TriageCodeID);
Parameters.AddWithValue("@Version", encounter.Version);
ExecuteNonQuery();
}
public void StagingEncounterFileSave(ref StagingEncounterFile encounter)
{
spAddStagingEncounterRow proc = new spAddStagingEncounterRow(this.ConnectionString);
proc.Execute(ref encounter);
}
public StagingEncounterFile GetEncounterValues(Job job)
{
StagingEncounterFile result = new StagingEncounterFile();
result.AdmitDT = this.AdmitDateTime;
result.AdmitType = this.AdmitType;
result.AttendingPhysician = this.AttendingPhysician;
result.Cost = this.Cost;
result.DiagnosisCode = this.DiagnosisCode;
result.DiagnosisType = this.DiagnosisType;
result.DischargeDT = this.DischargeDateTime;
result.EncounterNumber = this.EncounterNumber;
result.Facility = this.Facility;
result.FileID = job.FileID;
result.JobID = job.JobID;
result.PatientNumber = this.PatientNumber;
result.PresentOnAdmission = this.POA;
result.ProcedureCode = this.ProcedureCode;
result.ProcedureType = this.ProcedureType;
result.ReAdmission = this.ReadmitFlag;
result.ReferringPhysician = this.ReferringPhysician;
result.Source = this.Source;
int triagecode = 0;
if (int.TryParse(this.TriageCode, out triagecode))
{
result.TriageCode = triagecode;
}
else
{
result.TriageCode = 0;
}
result.Version = this.Version;
result.EncounterImportID = this.EncounterImportID;
return result;
}
public StagingEncounterFile GetEncounterValues(Job job, int clientOrganizationID)
{
StagingEncounterFile result = new StagingEncounterFile()
{
AdmitDT = this.AdmitDateTime,
AdmitType = this.AdmitType,
AttendingPhysician = this.AttendingPhysician,
Cost = this.Cost,
DiagnosisCode = this.DiagnosisCode,
DiagnosisType = this.DiagnosisType,
DischargeDT = this.DischargeDateTime,
EncounterNumber = this.EncounterNumber,
Facility = this.Facility,
FileID = job.FileID,
JobID = job.JobID,
PatientNumber = this.PatientNumber,
PresentOnAdmission = this.POA,
ProcedureCode = this.ProcedureCode,
ProcedureType = this.ProcedureType,
ReAdmission = this.ReadmitFlag,
ReferringPhysician = this.ReferringPhysician,
Source = this.Source,
Version = this.Version,
ClientOrganizationID = clientOrganizationID,
EncounterImportID = this.EncounterImportID
};
//result.LookupIDs();
//Task# 995 - CF
if (result.AdmitDT == libc.Constants.MinDateValue &&
result.DischargeDT == libc.Constants.MinDateValue)
{
return null;
}
return result;
}
public StagingEncounterFile Clone()
{
StagingEncounterFile result = new StagingEncounterFile();
result.PrimaryID = this.PrimaryID;
result.FileID = this.FileID;
result.Version = this.Version;
result.PatientNumber = this.PatientNumber;
result.EncounterNumber = this.EncounterNumber;
result.Facility = this.Facility;
result.DiagnosisCode = this.DiagnosisCode;
result.DiagnosisType = this.DiagnosisType;
result.ProcedureCode = this.ProcedureCode;
result.ProcedureType = this.ProcedureType;
result.AdmitDT = this.AdmitDT;
result.DischargeDT = this.DischargeDT;
result.Cost = this.Cost;
result.ReferringPhysician = this.ReferringPhysician;
result.AttendingPhysician = this.AttendingPhysician;
result.Source = this.Source;
result.AdmitType = this.AdmitType;
result.ReAdmission = this.ReAdmission;
result.TriageCode = this.TriageCode;
result.PresentOnAdmission = this.PresentOnAdmission;
result.EncounterAge = this.EncounterAge;
result.Income = this.Income;
result.EncounterID = this.EncounterID;
result.EncounterTypeID = this.EncounterTypeID;
result.DiagnosisCodeTypeID = this.DiagnosisCodeTypeID;
result.DiagnosisCodeID = this.DiagnosisCodeID;
result.ProcedureTypeID = this.ProcedureTypeID;
result.ProcedureCodeID = this.ProcedureCodeID;
result.AdmitTypeID = this.AdmitTypeID;
result.TriageCodeID = this.TriageCodeID;
result.JobID = this.JobID;
result.ClientOrganizationID = this.ClientOrganizationID;
result.ChapterID = this.ChapterID;
result.SectionID = this.SectionID;
result.SubSectionID = this.SubSectionID;
result.ChangeType = this.ChangeType;
result.EncounterImportID = this.EncounterImportID;
return result;
}
