public SdRequestWorkDto AddRequestWork(SdRequestWorkDto work)
        {
            work.CreateDate = DateTime.Now;
            RequestWorkTDataAccess requestDa = new RequestWorkTDataAccess();

            requestDa.Insert(work);

            return(work);
        }
        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);
        }