public bool ChangePassword(string userName, string newPassword) { byte[] bNewPassword = GetEncryptedString(newPassword); try { using (var ctx = new Entities(ConnectionString)) { RbacUser dbUser = ctx.RbacUsers.Where(r => r.UserName.Equals(userName, StringComparison.OrdinalIgnoreCase)).SingleOrDefault(); if (dbUser != null) { dbUser.Password = bNewPassword; ctx.SaveChanges(); return(true); } } } catch (DbUpdateException dbe) { RaiseError(dbe); } catch (DbEntityValidationException e) { RaiseError(e); } return(false); }
public Framework.RbacUser GetUser(string userName) { Framework.RbacUser user = null; using (var ctx = new Entities(ConnectionString)) { RbacUser dbRbacUser = ctx.RbacUsers.Where(r => r.UserName.Equals(userName, StringComparison.OrdinalIgnoreCase)).SingleOrDefault(); if (dbRbacUser != null) { user = Assign(dbRbacUser); } } return(user); }
public Framework.RbacUser GetUser(int userId) { Framework.RbacUser user = null; using (var ctx = new Entities(ConnectionString)) { RbacUser dbRbacUser = ctx.RbacUsers.Where(r => r.UserId == userId).SingleOrDefault(); if (dbRbacUser != null) { user = Assign(dbRbacUser); } } return(user); }
//private RbacEntitlement Assign(Framework.RbacEntitlement entitlement) //{ // if (entitlement == null) // return null; // RbacEntitlement dbEntitlement = new RbacEntitlement(); // dbEntitlement.RbacId = entitlement.RbacId; // dbEntitlement.EntitlementId = entitlement.EntitlementId; // dbEntitlement.Name = entitlement.Name; // dbEntitlement.Description = entitlement.Description; // dbEntitlement.MetaData = GetEncryptedString(entitlement.MetaDatar); // dbEntitlement.Version = entitlement.Version; // return dbEntitlement; //} //private Framework.RbacEntitlement Assign(RbacEntitlement rbacRole) //{ // if (rbacRole == null) // return null; // Framework.RbacEntitlement newRbacRole = new Framework.RbacEntitlement(); // newRbacRole.RbacId = rbacRole.RbacId; // newRbacRole.EntitlementId = rbacRole.EntitlementId; // newRbacRole.Name = rbacRole.Name; // newRbacRole.Description = rbacRole.Description; // if (!HideSensitiveData) // { // newRbacRole.MetaData = GetDecryptedString(rbacRole.MetaData); // } // newRbacRole.Version = (int)rbacRole.Version; // return newRbacRole; //} private RbacUser Assign(Framework.RbacUser user) { if (user == null) { return(null); } RbacUser newUser = new RbacUser(); newUser.RoleId = user.Role.RoleId; newUser.UserId = user.UserId; newUser.UserName = user.UserName; newUser.FullName = user.FullName; newUser.Email = user.Email; return(newUser); }
public Framework.RbacUser Authenticate(string userName, string password) { Framework.RbacUser user = null; byte[] bPassword = GetEncryptedString(password); using (var ctx = new Entities(ConnectionString)) { RbacUser dbUser = ctx.RbacUsers.AsEnumerable().Where(r => ((r.UserName.Equals(userName, StringComparison.OrdinalIgnoreCase)) && (r.Password.SequenceEqual(bPassword)))).SingleOrDefault(); if (dbUser != null) { HideSensitiveData = false; user = Assign(dbUser); } } return(user); }
private Framework.RbacUser Assign(RbacUser user) { if (user == null) { return(null); } Framework.RbacUser newUser = new Framework.RbacUser(); if (!HideSensitiveData) { newUser.Role = GetRole(user.RoleId); } newUser.UserId = user.UserId; newUser.UserName = user.UserName; newUser.FullName = user.FullName; newUser.Email = user.Email; return(newUser); }
public Framework.RbacUser AddOrUpdate(Framework.RbacUser user) { RbacUser dbUser = null; try { using (var ctx = new Entities(ConnectionString)) { dbUser = ctx.RbacUsers.Where(r => r.UserId == user.UserId).SingleOrDefault(); if (dbUser == null) //try with userName { dbUser = ctx.RbacUsers.Where(r => r.UserName.Equals(user.UserName, StringComparison.OrdinalIgnoreCase)).SingleOrDefault(); } if (dbUser == null) { RbacUser newUser = Assign(user); newUser.RoleId = user.Role.RoleId; newUser.Password = GetEncryptedString(RbacCache.TempPassword); //this needs to be immediately changed dbUser = ctx.RbacUsers.Add(newUser); } else { user.UserId = dbUser.UserId; dbUser.FullName = user.FullName; dbUser.Email = user.Email; } ctx.SaveChanges(); } } catch (DbUpdateException dbe) { RaiseError(dbe); } catch (DbEntityValidationException e) { RaiseError(e); } return(Assign(dbUser)); }