Esempio n. 1
0
        public static Surgical.PathologistHistoryList GetPathologistPatientHistory(string patientId)
        {
            Surgical.PathologistHistoryList result = new Surgical.PathologistHistoryList();
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = "prcGetPatientHistory_5";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@PatientId", SqlDbType.VarChar).Value = patientId;

            using (SqlConnection cn = new SqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
            {
                cn.Open();
                cmd.Connection = cn;
                using (SqlDataReader dr = cmd.ExecuteReader())
                {
                    while (dr.Read())
                    {
                        Surgical.PathologistHistoryItem pathologistHistoryItem = new Surgical.PathologistHistoryItem();
                        Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(pathologistHistoryItem, dr);
                        sqlDataReaderPropertyWriter.WriteProperties();
                        result.Add(pathologistHistoryItem);
                    }
                    dr.NextResult();
                    while (dr.Read())
                    {
                        Surgical.PathologistHistoryItemListItem pathologistHistoryItemListItem = new Surgical.PathologistHistoryItemListItem();
                        Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(pathologistHistoryItemListItem, dr);
                        sqlDataReaderPropertyWriter.WriteProperties();
                        foreach(Surgical.PathologistHistoryItem pathologistHistoryItem in result)
                        {
                            if(pathologistHistoryItemListItem.ReportNo == pathologistHistoryItem.ReportNo)
                            {
                                pathologistHistoryItem.PathologistHistoryItemList.Add(pathologistHistoryItemListItem);
                                break;
                            }
                        }
                    }
                }
            }
            return result;
        }
        public static Surgical.PathologistHistoryList GetPathologistPatientHistory(string patientId)
        {
            Surgical.PathologistHistoryList result = new Surgical.PathologistHistoryList();
            StringBuilder xmlString = new StringBuilder();
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = "prcGetPatientHistory_4";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@PatientId", SqlDbType.VarChar).Value = patientId;

            using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.Properties.Settings.Default.CurrentConnectionString))
            {
                cn.Open();
                cmd.Connection = cn;
                using (XmlReader xmlReader = cmd.ExecuteXmlReader())
                {
                    while (xmlReader.Read())
                    {
                        xmlString.Append(xmlReader.ReadOuterXml());
                    }
                }
            }

            if (xmlString.Length != 0)
            {
                XElement resultElements = XElement.Parse(xmlString.ToString(), LoadOptions.PreserveWhitespace);
                List<XElement> pathologistHistoryItemElements = (from item in resultElements.Elements("PathologistHistoryItem")
                                                                 select item).ToList<XElement>();
                foreach (XElement pathologistHistoryElement in pathologistHistoryItemElements)
                {
                    YellowstonePathology.Business.Surgical.PathologistHistoryItem pathologistHistory = new Surgical.PathologistHistoryItem();
                    YellowstonePathology.Business.Persistence.XmlPropertyWriter xmlPropertyWriter = new Persistence.XmlPropertyWriter(pathologistHistoryElement, pathologistHistory);
                    xmlPropertyWriter.Write();

                    List<XElement> pathologistHistoryItemListElements = (from item in pathologistHistoryElement.Elements("PathologistHistoryItemList")
                                                                         select item).ToList<XElement>();
                    foreach (XElement pathologistHistoryItemListElement in pathologistHistoryItemListElements)
                    {
                        List<XElement> pathologistHistoryItemListItemElements = (from item in pathologistHistoryItemListElement.Elements("PathologistHistoryItemListItem")
                                                                                 select item).ToList<XElement>();
                        foreach (XElement pathologistHistoryItemListItemElement in pathologistHistoryItemListItemElements)
                        {
                            YellowstonePathology.Business.Surgical.PathologistHistoryItemListItem pathologistHistoryItemListItem = new Surgical.PathologistHistoryItemListItem();
                            YellowstonePathology.Business.Persistence.XmlPropertyWriter xmlPropertyWriter1 = new Persistence.XmlPropertyWriter(pathologistHistoryItemListItemElement, pathologistHistoryItemListItem);
                            xmlPropertyWriter1.Write();

                            pathologistHistory.PathologistHistoryItemList.Add(pathologistHistoryItemListItem);
                        }
                    }
                    result.Add(pathologistHistory);
                }
            }

            return result;
        }