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