public ActionResult UserEdit(int id)
{
User user = null;
var userViewData = new UserViewData();
try
{
using (var db = new TrackerDataContext())
{
var options = new DataLoadOptions();
options.LoadWith <Data.User>(u => u.UserRoleList);
options.LoadWith <Data.UserRole>(u => u.Role);
db.LoadOptions = options;
user = db.User.GetByKey(id);
UpdateModel(user);
if (!db.GetChangeSet().Updates.Contains(user))
{
var ruleManager = new RuleManager();
ruleManager.Run(user);
if (ruleManager.BrokenRules.Count > 0)
{
throw new BrokenRuleException(ruleManager.BrokenRules);
}
}
db.SubmitChanges();
var audit = new Audit(db.LastAudit);
audit.User = user;
db.Audit.InsertOnSubmit(audit);
db.SubmitChanges();
}
return(RedirectToAction("Edit", new { id = id }));
}
catch (BrokenRuleException e)
{
if (user != null)
{
user.Detach();
}
foreach (BrokenRule rule in e.BrokenRules)
{
ModelState.AddModelError(rule.Context.Rule.TargetProperty, rule.Message);
}
return(View(GetData(user)));
}
}
//[Ignore]
public void ManyToMany()
{
var db = new TrackerDataContext {
Log = Console.Out
};
var user = db.User.GetByKey(1);
user.RoleList.Add(db.Role.GetByKey(1));
user.RoleList.Add(db.Role.GetByKey(2));
db.SubmitChanges();
var userRole = user.UserRoleList.FirstOrDefault(u => u.RoleId == 1);
db.UserRole.DeleteOnSubmit(userRole);
user.RoleList.Remove(db.Role.GetByKey(1));
user.RoleList.Remove(db.Role.GetByKey(2));
var changes = db.GetChangeSet();
db.SubmitChanges();
}