public static void DeleteBlackWord(string typeStr, string word)
{
BlackWordType type;
if (!BlackWordType.TryParse(typeStr, true, out type))
{
return;
}
var wordStruct = Words.FirstOrDefault(wordS => wordS.Type == type && word.Contains(wordS.Word));
if (string.IsNullOrEmpty(wordStruct.Word))
{
return;
}
Words.Remove(wordStruct);
using (var adapter = Azure.GetDatabaseManager().GetQueryReactor())
{
adapter.SetQuery("DELETE FROM server_blackwords WHERE word = @word AND type = @type");
adapter.AddParameter("word", word);
adapter.AddParameter("type", typeStr);
adapter.RunQuery();
}
}
public static void AddBlackWord(string typeStr, string word)
{
BlackWordType type;
if (!BlackWordType.TryParse(typeStr, true, out type))
{
return;
}
if (Words.Any(wordStruct => wordStruct.Type == type && word.Contains(wordStruct.Word)))
{
return;
}
using (var adapter = Azure.GetDatabaseManager().GetQueryReactor())
{
adapter.SetQuery("INSERT INTO server_blackwords VALUES (null, @word, @type)");
adapter.AddParameter("word", word);
adapter.AddParameter("type", typeStr);
adapter.RunQuery();
}
AddPrivateBlackWord(typeStr, word);
}
/// <summary>
/// Loads this instance.
/// </summary>
public static void Load()
{
using (var adapter = Azure.GetDatabaseManager().GetQueryReactor())
{
adapter.SetQuery("SELECT * FROM server_blackwords");
var table = adapter.GetTable();
if (table == null)
{
return;
}
foreach (DataRow row in table.Rows)
{
var word = row["word"].ToString();
var typeStr = row["type"].ToString();
AddPrivateBlackWord(typeStr, word);
}
}
// Out.WriteLine(Words.Count + " BlackWords Loaded -> READY!", "");
Console.WriteLine();
}
