private void NewRoleEventHandler(object sender, NewRoleEventArgs e)
{
User_RoleModel roleModel = new User_RoleModel();
roleModel.RoleName = e.RoleName;
roleModel.Remarks = e.Remark;
int roleID = bllRole.Add(roleModel);
if (roleID != 1)
{
for (int i = 0; i < e.FuncIDList.Count; i++)
{
User_LimitModel limitModel = new User_LimitModel();
limitModel.FunctionID = e.FuncIDList[i];
limitModel.RoleID = roleID;
bllUserLimit.Add(limitModel);
}
List <User_RoleModel> roleList = bllRole.GetModelList("");
this.View.RefreshRoleListData(roleList);
if (mainPre != null)
{
mainPre.View.AddLog(ECAMSModel.EnumLogCategory.管理层日志, ECAMSModel.EnumLogType.提示, "新建用户角色成功！");
}
}
else
{
if (mainPre != null)
{
mainPre.View.AddLog(ECAMSModel.EnumLogCategory.管理层日志, ECAMSModel.EnumLogType.提示, "新建用户角色成功！");
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(User_RoleModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update User_Role set ");
strSql.Append("RoleName=@RoleName,");
strSql.Append("Remarks=@Remarks");
strSql.Append(" where RoleID=@RoleID");
SqlParameter[] parameters =
{
new SqlParameter("@RoleName", SqlDbType.NVarChar, 50),
new SqlParameter("@Remarks", SqlDbType.NVarChar, 50),
new SqlParameter("@RoleID", SqlDbType.Int, 4)
};
parameters[0].Value = model.RoleName;
parameters[1].Value = model.Remarks;
parameters[2].Value = model.RoleID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(User_RoleModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into User_Role(");
strSql.Append("RoleName,Remarks)");
strSql.Append(" values (");
strSql.Append("@RoleName,@Remarks)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@RoleName", SqlDbType.NVarChar, 50),
new SqlParameter("@Remarks", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.RoleName;
parameters[1].Value = model.Remarks;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public async Task <IActionResult> Create([Bind("Id,Role_Name,User_Id,First_Name,Last_Name,Email,Address,Created_At,Updated_At")] User_RoleModel user_RoleModel, string Role_Name)
{
/* To return the selected application role from the database if it exists*/
var new_application_role = await _context.Roles.SingleOrDefaultAsync(r => r.Id == Role_Name);
if (ModelState.IsValid)
{
// To pass the creation date on system time
// The below NETCORE class is used to separate the email string into parts such as user and domain
System.Net.Mail.MailAddress addr = new System.Net.Mail.MailAddress(user_RoleModel.Email);
string email_username = addr.User;
var user = new ApplicationUser
{
UserName = email_username,
Email = user_RoleModel.Email,
FirstName = user_RoleModel.First_Name,
LastName = user_RoleModel.Last_Name,
Address = user_RoleModel.Address,
Created_At = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Trim())
};
string password = "******";
var result = await _userManager.CreateAsync(user, password);
if (result.Succeeded)
{
// Add role to user after successful insert
result = await _userManager.AddToRoleAsync(user, new_application_role.Name);
}
return(RedirectToAction(nameof(AdminIndex)).WithSuccess("Success", "Successfully Inserted User Details"));
}
return(View(user_RoleModel));
}
public async Task <IActionResult> Edit(string id, [Bind("Id,Role_Name,User_Id,First_Name,Last_Name,Email,Address,Created_At,Updated_At")] User_RoleModel user_RoleModel, string Role_Name)
{
if (id != user_RoleModel.User_Id)
{
return(NotFound());
}
/* To return the selected application user and application role from the database if it exists*/
var applicationuser = await _context.Users.SingleOrDefaultAsync(x => x.Id == id);
var new_application_role = await _context.Roles.SingleOrDefaultAsync(r => r.Id == Role_Name);
var old_application_role = await _context.UserRoles.SingleOrDefaultAsync(ru => ru.UserId == applicationuser.Id);
var old_RoleName = await _context.Roles.SingleOrDefaultAsync(r => r.Id == old_application_role.RoleId);
if (ModelState.IsValid)
{
try
{
applicationuser.FirstName = user_RoleModel.First_Name;
applicationuser.LastName = user_RoleModel.Last_Name;
applicationuser.Email = user_RoleModel.Email;
applicationuser.Address = user_RoleModel.Address;
// To set the system time for record update
applicationuser.Updated_At = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Trim());
_context.Update(applicationuser);
_context.Entry(applicationuser).Property(x => x.Created_At).IsModified = false; // To prevent the datetime property to be set as null on update operation
// To update the role of the user by deleting the old role and assigning new role to the user
if (old_application_role.RoleId != Role_Name)
{
await _userManager.RemoveFromRoleAsync(applicationuser, old_RoleName.Name);
await _userManager.AddToRoleAsync(applicationuser, new_application_role.Name);
}
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ApplicationUserExists(applicationuser.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(AdminIndex)).WithSuccess("Success", "Successfully Updated User Details"));
}
return(View(user_RoleModel));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public User_RoleModel DataRowToModel(DataRow row)
{
User_RoleModel model = new User_RoleModel();
if (row != null)
{
if (row["RoleID"] != null && row["RoleID"].ToString() != "")
{
model.RoleID = int.Parse(row["RoleID"].ToString());
}
if (row["RoleName"] != null)
{
model.RoleName = row["RoleName"].ToString();
}
if (row["Remarks"] != null)
{
model.Remarks = row["Remarks"].ToString();
}
}
return(model);
}
private void NewUserEventHandler(object sender, UserEventArgs e)
{
User_RoleModel roleModel = bllRole.GetModel(e.RoleId);
if (roleModel != null)
{
if (bllUser.IsExistUser(e.RoleId, e.UserName) == false)
{
User_ListModel userModel = new User_ListModel();
userModel.RoleID = e.RoleId;
userModel.UserName = e.UserName;
userModel.UserPassWord = e.Password;
userModel.RoleName = roleModel.RoleName;
int addStatus = bllUser.Add(userModel);
if (addStatus != 1)
{
List <User_ListModel> userModelList = bllUser.GetModelList("");
this.View.RefreshAllUserData(userModelList);
if (mainPre != null)
{
mainPre.View.AddLog(ECAMSModel.EnumLogCategory.管理层日志, ECAMSModel.EnumLogType.提示, "新建用户成功！！");
}
}
else
{
if (mainPre != null)
{
mainPre.View.AddLog(ECAMSModel.EnumLogCategory.管理层日志, ECAMSModel.EnumLogType.提示, "新建用户失败！！");
}
}
}
else
{
if (mainPre != null)
{
mainPre.View.AddLog(ECAMSModel.EnumLogCategory.管理层日志, ECAMSModel.EnumLogType.提示, "已存在同角色同名称用户!!");
}
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public User_RoleModel GetModel(int RoleID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 RoleID,RoleName,Remarks from User_Role ");
strSql.Append(" where RoleID=@RoleID");
SqlParameter[] parameters =
{
new SqlParameter("@RoleID", SqlDbType.Int, 4)
};
parameters[0].Value = RoleID;
User_RoleModel model = new User_RoleModel();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(User_RoleModel model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(User_RoleModel model)
{
return(dal.Add(model));
}
