public static Domain.OrderCommentLogCollection OrderCommentLogCollectionFromCaseNotesKeys(Domain.CaseNotesKeyCollection caseNotesKeyCollection) { Domain.OrderCommentLogCollection result = new Domain.OrderCommentLogCollection(); foreach (Domain.CaseNotesKey caseNotesKey in caseNotesKeyCollection) { SqlCommand cmd = new SqlCommand(); cmd.CommandType = System.Data.CommandType.Text; switch (caseNotesKey.CaseNotesKeyName) { case Domain.CaseNotesKeyNameEnum.MasterAccessionNo: cmd.CommandText = "SELECT * from tblOrderCommentLog where MasterAccessionNo = '" + caseNotesKey.Key + "' order by LogDate"; break; case Domain.CaseNotesKeyNameEnum.ClientOrderId: cmd.CommandText = "SELECT * from tblOrderCommentLog where ClientOrderId = '" + caseNotesKey.Key + "' order by LogDate"; break; case Domain.CaseNotesKeyNameEnum.ContainerId: cmd.CommandText = "SELECT * from tblOrderCommentLog where ContainerId = '" + caseNotesKey.Key + "' order by LogDate"; break; case Domain.CaseNotesKeyNameEnum.SpecimenLogId: cmd.CommandText = "SELECT * from tblOrderCommentLog where SpecimenLogId = " + caseNotesKey.Key + " order by LogDate"; break; } Domain.OrderCommentLogCollection midCollection1 = BuildOrderCommentLogCollection(cmd); foreach (Domain.OrderCommentLog orderCommentLog in midCollection1) { result.AddUnique(orderCommentLog); } } return result; }
public static Domain.OrderCommentLogCollection OrderCommentLogCollectionFromCaseNotesKeys(Domain.CaseNotesKeyCollection caseNotesKeyCollection) { Domain.OrderCommentLogCollection result = new Domain.OrderCommentLogCollection(); foreach (Domain.CaseNotesKey caseNotesKey in caseNotesKeyCollection) { SqlCommand cmd = new SqlCommand(); cmd.CommandType = System.Data.CommandType.Text; switch (caseNotesKey.CaseNotesKeyName) { case Domain.CaseNotesKeyNameEnum.MasterAccessionNo: cmd.CommandText = "SELECT * from tblOrderCommentLog where MasterAccessionNo = '" + caseNotesKey.Key + "' order by LogDate for xml Path('OrderCommentLog'), root('OrderCommentLogCollection')"; break; case Domain.CaseNotesKeyNameEnum.ClientOrderId: cmd.CommandText = "SELECT * from tblOrderCommentLog where ClientOrderId = '" + caseNotesKey.Key + "' order by LogDate for xml Path('OrderCommentLog'), root('OrderCommentLogCollection')"; break; case Domain.CaseNotesKeyNameEnum.ContainerId: cmd.CommandText = "SELECT * from tblOrderCommentLog where ContainerId = '" + caseNotesKey.Key + "' order by LogDate for xml Path('OrderCommentLog'), root('OrderCommentLogCollection')"; break; case Domain.CaseNotesKeyNameEnum.SpecimenLogId: cmd.CommandText = "SELECT * from tblOrderCommentLog where SpecimenLogId = " + caseNotesKey.Key + " order by LogDate for xml Path('OrderCommentLog'), root('OrderCommentLogCollection')"; break; } XElement xelement = Domain.Persistence.SqlXmlPersistence.CrudOperations.ExecuteXmlReaderCommand(cmd, Domain.Persistence.DataLocationEnum.ProductionData); Domain.OrderCommentLogCollection midCollection = BuildOrderCommentLogCollection(xelement); foreach (Domain.OrderCommentLog orderCommentLog in midCollection) { result.AddUnique(orderCommentLog); } } return result; }
public static Domain.OrderCommentLogCollection OrderCommentLogCollectionFromCaseNotesKeys(Domain.CaseNotesKeyCollection caseNotesKeyCollection) { Domain.OrderCommentLogCollection result = new Domain.OrderCommentLogCollection(); foreach (Domain.CaseNotesKey caseNotesKey in caseNotesKeyCollection) { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; switch (caseNotesKey.CaseNotesKeyName) { case Domain.CaseNotesKeyNameEnum.MasterAccessionNo: cmd.CommandText = "SELECT * from tblOrderCommentLog where MasterAccessionNo = '" + caseNotesKey.Key + "' order by LogDate;"; break; case Domain.CaseNotesKeyNameEnum.ClientOrderId: cmd.CommandText = "SELECT * from tblOrderCommentLog where ClientOrderId = '" + caseNotesKey.Key + "' order by LogDate;"; break; case Domain.CaseNotesKeyNameEnum.ContainerId: cmd.CommandText = "SELECT * from tblOrderCommentLog where ContainerId = '" + caseNotesKey.Key + "' order by LogDate;"; break; case Domain.CaseNotesKeyNameEnum.SpecimenLogId: cmd.CommandText = "SELECT * from tblOrderCommentLog where SpecimenLogId = " + caseNotesKey.Key + " order by LogDate;"; break; } Domain.OrderCommentLogCollection midCollection1 = BuildOrderCommentLogCollection(cmd); foreach (Domain.OrderCommentLog orderCommentLog in midCollection1) { result.AddUnique(orderCommentLog); } } return(result); }
public static Domain.OrderCommentLogCollection OrderCommentLogCollectionFromCaseNotesKeys(Domain.CaseNotesKeyCollection caseNotesKeyCollection) { Domain.OrderCommentLogCollection result = new Domain.OrderCommentLogCollection(); foreach (Domain.CaseNotesKey caseNotesKey in caseNotesKeyCollection) { SqlCommand cmd = new SqlCommand(); cmd.CommandType = System.Data.CommandType.Text; switch (caseNotesKey.CaseNotesKeyName) { case Domain.CaseNotesKeyNameEnum.MasterAccessionNo: cmd.CommandText = "SELECT * from tblOrderCommentLog where MasterAccessionNo = '" + caseNotesKey.Key + "' order by LogDate for xml Path('OrderCommentLog'), root('OrderCommentLogCollection')"; break; case Domain.CaseNotesKeyNameEnum.ClientOrderId: cmd.CommandText = "SELECT * from tblOrderCommentLog where ClientOrderId = '" + caseNotesKey.Key + "' order by LogDate for xml Path('OrderCommentLog'), root('OrderCommentLogCollection')"; break; case Domain.CaseNotesKeyNameEnum.ContainerId: cmd.CommandText = "SELECT * from tblOrderCommentLog where ContainerId = '" + caseNotesKey.Key + "' order by LogDate for xml Path('OrderCommentLog'), root('OrderCommentLogCollection')"; break; case Domain.CaseNotesKeyNameEnum.SpecimenLogId: cmd.CommandText = "SELECT * from tblOrderCommentLog where SpecimenLogId = " + caseNotesKey.Key + " order by LogDate for xml Path('OrderCommentLog'), root('OrderCommentLogCollection')"; break; } XElement xelement = Domain.Persistence.SqlXmlPersistence.CrudOperations.ExecuteXmlReaderCommand(cmd, Domain.Persistence.DataLocationEnum.ProductionData); Domain.OrderCommentLogCollection midCollection = BuildOrderCommentLogCollection(xelement); foreach (Domain.OrderCommentLog orderCommentLog in midCollection) { result.AddUnique(orderCommentLog); } } return(result); }