public IActionResult AddStock(StockDetailsVm stockdetailsvm)
{
var stck = _context.StockDetails.AsNoTracking().Where(s => s.IngredientId == stockdetailsvm.IngredientId).LastOrDefault();
if (stck != null)
{
stockdetailsvm.AvailableStock = stockdetailsvm.Quantity * 1000 + stck.AvailableStock;
}
else
{
stockdetailsvm.AvailableStock = stockdetailsvm.Quantity * 1000;
}
var ingredientlist = _context.Ingredient.ToList();
ingredientlist.Insert(0, new Ingredient {
IngredientId = 0, IngredientName = "Select Raw Ingredient"
});
ViewBag.IngredientList = ingredientlist;
StockDetails stockdetails = new StockDetails()
{
IngredientId = stockdetailsvm.IngredientId,
Quantity = stockdetailsvm.Quantity,
StockInDate = DateTime.Now,
AvailableStock = stockdetailsvm.AvailableStock,
};
_context.StockDetails.Add(stockdetails);
_context.SaveChanges();
ModelState.Clear();
ViewBag.Success = "You have succesfully added.";
return(View());
}
public IActionResult UpdateStock(StockDetailsVm stockdetailsvm)
{
StockDetails stockdetails = new StockDetails()
{
StockDetailsId = stockdetailsvm.StockDetailsId,
IngredientId = stockdetailsvm.IngredientId,
Quantity = stockdetailsvm.Quantity,
StockInDate = DateTime.Now,
AvailableStock = stockdetailsvm.Quantity * 1000,
};
_context.StockDetails.Update(stockdetails);
_context.SaveChanges();
return(RedirectToAction("StockDetails"));
}
public IActionResult UpdateStock(int id)
{
var item = _context.StockDetails.
AsNoTracking().Where(a => a.StockDetailsId == id).FirstOrDefault();
ViewBag.IngredientList = new SelectList(_context.Ingredient.ToList(), "IngredientId", "IngredientName");
StockDetailsVm data = new StockDetailsVm()
{
StockDetailsId = item.StockDetailsId,
Quantity = item.Quantity,
IngredientId = item.IngredientId,
StockInDate = item.StockInDate
};
return(View(data));
}
public async Task <IActionResult> StockStatus()
{
var stc = await _context.StockDetails.
AsNoTracking().Include(a => a.Ingredient).
ToListAsync();
var data = stc.GroupBy(x => x.IngredientId).
Select(x => x.OrderByDescending(x => x.StockDetailsId).First());
var sent = new List <StockDetailsVm>();
foreach (var item in data)
{
StockDetailsVm p = new StockDetailsVm()
{
StockInDate = item.StockInDate,
Quantity = item.Quantity,
AvailableStock = item.AvailableStock,
IngredientName = item.Ingredient.IngredientName,
};
sent.Add(p);
}
return(View(sent));
}
public IActionResult StockDetails(int Page = 1)
{
var list = _context.StockDetails.AsNoTracking().Include(a => a.Ingredient).ToList();
var sent = new List <StockDetailsVm>();
int c = 1;
foreach (var item in list)
{
StockDetailsVm a = new StockDetailsVm()
{
StockDetailsId = item.StockDetailsId,
Serial = c,
Quantity = item.Quantity,
AvailableStock = item.AvailableStock / 1000,
IngredientName = item.Ingredient.IngredientName,
StockInDate = item.StockInDate
};
sent.Add(a);
c++;
}
var list1 = sent.ToPagedList(Page, 5);
return(View(list1));
}
