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