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); } }
public static int GetLastUnixTime() { string query = $"SELECT max(req_timestamp) FROM B_REQUESTS"; OracleDataReader dataReader = SQLExecutor.GetSQLResults(query); if (dataReader.GetValue(0) != DBNull.Value) { return(dataReader.GetInt32(0)); } else { return(0); } }
public static int GetCurrentSeason(int playListId) { string query = $"SELECT max(pst_season_number) FROM B_PLAYLIST_STATS WHERE pst_playList_Id = '{playListId}'"; OracleDataReader dataReader = SQLExecutor.GetSQLResults(query); if (dataReader.GetValue(0) != DBNull.Value) { return(dataReader.GetInt32(0)); } else { return(0); } }
public static int GetLatestMatchesCount(int playListId, int seasonNumber) { string query = $"SELECT max(pst_matches_played) FROM B_PLAYLIST_STATS WHERE pst_playList_Id = '{playListId}' AND pst_season_number = '{seasonNumber}'"; OracleDataReader dataReader = SQLExecutor.GetSQLResults(query); Int32 currentMatchCount; if (dataReader.GetValue(0) != DBNull.Value) { currentMatchCount = dataReader.GetInt32(0); } else { currentMatchCount = 0; } return(currentMatchCount); }
public void WritePlayListStatsToTable(int requestCode) { string executeStmt = $"INSERT INTO b_playlist_stats (PST_REQ_CODE,PST_SEASON_NUMBER,PST_PLAYLIST_ID," + $"PST_PLAYLIST_NAME,PST_MATCHES_PLAYED,PST_RANK_POINTS,PST_TIER,PST_DIVISION) VALUES" + $" (" + $"{requestCode}," + $"{seasonNumber}," + $"{playListId}," + $"'{playListName}'," + $"{matchesPlayed}," + $"{rankPoints}," + $"{tier}," + $"{division})"; int execute = SQLExecutor.ExecuteSQL(executeStmt); }