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);
}
