public List <Teem> makeTeam_QueryBy_Continnent(int ContinnentArea) { // Done List <Teem> teems = new List <Teem>(); //SqlCommand command = new SqlCommand(Query + " where team = " + ContinnentArea.ToString(), makeConnection("open")); String GivenCommand = "select * from [team] where region in " + $"(select id_region from region where region.id_region = {ContinnentArea})"; SqlCommand command = new SqlCommand(GivenCommand, makeConnection("open")); SqlDataReader reader = command.ExecuteReader(); Console.WriteLine("Did come to here"); while (reader.Read()) { Teem teemObject = new Teem(); //teemObject.AddplayerToTeem(reader["playername"].ToString()); teemObject.teemindexing = (int)reader["id_team"]; teemObject.Coach = reader["coach"].ToString(); teemObject.CountryName = reader["name"].ToString(); teemObject.ContinentCode = ContinnentArea; teems.Add(teemObject); //Console.WriteLine(teem.ContinentCode.ToString()); } closeConnection(makeConnection("close")); foreach (var item in teems) { item.listOfPlayer = GetPlayerByTeem(item.teemindexing); } return(teems); }
public Teem startFinal(Teem teemA, Teem teemB) { match.TeemA = teemA; match.TeemB = teemB; match.who_Is_Winning(); return(match.Winner); }
//public List<String> getPlayer(String Query) //{ // List<String> tempReturn = new List<string>(); // SqlConnection connection1 = new SqlConnection(); // connection1.ConnectionString = path_connection; // connection1.Open(); // SqlCommand command = new SqlCommand(Query,connection1); // return tempReturn; //} /*GROUND: * */ public bool WriteMatchToDB(Teem teemA, Teem teemB, int stage = 0, int ground = 0, string sroce = "") { // this fuction write to Database which ref stage or ground if them are not 0 then it consider a legit match String GivenCommand = "INSERT INTO game(stage, ground, teamA, teamB, score) " + $"VALUES({stage},{ground}," + @"'" + $"{ teemA.CountryName}" + @"'" + "," + @"'" + $"{teemB.CountryName}" + @"'" + "," + @"'" + $"{sroce}" + @"'" + ")"; SqlCommand command = new SqlCommand(GivenCommand, makeConnection("open")); command.ExecuteNonQuery(); makeConnection("close"); return(true); }
private void RandomplayerGoal(Teem teem, int teemSroce) { // Distribute player Sroce by it teem sroce //Encapsulation method while (teemSroce > 0) { int _sroce = random.Next(1, teemSroce); int selected_player = random.Next(0, teem.listOfPlayer.Count); teem.listOfPlayer[selected_player]._Pesonalsroce = _sroce; teemSroce = teemSroce - _sroce; } }
public int writeResultToDatabase(Teem Winner, Teem Losser, int stage = 0, int ground = 0, string sroce = "") { DatabaseConnector database = new DatabaseConnector(); if (database.WriteMatchToDB(Winner, Losser, stage, ground, sroce)) { return(1); } else { return(0); } }
public void PlayoffStage(Teem teemA, Teem teemB, Teem teemC, Teem teemD) { Match match = new Match(); }