public int Delete(UserRolesTable userRole)
{
if (_database.Entry(userRole).State == System.Data.Entity.EntityState.Detached)
{
dbSet.Attach(userRole);
}
dbSet.Remove(userRole);
return this.Save();
}
/// <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>
/// Inserts a new role for a user in the UserRoles table
/// </summary>
/// <param name="user">The User</param>
/// <param name="roleId">The Role's id</param>
/// <returns></returns>
/*public int Insert(IdentityUser user, string roleId)
{
string commandText = "Insert into UserRoles (UserId, RoleId) values (@userId, @roleId)";
Dictionary<string, object> parameters = new Dictionary<string, object>();
parameters.Add("userId", user.Id);
parameters.Add("roleId", roleId);
return _database.Execute(commandText, parameters);
}*/
public int Insert(IdentityUser user, string roleId)
{
var userRole = new UserRolesTable
{
UserId = user.Id,
RoleId = roleId
};
dbSet.Add(userRole);
return this.Save();
}
