コード例 #1
0
        /// <summary>
        /// Saves the user address.
        /// </summary>
        /// <param name="address">The address.</param>
        /// <returns>Id of address</returns>
        public Optional <int> SaveUserAddress(EbayUserAddressData address)
        {
            using (var sqlConnection = GetOpenedSqlConnection2()) {
                Optional <SqlCommand> cmd = GetInsertCommand(address, sqlConnection.SqlConnection(), "MP_EbayUserAddressData", "Id", SkipColumns("Id"));
                if (!cmd.HasValue)
                {
                    return(Optional <int> .Empty());
                }

                using (var sqlCommand = cmd.GetValue()) {
                    return(ExecuteScalarAndLog <int>(sqlCommand));
                }
            }
        }
コード例 #2
0
        /// <summary>
        /// Saves the user data.
        /// </summary>
        /// <param name="ebayUserData">The ebay user data.</param>
        /// <param name="registrationAddress">The registration address.</param>
        /// <param name="sellerPaymentAddress">The seller payment address.</param>
        /// <returns></returns>
        public bool SaveUserData(EbayUserData ebayUserData, EbayUserAddressData registrationAddress, EbayUserAddressData sellerPaymentAddress)
        {
            if (registrationAddress != null)
            {
                Optional <int> registrationAddressId = SaveUserAddress(registrationAddress);
                if (!registrationAddressId.HasValue)
                {
                    return(false);
                }

                ebayUserData.RegistrationAddressId = registrationAddressId.GetValue();
            }

            if (sellerPaymentAddress != null)
            {
                Optional <int> sellerPaymentAddressId = SaveUserAddress(sellerPaymentAddress);
                if (!sellerPaymentAddressId.HasValue)
                {
                    return(false);
                }

                ebayUserData.SellerInfoSellerPaymentAddressId = sellerPaymentAddressId.GetValue();
            }

            using (var sqlConnection = GetOpenedSqlConnection2()) {
                Optional <SqlCommand> cmd = GetInsertCommand(ebayUserData, sqlConnection.SqlConnection(), "MP_EbayUserData", null, SkipColumns("Id"));
                if (!cmd.HasValue)
                {
                    return(false);
                }

                using (var sqlCommand = cmd.GetValue()) {
                    return(ExecuteNonQueryAndLog(sqlCommand));
                }
            }
        }