public Domain.Model.Device Handle(DeviceQuery query) { Device device = _entities.Query <Device>() .Where(p => p.ID == query.DeviceID).Single <Device>(); Domain.Model.Device model = new Model.Device(device.ID, device.SerialNo, device.Room.Department.Site.SiteName, device.Room.Department.HospitalDepartment.HospitalDepartmentName, device.Room.RoomNo, device.SubModality.Modality.ModalityName, device.SubModality.Modality.ID, device.SubModality.SubModalityName, device.ProductLine.Supplier.SupplierName, device.ProductLine.ProductLineName, device.ProductLine.ProductLineName + " " + device.SerialNo ); return(model); }
public IEnumerable <Domain.Model.Device> Handle(DevicesQuery query) { IEnumerable <Device> devices = _entities.Query <Device>() .Where(p => (!query.roomID.HasValue || p.roomID == query.roomID) && (!query.deviceTypeID.HasValue || p.deviceTypeID == query.deviceTypeID) && (query.modalityID == null || p.SubModality.ID == query.modalityID) && (query.subModalityID == null || p.submodalityID == query.subModalityID) && (!query.productLineID.HasValue || p.ProductLineID == query.productLineID) ).AsEnumerable(); List <Domain.Model.Device> models = new List <Domain.Model.Device>(); foreach (Device device in devices) { Domain.Model.Device model = new Model.Device(device.ID, device.SerialNo, device.Room.Department.Site.SiteName, device.Room.Department.HospitalDepartment.HospitalDepartmentName, device.Room.RoomNo, device.SubModality.Modality.ModalityName, device.SubModality.Modality.ID, device.SubModality.SubModalityName, device.ProductLine.Supplier.SupplierName, device.ProductLine.ProductLineName, device.ProductLine.ProductLineName + " " + device.SerialNo ); models.Add(model); } return(models); }
public Domain.Model.SourceQuote Handle(SourceQuoteQuery query) { SourceQuote entity = _entities.Query <SourceQuote>() .Where(p => p.Ref.ToLower() == query.QuoteRef.ToLower() ).FirstOrDefault <SourceQuote>(); List <Domain.Model.SourceQuote> models = new List <Domain.Model.SourceQuote>(); if (entity == null) { return(null); } else { Domain.Model.SourceQuote model = new Domain.Model.SourceQuote() { Date = entity.Date, DeviceID = entity.DeviceID, DeviceDescription = entity.DeviceID.ToString(), QuoteRef = entity.Ref, Supplier = entity.Supplier.SupplierName, SellingPriceInclVAT = entity.SellingPriceInclVAT, VAT = entity.VAT, TenderNumber = entity.TenderNumber, ROE = entity.ROE, ROEDate = entity.ROEDate }; return(model); } }
public Quote Handle(QuoteQuery query) { return(_entities.Query <Quote>().FirstOrDefault(p => (p.ID == query.ID || query.ID == 0) && (p.QuoteRef == query.QuoteRef || string.IsNullOrEmpty(query.QuoteRef)) && (p.BaseContractID == query.BaseContractID || query.BaseContractID == 0) )); }
public IEnumerable <EWS.Domain.Model.SourceQuote> Handle(SourceQuotesQuery query) { IEnumerable <SourceQuote> dataList = _entities.Query <SourceQuote>() .Where(p => query.QuoteRef == null || p.Ref.ToLower().Contains(query.QuoteRef.ToLower()) ).AsEnumerable(); List <Domain.Model.SourceQuote> models = new List <Domain.Model.SourceQuote>(); foreach (SourceQuote item in dataList) { Domain.Model.SourceQuote model = new Domain.Model.SourceQuote() { Date = item.Date, DeviceID = item.DeviceID, DeviceDescription = item.Device.DisplayName, QuoteRef = item.Ref, Supplier = item.Supplier.SupplierName, VAT = item.VAT, SellingPriceInclVAT = item.SellingPriceInclVAT, TenderNumber = item.TenderNumber }; models.Add(model); } return(models); }
public async Task <IActionResult> GetAsync([FromQuery] GetBooksParameters parameters) { var booksQuery = _booksReader.Query(); var result = await _pagingService.GetPagedQuery(booksQuery, new PagingParameters(parameters.PageNumber, parameters.PageSize)).ToListAsync(); return(Ok(result)); }
public IEnumerable <Contract> Handle(ContractsQuery query) { string keyw = query.Keyword.ToLower(); return(_entities.Query <Contract>().Where(p => p.TenderNo.ToLower().Contains(keyw) || p.Device.ModelNumber.ToLower().Contains(keyw) || p.Device.SerialNo.ToLower().Contains(keyw))); }
public Customer Handle(CustomerQuery query) { Customer entity = _entities.Query <Customer>() .Where(p => p.ID == query.ID) .SingleOrDefault <Customer>(); return(entity); }
public Test Handle(TestQuery query) { var dbTest = _entities.Query <EWS.Domain.Data.DataModel.Test>().Single(p => p.ID == query.Id); return(new Test(dbTest.ID, dbTest.Test1)); }
public IEnumerable <ContractInclusion> Handle(ContractInclusionsQuery query) { return(_entities.Query <ContractInclusion>().Where(i => (i.ModalityID == query.ModalityID && !string.IsNullOrEmpty(query.ModalityID)) || (string.IsNullOrEmpty(i.ModalityID) && string.IsNullOrEmpty(query.ModalityID)) ).AsEnumerable <ContractInclusion>()); }
public IEnumerable <Quote> Handle(QuotesQuery query) { return(_entities.Query <Quote>().AsEnumerable <Quote>()); }
public Contract Handle(ContractQuery query) { return(_entities.Query <Contract>().FirstOrDefault(p => p.ID == query.ID)); }
public IEnumerable <ContractType> Handle(ContractTypesQuery query) { return(_entities.Query <ContractType>().AsEnumerable <ContractType>()); }
public IEnumerable <QuoteCalculationItem> Handle(QuoteCalculationItemsQuery query) { return(_entities.Query <QuoteCalculationItem>().Where <QuoteCalculationItem>(p => p.QuoteCalculationID == query.QuoteCalculationID) .AsEnumerable <QuoteCalculationItem>()); }
public IEnumerable <ContractItem> Handle(ContractItemsQuery query) { return(_entities.Query <ContractItem>().Where(p => p.ContractID == query.ContractID)); }
public ContractType Handle(ContractTypeQuery query) { return(_entities.Query <ContractType>().Single(p => p.ID == query.ID)); }
public ContractTerm Handle(ContractTermQuery query) { return(_entities.Query <ContractTerm>().FirstOrDefault(p => p.NoOfMonths == query.NoOfMonths)); }