public int GetStockValueQuantity(int?id) { try { int CompanyId = 1003; MVCQutationViewModel _QutationList = new MVCQutationViewModel(); MVCPurchaseDetailsModel PurchaseModel = new MVCPurchaseDetailsModel(); //api in api/Qutation HttpResponseMessage response = GlobalVeriables.WebApiClient.GetAsync("GetSaleItemQty/" + id + "/" + CompanyId).Result; _QutationList = response.Content.ReadAsAsync <MVCQutationViewModel>().Result; //api in api/purchase HttpResponseMessage _response = GlobalVeriables.WebApiClient.GetAsync("GetPurchaseItemQTY/" + id + "/" + CompanyId).Result; PurchaseModel = _response.Content.ReadAsAsync <MVCPurchaseDetailsModel>().Result; int result = Convert.ToInt32(PurchaseModel.PurchaseQuantity) - Convert.ToInt32(_QutationList.Quantity); return(result); } catch (Exception ex) { return(0); } }
public IHttpActionResult GetSaleQuantity(int id, int companyid) { MVCPurchaseDetailsModel _MvcPurchaseDetailsModel = new MVCPurchaseDetailsModel(); try { var q = (from p in db.PurchaseOrderTables join pd in db.PurchaseOrderDetailsTables on p.PurchaseOrderID equals pd.PurchaseId where p.Status == "accepted" && pd.PurchaseItemId == id && p.CompanyId == companyid select pd).Sum(i => i.PurchaseQuantity); _MvcPurchaseDetailsModel.PurchaseQuantity = q; return(Ok(_MvcPurchaseDetailsModel)); } catch (Exception ex) { return(NotFound()); } }