private void BuildSurgicalAudit(YellowstonePathology.Business.Test.Surgical.SurgicalTestOrder panelSetOrder, XElement panelSetOrderElement)
 {
     List<XElement> collectionElements = (from item in panelSetOrderElement.Elements("SurgicalAuditCollection")
                                          select item).ToList<XElement>();
     foreach (XElement surgicalAuditElement in collectionElements.Elements("SurgicalAudit"))
     {
         YellowstonePathology.Business.Test.Surgical.SurgicalAudit surgicalAudit = new YellowstonePathology.Business.Test.Surgical.SurgicalAudit();
         YellowstonePathology.Business.Persistence.XmlPropertyWriter xmlPropertyWriter = new YellowstonePathology.Business.Persistence.XmlPropertyWriter(surgicalAuditElement, surgicalAudit);
         xmlPropertyWriter.Write();
         BuildSurgicalSpecimenAuditResult(surgicalAudit, surgicalAuditElement);
         panelSetOrder.SurgicalAuditCollection.Add(surgicalAudit);
     }
 }
        private void WriteAssemblyQualifiedTypeSQL()
        {
            YellowstonePathology.Business.Test.Surgical.SurgicalTestOrder psos = new YellowstonePathology.Business.Test.Surgical.SurgicalTestOrder();
            Console.WriteLine(psos.GetType().AssemblyQualifiedName);

            YellowstonePathology.Business.Test.PanelSetOrderCPTCodeCollection psocptc = new Business.Test.PanelSetOrderCPTCodeCollection();
            Console.WriteLine(psocptc.GetType().AssemblyQualifiedName);

            YellowstonePathology.Business.Test.PanelSetOrderCPTCodeBill psocptb = new Business.Test.PanelSetOrderCPTCodeBill();
            Console.WriteLine(psocptb.GetType().AssemblyQualifiedName);

            YellowstonePathology.Business.Test.PanelSetOrderCPTCodeBillCollection psocptbc = new Business.Test.PanelSetOrderCPTCodeBillCollection();
            Console.WriteLine(psocptbc.GetType().AssemblyQualifiedName);

            YellowstonePathology.Business.Test.Surgical.SurgicalSpecimen ssr = new YellowstonePathology.Business.Test.Surgical.SurgicalSpecimen();
            Console.WriteLine(ssr.GetType().AssemblyQualifiedName);

            YellowstonePathology.Business.Test.Surgical.SurgicalSpecimenCollection ssrc = new YellowstonePathology.Business.Test.Surgical.SurgicalSpecimenCollection();
            Console.WriteLine(ssrc.GetType().AssemblyQualifiedName);

            YellowstonePathology.Business.Test.Surgical.IntraoperativeConsultationResult ic = new YellowstonePathology.Business.Test.Surgical.IntraoperativeConsultationResult();
            Console.WriteLine(ic.GetType().AssemblyQualifiedName);

            YellowstonePathology.Business.Test.Surgical.IntraoperativeConsultationResultCollection icc = new YellowstonePathology.Business.Test.Surgical.IntraoperativeConsultationResultCollection();
            Console.WriteLine(icc.GetType().AssemblyQualifiedName);

            YellowstonePathology.Business.Test.Surgical.SurgicalAudit sra = new YellowstonePathology.Business.Test.Surgical.SurgicalAudit();
            Console.WriteLine(sra.GetType().AssemblyQualifiedName);

            YellowstonePathology.Business.Test.Surgical.SurgicalAuditCollection srac = new YellowstonePathology.Business.Test.Surgical.SurgicalAuditCollection();
            Console.WriteLine(srac.GetType().AssemblyQualifiedName);

            YellowstonePathology.Business.Test.Surgical.SurgicalSpecimenAudit ssra = new YellowstonePathology.Business.Test.Surgical.SurgicalSpecimenAudit();
            Console.WriteLine(ssra.GetType().AssemblyQualifiedName);

            YellowstonePathology.Business.Test.Surgical.SurgicalSpecimenAuditCollection ssrac = new YellowstonePathology.Business.Test.Surgical.SurgicalSpecimenAuditCollection();
            Console.WriteLine(ssrac.GetType().AssemblyQualifiedName);

            YellowstonePathology.Business.SpecialStain.StainResultItem sri = new Business.SpecialStain.StainResultItem();
            Console.WriteLine(sri.GetType().AssemblyQualifiedName);

            YellowstonePathology.Business.SpecialStain.StainResultItemCollection sric = new Business.SpecialStain.StainResultItemCollection();
            Console.WriteLine(sric.GetType().AssemblyQualifiedName);

            YellowstonePathology.Business.Billing.Model.ICD9BillingCode icd = new Business.Billing.Model.ICD9BillingCode();
            Console.WriteLine(icd.GetType().AssemblyQualifiedName);

            YellowstonePathology.Business.Billing.Model.ICD9BillingCodeCollection icdc = new Business.Billing.Model.ICD9BillingCodeCollection();
            Console.WriteLine(icdc.GetType().AssemblyQualifiedName);

            YellowstonePathology.Business.Billing.Model.CptBillingCodeItem cpt = new Business.Billing.Model.CptBillingCodeItem();
            Console.WriteLine(cpt.GetType().AssemblyQualifiedName);

            YellowstonePathology.Business.Billing.Model.CptBillingCodeItemCollection cptc = new Business.Billing.Model.CptBillingCodeItemCollection();
            Console.WriteLine(cptc.GetType().AssemblyQualifiedName);

            //foreach (YellowstonePathology.Business.PanelSet.Model.PanelSet panelSet in panelSetCollection)
            //{
            //    Console.WriteLine("Update tblPanelSet set AssemblyQualifiedTypeName = '" + panelSet.GetType().AssemblyQualifiedName + "' where panelsetId = " + panelSet.PanelSetId);
            //}
        }