public PatientNoteRepositoryFactory(string contract, string userid)
{
_contract = contract;
_userId = userid;
_context = new PatientNoteMongoContext(_contract);
}
public override void Execute()
{
try
{
OnDocColEvent(new ETLEventArgs {
Message = "[" + Contract + "] Loading Patient Utilization.", IsError = false
});
ConcurrentBag <EPatientUtilization> ePU = new ConcurrentBag <EPatientUtilization>();
List <EPatientUtilizationProgram> associatedPrograms = new List <EPatientUtilizationProgram>();
ConcurrentBag <MEPatientUtilization> mePU;
using (PatientNoteMongoContext ctx = new PatientNoteMongoContext(Contract))
{
mePU = new ConcurrentBag <MEPatientUtilization>(ctx.PatientUtilizations.Collection.FindAllAs <MEPatientUtilization>().ToList());
}
foreach (MEPatientUtilization u in mePU)
{
try
{
ePU.Add(new EPatientUtilization
{
Id = u.Id.ToString(),
PatientId = u.PatientId.ToString(),
NoteTypeId = u.NoteType == null ? null : u.NoteType.ToString(),
Reason = u.Reason,
VisitTypeId = u.VisitType == null ? null : u.VisitType.ToString(),
OtherVisitType = u.OtherType,
AdmitDate = u.AdmitDate,
Admitted = u.Admitted.ToString(),
DischargeDate = u.DischargeDate,
LocationId = u.Location == null ? null : u.Location.ToString(),
OtherLocation = u.OtherLocation,
DispositionId = u.Disposition == null ? null : u.Disposition.ToString(),
OtherDisposition = u.OtherDisposition,
UtilizationSourceId = u.SourceId == null ? null : u.SourceId.ToString(),
DataSource = u.DataSource,
Version = u.Version,
UpdatedBy = u.UpdatedBy == null ? string.Empty : u.UpdatedBy.ToString(),
RecordCreatedBy = u.RecordCreatedBy.ToString(),
RecordCreatedOn = u.RecordCreatedOn,
DeleteFlag = u.DeleteFlag.ToString(),
LastUpdatedOn = u.LastUpdatedOn
});
if (u.ProgramIds != null)
{
foreach (var progId in u.ProgramIds)
{
associatedPrograms.Add(new EPatientUtilizationProgram
{
Id = progId.ToString(),
LastUpdatedOn = u.LastUpdatedOn,
UpdatedBy = u.UpdatedBy == null ? string.Empty : u.UpdatedBy.ToString(),
RecordCreatedBy = u.RecordCreatedBy.ToString(),
PatientUtilizationId = u.Id.ToString(),
RecordCreatedOn = u.RecordCreatedOn,
Version = u.Version
});
}
}
}
catch (Exception ex)
{
OnDocColEvent(new ETLEventArgs {
Message = "[" + Contract + "] " + ex.Message + ": " + ex.StackTrace, IsError = true
});
}
}
SavePatientUtilizationCollection(ePU);
SavePatientUtilizationProgramCollection(associatedPrograms);
}
catch (Exception ex)
{
throw ex;
}
}
public override void Execute()
{
try
{
List <EPatientNoteProgram> noteMap = new List <EPatientNoteProgram>();
#region PatientNotes
OnDocColEvent(new ETLEventArgs {
Message = "[" + Contract + "] Loading Patient Notes.", IsError = false
});
ConcurrentBag <MEPatientNote> notes;
using (PatientNoteMongoContext pnctx = new PatientNoteMongoContext(Contract))
{
notes = new ConcurrentBag <MEPatientNote>(pnctx.PatientNotes.Collection.FindAllAs <MEPatientNote>().ToList());
}
foreach (MEPatientNote note in notes)
{
try
{
ParameterCollection parms = new ParameterCollection();
#region PatientNote fields
parms.Add(new Parameter("@MongoID", (string.IsNullOrEmpty(note.Id.ToString()) ? string.Empty : note.Id.ToString()), SqlDbType.VarChar, ParameterDirection.Input, 50));
parms.Add(new Parameter("@PatientMongoId", (string.IsNullOrEmpty(note.PatientId.ToString()) ? string.Empty : note.PatientId.ToString()), SqlDbType.VarChar, ParameterDirection.Input, 50));
parms.Add(new Parameter("@Text", (string.IsNullOrEmpty(note.Text) ? string.Empty : note.Text), SqlDbType.VarChar, ParameterDirection.Input, int.MaxValue));
parms.Add(new Parameter("@Type", note.Type.ToString() ?? (object)DBNull.Value, SqlDbType.VarChar, ParameterDirection.Input, 50));
parms.Add(new Parameter("@MongoMethodId", (string.IsNullOrEmpty(note.MethodId.ToString()) ? string.Empty : note.MethodId.ToString()), SqlDbType.VarChar, ParameterDirection.Input, 50));
parms.Add(new Parameter("@MongoOutcomeId", (string.IsNullOrEmpty(note.OutcomeId.ToString()) ? string.Empty : note.OutcomeId.ToString()), SqlDbType.VarChar, ParameterDirection.Input, 50));
parms.Add(new Parameter("@MongoWhoId", (string.IsNullOrEmpty(note.WhoId.ToString()) ? string.Empty : note.WhoId.ToString()), SqlDbType.VarChar, ParameterDirection.Input, 50));
parms.Add(new Parameter("@MongoSourceId", (string.IsNullOrEmpty(note.SourceId.ToString()) ? string.Empty : note.SourceId.ToString()), SqlDbType.VarChar, ParameterDirection.Input, 50));
parms.Add(new Parameter("@ContactedOn", note.ContactedOn ?? (object)DBNull.Value, SqlDbType.DateTime, ParameterDirection.Input, 50));
parms.Add(new Parameter("@ValidatedIntentity", note.ValidatedIdentity.ToString(), SqlDbType.VarChar, ParameterDirection.Input, 50));
parms.Add(new Parameter("@Duration", note.Duration ?? (object)DBNull.Value, SqlDbType.Int, ParameterDirection.Input, 50));
parms.Add(new Parameter("@DataSource", (string.IsNullOrEmpty(note.DataSource) ? string.Empty : note.DataSource.ToString()), SqlDbType.VarChar, ParameterDirection.Input, 50));
#endregion
#region StandardFields
parms.Add(new Parameter("@UpdatedBy", (string.IsNullOrEmpty(note.UpdatedBy.ToString()) ? string.Empty : note.UpdatedBy.ToString()), SqlDbType.VarChar, ParameterDirection.Input, 50));
parms.Add(new Parameter("@LastUpdatedOn", note.LastUpdatedOn ?? (object)DBNull.Value, SqlDbType.DateTime, ParameterDirection.Input, 50));
parms.Add(new Parameter("@RecordCreatedBy", (string.IsNullOrEmpty(note.RecordCreatedBy.ToString()) ? string.Empty : note.RecordCreatedBy.ToString()), SqlDbType.VarChar, ParameterDirection.Input, 50));
parms.Add(new Parameter("@RecordCreatedOn", note.RecordCreatedOn, SqlDbType.DateTime, ParameterDirection.Input, 50));
parms.Add(new Parameter("@Version", (string.IsNullOrEmpty(note.Version.ToString()) ? string.Empty : note.Version.ToString()), SqlDbType.Float, ParameterDirection.Input, 32));
parms.Add(new Parameter("@Delete", (string.IsNullOrEmpty(note.DeleteFlag.ToString()) ? string.Empty : note.DeleteFlag.ToString()), SqlDbType.VarChar, ParameterDirection.Input, 50));
parms.Add(new Parameter("@TTLDate", note.TTLDate ?? (object)DBNull.Value, SqlDbType.DateTime, ParameterDirection.Input, 50));
if (note.ExtraElements != null)
{
parms.Add(new Parameter("@ExtraElements", note.ExtraElements.ToString(), SqlDbType.VarChar, ParameterDirection.Input, int.MaxValue));
}
else
{
parms.Add(new Parameter("@ExtraElements", string.Empty, SqlDbType.VarChar, ParameterDirection.Input, int.MaxValue));
}
#endregion
SQLDataService.Instance.ExecuteScalar(Contract, true, "REPORT", "spPhy_RPT_SavePatientNote", parms);
if (note.ProgramIds != null)
{
foreach (var prg in note.ProgramIds)
{
noteMap.Add(new EPatientNoteProgram
{
MongoId = prg.ToString(),
LastUpdatedOn = note.LastUpdatedOn,
UpdatedBy = note.UpdatedBy.ToString(),
RecordCreatedBy = note.RecordCreatedBy.ToString(),
PatientNoteMongoId = note.Id.ToString(),
RecordCreatedOn = note.RecordCreatedOn,
Version = Convert.ToInt32(note.Version)
});
}
}
}
catch (Exception ex)
{
OnDocColEvent(new ETLEventArgs {
Message = "[" + Contract + "] Error in Loading Patient Notes" + ex.Message + ": " + ex.StackTrace, IsError = true
});
}
}
#endregion
// Hydrate Program information from PatientNotes into it's own separate table - RPT_PatientNoteProgram
SaveSubcollection(noteMap);
}
catch (Exception ex)
{
throw ex;
}
}