User1643232994 posted
One example:
[HttpPost]
[ValidateAntiForgeryToken]
public ActionResult SetHandled(int? id, string orderNo)
{
if (id == null || orderNo == null)
{
return NotFound();
}
var orderArticle = _context.OrderArticle.Where(s => s.Id == id).SingleOrDefault();
orderArticle.State = "OK";
_context.OrderArticle.Update(orderArticle);
_context.SaveChanges();
bool exceptionExist = _context.OrderArticle.Any(x => x.State == "Exception");
//THIS ALWAYS RETURN FALSE
if (!exceptionExist)
{
var order = _context.Order.Where(s => s.OrderNo == orderNo).SingleOrDefault();
order.State = "OK";
order.HandledDate = Convert.ToDateTime(DateTime.Now);
_context.Order.Update(order);
_context.SaveChanges();
}
_context.SaveChanges();
return RedirectToAction("Index");
}
I need to check the datatable 'order', attribute 'state', if there's any value with 'Exception', if there's not and all of them have value 'ok', then I want to put the state in another datatable 'ok'. But this is never happen because "bool
exceptionExist = _context.OrderArticle.Any(x => x.State == "Exception");" always return false.
