public PatientNoteRepositoryFactory(string contract, string userid)
 {
     _contract = contract;
     _userId   = userid;
     _context  = new PatientNoteMongoContext(_contract);
 }
Example #2
0
        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;
            }
        }
Example #3
0
        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;
            }
        }