public ActionResult Create(RoleUser ObjRoleUser)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
try
{
if (ModelState.IsValid)
{
db.RoleUsers.Add(ObjRoleUser);
db.SaveChanges();
sb.Append("Sumitted");
return(Content(sb.ToString()));
}
else
{
foreach (var key in this.ViewData.ModelState.Keys)
{
foreach (var err in this.ViewData.ModelState[key].Errors)
{
sb.Append(err.ErrorMessage + "<br/>");
}
}
}
}
catch (Exception ex)
{
sb.Append("Error :" + ex.Message);
}
return(Content(sb.ToString()));
}
protected override void Seed(UnifyAuthorization.UnifyContext context)
{
// This method will be called after migrating to the latest version.
// You can use the DbSet<T>.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data.
var Company = new Company("LFG", "LGPMS", "https://www.bing.com", "Test");
context.Set <Company>().AddOrUpdate(Company);
var User = new User(Company.Id, "IT", "12345678", "Tim", "123456", "Programming", "15234592255", "*****@*****.**", null);
context.Set <User>().AddOrUpdate(User);
var Role = new Role(Company.Id, "Admin", "Admin", User.Id);
context.Set <Role>().AddOrUpdate(Role);
var Function = new FunctionModel("Pms", "Project", "ПоДї", "View", "View", User.Id);
context.Set <FunctionModel>().Add(Function);
var RoleUser = new RoleUser(Role.Id, User.Id, User.Id);
context.Set <RoleUser>().AddOrUpdate(RoleUser);
var RolePermission = new RolePermission(Role.Id, Function.Id, User.Id);
context.Set <RolePermission>().AddOrUpdate(RolePermission);
context.SaveChanges();
}
static void Init()
{
using (var db = new UnifyContext())
{
db.Database.CreateIfNotExists();
var Company = new Company("LFG", "LGPMS", "https://www.bing.com", "Test");
db.Set <Company>().Add(Company);
//var Company = db.Set<Company>().First();
var User = new User(Company.Id, "IT", "12345678", "Tim", "123456", "Programming", "15234592255", "*****@*****.**", null);
db.Set <User>().Add(User);
//var User = db.Set<User>().First();
var Role = new Role(Company.Id, "Admin", "Admin", User.Id);
db.Set <Role>().Add(Role);
//var Role = db.Set<Role>().First();
var Function = new FunctionModel("Pms", "Project", "项目", "View", "View", User.Id);
db.Set <FunctionModel>().Add(Function);
var RoleUser = new RoleUser(Role.Id, User.Id, User.Id);
db.Set <RoleUser>().Add(RoleUser);
var RolePermission = new RolePermission(Role.Id, Function.Id, User.Id);
db.Set <RolePermission>().Add(RolePermission);
db.SaveChanges();
Console.WriteLine("Save successful");
Console.ReadLine();
}
}
public async Task <IActionResult> AddRole(Guid userId, Guid roleId)
{
RoleUser roleUser = this.roleUserService.Get(ru => ru.RoleId == roleId && ru.UserId == userId);
if (roleUser == null)
{
roleUser = new RoleUser {
UserId = userId, RoleId = roleId
};
this.roleUserService.Create(roleUser);
}
else
{
return(Json(null));
}
var roleUsers = await this.roleUserService.GetManyAsync(ru => ru.UserId == userId);
string roleNames = "";
foreach (var _roleUser in roleUsers)
{
var role = this.roleService.GetById(_roleUser.RoleId);
roleNames += role.Name + ",";
}
//JsonResult jsonResult = role == null ? Json(null) : Json(new { RoleName = role.Name });
return(Json(new { RoleNames = roleNames }));
}
static public void AddUserAndRoles(string newStaffUserName)
{
var environmentParametersViewModel = new Thinkgate.Domain.Classes.EnvironmentParametersFactory(AppSettings.ConnectionStringName).GetEnvironmentParameters();
var clientId = environmentParametersViewModel.ClientId;
var kenticoEnabled = environmentParametersViewModel.IsKenticoEnabledSite;
if (kenticoEnabled)
{
SqlParameterCollection parmsUersInRoles = new SqlCommand().Parameters;
parmsUersInRoles.AddWithValue("ApplicationName", AppSettings.ApplicationName);
parmsUersInRoles.AddWithValue("UserName", newStaffUserName);
var findRolesForUser = ThinkgateDataAccess.FetchDataTable(AppSettings.ConnectionString,
Thinkgate.Base.Classes.Data.StoredProcedures.ASPNET_USERS_IN_ROLES_GET_ROLES_FOR_USER,
System.Data.CommandType.StoredProcedure,
parmsUersInRoles);
var roleservice = new RoleServiceProxy();
var nameCalculator = new Thinkgate.Domain.Classes.KenticoNameCalculator();
for (int i = 0; i < findRolesForUser.Rows.Count; i++)
{
string newStaffRoleName = findRolesForUser.Rows[i]["RoleName"].ToString();
var kenticoUserName = nameCalculator.CalculateUserName(clientId, newStaffUserName);
var kenticoRoleName = nameCalculator.CalculateSystemGroupName(clientId, AdminUserName, newStaffRoleName);
var roleuser = new RoleUser();
roleuser.UserName = kenticoUserName;
roleservice.AddUsersToRole(kenticoRoleName, EnumerableExtensions.SingleItemAsEnumerable<RoleUser>(roleuser));
}
}
}
public ActionResult SaveSysUser(UserInfo userInfo, string roleIDs)
{
// 添加系统用户
if (userInfo.ID == new Guid())
{
userInfo.ID = Guid.NewGuid();
}
if (UserInfoManager.GetUserSession().IsAdmin)
{
userInfo.IsAdmin = true;
}
userInfo.CreateTime = DateTime.Now;
userInfo.UpdateTime = DateTime.Now;
userInfo.Password = Atom.Common.DEncrypt.HashEncode.HashCode(userInfo.Account.ToUpper() + "123456" + userInfo.CreateTime.ToLongDateString());
UserInfoManager.SaveOrUpdate(userInfo);
// 初始化用户和角色关系
RoleUserManager.InitRoleUserRelateion(userInfo);
// 添加用户角色关联关系
string[] roleStrs = roleIDs.Trim(',').Split(',');
for (int i = 0; i < roleStrs.Length; i++)
{
Guid roleID = new Guid(roleStrs[i].ToString());
RoleUser entity = new RoleUser();
entity.ID = Guid.NewGuid();
entity.Role = RoleManager.Get(roleID);
entity.User = userInfo;
RoleUserManager.Save(entity);
}
return(Content("1"));
}
public async Task <IActionResult> UpdateRoleUser([FromRoute] long id, [FromBody] RoleUser roleUser)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != roleUser.RoleId)
{
return(BadRequest());
}
_context.Entry(roleUser).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (Exception e)
{
if (!RoleUserExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public void AddUserToRole(List <RoleUser> roleUserList)
{
if (roleUserList == null || roleUserList.Count == 0)
{
return;
}
using (List <RoleUser> .Enumerator enumerator = this.GetUserRoleListByRoleId(roleUserList[0].Role).GetEnumerator())
{
while (enumerator.MoveNext())
{
RoleUser currentRoleUser = enumerator.Current;
List <RoleUser> list = (from c in roleUserList
where c.User == currentRoleUser.User
select c).ToList <RoleUser>();
if (list.Count != 0)
{
foreach (RoleUser current in list)
{
roleUserList.Remove(current);
}
}
}
}
this._dataBase.InsertList(roleUserList.Cast <object>().ToList <object>());
}
public async Task <IActionResult> EditUsersInRole(string roleId)
{
var role = await _roleManager.FindByIdAsync(roleId);
if (role == null)
{
ViewBag.ErrorMessage = $"The role with id {roleId} can not be found";
return(View("_NotFound"));
}
UserRoleVM model = new UserRoleVM();
model.RoleId = role.Id;
model.RoleName = role.Name;
foreach (var user in _userManager.Users)
{
RoleUser userRole = new RoleUser
{
UserId = user.Id,
UserName = user.UserName,
IsSelected = await _userManager.IsInRoleAsync(user, role.Name)
};
model.Users.Add(userRole);
}
return(View(model));
}
public MenuTreeDto GetNavigationItemV3(RoleUser user)
{
return(GetNavigationItemV3(new List <RoleUser>()
{
user
}));
}
protected void cmdDelete_Click1(object sender, EventArgs e)
{
if (cboOperatorId.Text == null)
{
lblResults1.Text = "User id cannot be empty";
}
if (cboRole.Text == null)
{
lblResults1.Text = "Role cannot be empty";
}
RoleUser DB = new RoleUser();
string varDeleteRole = DB.DeleteRole(cboOperatorId.Text, cboRole.Text, txtUserLabel.Text);
// Fill the DataSet.
DataSet ds = new DataSet();
ds = DB.FindTable();
//adapter.Fill(ds, "tb_Customer");
// Perform the binding.
GridView1.DataSource = ds;
GridView1.DataBind();
lblResults1.Text = "Operation successful";
}
public async Task <OperationResult> AddRoleUserAsync(RoleUser roleUser, List <string> authorisedOrgIds)
{
var isAlreadyExisting = await _organisationContext.RoleUsers
.Where(x => x.NormalisedEmail.Equals(roleUser.NormalisedEmail) &&
x.OrganisationId == roleUser.OrganisationId &&
x.Role == roleUser.Role)
.AnyAsync();
if (isAlreadyExisting)
{
_logger.LogError($"Unable to add role user. Role user with email: {roleUser.Email}, role: {roleUser.Role} and organisation: {roleUser.OrganisationId} already exists.");
return(OperationResult.Error(OperationErrors.DuplicateEmailAndRole));
}
var isAuthorisedToOrg = await _organisationContext.Organisations
.AnyAsync(x => x.Id == roleUser.OrganisationId &&
authorisedOrgIds.Contains(x.ExternalId));
if (!isAuthorisedToOrg)
{
_logger.LogError($"Not authorised to add Role user with email: {roleUser.Email}, role: {roleUser.Role} to organisation: {roleUser.OrganisationId}.");
return(OperationResult.Error(OperationErrors.Unauthorised));
}
_organisationContext.RoleUsers.Add(roleUser);
await _organisationContext.SaveChangesAsync();
return(OperationResult.Success());
}
protected void cmdReport_Click1(object sender, EventArgs e)
{
RoleUser DB = new RoleUser();
string varResponse = DB.PurgeLog(DateTime.Parse(cboStartDate.SelectedDate.ToString()), DateTime.Parse(cboEndDate.SelectedDate.ToString()), txtUserLabel.Text);
lblResults.Text = varResponse;
}
public HttpStatusCode Save(UserModel objModel)
{
if (objModel != null)
{
var existUser = _context.Users.SingleOrDefault(u => u.Email == objModel.Email);
if (existUser != null)
{
return(HttpStatusCode.Conflict);
}
var objEntity = _mapper.Map <UserEntity>(objModel);
objEntity.Password = _stringUltil.EncryptPassword(objEntity.Password, objEntity.Salt);
foreach (var roleId in objModel.RoleIds)
{
var role = _context.Roles.Find(roleId);
if (role != null)
{
RoleUser roleUser = new RoleUser
{
Role = role,
UserEntity = objEntity
};
_context.Add(roleUser);
}
}
_context.Add(objEntity);
_context.SaveChanges();
return(HttpStatusCode.OK);
}
return(HttpStatusCode.BadRequest);
}
public IActionResult Edit(RoleUser model)
{
AlertBack alert = new AlertBack();
try
{
if (ModelState.IsValid)
{
_roleUserService.Update(model);
alert.Status = "success";
alert.Message = "Register Successfully";
}
else
{
alert.Status = "warning";
foreach (var key in this.ViewData.ModelState.Keys)
{
foreach (var err in this.ViewData.ModelState[key].Errors)
{
alert.Message += err.ErrorMessage + "<br/>";
}
}
}
}
catch (Exception ex)
{
alert.Status = "error";
alert.Message = ex.Message;
}
return(Json(alert));
}
public ActionResult register(System.Web.Mvc.FormCollection frmCollection)
{
User user = new User();
user.Username = frmCollection["name"];
user.Password = frmCollection["password2"];
user.Email = frmCollection["email"];
var parent = frmCollection["parent"];
var sponser = frmCollection["sponser"];
if (db.Users.Where(u => u.Username == user.Username).SingleOrDefault() != null)
{
ViewBag.Msg = "Username already taken.";
return(View());
}
User userparent = db.Users.Where(u => u.Username == parent).SingleOrDefault();
User usersponser = db.Users.Where(u => u.Username == sponser).SingleOrDefault();
if (userparent == null || usersponser == null)
{
ViewBag.Msg = "Parent or Sponser doesn't exist";
return(View());
}
else
{
user.ParentId = userparent.Id;
user.SponserId = usersponser.Id;
}
user.MemberShipLevelId = 1;
db.Users.Add(user);
db.SaveChanges();
//REGISTER USER ROLE
RoleUser roleuser = new RoleUser();
roleuser.RoleId = 2;
roleuser.UserId = user.Id;
db.RoleUsers.Add(roleuser);
db.SaveChanges();
string To = user.Email, UserID, Password, SMTPPort, Host;
var lnkHref = "<a href='http://incomeplant.azurewebsites.net/Account/login'>Click this to login your account</a>";
string subject = "Welcome To Income Plant";
string body = "<b>Congratulation!!! <br/> Your account has been successfully created.<br/> We warmly welcome you to our family and appreciate your interest for joining us.</b><br/>" + "</br>" + lnkHref + "<br/>" + "<p>If you did not make this request then you can simply ignore this email.</p><br/><p>Thanks,<br/><br/><b>Incomeplant Support</b></p>" + "<hr>" + "<img src='http://incomeplant.com/images/header-logo.png'/>" + "<br/>" + "<b>Telephone:</b> +91-8218-041-593 <p><b>Website: </b>http://incomeplant.com/</p>" + "<br/>" + "<p style='font-size: 10px;'><b>Address:</b>Harora Road, Simbhaoli, Hapur-245207</p></br><p style='font-size: 10px;'><b>Disclaimer:</b> This message (and any attachments) is private and confidential and may contain personal data or personal views which are not the views of Incomeplant unless specifically stated. If you have received this message in error, please notify us and remove it from your system. Do not use, copy or disclose the information in any way.</p>";
//Get and set the AppSettings using configuration manager.
emailmanager.Appsettings(out UserID, out Password, out SMTPPort, out Host);
//Call send email methods.
emailmanager.SendEmail(UserID, subject, body, To, UserID, Password, SMTPPort, Host);
ViewBag.Msg = "Register Successfully! ";
return(View());
}
private static void AddUser2Role(StreetContext context, Role role, User user)
{
RoleUser ru = new RoleUser {
Role = role, User = user
};
context.RoleUsers.Add(ru);
}
public UpdateRolePage(RoleUser role)
{
InitializeComponent();
var viewModel = new UpdateRoleViewModel();
viewModel.Role = role;
BindingContext = viewModel;
}
public ActionResult DeleteConfirmed(int id)
{
RoleUser ObjRoleUser = db.RoleUsers.Find(id);
db.RoleUsers.Remove(ObjRoleUser);
db.SaveChanges();
return(Redirect(TempData["ThisUrl"].ToString()));
}
public void AddUserToRole(RoleUser roleUser)
{
if (roleUser == null)
{
return;
}
this._dataBase.Insert(roleUser);
}
private RoleUser CreateRoleUser(User u, Role r)
{
var ru = new RoleUser {
Role = r, User = u
};
return(ru);
}
public IActionResult Create(UserViewModel userVM)
{
if (ModelState.IsValid)
{
var random = new Random();
var randomcode = random.Next(1, 10000).ToString("D4");
MailMessage message = new MailMessage();
message.From = new MailAddress("*****@*****.**");
message.To.Add(userVM.Email);
message.Subject = "Verification code";
message.Body = "Your Verify Code is " + randomcode;
SmtpClient smptc = new SmtpClient();
smptc.Host = "smtp.gmail.com";
NetworkCredential nc = new NetworkCredential();
nc.UserName = "******";
nc.Password = "******";
smptc.UseDefaultCredentials = true;
smptc.Credentials = nc;
smptc.Port = 587;
smptc.EnableSsl = true;
smptc.Send(message);
//create akun baru
userVM.RoleName = "Sales";
var user = new User();
var roleuser = new RoleUser();
var role = myContext.Roles.Where(r => r.Name == userVM.RoleName).FirstOrDefault();
user.UserName = userVM.UserName;
user.Email = userVM.Email;
user.NormalizedEmail = randomcode.ToString();
user.EmailConfirmed = false;
user.PasswordHash = BCrypt.Net.BCrypt.HashPassword(userVM.Password);
user.PhoneNumber = userVM.Phone;
user.PhoneNumberConfirmed = false;
user.TwoFactorEnabled = false;
user.LockoutEnabled = false;
user.AccessFailedCount = 0;
roleuser.Role = role;
roleuser.User = user;
myContext.RoleUsers.AddAsync(roleuser);
myContext.Users.AddAsync(user);
myContext.SaveChanges();
var emp = new Employees
{
Id = user.Id,
CreateDate = DateTimeOffset.Now,
isDelete = false
};
myContext.Employees.Add(emp);
myContext.SaveChanges();
return(Ok("Successfully Created"));
}
return(BadRequest("Register Failed"));
}
//Remove lessons from the list the user has no business seeing
//NOTE: This logic should mirror LessonsLearnedMP.Business/LessonBusiness/GetLessonsPaged
public static bool IsLessonVisible(LessonViewModel lesson, RoleUser user)
{
if (lesson.Enabled != true)
{
return(user.RoleId == (int)Enumerations.Role.Administrator);
}
if ((lesson.Status == Enumerations.LessonStatus.Closed && lesson.LessonTypeInvalidId == null) ||
(lesson.Status != Enumerations.LessonStatus.Closed && lesson.OwnerSid == user.Sid))
{
//all user can see valid closed lessons
//ALl users can see their own open lessons
return(true);
}
switch ((Enumerations.Role)user.RoleId)
{
case Enumerations.Role.User:
//User can see Draft Lessons they own
//User can see New Lessons they own
//User can see Admin Review Lessons they own
//User can see Clarification Lessons they own
//User can see BPO Review Lessons they own
//User can see Closed Lessons (Valid only)
return(false);
case Enumerations.Role.Coordinator:
//User can see Draft Lessons they own
//User can see New Lessons they own
//User can see Admin Review Lessons they own
//User can see Clarification Lessons they own
//User can see Clarification Lessons they are assigned to
//User can see BPO Review Lessons they own
//User can see BPO Review Lessons they are assigned to
//User can see Closed Lessons (Valid only)
return((lesson.Status == Enumerations.LessonStatus.Clarification && lesson.CoordinatorOwnerSid == user.Sid) ||
(lesson.Status == Enumerations.LessonStatus.BPOReview && lesson.CoordinatorOwnerSid == user.Sid));
case Enumerations.Role.BPO:
//User can see Draft Lessons they own
//User can see New Lessons they own
//User can see Admin Review Lessons they own
//User can see Clarification Lessons they own
//User can see Clarification Lessons for their discipline
//User can see BPO Review Lessons they own
//User can see BPO Review Lessons for their discipline
//User can see Closed Lessons for their discipline (Valid or Invalid)
//User can see Closed Lessons for other disciplines (Valid only)
return(user.DisciplineId != null && lesson.DisciplineId == user.DisciplineId);
case Enumerations.Role.Administrator:
//No action, users can see everything
return(true);
default:
throw new ArgumentOutOfRangeException();
}
}
public async Task <ActionResult> UpdateRole(int accountId, RoleUser role)
{
Account account = await _account.FindAsync(x => x.AccountId == accountId);
account.Role = role;
bool result = await _account.UpdateAsync(account);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public AlertBack DeleteRoleUser([FromBody] RoleUser model, int id = 0)
{
AlertBack alert = new AlertBack();
roleUserService.Delete(model);
alert.status = "success";
alert.message = "Register Successfully";
return(alert);
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
RoleUser roleUser = await db.RolUsers.FindAsync(id);
db.RolUsers.Remove(roleUser);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public static string FormatUserNameForDisplay(RoleUser person, bool showEmail = true)
{
if (person != null)
{
return(Utility.FormatUserNameForDisplay(person.LastName, person.FirstName, person.Email, person.Enabled, showEmail));
}
return("[*Unknown*]");
}
public PartialViewResult Create()
{
RoleUser model = new RoleUser();
ViewBag.Roles = new SelectList(_roleService.GetAll().ToArray(), "Id", "RoleName");
ViewBag.Users = new SelectList(_userService.GetAll().ToArray(), "Id", "UserName");
return(PartialView(model));
}
public PartialViewResult Edit(int id)
{
RoleUser ObjRoleUser = _roleUserService.Get(id);
ViewBag.Roles = new SelectList(_roleService.GetAll().ToArray(), "Id", "RoleName");
ViewBag.Users = new SelectList(_userService.GetAll().ToArray(), "Id", "UserName");
return(PartialView(ObjRoleUser));
}
/// <summary>
/// 组删除用户
/// </summary>
/// <param name="roleUser"></param>
/// <returns></returns>
public static int DeleteRoleUser(RoleUser roleUser)
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
context.Entry(roleUser).State = System.Data.EntityState.Deleted;
return(context.SaveChanges());
}
}
/// <summary>
/// 用户添加到组
/// </summary>
/// <param name="roleUser"></param>
/// <returns></returns>
public static int AddRoleUser(RoleUser roleUser)
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
context.RoleUsers.Add(roleUser);
return(context.SaveChanges());
}
}
private void SaveFuncUserRoleData(string secFuncNodes, string secUsersNodes, Guid roleGuid)
{
if (!string.IsNullOrEmpty(secFuncNodes))
{
var lstFunc = secFuncNodes.Split(',');
foreach (var func in lstFunc)
{
var roleFunc = new RoleFunc();
roleFunc.CreateId = CurrentUser.UserId;
roleFunc.CreateName = CurrentUser.UserName;
roleFunc.CreateTime = DateTime.Now;
roleFunc.Id = Guid.NewGuid();
roleFunc.FuncId = new Guid(func);
roleFunc.IsValid = true;
roleFunc.RoleId = roleGuid;
unitOfWork.RoleFuncBLL.InsertEntity(roleFunc);
}
}
if (!string.IsNullOrEmpty(secUsersNodes))
{
var lstUser = secUsersNodes.Split(',');
foreach (var user in lstUser)
{
var roleUser = new RoleUser();
roleUser.Id = Guid.NewGuid();
roleUser.IsValid = true;
roleUser.RoleId = roleGuid;
roleUser.UserId = new Guid(user);
roleUser.CreateId = CurrentUser.UserId;
roleUser.CreateName = CurrentUser.UserName;
roleUser.CreateTime = DateTime.Now;
roleUser.UserType = (int)EnumAccountType.Employee;
unitOfWork.RoleUserBLL.InsertEntity(roleUser);
}
}
}
