public static SampleInfo[] GetAll(SampleInfo filter)
{
using (DbManagerProxy manager = DbManagerFactory.Factory.Create(EidssUserContext.Instance))
{
return(LabSampleListItem.Accessor.Instance(null)
.SelectListT(manager, FilterAutoBuilder.BuildFilter(filter))
.Select(
c => new SampleInfo()
{
Id = c.idfMaterial,
SampleID = c.strBarcode,
FieldID = c.strFieldBarcode,
Type = new BaseReferenceItem()
{
Id = c.idfsSampleType, Name = c.SampleType != null ? c.SampleType.name : ""
},
CollectionDate = c.datFieldCollectionDate,
CaseID = c.CaseID,
//[FieldName("ParentBarcode")]
//ParentSampleID = c.str
AccessionDate = c.datAccession,
AnimalID = c.AnimalName
}
).ToArray());
}
}
public static List <eidss.openapi.contract.VetCaseListItem> Select(eidss.openapi.contract.VetCaseListFilter filter)
{
using (var manager = DbManagerFactory.Factory.Create(EidssUserContext.Instance))
{
var acc = VetCaseListItem.Accessor.Instance(null);
var fp = FilterAutoBuilder.BuildFilter(filter, VetCaseListFilterConverter.Instance);
var vcs = acc.SelectListT(manager, fp);
return(VetCaseListItemConverter.Instance.ToContract(manager, vcs));
}
}
public static List <eidss.openapi.contract.OrganizationListItem> Select(eidss.openapi.contract.OrganizationListFilter filter)
{
using (var manager = DbManagerFactory.Factory.Create(EidssUserContext.Instance))
{
var acc = eidss.model.Schema.OrganizationListItem.Accessor.Instance(null);
var fp = FilterAutoBuilder.BuildFilter(filter, OrganizationListFilterConverter.Instance);
var hcs = acc.SelectListT(manager, fp);
return(OrganizationListItemConverter.Instance.ToContract(manager, hcs));
}
}
public static TestInfo[] GetAll(TestInfo filter)
{
using (DbManagerProxy manager = DbManagerFactory.Factory.Create(EidssUserContext.Instance))
{
return(LabTestListItem.Accessor.Instance(null)
.SelectListT(manager, FilterAutoBuilder.BuildFilter(filter))
.Select(
c => new TestInfo()
{
Id = c.idfTesting,
Type = new BaseReferenceItem()
{
Id = c.idfsTestName, Name = c.TestName != null ? c.TestNameRef.name : ""
},
SampleID = c.strBarcode,
Category = new BaseReferenceItem()
{
Id = c.idfsTestCategory, Name = c.TestCategory != null ? c.TestCategoryRef.name : ""
},
Diagnosis = new BaseReferenceItem()
{
Id = c.idfsDiagnosis, Name = c.Diagnosis != null ? c.Diagnosis.name : ""
},
Status = new BaseReferenceItem()
{
Id = c.idfsTestStatus, Name = c.TestStatus != null ? c.TestStatus.name : ""
},
Result = new BaseReferenceItem()
{
Id = c.idfsTestResult, Name = c.TestResultRef != null ? c.TestResultRef.name : ""
},
PerformedDate = c.datPerformedDate,
PerformedByOffice = new BaseReferenceItem()
{
Id = 0, Name = ""
},
PerformedByPerson = "",
BatchID = c.BatchTestCode,
CaseID = c.CaseID
}
).ToArray());
}
//return GetAll("fnWebTestList",FilterAutoBuilder.BuildFilter(filter));
}
