public bool RemoveRole(UsersInRoles usersInRoles)
{
var role = (from userrole in _context.UsersInRoles
where userrole.UserId == usersInRoles.UserId && userrole.RoleId == usersInRoles.RoleId
select userrole).FirstOrDefault();
if (role != null)
{
_context.UsersInRoles.Remove(role);
var result = _context.SaveChanges();
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
public HttpResponseMessage Post([FromBody] UsersInRoles usersInRoles)
{
if (ModelState.IsValid)
{
if (_usersInRoles.CheckRoleExists(usersInRoles))
{
usersInRoles.UserRolesId = 0;
_usersInRoles.RemoveRole(usersInRoles);
var response = new HttpResponseMessage()
{
StatusCode = HttpStatusCode.OK // Status code: 200
};
return(response);
}
else
{
var response = new HttpResponseMessage()
{
StatusCode = HttpStatusCode.Conflict // Status code: 409
};
return(response);
}
}
else
{
var response = new HttpResponseMessage()
{
StatusCode = HttpStatusCode.BadRequest // Status code: 400
};
return(response);
}
}
public ActionResult Create(trabajador trabajador)
{
if (ModelState.IsValid)
{
db.trabajador.Add(trabajador);
db.SaveChanges();
if (IsUserExist(trabajador.tra_cedula))
{
AccountController account = new AccountController();
account.CreateUserProfile(trabajador.tra_cedula, trabajador.tra_cedula);
UserManager userManager = new UserManager();
int Userid = userManager.UpdateTrabajador(trabajador.tra_cedula, trabajador.tra_id);
UsersInRoles usersinroles = new UsersInRoles();
usersinroles.RoleId = 6;
usersinroles.UserId = Userid;
account.CreateUsersInRole(usersinroles);
}
else
{
AccountController account = new AccountController();
UserManager userManager = new UserManager();
int UserId = userManager.UserId(trabajador.tra_cedula);
account.UpdateUsersInRole(UserId, 6);
}
return(RedirectToAction("Index"));
}
ViewBag.tra_empresa = new SelectList(db.empresa, "emp_id", "emp_nombre", trabajador.tra_empresa);
return(View(trabajador));
}
public HttpResponseMessage Post([FromBody] CoordinatorViewModel coordinator)
{
if (ModelState.IsValid)
{
var userId = this.User.FindFirstValue(ClaimTypes.Name);
var tempUsers = AutoMapper.Mapper.Map <Users>(coordinator);
tempUsers.CreatedDate = DateTime.Now;
tempUsers.Createdby = Convert.ToInt32(userId);
tempUsers.Password = EncryptLib.EncryptText(coordinator.Password);
_users.InsertUsers(tempUsers);
var tempCoordinator = AutoMapper.Mapper.Map <Coordinator>(coordinator);
tempCoordinator.UserId = tempUsers.UserId;
_coordinator.InsertCoordinator(tempCoordinator);
UsersInRoles usersInRoles = new UsersInRoles();
usersInRoles.RoleId = 4;
usersInRoles.UserId = tempCoordinator.UserId;
_usersInRoles.AssignRole(usersInRoles);
var response = new HttpResponseMessage()
{
StatusCode = HttpStatusCode.OK
};
return(response);
}
else
{
var response = new HttpResponseMessage()
{
StatusCode = HttpStatusCode.BadRequest
};
return(response);
}
}
public IActionResult UpdateUser([FromBody] UserVm user)
{
User _user = _service.GetUserById(user.UserId);
Membership _membership = _memberservice.GetMemberShipById(user.UserId);
UsersInRoles _userInRol = _userinrole.GetUsersInRolesById(user.UserId);
if (_user != null && _membership != null && _userInRol != null)
{
_user.UserName = user.UserName;
_membership.IsApproved = (bool)user.IsApproved;
_membership.Password = user.Password;
_membership.Email = user.Email;
_user.Membership.Add(_membership);
_userInRol.RoleId = int.Parse(user.roleID);
_user.UsersInRoles.Add(_userInRol);
_service.UpdateUser(_user);
return(new OkObjectResult(_user));
}
else
{
return(NotFound());
}
}
/// <summary>
/// Inserts a new user/role association into the db.
/// </summary>
/// <param name="userRole">The user/role association to add.</param>
/// <returns>true if the user/role is valid and successfully added.</returns>
public bool Insert(UsersInRoles userRole)
{
if (userRole.Validate())
{
userRole.Username = userRole.Username.ToLower();
userRole.Role = userRole.Role.ToLower();
// search for a pre-exisiting association
bool found = (from ur in UserRoles.AsQueryable <UsersInRoles>()
where ur.Username == userRole.Username && ur.Role == userRole.Role
select ur).Any();
if (!found)
{
userRole.UserRoleID = ObjectId.GenerateNewId();
SafeModeResult result = UserRoles.Insert(userRole, SafeMode.True);
return(result.Ok);
}
else
{
return(true);
}
}
else
{
return(false);
}
}
public ActionResult Register(RegisterModel model)
{
if (ModelState.IsValid)
{
// Attempt to register the user
try
{
WebSecurity.CreateUserAndAccount(model.UserName, model.Password);
WebSecurity.Login(model.UserName, model.Password);
UserManager usermanager = new UserManager();
UsersInRoles usersinroles = new UsersInRoles();
usersinroles.RoleId = 4;
usersinroles.UserId = usermanager.UserId(model.UserName);
this.CreateUsersInRole(usersinroles);
return(RedirectToAction("Index", "Home"));
}
catch (MembershipCreateUserException e)
{
ModelState.AddModelError("", ErrorCodeToString(e.StatusCode));
}
}
// If we got this far, something failed, redisplay form
return(View(model));
}
private void validateNewUserInRole(UsersInRoles newUserInRole)
{
if ((_unitOfWork.Users.GetUserById(newUserInRole.UserId) == null) || (_unitOfWork.Roles.GetByRoleId(newUserInRole.RoleId) == null) || (_unitOfWork.UsersInRoles.GetByUserAndRoleId(newUserInRole.UserId, newUserInRole.RoleId) != null))
{
throw new Exception();
}
}
public bool AssignRole(UsersInRoles usersInRoles)
{
_context.Add(usersInRoles);
var result = _context.SaveChanges();
return(result > 0);
}
public ActionResult DeleteConfirmed(Guid?UserId, Guid?RoleId)
{
UsersInRoles usersinroles = db.UsersInRoles.Where(usrl => usrl.UserId == UserId && usrl.RoleId == RoleId).FirstOrDefault <UsersInRoles>();
db.UsersInRoles.Remove(usersinroles);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void CreateUsersInRole(UsersInRoles userinroles)
{
if (ModelState.IsValid)
{
db.UsersInRoles.Add(userinroles);
db.SaveChanges();
}
}
public bool CheckRoleExists(UsersInRoles usersInRoles)
{
var result = (from userrole in _context.UsersInRoles
where userrole.UserId == usersInRoles.UserId && userrole.RoleId == usersInRoles.RoleId
select userrole).Count();
return(result > 0 ? true : false);
}
public static void RemoveCache(UsersInRoles objItem)
{
HttpCache.RemoveByPattern(string.Format(SETTINGS_ALL_KEY, objItem.CompanyID));
HttpCache.RemoveByPattern(string.Format(SETTINGS_ID_KEY, objItem.Username, objItem.CompanyID));
HttpCache.RemoveByPattern(string.Format(SETTINGS_User_KEY, objItem.CreatedUser, objItem.CompanyID));
HttpCache.RemoveSearchCache(SystemConfig.AllowSearchCache, SETTINGS_Search_KEY);
HttpCache.RemoveSearchCache(true, string.Format(SystemConfig.sitemapAccessKey, objItem.CompanyID));//remove key sitemap by role
}
private void ResetAccessForUsers(List <Users> users)
{
List <UsersInRoles> usersInRoleList = Base.UsersByRole.Select().GetAsList();
//add users which exist in the new list but do not exist in the current list on screen
List <Users> usersToAdd =
users.Where(u => !usersInRoleList
.Any(r => string.Equals(r.Username, u.Username))).ToList();
//remove users which exist on screen but do not exist in the new list
List <UsersInRoles> usersToRemove =
usersInRoleList.Where(u =>
u.GetExtension <UsersInRolesExt>().UsrESDirectAssigned != true &&
!users.Any(r => string.Equals(r.Username, u.Username))).ToList();
foreach (UsersInRoles user in usersToRemove)
{
Base.UsersByRole.Delete(user);
}
var usersFromDB = PXSelectJoin <Users,
LeftJoin <EPLoginType,
On <EPLoginType.loginTypeID, Equal <Users.loginTypeID> >,
LeftJoin <EPLoginTypeAllowsRole,
On <EPLoginTypeAllowsRole.loginTypeID, Equal <EPLoginType.loginTypeID> > > >,
Where2 <Where2 <Where <Users.isHidden, Equal <False> >,
And <Where2 <Where <Users.source, Equal <PXUsersSourceListAttribute.application>, Or <Users.overrideADRoles, Equal <True> > >,
And <Where <Required <Roles.guest>, Equal <True>, Or <Users.guest, NotEqual <True> > > > > > >,
And <Where <EPLoginTypeAllowsRole.rolename, Equal <Required <UsersInRoles.rolename> >,
Or <Users.loginTypeID, IsNull> > > > > .Select(Base, new object[] { Base.Roles.Current.Guest,
Base.Roles.Current.Rolename })
.GetAsList()
.ToDictionary(x => x.Username);
List <Users> newUsrsToAdd = new List <Users>();
foreach (Users user in usersToAdd)
{
if (usersFromDB.ContainsKey(user.Username))
{
newUsrsToAdd.Add(user);
}
}
foreach (Users user in newUsrsToAdd)
{
UsersInRoles newUser = Base.UsersByRole.Insert();
Base.UsersByRole.SetValueExt <UsersInRoles.username>(newUser, user.Username);
Base.UsersByRole.SetValueExt <UsersInRolesExt.usrESDirectAssigned>(newUser, false);
//Base.UsersByRole.Update(newUser);
}
}
public UsersInRoles Create(UsersInRoles usersInRoles)
{
using (_unitOfWork)
{
_db.UsersInRoleses.Add(usersInRoles);
_db.SaveChanges();
return(usersInRoles);
}
}
//
// GET: /UsersInRolesAdmin/Delete/5
public ActionResult Delete(Guid?UserId, Guid?RoleId)
{
UsersInRoles usersinroles = db.UsersInRoles.Where(usrl => usrl.UserId == UserId && usrl.RoleId == RoleId).FirstOrDefault <UsersInRoles>();
if (usersinroles == null)
{
return(HttpNotFound());
}
return(View(usersinroles));
}
public ActionResult Edit(UsersInRoles usersinroles)
{
if (ModelState.IsValid)
{
db.Entry(usersinroles).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(usersinroles));
}
//
// GET: /UsersInRolesAdmin/Edit/5
public ActionResult Edit(Guid?id)
{
UsersInRoles usersinroles = db.UsersInRoles.Find(id);
if (usersinroles == null)
{
return(HttpNotFound());
}
return(View(usersinroles));
}
public ActionResult Create(UsersInRoles usersinroles)
{
if (ModelState.IsValid)
{
db.UsersInRoles.Add(usersinroles);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(usersinroles));
}
public static void DeleteByUsername(UsersInRoles objItem)
{
if (objItem != null)
{
using (var client = WebApiHelper.myclient(HouseEndpoint, SystemConst.APIJosonReturnValue))
{
HttpResponseMessage response = client.DeleteAsync(string.Format(Resource + "?userName={0}&deleteby=username&CompanyID={1}", objItem.Username, objItem.CompanyID)).GetAwaiter().GetResult();
}
RemoveCache(objItem);
}
}
private void FillUsersInRollsTree()
{
string queryString = "select u.Name, r.RoleName from userstoRoles utr " +
" join users u on u.userID = utr.FKUserID " +
" join Roles r on r.roleID = utr.FKRoleID ";
if (rbName.Checked)
{
queryString += "order by Name";
}
else
{
queryString += "order by RoleName";
}
UsersInRoles.BeginUpdate();
UsersInRoles.Nodes.Clear();
TreeNode parentNode = null;
TreeNode subNode = null;
DataTable dt = GuardarDatos.GetRoles(queryString);
string currentName = string.Empty;
foreach (DataRow row in dt.Rows)
{
if (rbName.Checked)
{
subNode = new TreeNode(row["roleName"].ToString());
if (currentName != row["Name"].ToString())
{
parentNode = new TreeNode(row["Name"].ToString());
currentName = row["Name"].ToString();
UsersInRoles.Nodes.Add(parentNode);
}
}
else
{
subNode = new TreeNode(row["Name"].ToString());
if (currentName != row["RoleName"].ToString())
{
parentNode = new TreeNode(row["RoleName"].ToString());
currentName = row["RoleName"].ToString();
UsersInRoles.Nodes.Add(parentNode);
}
}
if (parentNode != null)
{
parentNode.Nodes.Add(subNode);
}
}
UsersInRoles.EndUpdate();
}
public void UpdateUsersInRole(int UserId, int RoleId)
{
UsersInRoles deletuser = db.UsersInRoles.Where(d => d.UserId == UserId).First();
db.UsersInRoles.Remove(deletuser);
db.SaveChanges();
if (ModelState.IsValid)
{
deletuser.RoleId = RoleId;
db.UsersInRoles.Add(deletuser);
db.SaveChanges();
}
}
private void AssingRoleIfUserNotHave(List <RolesModel> userRoles, string userId)
{
if (userRoles == null || userRoles.Count == 0)
{
UsersInRoles roleToAssing = new UsersInRoles()
{
UserId = userId,
RoleId = 0
};
_unitOfWork.UsersInRoles.Add(roleToAssing);
_unitOfWork.commit();
}
}
public void UsersInRoles_RowInserting(PXCache cache, PXRowInsertingEventArgs e)
{
UsersInRoles userInRoles = e.Row as UsersInRoles;
if (userInRoles == null)
{
return;
}
else
{
userInRoles.GetExtension <UsersInRolesExt>().UsrESDirectAssigned = true;
}
}
public bool AssignRole(UsersInRoles usersInRoles)
{
_context.Add(usersInRoles);
var result = _context.SaveChanges();
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
public ActionResult Create(doctor doctor)
{
if (Request.Files.Count > 0)
{
var file = Request.Files[0];
string fileName = Path.GetFileName(file.FileName);
string ext = Path.GetExtension(fileName);
string[] formatos = new string[] { ".jpg", ".jpeg", ".bmp", ".png", ".gif", ".JPG", ".JPEG", ".BMP", ".PNG", ".GIF" };
if (!String.IsNullOrEmpty(fileName) && (Array.IndexOf(formatos, ext) >= 0))
{
Firma objfirma = new Firma();
//doctor.doc_firma = fileName;
string path = Path.Combine(Server.MapPath("~/Content/firmas_"), fileName);
string path01 = Path.Combine(Server.MapPath("~/Content/firmas"), fileName);
file.SaveAs(path);
objfirma.ResizeImage(path, path01, 200, 120);
doctor.doc_firma = ConvertBytes(path01);
}
else
{
if (!String.IsNullOrEmpty(ext))
{
if (Array.IndexOf(formatos, ext) <= 0)
{
ModelState.AddModelError("ext", "Extensión no Válida");
}
}
}
}
if (ModelState.IsValid && IsUserExist(doctor.doc_cedula))
{
db.doctor.Add(doctor);
db.SaveChanges();
AccountController account = new AccountController();
account.CreateUserProfile(doctor.doc_cedula, doctor.doc_cedula);
UserManager userManager = new UserManager();
int Userid = userManager.UserId(doctor.doc_cedula);
UsersInRoles usersinroles = new UsersInRoles();
usersinroles.RoleId = 7;
usersinroles.UserId = Userid;
account.CreateUsersInRole(usersinroles);
return(RedirectToAction("Index"));
}
ViewBag.doc_empresa = new SelectList(db.empresa, "emp_id", "emp_nombre", doctor.doc_empresa);
ViewBag.doc_especialidad = new SelectList(db.especialidad, "esp_id", "esp_nombre", doctor.doc_especialidad);
return(View(doctor));
}
public async Task <ActionResult> UsersInRoles(UsersInRoles Role)
{
if (ModelState.IsValid)
{
string userid = _IdentitiyContext.Users.Where(x => x.UserName == Role.Username).Select(x => x.Id).FirstOrDefault();
var result = await UserManager.AddToRoleAsync(userid, Role.RoleID);
ViewBag.Username = new SelectList(_IdentitiyContext.Users, "UserName", "UserName", Role.Username);
ViewBag.RoleId = new SelectList(_IdentitiyContext.Roles, "Name", "Name", Role.RoleID);
return(View(Role));
}
ViewBag.Username = new SelectList(_IdentitiyContext.Users, "UserName", "UserName", Role.Username);
ViewBag.RoleId = new SelectList(_IdentitiyContext.Roles, "Name", "Name", Role.RoleID);
return(View(Role));
}
public static UsersInRoles Update(UsersInRoles objItem)
{
UsersInRoles item = new UsersInRoles();
using (var client = WebApiHelper.myclient(HouseEndpoint, SystemConst.APIJosonReturnValue))
{
HttpResponseMessage response = client.PutAsJsonAsync(string.Format(Resource + "/{0}", objItem.Username), objItem).GetAwaiter().GetResult();
if (response.IsSuccessStatusCode)
{
item = response.Content.ReadAsAsync <UsersInRoles>().GetAwaiter().GetResult();
RemoveCache(item);
}
}
return(item);
}
public static UsersInRoles Add(UsersInRoles objItem)
{
UsersInRoles b = new UsersInRoles();
using (var client = WebApiHelper.myclient(HouseEndpoint, SystemConst.APIJosonReturnValue))
{
HttpResponseMessage response = client.PostAsJsonAsync(Resource, objItem).GetAwaiter().GetResult();
if (response.IsSuccessStatusCode)
{
b = response.Content.ReadAsAsync <UsersInRoles>().GetAwaiter().GetResult();
}
}
RemoveCache(b);
return(b);
}
public bool RemoveRole(UsersInRoles usersInRoles)
{
var role = (from userrole in _roleService.GetUserRoles()
where userrole.UserId == usersInRoles.UserId && userrole.RoleId == usersInRoles.RoleId
select userrole).FirstOrDefault();
if (role != null)
{
_roleService.DeleteUsersInRole(role);
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// Create a new UsersInRoles object.
/// </summary>
/// <param name="ID">Initial value of ID.</param>
public static UsersInRoles CreateUsersInRoles(int ID)
{
UsersInRoles usersInRoles = new UsersInRoles();
usersInRoles.ID = ID;
return usersInRoles;
}
/// <summary>
/// There are no comments for UsersInRoles in the schema.
/// </summary>
public void AddToUsersInRoles(UsersInRoles usersInRoles)
{
base.AddObject("UsersInRoles", usersInRoles);
}
/// <summary>
/// Create a new UsersInRoles object.
/// </summary>
/// <param name="id">Initial value of ID.</param>
public static UsersInRoles CreateUsersInRoles(int id)
{
UsersInRoles usersInRoles = new UsersInRoles();
usersInRoles.ID = id;
return usersInRoles;
}
