public static void Delete(IgnoreEntry ignore)
{
if (ignore == null)
{
throw new ArgumentNullException("ignore");
}
if (ignore.Id < 1)
{
throw new ArgumentException("Can't delete a non-existant ignore", "ignore");
}
using (var cmd = db.CreateCommand("DELETE FROM ignores WHERE (ignoreId=?)"))
{
cmd.Parameters.Add(new SQLiteParameter("id", ignore.Id));
cmd.ExecuteNonQuery();
}
}
public static void SaveOrUpdate(IgnoreEntry ignore)
{
if (ignore == null)
{
throw new ArgumentNullException("ignore");
}
using (var cmd = db.CreateCommand())
{
cmd.CommandText = ignore.Id > 0
? "UPDATE ignores SET ignoreServerId=?,ignoreUsername=? WHERE (ignoreId=?)"
: "INSERT INTO ignores (ignoreServerId,ignoreUsername) VALUES (?,?)";
cmd.Parameters.Add(new SQLiteParameter("server", ignore.ServerId));
cmd.Parameters.Add(new SQLiteParameter("username", ignore.Username));
if (ignore.Id > 0)
{
cmd.Parameters.Add(new SQLiteParameter("id", ignore.Id));
}
cmd.ExecuteNonQuery();
}
}
