public void add_or_update_computer_in_table(GameComputer computer)
{
if (!IsComputerInTable(computer)) {
add_computer_to_table(computer);
}
else
update_computer_in_table(computer);
}
private void update_computer_in_table(GameComputer computer)
{
ExecuteQuery(
@"UPDATE computers SET
client_version='" + computer.client_version +
"', last_used=NOW() WHERE computer_name='" + computer.name + "'");
}
private bool IsComputerInTable(GameComputer computer)
{
var dt = GetQueryResult(
"SELECT * FROM computers WHERE computer_name = '" + computer.name + "'");
if (dt.Rows.Count > 0)
return true;
return false;
}
private void add_computer_to_table(GameComputer computer)
{
ExecuteQuery(
"INSERT INTO computers(computer_name, client_version, last_used) " +
"VALUES ('" + computer.name + " ', '" + computer.client_version + "', NOW() )");
}
private bool IsComputerInTable(GameComputer computer)
{
var dt = GetQueryResult(
$"select * from computers where computer_name = '{computer.name}'");
return dt.Rows.Count > 0;
}
private void UpdateComputerInTable(GameComputer computer)
{
ExecuteQuery(
$"UPDATE computers SET " +
$"client_version='{computer.client_version}'" +
$", last_used=datetime('now') where computer_name='{computer.name}'");
}
private void add_computer_to_table(GameComputer computer)
{
ExecuteQuery(
"insert into computers(computer_name, client_version) " +
$"values ('{computer.name}', '{computer.client_version}' )");
}
