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