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