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