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;
}
