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));
}
public void Delete(Framework.RbacUser user)
{
}
