//Update status contest when contest have run public bool CheckRunContestbyID(Contest Contest) { string query = "UPDATE [Contest]" + " SET [Run] = '" + Contest.Run_I+ "'" + " WHERE [Contest_ID] = '" + Contest.IDContest + "'"; return DA.UpdateDatabase(query); }
//Insert Contest public bool AddContest(Contest Contest) { string query = "INSERT INTO [Contest]" +"([Round_ID],[Contest_Name],[Bonus],[Request_Time],[Challenge_Score],[Number_Challenge]," +"[Time_show_Anwer],[Time_show_Question],[Time_of_True],[Time_of_False],[EndContest],[Run])" + " VALUES ('" + Contest.IDRound + "','" + Contest.NameContest.Replace("'", "''") + "','" + Contest.Bonus + "'," + "'" + Contest.TimeSupport + "','" + Contest.ChallengceScore + "','" + Contest.NumberChallenge + "'," + "'" + Contest.TimeShowAnswer + "','" + Contest.TimeShowQuestion + "','" + Contest.TimesTrue + "','" + Contest.TimesFalse + "','" + Contest.EndContest + "','" + Contest.Run_I + "')"; if (ExistContest(Contest) == true) { return false; } else { return DA.InsertDatabase(query); } }
//Edit Contest public bool EditContestbyID(Contest Contest) { string query = "UPDATE [Contest]" + " SET [Round_ID] = '" + Contest.IDRound + "',[Contest_Name] = '" + Contest.NameContest.Replace("'", "''") + "'" + ",[Bonus]='" + Contest.Bonus + "',[Request_Time]='" + Contest.TimeSupport + "'" + ",[Challenge_Score] = '" + Contest.ChallengceScore + "', [Number_Challenge] = '" + Contest.NumberChallenge + "'" + ",[Time_show_Anwer] = '" + Contest.TimeShowAnswer + "', [Time_show_Question] = '" + Contest.TimeShowQuestion + "'" + ",[Time_of_True] = '" + Contest.TimesTrue + "', [Time_of_False] = '" + Contest.TimesFalse + "'" + " WHERE [Contest_ID] = '" + Contest.IDContest + "'"; if (EditExistContest(Contest) == true) { return false; } else { return DA.UpdateDatabase(query); } }
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); } } }
//Check Edit Contest Exist public bool EditExistContest(Contest Contest) { string query = "SELECT [Contest_ID],[Round_ID],[Contest_Name],[Bonus],[Request_Time],[Challenge_Score],[Number_Challenge]" + ",[Time_show_Anwer],[Time_show_Question],[Time_of_True],[Time_of_False]" + " FROM [Contest]"; DataTable dt = DA.SelectDatabase(query); int i = 0; if (dt != null) { foreach (DataRow item in dt.Rows) { if (Convert.ToInt32(item["Round_ID"]) == Contest.IDRound && item["Contest_Name"].ToString().ToUpper() == Contest.NameContest.ToUpper() && Convert.ToInt32(item["Contest_ID"])!=Contest.IDContest) { i++; } } } if (i == 0) { return false; } else { return true; } }
//Delete Contest public bool DeleteContestbyID(Contest Contest) { string query = "DELETE FROM [Contest]" + " WHERE [Contest_ID] = '" + Contest.IDContest + "'"; return DA.DeleteDatabase(query); }
//Get round by id contest public List<Contest> GetRoundByIDContest(Contest contest) { List<Contest> ContestList = new List<Contest>(); string query = "SELECT c.[Contest_ID],c.[Round_ID],c.[Contest_Name],c.[Bonus],c.[Request_Time],c.[Challenge_Score],c.[Number_Challenge]" + ",c.[Time_show_Anwer],c.[Time_show_Question],c.[Time_of_True],c.[Time_of_False], r.[Round_Name]" + " FROM [Contest] c" + " INNER JOIN Round r ON r.Round_ID = c.Round_ID" + " WHERE c.[Contest_ID] = '" + contest.IDContest + "'"; DataTable dt = DA.SelectDatabase(query); //int i = 0; if (dt != null) { foreach (DataRow item in dt.Rows) { Contest Contest = new Contest(); Contest.IDContest = Convert.ToInt32(item["Contest_ID"].ToString()); Contest.IDRound = Convert.ToInt32(item["Round_ID"].ToString()); Contest.NameContest = (item["Contest_Name"]).ToString(); Contest.Bonus = Convert.ToInt32(item["Bonus"].ToString()); Contest.TimeSupport = Convert.ToInt32(item["Request_Time"].ToString()); Contest.ChallengceScore = Convert.ToInt32(item["Challenge_Score"].ToString()); Contest.NumberChallenge = Convert.ToInt32(item["Number_Challenge"].ToString()); Contest.TimeShowAnswer = Convert.ToInt32(item["Time_show_Anwer"].ToString()); Contest.TimeShowQuestion = Convert.ToInt32(item["Time_show_Question"].ToString()); Contest.TimesTrue = Convert.ToInt32(item["Time_of_True"].ToString()); Contest.TimesFalse = Convert.ToInt32(item["Time_of_False"].ToString()); Contest.Round.NameRound = (item["Round_Name"].ToString()); ContestList.Add(Contest); } } return ContestList; }
//Get contest to run game public List<Contest> GetContestByID(Contest contest) { List<Contest> ContestList = new List<Contest>(); string query = "SELECT c.[Contest_ID],c.[Round_ID],c.[Contest_Name],c.[Bonus],c.[Request_Time],c.[Challenge_Score],c.[Number_Challenge]" + ",c.[Time_show_Anwer],c.[Time_show_Question],c.[Time_of_True],c.[Time_of_False],c.[Run]" //+ ",ph.[Phase_Name],ph.[Phase_ID],ph.[Phase_Time],ph.[Phase_Score],ph.[Sequence]" //+ ",pl.[Player_Name],pl.[Player_ID],pl.[Color],pl.[Player_Score],pl.[Player_Sequence]" + " FROM [Contest] c" //+ " INNER JOIN Player pl ON pl.Contest_ID = c.Contest_ID" //+ " INNER JOIN Phase ph ON ph.Contest_ID = c.Contest_ID" + " WHERE c.[Contest_ID] = '" + contest.IDContest + "'"; DataTable dt = DA.SelectDatabase(query); //int i = 0; if (dt != null) { foreach (DataRow item in dt.Rows) { Contest Contest = new Contest(); Contest.IDContest = Convert.ToInt32(item["Contest_ID"].ToString()); Contest.IDRound = Convert.ToInt32(item["Round_ID"].ToString()); Contest.NameContest = (item["Contest_Name"]).ToString(); Contest.Bonus = Convert.ToInt32(item["Bonus"].ToString()); Contest.TimeSupport = Convert.ToInt32(item["Request_Time"].ToString()); Contest.ChallengceScore = Convert.ToInt32(item["Challenge_Score"].ToString()); Contest.NumberChallenge = Convert.ToInt32(item["Number_Challenge"].ToString()); Contest.TimeShowAnswer = Convert.ToInt32(item["Time_show_Anwer"].ToString()); Contest.TimeShowQuestion = Convert.ToInt32(item["Time_show_Question"].ToString()); Contest.TimesTrue = Convert.ToInt32(item["Time_of_True"].ToString()); Contest.TimesFalse = Convert.ToInt32(item["Time_of_False"].ToString()); Contest.Run = (bool)(item["Run"]); //Player //Contest.Player.PlayerName = (item["Player_Name"].ToString()); //Contest.Player.PlayerScore = Convert.ToInt32( (item["Player_Score"].ToString())); //Contest.Player.Sequence = Convert.ToInt32((item["Player_Sequence"].ToString())); ////Contest.Player.IDPlayer = Convert.ToInt32((item["Player_ID"].ToString())); ////Contest.Player.PlayerName = (item["Player_Name"].ToString()); //Contest.PlayerList.Add(Contest.Player); ContestList.Add(Contest); //i++; } } return ContestList; }
//select Contest table public List<Contest> GetContest() { List<Contest> ContestList = new List<Contest>(); string query = "SELECT [Contest_ID],[Round_ID],[Contest_Name],[Bonus],[Request_Time],[Challenge_Score],[Number_Challenge]" + ",[Time_show_Anwer],[Time_show_Question],[Time_of_True],[Time_of_False]" + " FROM [Contest]"; DataTable dt = DA.SelectDatabase(query); //int i = 1; if (dt!= null) { foreach (DataRow item in dt.Rows) { Contest Contest = new Contest(); Contest.IDContest = Convert.ToInt32(item["Contest_ID"].ToString()); Contest.IDRound = Convert.ToInt32(item["Round_ID"].ToString()); Contest.NameContest = (item["Contest_Name"]).ToString(); Contest.Bonus = Convert.ToInt32(item["Bonus"].ToString()); Contest.TimeSupport = Convert.ToInt32(item["Request_Time"].ToString()); Contest.ChallengceScore = Convert.ToInt32(item["Challenge_Score"].ToString()); Contest.NumberChallenge = Convert.ToInt32(item["Number_Challenge"].ToString()); Contest.TimeShowAnswer = Convert.ToInt32(item["Time_show_Anwer"].ToString()); Contest.TimeShowQuestion = Convert.ToInt32(item["Time_show_Question"].ToString()); Contest.TimesTrue = Convert.ToInt32(item["Time_of_True"].ToString()); Contest.TimesFalse= Convert.ToInt32(item["Time_of_False"].ToString()); ContestList.Add(Contest); //i++; } } return ContestList; }
//Get competition/round/contest public List<Contest> GetAllSetup() { List<Contest> ContestList = new List<Contest>(); string query = "SELECT c.[Contest_ID],c.[Round_ID],c.[Contest_Name],c.[Bonus],c.[Request_Time],c.[Challenge_Score],c.[Number_Challenge]" + ",c.[Time_show_Anwer],c.[Time_show_Question],c.[Time_of_True],c.[Time_of_False]" + ",r.[Round_Name],n.[Competition_Name],r.[Competition_ID], c.[EndContest],c.[Run]" + " FROM [Contest] c" + " INNER JOIN [Round] r ON r.[Round_ID] = c.[Round_ID]" + " INNER JOIN [Competition] n ON n.[Competition_ID] = r.[Competition_ID]"; DataTable dt = DA.SelectDatabase(query); //int i = 1; if (dt != null) { foreach (DataRow item in dt.Rows) { Contest Contest = new Contest(); Contest.IDContest = Convert.ToInt32(item["Contest_ID"].ToString()); Contest.IDRound = Convert.ToInt32(item["Round_ID"].ToString()); Contest.NameContest = (item["Contest_Name"]).ToString(); Contest.Bonus = Convert.ToInt32(item["Bonus"].ToString()); Contest.TimeSupport = Convert.ToInt32(item["Request_Time"].ToString()); Contest.ChallengceScore = Convert.ToInt32(item["Challenge_Score"].ToString()); Contest.NumberChallenge = Convert.ToInt32(item["Number_Challenge"].ToString()); Contest.TimeShowAnswer = Convert.ToInt32(item["Time_show_Anwer"].ToString()); Contest.TimeShowQuestion = Convert.ToInt32(item["Time_show_Question"].ToString()); Contest.TimesTrue = Convert.ToInt32(item["Time_of_True"].ToString()); Contest.Status = (bool)item["EndContest"]; Contest.Run = (bool)(item["Run"]); //round Contest.TimesFalse = Convert.ToInt32(item["Time_of_False"].ToString()); Contest.Round.IDRound = Convert.ToInt32(item["Round_ID"].ToString()); Contest.Round.IDCompetition = Convert.ToInt32(item["Competition_ID"].ToString()); Contest.Round.NameRound = (item["Round_Name"]).ToString(); Contest.Competition.NameCompetition = (item["Competition_Name"]).ToString(); ContestList.Add(Contest); //i++; } } return ContestList; }
//Update status contest when contest have run public bool EditStatusContestbyID(Contest Contest) { string query = "UPDATE [Contest]" + " SET [EndContest] = '" + Contest.EndContest + "'" + " WHERE [Contest_ID] = '" + Contest.IDContest + "'"; return DA.UpdateDatabase(query); }
//Update contest by id public bool EditGeneralSetting(Contest Contest) { string query = "UPDATE [Contest]" + " SET [Round_ID] = '" + Contest.IDRound + "',[Contest_Name] = '" + Contest.NameContest.Replace("'", "''") + "'" + ",[Bonus]='" + Contest.Bonus + "'" + ",[Time_show_Anwer] = '" + Contest.TimeShowAnswer + "', [Time_show_Question] = '" + Contest.TimeShowQuestion + "'" + ",[Time_of_True] = '" + Contest.TimesTrue + "', [Time_of_False] = '" + Contest.TimesFalse + "'" + " WHERE [Contest_ID] = '" + Contest.IDContest + "'"; if (EditExistContest(Contest) == true) { return false; } else { return DA.UpdateDatabase(query); } }