public SdServiceCategoryJobDto GetServiceCatJob(int id) { ServiceCategoryTDataAccess scatDa = new ServiceCategoryTDataAccess(); ServiceJobTDataAccess sJobDa = new ServiceJobTDataAccess(); var scatJob = this.GetSingle(it => it.ServiceCatJobId == id); if (scatJob != null) { scatJob.ServiceCategory = scatDa.GetSingle(it => it.ServiceCatId == scatJob.Servicecategoryid); scatJob.ServiceJob = sJobDa.GetSingle(it => it.ServiceJobId == scatJob.Servicejobid); } return(scatJob); }