public void GetDepartmentsTest()
{
DepartmentAccessor accessor = new DepartmentAccessor();
List <Department> departments = accessor.GetDepartments();
foreach (Department d in departments)
{
Console.WriteLine("ID:{0}, Name:{1}, CityCode:{2}, Addresse:{3}, Phone{4}",
d.Id, d.Name, d.CityCode, d.Addresse, d.Phone);
}
}
public void CreateDepartmentTest()
{
DepartmentAccessor accessor = new DepartmentAccessor();
Department department = new Department
{
CityCode = 10,
Name = "LvDept",
Addresse = "Straus Str., 12",
Phone = "(065)6035282"
};
Guid id = accessor.CreateDepartment(department);
}
public void UpdateDepartmentTest()
{
DepartmentAccessor accessor = new DepartmentAccessor();
Department department = new Department
{
CityCode = 20,
Name = "KievDept",
Addresse = "Central st., 74",
Phone = "(050)2536789"
};
department.Id = accessor.CreateDepartment(department);
department.Phone = "(098)1212111";
accessor.UpdateDepartment(department);
}
partial void ListSelected(DbManagerProxy manager, List <LaboratorySectionItem> objs)
{
var lookupDepartment = DepartmentAccessor.SelectLookupList(manager, eidss.model.Core.EidssSiteContext.Instance.OrganizationID, null);
var lookupDiagnosis = DiagnosisAccessor.SelectLookupList(manager);
var lookupSampleStatus = SampleStatusFullAccessor.rftSampleStatus_SelectList(manager);
var lookupSampleType = SampleTypeAllAccessor.rftSampleType_SelectList(manager);
var lookupAccessionCondition = AccessionConditionAccessor.rftAccessionCondition_SelectList(manager);
var lookupTestName = TestNameRefAccessor.SelectLookupList(manager);
var lookupTestStatus = TestStatusFullAccessor.rftTestStatus_SelectList(manager);
var lookupTestResult = TestResultRefAccessor.SelectLookupList(manager);
var lookupTestCategory = TestCategoryRefAccessor.rftTestCategory_SelectList(manager);
var lookupRegion = eidss.model.Schema.RegionLookup.Accessor.Instance(m_CS).SelectLookupList(manager, null, null);
var lookupRayon = eidss.model.Schema.RayonLookup.Accessor.Instance(m_CS).SelectLookupList(manager, null, null);
objs.ForEach(o =>
{
o.strDepartmentName = !o.idfInDepartment.HasValue || o.idfInDepartment.Value == 0 ? "" : lookupDepartment.FirstOrDefault(i => i.idfDepartment == o.idfInDepartment, i => i.name);
o.strDiagnosisName = !o.idfsDiagnosis.HasValue || o.idfsDiagnosis.Value == 0 ? "" : lookupDiagnosis.FirstOrDefault(i => i.idfsDiagnosis == o.idfsDiagnosis, i => i.name);
o.strSampleStatus = o.idfsSampleStatus == -1 ? eidss.model.Resources.EidssFields.Get("Unaccessioned") : (o.idfsSampleStatus == 0 ? "" : lookupSampleStatus.FirstOrDefault(i => i.idfsBaseReference == o.idfsSampleStatus, i => i.name));
o.strSampleName = o.idfsSampleType == 0 ? "" : lookupSampleType.FirstOrDefault(i => i.idfsBaseReference == o.idfsSampleType, i => i.name);
o.strSampleConditionReceivedStatus = !o.idfsAccessionCondition.HasValue || o.idfsAccessionCondition.Value == 0 ? "" : lookupAccessionCondition.FirstOrDefault(i => i.idfsBaseReference == o.idfsAccessionCondition, i => i.name);
o.strTestName = !o.idfsTestName.HasValue || o.idfsTestName.Value == 0 ? "" : lookupTestName.FirstOrDefault(i => i.idfsReference == o.idfsTestName, i => i.name);
o.strTestStatus = o.idfsTestStatus == -1 ? eidss.model.Resources.EidssFields.Get("Deleted") : (!o.idfsTestStatus.HasValue || o.idfsTestStatus.Value == 0 ? "" : lookupTestStatus.FirstOrDefault(i => i.idfsBaseReference == o.idfsTestStatus, i => i.name));
o.strTestResult = !o.idfsTestResult.HasValue || o.idfsTestResult.Value == 0 ? "" : lookupTestResult.FirstOrDefault(i => i.idfsReference == o.idfsTestResult, i => i.name);
o.strTestCategory = !o.idfsTestCategory.HasValue || o.idfsTestCategory.Value == 0 ? "" : lookupTestCategory.FirstOrDefault(i => i.idfsBaseReference == o.idfsTestCategory, i => i.name);
o.strRegion = !o.idfsRegion.HasValue || o.idfsRegion.Value == 0 ? "" : lookupRegion.FirstOrDefault(i => i.idfsRegion == o.idfsRegion, i => i.strRegionName);
o.strRayon = !o.idfsRayon.HasValue || o.idfsRayon.Value == 0 ? "" : lookupRayon.FirstOrDefault(i => i.idfsRayon == o.idfsRayon, i => i.strRayonName);
o.HumanName =
(o.idfsCaseType == (long)CaseTypeEnum.Human && EidssUserContext.User.ForbiddenPersonalDataGroups.Contains(PersonalDataGroup.Human_PersonName))
||
(o.idfsCaseType != (long)CaseTypeEnum.Human && (EidssUserContext.User.ForbiddenPersonalDataGroups.Contains(PersonalDataGroup.Vet_Farm_Settlement) || EidssUserContext.User.ForbiddenPersonalDataGroups.Contains(PersonalDataGroup.Vet_Farm_Details)))
? "*******" : o.HumanName;
o.AcceptChanges();
});
objs.Sort(new LaboratorySectionItemComparator());
}
public DepartmentManager()
{
_departmentAccessor = new DepartmentAccessor();
}
