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