/// <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);
}
