public void Execute(ref StagingDiagnosisFile diagnosis) { Parameters.AddWithValue("@ChapterID", diagnosis.ChapterID); Parameters.AddWithValue("@DiagnosisCodeID", diagnosis.DiagnosisCodeID); Parameters.AddWithValue("@DiagnosisCodeTypeID", diagnosis.DiagnosisCodeTypeID); Parameters.AddWithValue("@DiagnosticCode", diagnosis.DiagnosticCode); Parameters.AddWithValue("@DiagnosticCodeFlag", diagnosis.DiagnosticCodeFlag); Parameters.AddWithValue("@DxCodePriority", diagnosis.DXCodePriority); Parameters.AddWithValue("@DxDate", diagnosis.DXDate); Parameters.AddWithValue("@EncounterID", diagnosis.EncounterID); Parameters.AddWithValue("@EncounterNumber", diagnosis.EncounterNumber); Parameters.AddWithValue("@FileID", diagnosis.FileID); Parameters.AddWithValue("@JobID", diagnosis.JobID); Parameters.AddWithValue("@SectionID", diagnosis.SectionID); Parameters.AddWithValue("@SubSectionID", diagnosis.SubSectionID); Parameters.AddWithValue("@Version", diagnosis.Version); ExecuteNonQuery(); }
/// <summary> /// /// </summary> protected override void ReadIncomingTable() { base.ReadIncomingTable(); string fileToProcess = Path.Combine(SystemDataProvider.CurrentSettings.FileProcessingPath, file.FileName); log.DebugFormat("Looking for file {0}", fileToProcess); if (!File.Exists(fileToProcess)) { throw new FileNotFoundException(fileToProcess); } DelimitedFileValidator<Diagnosis> validator = new DelimitedFileValidator<Diagnosis>(); validator.Validate(fileToProcess); var list = validator.Rows.OrderBy(x => x.EncounterNumber).ThenBy(x => x.DxCodePriority); if (list.Count() == 0) { throw new FileImportException(fileToProcess); } log.Debug("Creating Diagnosis objects"); foreach (Diagnosis item in list) { StagingDiagnosisFile diagnosis = new StagingDiagnosisFile(); diagnosis.JobID = job.JobID; //diagnosis.ClientOrganizationID = file.ClientOrganizationID; diagnosis.DiagnosticCode = item.DiagnosticCode; diagnosis.DiagnosticCodeFlag = item.DiagnosticFlag; int priority = 0; if (int.TryParse(item.DxCodePriority, out priority)) { diagnosis.DXCodePriority = priority; } else { diagnosis.DXCodePriority = 0; } diagnosis.DXDate = item.DxDate; diagnosis.EncounterNumber = item.EncounterNumber; Diagnoses.Add(diagnosis); } }
public StagingDiagnosisFile Clone() { StagingDiagnosisFile result = new StagingDiagnosisFile(); result.PrimaryID = this.PrimaryID; result.EncounterID = this.EncounterID; result.DiagnosticCode = this.DiagnosticCode; result.DiagnosticCodeFlag = this.DiagnosticCodeFlag; result.DXCodePriority = this.DXCodePriority; result.DXDate = this.DXDate; result.FileID = this.FileID; result.Version = this.Version; result.DiagnosisCodeTypeID = this.DiagnosisCodeTypeID; result.DiagnosisCodeID = this.DiagnosisCodeID; result.JobID = this.JobID; result.EncounterNumber = this.EncounterNumber; result.NewDiagnosisCodeID = this.NewDiagnosisCodeID; result.ChapterID = this.ChapterID; result.SectionID = this.SectionID; result.SubSectionID = this.SubSectionID; return result; }
public void StagingDiagnosisFileSave(ref StagingDiagnosisFile diagnosis) { spStagingDiagnosisAdd proc = new spStagingDiagnosisAdd(this.ConnectionString); proc.Execute(ref diagnosis); }