public async Task RegisterUserToDBAsync(User user)
{
SteamDataService SteamData = new SteamDataService();
SteamUserContainer SteamUser = new SteamUserContainer();
SteamGameContainer SteamGameList = new SteamGameContainer();
string steamUserID;
List <SteamGame> games;
SteamUser = await SteamData.GetSteamUser64IDAsync(user.username);
SteamGameList = await SteamData.GetUsersGames(SteamUser.response.steamID);
steamUserID = SteamUser.response.steamID;
games = SteamGameList.response.games;
cnn = new SqlConnection(connectionString);
cnn.Open();
SqlCommand cmd = new SqlCommand();
//AddUserCredentialsToTable(user, cmd);
//AddUserSteamIDToTable(user, steamUserID, cmd);
AddUserGameListToTable(games, steamUserID, cmd);
cnn.Close();
}
public async Task <List <SteamGame> > UpdateAndLoadUserSteamInfoAsync(User user)
{
SteamDataService SteamData = new SteamDataService();
SteamUserContainer SteamUser = new SteamUserContainer();
SteamGameContainer SteamGameList = new SteamGameContainer();
string steamUserID;
List <SteamGame> gamesFromAPI;
List <SteamGame> gamesFromDB;
//TODO: Put in check if cant get steam user id from username
//GET USER'S STEAM 64 ID FROM USERNAME
SteamUser = await SteamData.GetSteamUser64IDAsync(user.username);
steamUserID = SteamUser.response.steamID;
//STORE/UPDATE USER'S INFO IN DB
cnn = new SqlConnection(connectionString);
cnn.Open();
SqlCommand cmd = new SqlCommand();
AddUserSteamIDToTable(user, steamUserID, cmd);
cnn.Close();
try
{
//TODO: Put in check if cant get game list from Steam
//GET USER'S GAMES FROM API CALL
SteamGameList = await SteamData.GetUsersGames(steamUserID);
gamesFromAPI = SteamGameList.response.games;
//STORE/UPDATE GAMES IN DB
cnn = new SqlConnection(connectionString);
cnn.Open();
AddUserGameListToTable(gamesFromAPI, steamUserID, cmd);
cnn.Close();
}
catch (Exception e)
{
}
//GET GAMES FROM DB
gamesFromDB = GetUserSteamGameInfoFromDB(user);
return(gamesFromDB);
}
public async Task <List <SteamGame> > GetUserSteamGameInfoFromSteamAPI(User user)
{
SteamDataService SteamData = new SteamDataService();
SteamUserContainer SteamUser = new SteamUserContainer();
SteamGameContainer SteamGameList = new SteamGameContainer();
string steamUserID;
List <SteamGame> games;
SteamUser = await SteamData.GetSteamUser64IDAsync(user.username);
steamUserID = SteamUser.response.steamID;
SteamGameList = await SteamData.GetUsersGames(steamUserID);
games = SteamGameList.response.games;
return(games);
}
