/Apttus.SNowPS/Apttus.SNowPS.Repository/Products/ProdQuoteRepository.cs

/****************************************************************************************
@Name: QuoteRepository.cs
@Author: Asha Tank
@CreateDate: 11 Oct 2017
@Description: Quote header related process
@UsedBy: This will be used by ProdQuoteRepository controller
@ModifiedBy: 
@ModifiedDate: 
@ChangeDescription: 
*****************************************************************************************/
using Apttus.DataAccess.Common.Enums;
using Apttus.DataAccess.Common.Model;
using Apttus.SNowPS.Common;
using Apttus.SNowPS.Model;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net.Http;
using System.Xml.Linq;
using System.IO;
using System.Reflection;

namespace Apttus.SNowPS.Respository
{
    public class ProdQuoteRepository
    {
        /// <summary>
        /// Calculate financial fields of quote header for paased quote id 
        /// </summary>
        /// <param name="QuoteId"></param>
        /// <param name="accessToken"></param>
        /// <returns></returns>
        public HttpResponseMessage GetQuoteDetail(string QuoteId, string accessToken)
        {
            var errors = new List<Model.ErrorInfo>();
            try
            {
                //Build AQL Query to fetch Quote,Quote Line Items & Product details
                var query = new Query(Constants.OBJ_QUOTE);
                query.AddColumns(Constants.OBJ_FIELDQUOTELINEITEM.Split(Constants.CHAR_COMMA));
                Expression exp = new Expression(ExpressionOperator.AND);
                exp.AddCondition(new Condition(Constants.FIELD_ID, FilterOperator.Equal, QuoteId));

                query.SetCriteria(exp);

                Join quoteLineItem = new Join(Constants.OBJ_QUOTE, Constants.OBJ_CPQ_QUOTELINEITEM, Constants.FIELD_ID, Constants.FIELD_QUOTEID, JoinType.LEFT);
                quoteLineItem.EntityAlias = Constants.OBJ_CPQ_QUOTELINEITEM;
                query.AddJoin(quoteLineItem);

                Join lineItem = new Join(Constants.OBJ_CPQ_QUOTELINEITEM, Constants.OBJ_LINEITEM, Constants.FIELD_DERIVEDFROMId, Constants.FIELD_ID, JoinType.LEFT);
                lineItem.EntityAlias = Constants.OBJ_LINEITEM;
                query.AddJoin(lineItem);

                Join product = new Join(Constants.OBJ_CPQ_QUOTELINEITEM, Constants.OBJ_PRODUCT, Constants.FIELD_PRODUCTID, Constants.FIELD_ID, JoinType.LEFT);
                product.EntityAlias = Constants.OBJ_PRODUCT;
                query.AddJoin(product);

                var jsonQuery = query.Serialize();
                //

                var reqConfig = new RequestConfigModel();
                reqConfig.accessToken = accessToken;
                reqConfig.searchType = SearchType.AQL;
                reqConfig.objectName = Constants.OBJ_QUOTE;

                var response = Utilities.Search(jsonQuery, reqConfig);
                ResultQuoteHeaderModel resultQuoteHeaderModel = new ResultQuoteHeaderModel();
                if (response != null && response.IsSuccessStatusCode)
                {
                    var responseString = JObject.Parse(response.Content.ReadAsStringAsync().Result).SelectToken(Constants.NODE_SERIALIZEDRESULTENTITIES).ToString();
                    List<QuoteQuoteLineDetails> QuoteLineList = new List<QuoteQuoteLineDetails>();
                    QuoteLineList = JsonConvert.DeserializeObject<List<QuoteQuoteLineDetails>>(responseString);

                    if (QuoteLineList != null && QuoteLineList.Count > 0)
                    {
                        DailyExcnageRate objDailyExcnageRate = new DailyExcnageRate();
                        objDailyExcnageRate = GetExchangeRateDetails(QuoteLineList.FirstOrDefault().cpq_lineitem.CurrencyId, accessToken);

                        decimal EstimatedTotal = 0;
                        decimal ProfesionalServiceTotal = 0;

                        //Calculate quote fields 
                        for (int i = 0; i < QuoteLineList.Count; i++)
                        {
                            switch (QuoteLineList[i].crm_Product.ContributesTo.Value)
                            {
                                case Constants.TOTALPSREVENUE:
                                    resultQuoteHeaderModel.ext_EducationalServicesandKnowledgeandOther = resultQuoteHeaderModel.ext_EducationalServicesandKnowledgeandOther + Convert.ToDecimal(QuoteLineList[i].cpq_QuoteLineItem.NetPrice);
                                    resultQuoteHeaderModel.ext_TotalServicesRevenue = resultQuoteHeaderModel.ext_TotalServicesRevenue + Convert.ToDecimal(QuoteLineList[i].cpq_QuoteLineItem.NetPrice);
                                    resultQuoteHeaderModel.ext_TotalPSRevenue = resultQuoteHeaderModel.ext_TotalPSRevenue + Convert.ToDecimal(QuoteLineList[i].cpq_QuoteLineItem.NetPrice);
                                    break;
                                case Constants.SUBSCRIPTIONANDLICENSEREVENUE:
                                    resultQuoteHeaderModel.ext_TotalLicenseValue = resultQuoteHeaderModel.ext_TotalLicenseValue + Convert.ToDecimal(QuoteLineList[i].cpq_QuoteLineItem.NetPrice);
                                    resultQuoteHeaderModel.ext_TotalSubscriptionACV = resultQuoteHeaderModel.ext_TotalSubscriptionACV + Convert.ToDecimal(QuoteLineList[i].cpq_QuoteLineItem.AnnualContractValue);
                                    break;
                                case Constants.LICENSEREVENUE:
                                    resultQuoteHeaderModel.ext_TotalLicenseValue = resultQuoteHeaderModel.ext_TotalLicenseValue + Convert.ToDecimal(QuoteLineList[i].cpq_QuoteLineItem.NetPrice);
                                    break;
                                case Constants.TRAININGREVENUE:
                                    resultQuoteHeaderModel.ext_TotalServicesRevenue = resultQuoteHeaderModel.ext_TotalServicesRevenue + Convert.ToDecimal(QuoteLineList[i].cpq_QuoteLineItem.NetPrice);
                                    resultQuoteHeaderModel.ext_TotalTrainingRevenue = resultQuoteHeaderModel.ext_TotalTrainingRevenue + Convert.ToDecimal(QuoteLineList[i].cpq_QuoteLineItem.NetPrice);
                                    break;
                                case Constants.OTHERREVENUE:
                                    resultQuoteHeaderModel.ext_TotalOtherRevenue = resultQuoteHeaderModel.ext_TotalOtherRevenue + Convert.ToDecimal(QuoteLineList[i].cpq_QuoteLineItem.NetPrice);
                                    break;

                            }
                            if (QuoteLineList[i].crm_Product.Family != null && QuoteLineList[i].crm_Product.Family.Value == "Professional Services")
                            {
                                ProfesionalServiceTotal = ProfesionalServiceTotal + Convert.ToDecimal(QuoteLineList[i].cpq_QuoteLineItem.NetPrice);
                            }
                            resultQuoteHeaderModel.ext_TotalAnnualListPrice = resultQuoteHeaderModel.ext_TotalAnnualListPrice + Convert.ToDecimal(QuoteLineList[i].cpq_QuoteLineItem.AnnualContractValue);
                            EstimatedTotal = EstimatedTotal + Convert.ToDecimal(QuoteLineList[i].cpq_QuoteLineItem.EstimatedTotal);
                        }
                        resultQuoteHeaderModel.ext_PreTaxTotals = Convert.ToDecimal(resultQuoteHeaderModel.ext_TotalLicenseValue + resultQuoteHeaderModel.ext_TotalServicesRevenue + resultQuoteHeaderModel.ext_TotalOtherRevenue);
                        if (ProfesionalServiceTotal != 0)
                        {
                            resultQuoteHeaderModel.ext_EstimatedTravelExpenseFees = (ProfesionalServiceTotal * 10) / 100;
                        }
                        resultQuoteHeaderModel.ext_EstimatedTotal = EstimatedTotal + resultQuoteHeaderModel.ext_EstimatedTravelExpenseFees;
                        resultQuoteHeaderModel.Id = QuoteLineList.FirstOrDefault().Id;

                        //Calculation of USD fields
                        resultQuoteHeaderModel.ext_USDTotalAnnualListPrice = Convert.ToDecimal(objDailyExcnageRate.ext_Rate * resultQuoteHeaderModel.ext_TotalAnnualListPrice);
                        resultQuoteHeaderModel.ext_USDTotalLicenseValue = Convert.ToDecimal(objDailyExcnageRate.ext_Rate * resultQuoteHeaderModel.ext_TotalLicenseValue);
                        resultQuoteHeaderModel.ext_USDTotalOtherRevenue = Convert.ToDecimal(objDailyExcnageRate.ext_Rate * resultQuoteHeaderModel.ext_TotalOtherRevenue);
                        resultQuoteHeaderModel.ext_USDTotalPSRevenue = Convert.ToDecimal(objDailyExcnageRate.ext_Rate * resultQuoteHeaderModel.ext_TotalPSRevenue);
                        resultQuoteHeaderModel.ext_USDTotalServicesRevenue = Convert.ToDecimal(objDailyExcnageRate.ext_Rate * resultQuoteHeaderModel.ext_TotalServicesRevenue);
                        resultQuoteHeaderModel.ext_USDTotalSubscriptionACV = Convert.ToDecimal(objDailyExcnageRate.ext_Rate * resultQuoteHeaderModel.ext_TotalSubscriptionACV);
                        resultQuoteHeaderModel.ext_USDTotalTrainingRevenue = Convert.ToDecimal(objDailyExcnageRate.ext_Rate * resultQuoteHeaderModel.ext_TotalTrainingRevenue);
                        //Calculation of USD fields end
                    }

                    //return response
                    List<ResultQuoteHeaderModel> quoteHeaderList = new List<ResultQuoteHeaderModel>();
                    quoteHeaderList.Add(resultQuoteHeaderModel);

                    var responseResult = UpdateQuoteHeader(quoteHeaderList, accessToken);
                    return responseResult;
                }
                else
                {
                    HttpResponseMessage jsonResponse = new HttpResponseMessage();
                    Model.ErrorInfo errorInfo = new Model.ErrorInfo();
                    errorInfo.Message = "Error";
                    var dict = new Dictionary<string, object>
                    {
                        {"Message", "Fail to update records"}
                    };
                    errorInfo.Record = dict;
                    errors.Add(errorInfo);
                    Utilities.CreateResponse(jsonResponse, errors);
                    return jsonResponse;
                }
            }
            catch (Exception ex)
            {
                var resp = new HttpResponseMessage
                {
                    Content = new StringContent("Message :" + ex.Message + " " + "StackStrace :" + ex.StackTrace, System.Text.Encoding.UTF8, "application/json"),
                    StatusCode = System.Net.HttpStatusCode.BadRequest
                };
                return resp;
            }
        }
        /// <summary>
        /// Get Currency exchange rate based on currency code
        /// </summary>
        /// <param name="currencyCode"></param>
        /// <returns></returns>
        public DailyExcnageRate GetExchangeRateDetails(string currencyId, string accessToken)
        {
            //currencyCode = "USD";
            DailyExcnageRate ExchangeRates = new DailyExcnageRate();
            accessToken = accessToken != null ? accessToken : Utilities.GetAuthToken();

            var reqExchangeRateLineItem = Utilities.GetRequestConfiguration(Constants.OBJ_DAILYEXCHANGERATE, Constants.FIELD_CURRENCYCODE, Constants.FIELD_CURRENCYCODE);
            var dictContent = new List<Dictionary<string, object>> { new Dictionary<string, object>() { { "ext_CurrencyCode", currencyId } } };
            var resExchangeRate = Utilities.Search(dictContent, reqExchangeRateLineItem);

            if (resExchangeRate != null && resExchangeRate.IsSuccessStatusCode)
            {
                var responseString = JObject.Parse(resExchangeRate.Content.ReadAsStringAsync().Result).SelectToken("SerializedResultEntities").ToString();
                List<DailyExcnageRate> ListExchgRates = JsonConvert.DeserializeObject<List<DailyExcnageRate>>(responseString);
                // Getting last Created/Modified currency rate
                ExchangeRates = ListExchgRates.OrderByDescending(x => x.ModifiedOn).FirstOrDefault();
            }
            return ExchangeRates;
        }

        /// <summary>
        /// Update Quote Line Items
        /// </summary>
        /// <param name="lineItems"></param>
        /// <param name="accessToken"></param>
        /// <returns></returns>
        public HttpResponseMessage UpdateQuoteHeader(List<ResultQuoteHeaderModel> quoteHeaderList, string accessToken)
        {
            var reqConfig = new RequestConfigModel();
            reqConfig.accessToken = accessToken;
            reqConfig.objectName = Constants.OBJ_QUOTE;

            var lstQuoteToUpdate = new List<dynamic>();
            foreach (var lstQuoteItems in quoteHeaderList)
            {
                lstQuoteToUpdate.Add(new
                {
                    Id = lstQuoteItems.Id,
                    ext_EducationalServicesandKnowledgeandOther = lstQuoteItems.ext_EducationalServicesandKnowledgeandOther,
                    ext_TotalServicesRevenue = lstQuoteItems.ext_TotalServicesRevenue,
                    ext_TotalPSRevenue = lstQuoteItems.ext_TotalPSRevenue,
                    ext_TotalSubscriptionACV = lstQuoteItems.ext_TotalSubscriptionACV,
                    ext_TotalLicenseValue = lstQuoteItems.ext_TotalLicenseValue,
                    ext_TotalTrainingRevenue = lstQuoteItems.ext_TotalTrainingRevenue,
                    ext_TotalOtherRevenue = lstQuoteItems.ext_TotalOtherRevenue,
                    ext_TotalAnnualListPrice = lstQuoteItems.ext_TotalAnnualListPrice,
                    ext_PreTaxTotals = lstQuoteItems.ext_PreTaxTotals,
                    ext_EstimatedTravelExpenseFees = lstQuoteItems.ext_EstimatedTravelExpenseFees,
                    ext_EstimatedTotal = lstQuoteItems.ext_EstimatedTotal,
                    ext_USDTotalAnnualListPrice = lstQuoteItems.ext_USDTotalAnnualListPrice,
                    ext_USDTotalLicenseValue = lstQuoteItems.ext_USDTotalLicenseValue,
                    ext_USDTotalOtherRevenue = lstQuoteItems.ext_USDTotalOtherRevenue,
                    ext_USDTotalPSRevenue = lstQuoteItems.ext_USDTotalPSRevenue,
                    ext_USDTotalServicesRevenue = lstQuoteItems.ext_USDTotalServicesRevenue,
                    ext_USDTotalSubscriptionACV = lstQuoteItems.ext_USDTotalSubscriptionACV,
                    ext_USDTotalTrainingRevenue = lstQuoteItems.ext_USDTotalTrainingRevenue
                });
            }

            var responseString = Utilities.Update(lstQuoteToUpdate, reqConfig);
            return responseString;
        }


        #region Commented Code
        ///// <summary>
        ///// Calculate financial fields of Quote line items for given QuoteId
        ///// </summary>
        ///// <param name="QuoteId"></param>
        ///// <param name="accessToken"></param>
        ///// <returns></returns>
        //public HttpResponseMessage UpdateQuoteLineItemFields(string QuoteId, string accessToken)
        //{
        //    var errors = new List<Model.ErrorInfo>(); 
        //    try
        //    {
        //        //Build AQL Query to fetch Quote,Quote Line Items & Product details
        //        var query = new Query(Constants.OBJ_QUOTE);
        //        query.AddColumns(Constants.OBJ_FIELDQUOTELINEITEMFINANCIAL.Split(Constants.CHAR_COMMA));
        //        Expression exp = new Expression(ExpressionOperator.AND);
        //        exp.AddCondition(new Condition(Constants.FIELD_ID, FilterOperator.Equal, QuoteId));

        //        query.SetCriteria(exp);

        //        Join quoteLineItem = new Join(Constants.OBJ_QUOTE, Constants.OBJ_CPQ_QUOTELINEITEM, Constants.FIELD_ID, Constants.FIELD_QUOTEID, JoinType.LEFT);
        //        quoteLineItem.EntityAlias = Constants.OBJ_CPQ_QUOTELINEITEM;
        //        query.AddJoin(quoteLineItem);

        //        Join lineItem = new Join(Constants.OBJ_CPQ_QUOTELINEITEM, Constants.OBJ_LINEITEM, Constants.FIELD_DERIVEDFROMId, Constants.FIELD_ID, JoinType.LEFT);
        //        lineItem.EntityAlias = Constants.OBJ_LINEITEM;
        //        query.AddJoin(lineItem);

        //        Join product = new Join(Constants.OBJ_CPQ_QUOTELINEITEM, Constants.OBJ_PRODUCT, Constants.FIELD_PRODUCTID, Constants.FIELD_ID, JoinType.LEFT);
        //        product.EntityAlias = Constants.OBJ_PRODUCT;
        //        query.AddJoin(product);

        //        var jsonQuery = query.Serialize();

        //        var reqConfig = new RequestConfigModel();
        //        reqConfig.accessToken = accessToken;
        //        reqConfig.searchType = SearchType.AQL;
        //        reqConfig.objectName = Constants.OBJ_QUOTE;

        //        var response = Utilities.Search(jsonQuery, reqConfig);
        //        ResultUSDQuoteHeaderLineItemFields resultQuoteHeaderAndLIneItems = new ResultUSDQuoteHeaderLineItemFields();
        //        ResultQuoteHeaderModel resultQuoteHeaderModel = new ResultQuoteHeaderModel();
        //        List<ResultQuoteLineItem> lstResultQuoteLineItem = new List<ResultQuoteLineItem>();

        //        if (response != null && response.IsSuccessStatusCode)
        //        {
        //            var responseString = JObject.Parse(response.Content.ReadAsStringAsync().Result).SelectToken(Constants.NODE_SERIALIZEDRESULTENTITIES).ToString();
        //            List<QuoteQuoteLineDetails> QuoteLineList = new List<QuoteQuoteLineDetails>();

        //            QuoteLineList = JsonConvert.DeserializeObject<List<QuoteQuoteLineDetails>>(responseString);

        //            if (QuoteLineList != null && QuoteLineList.Count > 0)
        //            {

        //                LineItemRepository lineItemRepo = new LineItemRepository();
        //                //Calculate quote line item USD fields 
        //                for (int i = 0; i < QuoteLineList.Count; i++)
        //                {
        //                    ResultQuoteLineItem objResultQuoteLineItem = new ResultQuoteLineItem();

        //                    objResultQuoteLineItem.Id = QuoteLineList[i].cpq_QuoteLineItem.Id;

        //                    //get daily currenct exchange rates based on currency code
        //                    DailyExcnageRate objDailyExcnageRate = lineItemRepo.GetExchangeRateDetails(QuoteLineList[i].cpq_lineitem.CurrencyId, accessToken);

        //                    //USD fields
        //                    if (objDailyExcnageRate != null)
        //                    {
        //                        objResultQuoteLineItem.ext_USDAdjustment = objDailyExcnageRate.ext_Rate * QuoteLineList[i].cpq_QuoteLineItem.Ext_AdjustmentAmount;
        //                        objResultQuoteLineItem.ext_USDBasePrice = objDailyExcnageRate.ext_Rate * QuoteLineList[i].cpq_QuoteLineItem.BasePrice;
        //                        objResultQuoteLineItem.ext_USDTotalValue = objDailyExcnageRate.ext_Rate * (QuoteLineList[i].cpq_QuoteLineItem.NetPrice);
        //                        objResultQuoteLineItem.ext_USDListPrice = objDailyExcnageRate.ext_Rate * (QuoteLineList[i].cpq_QuoteLineItem.ListPrice);
        //                        objResultQuoteLineItem.ext_USDSalesPrice = objDailyExcnageRate.ext_Rate * (QuoteLineList[i].cpq_QuoteLineItem.NetUnitPrice);
        //                        objResultQuoteLineItem.ext_USDAnnualContractValue = objDailyExcnageRate.ext_Rate * QuoteLineList[i].cpq_QuoteLineItem.AnnualContractValue;
        //                        objResultQuoteLineItem.ext_USDAnnualListPrice = objDailyExcnageRate.ext_Rate * QuoteLineList[i].cpq_QuoteLineItem.AnnualListPrice;
        //                    }
        //                    lstResultQuoteLineItem.Add(objResultQuoteLineItem);
        //                }
        //            }
        //            resultQuoteHeaderAndLIneItems.ListQuoteLineItemFinFields = lstResultQuoteLineItem;
        //            var responseResult = UpdateQuoteLineItems(lstResultQuoteLineItem, accessToken);
        //            return responseResult;
        //        }
        //        else
        //        {
        //            HttpResponseMessage jsonResponse = new HttpResponseMessage();
        //            Model.ErrorInfo errorInfo = new Model.ErrorInfo();
        //            errorInfo.Message = "Error";
        //            var dict = new Dictionary<string, object>
        //            {
        //                {"Message", "Fail to update records"}
        //            };
        //            errorInfo.Record = dict;
        //            errors.Add(errorInfo);
        //            Utilities.CreateResponse(jsonResponse, errors);
        //            return jsonResponse;
        //        }
        //        //return response

        //    }
        //    catch (Exception ex)
        //    {
        //        var resp = new HttpResponseMessage
        //        {
        //            Content = new StringContent("Message :" + ex.Message + " " + "StackStrace :" + ex.StackTrace, System.Text.Encoding.UTF8, "application/json"),
        //            StatusCode = System.Net.HttpStatusCode.BadRequest
        //        };
        //        return resp;
        //    }
        //}
        #endregion

        /// <summary>
        /// Calculate financial fields of Quote line items for given QuoteId
        /// </summary>
        /// <param name="QuoteId"></param>
        /// <param name="accessToken"></param>
        /// <returns></returns>
        public HttpResponseMessage UpdateQuoteLineItemFields(string QuoteId, string accessToken)
        {
            var errors = new List<Model.ErrorInfo>();
            try
            {
                //Build AQL Query to fetch Quote,Quote Line Items & Product details
                var query = new Query(Constants.OBJ_QUOTE);
                query.AddColumns(Constants.OBJ_FIELDQUOTELINEITEMFINANCIAL.Split(Constants.CHAR_COMMA));
                Expression exp = new Expression(ExpressionOperator.AND);
                exp.AddCondition(new Condition(Constants.FIELD_ID, FilterOperator.Equal, QuoteId));

                query.SetCriteria(exp);

                Join quoteLineItem = new Join(Constants.OBJ_QUOTE, Constants.OBJ_CPQ_QUOTELINEITEM, Constants.FIELD_ID, Constants.FIELD_QUOTEID, JoinType.LEFT);
                quoteLineItem.EntityAlias = Constants.OBJ_CPQ_QUOTELINEITEM;
                query.AddJoin(quoteLineItem);

                Join lineItem = new Join(Constants.OBJ_CPQ_QUOTELINEITEM, Constants.OBJ_LINEITEM, Constants.FIELD_DERIVEDFROMId, Constants.FIELD_ID, JoinType.LEFT);
                lineItem.EntityAlias = Constants.OBJ_LINEITEM;
                query.AddJoin(lineItem);

                Join product = new Join(Constants.OBJ_CPQ_QUOTELINEITEM, Constants.OBJ_PRODUCT, Constants.FIELD_PRODUCTID, Constants.FIELD_ID, JoinType.LEFT);
                product.EntityAlias = Constants.OBJ_PRODUCT;
                query.AddJoin(product);

                var jsonQuery = query.Serialize();

                var reqConfig = new RequestConfigModel();
                reqConfig.accessToken = accessToken;
                reqConfig.searchType = SearchType.AQL;
                reqConfig.objectName = Constants.OBJ_QUOTE;

                var response = Utilities.Search(jsonQuery, reqConfig);
                ResultUSDQuoteHeaderLineItemFields resultQuoteHeaderAndLIneItems = new ResultUSDQuoteHeaderLineItemFields();
                ResultQuoteHeaderModel resultQuoteHeaderModel = new ResultQuoteHeaderModel();
                List<ResultQuoteLineItem> lstResultQuoteLineItem = new List<ResultQuoteLineItem>();

                if (response != null && response.IsSuccessStatusCode)
                {
                    var responseString = JObject.Parse(response.Content.ReadAsStringAsync().Result).SelectToken(Constants.NODE_SERIALIZEDRESULTENTITIES).ToString();
                    List<QuoteQuoteLineDetails> QuoteLineList = new List<QuoteQuoteLineDetails>();

                    QuoteLineList = JsonConvert.DeserializeObject<List<QuoteQuoteLineDetails>>(responseString);

                    if (QuoteLineList != null && QuoteLineList.Count > 0)
                    {

                        LineItemRepository lineItemRepo = new LineItemRepository();
                        //Calculate quote line item USD fields 
                        for (int i = 0; i < QuoteLineList.Count; i++)
                        {
                            ResultQuoteLineItem objResultQuoteLineItem = new ResultQuoteLineItem();

                            objResultQuoteLineItem.Id = QuoteLineList[i].cpq_QuoteLineItem.Id;
                            objResultQuoteLineItem.ext_ListPriceWithAdjustments = QuoteLineList[i].cpq_QuoteLineItem.BasePrice.ConvertToDecimal();

                            if (QuoteLineList[i].cpq_QuoteLineItem.ListPrice != 0)
                            {
                                objResultQuoteLineItem.ext_AdjustmentAmount = (QuoteLineList[i].cpq_QuoteLineItem.ListPrice.ConvertToDecimal() * QuoteLineList[i].cpq_QuoteLineItem.Quantity2.ConvertToDecimal() * QuoteLineList[i].cpq_QuoteLineItem.Term.ConvertToDecimal()) - QuoteLineList[i].cpq_QuoteLineItem.NetPrice.ConvertToDecimal();
                                objResultQuoteLineItem.ext_AdjustmentDiscountPercent = objResultQuoteLineItem.ext_AdjustmentAmount * 100 / (QuoteLineList[i].cpq_QuoteLineItem.ListPrice.ConvertToDecimal() * QuoteLineList[i].cpq_QuoteLineItem.Quantity2.ConvertToDecimal() * QuoteLineList[i].cpq_QuoteLineItem.Term.ConvertToDecimal());
                            }


                            if (QuoteLineList[i].crm_Product.Family != null && QuoteLineList[i].crm_Product.Family.Value.ConvertToStringNull() != null && QuoteLineList[i].cpq_QuoteLineItem.ProductId.Ext_Family.Value.ToString() != Constants.STR_SUBSCRIPTION)
                            {
                                objResultQuoteLineItem.ext_AnnualContractValue = 0;
                                objResultQuoteLineItem.ext_AnnualListPrice = 0;
                            }
                            else
                            {
                                if (QuoteLineList[i].cpq_QuoteLineItem.SellingFrequency != null && QuoteLineList[i].cpq_QuoteLineItem.SellingFrequency.ConvertToStringNull() != null && QuoteLineList[i].cpq_QuoteLineItem.SellingFrequency.Value.ToString() == Constants.STR_YEARLY)
                                {
                                    objResultQuoteLineItem.ext_AnnualContractValue = QuoteLineList[i].cpq_QuoteLineItem.NetUnitPrice.ConvertToDecimal() * QuoteLineList[i].cpq_QuoteLineItem.Quantity2;
                                    objResultQuoteLineItem.ext_AnnualListPrice = QuoteLineList[i].cpq_QuoteLineItem.ListPrice.ConvertToDecimal() * QuoteLineList[i].cpq_QuoteLineItem.Quantity2;
                                }
                                else
                                {
                                    objResultQuoteLineItem.ext_AnnualContractValue = QuoteLineList[i].cpq_QuoteLineItem.NetUnitPrice.ConvertToDecimal() * 12 * QuoteLineList[i].cpq_QuoteLineItem.Quantity2;
                                    objResultQuoteLineItem.ext_AnnualListPrice = QuoteLineList[i].cpq_QuoteLineItem.ListPrice.ConvertToDecimal() * 12 * QuoteLineList[i].cpq_QuoteLineItem.Quantity2;
                                }
                            }


                            objResultQuoteLineItem.ext_EstimatedTax = QuoteLineList[i].cpq_QuoteLineItem.ext_EstimatedTax.ConvertToDecimal();

                            //Estimated Total: Total Value + EstimatedTax 
                            objResultQuoteLineItem.ext_EstimatedTotal = QuoteLineList[i].cpq_QuoteLineItem.NetPrice.ConvertToDecimal() + objResultQuoteLineItem.ext_EstimatedTax.ConvertToDecimal();

                            //Sales Price
                            objResultQuoteLineItem.ext_SalesPrice = QuoteLineList[i].cpq_QuoteLineItem.NetUnitPrice.ConvertToDecimal();

                            //get daily currenct exchange rates based on currency code
                            DailyExcnageRate objDailyExcnageRate = lineItemRepo.GetExchangeRateDetails(QuoteLineList[i].cpq_lineitem.CurrencyId, accessToken);

                            //USD fields
                            if (objDailyExcnageRate != null)
                            {
                                objResultQuoteLineItem.ext_USDAdjustment = objDailyExcnageRate.ext_Rate * QuoteLineList[i].cpq_QuoteLineItem.Ext_AdjustmentAmount.ConvertToDecimal();
                                objResultQuoteLineItem.ext_USDBasePrice = objDailyExcnageRate.ext_Rate * QuoteLineList[i].cpq_QuoteLineItem.BasePrice.ConvertToDecimal();
                                objResultQuoteLineItem.ext_USDTotalValue = objDailyExcnageRate.ext_Rate * (QuoteLineList[i].cpq_QuoteLineItem.NetPrice.ConvertToDecimal());
                                objResultQuoteLineItem.ext_USDListPrice = objDailyExcnageRate.ext_Rate * (QuoteLineList[i].cpq_QuoteLineItem.ListPrice.ConvertToDecimal());
                                objResultQuoteLineItem.ext_USDSalesPrice = objDailyExcnageRate.ext_Rate * (QuoteLineList[i].cpq_QuoteLineItem.NetUnitPrice.ConvertToDecimal());
                                objResultQuoteLineItem.ext_USDAnnualContractValue = objDailyExcnageRate.ext_Rate * QuoteLineList[i].cpq_QuoteLineItem.AnnualContractValue.ConvertToDecimal();
                                objResultQuoteLineItem.ext_USDAnnualListPrice = objDailyExcnageRate.ext_Rate * QuoteLineList[i].cpq_QuoteLineItem.AnnualListPrice.ConvertToDecimal();
                            }
                            lstResultQuoteLineItem.Add(objResultQuoteLineItem);
                        }
                    }
                    resultQuoteHeaderAndLIneItems.ListQuoteLineItemFinFields = lstResultQuoteLineItem;
                    var responseResult = UpdateQuoteLineItems(lstResultQuoteLineItem, accessToken);
                    return responseResult;
                }
                else
                {
                    HttpResponseMessage jsonResponse = new HttpResponseMessage();
                    Model.ErrorInfo errorInfo = new Model.ErrorInfo();
                    errorInfo.Message = "Error";
                    var dict = new Dictionary<string, object>
                    {
                        {"Message", "Fail to update records"}
                    };
                    errorInfo.Record = dict;
                    errors.Add(errorInfo);
                    Utilities.CreateResponse(jsonResponse, errors);
                    return jsonResponse;
                }
                //return response

            }
            catch (Exception ex)
            {
                var resp = new HttpResponseMessage
                {
                    Content = new StringContent("Message :" + ex.Message + " " + "StackStrace :" + ex.StackTrace, System.Text.Encoding.UTF8, "application/json"),
                    StatusCode = System.Net.HttpStatusCode.BadRequest
                };
                return resp;
            }
        }

        /// <summary>
        /// Update calculated Quote line items details
        /// </summary>
        /// <param name="lineItems">list of fileds to be update</param>
        /// <returns></returns>
        public HttpResponseMessage UpdateQuoteLineItems(List<ResultQuoteLineItem> quoteLineItems, string accessToken)
        {
            var reqConfig = new RequestConfigModel();
            reqConfig.accessToken = accessToken;
            reqConfig.objectName = Constants.OBJ_CPQ_QUOTELINEITEM;

            var lstLineItemsToUpdate = new List<dynamic>();
            foreach (var lstLineItems in quoteLineItems)
            {
                lstLineItemsToUpdate.Add(new
                {
                    Id = lstLineItems.Id,
                    ext_ListPriceWithAdjustments = lstLineItems.ext_ListPriceWithAdjustments,
                    ext_AdjustmentAmount = lstLineItems.ext_AdjustmentAmount,
                    ext_AdjustmentDiscountPercent = lstLineItems.ext_AdjustmentDiscountPercent,
                    ext_EstimatedTax = lstLineItems.ext_EstimatedTax,
                    ext_AnnualContractValue = lstLineItems.ext_AnnualContractValue,
                    ext_AnnualListPrice = lstLineItems.ext_AnnualListPrice,
                    ext_EstimatedTotal = lstLineItems.ext_EstimatedTotal,
                    ext_SalesPrice = lstLineItems.ext_SalesPrice,
                    ext_USDAdjustment = lstLineItems.ext_USDAdjustment,
                    ext_USDBasePrice = lstLineItems.ext_USDBasePrice,
                    ext_USDTotalValue = lstLineItems.ext_USDTotalValue,
                    ext_USDListPrice = lstLineItems.ext_USDListPrice,
                    ext_USDSalesPrice = lstLineItems.ext_USDSalesPrice,
                    ext_USDAnnualContractValue = lstLineItems.ext_USDAnnualContractValue,
                    ext_USDAnnualListPrice = lstLineItems.ext_USDAnnualListPrice,
                });
            }

            var responseString = Utilities.Update(lstLineItemsToUpdate, reqConfig);
            return responseString;
        }
        /// <summary>
        /// Default quote details based on rule conditions
        /// </summary>
        /// <param name="QuoteId"></param>
        /// <param name="accessToken"></param>
        /// <returns></returns>
        public HttpResponseMessage DefaultQuoteDetails(string QuoteId, string accessToken)
        {
            try
            {
                //Build AQL Query to fetch Quote's opprtunityID
                var updateResult = new HttpResponseMessage();
                var query = new Query(Constants.OBJ_QUOTE);
                query.AddColumns(Constants.OBJ_QUOTEVALIDATE_DEFAULT_SELECTFIELD.Split(Constants.CHAR_COMMA));
                Expression exp = new Expression(ExpressionOperator.AND);
                exp.AddCondition(new Condition(Constants.FIELD_ID, FilterOperator.Equal, QuoteId));

                Join account = new Join(Constants.OBJ_QUOTE, Constants.OBJ_ACCOUNT, Constants.FIELD_ACCOUNTID, Constants.FIELD_ID, JoinType.LEFT);
                account.EntityAlias = Constants.OBJ_ACCOUNT;
                query.AddJoin(account);

                query.SetCriteria(exp);

                var jsonQuery = query.Serialize();


                var reqConfig = new RequestConfigModel();
                reqConfig.accessToken = accessToken;
                reqConfig.searchType = SearchType.AQL;
                reqConfig.objectName = Constants.OBJ_QUOTE;

                var response = Utilities.Search(jsonQuery, reqConfig);
                ValidateDefaultQuoteResult objValidateDefaultQuoteResult = new ValidateDefaultQuoteResult();
                List<Dictionary<string, object>> ListQuoteFieldToUpdate = new List<Dictionary<string, object>>();

                if (response != null && response.IsSuccessStatusCode)
                {
                    var responseString = JObject.Parse(response.Content.ReadAsStringAsync().Result).SelectToken(Constants.NODE_SERIALIZEDRESULTENTITIES).ToString();
                    List<QuoteValidate> objQuoteOppoDetails = new List<QuoteValidate>();

                    objQuoteOppoDetails = JsonConvert.DeserializeObject<List<QuoteValidate>>(responseString);

                    if (objQuoteOppoDetails != null && objQuoteOppoDetails.Count > 0)
                    {
                        #region "Set default data center based on Country"
                        if (objQuoteOppoDetails.FirstOrDefault().crm_Account != null && objQuoteOppoDetails.FirstOrDefault().crm_Account.ext_Country != null)
                        {
                            #region get country and data center mapping data from xml file
                            Dictionary<string, string> countryDCDict = new Dictionary<string, string>();
                            string path = Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), @"XMLFiles\DataCenterCountryMapping.xml");

                            XDocument XDoc = XDocument.Load(path);
                            try
                            {
                                countryDCDict = XDoc.Descendants("Country").ToDictionary(d => (string)d.Attribute("Name"), d => (string)d);

                                if (countryDCDict.ContainsKey(objQuoteOppoDetails.FirstOrDefault().crm_Account.ext_Country))
                                {
                                    objValidateDefaultQuoteResult.ext_datacenter = countryDCDict[objQuoteOppoDetails.FirstOrDefault().crm_Account.ext_Country];
                                }
                                else
                                {  //setting default data center to United States
                                    objValidateDefaultQuoteResult.ext_datacenter = countryDCDict[Constants.STR_UNITEDSTATES];
                                }

                            }
                            catch (Exception ex)
                            {
                                objValidateDefaultQuoteResult.ErrorMessage = "DataCenterCountryMapping :" + ex.Message;
                            }
                            #endregion
                        }
                        #endregion

                        #region "Set Selling entity"
                        if (objQuoteOppoDetails.FirstOrDefault().crm_Account != null && objQuoteOppoDetails.FirstOrDefault().crm_Account.ext_Country != null)
                        {

                            #region get country and selling entity mapping data from xml file
                            Dictionary<string, string> countryDCDict = new Dictionary<string, string>();
                            string path = Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), @"XMLFiles\CountryandSellingEntityMapping.xml");

                            XDocument XDoc = XDocument.Load(path);
                            try
                            {
                                countryDCDict = XDoc.Descendants("Country").ToDictionary(d => (string)d.Attribute("Name"), d => (string)d);

                                if (countryDCDict.ContainsKey(objQuoteOppoDetails.FirstOrDefault().crm_Account.ext_Country))
                                {
                                    objValidateDefaultQuoteResult.ext_SellingEntity = countryDCDict[objQuoteOppoDetails.FirstOrDefault().crm_Account.ext_Country];
                                }
                                else
                                {
                                    objValidateDefaultQuoteResult.ext_SellingEntity = countryDCDict[Constants.STR_NEDERLAND];
                                }
                            }
                            catch (Exception ex)
                            {
                                objValidateDefaultQuoteResult.ErrorMessage += " CountryandSellingEntityMapping :" + ex.Message;
                            }
                            #endregion
                        }
                        #endregion

                        #region "Set PriceList based on currency and vice versa"

                        //Build AQL Query to fetch pricelist details 
                        var priceListId = objQuoteOppoDetails.FirstOrDefault().PriceListId != null ? objQuoteOppoDetails.FirstOrDefault().PriceListId.Id : null;

                        if (!string.IsNullOrEmpty(priceListId))
                        {
                            var queryPricelist = new Query(Constants.OBJ_PRICELIST);
                            queryPricelist.AddColumns(Constants.OBJ_PRICELIST_SELECTFIELD.Split(Constants.CHAR_COMMA));
                            Expression expPriceList = new Expression(ExpressionOperator.AND);
                            expPriceList.AddCondition(new Condition(Constants.FIELD_ID, FilterOperator.Equal, priceListId));

                            queryPricelist.SetCriteria(expPriceList);

                            jsonQuery = queryPricelist.Serialize();

                            reqConfig = new RequestConfigModel();
                            reqConfig.accessToken = accessToken;
                            reqConfig.searchType = SearchType.AQL;
                            reqConfig.objectName = Constants.OBJ_PRICELIST;

                            var responsePricelistDetail = Utilities.Search(jsonQuery, reqConfig);
                            if (responsePricelistDetail != null && responsePricelistDetail.IsSuccessStatusCode)
                            {
                                var responsePriceListString = JObject.Parse(responsePricelistDetail.Content.ReadAsStringAsync().Result).SelectToken(Constants.NODE_SERIALIZEDRESULTENTITIES).ToString();
                                List<QQuoteLineItem> objPriceListResult = new List<QQuoteLineItem>();
                                objPriceListResult = JsonConvert.DeserializeObject<List<QQuoteLineItem>>(responsePriceListString);

                                if (objPriceListResult != null && objPriceListResult.Count > 0)
                                {
                                    if (!string.IsNullOrEmpty(objPriceListResult.FirstOrDefault().CurrencyId))
                                    {
                                        objValidateDefaultQuoteResult.BaseCurrency = objPriceListResult.FirstOrDefault().CurrencyId;
                                    }
                                }

                            }
                        }
                        // PricelistId will be null when Quote is created outside Apttus
                        if (!string.IsNullOrEmpty(objQuoteOppoDetails.FirstOrDefault().ext_BaseCurrency) && string.IsNullOrEmpty(priceListId))
                        {
                            if (objQuoteOppoDetails.FirstOrDefault().ext_Type.Value.ToLower() == Constants.SERVICES || objQuoteOppoDetails.FirstOrDefault().ext_Type.Value.ToLower() == Constants.STR_TRAINING.ToLower())
                            {
                                #region get Currency and Pricelist mapping data from xml file for Services

                                Dictionary<string, string> currencyDCDict = new Dictionary<string, string>();
                                string path = Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), @"XMLFiles\CurrencyandPriceListMappingServices.xml");

                                XDocument XDoc = XDocument.Load(path);
                                try
                                {
                                    currencyDCDict = XDoc.Descendants("Currency").ToDictionary(d => (string)d.Attribute("Name"), d => (string)d);
                                    if (currencyDCDict.ContainsKey(objQuoteOppoDetails.FirstOrDefault().ext_BaseCurrency))
                                    {
                                        objValidateDefaultQuoteResult.PriceListName = currencyDCDict[objQuoteOppoDetails.FirstOrDefault().ext_BaseCurrency];
                                        if (objQuoteOppoDetails.FirstOrDefault().ext_BaseCurrency == Constants.STR_USD)
                                        {
                                            if (objQuoteOppoDetails.FirstOrDefault().crm_Account.ext_Country == Constants.STR_AUSTRALIA)
                                            {
                                                objValidateDefaultQuoteResult.PriceListName = "Australian (USD) Services";
                                            }
                                            else if (objQuoteOppoDetails.FirstOrDefault().crm_Account.ext_Country == Constants.STR_JAPAN)
                                            {
                                                objValidateDefaultQuoteResult.PriceListName = "Japan (USD) Subscription";
                                            }
                                        }
                                    }
                                    else
                                    {
                                        objValidateDefaultQuoteResult.PriceListName = currencyDCDict[Constants.STR_USD];
                                    }
                                }
                                catch (Exception ex)
                                {
                                    objValidateDefaultQuoteResult.ErrorMessage += " CurrencyandPriceListMappingServices :" + ex.Message;
                                }
                                #endregion
                            }
                            else// Remaining types will be for Subscription
                            {
                                #region get Currency and Pricelist mapping data from xml file for Subscription
                                Dictionary<string, string> currencyDCDict = new Dictionary<string, string>();
                                string path = Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), @"XMLFiles\CurrencyandPriceListMapping.xml");

                                XDocument XDoc = XDocument.Load(path);
                                try
                                {
                                    currencyDCDict = XDoc.Descendants("Currency").ToDictionary(d => (string)d.Attribute("Name"), d => (string)d);

                                    if (currencyDCDict.ContainsKey(objQuoteOppoDetails.FirstOrDefault().ext_BaseCurrency))
                                    {
                                        objValidateDefaultQuoteResult.PriceListName = currencyDCDict[objQuoteOppoDetails.FirstOrDefault().ext_BaseCurrency];
                                    }
                                    else
                                    {
                                        objValidateDefaultQuoteResult.PriceListName = currencyDCDict[Constants.STR_USD];
                                    }
                                }
                                catch (Exception ex)
                                {
                                    objValidateDefaultQuoteResult.ErrorMessage += " CurrencyandPriceListMapping :" + ex.Message;
                                }
                                #endregion
                            }
                        }
                        #endregion

                        //Update Quote fileds to default values
                        ListQuoteFieldToUpdate = new List<Dictionary<string, object>>();
                        Dictionary<string, object> QuoteFieldToUpdate = new Dictionary<string, object>();
                        QuoteFieldToUpdate.Add("Id", QuoteId);
                        if (!string.IsNullOrEmpty(objValidateDefaultQuoteResult.ext_datacenter))
                        {
                            QuoteFieldToUpdate.Add("ext_datacenter", objValidateDefaultQuoteResult.ext_datacenter);
                        }
                        if (!string.IsNullOrEmpty(objValidateDefaultQuoteResult.ext_SellingEntity))
                        {

                            //Build AQL Query to fetch Account details 
                            var queryQuote = new Query(Constants.OBJ_ACCOUNT);
                            queryQuote.AddColumns(Constants.OBJ_ACCOUNT_SELECTFIELD.Split(Constants.CHAR_COMMA));
                            Expression expQuote = new Expression(ExpressionOperator.AND);
                            expQuote.AddCondition(new Condition(Constants.FIELD_NAME, FilterOperator.Equal, objValidateDefaultQuoteResult.ext_SellingEntity));

                            queryQuote.SetCriteria(expQuote);

                            jsonQuery = queryQuote.Serialize();

                            reqConfig = new RequestConfigModel();
                            reqConfig.accessToken = accessToken;
                            reqConfig.searchType = SearchType.AQL;
                            reqConfig.objectName = Constants.OBJ_ACCOUNT;

                            var responseAccountDetail = Utilities.Search(jsonQuery, reqConfig);
                            if (responseAccountDetail != null && responseAccountDetail.IsSuccessStatusCode)
                            {
                                var responseAccountString = JObject.Parse(responseAccountDetail.Content.ReadAsStringAsync().Result).SelectToken(Constants.NODE_SERIALIZEDRESULTENTITIES).ToString();
                                List<AccountCountry> objAccountResult = new List<AccountCountry>();
                                objAccountResult = JsonConvert.DeserializeObject<List<AccountCountry>>(responseAccountString);

                                if (objAccountResult != null && objAccountResult.Count > 0)
                                {
                                    Dictionary<string, object> dictAccount = new Dictionary<string, object>();
                                    dictAccount.Add("Id", objAccountResult.FirstOrDefault().Id);
                                    dictAccount.Add("Name", objAccountResult.FirstOrDefault().Name);

                                    QuoteFieldToUpdate.Add("ext_SellingEntity", dictAccount);
                                }
                            }


                        }
                        if (!string.IsNullOrEmpty(objValidateDefaultQuoteResult.PriceListName))
                        {

                            //Build AQL Query to fetch Account details 
                            var queryPriceList = new Query(Constants.OBJ_PRICELIST);
                            queryPriceList.AddColumns(Constants.OBJ_PRICELIST_SELECTFIELD.Split(Constants.CHAR_COMMA));
                            Expression expPriceLIst = new Expression(ExpressionOperator.AND);
                            expPriceLIst.AddCondition(new Condition(Constants.FIELD_NAME, FilterOperator.Equal, objValidateDefaultQuoteResult.PriceListName));

                            queryPriceList.SetCriteria(expPriceLIst);

                            jsonQuery = queryPriceList.Serialize();

                            reqConfig = new RequestConfigModel();
                            reqConfig.accessToken = accessToken;
                            reqConfig.searchType = SearchType.AQL;
                            reqConfig.objectName = Constants.OBJ_PRICELIST;

                            var responsePricelistDetail = Utilities.Search(jsonQuery, reqConfig);
                            if (responsePricelistDetail != null && responsePricelistDetail.IsSuccessStatusCode)
                            {
                                var responsePricelistString = JObject.Parse(responsePricelistDetail.Content.ReadAsStringAsync().Result).SelectToken(Constants.NODE_SERIALIZEDRESULTENTITIES).ToString();
                                List<LookUp> objPriceListResult = new List<LookUp>();
                                objPriceListResult = JsonConvert.DeserializeObject<List<LookUp>>(responsePricelistString);

                                if (objPriceListResult != null && objPriceListResult.Count > 0)
                                {
                                    Dictionary<string, object> dictAccount = new Dictionary<string, object>();
                                    dictAccount.Add("Id", objPriceListResult.FirstOrDefault().Id);
                                    dictAccount.Add("Name", objPriceListResult.FirstOrDefault().Name);

                                    QuoteFieldToUpdate.Add("PriceListId", dictAccount);
                                }
                            }


                        }
                        if (!string.IsNullOrEmpty(objValidateDefaultQuoteResult.BaseCurrency))
                        {
                            QuoteFieldToUpdate.Add("ext_BaseCurrency", objValidateDefaultQuoteResult.BaseCurrency);
                        }
                        #region "Set Sales Partner"
                        //Build AQL Query to fetch Sales Partner Account details 
                        if (objQuoteOppoDetails.Count > 0 && objQuoteOppoDetails.FirstOrDefault().ext_PartnerAccountMDMID != null)
                        {
                            var querySalesParnterAccount = new Query(Constants.OBJ_ACCOUNT);
                            querySalesParnterAccount.AddColumns(Constants.OBJ_ACCOUNT_SELECTFIELD.Split(Constants.CHAR_COMMA));
                            Expression expSalesPartner = new Expression(ExpressionOperator.AND);
                            expSalesPartner.AddCondition(new Condition(Constants.FIELD_EXTERNALID, FilterOperator.Equal, objQuoteOppoDetails.FirstOrDefault().ext_PartnerAccountMDMID));

                            querySalesParnterAccount.SetCriteria(expSalesPartner);

                            jsonQuery = querySalesParnterAccount.Serialize();

                            reqConfig = new RequestConfigModel();
                            reqConfig.accessToken = accessToken;
                            reqConfig.searchType = SearchType.AQL;
                            reqConfig.objectName = Constants.OBJ_ACCOUNT;

                            var responseSalesParnterAccountDetail = Utilities.Search(jsonQuery, reqConfig);

                            if (responseSalesParnterAccountDetail != null && responseSalesParnterAccountDetail.IsSuccessStatusCode)
                            {
                                var responseAccountString = JObject.Parse(responseSalesParnterAccountDetail.Content.ReadAsStringAsync().Result).SelectToken(Constants.NODE_SERIALIZEDRESULTENTITIES).ToString();
                                List<AccountCountry> objAccountResult = new List<AccountCountry>();
                                objAccountResult = JsonConvert.DeserializeObject<List<AccountCountry>>(responseAccountString);

                                if (objAccountResult != null && objAccountResult.Count > 0)
                                {
                                    Dictionary<string, object> dictAccount = new Dictionary<string, object>();
                                    dictAccount.Add("Id", objAccountResult.FirstOrDefault().Id);
                                    dictAccount.Add("Name", objAccountResult.FirstOrDefault().Name);
                                    QuoteFieldToUpdate.Add("ext_SalesPartner", dictAccount);
                                }
                            }
                        }
                        #endregion

                        ListQuoteFieldToUpdate.Add(QuoteFieldToUpdate);
                        updateResult = UpdateQuoteIsPrimary(ListQuoteFieldToUpdate, accessToken);
                    }
                }

                if (updateResult.IsSuccessStatusCode)
                {//Create response message
                    var resp = new HttpResponseMessage
                    {
                        Content = new StringContent(JsonConvert.SerializeObject(objValidateDefaultQuoteResult), System.Text.Encoding.UTF8, "application/json"),
                        StatusCode = System.Net.HttpStatusCode.OK
                    };
                    return resp;
                }
                else
                {
                    return updateResult;
                }
            }
            catch (Exception ex)
            {
                var resp = new HttpResponseMessage
                {
                    Content = new StringContent("Message :" + ex.Message + " " + "StackStrace :" + ex.StackTrace, System.Text.Encoding.UTF8, "application/json"),
                    StatusCode = System.Net.HttpStatusCode.BadRequest
                };
                return resp;
            }

        }

        /// <summary>
        /// Validate Quote details
        /// </summary>
        /// <param name="QuoteId"></param>
        /// <param name="setIsPrimary"></param>
        /// <param name="accessToken"></param>
        /// <returns></returns>
        public HttpResponseMessage ValidateQuoteDetails(string QuoteId, bool setIsPrimary, string accessToken)
        {
            try
            {
                //Build AQL Query to fetch Quote's opprtunityID
                var updateResult = new HttpResponseMessage();
                var query = new Query(Constants.OBJ_QUOTE);
                query.AddColumns(Constants.OBJ_QUOTEVALIDATE_DEFAULT_SELECTFIELD.Split(Constants.CHAR_COMMA));
                Expression exp = new Expression(ExpressionOperator.AND);
                exp.AddCondition(new Condition(Constants.FIELD_ID, FilterOperator.Equal, QuoteId));

                Join account = new Join(Constants.OBJ_QUOTE, Constants.OBJ_ACCOUNT, Constants.FIELD_ACCOUNTID, Constants.FIELD_ID, JoinType.LEFT);
                account.EntityAlias = Constants.OBJ_ACCOUNT;
                query.AddJoin(account);

                query.SetCriteria(exp);

                var jsonQuery = query.Serialize();


                var reqConfig = new RequestConfigModel();
                reqConfig.accessToken = accessToken;
                reqConfig.searchType = SearchType.AQL;
                reqConfig.objectName = Constants.OBJ_QUOTE;

                var response = Utilities.Search(jsonQuery, reqConfig);
                ValidateDefaultQuoteResult objValidateDefaultQuoteResult = new ValidateDefaultQuoteResult();
                List<Dictionary<string, object>> ListQuoteFieldToUpdate = new List<Dictionary<string, object>>();

                if (response != null && response.IsSuccessStatusCode)
                {
                    var responseString = JObject.Parse(response.Content.ReadAsStringAsync().Result).SelectToken(Constants.NODE_SERIALIZEDRESULTENTITIES).ToString();
                    List<QuoteValidate> objQuoteOppoDetails = new List<QuoteValidate>();

                    objQuoteOppoDetails = JsonConvert.DeserializeObject<List<QuoteValidate>>(responseString);

                    if (objQuoteOppoDetails != null && objQuoteOppoDetails.Count > 0)
                    {
                        #region "Validate and Set IsPrimary true for only current Quote"
                        //Validate all quotes for an opportunity and update current Quote IsPrimary field set to true and rest of the Quotes IsPrimary will be set to false.
                        if (objQuoteOppoDetails.FirstOrDefault().IsPrimary != null)
                        {
                            setIsPrimary = Convert.ToBoolean(ConversionHelper.ConvertToBool(objQuoteOppoDetails.FirstOrDefault().IsPrimary));
                        }
                        else
                        {
                            setIsPrimary = false;
                        }
                        if (setIsPrimary && objQuoteOppoDetails.FirstOrDefault().ext_OpportunitySysId != null)
                        {
                            //Build AQL Query to fetch all quotes of opprtunityID 
                            var queryQuote = new Query(Constants.OBJ_QUOTE);
                            queryQuote.AddColumns(Constants.OBJ_QUOTEOPPORTUNITY_SELECTFIELD.Split(Constants.CHAR_COMMA));
                            Expression expQuote = new Expression(ExpressionOperator.AND);
                            expQuote.AddCondition(new Condition(Constants.FIELD_OPPORTUNITYSYSID, FilterOperator.Equal, objQuoteOppoDetails[0].ext_OpportunitySysId));

                            queryQuote.SetCriteria(expQuote);

                            jsonQuery = queryQuote.Serialize();

                            reqConfig = new RequestConfigModel();
                            reqConfig.accessToken = accessToken;
                            reqConfig.searchType = SearchType.AQL;
                            reqConfig.objectName = Constants.OBJ_QUOTE;

                            var responseQuotewithOppo = Utilities.Search(jsonQuery, reqConfig);
                            if (responseQuotewithOppo != null && responseQuotewithOppo.IsSuccessStatusCode)
                            {
                                var responseQuotewithOppoString = JObject.Parse(responseQuotewithOppo.Content.ReadAsStringAsync().Result).SelectToken(Constants.NODE_SERIALIZEDRESULTENTITIES).ToString();
                                List<QuoteValidate> objQuoteOppoResult = new List<QuoteValidate>();
                                objQuoteOppoResult = JsonConvert.DeserializeObject<List<QuoteValidate>>(responseQuotewithOppoString);

                                //Check for any other Quote is set to IsPrimary to true 
                                ListQuoteFieldToUpdate = new List<Dictionary<string, object>>();
                                Dictionary<string, object> QuoteFieldToUpdate = new Dictionary<string, object>();
                                var otherQuoteIsPrimary = objQuoteOppoResult.Where(x => x.Id != QuoteId && x.IsPrimary == true);
                                if (otherQuoteIsPrimary != null && otherQuoteIsPrimary.Count() > 0)
                                {
                                    //Set any other Quotes IsPrimary value to false
                                    foreach (var item in otherQuoteIsPrimary)
                                    {
                                        QuoteFieldToUpdate = new Dictionary<string, object>();
                                        QuoteFieldToUpdate.Add("Id", item.Id);
                                        QuoteFieldToUpdate.Add("IsPrimary", false);
                                        ListQuoteFieldToUpdate = new List<Dictionary<string, object>>();
                                        ListQuoteFieldToUpdate.Add(QuoteFieldToUpdate);

                                        UpdateQuoteIsPrimary(ListQuoteFieldToUpdate, accessToken);
                                    }
                                }

                                //Update only current Quote as IsPrimary true
                                QuoteFieldToUpdate = new Dictionary<string, object>();
                                QuoteFieldToUpdate.Add("Id", QuoteId);
                                QuoteFieldToUpdate.Add("IsPrimary", true);
                                ListQuoteFieldToUpdate = new List<Dictionary<string, object>>();
                                ListQuoteFieldToUpdate.Add(QuoteFieldToUpdate);

                                updateResult = UpdateQuoteIsPrimary(ListQuoteFieldToUpdate, accessToken);
                                objValidateDefaultQuoteResult.IsPrimarySet = updateResult.IsSuccessStatusCode;
                            }
                        }
                        #endregion

                        #region "Currency Based on pricing"
                        if (objQuoteOppoDetails.Count > 0 && objQuoteOppoDetails.FirstOrDefault().PriceListId != null)
                        {
                            var queryPriceListCurrency = new Query(Constants.OBJ_PRICELIST);
                            queryPriceListCurrency.AddColumns(Constants.OBJ_PRICELIST_SELECTFIELD.Split(Constants.CHAR_COMMA));
                            Expression expPriceListCurrency = new Expression(ExpressionOperator.AND);
                            expPriceListCurrency.AddCondition(new Condition(Constants.FIELD_ID, FilterOperator.Equal, objQuoteOppoDetails.FirstOrDefault().PriceListId.Id));

                            queryPriceListCurrency.SetCriteria(expPriceListCurrency);

                            jsonQuery = queryPriceListCurrency.Serialize();

                            reqConfig = new RequestConfigModel();
                            reqConfig.accessToken = accessToken;
                            reqConfig.searchType = SearchType.AQL;
                            reqConfig.objectName = Constants.OBJ_PRICELIST;

                            var responsePricelistCurrencyDetail = Utilities.Search(jsonQuery, reqConfig);
                            if (responsePricelistCurrencyDetail != null && responsePricelistCurrencyDetail.IsSuccessStatusCode)
                            {
                                var responsePricelistString = JObject.Parse(responsePricelistCurrencyDetail.Content.ReadAsStringAsync().Result).SelectToken(Constants.NODE_SERIALIZEDRESULTENTITIES).ToString();
                                List<QQuoteLineItem> objPriceListResult = new List<QQuoteLineItem>();
                                objPriceListResult = JsonConvert.DeserializeObject<List<QQuoteLineItem>>(responsePricelistString);

                                if (objPriceListResult != null && objPriceListResult.Count > 0)
                                {
                                    ListQuoteFieldToUpdate = new List<Dictionary<string, object>>();
                                    Dictionary<string, object> QuoteFieldToUpdate = new Dictionary<string, object>();

                                    QuoteFieldToUpdate = new Dictionary<string, object>();
                                    QuoteFieldToUpdate.Add("Id", QuoteId);
                                    QuoteFieldToUpdate.Add("ext_BaseCurrency", Convert.ToString(objPriceListResult.FirstOrDefault().CurrencyId));
                                    ListQuoteFieldToUpdate = new List<Dictionary<string, object>>();
                                    ListQuoteFieldToUpdate.Add(QuoteFieldToUpdate);

                                    updateResult = UpdateQuoteIsPrimary(ListQuoteFieldToUpdate, accessToken);
                                    //objValidateDefaultQuoteResult.IsPrimarySet = updateResult.IsSuccessStatusCode;
                                }
                            }
                        }
                        #endregion
                    }
                }
                return updateResult;
            }
            catch (Exception ex)
            {
                var resp = new HttpResponseMessage
                {
                    Content = new StringContent("Message :" + ex.Message + " " + "StackStrace :" + ex.StackTrace, System.Text.Encoding.UTF8, "application/json"),
                    StatusCode = System.Net.HttpStatusCode.BadRequest
                };
                return resp;
            }

        }

        /// <summary>
        /// To update IsPrimary field of Quote
        /// </summary>
        /// <param name="quoteHeaderList"></param>
        /// <param name="accessToken"></param>
        /// <returns></returns>
        public HttpResponseMessage UpdateQuoteIsPrimary(List<Dictionary<string, object>> quoteHeaderList, string accessToken)
        {
            var reqConfig = new RequestConfigModel();
            reqConfig.accessToken = accessToken;
            reqConfig.objectName = Constants.OBJ_QUOTE;
            var responseString = Utilities.Update(quoteHeaderList, reqConfig);
            return responseString;
        }

        #region Approvals On Quote

        /// <summary>
        /// Get, Calculate and update Approval Fields
        /// </summary>
        /// <param name="QuoteId"></param>
        /// <param name="accessToken"></param>
        /// <returns></returns>
        public HttpResponseMessage CalculateApprovalFields(string QuoteId, string accessToken)
        {
            try
            {
                //Build AQL Query to fetch Quote's opprtunityID
                var updateResult = new HttpResponseMessage();
                var query = new Query(Constants.OBJ_QUOTE);
                query.AddColumns(Constants.OBJ_APPROVALCALCULATION_DEFAULT_SELECTFIELDS.Split(Constants.CHAR_COMMA));
                Expression exp = new Expression(ExpressionOperator.AND);
                exp.AddCondition(new Condition(Constants.FIELD_ID, FilterOperator.Equal, QuoteId));
                query.SetCriteria(exp);

                Join quoteLineItem = new Join(Constants.OBJ_QUOTE, Constants.OBJ_CPQ_QUOTELINEITEM, Constants.FIELD_ID, Constants.FIELD_QUOTEID, JoinType.LEFT, Constants.OBJALIAS_QUOTELINEITEM);
                query.AddJoin(quoteLineItem);

                Join agreement = new Join(Constants.OBJ_QUOTE, Constants.OBJ_AGREEMENT, Constants.FIELD_EXT_REFAGREEMENT, Constants.FIELD_ID, JoinType.LEFT, Constants.OBJALIAS_AGREEMENT);
                query.AddJoin(agreement);

                var jsonQuery = query.Serialize();
                var reqConfig = new RequestConfigModel()
                {
                    accessToken = accessToken,
                    searchType = SearchType.AQL,
                    objectName = Constants.OBJ_QUOTE
                };
                var response = Utilities.Search(jsonQuery, reqConfig);
                if (response != null && response.IsSuccessStatusCode)
                {
                    var responseString = JObject.Parse(response.Content.ReadAsStringAsync().Result).SelectToken(Constants.NODE_SERIALIZEDRESULTENTITIES).ToString();
                    var quoteDetails = JsonConvert.DeserializeObject<List<QuoteResponseApproval>>(responseString);

                    if (quoteDetails != null && quoteDetails.Count() > 0)
                    {
                        //Inialize variables
                        double ext_DealSize = 0.0;
                        decimal ext_MaxDiscount = 0.0m;
                        int ext_RenewalCount = 0;
                        bool ext_ApproverUserDiscount = false;
                        bool ext_CustomerSatisfactionException = false;
                        bool ext_EndOfLifeProducts = false;

                        //Logic to update Approval Fields
                        DealSizeCalculation(quoteDetails, ref ext_DealSize, accessToken);
                        MaxDiscountCalculation(quoteDetails, ref ext_MaxDiscount);
                        RenewalCountCalculation(quoteDetails, ref ext_RenewalCount);
                        ApproverUserDiscountCalculation(quoteDetails, ref ext_ApproverUserDiscount);
                        CustomerSatisfactionExceptionApprovalCalculation(quoteDetails, ref ext_CustomerSatisfactionException);
                        EndOfLifeProductsApprovalCalculation(quoteDetails, ref ext_EndOfLifeProducts);

                        //Add all approval fields into dictionary
                        var QuoteFieldToUpdate = new Dictionary<string, object>
                        {
                            { "Id", QuoteId },
                            { "ext_DealSize", ext_DealSize },
                            { "ext_MaxDiscount", ext_MaxDiscount },
                            { "ext_RenewalCount", ext_RenewalCount },
                            { "ext_ApproverUserDiscount", ext_ApproverUserDiscount },
                            { "ext_EndOfLifeProductsApproval", ext_EndOfLifeProducts },
                            { "ext_CustomerSatisfactionExceptionApproval", ext_MaxDiscount }
                        };

                        //Update fields via API
                        updateResult = UpdateQuoteWithApprovalFields(new List<Dictionary<string, object>>() { QuoteFieldToUpdate }, accessToken);
                    }
                }
                return updateResult;
            }
            catch (Exception ex)
            {
                //TODO
                throw;
            }

        }

        /// <summary>
        /// Deal size calculation
        /// </summary>
        /// <param name="quoteDetails"></param>
        /// <param name="ext_DealSize"></param>
        /// <returns></returns>
        private void DealSizeCalculation(List<QuoteResponseApproval> quoteDetails, ref double ext_DealSize, string accessToken)
        {
            // Get subscription products 
            var subscriptionFamilyQuoteDetails = quoteDetails.Where(q => q.QLI.ProductId.ext_Family != null && q.QLI.ProductId.ext_Family.Key.ConvertToStringNull() == Constants.STR_PRODUCT_FAMILY_SUBSCRIPTIONS).ToList();

            // New Business 
            if (quoteDetails.Where(q => q.ext_Type.ConvertToStringNull() != null && q.ext_Type.Key.ConvertToStringNull() != null && q.ext_Type.Key == Enums.QuoteType.NewBusiness.GetEnumDisplayName()).Count() > 0)
            {
                //  A field on Quote Header.Rollup of USD Annual List Price of all the subscription products in the cart. 
                ext_DealSize = subscriptionFamilyQuoteDetails.Sum(s => s.QLI.ext_USDAnnualListPrice.ConvertToDouble());
            }

            // Upsell  
            if (quoteDetails.Where(q => !string.IsNullOrEmpty(q.ext_Type.Key) && q.ext_Type.Key == Enums.QuoteType.LicenseUpsell.GetEnumDisplayName()).Count() > 0)
            {
                //USD Total Annual List Price = Total Annual List Value from the agreement 
                ext_DealSize = quoteDetails.First().AGR.ext_QuoteId.ext_DealSize.ConvertToDouble();

                //Calculate rollup of USD Annual List Price of all the subscription products in the cart
                var rollUpUSDAnnualListPrice = 0.0;
                //objResultQuoteLineItem.ext_USDListPrice = objDailyExcnageRate.ext_Rate * (QuoteLineList[i].cpq_QuoteLineItem.BasePrice); //To Do: Replace 'BasePrice' with 'ListPrice' while calculating QLI.ext_USDListPrice!!
                subscriptionFamilyQuoteDetails.ForEach(p => rollUpUSDAnnualListPrice += (p.QLI.ext_USDListPrice.ConvertToDouble() * p.QLI.ext_ContractQuantity.ConvertToDouble()));

                // Total Deal Size = Previous value(Agreement's DealSize) + ollup of USD Annual List Price of all the subscription products
                ext_DealSize += rollUpUSDAnnualListPrice;
            }
        }
        /// <summary>
        /// Max Discount Calculation
        /// </summary>
        /// <param name="quoteDetails"></param>
        /// <param name="ext_MaxDiscount"></param>
        /// <returns></returns>
        private void MaxDiscountCalculation(List<QuoteResponseApproval> quoteDetails, ref decimal ext_MaxDiscount)
        {
            var quoteType = quoteDetails.First().ext_Type?.Key.ConvertToStringNull();
            var salesType = quoteDetails.First().ext_salestype?.Key.ConvertToStringNull();

            if ((quoteType == Enums.QuoteType.NewBusiness.GetEnumDisplayName() || quoteType == Enums.QuoteType.LicenseUpsell.GetEnumDisplayName())
                    && (salesType == "Direct" || salesType == "InDirect"))
            {
                // Maximum % of all the discounts on line item. 
                ext_MaxDiscount = quoteDetails.Max(s => (s.QLI.ext_AdjustmentDiscountPercent.ConvertToDecimal()));
            }
        }
        /// <summary>
        /// Renewal count calculations
        /// </summary>
        /// <param name="quoteDetails"></param>
        /// <param name="ext_RenewalCount"></param>
        /// <returns></returns>
        private void RenewalCountCalculation(List<QuoteResponseApproval> quoteDetails, ref int ext_RenewalCount)
        {
            // ext_AdjustmentDiscountPercent Renewal Count -If this.proposal has a previous proposal ( another field on quote ) and that previous proposal doesnt have any predecessor, the count will be calculated as 1.
            var quote = quoteDetails.First();
            if (quote.ext_Type != null && quote.ext_Type.Key.ConvertToStringNull() != null && quote.ext_Type.Key == "Renewal" && quote.AGR != null && quote.AGR.ext_QuoteId != null && quote.AGR.ext_QuoteId.Id.ConvertToString() != null)
            {
                ext_RenewalCount = 1;
            }

        }
        /// <summary>
        /// Approver User Discount Calculation
        /// </summary>
        /// <param name="quoteDetails"></param>
        /// <param name="ext_ApproverUserDiscount"></param>
        /// <returns></returns>
        private void ApproverUserDiscountCalculation(List<QuoteResponseApproval> quoteDetails, ref bool ext_ApproverUserDiscount)
        {
            // For Direct Sale 
            if (quoteDetails.Where(q => q.ext_salestype != null && q.ext_salestype.Key.ConvertToStringNull() != null && q.ext_salestype.Key.Equals("Direct")).Count() > 0)
            {
                ext_ApproverUserDiscount = ((quoteDetails.Where(q => q.ext_salestype != null && q.ext_salestype.Key.ConvertToStringNull() != null && q.ext_salestype.Key == "Direct"
                                                    && q.QLI.AttributeValueId.ext_UserModel != null && q.QLI.AttributeValueId.ext_UserModel.Key.ConvertToStringNull() != null && q.QLI.AttributeValueId.ext_UserModel.Key == "Approver User"
                                                    && q.AccountId.ext_Segment != null && q.AccountId.ext_Segment.Key.ConvertToStringNull() != null && (q.AccountId.ext_Segment.Key.Equals("Commercial")
                                                                                        || q.AccountId.ext_Segment.Key.Equals("Mid-Market") || q.AccountId.ext_Segment.Key.Equals("Small Business"))).Count() > 0
                                             && quoteDetails.Max(s => s.QLI.ext_AdjustmentDiscountPercent.ConvertToDecimal()) == 100.ConvertToDecimal())
                                           ? true
                                           : false);
            }
            // For InDirect Sale 
            else if (quoteDetails.Where(q => q.ext_salestype != null && q.ext_salestype.Key.ConvertToStringNull() != null && q.ext_salestype.Key.Equals("Indirect")
                            && q.ext_SalesPartner != null && !string.IsNullOrEmpty(q.ext_SalesPartner.Name)).Count() > 0)
            {
                ext_ApproverUserDiscount = ((quoteDetails.Where(q => q.ext_salestype != null && !string.IsNullOrEmpty(q.ext_salestype.Key) && q.ext_salestype.Key.Equals("Indirect")
                                                && q.QLI.AttributeValueId.ext_UserModel != null && q.QLI.AttributeValueId.ext_UserModel.Key.ConvertToStringNull() != null && q.QLI.AttributeValueId.ext_UserModel.Key.Equals("Approver User")
                                                && q.ext_SalesPartner.ext_Segment != null && q.ext_SalesPartner.ext_Segment.Key.ConvertToStringNull() != null && (q.ext_SalesPartner.ext_Segment.Key.Equals("Commercial")
                                                        || q.ext_SalesPartner.ext_Segment.Key.Equals("Mid-Market") || q.ext_SalesPartner.ext_Segment.Key.Equals("Small Business"))).Count() > 0
                                              && quoteDetails.Max(s => s.QLI.ext_AdjustmentDiscountPercent.ConvertToDecimal()) == 100.ConvertToDecimal())
                                            ? true
                                            : false);

            }
        }
        /// <summary>
        /// Customer Satisfaction Exception Approval Calculation
        /// </summary>
        /// <param name="quoteDetails"></param>
        /// <param name="ext_CustomerSatisfactionException"></param>
        /// <returns></returns>
        private void CustomerSatisfactionExceptionApprovalCalculation(List<QuoteResponseApproval> quoteDetails, ref bool ext_CustomerSatisfactionException)
        {
            if (quoteDetails.Where(s => s.QLI.ext_AdjustmentDiscountPercent.ConvertToDecimal() == 100.ConvertToDecimal()).ToList().Count > 0)
            {
                ext_CustomerSatisfactionException = true;
            }
        }
        /// <summary>
        /// Customer Satisfaction Exception Approval Calculation
        /// </summary>
        /// <param name="quoteDetails"></param>
        /// <param name="ext_EndOfLifeProducts"></param>
        /// <returns></returns>
        private void EndOfLifeProductsApprovalCalculation(List<QuoteResponseApproval> quoteDetails, ref bool ext_EndOfLifeProducts)
        {
            if (quoteDetails.Where(q => q.ext_Type != null && q.ext_Type.Key.ConvertToStringNull() != null && q.ext_Type.Key.Equals("new_business")
                    && q.QLI.ProductId.ConvertToStringNull() != null && q.QLI.ProductId.ext_ProductLifecycleStatus.ConvertToStringNull() != null
                        && q.QLI.ProductId.ext_ProductLifecycleStatus.Key.ConvertToStringNull() != null && q.QLI.ProductId.ext_ProductLifecycleStatus.Key.Equals("EOS And Inactive")).Count() > 0)
            {
                ext_EndOfLifeProducts = true;
            }
        }

        private HttpResponseMessage UpdateQuoteWithApprovalFields(List<Dictionary<string, object>> quoteHeaderList, string accessToken)
        {
            var reqConfig = new RequestConfigModel()
            {
                accessToken = accessToken,
                objectName = Constants.OBJ_QUOTE
            };
            var responseString = Utilities.Update(quoteHeaderList, reqConfig);
            return responseString;
        }


        /// <summary>
        /// Get, Calculate and update Approval Fields
        /// </summary>
        /// <param name="QuoteId"></param>
        /// <param name="accessToken"></param>
        /// <returns></returns>
        public HttpResponseMessage CalculatePSApprovalFields(string QuoteId, string accessToken)
        {
            try
            {
                var updateResult = new HttpResponseMessage();

                //Build AQL Query to fetch Quote's opprtunityID
                var query = new Query(Constants.OBJ_QUOTE);
                query.AddColumns(Constants.OBJ_PSAPPROVALCALCULATION_DEFAULT_SELECTFIELDS.Split(Constants.CHAR_COMMA));
                Expression exp = new Expression(ExpressionOperator.AND);
                exp.AddCondition(new Condition(Constants.FIELD_ID, FilterOperator.Equal, QuoteId));
                query.SetCriteria(exp);

                Join quoteLineItem = new Join(Constants.OBJ_QUOTE, Constants.OBJ_CPQ_QUOTELINEITEM, Constants.FIELD_ID, Constants.FIELD_QUOTEID, JoinType.LEFT, Constants.OBJALIAS_QUOTELINEITEM)
                {
                    JoinCriteria = new Expression { Conditions = new List<Condition>() { new Condition(Constants.FIELD_ID, FilterOperator.Equal, QuoteId) } }
                };
                query.AddJoin(quoteLineItem);

                Join quoteMileStone = new Join(Constants.OBJ_QUOTE, Constants.OBJ_EXT_MILESTONE, Constants.FIELD_ID, Constants.FIELD_EXT_QUOTEID, JoinType.LEFT, Constants.OBJALIAS_MILESTONE)
                {
                    JoinCriteria = new Expression { Conditions = new List<Condition>() { new Condition(Constants.FIELD_ID, FilterOperator.Equal, QuoteId) } }
                };
                query.AddJoin(quoteMileStone);

                var jsonQuery = query.Serialize();
                var reqConfig = new RequestConfigModel()
                {
                    accessToken = accessToken,
                    searchType = SearchType.AQL,
                    objectName = Constants.OBJ_QUOTE
                };
                var response = Utilities.Search(jsonQuery, reqConfig);
                if (response != null && response.IsSuccessStatusCode)
                {
                    var responseString = JObject.Parse(response.Content.ReadAsStringAsync().Result).SelectToken(Constants.NODE_SERIALIZEDRESULTENTITIES).ToString();
                    var quoteDetails = JsonConvert.DeserializeObject<List<PSQuoteResponseApproval>>(responseString);
                    decimal ext_TEDiscount = 0.0m;
                    decimal ext_AverageDiscount = 0.0m;
                    bool ext_MilestoneExists = false;

                    //Logic to update PS Approval Fields
                    if (quoteDetails != null && quoteDetails.Count() > 0)
                    {
                        ext_MilestoneExists = (quoteDetails.Where(x => (x.MS != null) && (x.MS.Id.ConvertToStringNull() != null)).Count() > 0) ? true : false;
                        CalculateTEDiscount(quoteDetails, ref ext_TEDiscount);
                        CalculateAverageDiscount(quoteDetails, ref ext_AverageDiscount);

                        //Update all PS approval fields
                        var QuoteFieldToUpdate = new Dictionary<string, object>
                        {
                            { "ext_MilestoneExists", ext_MilestoneExists },
                            { "ext_TEDiscount2", ext_TEDiscount.ConvertToDecimal() },
                            { "ext_AverageDiscount", ext_AverageDiscount },
                            { "Id", QuoteId}
                        };
                        updateResult = UpdateQuoteWithApprovalFields(new List<Dictionary<string, object>>() { QuoteFieldToUpdate }, accessToken);
                    }
                }
                return updateResult;
            }
            catch (Exception ex)
            {
                //TODO
                throw;
            }

        }
        /// <summary>
        /// TE discount Calculation
        /// </summary>
        /// <param name="quoteDetails"></param>
        /// <param name="ext_TEDiscount"></param>
        /// <returns></returns>
        private void CalculateTEDiscount(List<PSQuoteResponseApproval> quoteDetails, ref decimal ext_TEDiscount)
        {
            var TAndEProducts = quoteDetails.Where(s => s.QLI.ProductId != null && s.QLI.ProductId.Name.ConvertToStringNull() != null && s.QLI.ProductId.Name.Equals("Travel and Expense"));
            if (TAndEProducts.Count() > 0)
            {
                ext_TEDiscount = TAndEProducts.Max(x => x.QLI.ext_AdjustmentDiscountPercent.ConvertToDecimal());
            }
        }
        /// <summary>
        /// Average discount Calculation
        /// </summary>
        /// <param name="quoteDetails"></param>
        /// <param name="ext_TEDiscount"></param>
        /// <returns></returns>
        private void CalculateAverageDiscount(List<PSQuoteResponseApproval> quoteDetails, ref decimal ext_AverageDiscount)
        {
            var filterdQLIs = quoteDetails.Where(s => s.QLI.ext_AdjustmentDiscountPercent != null && s.QLI.ext_AdjustmentDiscountPercent != 0.0m);
            if (filterdQLIs.Count() > 0)
            {
                ext_AverageDiscount = filterdQLIs.Sum(x => x.QLI.ext_AdjustmentDiscountPercent.ConvertToDecimal()) / filterdQLIs.Count();
            }
        }

        #endregion Approvals On Quote

    }
}