public PersonDocument GetPersonDocument(int pt)
{
//return PersonDocumentRepository.Include(r => r.SalesOrder).Get().Where(i => i.SalesOrderDetailId == pt).FirstOrDefault();
//return _unitOfWork.Repository<PersonDocument>().Find(pt);
//return PersonDocumentRepository.Get().Where(i => i.PersonDocumentId == pt).FirstOrDefault();
return(PersonDocumentRepository.Include(r => r.Person).Get().Where(i => i.PersonDocumentID == pt).FirstOrDefault());
}
public ProductIncludedAccessories GetProductIncludedAccessories(int pt)
{
//return ProductIncludedAccessoriesRepository.Include(r => r.SalesOrder).Get().Where(i => i.SalesOrderDetailId == pt).FirstOrDefault();
//return _unitOfWork.Repository<ProductIncludedAccessories>().Find(pt);
//return ProductIncludedAccessoriesRepository.Get().Where(i => i.ProductIncludedAccessoriesId == pt).FirstOrDefault();
return(ProductIncludedAccessoriesRepository.Include(r => r.Product).Include(r => r.Accessory).Get().Where(i => i.ProductIncludedAccessoriesId == pt).FirstOrDefault());
}
public PersonContact GetPersonContact(int pt)
{
//return PersonContactRepository.Include(r => r.SalesOrder).Get().Where(i => i.SalesOrderDetailId == pt).FirstOrDefault();
//return _unitOfWork.Repository<PersonContact>().Find(pt);
//return PersonContactRepository.Get().Where(i => i.PersonContactId == pt).FirstOrDefault();
return(PersonContactRepository.Include(r => r.Person).Include(r => r.PersonContactType).Include(m => m.Contact).Get().Where(i => i.PersonContactID == pt).FirstOrDefault());
}
public IRepositoryQuery <EmployeeDTO> Get()
{
RepositoryQuery <EmployeeDTO> piEmployee = _employeeRepository
.Query()
.Include(c => c.Photo, c => c.StandPhoto, c => c.Address, c => c.ContactPerson,
c => c.ContactPerson.Address)
.Include(c => c.Education, c => c.Experience, c => c.Hawala, c => c.InsuranceProcess,
c => c.RequiredDocuments)
.Include(c => c.Agency, c => c.Agent)
.Filter(a => !string.IsNullOrEmpty(a.FirstName))
.OrderBy(q => q.OrderByDescending(c => c.Id));
if (_includeChilds)
{
piEmployee = piEmployee.Include(
c => c.CurrentComplain, c => c.CurrentComplain.Remarks, c => c.Complains,
c => c.Visa, c => c.Visa.Condition,
c => c.Visa.Sponsor, c => c.Visa.Sponsor.Address,
c => c.LabourProcess, c => c.EmbassyProcess, c => c.FlightProcess,
c => c.Visa.Agent, c => c.Visa.Agent.Address);
}
return(piEmployee);
}
public PersonRegistration GetPersonRegistration(int pt)
{
return(PersonRegistrationRepository.Include(r => r.Person).Get().Where(i => i.PersonRegistrationID == pt).FirstOrDefault());
}
public BuyerAccount GetBuyerAccount(int baId)
{
return(buyerAccountRepository.Include(r => r.Buyer).Get().Where(i => i.BuyerAccountID == baId).FirstOrDefault());
}
public ProductProcess GetProductProcess(int pt)
{
return(ProductProcessRepository.Include(r => r.Product).Get().Where(i => i.ProductProcessId == pt).FirstOrDefault());
}
public ProductGroup GetProductGroup(int pt)
{
return(ProductGroupRepository.Include(r => r.ProductType).Get().Where(i => i.ProductGroupId == pt).FirstOrDefault());
// return _unitOfWork.Repository<ProductGroup>().Find(pt);
}
public SalesOrder GetSalesOrder(int soId)
{
return(salesOrderRepository.Include(r => r.Buyer).Get().Where(i => i.SalesOrderId == soId).FirstOrDefault());
// return _unitOfWork.Repository<SalesOrder>().Find(soId);
}
public PersonAddress GetPersonAddress(int soId)
{
return(personAddressRepository.Include(r => r.Person).Include(r => r.City).Include(r => r.City.State).Include(r => r.City.State.Country).Get().Where(i => i.PersonAddressID == soId).FirstOrDefault());
}
