/// <summary> /// Returns an TUser given the user's id /// </summary> /// <param name="userId">The user's id</param> /// <returns></returns> public TUser GetUserById(string userId) { TUser user = null; string commandText = "Select * from Users where Id = @id"; Dictionary <string, object> parameters = new Dictionary <string, object>() { { "@id", userId } }; var rows = _database.Query(commandText, parameters); if (rows != null && rows.Count == 1) { var row = rows[0]; user = (TUser)Activator.CreateInstance(typeof(TUser)); user.Id = row["Id"]; user.UserName = row["UserName"]; user.PasswordHash = string.IsNullOrEmpty(row["PasswordHash"]) ? null : row["PasswordHash"]; user.SecurityStamp = string.IsNullOrEmpty(row["SecurityStamp"]) ? null : row["SecurityStamp"]; user.Email = string.IsNullOrEmpty(row["Email"]) ? null : row["Email"]; user.EmailConfirmed = row["EmailConfirmed"] == "1" ? true:false; user.PhoneNumber = string.IsNullOrEmpty(row["PhoneNumber"]) ? null : row["PhoneNumber"]; user.PhoneNumberConfirmed = row["PhoneNumberConfirmed"] == "1" ? true : false; user.LockoutEnabled = row["LockoutEnabled"] == "1" ? true : false; user.LockoutEndDateUtc = string.IsNullOrEmpty(row["LockoutEndDateUtc"]) ? DateTime.Now : DateTime.Parse(row["LockoutEndDateUtc"]); user.AccessFailedCount = string.IsNullOrEmpty(row["AccessFailedCount"]) ? 0 : int.Parse(row["AccessFailedCount"]); } return(user); }
/// <summary> /// Return all user /// </summary> /// <param name="userId"></param> /// <returns></returns> public IEnumerable <TUser> GetUsers() { List <TUser> userlist = new List <TUser>(); string commandText = "Select * from AspNetUsers"; var rows = _database.Query(commandText, null); foreach (var row in rows) { TUser user = null; user = (TUser)Activator.CreateInstance(typeof(TUser)); user.Id = row["Id"]; user.UserName = row["UserName"]; user.PasswordHash = string.IsNullOrEmpty(row["PasswordHash"]) ? null : row["PasswordHash"]; user.SecurityStamp = string.IsNullOrEmpty(row["SecurityStamp"]) ? null : row["SecurityStamp"]; user.Email = string.IsNullOrEmpty(row["Email"]) ? null : row["Email"]; user.EmailConfirmed = row["EmailConfirmed"] == "1" ? true : false; user.PhoneNumber = string.IsNullOrEmpty(row["PhoneNumber"]) ? null : row["PhoneNumber"]; user.PhoneNumberConfirmed = row["PhoneNumberConfirmed"] == "1" ? true : false; user.LockoutEnabled = row["LockoutEnabled"] == "1" ? true : false; user.LockoutEndDateUtc = string.IsNullOrEmpty(row["LockoutEndDateUtc"]) ? DateTime.Now : DateTime.Parse(row["LockoutEndDateUtc"]); user.AccessFailedCount = string.IsNullOrEmpty(row["AccessFailedCount"]) ? 0 : int.Parse(row["AccessFailedCount"]); userlist.Add(user); } return(userlist); }
/// <summary> /// Return all user /// </summary> /// <param name="userId"></param> /// <returns></returns> public IEnumerable <TUser> GetUsers() { List <TUser> userlist = new List <TUser>(); string commandText = "Select * from Users"; var rows = _database.Query(commandText, null); foreach (var row in rows) { TUser user = null; user = (TUser)Activator.CreateInstance(typeof(TUser)); user.Id = row["Id"]; user.UserName = row["UserName"]; user.PasswordHash = string.IsNullOrEmpty(row["PasswordHash"]) ? null : row["PasswordHash"]; user.Email = string.IsNullOrEmpty(row["Email"]) ? null : row["Email"]; user.EmailConfirmed = row["EmailConfirmed"] == "1" ? true : false; userlist.Add(user); } return(userlist); }
/// <summary> /// Returns a list of user's roles /// </summary> /// <param name="userId">The user's id</param> /// <returns></returns> public List <string> FindByUserId(string userId) { List <string> roles = new List <string>(); string commandText = "Select Roles.Name from UserRoles, Roles where UserRoles.UserId = @userId and UserRoles.RoleId = Roles.Id"; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("@userId", userId); var rows = _database.Query(commandText, parameters); foreach (var row in rows) { roles.Add(row["Name"]); } return(roles); }
public List <TRole> GetRoles() { List <TRole> rolelist = new List <TRole>(); string commandText = "Select * from Roles"; var rows = _database.Query(commandText, null); foreach (var row in rows) { TRole role = null; role = (TRole)Activator.CreateInstance(typeof(TRole)); role.Id = row["Id"]; role.Name = row["Name"]; rolelist.Add(role); } return(rolelist); }
/// <summary> /// Returns a list of user's logins /// </summary> /// <param name="userId">The user's id</param> /// <returns></returns> public List <UserLoginInfo> FindByUserId(string userId) { List <UserLoginInfo> logins = new List <UserLoginInfo>(); string commandText = "Select * from UserLogins where UserId = @userId"; Dictionary <string, object> parameters = new Dictionary <string, object>() { { "@userId", userId } }; var rows = _database.Query(commandText, parameters); foreach (var row in rows) { var login = new UserLoginInfo(row["LoginProvider"], row["ProviderKey"]); logins.Add(login); } return(logins); }
/// <summary> /// Returns a ClaimsIdentity instance given a userId /// </summary> /// <param name="userId">The user's id</param> /// <returns></returns> public ClaimsIdentity FindByUserId(string userId) { ClaimsIdentity claims = new ClaimsIdentity(); string commandText = "Select * from AspNetUserClaims where UserId = @userId"; Dictionary <string, object> parameters = new Dictionary <string, object>() { { "@UserId", userId } }; var rows = _database.Query(commandText, parameters); foreach (var row in rows) { Claim claim = new Claim(row["ClaimType"], row["ClaimValue"]); claims.AddClaim(claim); } return(claims); }