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