// POST api/<controller>
public string Post([FromBody] createGame value)
{
_conn = new SqlConnection("data source=DESKTOP-M8A87VO;Initial catalog=Gaming; user id= gamingapi; password=frederik0608;");
var query = "insert into Games (game_name,game_publisher,PEGI,game_developer,devices,genre,release_date) values(@game_name,@game_publisher,@PEGI,@game_developer,@devices,@genre,@release_date)";
SqlCommand insertcommand = new SqlCommand(query, _conn);
insertcommand.Parameters.AddWithValue("@game_name", value.game_name);
insertcommand.Parameters.AddWithValue("@game_publisher", value.game_publisher);
insertcommand.Parameters.AddWithValue("@PEGI", value.PEGI);
insertcommand.Parameters.AddWithValue("@game_developer", value.game_developer);
insertcommand.Parameters.AddWithValue("@devices", value.devices);
insertcommand.Parameters.AddWithValue("@genre", value.genre);
insertcommand.Parameters.AddWithValue("@release_date", value.release_date);
_conn.Open();
//her tager den i modnogle elementer, ude fra og indsætter dem på de plader i databasen, som stemmer over ens med det den har fået af vide de er
int result = insertcommand.ExecuteNonQuery();
if (result > 0)
{
return("true");
}
else
{
return("false");
}
}
// PUT api/<controller>/5
public string Put(int id, [FromBody] createGame value)
{
_conn = new SqlConnection("data source=DESKTOP-M8A87VO;Initial catalog=Gaming; user id= gamingapi; password=frederik0608;");
var query = "update Games set game_name=@game_name,game_publisher=@game_publisher,PEGI=@PEGI,game_developer=@game_developer,genre=@genre,release_date=@release_date where game_id=" + id;
SqlCommand insertcommand = new SqlCommand(query, _conn);
insertcommand.Parameters.AddWithValue("@game_name", value.game_name);
insertcommand.Parameters.AddWithValue("@game_publisher", value.game_publisher);
insertcommand.Parameters.AddWithValue("@PEGI", value.PEGI);
insertcommand.Parameters.AddWithValue("@game_developer", value.game_developer);
insertcommand.Parameters.AddWithValue("@genre", value.genre);
insertcommand.Parameters.AddWithValue("@release_date", value.release_date);
//dette er næsten det samme med at den modtager værdiger ude fra usern og der med kan putte det ind på et allrede Extiterne table i databasen
_conn.Open();
int result = insertcommand.ExecuteNonQuery();
if (result > 0)
{
return("true");
}
else
{
return("false");
}
}