Exemplo n.º 1
0
        //Method for deleting from database
        public bool Delete(Boardgame p)
        {
            using (SqlConnection con = new SqlConnection(DB.connectionString))
            {
                bool isSuccess = false;

                try
                {
                    string sql = "DELETE FROM Game_Library WHERE Boardgame_Id = @Boardgame_Id";

                    SqlCommand cmd = new SqlCommand(sql, con);
                    cmd.Parameters.AddWithValue("Boardgame_Id", p.boardgameId);
                    con.Open();
                    int rows = cmd.ExecuteNonQuery();
                    if (rows > 0)
                    {
                        isSuccess = true;
                    }
                    else
                    {
                        isSuccess = false;
                    }
                }
                catch (Exception)
                {
                    throw;
                }
                return(isSuccess);
            }
        }
Exemplo n.º 2
0
        //Method to insert to the database
        public bool Insert(Boardgame p)
        {
            using (SqlConnection con = new SqlConnection(DB.connectionString))
            {
                bool isSuccess = false;

                try
                {
                    //Query to insert to the database
                    string     sql = "INSERT INTO Game_Library (Boardgame_Name, Player_Count, Audience, Game_Time, Distributor, GameTag) VALUES (@Boardgame_Name, @Player_Count, @Audience, @Game_Time, @Distributor, @GameTag)";
                    SqlCommand cmd = new SqlCommand(sql, con);
                    //Parameter to add data
                    cmd.Parameters.AddWithValue("@Boardgame_Name, ", p.boardgameName);
                    cmd.Parameters.AddWithValue("@Player_Count, ", p.playerCount);
                    cmd.Parameters.AddWithValue("@Audience, ", p.audience);
                    cmd.Parameters.AddWithValue("@Game_Time, ", p.gameTime);
                    cmd.Parameters.AddWithValue("@Distributor, ", p.distributor);
                    cmd.Parameters.AddWithValue("@GameTag, ", p.gameTag);

                    con.Open();
                    int rows = cmd.ExecuteNonQuery();
                    if (rows > 0)
                    {
                        isSuccess = true;
                    }
                    else
                    {
                        isSuccess = false;
                    }
                }
                catch (Exception)
                {
                    throw;
                }
                finally
                {
                    con.Close();
                }
                return(isSuccess);
            }
        }
Exemplo n.º 3
0
        //Method to update the database
        public bool Update(Boardgame p)
        {
            using (SqlConnection con = new SqlConnection(DB.connectionString))
            {
                bool isSuccess = false;

                try
                {
                    string     sql = "UPDATE Game_Library SET Boardgame_Name = @Boardgame_Name, Player_Count = @Player_Count, Audience = @Audience, Game_Time = @Game_Time, Distributor = @Distributor, GameTag = @GameTag WHERE Boardgame_Id = @Boardgame_Id";
                    SqlCommand cmd = new SqlCommand(sql, con);

                    cmd.Parameters.AddWithValue("@Boardgame_Name, ", p.boardgameName);
                    cmd.Parameters.AddWithValue("@Player_Count, ", p.playerCount);
                    cmd.Parameters.AddWithValue("@Audience, ", p.audience);
                    cmd.Parameters.AddWithValue("@Game_Time, ", p.gameTime);
                    cmd.Parameters.AddWithValue("@Distributor, ", p.distributor);
                    cmd.Parameters.AddWithValue("@GameTag, ", p.gameTag);

                    con.Open();
                    int rows = cmd.ExecuteNonQuery();
                    if (rows > 0)
                    {
                        isSuccess = true;
                    }
                    else
                    {
                        isSuccess = false;
                    }
                }
                catch (Exception)
                {
                    throw;
                }
                finally
                {
                    con.Close();
                }
                return(isSuccess);
            }
        }
Exemplo n.º 4
0
        private void btnInsert_Click(object sender, RoutedEventArgs e)
        {
            Domain.Boardgame p = new Domain.Boardgame
            {
                boardgameName = txtBrætspil.Text,
                playerCount   = txtAntal.Text,
                audience      = txtAldersgruppe.Text,
                gameTime      = txtSpilletid.Text,
                distributor   = txtDistrubutør.Text,
                gameTag       = txtGenre.Text
            };

            bool success = p.Insert(p);

            if (success == true)
            {
                MessageBox.Show("Nyt brætspil er tilføjet");
            }
            else
            {
                MessageBox.Show("Brætspil blev ikke tilføjet");
            }
        }