In this article, we will learn how to update a bill 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 bill from Quickbooks online by calling bill API.
- We are querying a bill by ID.
- For querying/get the bill we have to define QueryService
- We need to pass the ServiceContext object into QueryService.
- We must need bill Id and SyncToken for an update.
- We will create a bill 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 bill object in DataService.Update<bill>() for updating an bill.
- It will return the newly updated bill object, you can store the required details to the database according to your needs.
- The code is as below.
public ActionResult UpdateBill() { 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_BILL_QUERYBYID = string.Format("select * from bill where id = '{0}'", "154"); var queryService = new QueryService<Bill>(serviceContext); Bill objBillFound = queryService.ExecuteIdsQuery(EXISTING_BILL_QUERYBYID).FirstOrDefault<Bill>(); //If Bill found on Quickbooks online if (objBillFound != null) { Bill ObjBill = new Bill(); ObjBill.Id = objBillFound.Id; ObjBill.SyncToken = objBillFound.SyncToken; ObjBill.VendorRef = new ReferenceType(); ObjBill.VendorRef = objBillFound.VendorRef; List<Line> LineList = new List<Line>(); for (int i = 0; i < objBillFound.Line.Count(); i++) { if (objBillFound.Line[i].DetailType == LineDetailTypeEnum.AccountBasedExpenseLineDetail) { objBillFound.Line[i].Amount = 150; objBillFound.Line[i].Description = "This Description is for BILL"; LineList.Add(objBillFound.Line[i]); } } ObjBill.Line = LineList.ToArray(); DataService dataService = new DataService(serviceContext); Bill UpdateEntity = dataService.Update<Bill>(ObjBill); 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 = "UpdateBill"; } <h2>Update Bill</h2> @if (ViewBag.IsSuccess != null && ViewBag.IsSuccess == true) { <div class="row"> <label class="label label-success"> Bill Updated 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 bill item’s amount and description, here we are changing the amount and description of bill object that we got from Quickbooks online and assigning it to our newly created object for an update.