public string GetYachtTourPrice(int tourId = 0, int yachtId = 0, int pax = 0) { string result = string.Empty; var query = _yachtDbContext.YachtTourPricings.AsNoTracking() .Where(x => x.Deleted == false && x.TourFid == tourId && x.YachtFid == yachtId && x.EffectiveDate.Date <= DateTime.Now.Date); var tourPrice = new YachtTourPricings(); if (query.Count() > 0) { tourPrice = query.OrderBy("EffectiveDate DESC").FirstOrDefault(); result = TourPriceEstimate((TourPricingTypeEnum)tourPrice.TourPricingTypeFid, tourPrice.TourFee, tourPrice.MinimumPaxToGo, pax).ToString(); return(result + "," + tourPrice.CultureCode); } return(result); }
public YachtTourPriceResultModel GetYachtTourPrice(int tourId = 0, int yachtId = 0, int pax = 0) { var priceReturn = new YachtTourPriceResultModel(); var query = _yachtDbContext.YachtTourPricings.AsNoTracking() .Where(x => x.Deleted == false && x.TourFid == tourId && x.YachtFid == yachtId && x.EffectiveDate <= DateTime.Now && DateTime.Now <= x.EffectiveEndDate); var tourPrice = new YachtTourPricings(); if (query.Count() > 0) { tourPrice = query.OrderBy("EffectiveDate DESC").FirstOrDefault(); var priceTemp = TourPriceEstimate((TourPricingTypeEnum)tourPrice.TourPricingTypeFid, tourPrice.TourFee, tourPrice.MinimumPaxToGo, pax); priceReturn.Price = priceTemp; priceReturn.CulturCode = tourPrice.CultureCode; } return(priceReturn); }
private YachtTourPricings GenerateForCreate(int tourId, int yachtId, YachtTourPricingCreateModel model = null) { var pricingTypeResponse = _commonValueRequestService. GetCommonValueByGroupInt(CommonValueGroupConstant.YachtTourPricingType, model.TourPricingTypeFid); var entity = new YachtTourPricings(); var now = DateTime.Now.Date; var userId = UserContextHelper.UserId; if (model != null) { entity.InjectFrom(model); } entity.TourFid = tourId; entity.YachtFid = yachtId; entity.TourPricingTypeResKey = pricingTypeResponse.IsSuccessStatusCode ? pricingTypeResponse.ResponseData.ResourceKey : string.Empty; entity.CreatedBy = userId; entity.LastModifiedBy = userId; entity.CreatedDate = now; entity.LastModifiedDate = now; entity.Deleted = false; return(entity); }