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