public void AddSimonData(SimonORM simon) { connection.Open(); string commandText = @"INSERT INTO Simon (Increment_Level, Level_1_Fail, Level_1_Fail_Time, Level_2_Fail, Level_2_Fail_Time, Level_3_Fail, Level_3_Fail_Time, Color, Position, Start, Stop, GameId) VALUES (@Increment_Level, @Level_1_Fail, @Level_1_Fail_Time, @Level_2_Fail, @Level_2_Fail_Time, @Level_3_Fail, @Level_3_Fail_Time, @Color, @Position, @Start, @Stop, @GameId)"; SqlCeCommand command = new SqlCeCommand(commandText, connection); command.Parameters.AddWithValue("@Increment_Level", simon.IncrementLevel); command.Parameters.AddWithValue("@Level_1_Fail", simon.Level_1_Fail); command.Parameters.AddWithValue("@Level_1_Fail_Time", simon.Level_1_Fail_Time); command.Parameters.AddWithValue("@Level_2_Fail", simon.Level_2_Fail); command.Parameters.AddWithValue("@Level_2_Fail_Time", simon.Level_2_Fail_Time); command.Parameters.AddWithValue("@Level_3_Fail", simon.Level_3_Fail); command.Parameters.AddWithValue("@Level_3_Fail_Time", simon.Level_3_Fail_Time); command.Parameters.AddWithValue("@Color", simon.Color); command.Parameters.AddWithValue("@Position", simon.Position); command.Parameters.AddWithValue("@Start", simon.Start); command.Parameters.AddWithValue("@Stop", simon.Stop); command.Parameters.AddWithValue("@GameId", simon.GameId); command.ExecuteNonQuery(); connection.Close(); }
private void handleData(Dictionary<string, string> dictionary) { Console.WriteLine("Data parsed and receive succesful"); if (dictionary.ContainsKey("Game Type")) { string title = dictionary["Game Type"]; DBWrapper db = new DBWrapper(); switch (title) { case "!SAY": SimonORM sayData = new SimonORM(dictionary); db.AddSimonData(sayData); break; case "!MAZ": MazeORM mazData = new MazeORM(dictionary); db.AddMazeData(mazData); break; } } }