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 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 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 BaseDataContainer GetObjectTypeList() { BaseDataTDataAccess da = new BaseDataTDataAccess(); return(da.GetObjectTypeList()); }
public Common.DTOContainer.BaseDataContainer GetRoleList() { BaseDataTDataAccess da = new BaseDataTDataAccess(); return(da.GetRoleList()); }