//Check Player Exist
 //public bool ExistPlayer(Player Player)
 //{
 //    string query = "SELECT [Player_ID],[Player_Name]"
 //               + " FROM [Player]"
 //               + " WHERE [Player_Name] = '" + Player.PlayerName.ToUpper() + "'";
 //    DataTable dt = DA.SelectDatabase(query);
 //    if (dt.Rows.Count != 0)
 //    {
 //        return true;
 //    }
 //    else
 //    {
 //        return false;
 //    }
 //}
 //Edit Player
 public bool EditPlayerbyID(Player Player)
 {
     string query = "UPDATE [Player] SET "
                  + "[Contest_ID] ='" + Player.IDContest + "',[Player_Name] ='" + Player.PlayerName + "',[Player_Score] ='" + Player.PlayerScore + "',[Color] ='" + Player.Color + "',[Player_Sequence] ='" + Player.Sequence + "'"
                  + " WHERE Player_ID = '" + Player.IDPlayer + "'";
     return DA.UpdateDatabase(query);
 }
Exemple #2
0
 public Contest()
 {
     round = new Round();
     competition = new Competition();
     phase = new Phase();
     player = new Player();
     playerList = new List<Player>();
 }
        //Insert Player
        public bool AddPlayer(Player Player)
        {
            string query = "INSERT INTO [Player]([Contest_ID],[Player_Sequence],[Player_Name],[Player_Score],[Color])"
                           + " VALUES ('" + Player.IDContest + "','" + Player.Sequence + "','" + Player.PlayerName + "',"
                           + "'" + Player.PlayerScore + "','" + Player.Color + "')";

            if (DA.InsertDatabase(query))
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        //select Player table
        public List<Player> GetPlayer()
        {
            List<Player> PlayerList = new List<Player>();
            string query = "SELECT [Player_ID],[Contest_ID],[Player_Name],[Player_Score],[Color],[Player_Sequence]"
                        +  " FROM [Player]";
            DataTable dt = DA.SelectDatabase(query);
            //int i = 1;
            if (dt!= null)
            {
                foreach (DataRow item in dt.Rows)
                {
                    Player Player = new Player();
                    Player.IDPlayer = Convert.ToInt32(item["Player_ID"].ToString());
                    Player.IDContest = Convert.ToInt32(item["Contest_ID"].ToString());
                    Player.PlayerName = item["Player_Name"].ToString();
                    Player.PlayerScore = Convert.ToInt32(item["Player_Score"].ToString());
                    Player.Color = item["Color"].ToString();
                    Player.Sequence = Convert.ToInt32(item["Player_Sequence"].ToString());

                    PlayerList.Add(Player);
                    //i++;
                }
            }
            return PlayerList;
        }
 public bool DeletePlayerbyIDContest(Player Player)
 {
     string query = "DELETE FROM [Player]"
                  + " WHERE [Contest_ID] = '" + Player.IDContest + "'";
     return DA.DeleteDatabase(query);
 }
        // get player by id contest
        public List<Player> GetPlayerByIDContest(Player player)
        {
            List<Player> PlayerList = new List<Player>();
            string query = "SELECT pl.[Player_ID],pl.[Contest_ID],pl.[Player_Name],pl.[Player_Score],pl.[Color],pl.[Player_Sequence]"
                        + " FROM [Player]pl"
                        + " INNER JOIN Contest  c ON c.Contest_ID = pl.Contest_ID"
                        //+ " INNER JOIN Phase ph ON ph.Contest_ID = c.Contest_ID"
                        + " WHERE pl.[Contest_ID] = '" + player.IDContest + "' ORDER BY [Player_Sequence] ASC";
            //ORDER BY [Player_Sequence] ASC
            DataTable dt = DA.SelectDatabase(query);
            if (dt != null)
            {
                foreach (DataRow item in dt.Rows)
                {
                    Player Player = new Player();
                    Player.IDPlayer = Convert.ToInt32(item["Player_ID"].ToString());
                    Player.IDContest = Convert.ToInt32(item["Contest_ID"].ToString());
                    Player.PlayerName = item["Player_Name"].ToString();
                    Player.PlayerScore = Convert.ToInt32(item["Player_Score"].ToString());
                    Player.Color = item["Color"].ToString();
                    Player.Sequence = Convert.ToInt32(item["Player_Sequence"].ToString());

                    PlayerList.Add(Player);
                }
            }
            return PlayerList;
        }
        private void deleteSetupToolStripMenuItem_Click(object sender, EventArgs e)
        {
            DialogResult dialogResult = MessageBox.Show("Bạn muốn xóa cuộc thi này không?", "Xóa Thiết Đặt", MessageBoxButtons.YesNo);
            if (dialogResult == DialogResult.Yes)
            {
                Contest Contest = new Contest();
                Phase Phase = new Phase();
                Player Player = new Player();
                Record Record = new Record();

                ContestBL ContestBL = new ContestBL();
                PhaseBL PhaseBl = new PhaseBL();
                PlayerBL PlayerBL = new PlayerBL();
                PhaseQuestionBL PhaseQuestionBL = new PhaseQuestionBL();
                RecordBL RecordBL = new RecordBL();

                Contest.IDContest = Convert.ToInt32(lbl_IDContest.Text);
                Phase.IDContest = Convert.ToInt32(lbl_IDContest.Text);
                Player.IDContest = Convert.ToInt32(lbl_IDContest.Text);
                Record.IDContest = Convert.ToInt32(lbl_IDContest.Text);

                RecordBL.DeleteRecordByIDContest(Record);
                PhaseQuestionBL.DeletePhaseQuestionbyIDContest(Phase);
                PlayerBL.DeletePlayerbyIDContest(Player);
                PhaseBl.DeletePhasebyIDContest(Phase);
                ContestBL.DeleteContestbyID(Contest);
                LoadAll();

                EventHandler delete = onDelete;

                if (delete != null)
                {
                    MyEventArgs args = new MyEventArgs();
                    args.IDNewGame = iD_NewGame;
                    delete(this, args);
                }
            }
        }