public static Flow.FlowMarkerCollection GetFlowMarkerCollectionByReportNo(string reportNo) { YellowstonePathology.Business.Flow.FlowMarkerCollection result = new YellowstonePathology.Business.Flow.FlowMarkerCollection(); YellowstonePathology.Business.Mongo.Server transferServer = new Business.Mongo.TestServer(YellowstonePathology.Business.Mongo.MongoTestServer.LISDatabaseName); MongoCollection collection = transferServer.Database.GetCollection <BsonDocument>("FlowMarkers"); MongoCursor cursor = collection.FindAs <BsonDocument>(Query.EQ("ReportNo", BsonValue.Create(reportNo))); List <BsonValue> markerNames = new List <BsonValue>(); foreach (BsonDocument bsonDocument in cursor) { markerNames.Add(bsonDocument.GetValue("Name")); } MongoCollection markerCollection = transferServer.Database.GetCollection <BsonDocument>("Markers"); MongoCursor markerCursor = markerCollection.FindAs <BsonDocument>(Query.In("MarkerName", markerNames)).SetSortOrder(SortBy.Ascending("OrderFlag", "MarkerName")); foreach (BsonDocument bsonDocument in cursor) { foreach (BsonDocument markerDocument in markerCursor) { if (bsonDocument.GetValue("Name").Equals(markerDocument.GetValue("MarkerName"))) { YellowstonePathology.Business.Flow.FlowMarkerItem flowMarkerItem = new Flow.FlowMarkerItem(); YellowstonePathology.Business.Mongo.BSONPropertyWriter.Write(bsonDocument, flowMarkerItem); result.Add(flowMarkerItem); break; } } } return(result); }
public override void Build(YellowstonePathology.Business.Test.PanelSetOrder panelSetOrder, System.Xml.Linq.XElement panelSetOrderElement) { Test.LLP.PanelSetOrderLeukemiaLymphoma llpPanelSetOrder = (Test.LLP.PanelSetOrderLeukemiaLymphoma)panelSetOrder; List<XElement> markerElements = (from item in panelSetOrderElement.Elements("FlowMarkerCollection") select item).ToList<XElement>(); llpPanelSetOrder.FlowMarkerCollection.RemoveDeleted(markerElements.Elements("FlowMarker")); Flow.FlowMarkerItem flowMarker = null; foreach (XElement markerElement in markerElements.Elements("FlowMarker")) { string flowMarkerId = markerElement.Element("FlowMarkerId").Value; if (llpPanelSetOrder.FlowMarkerCollection.Exists(flowMarkerId) == true) { flowMarker = llpPanelSetOrder.FlowMarkerCollection.Get(flowMarkerId); } else { flowMarker = new Flow.FlowMarkerItem(); llpPanelSetOrder.FlowMarkerCollection.Add(flowMarker); } YellowstonePathology.Business.Persistence.XmlPropertyWriter xmlPropertyWriter = new YellowstonePathology.Business.Persistence.XmlPropertyWriter(markerElement, flowMarker); xmlPropertyWriter.Write(); } }
public static Flow.FlowMarkerCollection GetFlowMarkerCollectionByPanelId(string reportNo, int panelId) { Flow.FlowMarkerCollection result = new Flow.FlowMarkerCollection(); MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "Select @ReportNo as ReportNo, mp.MarkerName as Name, mp.Intensity, mp.Interpretation, 'true' as MarkerUsed " + "from tblFlowMarkerPanel mp left outer join tblMarkers m on mp.MarkerName = m.MarkerName where PanelId = @PanelId " + "order by m.OrderFlag, m.MarkerName;"; cmd.Parameters.AddWithValue("@ReportNo", reportNo); cmd.Parameters.AddWithValue("@PanelId", panelId); using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString)) { cn.Open(); cmd.Connection = cn; using (MySqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { Flow.FlowMarkerItem flowMarkerItem = new Flow.FlowMarkerItem(); Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(flowMarkerItem, dr); sqlDataReaderPropertyWriter.WriteProperties(); result.Add(flowMarkerItem); } } } return(result); }
private static Flow.FlowMarkerItem BuildFlowMarkerItem(XElement sourceElement) { Flow.FlowMarkerItem flowMarkerItem = new Flow.FlowMarkerItem(); if (sourceElement != null) { YellowstonePathology.Business.Persistence.XmlPropertyWriter xmlPropertyWriter = new YellowstonePathology.Business.Persistence.XmlPropertyWriter(sourceElement, flowMarkerItem); xmlPropertyWriter.Write(); } return(flowMarkerItem); }
public override void Build(Test.PanelSetOrder panelSetOrder, System.Xml.Linq.XElement panelSetOrderElement) { List<XElement> markerElements = (from item in panelSetOrderElement.Elements("FlowMarkerCollection") select item).ToList<XElement>(); foreach (XElement markerElement in markerElements.Elements("FlowMarker")) { Flow.FlowMarkerItem flowMarkerItem = new Flow.FlowMarkerItem(); YellowstonePathology.Business.Persistence.XmlPropertyWriter xmlPropertyWriter = new YellowstonePathology.Business.Persistence.XmlPropertyWriter(markerElement, flowMarkerItem); xmlPropertyWriter.Write(); ((Test.LLP.PanelSetOrderLeukemiaLymphoma)panelSetOrder).FlowMarkerCollection.Add(flowMarkerItem); } }
public override void Build(Test.PanelSetOrder panelSetOrder, System.Xml.Linq.XElement panelSetOrderElement) { List <XElement> markerElements = (from item in panelSetOrderElement.Elements("FlowMarkerCollection") select item).ToList <XElement>(); foreach (XElement markerElement in markerElements.Elements("FlowMarker")) { Flow.FlowMarkerItem flowMarkerItem = new Flow.FlowMarkerItem(); YellowstonePathology.Business.Persistence.XmlPropertyWriter xmlPropertyWriter = new YellowstonePathology.Business.Persistence.XmlPropertyWriter(markerElement, flowMarkerItem); xmlPropertyWriter.Write(); ((Test.LLP.PanelSetOrderLeukemiaLymphoma)panelSetOrder).FlowMarkerCollection.Add(flowMarkerItem); } }
private static Flow.FlowMarkerCollection BuildFlowMarkerCollection(XElement sourceElement) { Flow.FlowMarkerCollection flowMarkerCollection = new Flow.FlowMarkerCollection(); if (sourceElement != null) { foreach (XElement flowMarkerItemElement in sourceElement.Elements("FlowMarkerItem")) { Flow.FlowMarkerItem flowMarkerItem = BuildFlowMarkerItem(flowMarkerItemElement); flowMarkerCollection.Add(flowMarkerItem); } } return(flowMarkerCollection); }
public static Flow.FlowMarkerCollection GetFlowMarkerCollectionByPanelId(string reportNo, int panelId) { YellowstonePathology.Business.Flow.FlowMarkerCollection result = new YellowstonePathology.Business.Flow.FlowMarkerCollection(); YellowstonePathology.Business.Mongo.Server transferServer = new Business.Mongo.TestServer(YellowstonePathology.Business.Mongo.MongoTestServer.LISDatabaseName); MongoCollection collection = transferServer.Database.GetCollection <BsonDocument>("FlowMarkerPanel"); MongoCursor cursor = collection.FindAs <BsonDocument>(Query.EQ("PanelId", BsonValue.Create(panelId))); List <BsonValue> markerNames = new List <BsonValue>(); foreach (BsonDocument bsonDocument in cursor) { markerNames.Add(bsonDocument.GetValue("MarkerName")); } MongoCollection markerCollection = transferServer.Database.GetCollection <BsonDocument>("Markers"); MongoCursor markerCursor = markerCollection.FindAs <BsonDocument>(Query.In("MarkerName", markerNames)).SetSortOrder(SortBy.Ascending("OrderFlag", "MarkerName")); foreach (BsonDocument bsonDocument in cursor) { foreach (BsonDocument markerDocument in markerCursor) { if (bsonDocument.GetValue("MarkerName").Equals(markerDocument.GetValue("MarkerName"))) { YellowstonePathology.Business.Flow.FlowMarkerItem flowMarkerItem = new Flow.FlowMarkerItem(); flowMarkerItem.Name = bsonDocument.GetValue("MarkerName").AsString; flowMarkerItem.MarkerUsed = true; flowMarkerItem.Intensity = Mongo.ValueHelper.GetStringValue(bsonDocument.GetValue("Intensity")); flowMarkerItem.Interpretation = Mongo.ValueHelper.GetStringValue(bsonDocument.GetValue("Interpretation")); result.Add(flowMarkerItem); break; } } } return(result); }
private static Flow.FlowMarkerItem BuildFlowMarkerItem(XElement sourceElement) { Flow.FlowMarkerItem flowMarkerItem = new Flow.FlowMarkerItem(); if (sourceElement != null) { YellowstonePathology.Business.Persistence.XmlPropertyWriter xmlPropertyWriter = new YellowstonePathology.Business.Persistence.XmlPropertyWriter(sourceElement, flowMarkerItem); xmlPropertyWriter.Write(); } return flowMarkerItem; }
public static Flow.FlowMarkerCollection GetFlowMarkerCollectionByReportNo(string reportNo) { YellowstonePathology.Business.Flow.FlowMarkerCollection result = new YellowstonePathology.Business.Flow.FlowMarkerCollection(); YellowstonePathology.Business.Mongo.Server transferServer = new Business.Mongo.TestServer(YellowstonePathology.Business.Mongo.MongoTestServer.LISDatabaseName); MongoCollection collection = transferServer.Database.GetCollection<BsonDocument>("FlowMarkers"); MongoCursor cursor = collection.FindAs<BsonDocument>(Query.EQ("ReportNo", BsonValue.Create(reportNo))); List<BsonValue> markerNames = new List<BsonValue>(); foreach (BsonDocument bsonDocument in cursor) { markerNames.Add(bsonDocument.GetValue("Name")); } MongoCollection markerCollection = transferServer.Database.GetCollection<BsonDocument>("Markers"); MongoCursor markerCursor = markerCollection.FindAs<BsonDocument>(Query.In("MarkerName", markerNames)).SetSortOrder(SortBy.Ascending("OrderFlag", "MarkerName")); foreach (BsonDocument bsonDocument in cursor) { foreach (BsonDocument markerDocument in markerCursor) { if(bsonDocument.GetValue("Name").Equals(markerDocument.GetValue("MarkerName"))) { YellowstonePathology.Business.Flow.FlowMarkerItem flowMarkerItem = new Flow.FlowMarkerItem(); YellowstonePathology.Business.Mongo.BSONPropertyWriter.Write(bsonDocument, flowMarkerItem); result.Add(flowMarkerItem); break; } } } return result; }
public static Flow.FlowMarkerCollection GetFlowMarkerCollectionByPanelId(string reportNo, int panelId) { YellowstonePathology.Business.Flow.FlowMarkerCollection result = new YellowstonePathology.Business.Flow.FlowMarkerCollection(); YellowstonePathology.Business.Mongo.Server transferServer = new Business.Mongo.TestServer(YellowstonePathology.Business.Mongo.MongoTestServer.LISDatabaseName); MongoCollection collection = transferServer.Database.GetCollection<BsonDocument>("FlowMarkerPanel"); MongoCursor cursor = collection.FindAs<BsonDocument>(Query.EQ("PanelId", BsonValue.Create(panelId))); List<BsonValue> markerNames = new List<BsonValue>(); foreach (BsonDocument bsonDocument in cursor) { markerNames.Add(bsonDocument.GetValue("MarkerName")); } MongoCollection markerCollection = transferServer.Database.GetCollection<BsonDocument>("Markers"); MongoCursor markerCursor = markerCollection.FindAs<BsonDocument>(Query.In("MarkerName", markerNames)).SetSortOrder(SortBy.Ascending("OrderFlag", "MarkerName")); foreach (BsonDocument bsonDocument in cursor) { foreach (BsonDocument markerDocument in markerCursor) { if (bsonDocument.GetValue("MarkerName").Equals(markerDocument.GetValue("MarkerName"))) { YellowstonePathology.Business.Flow.FlowMarkerItem flowMarkerItem = new Flow.FlowMarkerItem(); flowMarkerItem.Name = bsonDocument.GetValue("MarkerName").AsString; flowMarkerItem.MarkerUsed = true; flowMarkerItem.Intensity = Mongo.ValueHelper.GetStringValue(bsonDocument.GetValue("Intensity")); flowMarkerItem.Interpretation = Mongo.ValueHelper.GetStringValue(bsonDocument.GetValue("Interpretation")); result.Add(flowMarkerItem); break; } } } return result; }