/// <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)); } } }
/// <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)); } } }