/// <summary>
        /// Return values from ENett API
        /// and prepare response to caller
        /// </summary>
        /// <param name="user">user</param>
        /// <param name="vNettresponse">CompleteIssueVNettVANResponse</param>
        /// <param name="ENettRequestVAN">ENettRequestVAN</param>
        public void SetValues(UserInfo user, CompleteIssueVNettVANResponse vNettResponse, ENettRequestVAN reader)
        {
            if (!vNettResponse.GetIssuedVNettResponse().IsSuccessful)
            {
                // The request failed
                // we need to get support log id from ENett
                SetSupportLogId(vNettResponse.GetIssuedVNettResponse().SupportLogId);

                // The request was not succesfully processed
                // Set the exception code and message
                SetException(user, new CEEException(vNettResponse.GetIssuedVNettResponse().ErrorCode.ToString()
                                                    , vNettResponse.GetIssuedVNettResponse().ErrorDescription).GetCompleteExceptionMessage());

                // No need to go further!
                return;
            }

            // The response is success
            // Let's extract and return to caller all information
            SetVNettTransactionID(vNettResponse.GetIssuedVNettResponse().VNettTransactionID);
            SetPaymentID(vNettResponse.GetReferenceId());
            SetVAN(vNettResponse.GetIssuedVNettResponse().VirtualAccountNumber);
            SetActivationDate(Util.ConvertStringToDate(vNettResponse.GetIssuedVNettResponse().ActivationDate, Const.DateFormat_yyyyMMdd));
            /// EGE - 70723 ENett Response Expiry Date send to FO
            SetExpirationDate(Util.ConvertStringToDate(vNettResponse.GetIssuedVNettResponse().ExpiryDate, Const.DateFormat_MMyyyy));
            SetCardSecurityCode(vNettResponse.GetIssuedVNettResponse().CardSecurityCode);
            SetCardHolderName(vNettResponse.GetIssuedVNettResponse().CardHolderName);
            SetFundedAmount(vNettResponse.GetIssuedVNettResponse().FundedAmount);
            SetMultiUse(Util.ConvertStringToBool(reader.IsMultiUse));
            SetCurrency(vNettResponse.GetIssuedVNettResponse().CurrencyCode);
        }
        /// <summary>
        /// Log VCard request in the table
        /// </summary>
        /// <param name="reader">XML request</param>
        /// <param name="travelerOrder">Traveler order</param>
        /// <param name="percode">Traveler code</param>
        /// <param name="travelerName">Traveler Name</param>
        /// <param name="cc1">Cost center 1</param>
        /// <param name="cc2">Cost center 2</param>
        /// <param name="cc3">Cost center 3</param>
        /// <param name="channel">channel</param>
        /// <param name="response">CompleteIssueVNettVANResponse</param>
        public void InsertNewRequest(ENettRequestVAN reader, int travelerOrder, string percode, string travelerName
                                     , string cc1, string cc2, string cc3, string channel, CompleteIssueVNettVANResponse response)
        {
            string request = String.Format("INSERT INTO VCardBooking ("
                                           + "PaymentId ,TravelerOrder, PosCode, Comcode, BookerPercode, TravelerPercode, TravelerName, AdultCount, AgentLogin, "
                                           + "BookingDate, FundedAmount, Currency, CardActivationDate, CardExpirationDate, IsMultiUseCard, "
                                           + "TruncatedVAN, Product, Channel, ECN, MerchantCategory, MdCode, RefDossierType, RefDossierCode, OriginDate, OriginAddress, "
                                           + "OriginLocationCode, OriginCountryCode, EndDate, EndAddress, EndLocationCode, EndCountryCode, SupplierName, "
                                           + "CC1, CC2, CC3, RequestDate, TripName, FreeText1, FreeText2, FreeText3, HotelId, "
                                           //>>EGE-60949
                                           //+ "ErrorCode, ErrorDesc, CreationDate, CreatedBy, ModificationDate, ModifiedBy, SupportLogId, VNettTransactionID) "
                                           + "ErrorCode, ErrorDesc, CreationDate, CreatedBy, ModificationDate, ModifiedBy, SupportLogId, VNettTransactionID, PosCurrency, VanCountryCode) "
                                           //<< EGE-60949
                                           + "VALUES ("
                                           + "@PaymentId ,@TravelerOrder, @PosCode, @Comcode, @BookerPercode, @TravelerPercode, @TravelerName, @AdultCount, @AgentLogin, "
                                           + "@BookingDate, @FundedAmount, @Currency, @CardActivationDate, @CardExpirationDate, @IsMultiUseCard, "
                                           + "@TruncatedVAN, @Product, @Channel, @ECN, @MerchantCategory, @MdCode, @RefDossierType, @RefDossierCode, @OriginDate, @OriginAddress, "
                                           + "@OriginLocationCode, @OriginCountryCode, @EndDate, @EndAddress, @EndLocationCode, @EndCountryCode, @SupplierName, "
                                           + "@CC1, @CC2, @CC3, @RequestDate, @TripName, @FreeText1, @FreeText2, @FreeText3, @HotelId, "
                                           //>>EGE-60949
                                           //+ "@ErrorCode, @ErrorDesc, @CreationDate, @CreatedBy, @ModificationDate, @ModifiedBy, @SupportLogId, @VNettTransactionID)");
                                           + "@ErrorCode, @ErrorDesc, @CreationDate, @CreatedBy, @ModificationDate, @ModifiedBy, @SupportLogId, @VNettTransactionID, @PosCurrency, @VanCountryCode)");
            //<< EGE-60949
            // objet command
            SqlCommand command = new SqlCommand(request, GetConnection());

            try
            {
                // Send parameters
                command.Parameters.Add("@PaymentId", SqlDbType.VarChar, 16);
                command.Parameters["@PaymentId"].Value = Util.Nvl(response.GetReferenceId(), DBNull.Value);

                command.Parameters.Add("@SupportLogId", SqlDbType.VarChar, 256);
                command.Parameters["@SupportLogId"].Value = Util.Nvl(response.GetIssuedVNettResponse().SupportLogId, DBNull.Value);

                command.Parameters.Add("@VNettTransactionID", SqlDbType.VarChar, 100);
                command.Parameters["@VNettTransactionID"].Value = Util.Nvl(response.GetIssuedVNettResponse().VNettTransactionID, DBNull.Value);


                //<< EGE-60949
                command.Parameters.Add("@PosCode", SqlDbType.VarChar, 2);
                command.Parameters["@PosCode"].Value = Util.Nvl(reader.PosCountryCode, DBNull.Value);
                command.Parameters.Add("@PosCurrency", SqlDbType.VarChar, 3);
                command.Parameters["@PosCurrency"].Value = Util.Nvl(reader.PosCurrency, DBNull.Value);
                command.Parameters.Add("@VanCountryCode ", SqlDbType.VarChar, 2);
                command.Parameters["@VanCountryCode "].Value = Util.Nvl(reader.Market, DBNull.Value);
                //<< EGE-60949


                command.Parameters.Add("@TravelerOrder", SqlDbType.Int);
                command.Parameters["@TravelerOrder"].Value = travelerOrder;

                //<< EGE-60949
                //command.Parameters.Add("@PosCode", SqlDbType.VarChar, 2);
                //command.Parameters["@PosCode"].Value = Util.Nvl(reader.Market, DBNull.Value);
                //<< EGE-60949

                command.Parameters.Add("@Comcode", SqlDbType.Int);
                command.Parameters["@Comcode"].Value = Util.TryConvertStringToInt(reader.ComCode, DBNull.Value);

                command.Parameters.Add("@BookerPercode", SqlDbType.BigInt);
                command.Parameters["@BookerPercode"].Value = Util.TryConvertStringToLong(reader.BookerPerCode, DBNull.Value);

                command.Parameters.Add("@TravelerPercode", SqlDbType.BigInt);
                command.Parameters["@TravelerPercode"].Value = Util.TryConvertStringToLong(percode, DBNull.Value);

                command.Parameters.Add("@TravelerName", SqlDbType.VarChar, 512);
                command.Parameters["@TravelerName"].Value = Util.Nvl(travelerName, DBNull.Value);

                command.Parameters.Add("@AdultCount", SqlDbType.Int);
                command.Parameters["@AdultCount"].Value = Util.TryConvertStringToInt(reader.AdultsCount, DBNull.Value);

                command.Parameters.Add("@AgentLogin", SqlDbType.VarChar, 100);
                command.Parameters["@AgentLogin"].Value = Util.Nvl(reader.UserName, DBNull.Value);

                command.Parameters.Add("@BookingDate", SqlDbType.DateTime);
                command.Parameters["@BookingDate"].Value = Util.ConvertStringToDate(reader.BookingDate, Const.ExpirationDateFormat);

                command.Parameters.Add("@FundedAmount", SqlDbType.Money);
                command.Parameters["@FundedAmount"].Value = response.GetIssuedVNettResponse().IsSuccessful ?response.GetIssuedVNettResponse().FundedAmount:0;

                command.Parameters.Add("@Currency", SqlDbType.VarChar, 3);
                command.Parameters["@Currency"].Value = Util.Nvl(reader.Currency, DBNull.Value);

                command.Parameters.Add("@CardActivationDate", SqlDbType.DateTime);
                command.Parameters["@CardActivationDate"].Value = Util.ConvertStringToDate(reader.ActivationDate, Const.ExpirationDateFormat);

                command.Parameters.Add("@CardExpirationDate", SqlDbType.DateTime);
                command.Parameters["@CardExpirationDate"].Value = Util.ConvertStringToDate(reader.ExpiryDate, Const.ExpirationDateFormat);

                command.Parameters.Add("@IsMultiUseCard", SqlDbType.Bit);
                command.Parameters["@IsMultiUseCard"].Value = Util.ConvertStringToBool(reader.IsMultiUse) ? 1 : 0;

                command.Parameters.Add("@TruncatedVAN", SqlDbType.VarChar, 16);
                command.Parameters["@TruncatedVAN"].Value = response.GetIssuedVNettResponse().IsSuccessful ? CreditCardVerifier.TruncatePan(response.GetIssuedVNettResponse().VirtualAccountNumber) : string.Empty;

                command.Parameters.Add("@Product", SqlDbType.VarChar, 30);
                command.Parameters["@Product"].Value = Util.Nvl(reader.Product, DBNull.Value);

                command.Parameters.Add("@Channel", SqlDbType.VarChar, 10);
                command.Parameters["@Channel"].Value = Util.Nvl(channel, DBNull.Value);

                command.Parameters.Add("@ECN", SqlDbType.Int);
                command.Parameters["@ECN"].Value = Util.TryConvertStringToInt(reader.ECN, DBNull.Value);

                command.Parameters.Add("@MerchantCategory", SqlDbType.VarChar, 30);
                command.Parameters["@MerchantCategory"].Value = Util.Nvl(reader.MerchantCategory, DBNull.Value);

                command.Parameters.Add("@MdCode", SqlDbType.Int);
                command.Parameters["@MdCode"].Value = Util.TryConvertStringToInt(reader.MdCode, DBNull.Value);

                command.Parameters.Add("@RefDossierType", SqlDbType.VarChar, 10);
                command.Parameters["@RefDossierType"].Value = Util.Nvl(reader.RefDossierType, DBNull.Value);

                command.Parameters.Add("@RefDossierCode", SqlDbType.Int);
                command.Parameters["@RefDossierCode"].Value = Util.TryConvertStringToInt(reader.RefDossierCode, DBNull.Value);

                // Origin date is not available in verion 1 of the XML
                command.Parameters.Add("@OriginDate", SqlDbType.DateTime);
                if (String.IsNullOrEmpty(reader.OriginDate))
                {
                    command.Parameters["@OriginDate"].Value = DBNull.Value;
                }
                else
                {
                    command.Parameters["@OriginDate"].Value = Util.ConvertStringToDate(reader.OriginDate, Const.ExpirationDateFormat);
                }

                command.Parameters.Add("@OriginAddress", SqlDbType.VarChar, 2000);
                command.Parameters["@OriginAddress"].Value = Util.Nvl(reader.OriginLocationName, DBNull.Value);

                command.Parameters.Add("@OriginLocationCode", SqlDbType.VarChar, 30);
                command.Parameters["@OriginLocationCode"].Value = Util.Nvl(reader.OriginLocationCode, DBNull.Value);

                command.Parameters.Add("@OriginCountryCode", SqlDbType.VarChar, 3);
                command.Parameters["@OriginCountryCode"].Value = Util.Nvl(reader.OriginCountryCode, DBNull.Value);

                // Origin date is not available in verion 1 of the XML
                command.Parameters.Add("@EndDate", SqlDbType.DateTime);
                if (String.IsNullOrEmpty(reader.EndDate))
                {
                    command.Parameters["@EndDate"].Value = DBNull.Value;
                }
                else
                {
                    command.Parameters["@EndDate"].Value = Util.ConvertStringToDate(reader.EndDate, Const.ExpirationDateFormat);
                }

                command.Parameters.Add("@EndAddress", SqlDbType.VarChar, 2000);
                command.Parameters["@EndAddress"].Value = Util.Nvl(reader.EndLocationName, DBNull.Value);

                command.Parameters.Add("@EndLocationCode", SqlDbType.VarChar, 30);
                command.Parameters["@EndLocationCode"].Value = Util.Nvl(reader.EndLocationCode, DBNull.Value);

                command.Parameters.Add("@EndCountryCode", SqlDbType.VarChar, 3);
                command.Parameters["@EndCountryCode"].Value = Util.Nvl(reader.EndCountryCode, DBNull.Value);

                command.Parameters.Add("@SupplierName", SqlDbType.VarChar, 512);
                command.Parameters["@SupplierName"].Value = Util.Nvl(reader.SupplierName, DBNull.Value);

                command.Parameters.Add("@CC1", SqlDbType.VarChar, 100);
                command.Parameters["@CC1"].Value = Util.Nvl(cc1, DBNull.Value);

                command.Parameters.Add("@CC2", SqlDbType.VarChar, 100);
                command.Parameters["@CC2"].Value = Util.Nvl(cc2, DBNull.Value);

                command.Parameters.Add("@CC3", SqlDbType.VarChar, 100);
                command.Parameters["@CC3"].Value = Util.Nvl(cc3, DBNull.Value);

                command.Parameters.Add("@RequestDate", SqlDbType.DateTime);
                command.Parameters["@RequestDate"].Value = DateTime.Now;

                command.Parameters.Add("@TripName", SqlDbType.VarChar, 256);
                command.Parameters["@TripName"].Value = Util.Nvl(reader.TripName, DBNull.Value);

                command.Parameters.Add("@FreeText1", SqlDbType.VarChar, 1000);
                command.Parameters["@FreeText1"].Value = Util.Nvl(reader.FreeText1, DBNull.Value);
                command.Parameters.Add("@FreeText2", SqlDbType.VarChar, 1000);
                command.Parameters["@FreeText2"].Value = Util.Nvl(reader.FreeText2, DBNull.Value);
                command.Parameters.Add("@FreeText3", SqlDbType.VarChar, 1000);
                command.Parameters["@FreeText3"].Value = Util.Nvl(reader.FreeText3, DBNull.Value);

                command.Parameters.Add("@HotelId", SqlDbType.BigInt);
                command.Parameters["@HotelId"].Value = Util.TryConvertStringToLong(reader.HotelID, 0L);


                command.Parameters.Add("@ErrorCode", SqlDbType.VarChar, 50);
                command.Parameters["@ErrorCode"].Value = response.GetIssuedVNettResponse().IsSuccessful?0:response.GetIssuedVNettResponse().ErrorCode;
                command.Parameters.Add("@ErrorDesc", SqlDbType.VarChar, 256);
                command.Parameters["@ErrorDesc"].Value = response.GetIssuedVNettResponse().IsSuccessful ? string.Empty : response.GetIssuedVNettResponse().ErrorDescription;
                // Technical infos
                command.Parameters.Add("@CreationDate", SqlDbType.DateTime);
                command.Parameters["@CreationDate"].Value = DateTime.Now;
                command.Parameters.Add("@CreatedBy", SqlDbType.VarChar, 256);
                command.Parameters["@CreatedBy"].Value = Util.Nvl(reader.AgentLogIn, DBNull.Value);
                command.Parameters.Add("@ModificationDate", SqlDbType.DateTime);
                command.Parameters["@ModificationDate"].Value = DateTime.Now;
                command.Parameters.Add("@ModifiedBy", SqlDbType.VarChar, 256);
                command.Parameters["@ModifiedBy"].Value = Util.Nvl(reader.AgentLogIn, DBNull.Value);


                // Execute ...
                command.ExecuteNonQuery();
            }
            catch (Exception e)
            {
                // Something wen wrong
                throw new Exception(GetMessages().GetString("VCardLogConnection.Save.Error", response.GetReferenceId(), e.Message, true));
            }
            finally
            {
                DisposeCommand(command);
            }
        }