How To Update Payment In Quickbooks Online Using C#

In this article, we will learn how to update a payment in Quickbooks online from .NET MVC web application using SDK.

Before using any Quickbooks online API we need access token, if you don’t know how to get access token then you can find it here.

• First, we have to create a ServiceContext with Auth tokens and realmId.
• For that, we need access token and realmId
• We have to get the payment from Quickbooks online by calling payment API.
• We are querying a payment by ID.
• For querying/get the payment we have to define QueryService
• We need to pass the ServiceContext object into QueryService.
• We must need payment Id and SyncToken for an update.
• We will create a payment object and pass all data with updated data along with Id and SyncToken.
• After that, We have to create a DataService object by passing a ServiceContext object as a parameter.
• Add payment object in DataService.Update<Payment>() for updating an payment.
• It will return the newly updated payment object, you can store the required details to the database according to your needs.
• The code is as below.

public ActionResult UpdatePaymentById()
        {
            try
            {
                OAuth2RequestValidator oauthValidator = new OAuth2RequestValidator(Access_token);

                // Create a ServiceContext with Auth tokens and realmId
                ServiceContext serviceContext = new ServiceContext(RealmId, IntuitServicesType.QBO, oauthValidator);
                serviceContext.IppConfiguration.MinorVersion.Qbo = "23";
                serviceContext.IppConfiguration.BaseUrl.Qbo = QboBaseUrl;

                string EXISTING_PAYMENT_QUERYBYID = string.Format("select * from Payment where id = '{0}'", "167");
                var queryService = new QueryService<Payment>(serviceContext);
                Payment objPaymentFound = queryService.ExecuteIdsQuery(EXISTING_PAYMENT_QUERYBYID).FirstOrDefault<Payment>();

                //If Payment found on Quickbooks online
                if (objPaymentFound != null)
                {
                    objPaymentFound.TotalAmt = 200;

                    DataService dataService = new DataService(serviceContext);

                    Payment UpdateEntity = dataService.Update<Payment>(objPaymentFound);
                    if (UpdateEntity != null && !string.IsNullOrEmpty(UpdateEntity.Id))
                    {
                        //you can write Database code here
                        ViewBag.IsSuccess = true;
                    }
                }
                return View();
            }
            catch (IdsException ex)
            {
                ViewBag.IsSuccess = false;
                if (ex.InnerException != null && !string.IsNullOrEmpty(ex.InnerException.Message))
                {
                    ViewBag.Message = ex.InnerException.Message;
                }
                else if (!string.IsNullOrEmpty(ex.Message))
                {
                    ViewBag.Message = ex.Message;
                }
                else
                {
                    ViewBag.Message = "Something went wrong,IdsException occurs";
                }
                return View();
            }
            catch (Exception ex)
            {
                ViewBag.IsSuccess = false;
                if (ex.InnerException != null && !string.IsNullOrEmpty(ex.InnerException.Message))
                {
                    ViewBag.Message = ex.InnerException.Message;
                }
                else if (!string.IsNullOrEmpty(ex.Message))
                {
                    ViewBag.Message = ex.Message;
                }
                else
                {
                    ViewBag.Message = "Something went wrong,Exception occurs";
                }
                return View();
            }
        }

• View Code is as below,

@{
    ViewBag.Title = "UpdatePaymentById";
}

<h2>Update Payment By Id</h2>


@if (ViewBag.IsSuccess != null && ViewBag.IsSuccess == true)
{
    <div class="row">
        <label class="label label-success"> Payment Update Successfully </label>
    </div>
}
else if (ViewBag.IsSuccess != null && ViewBag.IsSuccess == false)
{
    <div class="row">
        <label class="label label-danger">@ViewBag.Message</label>
    </div>
}

• The above code will update the payment amount. here we are changing the amount of payment object that we got from Quickbooks online and assigning it to our newly created object for an update.