In this article, we will learn how to update an item 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.
public ActionResult UpdateItem() { List<Item> ItemList = new List<Item>(); 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; // Create a QuickBooks QueryService using ServiceContext QueryService<Item> querySvc = new QueryService<Item>(serviceContext); string EXISTING_ITEM_QUERYBYNAME = string.Format("select * from Item where Name = '{0}' and Type = '{1}'", "Vision Keyboard", "Inventory"); Item objItemFound = querySvc.ExecuteIdsQuery(EXISTING_ITEM_QUERYBYNAME).FirstOrDefault<Item>(); if (objItemFound != null) { Item ObjItem = new Item(); ObjItem.Id = objItemFound.Id; ObjItem.SyncToken = objItemFound.SyncToken; ObjItem.Name = "Vision Keyboard Mouse Set"; ObjItem.TypeSpecified = objItemFound.TypeSpecified; ObjItem.Type = objItemFound.Type; ObjItem.TrackQtyOnHand = objItemFound.TrackQtyOnHand; ObjItem.TrackQtyOnHandSpecified = objItemFound.TrackQtyOnHandSpecified; ObjItem.QtyOnHandSpecified = objItemFound.QtyOnHandSpecified; ObjItem.QtyOnHand = objItemFound.QtyOnHand; ObjItem.InvStartDateSpecified = objItemFound.InvStartDateSpecified; ObjItem.InvStartDate = objItemFound.InvStartDate; ObjItem.Description = "This Keyboard Mouse Set is made by vision infotech"; ObjItem.UnitPriceSpecified = objItemFound.UnitPriceSpecified; ObjItem.UnitPrice = objItemFound.UnitPrice; ObjItem.PurchaseDesc = "This Keyboard Mouse Set is purchase from Vision infotech"; ObjItem.PurchaseCostSpecified = objItemFound.PurchaseCostSpecified; ObjItem.PurchaseCost = objItemFound.PurchaseCost; ObjItem.AssetAccountRef = objItemFound.AssetAccountRef; ObjItem.IncomeAccountRef = objItemFound.IncomeAccountRef; ObjItem.ExpenseAccountRef = objItemFound.ExpenseAccountRef; DataService dataService = new DataService(serviceContext); Item UpdateEntity = dataService.Update<Item>(ObjItem); if (UpdateEntity != null && !string.IsNullOrEmpty(UpdateEntity.Id)) { //you can write Database code here ViewBag.IsSuccess = true; } } return View(); } catch (IdsException ex) { return View(); } catch (Exception ex) { return View(); } }
In this article, we have to show Create and Used PIPE in angular
In this article, we have to show Create and Used PIPE in angular
In this article, we have to show Create and Used PIPE in angular