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 SourceQuote GetSourceQuote(string QuoteRef) { if (string.IsNullOrEmpty(QuoteRef)) { return(null); } else { SourceQuoteQuery query = new Domain.Data.Queries.SourceQuoteQuery() { QuoteRef = QuoteRef }; SourceQuote founditem = _queryProcessor.Execute <SourceQuote>(query); return(founditem); } }
private EWS.Domain.Model.QuoteCalculationItem[] GetQuoteCalculationItemsStructure(Domain.Data.DataModel.QuoteCalculation calc, short NoOfYears, DateTime?StartDate = null) { QuoteCalculationItem[] models = new QuoteCalculationItem[NoOfYears]; // new/old ROE and VAT values needed ......................................... decimal oldROE; decimal newROE; float VAT; QuoteQuery quotequery = new QuoteQuery() { ID = calc.QuoteID }; EWS.Domain.Data.DataModel.Quote quoteEntity = _queryProcessor.Execute(quotequery); newROE = quoteEntity.ROE; if (!string.IsNullOrEmpty(quoteEntity.QuoteRef)) { SourceQuoteQuery query = new SourceQuoteQuery() { QuoteRef = quoteEntity.QuoteRef }; SourceQuote entity = _queryProcessor.Execute(query); oldROE = entity.ROE; VAT = entity.VAT; } else { ContractQuery query = new ContractQuery() { ID = quoteEntity.BaseContractID.Value }; EWS.Domain.Data.DataModel.Contract entity = _queryProcessor.Execute(query); oldROE = entity.ROE; VAT = entity.VAT; } // Currently Saved values .................................................... QuoteCalculationItemsQuery qury = new QuoteCalculationItemsQuery() { QuoteCalculationID = calc.ID }; IEnumerable <Domain.Data.DataModel.QuoteCalculationItem> calcs = _queryProcessor.Execute(qury); // Setup the structure ....................................................... for (byte i = 0; i < NoOfYears; i++) { byte yearno = (byte)(i + 1); models[i] = new QuoteCalculationItem() { YearNo = yearno, NewROE = newROE, TOPSROE = oldROE, VAT = VAT, UseNewROE = true, Increment = (i == 0 ? 0 : EWS.Domain.Defaults.AnnualIncrement) }; if (StartDate.HasValue) { models[i].StartDate = StartDate.Value.AddYears(i); models[i].EndDate = StartDate.Value.AddYears(yearno).AddDays(-1); } Domain.Data.DataModel.QuoteCalculationItem item = calcs.FirstOrDefault(c => c.YearNo == yearno); if (item != null) { models[i].ID = item.ID; models[i].Increment = item.IncrPerc; models[i].UseNewROE = (item.ROE == newROE); } } return(models); }