public double GetStateAmount(ExitViewModel model) { int thisYear = DateTime.Today.Year; var entriesSum = _context.Entries .Where(n => n.ProductId == model.productId & n.WareHouseId == model.warehouseId & n.DateEntry.Year == thisYear & n.IsActive) .Select(n => n.Amount) .Sum(); var exitsSum = _context.Exits .Where(n => n.ProductId == model.productId & n.WareHouseId == model.warehouseId & n.DateExit.Year == thisYear & n.IsActive) .Select(n => n.Amount) .Sum(); var state = entriesSum - exitsSum; return(state); }
public ActionResult ConfirmAmount(ExitViewModel model) => Ok(GetStateAmount(model) - model.amount);
public ActionResult ConfirmExit(ExitViewModel model) => Ok(GetStateAmount(model));