ASP.Net MVC和state -如何在双列表框中从Session更改更新数据库

我正在研究一个双列表框系统，操作员可以为特定用户分配和删除不同的练习。对于RemoveExercises函数，我已经开始使用会话，以便RequestedExercises列表框更新所做的更改(添加和删除练习)。

目前，AddExercises函数将练习从AvailableExercises列表框添加到数据库上的RequestedExercises列表框(也称为RegimeItems)，但它不会出现在RequestedExercises列表框上，直到我回到页面。

RemoveExercises函数从RequestedExercises列表框中删除了一个选定的练习，但没有对数据库进行更改。所以这两个函数只完成了我想要它们做的一半，只是方式不同。

这让我相信，由于会话状态，RequestedExercises列表框上没有显示添加的练习，而RemoveExercises没有更新其对数据库的更改。如有任何帮助，我将不胜感激。

UPDATE:在post request中将return View(model);更改为return RedirectToAction("ExerciseIndex", new { id = model2.UserID, vmodel = model2 });后，添加练习效果完美。我该如何使RemoveExercises在域对象用户上工作?

Controller.cs

    [HttpGet]
    public ActionResult ExerciseIndex(int id, UserExerciseViewModel vmodel)
    {
        User user = db.Users.Find(id);
        UserExerciseViewModel model = new UserExerciseViewModel { AvailableExercises = GetAllExercises(), RequestedExercises = ChosenExercises(user, vmodel) };
        model.UserID = user.UserID;
        Session["UserExerciseViewModel"] = model;
        return View(model);
    }
    [HttpPost]
    public ActionResult ExerciseIndex(UserExerciseViewModel model, string add, string remove, string send, int id, RegimeItem item)
    {
        UserExerciseViewModel model2 = (UserExerciseViewModel)(Session["UserExerciseViewModel"]);
        model.RequestedExercises = model2.RequestedExercises;
        model.AvailableExercises = model2.AvailableExercises;
        if (!string.IsNullOrEmpty(add))
            AddExercises(model, id);
        else if (!string.IsNullOrEmpty(remove))
            RemoveExercises(model, id);
        User user = db.Users.Find(model2.UserID);
        model2.RequestedExercises = ChosenExercises(user, model);
        user.RegimeItems = model.RequestedExercises;
        RestoreSavedState(model, user);
        return RedirectToAction("ExerciseIndex", new { id = model2.UserID, vmodel = model2 });
    )
    void RemoveExercises(UserExerciseViewModel model, int id)
    {
        var userExerciseViewModel = (UserExerciseViewModel)(Session["UserExerciseViewModel"]);
        foreach (int selected in model.RequestedSelected)
        {
            RegimeItem item = model.RequestedExercises.FirstOrDefault(i => i.RegimeItemID == selected);
            if (item != null)
            {
                model.RequestedExercises.Remove(item);
            }
        }
        db.SaveChanges();
    }
    void AddExercises(UserExerciseViewModel model, int id)
    {
        var userExerciseViewModel = (UserExerciseViewModel)(Session["UserExerciseViewModel"]);
        foreach (int selected in model.AvailableSelected)
        {
            if (model.AvailableSelected != null)
            {
                User user = db.Users.Find(id);
                user.RegimeItems.Add(new RegimeItem()
                {
                    RegimeExercise = (this.GetAllExercises().FirstOrDefault(i => i.ExerciseID == selected))
                });
            }
        }
        db.SaveChanges();
    }
    void RestoreSavedState(UserExerciseViewModel model, User user)
    {
        user.RegimeItems = this.ChosenExercises(user, model);
        if (!string.IsNullOrEmpty(model.SavedRequested))
        {
            string[] exIds = model.SavedRequested.Split(',');
            var regimeItems = ChosenExercises(user, model).Where(p => exIds.Contains(p.RegimeItemID.ToString()));
            model.RequestedExercises.AddRange(regimeItems);
        }
        db.SaveChanges();
    }
    private List<Exercise> GetAllExercises() //Gets all the data for AvailableExercises
    {
        return db.Exercises.ToList();
    }
    private List<RegimeItem> ChosenExercises(User user, UserExerciseViewModel model) //Gets all the data for RequestedExercies
    {
     return db.Users
     .Where(u => u.UserID == user.UserID)
     .SelectMany(u => u.RegimeItems)
     .ToList();
    }

模型(cs)

 public class User
    {
        public int UserID { get; set; }
        public ICollection<RegimeItem> RegimeItems { get; set; }
        public User()
        {
            this.RegimeItems = new List<RegimeItem>();
        } 
    }
    public class RegimeItem
    {
        public int RegimeItemID { get; set; }
        public Exercise RegimeExercise { get; set; }
    }

视图模型(cs)

public class UserExerciseViewModel
{
    public List<Exercise> AvailableExercises { get; set; }
    public List<RegimeItem> RequestedExercises { get; set; }
    public int? SelectedExercise { get; set; }
    public int[] AvailableSelected { get; set; }
    public int[] RequestedSelected { get; set; }
    public string SavedRequested { get; set; }
    public int UserID { get; set; }
}

视图(段只有(cshtml))

<td valign="top">
   @Html.ListBoxFor(model => model.AvailableSelected, new MultiSelectList(Model.AvailableExercises, "ExerciseID", "Name", Model.AvailableSelected))
</td>
<td valign="top">
  <input type="submit" name="add"
  id="add" value=">>" /><br />
  <input type="submit" name="remove"
  id="remove" value="<<" />
</td>
<td valign="top">
    @Html.ListBoxFor(model => model.RequestedSelected, new MultiSelectList(Model.RequestedExercises, "RegimeItemID", "RegimeExercise.Name", Model.RequestedSelected))
</td>

更新:将RemoveExercises更改为此修复了删除问题:

void RemoveExercises(UserExerciseViewModel model, int id)
{
    var userExerciseViewModel = (UserExerciseViewModel)(Session["UserExerciseViewModel"]);
    foreach (int selected in model.RequestedSelected)
    {
        if (model.RequestedSelected != null)
        {
            User user = db.Users.Find(id);
            RegimeItem item = db.RegimeItems.Find(selected);
            item.RegimeExercise = this.GetAllExercises().FirstOrDefault(i => i.ExerciseID == selected); //--this removes the regimeexercise
            user.RegimeItems.Remove(item); //deletes the user's regimeitem
            db.RegimeItems.Remove(item); //removes the regimeitem itself 
        }
    }
    db.SaveChanges();

void AddExercises(UserExerciseViewModel model, int id)
    {
        var userExerciseViewModel = (UserExerciseViewModel)(Session["UserExerciseViewModel"]);
        foreach (int selected in model.AvailableSelected)
        {
            if (model.AvailableSelected != null)
            {
                User user = db.Users.Find(id);
                user.RegimeItems.Add(new RegimeItem()
                {
                    RegimeExercise = (this.GetAllExercises().FirstOrDefault(i => i.ExerciseID == selected))
                });
            }
        }
        db.SaveChanges(); // db is updated but your model isn't
    }

 void RemoveExercises(UserExerciseViewModel model, int id)
    {
        var userExerciseViewModel = (UserExerciseViewModel)(Session["UserExerciseViewModel"]);
        foreach (int selected in model.RequestedSelected)
        {
            RegimeItem item = model.RequestedExercises.FirstOrDefault(i => i.RegimeItemID == selected);
            if (item != null)
            {
                model.RequestedExercises.Remove(item);
            }
        }
        db.SaveChanges(); // What is the point of this? You didn't alter the user?
    }

return View(model)

   return RedirectToAction("ExerciseIndex", new { id = model2.ID, vmodel= model2 });

if (ModelState.IsValid){ ...}