/// <summary>
/// Removes a user from the database by name
/// </summary>
/// <returns><c>true</c>, if user was deleted, <c>false</c> otherwise.</returns>
/// <param name="username">Username.</param>
public static bool DeleteUser(string username)
{
using (var ctx = new OTAContext())
{
var matches = ctx.Players.Where(x => x.Name == username);
var range = ctx.Players.RemoveRange(matches);
ctx.SaveChanges();
return matches.Any();
}
}
/// <summary>
/// Creates a user.
/// </summary>
/// <returns><c>true</c>, if user was created, <c>false</c> otherwise.</returns>
/// <param name="username">Username.</param>
/// <param name="password">Password.</param>
/// <param name="op">If set to <c>true</c> op.</param>
public static DbPlayer CreateUser(string username, string password, bool op = false)
{
using (var ctx = new OTAContext())
{
var player = ctx.Players.Add(new DbPlayer(username, password)
{
Operator = op,
DateAddedUTC = DateTime.UtcNow
});
ctx.SaveChanges();
return player;
}
}
/// <summary>
/// Store a setting
/// </summary>
/// <param name="key">Key.</param>
/// <param name="value">Value.</param>
public static void Set(string key, string value)
{
using (var ctx = new OTAContext())
{
var item = ctx.Settings.Where(x => x.DataKey == key).SingleOrDefault();
if (item != null)
{
item.DataValue = value;
}
else
{
ctx.Settings.Add(item = new DataSetting()
{
DataKey = key,
DataValue = value
});
}
ctx.SaveChanges();
}
}
/// <summary>
/// Removes a player from a group
/// </summary>
/// <returns><c>true</c>, if user from group was removed, <c>false</c> otherwise.</returns>
/// <param name="username">Username.</param>
/// <param name="groupName">Group name.</param>
public static bool RemoveUserFromGroup(string username, string groupName)
{
if (!IsAvailable)
throw new InvalidOperationException("No connector attached");
using (var ctx = new OTAContext())
{
var user = ctx.Players.Single(x => x.Name == username);
var group = ctx.Groups.Single(x => x.Name == groupName);
var range = ctx.PlayerGroups.RemoveRange(ctx.PlayerGroups.Where(x =>
x.GroupId == group.Id &&
x.UserId == user.Id
));
ctx.SaveChanges();
return range.Any();
}
}
/// <summary>
/// Removes a specific node from a user
/// </summary>
/// <returns><c>true</c>, if node from user was removed, <c>false</c> otherwise.</returns>
/// <param name="username">Username.</param>
/// <param name="node">Node.</param>
/// <param name="deny">If set to <c>true</c> deny.</param>
public static bool RemoveNodeFromUser(string username, string node, Permission permission)
{
if (!IsAvailable)
throw new InvalidOperationException("No connector attached");
using (var ctx = new OTAContext())
{
var range = ctx.PlayerNodes.RemoveRange(
ctx.Players
.Where(p => p.Name == username)
.Join(ctx.PlayerNodes, x => x.Id, y => y.UserId, (a, b) => b)
);
ctx.SaveChanges();
return range.Any();
}
}
/// <summary>
/// Removes a node from a group
/// </summary>
/// <returns><c>true</c>, if group node was removed, <c>false</c> otherwise.</returns>
/// <param name="groupName">Group name.</param>
/// <param name="node">Node.</param>
/// <param name="deny">If set to <c>true</c> deny.</param>
public static bool RemoveGroupNode(string groupName, string node, Permission permission)
{
if (!IsAvailable)
throw new InvalidOperationException("No connector attached");
using (var ctx = new OTAContext())
{
var range = ctx.GroupNodes.RemoveRange(
from grp in ctx.Groups
join nds in ctx.GroupNodes on grp.Id equals nds.GroupId
select nds
);
ctx.SaveChanges();
return range.Any();
}
}
/// <summary>
/// Remove a group
/// </summary>
/// <returns><c>true</c>, if group was removed, <c>false</c> otherwise.</returns>
/// <param name="name">Name.</param>
public static bool RemoveGroup(string name)
{
if (!IsAvailable)
throw new InvalidOperationException("No connector attached");
using (var ctx = new OTAContext())
{
var range = ctx.Groups.RemoveRange(ctx.Groups.Where(x => x.Name == name));
ctx.SaveChanges();
return range.Any();
}
}
public static NodePermission FindOrCreateNode(string node, Permission permission)
{
if (!IsAvailable)
throw new InvalidOperationException("No connector attached");
using (var ctx = new OTAContext())
{
var existing = ctx.Nodes.SingleOrDefault(x => x.Node == node && x.Permission == permission);
if (existing != null) return existing;
else
{
ctx.Nodes.Add(existing = new NodePermission()
{
Node = node,
Permission = permission
});
ctx.SaveChanges();
return existing;
}
}
}
/// <summary>
/// Adds a user to a group
/// </summary>
/// <returns><c>true</c>, if user to group was added, <c>false</c> otherwise.</returns>
/// <param name="username">Username.</param>
/// <param name="groupName">Group name.</param>
public static bool AddUserToGroup(string username, string groupName)
{
if (!IsAvailable)
throw new InvalidOperationException("No connector attached");
using (var ctx = new OTAContext())
{
var user = ctx.Players.Single(x => x.Name == username);
var group = ctx.Groups.Single(x => x.Name == groupName);
//Temporary until the need for more than one group
if (ctx.PlayerGroups.Any(x => x.GroupId > 0))
throw new NotSupportedException("A player can only be associated to one group, please assign a parent to the desired group");
ctx.PlayerGroups.Add(new PlayerGroup()
{
GroupId = group.Id,
UserId = user.Id
});
ctx.SaveChanges();
return true;
}
}
/// <summary>
/// Add or update a group
/// </summary>
/// <returns><c>true</c>, if the update group was added/updated, <c>false</c> otherwise.</returns>
/// <param name="name">Name.</param>
/// <param name="applyToGuests">If set to <c>true</c>, the group will be applied to guests.</param>
/// <param name="parent">Parent.</param>
/// <param name="r">The red chat component.</param>
/// <param name="g">The green chat component.</param>
/// <param name="b">The blue chat component.</param>
/// <param name="prefix">Prefix.</param>
/// <param name="suffix">Suffix.</param>
public static Group AddOrUpdateGroup(string name, bool applyToGuests = false, string parent = null, byte r = 255, byte g = 255, byte b = 255, string prefix = null, string suffix = null)
{
if (!IsAvailable)
throw new InvalidOperationException("No connector attached");
using (var ctx = new OTAContext())
{
var group = ctx.Groups.SingleOrDefault(x => x.Name == name);
if (group != null)
{
group.ApplyToGuests = applyToGuests;
group.Parent = parent;
group.Chat_Red = r;
group.Chat_Green = g;
group.Chat_Blue = b;
group.Chat_Prefix = prefix;
group.Chat_Suffix = suffix;
}
else
{
ctx.Groups.Add(group = new Group()
{
Name = name,
ApplyToGuests = applyToGuests,
Parent = parent,
Chat_Red = r,
Chat_Green = g,
Chat_Blue = b,
Chat_Prefix = prefix,
Chat_Suffix = suffix
});
}
ctx.SaveChanges();
return group;
}
}
/// <summary>
/// Adds a specific node to a user
/// </summary>
/// <returns><c>true</c>, if node to user was added, <c>false</c> otherwise.</returns>
/// <param name="username">Username.</param>
/// <param name="node">Node.</param>
/// <param name="deny">If set to <c>true</c> deny.</param>
public static bool AddNodeToUser(string username, string node, Permission permission)
{
if (!IsAvailable)
throw new InvalidOperationException("No connector attached");
using (var ctx = new OTAContext())
{
var user = ctx.Players.Single(x => x.Name == username);
var perm = FindOrCreateNode(node, permission);
var range = ctx.PlayerNodes.RemoveRange(ctx.PlayerNodes.Where(x =>
x.NodeId == perm.Id &&
x.UserId == user.Id
));
ctx.SaveChanges();
return range.Any();
}
}
/// <summary>
/// Adds a node to a group
/// </summary>
/// <returns><c>true</c>, if group node was added, <c>false</c> otherwise.</returns>
/// <param name="groupName">Group name.</param>
/// <param name="node">Node.</param>
/// <param name="deny">If set to <c>true</c> deny.</param>
public static bool AddGroupNode(string groupName, string node, Permission permission)
{
if (!IsAvailable)
throw new InvalidOperationException("No connector attached");
using (var ctx = new OTAContext())
{
var group = ctx.Groups.Where(x => x.Name == groupName).SingleOrDefault();
var perm = FindOrCreateNode(node, permission);
ctx.GroupNodes.Add(new GroupNode()
{
GroupId = group.Id,
NodeId = perm.Id
});
ctx.SaveChanges();
return true;
}
}
/// <summary>
/// Updates a user in the database.
/// </summary>
/// <returns><c>true</c>, if user was updated, <c>false</c> otherwise.</returns>
/// <param name="username">Username.</param>
/// <param name="password">Password.</param>
/// <param name="op">If set to <c>true</c> op.</param>
public static bool UpdateUser(string username, string password, bool? op = null)
{
if (username == null && op == null) throw new InvalidOperationException("You have not specified anything to be updated");
using (var ctx = new OTAContext())
{
var player = ctx.Players.SingleOrDefault(p => p.Name == username);
if (player == null) throw new InvalidOperationException("Cannot update a non-existent player");
if (password != null) player.SetRawPassword(password);
if (op.HasValue) player.Operator = op.Value;
ctx.SaveChanges();
return true;
}
}
