public void AddRankID(round round, Int64 id, judge_value value)
{
String judge_string = value == judge_value.A ? "a" : "b";
String query = String.Format("UPDATE rounds SET judge_{0}_ranks = {1} WHERE id = {2};", judge_string, id, round.id);
using (SQLiteCommand command = new SQLiteCommand(query, connection))
{
command.ExecuteNonQuery();
}
}
public void AddScore(round round, Int64 team_a_score, Int64 team_b_score, judge_value value)
{
String judge_string = value == judge_value.A ? "a" : "b";
String query = String.Format("UPDATE rounds SET judge_{0}_score_team_a = {1} WHERE id = {2}", judge_string, team_a_score, round.id);
using (SQLiteCommand command = new SQLiteCommand(query, connection))
{
command.ExecuteNonQuery();
}
String query2 = String.Format("UPDATE rounds SET judge_{0}_score_team_b = {1} WHERE id = {2}", judge_string, team_b_score, round.id);
using (SQLiteCommand command = new SQLiteCommand(query2, connection))
{
command.ExecuteNonQuery();
}
}
