public IActionResult GetPriceOfProductInventoryByArrayOfProductId([FromQuery] List <string> productId)
        {
            var result = _yachtMerchantProductInventorService.GetPriceOfProductInventoryByArrayOfProductId(productId);

            return(Ok(result));
        }
        //*****modified by hoangle 10-10-2019
        //*****next modified by
        //*****using Yacht/CartPayment
        public BaseResponse <SaveCharterPaymentResponseViewModel> SaveChartering(SaveBookingRequestModel requestModel, string PaymentMethod)
        {
            #region initalize logging
            string errCode = "0";
            SaveCharterPaymentResponseViewModel errGlobal = new SaveCharterPaymentResponseViewModel();
            #endregion

            #region logging Subject
            string dataSubjectLogging = "";

            errGlobal.Name       = "SavePaymentTrip";
            errGlobal.Value      = dataSubjectLogging;
            errGlobal.ResuldCode = errCode;
            errGlobal.Id         = "0";
            errGlobal.UniqueId   = "";
            #endregion
            try
            {
                var redisCartRequestModel = requestModel.RedisCartRequestModel;
                var bookingRequestModel   = requestModel.BookingRequestModel;
                var value = _distributedCache.GetString(redisCartRequestModel.Key);
                if (value != null)
                {
                    var lstRedisStorage = JsonConvert.DeserializeObject <List <RedisStorage> >(value);

                    //requestModel.HashKey ==> Dining or Yacht or other...
                    var RedisStorageModel = lstRedisStorage.FirstOrDefault(k => k.Domain == redisCartRequestModel.HashKey);
                    #region DOMAIN
                    if (RedisStorageModel != null)// DOMAIN IS  EXIST
                    {
                        var result = RedisStorageModel.PackageStorage;
                        if (result != null)
                        {
                            List <YachtPackageServiceModel> lstYachtPackage = result.Where(x => redisCartRequestModel.itemList.Contains(x.YachtId)).Select(i => i).ToList();

                            if (lstYachtPackage != null)
                            {
                                ///Foreach Yacht choosed
                                foreach (YachtPackageServiceModel yachtItem in lstYachtPackage)
                                {
                                    #region CALCULATION

                                    MerchantPaymentPackageViewModel            responsePackageModel  = new MerchantPaymentPackageViewModel();
                                    List <MerchantPaymentEachPackageViewModel> lstProductInventories = new List <MerchantPaymentEachPackageViewModel>();
                                    #region logging Subject
                                    if (dataSubjectLogging != "")
                                    {
                                        dataSubjectLogging += ",";
                                    }
                                    dataSubjectLogging += "{";
                                    dataSubjectLogging += $"YachtId:{yachtItem.YachtId},";
                                    dataSubjectLogging += $"Passenger:{yachtItem.Passenger },";
                                    dataSubjectLogging += $"CheckIn:{yachtItem.CheckIn },";
                                    dataSubjectLogging += $"CheckOut:{yachtItem.CheckOut },";
                                    string ErrorCode        = "0";
                                    string ErrorDescription = "";
                                    string ErrorGlobalPackageDescription = "";
                                    #endregion
                                    try
                                    {
                                        #region YACHT
                                        var yachtFIdde = Terminator.Decrypt(yachtItem.YachtId).ToInt32();

                                        double dbYachtFee        = 0;
                                        string yachtCultureCode  = "";
                                        string yachtCurrencyCode = "";

                                        #region NUMBER OF DAY OR WEEK
                                        int bookingDayNumber = GlobalMethod.BookingDayNumber(yachtItem.CheckIn, yachtItem.CheckOut);

                                        #region GET PRICE
                                        var responsePricingPlanDetail = _yachtPricingPlanDetailService.GetPricingPlanDetailYachtFId(yachtItem.YachtId);
                                        if (responsePricingPlanDetail != null && responsePricingPlanDetail.IsSuccessStatusCode && responsePricingPlanDetail.ResponseData != null)
                                        {
                                            if (responsePricingPlanDetail.ResponseData.Details != null)
                                            {
                                                var priceDetail = responsePricingPlanDetail.ResponseData.Details.OrderByDescending(x => x.PricingTypeFid).FirstOrDefault();
                                                if (priceDetail != null)
                                                {
                                                    yachtCultureCode  = priceDetail.CultureCode;
                                                    yachtCurrencyCode = priceDetail.CurrencyCode;
                                                }
                                                GlobalMethod.GetPriceRecuse(responsePricingPlanDetail.ResponseData.Details, bookingDayNumber, ref dbYachtFee);
                                            }
                                        }

                                        #endregion

                                        responsePackageModel.Id            = yachtItem.YachtId;
                                        responsePackageModel.Passenger     = yachtItem.Passenger;
                                        responsePackageModel.YachtTotal    = dbYachtFee;
                                        responsePackageModel.Total         = dbYachtFee;
                                        responsePackageModel.PackageTotal  = 0;
                                        responsePackageModel.DiscountTotal = 0;
                                        #endregion

                                        /**INSERT INTO CHARTERING**/

                                        #region YachtPort Infomation
                                        var responseYachtPort = (
                                            from p in _aqYachtContext.YachtPorts
                                            .Where(k => k.YachtFid == yachtFIdde &&
                                                   k.Deleted == false &&
                                                   k.EffectiveDate <= DateTime.Now.Date &&
                                                   k.IsActivated == true &&
                                                   k.EffectiveDate == _aqYachtContext.YachtPorts
                                                   .Where(o => o.YachtFid == yachtFIdde &&
                                                          o.Deleted == false &&
                                                          o.EffectiveDate <= DateTime.Now.Date &&
                                                          o.IsActivated == true
                                                          )
                                                   .OrderByDescending(x => x.EffectiveDate)
                                                   .Select(i => i.EffectiveDate).FirstOrDefault()
                                                   ).DefaultIfEmpty().Take(1)

                                            select p
                                            ).FirstOrDefault();
                                        #endregion

                                        #region YachtInfomation
                                        bool   isCrewmember = false;
                                        Yachts yachtOjb     = _aqYachtContext.Yachts.FirstOrDefault(x => x.Id == yachtFIdde);
                                        if (yachtOjb != null)
                                        {
                                            if (yachtOjb.CrewMembers > 0)
                                            {
                                                isCrewmember = true;
                                            }
                                        }
                                        #endregion

                                        #region INSERT INTO CHARTERING
                                        YachtCharterings charteringModel = new YachtCharterings();
                                        charteringModel.YachtFid = yachtFIdde;

                                        charteringModel.SourceFid    = 1;
                                        charteringModel.SourceResKey = "SOURCEAQBOOKINGS";
                                        charteringModel.UniqueId     = UniqueIDHelper.GenarateRandomString(12);

                                        //customer
                                        charteringModel.CustomerName     = bookingRequestModel.NameOfUser;
                                        charteringModel.ReservationEmail = bookingRequestModel.EmailOfUser;
                                        bool isUerExisting = false;
                                        if (bookingRequestModel.IsEmailExist != 0)
                                        {
                                            isUerExisting = true;
                                        }
                                        charteringModel.IsExistingCustomer = isUerExisting;

                                        if (bookingRequestModel.IdOfUser.Trim() != "")
                                        {
                                            charteringModel.CustomerFid = new Guid(bookingRequestModel.IdOfUser.Trim());
                                        }
                                        charteringModel.ContactNo       = bookingRequestModel.ContactNo;
                                        charteringModel.Passengers      = yachtItem.Passenger;
                                        charteringModel.CharterDateFrom = DateTime.Now;
                                        charteringModel.CharterDateTo   = DateTime.Now;
                                        charteringModel.BookingDate     = DateTime.Now;

                                        //yacht port
                                        if (responseYachtPort != null)
                                        {
                                            charteringModel.YachtPortFid  = responseYachtPort.PortFid;
                                            charteringModel.YachtPortName = responseYachtPort.PortName;
                                        }
                                        else
                                        {
                                            charteringModel.YachtPortFid  = -1;
                                            charteringModel.YachtPortName = "";
                                        }


                                        charteringModel.HaveCrewsMember = isCrewmember;
                                        charteringModel.CultureCode     = yachtCultureCode;
                                        charteringModel.CurrencyCode    = yachtCurrencyCode;

                                        charteringModel.StatusFid    = Convert.ToInt32(YachtCharterStatusEnum.Waiting);
                                        charteringModel.StatusResKey = "WAITINGPAYMENT";
                                        charteringModel.Processed    = false;

                                        _aqYachtContext.YachtCharterings.Add(charteringModel);
                                        _aqYachtContext.SaveChanges();
                                        long charteringModelId = charteringModel.Id;
                                        #region logging
                                        errGlobal.Id       = Terminator.Encrypt(charteringModelId.ToString());
                                        errGlobal.UniqueId = charteringModel.UniqueId;

                                        #endregion

                                        #endregion

                                        #endregion

                                        #region PACKAGE
                                        bool isPackageAddition = false;
                                        List <MerchantProductInventoriesModel> lstProductPackage = yachtItem.ProductPackage;
                                        double dbPackageFee           = 0;
                                        double dbTotalFinalValue      = 0;
                                        double dbTotalGrandTotalValue = 0;
                                        double dbTotalDiscountPackage = 0;

                                        if (lstProductPackage != null)
                                        {
                                            List <string> lstProductId           = lstProductPackage.Select(x => x.productInventoryFId).ToList();
                                            var           responsePriceOfProduct = _yachtMerchantProductInventoryService.GetPriceOfProductInventoryByArrayOfProductId(lstProductId);
                                            if (responsePriceOfProduct != null && responsePriceOfProduct.IsSuccessStatusCode && responsePriceOfProduct.ResponseData != null)
                                            {
                                                foreach (MerchantProductInventoriesModel proItem in lstProductPackage)
                                                {
                                                    #region logging Detail
                                                    //SaveCharterPaymentDetailViewModel errDetail = new SaveCharterPaymentDetailViewModel();
                                                    string dataSubLogging = "";
                                                    dataSubLogging += "{";
                                                    dataSubLogging += $"ProductInventoryFId:\"{proItem.productInventoryFId }\",";
                                                    dataSubLogging += $"Quantity:{ proItem.quantity}";
                                                    string ErrorDetailCode = "0";
                                                    string ErrorDetailPackageDescription = "";
                                                    #endregion
                                                    try
                                                    {
                                                        YachtMerchantProductInventoriesWithPriceViewModel reponseProduct = responsePriceOfProduct.ResponseData.FirstOrDefault(x => x.Id.Trim() == proItem.productInventoryFId.Trim());
                                                        if (reponseProduct != null)
                                                        {
                                                            MerchantPaymentEachPackageViewModel objPackageWithPrice = new MerchantPaymentEachPackageViewModel();

                                                            /**INSERT INTO  CHARTERINGDETAIL**/
                                                            #region INSERT INTO  CHARTERINGDETAIL
                                                            YachtCharteringDetails charteringDetailModel = new YachtCharteringDetails();
                                                            charteringDetailModel.CharteringFid  = charteringModelId;
                                                            charteringDetailModel.YachtFid       = yachtFIdde;
                                                            charteringDetailModel.ItemTypeFid    = 1;
                                                            charteringDetailModel.ItemTypeResKey = "VENDORSERVICES";

                                                            charteringDetailModel.RefFid = Terminator.Decrypt(reponseProduct.Id).ToInt32();

                                                            charteringDetailModel.ItemName        = reponseProduct.ProductName;
                                                            charteringDetailModel.CultureCode     = reponseProduct.CultureCode;
                                                            charteringDetailModel.CurrencyCode    = reponseProduct.CurrencyCode;
                                                            charteringDetailModel.OrderAmount     = proItem.quantity;
                                                            charteringDetailModel.DiscountedValue = 0;
                                                            charteringDetailModel.OriginalValue   = reponseProduct.Price;
                                                            charteringDetailModel.FinalValue      = reponseProduct.Price - charteringDetailModel.DiscountedValue;
                                                            charteringDetailModel.GrandTotalValue = GlobalMethod.PackageTotal(charteringDetailModel.FinalValue, proItem.quantity);
                                                            // charteringDetailModel.FinalValue = charteringDetailModel.GrandTotalValue - charteringDetailModel.DiscountedValue;

                                                            _aqYachtContext.YachtCharteringDetails.Add(charteringDetailModel);

                                                            _aqYachtContext.SaveChanges();
                                                            #endregion
                                                            dbTotalFinalValue      += charteringDetailModel.FinalValue;
                                                            dbTotalGrandTotalValue += charteringDetailModel.GrandTotalValue;
                                                            dbPackageFee           += GlobalMethod.PackageTotal(charteringDetailModel.OriginalValue, proItem.quantity);
                                                            dbTotalDiscountPackage += GlobalMethod.PackageTotal(charteringDetailModel.DiscountedValue, proItem.quantity);
                                                            isPackageAddition       = true;
                                                        }
                                                        ErrorDetailCode = "1";
                                                    }
                                                    catch (Exception ex)
                                                    {
                                                        #region logging add detail to errGlobal variable
                                                        ErrorDetailCode = "-1";
                                                        ErrorDetailPackageDescription = ex.Message.ToString();
                                                        #endregion
                                                    }
                                                    dataSubLogging += $"ErrorCode:{ ErrorDetailCode}";
                                                    dataSubLogging += $"ErrorDescription:{ ErrorDetailPackageDescription}";
                                                    dataSubLogging += "}";
                                                    #region ADD PACKAGE DETAIL ERROR TO THE YACHT ERROR.
                                                    if (ErrorGlobalPackageDescription != "")
                                                    {
                                                        ErrorGlobalPackageDescription += ",";
                                                    }
                                                    ErrorGlobalPackageDescription += dataSubLogging;
                                                    #endregion
                                                }

                                                responsePackageModel.PackageTotal  = dbPackageFee;
                                                responsePackageModel.DiscountTotal = responsePackageModel.DiscountTotal + dbTotalDiscountPackage;

                                                responsePackageModel.Total             = (responsePackageModel.PackageTotal + responsePackageModel.Total);
                                                responsePackageModel.lstPaymentPackage = lstProductInventories;
                                            }
                                        }
                                        #endregion

                                        responsePackageModel.PrePaidRate  = 0.5;
                                        responsePackageModel.PrepaidValue = responsePackageModel.PrePaidRate * responsePackageModel.Total;

                                        //***UPDATE CHARTERING PRICING
                                        var newChartering = _aqYachtContext.YachtCharterings.FirstOrDefault(x => x.Id == charteringModelId);
                                        if (newChartering != null)
                                        {
                                            newChartering.HaveAdditionalServices = isPackageAddition;
                                            newChartering.PrepaidRate            = responsePackageModel.PrePaidRate;
                                            newChartering.PrepaidValue           = responsePackageModel.PrepaidValue;
                                            newChartering.GrandTotalValue        = responsePackageModel.Total - responsePackageModel.DiscountTotal;
                                            newChartering.DiscountedValue        = responsePackageModel.DiscountTotal;
                                            newChartering.OriginalValue          = responsePackageModel.Total;

                                            _aqYachtContext.SaveChanges();
                                        }

                                        //****INSERT TO PAYMENTLOGS TABLE
                                        YachtCharteringPaymentLogs paymentLogs = new YachtCharteringPaymentLogs();
                                        paymentLogs.CharteringFid = charteringModelId;

                                        //call api payment from Mr Long
                                        paymentLogs.PaymentBy     = "";
                                        paymentLogs.PaymentRef    = "";
                                        paymentLogs.PaymentMethod = PaymentMethod;

                                        paymentLogs.PaymentDate   = DateTime.Now;
                                        paymentLogs.PaymentAmount = responsePackageModel.PrepaidValue;
                                        paymentLogs.CultureCode   = yachtCultureCode;
                                        paymentLogs.CurrencyCode  = yachtCurrencyCode;
                                        paymentLogs.StatusFid     = Convert.ToInt32(YachtCharterStatusEnum.Waiting);//wating for payment
                                        _aqYachtContext.YachtCharteringPaymentLogs.Add(paymentLogs);
                                        _aqYachtContext.SaveChanges();
                                        #endregion

                                        ErrorCode = "1";
                                    }
                                    catch (Exception ex)
                                    {
                                        ErrorCode        = "-1";
                                        ErrorDescription = ex.Message.ToString();
                                    }
                                    dataSubjectLogging += $"ErrorCode:{ErrorCode },";
                                    dataSubjectLogging += $"ErrorDescription:{ErrorDescription }";
                                    dataSubjectLogging += $"ErrorDetail:{ErrorGlobalPackageDescription }";
                                    dataSubjectLogging += "}";
                                }
                                errGlobal.Value = dataSubjectLogging;
                            }
                        }
                    }
                    #endregion
                }

                #region logging
                errCode = "1";
                errGlobal.ResuldCode = errCode;
                #endregion

                return(BaseResponse <SaveCharterPaymentResponseViewModel> .Success(errGlobal));
            }
            catch (Exception ex)
            {
                errCode = "-1";
                errGlobal.ResuldCode = errCode;
                errGlobal.Describes  = ex.Message.ToString();
                return(BaseResponse <SaveCharterPaymentResponseViewModel> .InternalServerError(errGlobal, ex.Message));
            }
        }