public static MySqlConnection connection; // Should I pool connections? <_<
#endregion Fields
#region Methods
public static void AddWaveban(WavebanEntry entry)
{
string query = "INSERT INTO wavebans (`issuedby`, `issuedtime`, `target`, `bantype`, `banlength`, `processed`, `processedtime`, `comment`) VALUES (@issuedby, @issuedtime, @target, @bantype, @banlength, @processed, @processedtime, @comment);";
MySqlCommand command = new MySqlCommand(query, connection);
command.Parameters.AddWithValue("@issuedby", entry.issuedby);
command.Parameters.AddWithValue("@issuedtime", entry.issuedtime);
command.Parameters.AddWithValue("@target", entry.target);
command.Parameters.AddWithValue("@bantype", entry.bantype);
command.Parameters.AddWithValue("@banlength", entry.banlength);
command.Parameters.AddWithValue("@processed", entry.processed);
command.Parameters.AddWithValue("@processedtime", entry.processedtime);
command.Parameters.AddWithValue("@comment", entry.comment);
command.ExecuteNonQuery();
}
public static List<WavebanEntry> GetWavebans()
{
List<WavebanEntry> ret = new List<WavebanEntry>();
string query = "SELECT * FROM wavebans;";
MySqlCommand command = new MySqlCommand(query, connection);
command.ExecuteNonQuery();
MySqlDataReader commandreader = command.ExecuteReader();
while (commandreader.Read())
{
WavebanEntry entry = new WavebanEntry(
Convert.ToInt32(commandreader["issuedby"]),
Convert.ToInt64(commandreader["issuedtime"]),
Convert.ToInt32(commandreader["target"]),
Convert.ToInt32(commandreader["bantype"]),
Convert.ToInt64(commandreader["banlength"]),
Convert.ToInt32(commandreader["processed"]),
Convert.ToInt64(commandreader["processedtime"]),
Convert.ToString(commandreader["comment"]));
ret.Add(entry);
}
commandreader.Close();
return ret;
}
