Example #1
0
        private static List <WebservicePropertySet> getSingleWebservicePropertySet(WebservicePropertySet WebservicePropertySet)
        {
            List <WebservicePropertySet> webservicePropertySets = new List <WebservicePropertySet>();
            SysDataAccessCredential      dac = DAOUtility.GetSysCredentials();
            DataAccess das = new DataAccess();

            using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
            {
                conn.Open();
                SqlCommand command = new SqlCommand();
                command.Connection  = conn;
                command.CommandType = System.Data.CommandType.Text;
                command.CommandText = das.GET_SINGLE_WEBSERVICE_PROPERTY_SET;
                command.Parameters.AddWithValue(WebservicePropertySetDAO.AT_ID, WebservicePropertySet.id);
                try
                {
                    SqlDataReader reader = command.ExecuteReader();

                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            webservicePropertySets.Add(new WebservicePropertySet(reader));
                        }
                    }
                }
                catch (Exception e)
                {
                    ErrorLogger.LogError(e, "getSingleWebservicePropertySet(WebservicePropertySet WebservicePropertySet)", WebservicePropertySet.id.ToString());
                }
            }

            return(webservicePropertySets);
        }
Example #2
0
        private static bool deleteWebservicePropertySet(WebservicePropertySet WebservicePropertySet)
        {
            SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
            DataAccess das = new DataAccess();

            using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
            {
                conn.Open();

                SqlCommand command = new SqlCommand();
                command.Connection  = conn;
                command.CommandType = System.Data.CommandType.Text;
                command.CommandText = das.DELETE_WEBSERVICE_PROPERTY_SET;
                command.Parameters.AddWithValue(WebservicePropertySetDAO.AT_ID, WebservicePropertySet.id);

                try
                {
                    SqlDataReader reader = command.ExecuteReader();

                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            WebservicePropertySet.id = DAOUtility.GetData <int>(reader, WebservicePropertySetDAO.ID);
                        }
                    }
                }
                catch (Exception e)
                {
                    ErrorLogger.LogError(e, "DeleteWebservicePropertySet()", WebservicePropertySet.name);
                }
            }
            return(true);
        }
Example #3
0
        private static WSShieldsApps.Doctor getReadingDoctor(WebservicePropertySet wsProperty, string hl7Value, WSShieldsApps.Doctor radiologist)
        {
            switch (wsProperty.name)
            {
            case ShieldsExpressLinkDAO.PROPERTY_RADIOLOGIST_FIRST_NAME:
                radiologist.FirstName = hl7Value;
                break;

            case ShieldsExpressLinkDAO.PROPERTY_RADIOLOGIST_LAST_NAME:
                radiologist.LastName = hl7Value;
                break;

            case ShieldsExpressLinkDAO.PROPERTY_RADIOLOGIST_MIDDLE_NAME:
                radiologist.MiddleName = hl7Value;
                break;

            case ShieldsExpressLinkDAO.PROPERTY_RADIOLOGIST_NPI:
                radiologist.Npi = hl7Value;
                break;

            default:
                break;
            }

            return(radiologist);
        }
Example #4
0
        private static string getHL7ValueSEL(HL7Message message,
                                             List <MessageGroupInstance> messageGroupInstances,
                                             List <MessageGroup> messageGroups,
                                             WebservicePropertySet wsProperty
                                             )
        {
            // get the ms groups
            List <MessageGroup> msGroups
                = ConfigurationUtility.GetIncomingWebserviceMessageGroup(wsProperty, messageGroups);

            // get segment string type
            MessageGroupInstance messageGroupInstance
                = messageGroupInstances.Find(i => i.id == msGroups[ZERO].messageGroupInstanceId);

            // get the message position for this specific column
            List <Configuration> configMessagePoisition
                = ConfigurationDAO.GetMessagePosition(messageGroupInstance);

            // get the coordinates for the message item
            string messageCoordinates = HL7MessageUtility.getItemCoordinates(configMessagePoisition);

            // get segment string type
            string segmentType = configMessagePoisition[ZERO_ELEMENT].segmentType.name;

            // get the value for the database inside of the value position
            string hl7Value = HL7MessageUtility.getValueByPosition(
                message,
                HL7MessageUtility.getSegmentType(segmentType),
                messageCoordinates);

            return(hl7Value);
        }
Example #5
0
        private static WSShieldsApps.Patient getPatient(WebservicePropertySet wsProperty, string hl7Value, WSShieldsApps.Patient patient)
        {
            switch (wsProperty.name)
            {
            case ShieldsExpressLinkDAO.PROPERTY_PATIENT_FIRST_NAME:
                patient.FirstName = hl7Value;
                break;

            case ShieldsExpressLinkDAO.PROPERTY_PATIENT_LAST_NAME:
                patient.LastName = hl7Value;
                break;

            case ShieldsExpressLinkDAO.PROPERTY_PATIENT_MIDDLE_NAME:
                patient.MiddleName = hl7Value;
                break;

            case ShieldsExpressLinkDAO.PROPERTY_PATIENT_MEDICAL_RECORD_NO:
                patient.MedicalRecordNo = hl7Value;
                break;

            case ShieldsExpressLinkDAO.PROPERTY_PATIENT_DATE_OF_BIRTH:
                patient.DateOfBirth = hl7DateToRealDate(hl7Value);
                break;

            default:
                break;
            }

            return(patient);
        }
Example #6
0
        private static WSShieldsApps.Doctor getReferringDoctor(WebservicePropertySet wsProperty, string hl7Value, WSShieldsApps.Doctor referring)
        {
            switch (wsProperty.name)
            {
            case ShieldsExpressLinkDAO.PROPERTY_REFERRING_FIRST_NAME:
                referring.FirstName = hl7Value;
                break;

            case ShieldsExpressLinkDAO.PROPERTY_REFERRING_LAST_NAME:
                referring.LastName = hl7Value;
                break;

            case ShieldsExpressLinkDAO.PROPERTY_REFERRING_MIDDLE_NAME:
                referring.MiddleName = hl7Value;
                break;

            case ShieldsExpressLinkDAO.PROPERTY_REFERRING_NPI:
                referring.Npi = hl7Value;
                break;

            case ShieldsExpressLinkDAO.PROPERTY_REFERRING_SUFFIX:
                referring.Suffix = hl7Value;
                break;

            default:
                break;
            }

            return(referring);
        }
Example #7
0
        private static WSShieldsApps.Location getLocation(WebservicePropertySet wsProperty, string hl7Value, WSShieldsApps.Location referringLocation)
        {
            switch (wsProperty.name)
            {
            case ShieldsExpressLinkDAO.PROPERTY_LOCATION_STREET_ONE:
                referringLocation.StreetOne = hl7Value;
                break;

            case ShieldsExpressLinkDAO.PROPERTY_LOCATION_STREET_TWO:
                referringLocation.StreetTwo = hl7Value;
                break;

            case ShieldsExpressLinkDAO.PROPERTY_LOCATION_CITY:
                referringLocation.City = hl7Value;
                break;

            case ShieldsExpressLinkDAO.PROPERTY_LOCATION_STATE:
                referringLocation.State = hl7Value;
                break;

            case ShieldsExpressLinkDAO.PROPERTY_LOCATION_ZIP:
                referringLocation.ZipCode = hl7Value;
                break;

            default:
                break;
            }

            return(referringLocation);
        }
        public static List <MessageGroup> GetIncomingWebserviceMessageGroup(WebservicePropertySet webservicePropertySet, List <MessageGroup> messageGroups)
        {
            List <MessageGroup> tempGroups = new List <MessageGroup>();

            tempGroups = messageGroups;

            tempGroups = tempGroups.FindAll(m => m.messageGroupInstanceId == webservicePropertySet.messageGroupInstanceId);

            return(tempGroups);
        }
Example #9
0
        private static WSShieldsApps.Report getReport(WebservicePropertySet wsProperty, HL7Message message, string hl7Value, WSShieldsApps.Report report)
        {
            switch (wsProperty.name)
            {
            case ShieldsExpressLinkDAO.PROPERTY_REPORT_OBSERVATION_DATE:
                report.ObservationDate = hl7DateToRealDateTime(hl7Value);
                break;

            default:
                break;
            }
            return(report);
        }
Example #10
0
        private static WSShieldsApps.Organization getOrganization(WebservicePropertySet wsProperty, string hl7Value, WSShieldsApps.Organization organization)
        {
            switch (wsProperty.name)
            {
            case ShieldsExpressLinkDAO.PROPERTY_ORGANIZATION_NAME:
                organization.OrganizationName = hl7Value;
                break;

            default:
                break;
            }

            return(organization);
        }
Example #11
0
        private static WSShieldsApps.Exam getExam(WebservicePropertySet wsProperty, string hl7Value, WSShieldsApps.Exam exam)
        {
            switch (wsProperty.name)
            {
            case ShieldsExpressLinkDAO.PROPERTY_EXAM_ACCESSION_NO:
                exam.AccessionNo = hl7Value;
                break;

            case ShieldsExpressLinkDAO.PROPERTY_EXAM_CODE_NAME:
                exam.ExamCodeName = hl7Value;
                break;

            case ShieldsExpressLinkDAO.PROPERTY_EXAM_TYPE_NAME:
                exam.ExamTypeName = hl7Value;
                break;

            case ShieldsExpressLinkDAO.PROPERTY_EXAM_SIDE_NAME:
                exam.ExamSideName = hl7Value;
                break;

            case ShieldsExpressLinkDAO.PROPERTY_EXAM_STATUS_NAME:
                exam.ExamStatusName = hl7Value;
                break;

            case ShieldsExpressLinkDAO.PROPERTY_EXAM_DATE:
                exam.ExamDate = hl7DateToRealDateTime(hl7Value);
                break;

            case ShieldsExpressLinkDAO.PROPERTY_EXAM_DATE_REQUESTED:
                exam.DateRequested = hl7DateToRealDateTime(hl7Value);
                break;

            case ShieldsExpressLinkDAO.PROPERTY_SOURCE_OF_REFERRAL:
                exam.SourceOfReferralName = hl7Value;
                break;

            default:
                break;
            }

            return(exam);
        }
Example #12
0
        private static WebservicePropertySet postUpdateWebservicePropertySet(WebservicePropertySet webservicePropertySet)
        {
            SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
            DataAccess das = new DataAccess();

            using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
            {
                conn.Open();

                SqlCommand command = new SqlCommand();
                command.Connection  = conn;
                command.CommandType = System.Data.CommandType.StoredProcedure;
                command.CommandText = das.PUT_WEBSERVICE_PROPERTY;
                command.Parameters.AddWithValue(WebservicePropertySetDAO.AT_WEBSERVICE_OBJECT_ID, webservicePropertySet.webserviceObjectId);
                command.Parameters.AddWithValue(WebservicePropertySetDAO.AT_NAME, webservicePropertySet.name);
                command.Parameters.AddWithValue(WebservicePropertySetDAO.AT_MESSAGE_GROUP_INSTANCE_ID, webservicePropertySet.messageGroupInstanceId);
                command.Parameters.AddWithValue(WebservicePropertySetDAO.AT_COLUMN_DATA_TYPE, webservicePropertySet.columnDataType);
                command.Parameters.AddWithValue(WebservicePropertySetDAO.AT_ID, webservicePropertySet.id);

                try
                {
                    SqlDataReader reader = command.ExecuteReader();

                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            webservicePropertySet.id = DAOUtility.GetData <int>(reader, WebservicePropertySetDAO.ID);
                        }
                    }
                }
                catch (Exception e)
                {
                    ErrorLogger.LogError(e, "postUpdateWebservicePropertySet()", webservicePropertySet.name);
                }
            }
            return(webservicePropertySet);
        }
Example #13
0
 public static bool Delete(WebservicePropertySet webservicePropertySet)
 {
     return(deleteWebservicePropertySet(webservicePropertySet));
 }
Example #14
0
 public static WebservicePropertySet PostUpdate(WebservicePropertySet webservicePropertySet)
 {
     return(postUpdateWebservicePropertySet(webservicePropertySet));
 }
Example #15
0
 public static List <WebservicePropertySet> Get(WebservicePropertySet webservicePropertySet)
 {
     return(getSingleWebservicePropertySet(webservicePropertySet));
 }
Example #16
0
        public static void makeNewMessageGroups()
        {
            List <String> lines = new List <string>();

            lines = File.ReadAllLines(@"C:\Users\chrisb\Source\Repos\HL7Broker\HL7BrokerConsoleTest\NewMessageGroupForWebService.txt").ToList();

            lines.ForEach(delegate(String line) {
                // skip comments
                if (line.Contains("##"))
                {
                    return;
                }

                string[] elementSplit = line.Split('|');

                // gives the first part
                string[] tempMessageGroupInstance = elementSplit[0].Split(',');

                Console.WriteLine("Inserting Message Group Instance");
                MessageGroupInstance messageGroupInstance
                    = MessageGroupInstanceDAO.PostUpdate(new MessageGroupInstance()
                {
                    messageTypeId = Convert.ToInt32(tempMessageGroupInstance[0]),
                    segmentTypeId = Convert.ToInt32(tempMessageGroupInstance[1]),
                    description   = tempMessageGroupInstance[2]
                });

                if (messageGroupInstance.id != -1 || messageGroupInstance.id != 0)
                {
                    List <String> tempMessageGroup = elementSplit[1].Split(',').ToList();

                    tempMessageGroup.ForEach(delegate(String tempElement) {
                        Console.WriteLine("Inserting Message Group");

                        string[] tempInnerElement = tempElement.Split('^');

                        MessageGroupDAO.PostUpdate(new MessageGroup()
                        {
                            messageGroupInstanceId = messageGroupInstance.id,
                            messagePartId          = Convert.ToInt32(tempInnerElement[0]),
                            position = Convert.ToInt32(tempInnerElement[1])
                        });
                    });

                    Console.WriteLine("Inserting Message Group Property or Column Set");

                    // gives the first part
                    string[] tempColumnSet = elementSplit[2].Split(',');

                    /*
                     * ColumnSet columnSet = new ColumnSet()
                     * {
                     *  databaseTableId = Convert.ToInt32(tempColumnSet[0]),
                     *  name = tempColumnSet[1],
                     *  messageGroupInstanceId = messageGroupInstance.id,
                     *  isPrimaryKey = Convert.ToBoolean(tempColumnSet[2]),
                     *  columnDataType = tempColumnSet[3]
                     * };
                     *
                     * ColumnSetDAO.PostUpdate(columnSet);
                     */

                    WebservicePropertySet webservicePropertySet = new WebservicePropertySet()
                    {
                        webserviceObjectId = Convert.ToInt32(tempColumnSet[0]),
                        name = tempColumnSet[1],
                        messageGroupInstanceId = messageGroupInstance.id,
                        columnDataType         = tempColumnSet[2]
                    };

                    WebservicePropertySetDAO.PostUpdate(webservicePropertySet);
                }
            });
            Console.Read();
        }