private void Form1_Load(object sender, EventArgs e) { mm = new MatchListFromXML(); string url = "https://www.scorespro.com/rss2/live-soccer.xml"; mm.path = path; Uri uri = new Uri(url); WebClient webClient = new WebClient(); try { webClient.DownloadFile(uri, mm.path); } catch (Exception ex) { Console.WriteLine("Error"); } mm.LoadData(); var dataArr = mm.Select(it => new DisplayMatch() { Id = it.ID, HomeTeamDisplay = it.HomeTeam.Name, AwayTeamDisplay = it.AwayTeam.Name, HomeScoreDisplay = it.Result.HomeScore, AwayScoreDisplay = it.Result.AwayScore }).ToArray(); dgMatches.DataSource = dataArr; }
static void Main(string[] args) { using (var sq = new SqlConnection()) { sq.ConnectionString = @"Server=.\SQLEXPRESS;Database=MyFootballManager;Trusted_Connection=True;"; sq.Open(); using (var cmd = sq.CreateCommand()) { cmd.CommandType = CommandType.Text; cmd.CommandText = "UPDATE [dbo].[Score] SET[HomeScore] = 71,[AwayScore] =41 WHERE id = 1"; cmd.ExecuteNonQuery(); } using (var cmd = sq.CreateCommand()) { cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT TOP (1000) [HomeScore],[AwayScore],[ID] FROM[MyFootballManager].[dbo].[Score]"; using (var rd = cmd.ExecuteReader()) { while (rd.Read()) { Score s = new Score(); s.AwayScore = int.Parse(rd["AwayScore"].ToString()); s.HomeScore = int.Parse(rd["HomeScore"].ToString()); Console.WriteLine(s.HomeScore + " " + s.AwayScore); } } } using (var cmd = sq.CreateCommand()) { cmd.CommandType = CommandType.Text; cmd.CommandText = @"SELECT TOP (1000) [ID],[DateTIme],[ID_TeamHome],[ID_TeamAway] ,[ID_Score] FROM[MyFootballManager].[dbo].[Match] where id = 1"; using (var read = cmd.ExecuteReader()) { while (read.Read()) { Match m = new Match(); m.Date = DateTime.Parse(read["DateTime"].ToString()); Console.WriteLine(m.Date); } } } MatchListFromXML mm = new MatchListFromXML(); string url = "https://www.scorespro.com/rss2/live-soccer.xml"; mm.path = "..\\..\\..\\Data\\Data.txt"; Uri uri = new Uri(url); WebClient webClient = new WebClient(); try { webClient.DownloadFile(uri, mm.path); } catch (Exception ex) { Console.WriteLine("Error"); } mm.LoadData(); int id_var = 200; for (int i = 0; i < mm.Count; i++, id_var++) { using (var cmd = sq.CreateCommand()) { cmd.CommandType = CommandType.Text; cmd.CommandText = "INSERT INTO [dbo].[Score] ([HomeScore],[AwayScore],[ID]) VALUES ("; cmd.CommandText += mm[i].Result.HomeScore + ", " + mm[i].Result.AwayScore + ", " + id_var + ")"; Console.WriteLine(cmd.CommandText); cmd.ExecuteNonQuery(); } using (var cmd = sq.CreateCommand()) { cmd.CommandType = CommandType.Text; cmd.CommandText = "INSERT INTO [dbo].[Team] ([ID], [Name], [ChampionshipPoints], [GoalsScored])"; cmd.CommandText += "VALUES (" + id_var + ", '" + mm[i].AwayTeam.Name + "', " + mm[i].AwayTeam.ChampionshipPoints; cmd.CommandText += ", " + mm[i].HomeTeam.GoalsScored + ")"; Console.WriteLine(cmd.CommandText); cmd.ExecuteNonQuery(); } int id_var2 = 2 * id_var; using (var cmd = sq.CreateCommand()) { cmd.CommandType = CommandType.Text; cmd.CommandText = "INSERT INTO [dbo].[Team] ([ID], [Name], [ChampionshipPoints], [GoalsScored])"; cmd.CommandText += "VALUES (" + id_var2 + ", '" + mm[i].AwayTeam.Name + "', " + mm[i].AwayTeam.ChampionshipPoints; cmd.CommandText += ", " + mm[i].AwayTeam.GoalsScored + ")"; Console.WriteLine(cmd.CommandText); cmd.ExecuteNonQuery(); } using (var cmd = sq.CreateCommand()) { cmd.CommandType = CommandType.Text; cmd.CommandText = "INSERT INTO [dbo].[Match] ([ID], [DateTIme], [ID_TeamHome], [ID_TeamAway] ,[ID_Score]) "; cmd.CommandText += "VALUES (" + id_var + ", " + "25/10/2017" + ", " + id_var + ", " + id_var2 + ", " + id_var + ")"; Console.WriteLine(cmd.CommandText); cmd.ExecuteNonQuery(); } } } }
static void Main(string[] args) { //https://www.scorespro.com/rss2/live-soccer.xml var mm = new MatchListFromMemory(); var csvm = new MatchListFromCSV(); string fileType = null; bool xml = false; Console.WriteLine("Is the file on hard or internet?"); Console.WriteLine("Write 0 if on hard, 1 if on internet"); int input = ReadMyInt(); while ((input != 1) && (input != 0)) { Console.WriteLine("Invalid input: write 0 if on hard, 1 if on internet"); input = ReadMyInt(); } if (input == 1) { Console.WriteLine("Write the url:"); string stringUrl = Console.ReadLine(); int i = stringUrl.Length - 2; for (; i >= 0; i--) { if (stringUrl[i] == '.') { fileType = stringUrl.Substring(i + 1); break; } } if (fileType.Equals("xml")) { xml = true; } Uri uri = new Uri(stringUrl); WebClient webClient = new WebClient(); try { webClient.DownloadFile(uri, pathToXML); } catch (Exception e) { Console.WriteLine("Error encountered while trying to download the file"); } } if (xml) { MatchListFromXML mx = new MatchListFromXML(); mx.path = pathToCSV; mx.LoadData(); ShowMatchList(mx); ShowLeaderboard(mx); return; } csvm.path = pathToCSV; try { csvm.LoadData(); } catch (InvalidDataException e) { Console.WriteLine(e.Message); } ShowMatchList(csvm); }