public Common.DTOContainer.ServiceJobDtoContainer GetServiceJobTree() { PersonelTDataAccess pers = new PersonelTDataAccess(); ServiceJobDtoContainer container = new ServiceJobDtoContainer(); ServiceCategoryTDataAccess serviceCatDa = new ServiceCategoryTDataAccess(); ServiceCategoryJobTDataAccess serviceCategoryJobDa = new ServiceCategoryJobTDataAccess(); var serviceCategoris = serviceCatDa.GetAll(); var serviceCatJobs = serviceCategoryJobDa.GetAll(); var serviceJobs = this.dataAccess.GetAll(); container.ServiceCategoryDtos.AddRange(serviceCategoris); container.ServiceCategoryJobs.AddRange(serviceCatJobs); container.ServiceJobs.AddRange(serviceJobs); return(container); }
public BaseDataContainer GetWorkListByServiceCatJob(int serviceCatJobId, bool loadParents) { BaseDataTDataAccess da = new BaseDataTDataAccess(); ServiceCategoryJobTDataAccess scJobDa = new ServiceCategoryJobTDataAccess(); var scjob = scJobDa.GetSingle(it => it.ServiceCatJobId == serviceCatJobId); var serviceCatId = scjob.Servicecategoryid.Value; ServiceCategoryTDataAccess scDa = new ServiceCategoryTDataAccess(); var serviceCat = scDa.GetSingle(it => it.ServiceCatId == serviceCatId); List <SdWorkDto> workList = new List <SdWorkDto>(); workList = da.GetWorks(serviceCatId); if (loadParents) { if (serviceCat.Parentid.HasValue != null) { SdServiceCategoryDto temp = scDa.GetSingle(it => it.ServiceCatId == serviceCat.Parentid.Value); while (temp != null) { var tworkList = da.GetWorks(temp.ServiceCatId); if (tworkList != null) { workList.AddRange(tworkList); } if (temp.Parentid.HasValue) { temp = scDa.GetSingle(it => it.ServiceCatId == temp.Parentid.Value); } else { temp = null; } } } } BaseDataContainer container = new BaseDataContainer() { WorkList = workList }; return(container); }
public override IList <SdUserRequestDto> GetAll() { BaseDataTDataAccess baseDa = new BaseDataTDataAccess(); ServiceCategoryJobTDataAccess scatJobDa = new ServiceCategoryJobTDataAccess(); PersonelTDataAccess persDa = new PersonelTDataAccess(); var result = base.GetAll(); foreach (var item in result) { item.SdServiceCategoryJobDto = scatJobDa.GetServiceCatJob(item.Servicecategoryjobid ?? 0); item.CurrentCartableUser = GetCurrentCartablePersonId(item.SerReqId); item.OwnerUser = persDa.GetPersonId(item.Owneruserid ?? 0); item.CreatorUser = persDa.GetPersonId(item.Createuserid ?? 0); if (item.Currentstateid.HasValue) { var state = baseDa.GetState(item.Currentstateid.Value); item.CurrentState = state; } } return(result); }
public Common.DTOContainer.ServiceJobDtoContainer LoadServiveCategoryJobs(int serviceCategoryId) { ServiceJobDtoContainer container = new ServiceJobDtoContainer(); ServiceCategoryJobTDataAccess serviceCategoryJobDa = new ServiceCategoryJobTDataAccess(); var serviceCatJobs = serviceCategoryJobDa.GetAll(it => it.Servicecategoryid == serviceCategoryId); var serviceJobs = LoadServiceJobs(-1).ServiceJobs; foreach (var item in serviceJobs) { var serviceCat = serviceCatJobs.FirstOrDefault(it => it.Servicejobid == item.ServiceJobId); if (serviceCat != null) { serviceCat.ServiceJob = item; container.ServiceCategoryJobs.Add(serviceCat); } else { container.ServiceJobs.Add(item); } } return(container); }