c# - 我想在注册时使用 EF 模型添加具有多对多关系的多个角色
问题描述
我有带有角色的用户注册表,我想通过多对多 Ef 模型生成的模型注册具有多个角色的新用户。我在注册用户时遇到问题,新角色被插入到角色表中,而这些新添加的角色被插入到 user_has_roles (Junction) 表中。
我正在分享一些我编写的自动生成模型类 user.cs 的代码
public partial class user
{
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
public user()
{
this.user_role = new HashSet<user_role>();
}
[Key]
[DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]
public int user_id { get; set; }
public string user_email { get; set; }
public string user_full_name { get; set; }
public string user_password { get; set; }
public string user_phone { get; set; }
public string user_mobile { get; set; }
public Nullable<int> country_id { get; set; }
public Nullable<int> city_id { get; set; }
public virtual city city { get; set; }
public virtual country country { get; set; }
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
public virtual ICollection<user_role> user_role { get; set; }
}
用户角色.cs
public partial class user_role
{
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
public user_role()
{
this.users = new HashSet<user>();
}
[Key]
[DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]
public int user_role_id { get; set; }
public string user_role_name { get; set; }
public Nullable<int> user_role_status { get; set; }
public string user_role_description { get; set; }
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
public virtual ICollection<user> users { get; set; }
这是我的数据库上下文类(自动生成的 AccountDb.cs
public partial class SaholatEntities : DbContext
{
public SaholatEntities()
: base("name=SaholatEntities")
{
}
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
throw new UnintentionalCodeFirstException();
}
public virtual DbSet<city> cities { get; set; }
public virtual DbSet<country> countries { get; set; }
public virtual DbSet<sysdiagram> sysdiagrams { get; set; }
public virtual DbSet<user> users { get; set; }
public virtual DbSet<user_role> user_role { get; set; }
public virtual int sp_alterdiagram(string diagramname, Nullable<int> owner_id, Nullable<int> version, byte[] definition)
{
var diagramnameParameter = diagramname != null ?
new ObjectParameter("diagramname", diagramname) :
new ObjectParameter("diagramname", typeof(string));
var owner_idParameter = owner_id.HasValue ?
new ObjectParameter("owner_id", owner_id) :
new ObjectParameter("owner_id", typeof(int));
var versionParameter = version.HasValue ?
new ObjectParameter("version", version) :
new ObjectParameter("version", typeof(int));
var definitionParameter = definition != null ?
new ObjectParameter("definition", definition) :
new ObjectParameter("definition", typeof(byte[]));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("sp_alterdiagram", diagramnameParameter, owner_idParameter, versionParameter, definitionParameter);
}
public virtual int sp_creatediagram(string diagramname, Nullable<int> owner_id, Nullable<int> version, byte[] definition)
{
var diagramnameParameter = diagramname != null ?
new ObjectParameter("diagramname", diagramname) :
new ObjectParameter("diagramname", typeof(string));
var owner_idParameter = owner_id.HasValue ?
new ObjectParameter("owner_id", owner_id) :
new ObjectParameter("owner_id", typeof(int));
var versionParameter = version.HasValue ?
new ObjectParameter("version", version) :
new ObjectParameter("version", typeof(int));
var definitionParameter = definition != null ?
new ObjectParameter("definition", definition) :
new ObjectParameter("definition", typeof(byte[]));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("sp_creatediagram", diagramnameParameter, owner_idParameter, versionParameter, definitionParameter);
}
public virtual int sp_dropdiagram(string diagramname, Nullable<int> owner_id)
{
var diagramnameParameter = diagramname != null ?
new ObjectParameter("diagramname", diagramname) :
new ObjectParameter("diagramname", typeof(string));
var owner_idParameter = owner_id.HasValue ?
new ObjectParameter("owner_id", owner_id) :
new ObjectParameter("owner_id", typeof(int));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("sp_dropdiagram", diagramnameParameter, owner_idParameter);
}
public virtual ObjectResult<sp_helpdiagramdefinition_Result> sp_helpdiagramdefinition(string diagramname, Nullable<int> owner_id)
{
var diagramnameParameter = diagramname != null ?
new ObjectParameter("diagramname", diagramname) :
new ObjectParameter("diagramname", typeof(string));
var owner_idParameter = owner_id.HasValue ?
new ObjectParameter("owner_id", owner_id) :
new ObjectParameter("owner_id", typeof(int));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_helpdiagramdefinition_Result>("sp_helpdiagramdefinition", diagramnameParameter, owner_idParameter);
}
public virtual ObjectResult<sp_helpdiagrams_Result> sp_helpdiagrams(string diagramname, Nullable<int> owner_id)
{
var diagramnameParameter = diagramname != null ?
new ObjectParameter("diagramname", diagramname) :
new ObjectParameter("diagramname", typeof(string));
var owner_idParameter = owner_id.HasValue ?
new ObjectParameter("owner_id", owner_id) :
new ObjectParameter("owner_id", typeof(int));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_helpdiagrams_Result>("sp_helpdiagrams", diagramnameParameter, owner_idParameter);
}
public virtual int sp_renamediagram(string diagramname, Nullable<int> owner_id, string new_diagramname)
{
var diagramnameParameter = diagramname != null ?
new ObjectParameter("diagramname", diagramname) :
new ObjectParameter("diagramname", typeof(string));
var owner_idParameter = owner_id.HasValue ?
new ObjectParameter("owner_id", owner_id) :
new ObjectParameter("owner_id", typeof(int));
var new_diagramnameParameter = new_diagramname != null ?
new ObjectParameter("new_diagramname", new_diagramname) :
new ObjectParameter("new_diagramname", typeof(string));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("sp_renamediagram", diagramnameParameter, owner_idParameter, new_diagramnameParameter);
}
public virtual int sp_upgraddiagrams()
{
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("sp_upgraddiagrams");
}
}
这是我注册用户的控制器方法(POST)
//post register
[HttpPost]
[ValidateAntiForgeryToken]
public ActionResult Register(AccountVM obj)
{
if(ModelState.IsValid)
{
// insert Data into user variable array from obj viewmodel
var user = new user()
{
user_email = obj.user_email,
user_full_name = obj.user_full_name,
user_password = obj.user_password,
user_phone = obj.user_phone,
user_mobile = obj.user_mobile,
country_id = obj.country_id,
city_id = obj.city_id
};
var user_roles = new user_role();
AccountDb.users.Add(user);
// insert Data into user_has_role variable array from obj viewmodel
foreach(var item in obj.selectedRoleList)
{
user_roles.user_role_id = Convert.ToInt32(item);
user_roles.users.Add(new user() { user_id = obj.user_id });
user.user_role.Add(new user_role() { user_role_id = Convert.ToInt32(item) });
}
if (AccountDb.SaveChanges() > 0)
{
TempData["errorMsg"] = "save";
return RedirectToAction("Index");
}
else
{
TempData["errorMsg"] = "queryError";
ViewBag.country_id = new SelectList(AccountDb.countries, "country_id", "country_name");
AccountVM objRole = new AccountVM();
objRole.getRoleList = AccountDb.user_role.ToList();
return View(objRole);
}
}
else
{
TempData["errorMsg"] = "modelError";
ViewBag.country_id = new SelectList(AccountDb.countries, "country_id", "country_name");
AccountVM objRole = new AccountVM();
objRole.getRoleList = AccountDb.user_role.ToList();
return View(objRole);
}
}
我想注册具有多个角色的用户,并且角色已经在角色表中定义,通过多选选择,当我注册具有 1 个角色的用户时,请帮助我,新角色添加到角色表中,而不是新添加的角色分配给用户(只有角色 ID 添加到角色表),如果我分配 2 个角色而不是 2 个将添加到角色表
解决方案
通过这样做解决这个问题
//post register
[HttpPost]
[ValidateAntiForgeryToken]
public ActionResult Register(AccountVM obj)
{
if(ModelState.IsValid)
{
// insert Data into user variable array from obj viewmodel
var user = new user()
{
user_email = obj.user_email,
user_full_name = obj.user_full_name,
user_password = obj.user_password,
user_phone = obj.user_phone,
user_mobile = obj.user_mobile,
country_id = obj.country_id,
city_id = obj.city_id
};
AccountDb.users.Add(user);
// insert Data into user_has_role variable array from obj viewmodel
foreach(var item in obj.selectedRoleList)
{
int id = Convert.ToInt32(item);
user_role _user_role = AccountDb.user_role.FirstOrDefault(r => r.user_role_id == id);
_user_role.users.Add(user);
user.user_role.Add(_user_role);
}
if (AccountDb.SaveChanges() > 0)
{
TempData["errorMsg"] = "save";
return RedirectToAction("Index");
}
else
{
TempData["errorMsg"] = "queryError";
ViewBag.country_id = new SelectList(AccountDb.countries, "country_id", "country_name");
AccountVM objRole = new AccountVM();
objRole.getRoleList = AccountDb.user_role.ToList();
return View(objRole);
}
}
else
{
TempData["errorMsg"] = "modelError";
ViewBag.country_id = new SelectList(AccountDb.countries, "country_id", "country_name");
AccountVM objRole = new AccountVM();
objRole.getRoleList = AccountDb.user_role.ToList();
return View(objRole);
}
}
推荐阅读
- c++ - 如何使用 stb_image 将像素颜色数据写入 bmp 图像文件?
- swift - 在后台访问 healthkit 锻炼
- mysql - 如何替换 MySQL 中关于 join 的多对多参考?
- php - 如何在特定刀片模板中添加/删除类
- java - 如何为导航抽屉活动使用自己的布局而不是自动生成的布局?
- llvm - ExecutionEngine 类与 MCJit 和 ORC 有什么关系?
- command-line - 命令行查找路径是否匹配并删除所有内容
- reactjs - 无法从“node_modules\react-redux\lib\index.js”解析“./utils/batch”
- python-3.x - 使用来自 TextInput 的名称保存 file.txt
- r - 如何重塑数据框并将重复列转置为数据框行?