Beispiel #1
0
        public void WriteRequestToDatabase()
        {
            Dictionary <string, Dictionary <string, dynamic> > parameters = new Dictionary <string, Dictionary <string, dynamic> >();
            Dictionary <string, dynamic> intParameters    = new Dictionary <string, dynamic>();
            Dictionary <string, dynamic> stringParameters = new Dictionary <string, dynamic>();

            intParameters.Add("par_req_updated_at", updatedAt);
            intParameters.Add("par_req_next_update_at", nextUpdateAt);
            intParameters.Add("par_req_timestamp", timestamp);
            intParameters.Add("par_req_wins", wins);
            intParameters.Add("par_req_goals", goals);
            intParameters.Add("par_req_mvps", mvps);
            intParameters.Add("par_req_saves", saves);
            intParameters.Add("par_req_shots", shots);
            intParameters.Add("par_req_assits", assists);
            parameters.Add("int", intParameters);
            stringParameters.Add("par_req_playlist_type", updatedPlayList);
            parameters.Add("string", stringParameters);
            int req_code = SQLExecutor.CallPLSQLFunction("P_REQUESTS.INSERT_ROW", parameters);

            foreach (PlaylistStats playList in updatedPlayLists)
            {
                playList.WritePlayListStatsToTable(req_code);
            }
        }