public string GetBrugerById(string id)
{
string sql = "select * from Bruger " +
$"where Bruger_Id = {id}";
var brugerReturn = new Bruger();
using (SqlConnection databaseConnection = new SqlConnection(connection))
{
databaseConnection.Open();
using (SqlCommand selectCommand = new SqlCommand(sql, databaseConnection))
{
using (SqlDataReader reader = selectCommand.ExecuteReader())
{
while (reader.Read())
{
string ID = reader.GetString(0);
string brugernavn = reader.GetString(1);
string description = reader.GetString(2);
int wins = reader.GetInt32(3);
int loses = reader.GetInt32(4);
int ai_wins = reader.GetInt32(5);
int ai_loses = reader.GetInt32(6);
var bruger = new Bruger()
{
Id = ID,
Brugernavn = brugernavn,
Description = description,
Wins = wins,
Loses = loses,
AI_Wins = ai_wins,
AI_Loses = ai_loses,
};
brugerReturn = bruger;
}
}
}
}
if (brugerReturn.Wins > 0 && brugerReturn.Wins < 5)
{
var updateBruger = $"UPDATE Achievement SET FirstWin = 'Unlocked' WHERE Bruger_Id={brugerReturn.Id};";
SqlConnection connect = new SqlConnection(connection);
using (SqlCommand insertCommand = new SqlCommand(updateBruger, connect))
{
connect.Open();
insertCommand.ExecuteNonQuery();
}
}
if (brugerReturn.Wins >= 5 && brugerReturn.Wins < 10)
{
var updateBruger = $"UPDATE Achievement SET FirstWin = 'Unlocked', FiveWins = 'Unlocked' WHERE Bruger_Id={brugerReturn.Id};";
SqlConnection connect = new SqlConnection(connection);
using (SqlCommand insertCommand = new SqlCommand(updateBruger, connect))
{
connect.Open();
insertCommand.ExecuteNonQuery();
}
}
if (brugerReturn.Wins >= 10 && brugerReturn.Wins < 20)
{
var updateBruger = $"UPDATE Achievement SET FirstWin = 'Unlocked', FiveWins = 'Unlocked', TenWins = 'Unlocked' WHERE Bruger_Id={brugerReturn.Id};";
SqlConnection connect = new SqlConnection(connection);
using (SqlCommand insertCommand = new SqlCommand(updateBruger, connect))
{
connect.Open();
insertCommand.ExecuteNonQuery();
}
}
if (brugerReturn.Wins >= 20)
{
var updateBruger = $"UPDATE Achievement SET FirstWin = 'Unlocked', FiveWins = 'Unlocked', TenWins = 'Unlocked', TwentyWins = 'Unlocked' WHERE Bruger_Id={brugerReturn.Id};";
SqlConnection connect = new SqlConnection(connection);
using (SqlCommand insertCommand = new SqlCommand(updateBruger, connect))
{
connect.Open();
insertCommand.ExecuteNonQuery();
}
}
if (brugerReturn.AI_Wins > 0 && brugerReturn.AI_Wins < 5)
{
var updateBruger = $"UPDATE Achievement SET AIFirstWin = 'Unlocked' WHERE Bruger_Id={brugerReturn.Id};";
SqlConnection connect = new SqlConnection(connection);
using (SqlCommand insertCommand = new SqlCommand(updateBruger, connect))
{
connect.Open();
insertCommand.ExecuteNonQuery();
}
}
if (brugerReturn.AI_Wins >= 5 && brugerReturn.AI_Wins < 10)
{
var updateBruger = $"UPDATE Achievement SET AIFirstWin = 'Unlocked', AIFiveWins = 'Unlocked' WHERE Bruger_Id={brugerReturn.Id};";
SqlConnection connect = new SqlConnection(connection);
using (SqlCommand insertCommand = new SqlCommand(updateBruger, connect))
{
connect.Open();
insertCommand.ExecuteNonQuery();
}
}
if (brugerReturn.AI_Wins >= 10 && brugerReturn.AI_Wins < 20)
{
var updateBruger = $"UPDATE Achievement SET AIFirstWin = 'Unlocked', AIFiveWins = 'Unlocked', AITenWins = 'Unlocked' WHERE Bruger_Id={brugerReturn.Id};";
SqlConnection connect = new SqlConnection(connection);
using (SqlCommand insertCommand = new SqlCommand(updateBruger, connect))
{
connect.Open();
insertCommand.ExecuteNonQuery();
}
}
if (brugerReturn.AI_Wins >= 20)
{
var updateBruger = $"UPDATE Achievement SET AIFirstWin = 'Unlocked', AIFiveWins = 'Unlocked', AITenWins = 'Unlocked', AITwentyWins = 'Unlocked' WHERE Bruger_Id={brugerReturn.Id};";
SqlConnection connect = new SqlConnection(connection);
using (SqlCommand insertCommand = new SqlCommand(updateBruger, connect))
{
connect.Open();
insertCommand.ExecuteNonQuery();
}
}
return(brugerReturn.ToString());
}
