Пример #1
0
        private void btnInstall_Click(object sender, EventArgs e)
        {
            DialogResult dialogResult = MessageBox.Show("Confirm Payment?", "ATTENTION", MessageBoxButtons.YesNo);

            if (dialogResult == DialogResult.Yes)
            {
                //compra
                if (lblOwned.Text != "Owned")
                {
                    int    i        = lbGames.SelectedIndex;
                    string gameName = storeGames[i].GetName();

                    DBSteamDataSet db = new DBSteamDataSet();
                    DBSteamDataSetTableAdapters.GameOfLibraryTableAdapter GameOfLibraryTableAdapter = new DBSteamDataSetTableAdapters.GameOfLibraryTableAdapter();

                    DBSteamDataSet.GameOfLibraryRow newGameOfLibraryRow = db.GameOfLibrary.NewGameOfLibraryRow();


                    DBSteamDataSetTableAdapters.AchievementOfLibraryTableAdapter AchievementOfLibraryTableAdapter = new DBSteamDataSetTableAdapters.AchievementOfLibraryTableAdapter();

                    DBSteamDataSet.GameOfLibraryRow newAchievementOfLibraryRow = db.GameOfLibrary.NewGameOfLibraryRow();
                    GameOfLibraryTableAdapter.Insert(0, userID, storeGames[i].getGameID());

                    int achID;
                    int gameOfLibraryID = 0;
                    int j = 0;

                    SqlDataReader MineReader = DatabaseAccess.getDataFromDB("SELECT ID FROM [GameOfLibrary] WHERE userID ='" + Convert.ToString(userID) + "' AND gameID = '" + storeGames[i].getGameID() + "'");
                    if (MineReader.Read())
                    {
                        gameOfLibraryID = Convert.ToInt32(MineReader["ID"].ToString());
                    }

                    while (true)
                    {
                        try
                        {
                            achID = storeGames[i].achievementsvector[j].ID;
                            AchievementOfLibraryTableAdapter.Insert(gameOfLibraryID, achID, 0);
                            j++;
                        }
                        catch
                        {
                            break;
                        }
                    }

                    MessageBox.Show("Sale succeeded");
                    this.Close();
                }
                else
                {
                    MessageBox.Show("You already have the selected game");
                }
            }
            else
            {
                MessageBox.Show("Sale cancelled");
            }
        }
Пример #2
0
        private void btnInstall_Click(object sender, EventArgs e)
        {
            DialogResult dialogResult = MessageBox.Show("Confirm Payment?", "ATTENTION", MessageBoxButtons.YesNo);
            if (dialogResult == DialogResult.Yes)
            {
                //compra
                if (lblOwned.Text != "Owned")
                {
                    int i = lbGames.SelectedIndex;
                    string gameName = storeGames[i].GetName();

                    DBSteamDataSet db = new DBSteamDataSet();
                    DBSteamDataSetTableAdapters.GameOfLibraryTableAdapter GameOfLibraryTableAdapter = new DBSteamDataSetTableAdapters.GameOfLibraryTableAdapter();

                    DBSteamDataSet.GameOfLibraryRow newGameOfLibraryRow = db.GameOfLibrary.NewGameOfLibraryRow();

                    DBSteamDataSetTableAdapters.AchievementOfLibraryTableAdapter AchievementOfLibraryTableAdapter = new DBSteamDataSetTableAdapters.AchievementOfLibraryTableAdapter();

                    DBSteamDataSet.GameOfLibraryRow newAchievementOfLibraryRow = db.GameOfLibrary.NewGameOfLibraryRow();
                    GameOfLibraryTableAdapter.Insert(0, userID, storeGames[i].getGameID());

                    int achID;
                    int gameOfLibraryID = 0;
                    int j = 0;

                    SqlDataReader MineReader = DatabaseAccess.getDataFromDB("SELECT ID FROM [GameOfLibrary] WHERE userID ='" + Convert.ToString(userID) + "' AND gameID = '" + storeGames[i].getGameID() + "'");
                    if (MineReader.Read())
                    {
                        gameOfLibraryID = Convert.ToInt32(MineReader["ID"].ToString());
                    }

                    while (true)
                        try
                        {
                            achID = storeGames[i].achievementsvector[j].ID;
                            AchievementOfLibraryTableAdapter.Insert(gameOfLibraryID, achID, 0);
                            j++;
                        }
                        catch
                        {
                            break;
                        }

                    MessageBox.Show("Sale succeeded");
                    this.Close();
                }
                else
                    MessageBox.Show("You already have the selected game");

            }
            else
            {
                MessageBox.Show("Sale cancelled");
            }
        }