public static int InsertResultItem(Simulation.GameRecord record, SQLiteCommand command) { string tableStr = $"Tbl{record.holeUniquePrime}"; command.CommandText = $"SELECT * FROM {tableStr} where Flop = {record.flopUniquePrime}"; SQLiteDataReader dr = command.ExecuteReader(); if (record.winFlag == 1) { // read integer in Wins column dr.Read(); long updatedWinCount = dr.GetInt64(1) + 1; // update integer in Wins column dr.Close(); command.CommandText = $"UPDATE {tableStr} SET W = {updatedWinCount} WHERE Flop = {record.flopUniquePrime};"; } else if (record.winFlag == 0) { // read integer in Losses column dr.Read(); long updatedLossCount = dr.GetInt64(2) + 1; // update integer in Losses column dr.Close(); command.CommandText = $"UPDATE {tableStr} SET L = {updatedLossCount} WHERE Flop = {record.flopUniquePrime};"; } return(command.ExecuteNonQuery()); }
public static int InsertResultItem(Simulation.GameRecord record, SQLiteCommand command) { command.Parameters.AddWithValue("@hole1", ""); command.Parameters.AddWithValue("@hole2", ""); command.Parameters.AddWithValue("@flop1", ""); command.Parameters.AddWithValue("@flop2", ""); command.Parameters.AddWithValue("@flop3", ""); command.Parameters.AddWithValue("@win_flag", ""); command.CommandText = "INSERT INTO PlayerHandsTable " + "(Hole1, Hole2, Flop1, Flop2, Flop3, Winflag) " + "VALUES (@hole1, @hole2, @flop1,@flop2, @flop3, @win_flag)"; command.Parameters["@hole1"].Value = Program.card_to_int_dict[record.hole1.ToString()]; command.Parameters["@hole2"].Value = Program.card_to_int_dict[record.hole2.ToString()]; command.Parameters["@flop1"].Value = Program.card_to_int_dict[record.flop1.ToString()]; command.Parameters["@flop2"].Value = Program.card_to_int_dict[record.flop2.ToString()]; command.Parameters["@flop3"].Value = Program.card_to_int_dict[record.flop3.ToString()]; command.Parameters["@win_flag"].Value = record.winFlag; return(command.ExecuteNonQuery()); }