public JsonResult StockStatus(int hub, int program) { if (hub != 0) { var st = _stockStatusService.GetStockSummaryHubDahsBoard(hub, DateTime.Now); //st.Take() if (st.Count > 0) { var value = st.Find(t => t.HubID == hub); var free = (value.TotalPhysicalStock == 0) ? 0 : ((value.TotalFreestock / (value.TotalPhysicalStock + value.TotalFreestock)) * 100); var commited = ((value.TotalPhysicalStock) / ((value.TotalPhysicalStock == 0) ? 1.0M : value.TotalPhysicalStock + value.TotalFreestock)) * 100; var j = new StockStatusViewModel() { freeStockAmount = value.TotalFreestock, freestockPercent = free, physicalStockAmount = (value.TotalPhysicalStock - value.TotalFreestock), physicalStockPercent = commited, totalStock = value.TotalPhysicalStock }; return(Json(j, JsonRequestBehavior.AllowGet)); } } return(Json(new StockStatusViewModel(), JsonRequestBehavior.AllowGet)); }
public StockStatusViewModel StoneStatus(DataTable dt, int LoginID, decimal pageIndex, int pageSize, string RaisedEvent, string OrderBy, string OrderDirection) { try { dt.Columns[0].ColumnName = "Lotnumber"; StockStatusViewModel obj = new StockStatusViewModel(); if (context.Database.Connection.State != ConnectionState.Open) { context.Database.Connection.Open(); } var cmd = context.Database.Connection.CreateCommand(); cmd.CommandText = "proc_StoneStatus"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@tblLotNumbers", dt)); cmd.Parameters.Add(new SqlParameter("@LoginID", LoginID)); cmd.Parameters.Add(new SqlParameter("@pageIndex", pageIndex)); cmd.Parameters.Add(new SqlParameter("@pageSize", pageSize)); cmd.Parameters.Add(new SqlParameter("@RaisedEvent", RaisedEvent)); cmd.Parameters.Add(new SqlParameter("@OrderBy", OrderBy)); cmd.Parameters.Add(new SqlParameter("@OrderDirection", OrderDirection)); var reader = cmd.ExecuteReader(); obj.TotalCount = ((IObjectContextAdapter)context) .ObjectContext .Translate <int>(reader).FirstOrDefault(); reader.NextResult(); obj.inventories = ((IObjectContextAdapter)context) .ObjectContext .Translate <inventoryDetailsViewModel>(reader).ToList(); return(obj); } finally { context.Database.Connection.Close(); } }