public BaseDataContainer GetDeviceList(int perid, int objTypeId) { BaseDataContainer container = new BaseDataContainer(); PersonelTDataAccess pDa = new PersonelTDataAccess(); var lst = pDa.GetDeviceList(perid, objTypeId); container.DeviceList = lst; return(container); }
public Common.DTOContainer.PersonelDtoContainer GetPersonelList(int chartId) { PersonelTDataAccess da = new PersonelTDataAccess(); PersonelDtoContainer container = new PersonelDtoContainer(); var personels = da.GetPersonel(chartId); container.PersonelDtoList.AddRange(personels); return(container); }
public PersonelDtoContainer GetPersonelListByIndependentId(int independentId) { PersonelTDataAccess da = new PersonelTDataAccess(); PersonelDtoContainer container = new PersonelDtoContainer(); var personels = da.GetPersonelByIndependentId(independentId); container.PersonelDtoList.AddRange(personels); return(container); }
private VwPersonelDto GetCurrentCartablePersonId(int requestId) { BaseDataTDataAccess baseDa = new BaseDataTDataAccess(); var currentCartable = baseDa.GetRequestLatestCycle(requestId); if (currentCartable != null) { PersonelTDataAccess persDa = new PersonelTDataAccess(); int perId = currentCartable.ReceiverPerId; var person = persDa.GetPersonId(perId); return(person); } return(null); }
public Common.DTOContainer.OfficeDtoContainer GetExpertList() { OfficeDtoContainer container = new OfficeDtoContainer(); ExpertTDataAccess exDa = new ExpertTDataAccess(); var experts = exDa.GetAll(); PersonelTDataAccess pda = new PersonelTDataAccess(); foreach (var item in experts) { item.Personel = pda.GetSingle(it => it.PerId == item.Userid); } container.ExpertList.AddRange(experts); return(container); }
public DeviceDto GetDevice(int transferId) { DeviceDto result = new DeviceDto(); PersonelTDataAccess pDa = new PersonelTDataAccess(); var lst = pDa.GetDeviceList(transferId); if (lst.Count > 0) { result = lst.FirstOrDefault(); } else { result.Response.AddBusinessException("there is no device", BusinessExceptionEnum.Validation); } return(result); }
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 Common.DTOContainer.OfficeDtoContainer GetRoleExperts(int roleId) { ExpertTDataAccess exDa = new ExpertTDataAccess(); SdRoleTDataAccess da = new SdRoleTDataAccess(); PersonelTDataAccess pDa = new PersonelTDataAccess(); var role = da.GetSingle(it => it.RoleId == roleId); OfficeDtoContainer container = new OfficeDtoContainer(); var dtoList = da.GetSdRoles(roleId); foreach (var dto in dtoList) { dto.Role = role; var expert = exDa.GetSingle(it => it.ItExpertId == dto.Expertid); dto.Expert = expert; var personel = pDa.GetSingle(it => it.PerId == expert.Userid); dto.Personel = personel; } container.RoleExperts.AddRange(dtoList); 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 UserRequestDtoContainer GetRequestWorkList(int requestId) { UserRequestDtoContainer container = new UserRequestDtoContainer(); PersonelTDataAccess pda = new PersonelTDataAccess(); RequestWorkTDataAccess requestDa = new RequestWorkTDataAccess(); BaseDataTDataAccess baseDa = new BaseDataTDataAccess(); var dtoList = requestDa.GetAll(it => it.RequestId == requestId); var wList = baseDa.GetWorks(); foreach (var item in dtoList) { var pers = pda.GetPersonId(item.UserId ?? 0); item.Work = wList.Where(it => it.WorkId == item.SdWorkId).FirstOrDefault(); item.User = pers; } if (dtoList != null) { container.SdRequestWorkDtolist.AddRange(dtoList); } return(container); }
public Common.DTO.VwPersonelDto GetPersonId(int perId) { PersonelTDataAccess da = new PersonelTDataAccess(); return(da.GetPersonId(perId)); }