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