public IActionResult GetCommercialsData(string QRFID, string EnquiryPipeline = "", long filterByDeparture = 0, long filterByPaxSlab = 0)
        {
            CommercialsViewModel model = new CommercialsViewModel();

            model.MenuViewModel.QRFID           = QRFID;
            model.MenuViewModel.EnquiryPipeline = EnquiryPipeline;
            #region Dropdown Binding
            //NewQuoteViewModel modelQuote = new NewQuoteViewModel();
            //bool GetStatus = false;
            //SalesQuoteLibrary quoteLibrary = new SalesQuoteLibrary(_configuration);
            //if (Convert.ToInt32(QRFId) > 0)
            //{
            //    modelQuote.QRFID = QRFID;
            //    GetStatus = quoteLibrary.GetQRFPaxSlabDetails(_configuration, token, ref modelQuote);
            //}

            //SalesProviders objSalesProvider = new SalesProviders(_configuration);
            //DepartureDateGetRequest objDepartureDatesReq = new DepartureDateGetRequest() { QRF_Id = QRFId, date = (DateTime?)null };
            //DepartureDateGetResponse objDepartureDatesRes = objSalesProvider.GetDepartureDatesForQRFId(objDepartureDatesReq, token).Result;
            //model.PaxSlabList = (modelQuote.mdlQuotePaxRangeViewModel.QuotePaxSlabDetails).Select(a => new AttributeValues { AttributeValue_Id = a.PaxSlabId.ToString(), Value = a.PaxSlabFrom + "-" + a.PaxSlabTo }).ToList();
            //model.DepartureDatesList = (objDepartureDatesRes.DepartureDates).Select(a => new AttributeValues { AttributeValue_Id = a.Departure_Id.ToString(), Value = Convert.ToDateTime(a.Date).ToString("dd MMM yy") }).ToList();
            ////long defaultPaxSlabId = Convert.ToInt32(model.PaxSlabList[0].AttributeValue_Id);

            QRFDepartureDateGetReq objDepartureDatesReq = new QRFDepartureDateGetReq()
            {
                QRFID = QRFID, date = (DateTime?)null
            };
            QRFDepartureDateGetRes objDepartureDatesRes = coProviders.GetDepartureDatesForCostingByQRF_Id(objDepartureDatesReq, token).Result;
            QRFPaxSlabGetReq       objPaxSlabReq        = new QRFPaxSlabGetReq()
            {
                QRFID = QRFID
            };
            QRFPaxGetResponse objPaxSlabRes = coProviders.GetPaxSlabDetailsForCostingByQRF_Id(objPaxSlabReq, token).Result;
            model.PaxSlabList = (objPaxSlabRes.PaxSlabDetails.QRFPaxSlabs).Select(a => new AttributeValues {
                AttributeValue_Id = a.PaxSlab_Id.ToString(), Value = a.From + "-" + a.To
            }).ToList();
            model.DepartureDatesList = (objDepartureDatesRes.DepartureDates).Select(a => new AttributeValues {
                AttributeValue_Id = a.Departure_Id.ToString(), Value = Convert.ToDateTime(a.Date).ToString("dd MMM yy")
            }).ToList();

            model.CurrentDate = DateTime.Now.ToString("dd MMM yyyy");

            string username = "";
            IRequestCookieCollection objCookies = HttpContext.Request.Cookies;
            username       = HttpContext.Request.Cookies["UserName"] ?? ckUserName;
            model.UserName = username;
            #endregion

            #region Get Commercial data
            CommercialsGetRes response = new CommercialsGetRes();
            CommercialsGetReq request  = new CommercialsGetReq();
            request.QRFID       = QRFID;
            request.DepartureId = filterByDeparture == 0 ? objDepartureDatesRes.DepartureDates[0].Departure_Id : filterByDeparture;
            request.PaxSlabId   = filterByPaxSlab == 0 ? objPaxSlabRes.PaxSlabDetails.QRFPaxSlabs[0].PaxSlab_Id : filterByPaxSlab;

            response                  = coProviders.GetCommercials(request, token).Result;
            model.QRFID               = response.QRFID;
            model.QRFPriceId          = response.QRFPriceId;
            model.PercentSoldOptional = response.PercentSoldOptional;

            model.BareBoneList    = response.BareBoneList;
            model.QRFExhangeRates = response.QRFExhangeRates;

            string PositionType = "";
            foreach (var item in response.PositionIncluded)
            {
                if (item.PositionType != PositionType)
                {
                    model.PositionIncluded.Add(new mQRFPositionTotalCost
                    {
                        QRFCostForPositionID = "",
                        PositionType         = item.PositionType,
                        ProductName          = "",
                        TotalBuyPrice        = response.PositionIncluded.Where(a => a.PositionType == item.PositionType).Sum(a => a.TotalBuyPrice),
                        TotalSellPrice       = response.PositionIncluded.Where(a => a.PositionType == item.PositionType).Sum(a => a.TotalSellPrice),
                        ProfitPercentage     = response.PositionIncluded.Where(a => a.PositionType == item.PositionType && a.ProfitPercentage > 0).Count() > 0 ?
                                               (response.PositionIncluded.Where(a => a.PositionType == item.PositionType).Sum(a => a.ProfitPercentage)
                                                / response.PositionIncluded.Where(a => a.PositionType == item.PositionType && a.ProfitPercentage > 0).Count()) : 0,
                        ProfitAmount = response.PositionIncluded.Where(a => a.PositionType == item.PositionType).Sum(a => a.ProfitAmount),
                        BuyCurrency  = item.BuyCurrency,
                        QRFCurrency  = item.QRFCurrency
                    });
                }
                model.PositionIncluded.Add(new mQRFPositionTotalCost
                {
                    QRFCostForPositionID = item.QRFCostForPositionID,
                    PositionType         = item.PositionType,
                    PositionId           = item.PositionId,
                    ProductName          = item.ProductName,
                    TotalBuyPrice        = item.TotalBuyPrice,
                    TotalSellPrice       = item.TotalSellPrice,
                    ProfitAmount         = item.ProfitAmount,
                    ProfitPercentage     = item.ProfitPercentage,
                    BuyCurrency          = item.BuyCurrency,
                    QRFCurrency          = item.QRFCurrency
                });
                PositionType = item.PositionType;
            }

            foreach (var item in response.PositionSupplement)
            {
                model.PositionSupplement.Add(new mQRFPositionTotalCost
                {
                    QRFCostForPositionID = item.QRFCostForPositionID,
                    PositionType         = item.PositionType,
                    PositionId           = item.PositionId,
                    ProductName          = item.ProductName,
                    TotalBuyPrice        = item.TotalBuyPrice,
                    TotalSellPrice       = item.TotalSellPrice,
                    ProfitAmount         = item.ProfitAmount,
                    ProfitPercentage     = item.ProfitPercentage,
                    BuyCurrency          = item.BuyCurrency,
                    QRFCurrency          = item.QRFCurrency
                });
            }

            foreach (var item in response.PositionOptional)
            {
                model.PositionOptional.Add(new mQRFPositionTotalCost
                {
                    QRFCostForPositionID = item.QRFCostForPositionID,
                    PositionType         = item.PositionType,
                    PositionId           = item.PositionId,
                    ProductName          = item.ProductName,
                    TotalBuyPrice        = item.TotalBuyPrice,
                    TotalSellPrice       = item.TotalSellPrice,
                    ProfitAmount         = item.ProfitAmount,
                    ProfitPercentage     = item.ProfitPercentage,
                    BuyCurrency          = item.BuyCurrency,
                    QRFCurrency          = item.QRFCurrency
                });
            }

            model.DepartureDate = filterByDeparture;
            model.PaxSlab       = filterByPaxSlab;

            #endregion

            if (model.PositionSupplement.Count > 0)
            {
                ViewBag.QRFCurrency = model.PositionSupplement[0].QRFCurrency;
            }
            if (model.PositionOptional.Count > 0)
            {
                ViewBag.QRFCurrency = model.PositionOptional[0].QRFCurrency;
            }
            if (model.PositionIncluded.Count > 0)
            {
                ViewBag.QRFCurrency = model.PositionIncluded[0].QRFCurrency;
            }

            ViewBag.IsAllowToAppRej = false;
            if (model.MenuViewModel.EnquiryPipeline == "Costing Approval Pipeline")
            {
                if (UserRoles.Contains("Product Accountant"))
                {
                    ViewBag.IsAllowToAppRej = true;
                }
            }

            return(PartialView("_Commercials", model));
        }