/// <summary> /// Constructor that takes a MySQLDatabase as argument /// </summary> /// <param name="database"></param> public UserStore(MySQLDatabase database) { Database = database; userTable = new UserTable <TUser>(database); roleTable = new RoleTable(database); userRolesTable = new UserRolesTable(database); userClaimsTable = new UserClaimsTable(database); userLoginsTable = new UserLoginsTable(database); }
/// <summary> /// Deletes all roles from a user in the UserRoles table /// </summary> /// <param name="userId">The user's id</param> /// <returns></returns> public int Delete(string userId, string role) { RoleTable roleTable = new RoleTable(_database); string roleId = roleTable.GetRoleId(role); string commandText = "Delete from UserRoles where UserId = @userId AND RoleId = @roleId"; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("UserId", userId); parameters.Add("RoleId", roleId); return(_database.Execute(commandText, parameters)); }
/// <summary> /// Constructor that takes a MySQLDatabase as argument /// </summary> /// <param name="database"></param> public RoleStore(MySQLDatabase database) { Database = database; roleTable = new RoleTable(database); }