public ActionResult ChangeHerd(ChangeHerdViewModel changeHerd) { if (ModelState.IsValid) { var popup = new MessageInfo { State = 1, Message = "troupeau bien changé" }; foreach (var idCattle in changeHerd.IdChangeCattle) { var herdDecrement = _dairyFarmService.GetCattleById(idCattle); _dairyFarmService.DecrementHerd(changeHerd.IdChangeHerd); _dairyFarmService.IncrementHerd(herdDecrement.IdHerd); ////var cattleToEdit = _dairyFarmService.GetCattleById(idCattle); // herdDecrement.IdHerd = changeHerd.IdChangeHerd; //_db.Detach(order); int noOfRowUpdated = _db.Database.ExecuteSqlCommand("Update Cattles set IdHerd =" + changeHerd.IdChangeHerd + " where IdCattle=" + idCattle + ""); if (noOfRowUpdated != 1) { popup.State *= 0; } //_db.Entry(cattleToEdit).State = EntityState.Modified; //_db.SaveChanges(); } return(RedirectToAction("Index", new { message = popup.Message, state = popup.State })); } return(RedirectToAction("Index", new { message = "Erreur dans le changement du troupeau !", state = 0 })); }