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}' )"); }