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 GetProductQuantityPurchase(int ProductId) { MVCQutationViewModel _MvcQuatation = new MVCQutationViewModel(); int PurchaseQuantity = 0; 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 == ProductId select pd).Sum(i => i.PurchaseQuantity); // PurchaseQuantity = Convert.ToInt32(db.PurchaseOrderDetailsTables.Where(t => t.PurchaseItemId == ProductId).Sum(i => i.PurchaseQuantity)); _MvcQuatation.QuantityRemaing = q; return(Ok(_MvcQuatation)); } catch (Exception ex) { return(BadRequest()); } }
public JsonResult UpdateOrderStaus(int QutationId, string Status, string Type) { List <MVCQutationViewModel> _QuatationModel = new List <MVCQutationViewModel>(); QutationOrderStatusTable orderstatusModel = new QutationOrderStatusTable(); List <MVCQutationViewModel> _QutationList = new List <MVCQutationViewModel>(); MVCQutationViewModel _mvcQuatationViewModel23 = new MVCQutationViewModel(); try { HttpResponseMessage res = GlobalVeriables.WebApiClient.GetAsync("APIQutation/" + QutationId.ToString()).Result; MVCQutationModel qutationModel = res.Content.ReadAsAsync <MVCQutationModel>().Result; qutationModel.Status = Status; if (qutationModel == null) { return(new JsonResult { Data = new { Status = "Fail", Message = "No record Found" } }); } HttpResponseMessage response = GlobalVeriables.WebApiClient.PutAsJsonAsync("APIQutation/" + QutationId, qutationModel).Result; if (response.StatusCode == System.Net.HttpStatusCode.OK) { GlobalVeriables.WebApiClient.DefaultRequestHeaders.Clear(); if (qutationModel != null) { orderstatusModel.Fk_QutationID = qutationModel.QutationID; orderstatusModel.Status = Status; orderstatusModel.CreateDate = DateTime.Now; orderstatusModel.CompanyId = Convert.ToInt32(Session["CompayID"]); orderstatusModel.UserId = 1; orderstatusModel.Type = "Qutation"; HttpResponseMessage response2 = GlobalVeriables.WebApiClient.PostAsJsonAsync("postOrderStatus", orderstatusModel).Result; if (response2.StatusCode == System.Net.HttpStatusCode.OK) { return(new JsonResult { Data = new { Status = "Success", Message = "Status is change successfully" } }); } else { return(new JsonResult { Data = new { Status = "Fail", Message = "Fail to change status" } }); } } } } catch (Exception ex) { return(new JsonResult { Data = new { Status = "Fail", ex.Message } }); } return(Json("", JsonRequestBehavior.AllowGet)); }
public IHttpActionResult GetCheckQuantity(int ProductId) { MVCQutationViewModel _MvcQuatation = new MVCQutationViewModel(); int PurchaseQuantity = 0; int qutationquantity = 0; try { PurchaseQuantity = Convert.ToInt32(db.PurchaseOrderDetailsTables.Where(t => t.PurchaseItemId == ProductId).Sum(i => i.PurchaseQuantity)); qutationquantity = Convert.ToInt32(db.QutationDetailsTables.Where(t => t.ItemId == ProductId).Sum(i => i.Quantity)); _MvcQuatation.QuantityRemaing = PurchaseQuantity - qutationquantity; return(Ok(_MvcQuatation)); } catch (Exception ex) { return(BadRequest()); } }
public IHttpActionResult GetSaleQuantity(int id, int companyid) { MVCQutationViewModel _MvcQutationViewModel = new MVCQutationViewModel(); try { var q = (from p in db.QutationTables join pd in db.QutationDetailsTables on p.QutationID equals pd.QutationID where p.Status == "accepted" && pd.QutationID == id && p.CompanyId == companyid select pd).Sum(i => i.Quantity); _MvcQutationViewModel.QuantityRemaing = q; return(Ok(_MvcQutationViewModel)); } catch (Exception ex) { return(NotFound()); } }