using Live_Scoring_V1.Classes; using Newtonsoft.Json; using System; using System.Collections.Generic; using System.Data; using System.Diagnostics; using System.Linq; using System.Security.Cryptography; using System.Security.Policy; using System.Text; using System.Threading; using System.Threading.Tasks; using System.Windows; using System.Windows.Controls; using System.Windows.Controls.Primitives; using System.Windows.Data; using System.Windows.Documents; using System.Windows.Input; using System.Windows.Markup; using System.Windows.Media; using System.Windows.Media.Animation; using System.Windows.Media.Imaging; using System.Windows.Navigation; using System.Windows.Shapes; using System.Windows.Threading; using System.Xml.Linq; //check if there a hakftime value is specificed if not use 40mins as default namespace Live_Scoring_V1 { ///

/// Interaction logic for Scoring.xaml ///

public partial class Scoring : Page { //int timesec = 0; int timesecYellowCardTimer = 0; int timesecBloodTimer = 0; int timesecHIATimer = 0; List PushOnResume = new List(); List InjuryOnResume = new List(); List InjuryPermanentOnResume = new List(); List InjuryReverseOnResume = new List(); List allCards = new List(); List Events_Data = null; Fixtures Fixture_Data = null; List Team_Data = null; Score Score_Data; public int FID { get; set; } public Frame MainFrame; int Player_ID = 0; int Old_Player_ID = 0; int Subs = 0; int subs_off = 0; int TeamID = 0; int EventID = 0; int Side = 0; int Replacemant_ID = 0; int Old_Replacemant_ID = 0; string SquadName; string PlayerName; string ReplacementName; string EventName; string Commentary; int Group; int SID; int Session = 0; int USERID; int countTime = 300; Score scoreData = new Score(); //GAME GLOBAL VARIABELS int Game_status = 0; int Game_Paused = 0; int GAMESTARTED = 0; int set_half_time = 0; string Time = ""; DispatcherTimer ST = new DispatcherTimer(); Stopwatch sw = new Stopwatch(); DispatcherTimer dt_pt = new DispatcherTimer(); Stopwatch sw_pt = new Stopwatch(); DispatcherTimer dt_stop = new DispatcherTimer(); Stopwatch sw_stop = new Stopwatch(); DispatcherTimer dt_stop_dur = new DispatcherTimer(); Stopwatch sw_stop_dur = new Stopwatch(); string currentTime = string.Empty; string currentTime_pt = string.Empty; string currentTime_stop = string.Empty; string time_duration = "00:00"; string time_playing = "00:00"; string time_stopped = "00:00"; string CommentaryID = ""; Comments Commentry_Edit_Data = null; Events Events = new Events(); Window1 window = new Window1(); DispatcherTimer warningTime; bool performedCountDown = false; public Scoring(int FID = 0) { Loginn User_Logged = new Loginn(); USERID = User_Logged.IsLoggedIN_AlReady(); this.FID = FID; InitializeComponent(); GetFixture(); LoadCurrentYellowCards(); LoadCurrentRedCards(); ST.Tick += new EventHandler(dt_Tick); ST.Interval = new TimeSpan(0, 0, 0, 0, 1); dt_pt.Tick += new EventHandler(dt_Tick_pT); dt_pt.Interval = new TimeSpan(0, 0, 0, 0, 1); dt_stop.Tick += new EventHandler(dt_Tick_Stop); dt_stop.Interval = new TimeSpan(0, 0, 0, 0, 1); dt_stop_dur.Tick += new EventHandler(dt_Tick_Stop_dur); dt_stop_dur.Interval = new TimeSpan(0, 0, 0, 0, 1); GetSessionButtons(); Kickoff_HomeTeam.Text = Fixture_Data.HomeName; Kickoff_AwayTeam.Text = Fixture_Data.AwayName; //timesec = Fixture_Data.YellowCard_Counter * 60; timesecYellowCardTimer = Fixture_Data.YellowCardTimer * 60; timesecBloodTimer = Fixture_Data.BloodTimer * 60; timesecHIATimer = Fixture_Data.HIATimer * 60; //int a = timesec; int yct = timesecYellowCardTimer; int bt = timesecBloodTimer; int hiat = timesecHIATimer; //OnlineBtn = Online_BTN; //OnlineBtn_Text = Online_BTN_Text;*/ } private void ResetValues() { Away_Cancel.Visibility = Visibility.Hidden; Home_Blocker.Visibility = Visibility.Hidden; Home_Cancel.Visibility = Visibility.Hidden; Away_Blocker.Visibility = Visibility.Hidden; GetEvents(); Home_Events_Title.Text = "EVENTS"; Away_Events_Title.Text = "EVENTS"; Player_ID = 0; Replacemant_ID = 0; Subs = 0; TeamID = 0; EventID = 0; Side = 0; SquadName = ""; PlayerName = ""; ReplacementName = ""; Commentary = ""; EventName = ""; Group = 0; } public void GetEvents() { Fixtures fixture = new Fixtures(); StackPanel Home_Stack = new StackPanel(); Home_Scroller.Content = null; StackPanel Away_Stack = new StackPanel(); Away_Scroller.Content = null; Events Evts = new Events(); int Allow22Miter = Int32.Parse(Fixture_Data.Allow22MeterTry.ToString()); //MessageBox.Show(Fixture_Data.Allow22MeterTry.ToString()); Events_Data = Evts.GetEvents(Allow22Miter); foreach (Events Evt in Events_Data) { if (fixture.IsGamePaused(FID)) // Time off { string ColorCode = Convert.ToString(Evt.Color); Border grd = Avents_Button(0, Evt.CommName, ColorCode, Evt.CEID); Border grd2 = Avents_Button(1, Evt.CommName, ColorCode, Evt.CEID); Home_Stack.Children.Add(grd); Away_Stack.Children.Add(grd2); } else // Time On { if (Evt.CEID != 45 && Evt.CEID != 40) { string ColorCode = Convert.ToString(Evt.Color); Border grd = Avents_Button(0, Evt.CommName, ColorCode, Evt.CEID); Border grd2 = Avents_Button(1, Evt.CommName, ColorCode, Evt.CEID); Home_Stack.Children.Add(grd); Away_Stack.Children.Add(grd2); } } } Home_Scroller.Content = Home_Stack; Away_Scroller.Content = Away_Stack; } private void getCommentary() { StackPanel Home_Comment_Stack = new StackPanel(); StackPanel Home_Scores_Stack = new StackPanel(); StackPanel Home_Movements_Stack = new StackPanel(); StackPanel Home_Stoppages_Stack = new StackPanel(); Commentary_Scroller.Content = null; Scorers_Scroller.Content = null; Movements_Scroller.Content = null; Stoppages_Scroller.Content = null; List commentsList = Comments.GetCommentary(FID); int cc = 0; int cs = 0; int cm = 0; int cp = 0; foreach (Comments row in commentsList) { string bgc = ""; string bgs = ""; string bgm = ""; string bgp = ""; // Commentary Tab if (cc == 0) { cc = 1; bgc = "#ccc"; } else { cc = 0; bgc = "#fff"; } Grid GRDC = Commentary_line(bgc, row); Home_Comment_Stack.Children.Add(GRDC); // Scores Tab if (row.EventID == 2 || row.EventID == 3 || row.EventID == 4 || row.EventID == 5 || row.EventID == 6 || row.EventID == 7 || row.EventID == 9 || row.EventID == 10 || row.EventID == 53 || row.EventID == 56) { if (cs == 0) { cs = 1; bgs = "#ccc"; } else { cs = 0; bgs = "#fff"; } Grid GRDS = Commentary_line(bgs, row); GRDS.ColumnDefinitions.ElementAt(0).Width = new GridLength(50); GRDS.ColumnDefinitions.ElementAt(1).Width = new GridLength(160); GRDS.ColumnDefinitions.ElementAt(2).Width = new GridLength(220); GRDS.ColumnDefinitions.ElementAt(3).Width = new GridLength(370); GRDS.ColumnDefinitions.ElementAt(4).Width = new GridLength(0); GRDS.ColumnDefinitions.ElementAt(5).Width = new GridLength(0); GRDS.ColumnDefinitions.ElementAt(6).Width = new GridLength(80); Home_Scores_Stack.Children.Add(GRDS); } // Movements Tab if (row.EventID == 11 || row.EventID == 12 || row.EventID == 14 || row.EventID == 40 || row.EventID == 43 || row.EventID == 44 || row.EventID == 45 || row.EventID == 46 || row.EventID == 48 || row.EventID == 49 || row.EventID == 50 || row.EventID == 51 || row.EventID == 55 || row.EventID == 57) { if (cm == 0) { cm = 1; bgm = "#ccc"; } else { cm = 0; bgm = "#fff"; } Grid GRDM = Commentary_line(bgm, row); Home_Movements_Stack.Children.Add(GRDM); } // Stoppages Tab if (row.EventName == "Time off") { if (cp == 0) { cp = 1; bgp = "#ccc"; } else { cp = 0; bgp = "#fff"; } Grid GRDP = Commentary_line(bgp, row); GRDP.ColumnDefinitions.ElementAt(0).Width = new GridLength(50); GRDP.ColumnDefinitions.ElementAt(1).Width = new GridLength(350); GRDP.ColumnDefinitions.ElementAt(2).Width = new GridLength(0); GRDP.ColumnDefinitions.ElementAt(3).Width = new GridLength(0); GRDP.ColumnDefinitions.ElementAt(4).Width = new GridLength(0); GRDP.ColumnDefinitions.ElementAt(5).Width = new GridLength(480); GRDP.ColumnDefinitions.ElementAt(6).Width = new GridLength(0); Home_Stoppages_Stack.Children.Add(GRDP); } } // Lineup Tab // // // // // // // // // getLineUpTab(); // // // // // // // // // // // Commentary_Scroller.Content = Home_Comment_Stack; Scorers_Scroller.Content = Home_Scores_Stack; Movements_Scroller.Content = Home_Movements_Stack; Stoppages_Scroller.Content = Home_Stoppages_Stack; } private List GetLineUpPlayers(bool Onfield, int SID, int Code) { Teams DB = new Teams(); List FullTeam = Teams.GetLineUP_IDs(FID, SID, Code); List Team = new List(); if (FullTeam.Count > 0) { foreach (var item in FullTeam) { Teams Player = DB.GetPlayer(FID, SID, item); if (Onfield) { if (Player.CurrentPos <= Code && Player.Location < 3) { Team.Add(Player); } } if (!Onfield) { if (Player.CurrentPos > Code && Player.Location < 3) { Team.Add(Player); } } } } return Team; } private void getLineUpTab() { StackPanel Home_Lineup_Stack = new StackPanel(); Lineup_Scroller.Content = null; int cl = 0; // Get Home Players On Field List HomeOnField = new List(); HomeOnField = GetLineUpPlayers(true, Fixture_Data.HomeTeam, Int32.Parse(Fixture_Data.Code)); // Get Away Players On Field List AwayOnField = new List(); AwayOnField = GetLineUpPlayers(true, Fixture_Data.AwayTeam, Int32.Parse(Fixture_Data.Code)); int i = 0; dynamic LineupRows = new string[Int32.Parse(Fixture_Data.Code), 7]; do { LineupRows[i, 3] = (i + 1).ToString(); i++; } while (i < Int32.Parse(Fixture_Data.Code)); foreach (var p in HomeOnField) { i = 0; do { if (p.CurrentPos.ToString() == LineupRows[i, 3]) { LineupRows[i, 0] = p.Front; LineupRows[i, 1] = p.FullName; LineupRows[i, 2] = "(" + p.Jersey + ")"; i = Int32.Parse(Fixture_Data.Code); } i++; } while (i < Int32.Parse(Fixture_Data.Code)); } foreach (var p in AwayOnField) { i = 0; do { if (p.CurrentPos.ToString() == LineupRows[i, 3]) { LineupRows[i, 4] = "(" + p.Jersey + ")"; LineupRows[i, 5] = p.FullName; LineupRows[i, 6] = p.Front; i = Int32.Parse(Fixture_Data.Code); } i++; } while (i < Int32.Parse(Fixture_Data.Code)); } for (int j = 0; j < Int32.Parse(Fixture_Data.Code); j++) { string bgl = ""; string[] row = new string[7]; row[0] = LineupRows[j, 0]; row[1] = LineupRows[j, 1]; row[2] = LineupRows[j, 2]; row[3] = LineupRows[j, 3]; row[4] = LineupRows[j, 4]; row[5] = LineupRows[j, 5]; row[6] = LineupRows[j, 6]; // Linup Tab if (cl == 0) { cl = 1; bgl = "#ccc"; } else { cl = 0; bgl = "#fff"; } Grid GRDL = Linup_line_Home(bgl, row); Home_Lineup_Stack.Children.Add(GRDL); } // Get Home Players Off Field List HomeOffField = new List(); HomeOffField = GetLineUpPlayers(false, Fixture_Data.HomeTeam, Int32.Parse(Fixture_Data.Code)); // Get Away Players Off Field List AwayOffField = new List(); AwayOffField = GetLineUpPlayers(false, Fixture_Data.AwayTeam, Int32.Parse(Fixture_Data.Code)); i = 0; int TotalLength = HomeOffField.Count > AwayOffField.Count ? HomeOffField.Count + 1 : AwayOffField.Count + 1; int TeamTotal = Int32.Parse(Fixture_Data.Code); dynamic ReplacementRows = new string[TotalLength, 7]; do { ReplacementRows[i, 3] = i == 0 ? "Replacement" : (i + TeamTotal).ToString(); i++; } while (i < TotalLength); foreach (var p in HomeOffField) { i = 0; do { if (p.CurrentPos.ToString() == ReplacementRows[i, 3]) { ReplacementRows[i, 0] = p.Front; ReplacementRows[i, 1] = p.FullName; ReplacementRows[i, 2] = "(" + p.Jersey + ")"; i = TotalLength - 1; } i++; } while (i < TotalLength); } foreach (var p in AwayOffField) { i = 0; do { if (p.CurrentPos.ToString() == ReplacementRows[i, 3]) { ReplacementRows[i, 4] = "(" + p.Jersey + ")"; ReplacementRows[i, 5] = p.FullName; ReplacementRows[i, 6] = p.Front; i = TotalLength - 1; } i++; } while (i < TotalLength); } for (int j = 0; j < TotalLength; j++) { string bgl = ""; string[] row = new string[7]; row[0] = ReplacementRows[j, 0]; row[1] = ReplacementRows[j, 1]; row[2] = ReplacementRows[j, 2]; row[3] = ReplacementRows[j, 3]; row[4] = ReplacementRows[j, 4]; row[5] = ReplacementRows[j, 5]; row[6] = ReplacementRows[j, 6]; // Commentary Tab if (cl == 0) { cl = 1; bgl = "#ccc"; } else { cl = 0; bgl = "#fff"; } Grid GRDL = Linup_line_Home(bgl, row); Home_Lineup_Stack.Children.Add(GRDL); } TotalLength = 4; dynamic OfficialRows = new string[TotalLength, 7]; OfficialRows[0, 3] = "Match Officials"; OfficialRows[1, 1] = "Game Referee:"; OfficialRows[1, 5] = Fixture_Data.GameReferee; OfficialRows[2, 1] = "Assistant Referee:"; OfficialRows[2, 5] = Fixture_Data.AssistantReferee; OfficialRows[3, 1] = "Television Match Official:"; OfficialRows[3, 5] = Fixture_Data.TelevisionReferee; for (int j = 0; j < TotalLength; j++) { string bgl = ""; string[] row = new string[7]; row[0] = OfficialRows[j, 0]; row[1] = OfficialRows[j, 1]; row[2] = OfficialRows[j, 2]; row[3] = OfficialRows[j, 3]; row[4] = OfficialRows[j, 4]; row[5] = OfficialRows[j, 5]; row[6] = OfficialRows[j, 6]; // Commentary Tab if (cl == 0) { cl = 1; bgl = "#ccc"; } else { cl = 0; bgl = "#fff"; } Grid GRDL = Linup_line_Home(bgl, row); if (j == 0) { GRDL.ColumnDefinitions.ElementAt(0).Width = new GridLength(0); GRDL.ColumnDefinitions.ElementAt(1).Width = new GridLength(0); GRDL.ColumnDefinitions.ElementAt(2).Width = new GridLength(0); GRDL.ColumnDefinitions.ElementAt(3).Width = new GridLength(880); GRDL.ColumnDefinitions.ElementAt(4).Width = new GridLength(0); GRDL.ColumnDefinitions.ElementAt(5).Width = new GridLength(0); GRDL.ColumnDefinitions.ElementAt(6).Width = new GridLength(0); } else { GRDL.ColumnDefinitions.ElementAt(0).Width = new GridLength(0); GRDL.ColumnDefinitions.ElementAt(1).Width = new GridLength(440); GRDL.ColumnDefinitions.ElementAt(2).Width = new GridLength(0); GRDL.ColumnDefinitions.ElementAt(3).Width = new GridLength(0); GRDL.ColumnDefinitions.ElementAt(4).Width = new GridLength(0); GRDL.ColumnDefinitions.ElementAt(5).Width = new GridLength(440); GRDL.ColumnDefinitions.ElementAt(6).Width = new GridLength(0); } Home_Lineup_Stack.Children.Add(GRDL); } Lineup_Scroller.Content = Home_Lineup_Stack; } private void GetPlayers(int FID, int SID, int side, int RugbyCode, int Subs, int Running = 0) { Teams Team = new Teams(); List Data = Team.GetTeam(FID, SID); StackPanel Away_Stack = new StackPanel(); StackPanel Home_Stack = new StackPanel(); if (side == 0) { Home_Scroller.Content = null; } else { Away_Scroller.Content = null; } if (Running == 1) { foreach (Teams Player in Data) { if (Subs == 1 && Player.CurrentPos > RugbyCode && Player.Location < 3) { // SUBS Border grd = PlayerButton(Player.Jersey.ToString(), Player.FullName, side, Subs, 0, 0, Player.UserID); if (side == 0) { Home_Stack.Children.Add(grd); } else { Away_Stack.Children.Add(grd); } } else if (Subs == 0 && Player.CurrentPos <= RugbyCode && Player.Location < 3) { Border grd = PlayerButton(Player.Jersey.ToString(), Player.FullName, side, Subs, 0, 0, Player.UserID); if (side == 0) { Home_Stack.Children.Add(grd); } else { Away_Stack.Children.Add(grd); } } } } else { foreach (Teams Player in Data) { if (Player.Location < 3 && Player.Returned <= 0) { Border grd = PlayerButton(Player.Jersey.ToString(), Player.FullName, side, Subs, 0, 0, Player.UserID); if (side == 0) { Home_Stack.Children.Add(grd); } else { Away_Stack.Children.Add(grd); } } } } if (side == 0) { Home_Scroller.Content = Home_Stack; } else { Away_Scroller.Content = Away_Stack; } } private void GetYellowPlayers(int FID, int SID, int side, int RugbyCode, int Subs) { Teams Team = new Teams(); List Data = Team.GetYellowCards(FID, SID); StackPanel Away_Stack = new StackPanel(); StackPanel Home_Stack = new StackPanel(); if (side == 0) { Home_Scroller.Content = null; } else { Away_Scroller.Content = null; } foreach (Teams Player in Data) { Border grd = PlayerButton(Player.Jersey.ToString(), Player.FullName, side, Subs, 1, Player.Time, Player.UserID); if (side == 0) { Home_Stack.Children.Add(grd); } else { Away_Stack.Children.Add(grd); } } if (side == 0) { Home_Scroller.Content = Home_Stack; } else { Away_Scroller.Content = Away_Stack; } } private Border Avents_Button(int Team, string Event, string Color, int EventID) { Border BRD = new Border(); BRD.BorderBrush = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#2e405b")); BRD.BorderThickness = new Thickness(1); BRD.Margin = new Thickness(5); BRD.Name = "EevntID_" + EventID.ToString(); Grid GRD = new Grid(); GRD.Height = 50; TextBlock Name = new TextBlock(); Name.Text = Event; Name.FontSize = 14; Name.FontWeight = FontWeights.Bold; Name.VerticalAlignment = VerticalAlignment.Center; Name.Margin = new Thickness(10); Name.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#000000")); if (Color != "") { GRD.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString(Color)); } if (Team == 0) { BRD.MouseDown += new MouseButtonEventHandler(HomeEvents_Clicked); } else { BRD.MouseDown += new MouseButtonEventHandler(AwayEvents_Clicked); } Name.HorizontalAlignment = HorizontalAlignment.Center; GRD.Children.Add(Name); BRD.Child = GRD; return BRD; } private Grid Commentary_line(string Background, Comments Row) { Grid GRD = new Grid(); GRD.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString(Background)); GRD.Height = 40; ColumnDefinition Col1 = new ColumnDefinition(); ColumnDefinition Col2 = new ColumnDefinition(); ColumnDefinition Col3 = new ColumnDefinition(); ColumnDefinition Col4 = new ColumnDefinition(); ColumnDefinition Col5 = new ColumnDefinition(); ColumnDefinition Col6 = new ColumnDefinition(); ColumnDefinition Col7 = new ColumnDefinition(); Col1.Width = new GridLength(50); Col2.Width = new GridLength(150); Col3.Width = new GridLength(150); Col4.Width = new GridLength(150); Col5.Width = new GridLength(150); Col6.Width = new GridLength(150); Col7.Width = new GridLength(80); GRD.ColumnDefinitions.Add(Col1); GRD.ColumnDefinitions.Add(Col2); GRD.ColumnDefinitions.Add(Col3); GRD.ColumnDefinitions.Add(Col4); GRD.ColumnDefinitions.Add(Col5); GRD.ColumnDefinitions.Add(Col6); GRD.ColumnDefinitions.Add(Col7); Border BRD1 = GetTableBorder(Row.Time, HorizontalAlignment.Center); Border BRD2 = GetTableBorder(Row.EventName, HorizontalAlignment.Left); Border BRD3 = GetTableBorder(Row.SquadName, HorizontalAlignment.Left); if (Row.Subs == 1) { if (Row.EventID != 12) { Grid BRD4 = GetTableColWithArrow(Row.PlayerName, HorizontalAlignment.Left, "RedArrow.png"); Grid.SetColumn(BRD4, 3); GRD.Children.Add(BRD4); } else if (Row.EventID == 12) { Grid BRD4 = GetTableColWithArrow(Row.PlayerName, HorizontalAlignment.Left, "GreenArrow.png"); Grid.SetColumn(BRD4, 3); GRD.Children.Add(BRD4); } } else { Border BRD4 = GetTableBorder(Row.PlayerName, HorizontalAlignment.Left); Grid.SetColumn(BRD4, 3); GRD.Children.Add(BRD4); } if (Row.Subs == 1 && Row.ReplacementID > 0) { Grid BRD5 = GetTableColWithArrow(Row.ReplacementName, HorizontalAlignment.Left, "GreenArrow.png"); Grid.SetColumn(BRD5, 4); GRD.Children.Add(BRD5); } else { Border BRD5 = GetTableBorder(Row.ReplacementName, HorizontalAlignment.Left); Grid.SetColumn(BRD5, 4); GRD.Children.Add(BRD5); } Border BRD6 = GetTableBorder(Row.Comment, HorizontalAlignment.Left); Border BRD7 = new Border(); BRD7.BorderBrush = Brushes.Gray; BRD7.BorderThickness = new Thickness(0, 0, 0, 1); StackPanel stck = new StackPanel(); stck.Orientation = Orientation.Horizontal; if (Row.EventID != 27 && Row.EventID != 28 && Row.EventID != 29 && Row.EventID != 30 && Row.EventID != 31 && Row.EventID != 32 && Row.EventID != 33 && Row.EventID != 34 && Row.EventID != 39) { ImageBrush myBrush = new ImageBrush(); Image image = new Image(); image.Source = new BitmapImage(new Uri("pack://application:,,,/Images/Editing-edit-icon.png")); myBrush.ImageSource = image.Source; Border b1 = new Border(); b1.Height = 30; b1.Width = 30; b1.Uid = Row.ID.ToString(); b1.MouseDown += new MouseButtonEventHandler(Edit_Clicked); b1.Margin = new Thickness(5, 5, 0, 5); b1.Background = myBrush; stck.Children.Add(b1); ImageBrush myBrush2 = new ImageBrush(); Image image2 = new Image(); image2.Source = new BitmapImage(new Uri("pack://application:,,,/Images/Delete-icon.png")); myBrush2.ImageSource = image2.Source; Border b2 = new Border(); b2.Height = 30; b2.Uid = Row.ID.ToString(); b2.Width = 30; b2.MouseDown += new MouseButtonEventHandler(Delete_Clicked); b2.Margin = new Thickness(5, 5, 0, 5); b2.Background = myBrush2; stck.Children.Add(b2); } else { { ImageBrush myBrush = new ImageBrush(); Image image = new Image(); image.Source = new BitmapImage(new Uri("pack://application:,,,/Images/Editing-edit-icon.png")); myBrush.ImageSource = image.Source; Border b1 = new Border(); b1.Height = 30; b1.Width = 30; b1.Uid = Row.ID.ToString(); b1.MouseDown += new MouseButtonEventHandler(Session_Edit_Clicked); b1.Margin = new Thickness(5, 5, 0, 5); b1.Background = myBrush; stck.Children.Add(b1); } } stck.Children.Add(BRD7); Grid.SetColumn(BRD1, 0); Grid.SetColumn(BRD2, 1); Grid.SetColumn(BRD3, 2); Grid.SetColumn(BRD6, 5); Grid.SetColumn(stck, 6); GRD.Children.Add(BRD1); GRD.Children.Add(BRD2); GRD.Children.Add(BRD3); GRD.Children.Add(BRD6); GRD.Children.Add(stck); return GRD; } private Grid Linup_line_Home(string Background, dynamic Row) { Grid GRD = new Grid(); GRD.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString(Background)); GRD.Height = 40; ColumnDefinition Col1 = new ColumnDefinition(); ColumnDefinition Col2 = new ColumnDefinition(); ColumnDefinition Col3 = new ColumnDefinition(); ColumnDefinition Col4 = new ColumnDefinition(); ColumnDefinition Col5 = new ColumnDefinition(); ColumnDefinition Col6 = new ColumnDefinition(); ColumnDefinition Col7 = new ColumnDefinition(); Col1.Width = new GridLength(65); Col2.Width = new GridLength(260); Col3.Width = new GridLength(40); Col4.Width = new GridLength(150); Col5.Width = new GridLength(40); Col6.Width = new GridLength(260); Col7.Width = new GridLength(65); GRD.ColumnDefinitions.Add(Col1); GRD.ColumnDefinitions.Add(Col2); GRD.ColumnDefinitions.Add(Col3); GRD.ColumnDefinitions.Add(Col4); GRD.ColumnDefinitions.Add(Col5); GRD.ColumnDefinitions.Add(Col6); GRD.ColumnDefinitions.Add(Col7); Border BRD1 = GetTableBorder(Row[0], HorizontalAlignment.Center); Border BRD2 = GetTableBorder(Row[1], HorizontalAlignment.Right); Border BRD3 = GetTableBorder(Row[2], HorizontalAlignment.Center); Border BRD4 = GetTableBorder(Row[3], HorizontalAlignment.Center); Border BRD5 = GetTableBorder(Row[4], HorizontalAlignment.Center); Border BRD6 = GetTableBorder(Row[5], HorizontalAlignment.Left); Border BRD7 = GetTableBorder(Row[6], HorizontalAlignment.Center); Grid.SetColumn(BRD1, 0); Grid.SetColumn(BRD2, 1); Grid.SetColumn(BRD3, 2); Grid.SetColumn(BRD4, 3); Grid.SetColumn(BRD5, 4); Grid.SetColumn(BRD6, 5); Grid.SetColumn(BRD7, 6); GRD.Children.Add(BRD1); GRD.Children.Add(BRD2); GRD.Children.Add(BRD3); GRD.Children.Add(BRD4); GRD.Children.Add(BRD5); GRD.Children.Add(BRD6); GRD.Children.Add(BRD7); return GRD; } private Border GetTableBorder(string content, HorizontalAlignment Aligment) { Border BRD1 = new Border(); BRD1.BorderBrush = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#999")); BRD1.BorderThickness = new Thickness(0, 0, 1, 0); TextBlock Txt1 = new TextBlock(); Txt1.HorizontalAlignment = Aligment; Txt1.VerticalAlignment = VerticalAlignment.Center; Txt1.FontSize = 14; Txt1.Margin = new Thickness(5, 0, 5, 0); Txt1.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#000")); Txt1.Text = content; BRD1.Child = Txt1; return BRD1; } private Grid GetTableColWithArrow(string content, HorizontalAlignment Aligment, string ImageName) { Grid GRD = new Grid(); Border BRD1 = new Border(); BRD1.Width = 135; BRD1.BorderBrush = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#999")); BRD1.BorderThickness = new Thickness(0, 0, 1, 0); TextBlock Txt1 = new TextBlock(); Txt1.HorizontalAlignment = Aligment; Txt1.VerticalAlignment = VerticalAlignment.Center; Txt1.FontSize = 14; Txt1.Margin = new Thickness(5, 0, 5, 0); Txt1.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#000")); Txt1.Text = content; BRD1.Child = Txt1; Border BRD2 = new Border(); //BRD2.BorderBrush = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#999")); //BRD2.BorderThickness = new Thickness(0, 0, 1, 0); Image IMG = new Image(); IMG.Source = new BitmapImage(new Uri("pack://application:,,,/Images/" + ImageName)); IMG.Height = 20; IMG.Width = 10; IMG.Margin = new Thickness(5, 0, 0, 0); BRD2.Child = IMG; StackPanel STK = new StackPanel(); STK.Orientation = Orientation.Horizontal; STK.Children.Add(BRD2); STK.Children.Add(BRD1); GRD.Children.Add(STK); return GRD; } private Border PlayerButton(string JerseyNo, string FullName, int Team, int Subs, int Yellow, int time, int UserID) { Border BRD = new Border(); BRD.BorderBrush = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#2e405b")); BRD.BorderThickness = new Thickness(1); BRD.Margin = new Thickness(5); BRD.Name = "UserID_" + UserID.ToString(); Grid GRD = new Grid(); GRD.Height = 50; TextBlock Name = new TextBlock(); Name.Text = FullName; Name.FontSize = 14; Name.VerticalAlignment = VerticalAlignment.Center; Name.Margin = new Thickness(10); Border border = new Border(); border.BorderBrush = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#2e405b")); TextBlock Jersey = new TextBlock(); Jersey.Text = JerseyNo; Jersey.FontSize = 26; Jersey.FontWeight = FontWeights.Bold; Jersey.HorizontalAlignment = HorizontalAlignment.Center; Jersey.VerticalAlignment = VerticalAlignment.Center; Jersey.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#cccccc")); ColumnDefinition Col1 = new ColumnDefinition(); Col1.Width = new GridLength(150); ColumnDefinition Col2 = new ColumnDefinition(); Col2.Width = new GridLength(40); if (Team == 0) { border.BorderThickness = new Thickness(1, 0, 0, 0); if (Yellow == 1) { if (time == 0) { Name.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#000000")); GRD.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#FFFF00")); border.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#828213")); BRD.MouseDown += new MouseButtonEventHandler(Yellow_Card_Return_Clicked); } else { Name.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#000000")); GRD.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#999999")); border.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#000")); } } else { if (Subs == 1) { Name.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#000000")); GRD.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#c6ab0d")); border.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#9e880c")); BRD.MouseDown += new MouseButtonEventHandler(Subs_Clicked); } else { Name.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#cccccc")); GRD.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#107c25")); border.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#045113")); BRD.MouseDown += new MouseButtonEventHandler(Player_clicked); } } Name.HorizontalAlignment = HorizontalAlignment.Left; GRD.ColumnDefinitions.Add(Col1); GRD.ColumnDefinitions.Add(Col2); Grid.SetColumn(Name, 0); Grid.SetColumn(border, 1); } else { border.BorderThickness = new Thickness(0, 0, 1, 0); if (Yellow == 1) { if (time == 0) { Name.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#000000")); GRD.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#FFFF00")); border.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#828213")); BRD.MouseDown += new MouseButtonEventHandler(Yellow_Card_Return_Clicked); } else { Name.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#000000")); GRD.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#999999")); border.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#000")); } } else { if (Subs == 1) { Name.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#000000")); GRD.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#c6ab0d")); border.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#9e880c")); BRD.MouseDown += new MouseButtonEventHandler(Subs_Clicked); } else { Name.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#cccccc")); GRD.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#107c25")); border.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#045113")); BRD.MouseDown += new MouseButtonEventHandler(Player_clicked); } } Name.HorizontalAlignment = HorizontalAlignment.Right; GRD.ColumnDefinitions.Add(Col2); GRD.ColumnDefinitions.Add(Col1); Grid.SetColumn(Name, 1); Grid.SetColumn(border, 0); } border.Child = Jersey; GRD.Children.Add(Name); GRD.Children.Add(border); BRD.Child = GRD; return BRD; } private void Yellow_Card_Return_Clicked(object sender, MouseButtonEventArgs e) { /////test from my code// /// //var block = (TextBlock)sender; //Grid grid = (Grid)this.HomePlayers_YellowCards.FindName(block.Uid); //if (grid != null) //{ // HomePlayers_YellowCards.Children.Remove(grid); //} //var element = (Grid)this.AwayPlayers_YellowCards.FindName(block.Uid); //if (element != null) //{ // AwayPlayers_YellowCards.Children.Remove(element); //} //register name /////// end TextBlock button = (TextBlock)sender; string UserID_ID = button.Uid; var _Split = UserID_ID.Split('|'); int Player_ID = Convert.ToInt32(_Split[0]); int F_ID = Convert.ToInt32(_Split[1]); int S_ID = Convert.ToInt32(_Split[2]); var identfier = _Split[3]; bool Updated = UpdateLocation_Return(Player_ID, F_ID, S_ID, 1); if (Updated) { //LoadCurrentYellowCards(); Grid grid = (Grid)this.HomePlayers_Cards.FindName(identfier); if (grid != null) { HomePlayers_Cards.Children.Remove(grid); } var element = (Grid)this.AwayPlayers_Cards.FindName(identfier); if (element != null) { AwayPlayers_Cards.Children.Remove(element); } } ResetValues(); e.Handled = true; //avoid mutiple firing of this event. } object objOG; MouseButtonEventArgs eOG; private void Player_clicked(object sender, MouseButtonEventArgs e) { Border button = (Border)sender; string UserID_ID = button.Name; var _Split = UserID_ID.Split('_'); Player_ID = Convert.ToInt32(_Split[1]); //Events_Data Teams tms = new Teams(); Teams Data = tms.GetPlayer(FID, SID, Player_ID); string P_Name = Data.FullName.ToString(); var player_location = Data.Location; if (player_location == 4) return; //red card cant do anything. PlayerName = P_Name; //Player_ID switch (Group) { case 1: //GROUP 1 IS SCORES switch (EventID) { case 2: //tries Process_Data(); break; case 3: //Conversion Process_Data(); break; case 4: //Penalty Process_Data(); break; case 5: //Drop Goal Process_Data(); break; case 53: //Drop Goal Process_Data(); break; } break; case 2: // MISSED CONVERTION Process_Data(); break; case 3: Commentary = EventName; EventName = "Substitution"; Show_Subtitution(); subs_off = Player_ID; break; case 4: switch (EventID) { case 11: //Yellow Card CreateTimers(); break; case 45: //Blue Card //Conversion_points(); break; case 14: //Red Card Red_Card_Process_Data(); break; } break; default: Start_Session(); break; } } private void Show_Subtitution() { if (Side == 0) { Home_Events_Title.Text = "PLAYER ON"; } else { Away_Events_Title.Text = "PLAYER ON"; } GetPlayers(FID, SID, Side, Convert.ToInt32(Fixture_Data.Code), 1, 1); //if (EventID == 49) //{ // GetYellowPlayers(FID, SID, Side, Convert.ToInt32(Fixture_Data.Code), 0); //} //else //{ // GetPlayers(FID, SID, Side, Int32.Parse(Fixture_Data.Code), 1, 1); //} } private void Subs_Clicked(object sender, MouseButtonEventArgs e) { Border button = (Border)sender; string UserID_ID = button.Name; var _Split = UserID_ID.Split('_'); Replacemant_ID = Convert.ToInt32(_Split[1]); //// if (Commentary != "Tactical") { //if(Commentary.Contains("")) //Events_Data Teams tms = new Teams(); Teams Data = tms.GetPlayer(FID, SID, Player_ID); ReplacementName = Data.FullName; string subType = Commentary; Subs = 1; if (EventID == 44) { Process_Data(); } if (!subType.Contains("Return") && !subType.Contains("Substitution") && !subType.Contains("Injury")) { //CreateInjuryTimers(Data.Jersey, subType); Teams t = new Teams(); Teams d = t.GetPlayer(FID, SID, subs_off); int sub_off = subs_off; ; /// Subs = 1; /////////// Teams DB = new Teams(); Teams Player = DB.GetPlayer(FID, TeamID, Replacemant_ID); int UserID = Player.UserID; Grid Maingrd = new Grid(); var identifier = "I" + DateTime.Now.ToString("ddddddMMMMyyyyHHmmss"); Maingrd.Uid = UserID.ToString(); Maingrd.Margin = new Thickness(10, 30, 10, 10); Maingrd.Background = Brushes.White; RowDefinition row1 = new RowDefinition(); RowDefinition row2 = new RowDefinition(); row1.Height = new GridLength(25); row2.Height = new GridLength(40); Maingrd.RowDefinitions.Add(row1); Maingrd.RowDefinitions.Add(row2); if (EventID == 49 || EventID == 50) { } else { RowDefinition row3 = new RowDefinition(); row3.Height = new GridLength(25); Maingrd.RowDefinitions.Add(row3); } //Add Text TextBlock Title = new TextBlock(); Title.Uid = Player.UserID.ToString() + "|" + d.FID + "|" + d.SID + "|" + d.UserID.ToString() + "|" + identifier + "|" + EventID; Title.Text = subType; Title.FontSize = 14; Title.Background = Brushes.White; Title.FontWeight = FontWeights.Bold; Title.TextAlignment = TextAlignment.Center; Title.MouseDown += new MouseButtonEventHandler(Handle_Injury); Border BRD = new Border(); BRD.BorderBrush = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#999")); BRD.BorderThickness = new Thickness(2, 2, 2, 2); BRD.Child = Title; TextBlock Number = new TextBlock(); Number.Text = Player.Jersey.ToString() + " ON ↑" + Environment.NewLine + d.Jersey.ToString() + " OFF ↓"; Number.FontSize = 16; Number.FontWeight = FontWeights.Bold; Number.Margin = new Thickness(5, 0, 5, 0); Number.TextAlignment = TextAlignment.Center; Number.HorizontalAlignment = HorizontalAlignment.Center; if (EventID == 49 || EventID == 50) { } else { TextBlock Timm = new TextBlock(); Timm.Uid = Data.Jersey.ToString() + "|" + FID + "|" + SID + "|" + Game_Duration.Text + "|" + d.Jersey.ToString(); Timm.FontSize = 16; Timm.FontWeight = FontWeights.Bold; Timm.TextAlignment = TextAlignment.Center; Timm.VerticalAlignment = VerticalAlignment.Center; Timm.Text = "00:00"; Timm.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#808080")); Timm.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#fff")); Timm.Margin = new Thickness(5, 0, 5, 0); Grid.SetRow(Timm, 3); Maingrd.Children.Add(Timm); } Border BRD2 = new Border(); BRD2.BorderBrush = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#999")); BRD2.BorderThickness = new Thickness(0, 0, 1, 0); BRD2.Child = Number; Grid.SetRow(BRD, 0); Grid.SetRow(BRD2, 1); Maingrd.Children.Add(BRD); Maingrd.Children.Add(BRD2); //Check Team if (SID == Fixture_Data.HomeTeam) { HomePlayers_Subs.Children.Add(Maingrd); HomePlayers_Subs.RegisterName(identifier, Maingrd); } else if (SID == Fixture_Data.AwayTeam) { AwayPlayers_Subs.Children.Add(Maingrd); AwayPlayers_Subs.RegisterName(identifier, Maingrd); } allCards.Add(new Cards { FID = d.FID, SID = d.SID, EventID = EventID, PlayerID = d.UserID, ReplacementID = Player.UserID, Identfier = identifier }); if (EventID == 49 || EventID == 50) { InjuryPermanentOnResume.Add(Title.Uid); } else { InjuryOnResume.Add(Title.Uid); } //if (!sw.IsRunning) //{ // SubPopup.IsOpen = true; // btnPush.Visibility = Visibility.Visible; // btnPush.Margin = new Thickness(32, 50, 0, 0); // btnPush.Content = "Confirm"; // btnPark.Visibility = Visibility.Hidden; // btnPark.Margin = new Thickness(32, 50, 0, 0); // btnPark.Content = "Park"; // btnCancel.Visibility = Visibility.Visible; // btnCancel.Margin = new Thickness(32, 100, 0, 0); // SubPopup.Height = 150; //} //else //{ // SubPopup.IsOpen = true; // btnPush.Visibility = Visibility.Visible; // btnPush.Margin = new Thickness(32, 50, 0, 0); // btnPush.Content = "Push"; // btnPark.Visibility = Visibility.Visible; // btnPark.Margin = new Thickness(32, 100, 0, 0); // btnPark.Content = "Confirm"; // btnCancel.Visibility = Visibility.Visible; // btnCancel.Margin = new Thickness(32, 150, 0, 0); // SubPopup.Height = 200; //} ResetValues(); GetEvents(); } } else //tactical sub { /// Teams t = new Teams(); Teams d = t.GetPlayer(FID, SID, subs_off); int sub_off = subs_off; ; /// Subs = 1; /////////// Teams DB = new Teams(); Teams Player = DB.GetPlayer(FID, TeamID, Replacemant_ID); int UserID = Player.UserID; Grid Maingrd = new Grid(); var identifier = "S" + DateTime.Now.ToString("ddddddMMMMyyyyHHmmss"); Maingrd.Uid = UserID.ToString(); Maingrd.Margin = new Thickness(10, 30, 10, 30); Maingrd.Background = Brushes.LightGray; RowDefinition row1 = new RowDefinition(); RowDefinition row2 = new RowDefinition(); row1.Height = new GridLength(25); row2.Height = new GridLength(40); Maingrd.RowDefinitions.Add(row1); Maingrd.RowDefinitions.Add(row2); //Maingrd.MouseDown += new MouseButtonEventHandler(Handle_Sub); //Add Text TextBlock Title = new TextBlock(); Title.Uid = Player.UserID.ToString() + "|" + d.FID + "|" + d.SID + "|" + d.UserID.ToString() + "|" + identifier + "|" + EventID; Title.Text = "Parked"; Title.FontSize = 14; Title.Background = Brushes.Yellow; Title.FontWeight = FontWeights.Bold; Title.TextAlignment = TextAlignment.Center; Title.MouseDown += new MouseButtonEventHandler(Handle_Sub); Border BRD = new Border(); BRD.BorderBrush = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#999")); BRD.BorderThickness = new Thickness(2, 2, 2, 2); BRD.Child = Title; Grid GRD = new Grid(); Grid.SetRow(BRD, 0); Grid.SetRow(GRD, 1); Maingrd.Children.Add(BRD); Maingrd.Children.Add(GRD); TextBlock Number = new TextBlock(); Number.Text = Player.Jersey.ToString() + " ON ↑" + Environment.NewLine + d.Jersey.ToString() + " OFF ↓"; Number.FontSize = 16; Number.FontWeight = FontWeights.Bold; Number.TextAlignment = TextAlignment.Center; Number.HorizontalAlignment = HorizontalAlignment.Center; GRD.Children.Add(Number); //Check Team if (SID == Fixture_Data.HomeTeam) { HomePlayers_Subs.Children.Add(Maingrd); HomePlayers_Subs.RegisterName(identifier, Maingrd); } else if (SID == Fixture_Data.AwayTeam) { AwayPlayers_Subs.Children.Add(Maingrd); AwayPlayers_Subs.RegisterName(identifier, Maingrd); } allCards.Add(new Cards { FID = d.FID, SID = d.SID, EventID = EventID, PlayerID = d.UserID, ReplacementID = Player.UserID, Identfier = identifier }); objOG = Title; if (!sw.IsRunning) { SubPopup.IsOpen = true; btnPush.Visibility = Visibility.Visible; btnPush.Margin = new Thickness(32, 50, 0, 0); btnPush.Content = "Confirm"; btnPark.Visibility = Visibility.Hidden; btnPark.Margin = new Thickness(32, 50, 0, 0); btnPark.Content = "Park"; btnCancel.Visibility = Visibility.Visible; btnCancel.Margin = new Thickness(32, 100, 0, 0); SubPopup.Height = 150; } else { SubPopup.IsOpen = true; btnPush.Visibility = Visibility.Visible; btnPush.Margin = new Thickness(32, 50, 0, 0); btnPush.Content = "Push"; btnPark.Visibility = Visibility.Visible; btnPark.Margin = new Thickness(32, 100, 0, 0); btnPark.Content = "Confirm"; btnCancel.Visibility = Visibility.Visible; btnCancel.Margin = new Thickness(32, 150, 0, 0); SubPopup.Height = 200; } allCards.Add(new Cards { FID = d.FID, SID = d.SID, EventID = EventID, PlayerID = d.UserID, ReplacementID = Player.UserID, Identfier = identifier }); ResetValues(); GetEvents(); } } private void HandleInjuryOnResume(string identifier) { var _Split = identifier.Split('|'); int Player_ID = Convert.ToInt32(_Split[0]); int F_ID = Convert.ToInt32(_Split[1]); int S_ID = Convert.ToInt32(_Split[2]); int sub_ID = Convert.ToInt32(_Split[3]); var identfier = _Split[4]; var eventId = Convert.ToInt32(_Split[5]); Grid grid = null; grid = (Grid)this.FindName(identfier); Teams DB = new Teams(); Teams pSubOff = DB.GetPlayer(F_ID, S_ID, Player_ID); Teams pSubOn = DB.GetPlayer(F_ID, S_ID, sub_ID); UpdatePosition(Player_ID, pSubOn.CurrentPos, F_ID, S_ID); UpdatePosition(sub_ID, pSubOff.CurrentPos, F_ID, S_ID); UpdateLocation_ReturnInjury(Player_ID, F_ID, S_ID, sub_ID, grid, eventId); TextBlock Timm = (TextBlock)grid.Children[0]; //Border BRD = (Border)grid.Children[0]; //TextBlock text = (TextBlock)BRD.Child; //if (Timm.Text != "Start") //{ // return; //} var time_arr = Timm.Uid.Split('|'); var timerFirst = time_arr[3]; Timm.Uid = timerFirst; grid.Uid = time_arr[0]; Timm.FontSize = 50; Timm.FontSize = 16; Timm.FontWeight = FontWeights.Bold; Timm.TextAlignment = TextAlignment.Center; Timm.VerticalAlignment = VerticalAlignment.Center; Timm.Text = "00:00"; if (eventId == 45) { Timm.Name = Convert.ToString("Sec_" + timesecBloodTimer); } else if (eventId == 40) { Timm.Name = Convert.ToString("Sec_" + timesecHIATimer); } DispatcherTimer dispatcherTimer = new DispatcherTimer(); dispatcherTimer.Tick += new EventHandler(outInjuryTimer_Tick); dispatcherTimer.Tag = grid; dispatcherTimer.Interval = new TimeSpan(0, 0, 1); dispatcherTimer.Start(); grid.Children.RemoveAt(0); grid.Children.Add(Timm); Grid.SetColumn(Timm, 3); } private void HandlePushOnResume(string identifier) { var _Split = identifier.Split('|'); int Player_ID = Convert.ToInt32(_Split[0]); int F_ID = Convert.ToInt32(_Split[1]); int S_ID = Convert.ToInt32(_Split[2]); int sub_ID = Convert.ToInt32(_Split[3]); var identfier = _Split[4]; Grid grid = null; Teams DB = new Teams(); Teams pSubOff = DB.GetPlayer(F_ID, S_ID, Player_ID); Teams pSubOn = DB.GetPlayer(F_ID, S_ID, sub_ID); UpdatePosition(Player_ID, pSubOn.CurrentPos, F_ID, S_ID); UpdatePosition(sub_ID, pSubOff.CurrentPos, F_ID, S_ID); try { //grid = (Grid)e.OriginalSource; UpdateLocation_ReturnSubstitute(Player_ID, F_ID, S_ID, sub_ID, grid); grid = (Grid)this.HomePlayers_Cards.FindName(identfier); if (grid != null) { HomePlayers_Subs.Children.Remove(grid); } var element = (Grid)this.AwayPlayers_Cards.FindName(identfier); if (element != null) { AwayPlayers_Subs.Children.Remove(element); } } catch { } } private void HandleInjuryPermanentOnResume(string identifier) { var _Split = identifier.Split('|'); int Player_ID = Convert.ToInt32(_Split[0]); int F_ID = Convert.ToInt32(_Split[1]); int S_ID = Convert.ToInt32(_Split[2]); int sub_ID = Convert.ToInt32(_Split[3]); var identfier = _Split[4]; var eventId = Convert.ToInt32(_Split[5]); Grid grid = null; try { if (eventId == 49 || eventId == 50) { Teams DB = new Teams(); Teams pSubOff = DB.GetPlayer(F_ID, S_ID, Player_ID); Teams pSubOn = DB.GetPlayer(F_ID, S_ID, sub_ID); UpdatePosition(Player_ID, pSubOn.CurrentPos, F_ID, S_ID); UpdatePosition(sub_ID, pSubOff.CurrentPos, F_ID, S_ID); UpdateLocation_ReturnInjury(Player_ID, F_ID, S_ID, sub_ID, grid, eventId); } grid = (Grid)this.HomePlayers_Cards.FindName(identfier); if (grid != null) { HomePlayers_Subs.Children.Remove(grid); } var element = (Grid)this.AwayPlayers_Cards.FindName(identfier); if (element != null) { AwayPlayers_Subs.Children.Remove(element); } InjuryPopup.IsOpen = false; } catch (Exception) { } } private void HandleInjuryReverseOnResume(string identifier) { var _Split = identifier.Split('|'); int Player_ID = Convert.ToInt32(_Split[0]); int F_ID = Convert.ToInt32(_Split[1]); int S_ID = Convert.ToInt32(_Split[2]); int sub_ID = Convert.ToInt32(_Split[3]); var identfier = _Split[4]; var eventId = Convert.ToInt32(_Split[5]); Grid grid = null; eventId = eventId == 45 ? 46 : 48; Teams DB = new Teams(); Teams pSubOff = DB.GetPlayer(F_ID, S_ID, Player_ID); Teams pSubOn = DB.GetPlayer(F_ID, S_ID, sub_ID); UpdatePosition(sub_ID, pSubOff.CurrentPos, F_ID, S_ID); UpdatePosition(Player_ID, pSubOn.CurrentPos, F_ID, S_ID); UpdateLocation_ReturnInjury(sub_ID, F_ID, S_ID, Player_ID, grid, eventId); try { grid = (Grid)this.HomePlayers_Cards.FindName(identfier); if (grid != null) { HomePlayers_Subs.Children.Remove(grid); } var element = (Grid)this.AwayPlayers_Cards.FindName(identfier); if (element != null) { AwayPlayers_Subs.Children.Remove(element); } InjuryPopup.IsOpen = false; } catch (Exception) { } } private void Button_Injury_Permanent_Click(object sender, RoutedEventArgs e) { TextBlock button = (TextBlock)objOG; string UserID_ID = button.Uid; try { InjuryPermanentOnResume.Remove(UserID_ID); InjuryReverseOnResume.Remove(UserID_ID); } catch (Exception) { } InjuryPermanentOnResume.Add(UserID_ID); button.Text = "Permanent"; button.Background = Brushes.DeepSkyBlue; e.Handled = true; InjuryPopup.IsOpen = false; } private void Button_Injury_Reverse_Click(object sender, RoutedEventArgs e) { TextBlock button = (TextBlock)objOG; string UserID_ID = button.Uid; try { InjuryPermanentOnResume.Remove(UserID_ID); InjuryReverseOnResume.Remove(UserID_ID); } catch (Exception) { } InjuryReverseOnResume.Add(UserID_ID); button.Text = "Reverse"; button.Background = Brushes.Yellow; e.Handled = true; InjuryPopup.IsOpen = false; } private void Button_Sub_In_Click(object sender, RoutedEventArgs e) { TextBlock button = (TextBlock)objOG; string UserID_ID = button.Uid; if (!sw.IsRunning) { if (button.Text == "Parked") { PushOnResume.Add(UserID_ID); button.Text = "Confirmed"; button.Background = Brushes.DeepSkyBlue; e.Handled = true; SubPopup.IsOpen = false; btnPush.Visibility = Visibility.Visible; btnPush.Margin = new Thickness(32, 50, 0, 0); btnPush.Content = "Push"; btnPark.Visibility = Visibility.Visible; btnPark.Margin = new Thickness(32, 100, 0, 0); btnPark.Content = "Confirm"; btnCancel.Visibility = Visibility.Visible; btnCancel.Margin = new Thickness(32, 150, 0, 0); btnCancel.Content = "Cancel"; SubPopup.Height = 200; } else if (button.Text == "Confirmed") { PushOnResume.Remove(UserID_ID); button.Text = "Parked"; button.Background = Brushes.Yellow; e.Handled = true; SubPopup.IsOpen = false; btnPush.Visibility = Visibility.Visible; btnPush.Margin = new Thickness(32, 50, 0, 0); btnPush.Content = "Push"; btnPark.Visibility = Visibility.Visible; btnPark.Margin = new Thickness(32, 100, 0, 0); btnPark.Content = "Confirm"; btnCancel.Visibility = Visibility.Visible; btnCancel.Margin = new Thickness(32, 150, 0, 0); btnCancel.Content = "Cancel"; SubPopup.Height = 200; } } //else if (button.Text == "Confirmed") //{ // PushOnResume.Remove(UserID_ID); // button.Text = "Parked"; // button.Background = Brushes.Yellow; // e.Handled = true; // SubPopup.IsOpen = false; // btnPush.Visibility = Visibility.Visible; // btnPush.Margin = new Thickness(32, 50, 0, 0); // btnPush.Content = "Push"; // btnPark.Visibility = Visibility.Visible; // btnPark.Margin = new Thickness(32, 100, 0, 0); // btnPark.Content = "Confirm"; // btnCancel.Visibility = Visibility.Visible; // btnCancel.Margin = new Thickness(32, 150, 0, 0); // btnCancel.Content = "Cancel"; // SubPopup.Height = 200; //} else { var _Split = UserID_ID.Split('|'); int Player_ID = Convert.ToInt32(_Split[0]); int F_ID = Convert.ToInt32(_Split[1]); int S_ID = Convert.ToInt32(_Split[2]); int sub_ID = Convert.ToInt32(_Split[3]); var identfier = _Split[4]; Grid grid = null; Teams DB = new Teams(); Teams pSubOff = DB.GetPlayer(F_ID, S_ID, Player_ID); Teams pSubOn = DB.GetPlayer(F_ID, S_ID, sub_ID); UpdatePosition(Player_ID, pSubOn.CurrentPos, F_ID, S_ID); UpdatePosition(sub_ID, pSubOff.CurrentPos, F_ID, S_ID); //if user clicks in the textblock try { //grid = (Grid)e.OriginalSource; UpdateLocation_ReturnSubstitute(Player_ID, F_ID, S_ID, sub_ID, grid); grid = (Grid)this.HomePlayers_Cards.FindName(identfier); if (grid != null) { HomePlayers_Subs.Children.Remove(grid); } var element = (Grid)this.AwayPlayers_Cards.FindName(identfier); if (element != null) { AwayPlayers_Subs.Children.Remove(element); } e.Handled = true; SubPopup.IsOpen = false; btnPush.Visibility = Visibility.Visible; btnPush.Margin = new Thickness(32, 50, 0, 0); btnPush.Content = "Push"; btnPark.Visibility = Visibility.Visible; btnPark.Margin = new Thickness(32, 100, 0, 0); btnPark.Content = "Confirm"; btnCancel.Visibility = Visibility.Visible; btnCancel.Margin = new Thickness(32, 150, 0, 0); btnCancel.Content = "Cancel"; SubPopup.Height = 200; } catch (Exception) { } } } public void Button_Sub_Park_Click(object sender, RoutedEventArgs e) { TextBlock button = (TextBlock)objOG; string UserID_ID = button.Uid; if (sw.IsRunning) { if (button.Text == "Confirmed") { try { PushOnResume.Remove(UserID_ID); } catch (Exception) { } button.Text = "Parked"; button.Background = Brushes.Yellow; e.Handled = true; } else { PushOnResume.Add(UserID_ID); button.Text = "Confirmed"; button.Background = Brushes.DeepSkyBlue; e.Handled = true; } SubPopup.IsOpen = false; btnPush.Visibility = Visibility.Visible; btnPush.Margin = new Thickness(32, 50, 0, 0); btnPush.Content = "Push"; btnPark.Visibility = Visibility.Visible; btnPark.Margin = new Thickness(32, 100, 0, 0); btnPark.Content = "Confirm"; btnCancel.Visibility = Visibility.Visible; btnCancel.Margin = new Thickness(32, 150, 0, 0); btnCancel.Content = "Cancel"; SubPopup.Height = 200; } else { if (button.Text == "Confirmed") { try { PushOnResume.Remove(UserID_ID); } catch (Exception) { } button.Text = "Parked"; button.Background = Brushes.Yellow; e.Handled = true; } else { PushOnResume.Add(UserID_ID); button.Text = "Confirmed"; button.Background = Brushes.DeepSkyBlue; e.Handled = true; } SubPopup.IsOpen = false; btnPush.Visibility = Visibility.Visible; btnPush.Margin = new Thickness(32, 50, 0, 0); btnPush.Content = "Push"; btnPark.Visibility = Visibility.Visible; btnPark.Margin = new Thickness(32, 100, 0, 0); btnPark.Content = "Confirm"; btnCancel.Visibility = Visibility.Visible; btnCancel.Margin = new Thickness(32, 150, 0, 0); btnCancel.Content = "Cancel"; SubPopup.Height = 200; } } private void Button_Sub_Calcel_Click(object sender, RoutedEventArgs e) { try { TextBlock button = (TextBlock)objOG; string UserID_ID = button.Uid; try { PushOnResume.Remove(UserID_ID); } catch (Exception) { } var _Split = UserID_ID.Split('|'); int Player_ID = Convert.ToInt32(_Split[0]); int F_ID = Convert.ToInt32(_Split[1]); int S_ID = Convert.ToInt32(_Split[2]); var identfier = _Split[4]; Grid grid = (Grid)this.HomePlayers_Cards.FindName(identfier); if (grid != null) { HomePlayers_Subs.Children.Remove(grid); } var element = (Grid)this.AwayPlayers_Cards.FindName(identfier); if (element != null) { AwayPlayers_Subs.Children.Remove(element); } e.Handled = true; SubPopup.IsOpen = false; btnPush.Visibility = Visibility.Visible; btnPush.Margin = new Thickness(32, 50, 0, 0); btnPush.Content = "Push"; btnPark.Visibility = Visibility.Visible; btnPark.Margin = new Thickness(32, 100, 0, 0); btnPark.Content = "Confirm"; btnCancel.Visibility = Visibility.Visible; btnCancel.Margin = new Thickness(32, 150, 0, 0); btnCancel.Content = "Cancel"; SubPopup.Height = 200; } catch (Exception) { } } private void Handle_Injury(object sender, MouseButtonEventArgs e) { objOG = sender; eOG = e; InjuryPopup.IsOpen = true; } private void Handle_Sub(object sender, MouseButtonEventArgs e) { objOG = sender; eOG = e; SubPopup.IsOpen = true; TextBlock button = (TextBlock)objOG; string UserID_ID = button.Uid; if (sw.IsRunning) { if (button.Text == "Confirmed") { btnPush.Visibility = Visibility.Visible; btnPush.Margin = new Thickness(32, 50, 0, 0); btnPush.Content = "Push"; btnPark.Visibility = Visibility.Visible; btnPark.Margin = new Thickness(32, 100, 0, 0); btnPark.Content = "Park"; btnCancel.Visibility = Visibility.Visible; btnCancel.Margin = new Thickness(32, 150, 0, 0); SubPopup.Height = 200; } else if (button.Text == "Parked") { btnPush.Visibility = Visibility.Visible; btnPush.Margin = new Thickness(32, 50, 0, 0); btnPush.Content = "Push"; btnPark.Visibility = Visibility.Visible; btnPark.Margin = new Thickness(32, 100, 0, 0); btnPark.Content = "Confirm"; btnCancel.Visibility = Visibility.Visible; btnCancel.Margin = new Thickness(32, 150, 0, 0); SubPopup.Height = 200; } } else { if (button.Text == "Confirmed") { btnPush.Visibility = Visibility.Hidden; btnPush.Margin = new Thickness(32, 50, 0, 0); btnPush.Content = "Push"; btnPark.Visibility = Visibility.Visible; btnPark.Margin = new Thickness(32, 50, 0, 0); btnPark.Content = "Park"; btnCancel.Visibility = Visibility.Visible; btnCancel.Margin = new Thickness(32, 100, 0, 0); SubPopup.Height = 150; } else if (button.Text == "Parked") { btnPush.Visibility = Visibility.Visible; btnPush.Margin = new Thickness(32, 50, 0, 0); btnPush.Content = "Push"; btnPark.Visibility = Visibility.Hidden; btnPark.Margin = new Thickness(32, 100, 0, 0); btnPark.Content = "Park"; btnCancel.Visibility = Visibility.Visible; btnCancel.Margin = new Thickness(32, 100, 0, 0); SubPopup.Height = 150; } } } private void UpdateLocation_ReturnInjury(int Players_ID, int FID, int TeamID, int sub_ID, Grid grid, int eventId) { Guid guid = Guid.NewGuid(); string ID = guid.ToString(); SquadName = Fixture_Data.HomeName; if (Fixture_Data.AwayTeam == TeamID) { SquadName = Fixture_Data.AwayName; } string Time = Game_Duration.Text; var time_split = Time.Split(':'); Teams PlayeDBr = new Teams(); Teams Playe = PlayeDBr.GetPlayer(FID, TeamID, sub_ID); EventID = eventId; Events evt = new Events(); Events Data = evt.GetEvent(EventID); string commentary = Data.CommName; EventName = "Substitution"; Group = Data.Group; //Time = time_playing; Player_ID = Playe.UserID; PlayerName = Playe.FirstName + " " + Playe.LastName; Teams repPlayer = new Teams(); Teams player = repPlayer.GetPlayer(FID, TeamID, Players_ID); ReplacementName = player.FirstName + " " + player.LastName; //int Session = 0; int No = Convert.ToInt32(time_split[0] + time_split[1]); //string commentary = "Substitution"; string sql_string = "insert into Commentary (FID, ID,Time,Session,SID," + "EventID,PlayerID,ReplcamentID,SquadName,EventName,ReplacementName,PlayerName,No,Comment)" + " values ('" + FID + "', '" + ID + "','" + Playing_Time.Text + "','" + Session + "'," + "'" + TeamID + "','" + EventID + "','" + sub_ID + "','" + Players_ID + "'," + "'" + SquadName + "','" + EventName + "','" + ReplacementName + "','" + PlayerName + "','" + No + "','" + commentary + "')"; Comments Comm = new Comments(); bool Saved = Comm.insertData(sql_string); if (Saved == true) { SubsPositonUpdate(); getCommentary(); //clear yellow card area HomePlayers_Cards.Children.Remove(grid); AwayPlayers_Cards.Children.Remove(grid); } else { MessageBox.Show("Did not save!"); } ResetValues(); GetFixture(); } private void UpdateLocation_ReturnSubstitute(int Players_ID, int FID, int TeamID, int sub_ID, Grid grid) { //Process_Data(); Guid guid = Guid.NewGuid(); string ID = guid.ToString(); SquadName = Fixture_Data.HomeName; if (Fixture_Data.AwayTeam == TeamID) { SquadName = Fixture_Data.AwayName; } string Time = Game_Duration.Text; var time_split = Time.Split(':'); Teams PlayeDBr = new Teams(); Teams Playe = PlayeDBr.GetPlayer(FID, TeamID, sub_ID); EventID = 43; Events evt = new Events(); Events Data = evt.GetEvent(EventID); string commentary = Data.CommName; EventName = "Substitution"; Group = Data.Group; //Time = time_playing; Player_ID = Playe.UserID; PlayerName = Playe.FirstName + " " + Playe.LastName; Teams repPlayer = new Teams(); Teams player = repPlayer.GetPlayer(FID, TeamID, Players_ID); ReplacementName = player.FirstName + " " + player.LastName; //int Session = 0; int No = Convert.ToInt32(time_split[0] + time_split[1]); //string commentary = "Substitution"; string sql_string = "insert into Commentary (FID, ID,Time,Session,SID," + "EventID,PlayerID,ReplcamentID,SquadName,EventName,ReplacementName,PlayerName,No,Comment)" + " values ('" + FID + "', '" + ID + "','" + Playing_Time.Text + "','" + Session + "'," + "'" + TeamID + "','" + EventID + "','" + sub_ID + "','" + Players_ID + "'," + "'" + SquadName + "','" + EventName + "','" + ReplacementName + "','" + PlayerName + "','" + No + "','" + commentary + "')"; Comments Comm = new Comments(); bool Saved = Comm.insertData(sql_string); if (Saved == true) { SubsPositonUpdate(); getCommentary(); //clear yellow card area HomePlayers_Cards.Children.Remove(grid); AwayPlayers_Cards.Children.Remove(grid); } else { MessageBox.Show("Did not save!"); } ResetValues(); GetEvents(); GetFixture(); } private void HomeEvents_Clicked(object sender, MouseButtonEventArgs e) { GAMESTARTED = 0; bool score_Events = false; bool playerMovement_Events = false; if (Game_status > 0 && Game_status < 10) { this.Time = Game_Duration.Text; Home_Cancel.Visibility = Visibility.Visible; Away_Blocker.Visibility = Visibility.Visible; Border button = (Border)sender; string Event_ID = button.Name; var EVT_Split = Event_ID.Split('_'); EventID = Convert.ToInt32(EVT_Split[1]); //Events_Data Events evt = new Events(); Events Data = evt.GetEvent(EventID); TeamID = Fixture_Data.HomeTeam; SquadName = Fixture_Data.HomeName; SID = Fixture_Data.HomeTeam; EventName = Data.CommName; Group = Data.Group; Side = 0; if (Group == 1 || Group == 2) { Home_Events_Title.Text = "SELECT PLAYER"; score_Events = true; } if (Group == 3 || Group == 4) { Home_Events_Title.Text = "PLAYER OFF"; playerMovement_Events = true; } if (EventID == 6) { Home_Events_Title.Text = "PENALTY TRY"; Popup_Content.Text = "Please confirm that a Penalty Try was awarded to (" + SquadName + ") by clicking the Confrim Button below"; Confirm_Penaltytry_Btn.Visibility = Visibility.Visible; Confirmation_Popup.Visibility = Visibility.Visible; } else if (EventID == 12) { Home_Events_Title.Text = "PLAYER ON"; GetYellowPlayers(FID, SID, Side, Convert.ToInt32(Fixture_Data.Code), 0); } else if (score_Events || playerMovement_Events) { // Get onfield players GetPlayers(FID, SID, Side, Convert.ToInt32(Fixture_Data.Code), 0, 1); } else { GetPlayers(FID, SID, Side, Convert.ToInt32(Fixture_Data.Code), 0); } } } private void AwayEvents_Clicked(object sender, MouseButtonEventArgs e) { GAMESTARTED = 0; bool score_Events = false; bool playerMovement_Events = false; if (Game_status > 0 && Game_status < 10) { this.Time = Game_Duration.Text; Away_Cancel.Visibility = Visibility.Visible; Home_Blocker.Visibility = Visibility.Visible; Border button = (Border)sender; string Event_ID = button.Name; var EVT_Split = Event_ID.Split('_'); EventID = Convert.ToInt32(EVT_Split[1]); //Events_Data Events evt = new Events(); Events Data = evt.GetEvent(EventID); TeamID = Fixture_Data.AwayTeam; SquadName = Fixture_Data.AwayName; SID = Fixture_Data.AwayTeam; EventName = Data.CommName; Group = Data.Group; if (Group == 1 || Group == 2) { Away_Events_Title.Text = "SELECT PLAYER"; score_Events = true; } if (Group == 3 || Group == 4) { Away_Events_Title.Text = "PLAYER OFF"; playerMovement_Events = true; } Side = 1; if (EventID == 6) { Away_Events_Title.Text = "PENALTY TRY"; Popup_Content.Text = "Please confirm that a Penalty Try was awarded to (" + SquadName + ") by clicking the Confirm Button below"; Confirm_Penaltytry_Btn.Visibility = Visibility.Visible; Confirmation_Popup.Visibility = Visibility.Visible; } else if (EventID == 12) { Away_Events_Title.Text = "PLAYER ON"; GetYellowPlayers(FID, SID, Side, Convert.ToInt32(Fixture_Data.Code), 0); } else if (score_Events || playerMovement_Events) { // Get onfield players GetPlayers(FID, SID, Side, Convert.ToInt32(Fixture_Data.Code), 0, 1); } else { GetPlayers(FID, SID, Side, Convert.ToInt32(Fixture_Data.Code), 0); } } } private void Session_Edit_Clicked(object sender, MouseButtonEventArgs e) { Border btn = (Border)sender; string id = btn.Uid; CommentaryID = id; Comments Row = Comments.GetRow(CommentaryID); Commentry_Edit_Data = Row; SessionDropDown.SelectedIndex = Int32.Parse(Row.Session.ToString()); //1. SET TIME MinuteSessionsDropDown_1.SelectedIndex = Int32.Parse(Row.Time[0].ToString()); MinutesSessionDropDown_2.SelectedIndex = Int32.Parse(Row.Time[1].ToString()); SecondsSessionDropDown_1.SelectedIndex = Int32.Parse(Row.Time[3].ToString()); SecondsSessionDropDown_2.SelectedIndex = Int32.Parse(Row.Time[4].ToString()); //2. SET EVENT EventsDropDown.Items.Clear(); EventID = Row.EventID; //EventsDropDown.SelectedIndex = E_Selected; //MessageBox.Show(Row.EventID.ToString()); //3. SET SQUAD SessionSquadDropDown.Items.Clear(); SessionSquadDropDown.Items.Add(Fixture_Data.HomeName); SessionSquadDropDown.Items.Add(Fixture_Data.AwayName); if (Row.SID == Fixture_Data.HomeTeam) { SessionSquadDropDown.SelectedIndex = 0; } else { SessionSquadDropDown.SelectedIndex = 1; } if (Row.EventID == 30 || Row.EventID == 28) { SessionPalayerWrapa.Visibility = Visibility.Hidden; SessionPlayerDropDown.SelectedIndex = 0; } else { SessionPalayerWrapa.Visibility = Visibility.Visible; //get team Teams Ts = new Teams(); List Team = Ts.GetTeam(FID, Row.SID); Team_Data = Team; SessionPlayerDropDown.Items.Clear(); int E = 0; int E_Selected = -1; foreach (Teams item in Team) { if (item.UserID == Row.PlayerID) { E_Selected = E; } E++; SessionPlayerDropDown.Items.Add(item.FullName + " (" + item.Jersey + ")"); } SessionPlayerDropDown.SelectedIndex = E_Selected; } SessionEdit_Popup.Visibility = Visibility.Visible; } private void Edit_Clicked(object sender, MouseButtonEventArgs e) { Border btn = (Border)sender; string id = btn.Uid; CommentaryID = id; Comments Row = Comments.GetRow(CommentaryID); Commentry_Edit_Data = Row; SessionDropDown.SelectedIndex = Int32.Parse(Row.Session.ToString()); //1. SET TIME MinutesDropDown_1.SelectedIndex = Int32.Parse(Row.Time[0].ToString()); MinutesDropDown_2.SelectedIndex = Int32.Parse(Row.Time[1].ToString()); SecondsDropDown_1.SelectedIndex = Int32.Parse(Row.Time[3].ToString()); SecondsDropDown_2.SelectedIndex = Int32.Parse(Row.Time[4].ToString()); //2. SET EVENT EventsDropDown.Items.Clear(); int E = 0; int E_Selected = -1; foreach (Events item in Events_Data) { if (item.CEID == Row.EventID) { E_Selected = E; } E++; EventsDropDown.Items.Add(item.CommName); } EventsDropDown.SelectedIndex = E_Selected; //3. SET SQUAD SquadDropDown.Items.Clear(); SquadDropDown.Items.Add(Fixture_Data.HomeName); SquadDropDown.Items.Add(Fixture_Data.AwayName); if (Row.SID == Fixture_Data.HomeTeam) { SquadDropDown.SelectedIndex = 0; } else { SquadDropDown.SelectedIndex = 1; } Reason.Text = Row.Comment; Edit_Popup.Visibility = Visibility.Visible; } private void Delete_Clicked(object sender, MouseButtonEventArgs e) { Border btn = (Border)sender; string id = btn.Uid; CommentaryID = id; Popup_Content.Text = "Your are about to delete an Commentary entry, please confirm the delete action by clicking the Confirm Button below"; Delete_Btn.Visibility = Visibility.Visible; Confirmation_Popup.Visibility = Visibility.Visible; } private void Cancel_delete(object sender, MouseButtonEventArgs e) { CommentaryID = ""; Confirmation_Popup.Visibility = Visibility.Hidden; ResetValues(); } private void Confrim_delete(object sender, MouseButtonEventArgs e) { if (CommentaryID != "") { Comments comment = Comments.GetRow(CommentaryID); Cards card = new Cards(); if (comment.EventID == 40 || comment.EventID == 43 || comment.EventID == 44 || comment.EventID == 45 || comment.EventID == 46 || comment.EventID == 48 || comment.EventID == 49 || comment.EventID == 50 || comment.EventID == 51 || comment.EventID == 55 || comment.EventID == 57) { Teams DB = new Teams(); bool foundCard = false; for (int i = 0; i < allCards.Count; i++) { if (allCards[i].FID == comment.FID && allCards[i].SID == comment.SID && allCards[i].EventID == comment.EventID && allCards[i].PlayerID == comment.PlayerID && allCards[i].ReplacementID == comment.ReplacementID) { foundCard = true; i = allCards.Count - 1; try { Grid grid = (Grid)this.FindName(allCards[i].Identfier); if (grid != null) { HomePlayers_Cards.Children.Remove(grid); HomePlayers_Subs.Children.Remove(grid); } var element = (Grid)this.FindName(allCards[i].Identfier); if (element != null) { AwayPlayers_Cards.Children.Remove(element); AwayPlayers_Subs.Children.Remove(element); } } catch (Exception) { } } } Teams pSubOff = DB.GetPlayer(comment.FID, comment.SID, comment.PlayerID); Teams pSubOn = DB.GetPlayer(comment.FID, comment.SID, comment.ReplacementID); UpdatePosition(comment.PlayerID, pSubOn.CurrentPos, comment.FID, comment.SID); UpdatePosition(comment.ReplacementID, pSubOff.CurrentPos, comment.FID, comment.SID); } else if (comment.EventID == 11 || comment.EventID == 14) { string sql_string = "UPDATE Teams SET " + " Location = '" + 0 + "'," + " Started = '" + 0 + "'" + " WHERE FID = '" + comment.FID + "' AND SID = '" + comment.SID + "' AND UserID = '" + comment.PlayerID + "' ; "; SqlDatabase SQL = new SqlDatabase(); bool done = SQL.Execute(sql_string); bool foundCard = false; for (int i = 0; i < allCards.Count; i++) { if (allCards[i].FID == comment.FID && allCards[i].SID == comment.SID && allCards[i].EventID == comment.EventID && allCards[i].PlayerID == comment.PlayerID && allCards[i].ReplacementID == comment.ReplacementID) { foundCard = true; i = allCards.Count - 1; try { Grid grid = (Grid)this.FindName(allCards[i].Identfier); if (grid != null) { HomePlayers_Cards.Children.Remove(grid); HomePlayers_Subs.Children.Remove(grid); } var element = (Grid)this.FindName(allCards[i].Identfier); if (element != null) { AwayPlayers_Cards.Children.Remove(element); AwayPlayers_Subs.Children.Remove(element); } } catch (Exception) { } } } } else if (comment.EventID == 12) { string sql_string = "UPDATE Teams SET " + " Location = '" + 3 + "'," + " Started = '" + 0 + "'" + " WHERE FID = '" + comment.FID + "' AND SID = '" + comment.SID + "' AND UserID = '" + comment.PlayerID + "' ; "; SqlDatabase SQL = new SqlDatabase(); bool done = SQL.Execute(sql_string); } SqlDatabase sql = new SqlDatabase(); string query = "DELETE FROM Commentary WHERE ID = '" + CommentaryID + "'"; bool delete = sql.Execute(query); if (delete) { GetFixture(); } CommentaryID = ""; Confirmation_Popup.Visibility = Visibility.Hidden; } } private void PenaltyTry_Process(object sender, MouseButtonEventArgs e) { Process_Data(); Confirmation_Popup.Visibility = Visibility.Hidden; } private void GetFixture() { scoreData.SetScore(FID); Fixtures Fxts = new Fixtures(); Fixtures fixture = Fxts.GetFixture(FID); Fixture_Data = fixture; int HomeTeam = 0; int AwayTeam = 0; int Code = 0; Code = Convert.ToInt32(fixture.Code); FID = Convert.ToInt32(fixture.FID); HomeTeam = Convert.ToInt32(fixture.HomeTeam); AwayTeam = Convert.ToInt32(fixture.AwayTeam); FixtureName.Text = Convert.ToString(fixture.TournName) + " | " + Convert.ToString(fixture.HomeName) + " vs " + Convert.ToString(fixture.AwayName) + " - " + Convert.ToString(fixture.StartTime).Substring(0, 5) + " - " + Convert.ToString(fixture.Location) + ""; Home_TeamName.Text = Convert.ToString(fixture.HomeName); Away_TeamName.Text = Convert.ToString(fixture.AwayName); Game_status = fixture.Game_status; Game_Paused = fixture.Game_Paused; Score_Data = scoreData.GetScore(FID); Home_Tries.Text = Score_Data.H_Try.ToString(); Home_Conversions.Text = Score_Data.H_Convertion.ToString(); Home_Penalties.Text = Score_Data.H_Penalty.ToString(); Home_PenaltyTry.Text = Score_Data.H_PenaltyTry.ToString(); Home_DropGoals.Text = Score_Data.H_Dropgoal.ToString(); Home_Subs.Text = Score_Data.H_Subs.ToString(); Home_YelloCards.Text = Score_Data.H_YellowCards.ToString(); Home_RedCards.Text = Score_Data.H_RedCards.ToString(); Home_FScore.Text = Score_Data.H_FS.ToString(); Home_HScore.Text = Score_Data.H_HS.ToString(); Away_Tries.Text = Score_Data.A_Try.ToString(); Away_Conversions.Text = Score_Data.A_Convertion.ToString(); Away_Penalties.Text = Score_Data.A_Penalty.ToString(); Away_PenaltyTry.Text = Score_Data.A_PenaltyTry.ToString(); Away_DropGoal.Text = Score_Data.A_Dropgoal.ToString(); Away_Subs.Text = Score_Data.A_Subs.ToString(); Away_YellowCards.Text = Score_Data.A_YellowCards.ToString(); Away_RedCards.Text = Score_Data.A_RedCards.ToString(); Away_FScore.Text = Score_Data.A_FS.ToString(); Away_HScore.Text = Score_Data.A_HS.ToString(); GetEvents(); getCommentary(); } private void GetSession() { switch (Fixture_Data.Game_status) { case 0: //1H Started Session = 0; break; case 1: //1H Started Session = 0; break; case 2: //1H END Session = 0; //set_half_time = 1; break; case 3: //2H Started Session = 1; break; case 4: //2H END Session = 1; break; case 5: //Xtra 1H Started Session = 2; break; case 6: //Xtra 1H End Session = 2; break; case 7: // Xtra 2H Started Session = 3; break; case 8: // Xtra 2H END Session = 3; break; case 9: // END Session = 3; break; case 10: // COMPLETED Session = 3; break; } } private void Download_data(object sender, MouseButtonEventArgs e) { Teams TeamDB = new Teams(); TeamDB.DeleteAllTeam(); Webservices Services = new Webservices(); Services.USERID = USERID; Services.DownloadingProgress = ProgressBarBox; Services.DownloadingProgressText = ProgressBarBoxText; Services.ProgressPopup = DownloadingProgress; DownloadingProgress.Visibility = Visibility.Visible; Services.GetNewData(); GetFixture(); } private void Away_Cancel_Button(object sender, MouseButtonEventArgs e) { if (GAMESTARTED == 1) { Start_Session(); } else { ResetValues(); } } private void Home_Cancel_Button(object sender, MouseButtonEventArgs e) { if (GAMESTARTED == 1) { Start_Session(); } else { ResetValues(); } } public static String GetTimestamp(DateTime value) { return value.ToString("yyyyMMddHHmmssffff"); } private void Red_Card_Process_Data() { Guid guid = Guid.NewGuid(); string ID = guid.ToString(); //string Time = Playing_Time.Text; //var time_split = Time.Split(':'); Teams DB = new Teams(); Teams Player = DB.GetPlayer(FID, TeamID, Player_ID); int UserID = Player.UserID; Grid Maingrd = new Grid(); var identifier = "R" + DateTime.Now.ToString("ddddddMMMMyyyyHHmmss"); Maingrd.Uid = UserID.ToString(); Maingrd.Margin = new Thickness(10, 30, 0, 20); Maingrd.Background = Brushes.Red; RowDefinition row1 = new RowDefinition(); //RowDefinition row2 = new RowDefinition(); row1.Height = new GridLength(40); //row2.Height = new GridLength(40); Maingrd.RowDefinitions.Add(row1); ///Maingrd.RowDefinitions.Add(row2); //Add Text TextBlock Title = new TextBlock(); Title.Text = "(" + Player.Jersey.ToString() + ") Red Card"; Title.FontSize = 14; Title.FontWeight = FontWeights.Bold; Title.TextAlignment = TextAlignment.Center; Title.VerticalAlignment = VerticalAlignment.Center; Title.Margin = new Thickness(10); Grid GRD = new Grid(); Grid.SetRow(Title, 0); Grid.SetRow(GRD, 1); Maingrd.Children.Add(Title); Maingrd.Children.Add(GRD); if (SID == Fixture_Data.HomeTeam) { HomePlayers_Cards.Children.Add(Maingrd); HomePlayers_Cards.RegisterName(identifier, Maingrd); } else if (SID == Fixture_Data.AwayTeam) { AwayPlayers_Cards.Children.Add(Maingrd); AwayPlayers_Cards.RegisterName(identifier, Maingrd); } UpdateLocation_HasStarted(Player_ID, FID, SID, 4); allCards.Add(new Cards { FID = Player.FID, SID = Player.SID, EventID = 14, PlayerID = Player.UserID, ReplacementID = null, Identfier = identifier }); ResetValues(); } private void Second_Yellow_Card_Process_Data() { Guid guid = Guid.NewGuid(); string ID = guid.ToString(); string Time = Game_Duration.Text; var time_split = Time.Split(':'); //int Session = 0; int No = Convert.ToInt32(time_split[0] + time_split[1]); string sql_string = "insert into Commentary (FID, ID,Time,Session,SID," + "EventID,PlayerID,ReplcamentID,SquadName,EventName,ReplacementName,PlayerName,No,Comment)" + " values ('" + FID + "', '" + ID + "','" + Playing_Time.Text + "','" + Session + "'," + "'" + TeamID + "','" + EventID + "','" + Player_ID + "','" + Replacemant_ID + "'," + "'" + SquadName + "','" + EventName + "','" + ReplacementName + "','" + PlayerName + "','" + No + "','" + Commentary + "')"; Comments Comm = new Comments(); bool Saved = Comm.insertData(sql_string); if (Saved == true) { Commentary = "Second Yellow Card"; EventName = "Red Card"; EventID = 14; UpdateLocation_HasStarted(Player_ID, FID, SID, 4); ResetValues(); } else { MessageBox.Show("Did not save!"); } } private void Process_Data(int set_time = 0) { Guid guid = Guid.NewGuid(); string ID = guid.ToString(); string Timerr = Game_Duration.Text; if (set_time == 1) { Time = Timerr; if (EventID == 29) { if (string.IsNullOrEmpty(Fixture_Data.HalfTime)) { Time = "40:00"; //default to 40 mins if empty } else { Time = Fixture_Data.HalfTime + ":00"; } set_half_time = 1; Playing_Time.Text = Time; } } Time = Game_Duration.Text; var time_split = Time.Split(':'); int No = 0; try { No = Convert.ToInt32(time_split[0] + time_split[1]); } catch { } string sql_string = "insert into Commentary (FID, ID,Time,Session,SID," + "EventID,PlayerID,ReplcamentID,SquadName,EventName,ReplacementName,PlayerName,No,Comment)" + " values ('" + FID + "', '" + ID + "','" + Playing_Time.Text + "','" + Session + "'," + "'" + TeamID + "','" + EventID + "','" + Player_ID + "','" + Replacemant_ID + "'," + "'" + SquadName + "','" + EventName + "','" + ReplacementName + "','" + PlayerName + "','" + No + "','" + Commentary + "')"; Comments Comm = new Comments(); bool Saved = Comm.insertData(sql_string); if (Saved == true) { if (Subs == 1) { SubsPositonUpdate(); } getCommentary(); } else { MessageBox.Show("Did not save!"); } ResetValues(); GetFixture(); } private void SubsPositonUpdate() { //clearPlayers(); Teams DB = new Teams(); Teams Player = DB.GetPlayer(FID, TeamID, Player_ID); Teams Replacement = DB.GetPlayer(FID, TeamID, Replacemant_ID); //Update Player bool Plr = UpdatePosition(Player_ID, Replacement.CurrentPos, FID, TeamID); if (Plr == true) { bool Rps = UpdatePosition(Replacemant_ID, Player.CurrentPos, FID, TeamID); } } private void Hide_Click(object sender, RoutedEventArgs e) { } private void Manuel_Cancel_Events(object sender, RoutedEventArgs e) { FooterMainButtonsArea.Visibility = Visibility.Visible; Scoller_Bg.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#576d8e")); Scoller_Bg2.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#576d8e")); ResetValues(); } private void Back_to_Fixtures(object sender, MouseButtonEventArgs e) { BackPopup.IsOpen = true; } private void Tab_Open(object sender, MouseButtonEventArgs e) { //Tab.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#576d8e")); Border grd = (Border)sender; string Tab = grd.Name; var Splitter = Tab.Split('_'); int numberIndex = Convert.ToInt32(Splitter[1]); int Number = Convert.ToInt32(Splitter[1]); Tab_1.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#2e405b")); Tab_2.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#2e405b")); Tab_3.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#2e405b")); Tab_4.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#2e405b")); Tab_5.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#2e405b")); Tab_1_Test.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#576d8e")); Tab_2_Test.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#576d8e")); Tab_3_Test.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#576d8e")); Tab_4_Test.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#576d8e")); Tab_5_Test.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#576d8e")); Content_1.Visibility = Visibility.Hidden; Content_2.Visibility = Visibility.Hidden; Content_3.Visibility = Visibility.Hidden; Content_4.Visibility = Visibility.Hidden; Content_5.Visibility = Visibility.Hidden; if (numberIndex == 1) { Content_1.Visibility = Visibility.Visible; Tab_1.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#576d8e")); Tab_1_Test.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#ffffff")); } if (numberIndex == 2) { Content_2.Visibility = Visibility.Visible; Tab_2.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#576d8e")); Tab_2_Test.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#ffffff")); } if (numberIndex == 3) { Content_3.Visibility = Visibility.Visible; Tab_3.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#576d8e")); Tab_3_Test.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#ffffff")); } if (numberIndex == 4) { Content_4.Visibility = Visibility.Visible; Tab_4.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#576d8e")); Tab_4_Test.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#ffffff")); } if (numberIndex == 5) { Content_5.Visibility = Visibility.Visible; Tab_5.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#576d8e")); Tab_5_Test.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#ffffff")); } } public Dictionary dict = new Dictionary(); private int check_yellow_cards() { Comments Commentary = new Comments(); int yellowcards = Commentary.Count_YellowCards_Player(FID, Player_ID); return yellowcards; } private void CreateTimers() { int YellowCards = check_yellow_cards(); if (YellowCards == 0) { // Teams DB = new Teams(); Teams Player = DB.GetPlayer(FID, TeamID, Player_ID); int UserID = Player.UserID; Grid Maingrd = new Grid(); //Maingrd.MouseDown += new MouseButtonEventHandler(YellowPlayer_clicked); var identifier = "Y" + DateTime.Now.ToString("ddddddMMMMyyyyHHmmss"); Maingrd.Uid = UserID.ToString(); Maingrd.Margin = new Thickness(10, 30, 0, 20); Maingrd.Background = Brushes.Yellow; RowDefinition row1 = new RowDefinition(); RowDefinition row2 = new RowDefinition(); row1.Height = new GridLength(40); row2.Height = new GridLength(40); Maingrd.RowDefinitions.Add(row1); Maingrd.RowDefinitions.Add(row2); //Add Text TextBlock Title = new TextBlock(); Title.Text = "Yellow Card"; Title.FontSize = 14; Title.FontWeight = FontWeights.Bold; Title.TextAlignment = TextAlignment.Center; Title.VerticalAlignment = VerticalAlignment.Center; Title.Margin = new Thickness(10); Grid GRD = new Grid(); Grid.SetRow(Title, 0); Grid.SetRow(GRD, 1); Maingrd.Children.Add(Title); Maingrd.Children.Add(GRD); ColumnDefinition Col1 = new ColumnDefinition(); ColumnDefinition Col2 = new ColumnDefinition(); Col1.Width = new GridLength(45); Col2.Width = new GridLength(65); GRD.ColumnDefinitions.Add(Col1); GRD.ColumnDefinitions.Add(Col2); TextBlock Number = new TextBlock(); Number.Text = Player.Jersey.ToString(); Number.FontSize = 16; Number.FontWeight = FontWeights.Bold; Number.TextAlignment = TextAlignment.Center; Number.VerticalAlignment = VerticalAlignment.Center; TextBlock Timm = new TextBlock(); Timm.Uid = UserID.ToString() + "|" + FID + "|" + SID + "|" + identifier; Timm.FontSize = 50; Timm.FontSize = 16; Timm.FontWeight = FontWeights.Bold; Timm.TextAlignment = TextAlignment.Center; Timm.VerticalAlignment = VerticalAlignment.Center; Timm.Text = "Start"; Timm.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#F00")); Timm.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#fff")); Timm.Margin = new Thickness(5, 0, 5, 0); Timm.MouseDown += new MouseButtonEventHandler(Start_Clock_Clicked); /* */ Border BRD = new Border(); BRD.BorderBrush = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#999")); BRD.BorderThickness = new Thickness(0, 0, 1, 0); BRD.Child = Number; Grid.SetColumn(BRD, 0); Grid.SetColumn(Timm, 1); GRD.Children.Add(BRD); GRD.Children.Add(Timm); //Check Team if (SID == Fixture_Data.HomeTeam) { HomePlayers_Cards.Children.Add(Maingrd); HomePlayers_Cards.RegisterName(identifier, Maingrd); } else if (SID == Fixture_Data.AwayTeam) { AwayPlayers_Cards.Children.Add(Maingrd); AwayPlayers_Cards.RegisterName(identifier, Maingrd); } //Update Player Location UpdateLocation(Player_ID, FID, SID, 3, 0); allCards.Add(new Cards { FID = Player.FID, SID = Player.SID, EventID = EventID, PlayerID = Player.UserID, ReplacementID = null, Identfier = identifier }); } else { //Second yellow card Commentary = "Second Yellow Card"; Second_Yellow_Card_Process_Data(); } } private void Start_Injury_Clock_Clicked(object sender, MouseButtonEventArgs e) { TextBlock Timm = (TextBlock)sender; Grid gridd = (Grid)Timm.Parent; Grid block = (Grid)gridd.Parent; TextBlock text = (TextBlock)block.Children[0]; if (Timm.Text != "Start") { return; } var time_arr = Timm.Uid.Split('|'); var timerFirst = time_arr[3]; Timm.Uid = timerFirst; gridd.Uid = time_arr[0]; Timm.FontSize = 50; Timm.FontSize = 16; Timm.FontWeight = FontWeights.Bold; Timm.TextAlignment = TextAlignment.Center; Timm.VerticalAlignment = VerticalAlignment.Center; Timm.Text = "00:00"; if (text.Text == "Blood") { Timm.Name = Convert.ToString("Sec_" + timesecBloodTimer); } else if (text.Text == "Concussion") { Timm.Name = Convert.ToString("Sec_" + timesecHIATimer); } DispatcherTimer dispatcherTimer = new DispatcherTimer(); dispatcherTimer.Tick += new EventHandler(outInjuryTimer_Tick); dispatcherTimer.Tag = gridd; dispatcherTimer.Interval = new TimeSpan(0, 0, 1); dispatcherTimer.Start(); gridd.Children.RemoveAt(1); gridd.Children.Add(Timm); Grid.SetColumn(Timm, 1); } private void RemoveInjuryCard(object sender, MouseButtonEventArgs e) { try { TextBlock button = (TextBlock)sender; var block = (TextBlock)sender; Grid grid = (Grid)this.Home_Subs.FindName(block.Uid); if (grid != null) { HomePlayers_Cards.Children.Remove(grid); } var element = (Grid)this.AwayPlayers_Cards.FindName(block.Uid); if (element != null) { AwayPlayers_Cards.Children.Remove(element); } e.Handled = true; } catch (Exception) { } } private void outInjuryTimer_Tick(object sender, EventArgs e) { var timersource = (DispatcherTimer)sender; Grid btn = (Grid)timersource.Tag; Border BRDR = (Border)btn.Children[0]; TextBlock text = (TextBlock)BRDR.Child; var _Split = text.Uid.Split('|'); //int Player_ID = Convert.ToInt32(_Split[0]); //int F_ID = Convert.ToInt32(_Split[1]); //int S_ID = Convert.ToInt32(_Split[2]); //int sub_ID = Convert.ToInt32(_Split[3]); //var identifier = _Split[4]; var eventId = Convert.ToInt32(_Split[5]); //TextBlock Timm = (TextBlock)sender; //Grid gridd = (Grid)Timm.Parent; //Grid block = (Grid)gridd.Parent; //TextBlock text = (TextBlock)block.Children[0]; var jerseryNumber = btn.Uid; TextBlock Timm = (TextBlock)btn.Children[2]; int out_time = 0; if (eventId == 45) { out_time = Fixture_Data.BloodTimer - 1; } else if (eventId == 40) { out_time = Fixture_Data.HIATimer - 1; } var splittime_injury = Timm.Uid.Split(':'); var curTime = Game_Duration.Text; var splittime_curr = curTime.Split(':'); TimeSpan duration = (new System.TimeSpan(0, 0, int.Parse(splittime_curr[0]), int.Parse(splittime_curr[1])).Subtract(new System.TimeSpan(0, 0, int.Parse(splittime_injury[0]), int.Parse(splittime_injury[1])))); Timm.Text = duration.ToString().Substring(3); if (duration > new TimeSpan(0, out_time, 30)) { Timm.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#fff")); Timm.Background = Brushes.Red; if (duration.Seconds % 2 == 0) { Timm.Background = Brushes.White; //Timm.Text = ""; //give a flashing visual } } Timm.FontSize = 16; Timm.FontWeight = FontWeights.Bold; Timm.TextAlignment = TextAlignment.Center; Timm.VerticalAlignment = VerticalAlignment.Center; Timm.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#55AE3A")); if (duration > new TimeSpan(0, out_time, 59)) { //Timm.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#fff")); ////Timm.Foreground = Brushes.Red; //Timm.Text = "Return" + Environment.NewLine + "decison:" + Environment.NewLine + jerseryNumber; //Timm.FontSize = 10; //Timm.Background = Brushes.Red; //Timm.MouseDown += new MouseButtonEventHandler(RemoveInjuryCard); //ReturnPlayerPopUp.IsOpen = true; // ReturnPlayerPopUp.Visibility = Visibility.Visible; // var child = (TextBlock)ReturnPlayerPopUp.Child; // child.Text = "Return decison:" + Environment.NewLine + jerseryNumber; // ReturnPlayerPopUp.MouseDown += ReturnPlayerPopUp_MouseDown; // timersource.Stop(); } //btn.MouseDown += new MouseButtonEventHandler(RemoveInjuryCard); btn.Children.RemoveAt(2); btn.Children.Add(Timm); Grid.SetColumn(Timm, 1); } private void ReturnPlayerPopUp_MouseDown(object sender, MouseButtonEventArgs e) { ReturnPlayerPopUp.IsOpen = false; } private void Start_Clock_Clicked(object sender, MouseButtonEventArgs e) { TextBlock btn = (TextBlock)sender; Grid gridd = (Grid)btn.Parent; TextBlock Timm = new TextBlock(); Timm.Uid = btn.Uid; Timm.FontSize = 50; Timm.FontSize = 16; Timm.FontWeight = FontWeights.Bold; Timm.TextAlignment = TextAlignment.Center; Timm.VerticalAlignment = VerticalAlignment.Center; Timm.Name = Convert.ToString("Sec_" + timesecYellowCardTimer); int min = timesecYellowCardTimer / 60; int sec = timesecYellowCardTimer % 60; if (min < 10 && sec < 10) { Timm.Text = string.Format("0{0}:0{1}", min, sec); } else if (min < 10 && sec > 9) { Timm.Text = string.Format("0{0}:{1}", min, sec); } else if (min > 9 && sec < 10) { Timm.Text = string.Format("{0}:0{1}", min, sec); } else if (min > 9 && sec > 9) { Timm.Text = string.Format("{0}:{1}", min, sec); } gridd.Children.RemoveAt(1); gridd.Children.Add(Timm); Grid.SetColumn(Timm, 1); DispatcherTimer timer = new DispatcherTimer(); timer.Tick += timer_Ticke; //timer.Elapsed += new EventHandler(timer_Tick); timer.Interval = new TimeSpan(0, 0, 1); timer.Tag = gridd; dict[timer] = Timm; timer.Start(); var Splitter = btn.Uid.Split('|'); string sql_string = "UPDATE Teams SET " + " Location = '3'," + " Started = '1'" + " WHERE FID = '" + Convert.ToInt32(Splitter[1]) + "' AND SID = '" + Convert.ToInt32(Splitter[2]) + "' AND UserID = '" + Convert.ToInt32(Splitter[0]) + "' ; "; } private void UpdateDatBaseYellowCardTimers(Teams DATA) { //MessageBox.Show(DATA.Returned.ToString()); if (DATA.Returned != 1) { int UserID = DATA.UserID; Grid Maingrd = new Grid(); //Maingrd.MouseDown += new MouseButtonEventHandler(YellowPlayer_clicked); var identifier = "Y" + DateTime.Now.ToString("ddddddMMMMyyyyHHmmss"); Maingrd.Uid = UserID.ToString(); Maingrd.Margin = new Thickness(10, 30, 0, 20); Maingrd.Background = Brushes.Yellow; RowDefinition row1 = new RowDefinition(); RowDefinition row2 = new RowDefinition(); row1.Height = new GridLength(40); row2.Height = new GridLength(40); Maingrd.RowDefinitions.Add(row1); Maingrd.RowDefinitions.Add(row2); //Add Text TextBlock Title = new TextBlock(); Title.Text = "Yellow Card"; Title.FontSize = 14; Title.FontWeight = FontWeights.Bold; Title.TextAlignment = TextAlignment.Center; Title.VerticalAlignment = VerticalAlignment.Center; Title.Margin = new Thickness(10); Grid GRD = new Grid(); Grid.SetRow(Title, 0); Grid.SetRow(GRD, 1); Maingrd.Children.Add(Title); Maingrd.Children.Add(GRD); ColumnDefinition Col1 = new ColumnDefinition(); ColumnDefinition Col2 = new ColumnDefinition(); Col1.Width = new GridLength(45); Col2.Width = new GridLength(65); GRD.ColumnDefinitions.Add(Col1); GRD.ColumnDefinitions.Add(Col2); TextBlock Number = new TextBlock(); Number.Text = DATA.Jersey.ToString(); Number.FontSize = 18; Number.FontWeight = FontWeights.Bold; Number.TextAlignment = TextAlignment.Center; Number.VerticalAlignment = VerticalAlignment.Center; TextBlock Timm = new TextBlock(); Timm.FontSize = 50; Timm.FontSize = 18; Timm.FontWeight = FontWeights.Bold; Timm.TextAlignment = TextAlignment.Center; Timm.VerticalAlignment = VerticalAlignment.Center; if (DATA.Started == 1 && DATA.Returned == 0 && DATA.Time > 0) { //Timm.Uid = UserID.ToString() + "|" + DATA.FID + "|" + DATA.SID; Timm.Uid = UserID.ToString() + "|" + DATA.FID + "|" + DATA.SID + "|" + identifier; Timm.Name = Convert.ToString("Sec_" + DATA.Time); int min = timesecYellowCardTimer / 60; int sec = timesecYellowCardTimer % 60; if (min < 10 && sec < 10) { Timm.Text = string.Format("0{0}:0{1}", min, sec); } else if (min < 10 && sec > 9) { Timm.Text = string.Format("0{0}:{1}", min, sec); } else if (min > 9 && sec < 10) { Timm.Text = string.Format("{0}:0{1}", min, sec); } else if (min > 9 && sec > 9) { Timm.Text = string.Format("{0}:{1}", min, sec); } DispatcherTimer timer = new DispatcherTimer(); timesecYellowCardTimer = DATA.Time; timer.Tick += timer_Ticke; //timer.Elapsed += new EventHandler(timer_Tick); timer.Interval = new TimeSpan(0, 0, 1); dict[timer] = Timm; timer.Start(); } else if (DATA.Started == 1 && DATA.Returned == 0 && DATA.Time == 0) { //MessageBox.Show(DATA.Time.ToString() + " | " + DATA.UserID); //Timm.Uid = UserID.ToString() + "|" + DATA.FID + "|" + DATA.SID; Timm.Uid = UserID.ToString() + "|" + DATA.FID + "|" + DATA.SID + "|" + identifier; Timm.FontSize = 50; Timm.FontSize = 18; Timm.FontWeight = FontWeights.Bold; Timm.TextAlignment = TextAlignment.Center; Timm.VerticalAlignment = VerticalAlignment.Center; Timm.Text = "Return"; Timm.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#006631")); Timm.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#fff")); Timm.Margin = new Thickness(5, 0, 5, 0); Timm.MouseDown += new MouseButtonEventHandler(Yellow_Card_Return_Clicked); } else { //Timm.Uid = UserID.ToString() + "|" + DATA.FID + "|" + DATA.SID; Timm.Uid = UserID.ToString() + "|" + DATA.FID + "|" + DATA.SID + "|" + identifier; Timm.Text = "Start"; Timm.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#F00")); Timm.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#fff")); Timm.Margin = new Thickness(5, 0, 5, 0); Timm.MouseDown += new MouseButtonEventHandler(Start_Clock_Clicked); } Border BRD = new Border(); BRD.BorderBrush = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#999")); BRD.BorderThickness = new Thickness(0, 0, 1, 0); BRD.Child = Number; //Check Team if (DATA.SID == Fixture_Data.HomeTeam) { HomePlayers_Cards.Children.Add(Maingrd); HomePlayers_Cards.RegisterName(identifier, Maingrd); } else if (DATA.SID == Fixture_Data.AwayTeam) { AwayPlayers_Cards.Children.Add(Maingrd); AwayPlayers_Cards.RegisterName(identifier, Maingrd); } Grid.SetColumn(BRD, 0); Grid.SetColumn(Timm, 1); GRD.Children.Add(BRD); GRD.Children.Add(Timm); //Update Player Location //UpdateLocation(Player_ID, FID, SID); allCards.Add(new Cards { FID = DATA.FID, SID = DATA.SID, EventID = 11, PlayerID = DATA.UserID, ReplacementID = null, Identfier = identifier }); ResetValues(); } } private void UpdateDatBaseRedCards(Teams DATA) { int UserID = DATA.UserID; Grid Maingrd = new Grid(); var identifier = "R" + DateTime.Now.ToString("ddddddMMMMyyyyHHmmss"); Maingrd.Uid = UserID.ToString(); Maingrd.Margin = new Thickness(10, 30, 0, 20); Maingrd.Background = Brushes.Red; RowDefinition row1 = new RowDefinition(); //RowDefinition row2 = new RowDefinition(); row1.Height = new GridLength(40); //row2.Height = new GridLength(40); Maingrd.RowDefinitions.Add(row1); //Maingrd.RowDefinitions.Add(row2); //Add Text TextBlock Title = new TextBlock(); Title.Text = "(" + DATA.Jersey.ToString() + ") Red Card"; Title.FontSize = 14; Title.FontWeight = FontWeights.Bold; Title.TextAlignment = TextAlignment.Center; Title.VerticalAlignment = VerticalAlignment.Center; Title.Margin = new Thickness(10); Grid GRD = new Grid(); Grid.SetRow(Title, 0); Grid.SetRow(GRD, 1); Maingrd.Children.Add(Title); Maingrd.Children.Add(GRD); //ColumnDefinition Col1 = new ColumnDefinition(); ////ColumnDefinition Col2 = new ColumnDefinition(); //Col1.Width = new GridLength(45); ////Col2.Width = new GridLength(65); //GRD.ColumnDefinitions.Add(Col1); ////GRD.ColumnDefinitions.Add(Col2); //TextBlock Number = new TextBlock(); //Number.Text = DATA.Jersey.ToString(); //Number.FontSize = 16; //Number.FontWeight = FontWeights.Bold; //Number.TextAlignment = TextAlignment.Center; //Number.VerticalAlignment = VerticalAlignment.Center; //Border BRD = new Border(); //BRD.BorderBrush = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#999")); //BRD.BorderThickness = new Thickness(0, 0, 1, 0); //BRD.Child = Number; //Grid.SetColumn(BRD, 0); //GRD.Children.Add(BRD); if (DATA.SID == Fixture_Data.HomeTeam) { HomePlayers_Cards.Children.Add(Maingrd); } else if (DATA.SID == Fixture_Data.AwayTeam) { AwayPlayers_Cards.Children.Add(Maingrd); } allCards.Add(new Cards { FID = DATA.FID, SID = DATA.SID, EventID = 14, PlayerID = DATA.UserID, ReplacementID = null, Identfier = identifier }); ResetValues(); } private void LoadCurrentYellowCards() { try { HomePlayers_Cards.Children.Clear(); AwayPlayers_Cards.Children.Clear(); Teams Team = new Teams(); List HomeTeam = Team.GetYellowCards(FID, Fixture_Data.HomeTeam); foreach (Teams HT in HomeTeam) { //MessageBox.Show(HT.Returned.ToString()); UpdateDatBaseYellowCardTimers(HT); } List AwayTeam = Team.GetYellowCards(FID, Fixture_Data.AwayTeam); foreach (Teams AT in AwayTeam) { UpdateDatBaseYellowCardTimers(AT); } } catch { } } private void LoadCurrentRedCards() { try { //HomePlayers_Cards.Children.Clear(); //AwayPlayers_Cards.Children.Clear(); Teams Team = new Teams(); List HomeTeam = Team.GetRedCards(FID, Fixture_Data.HomeTeam); foreach (Teams HT in HomeTeam) { //MessageBox.Show(HT.Returned.ToString()); UpdateDatBaseRedCards(HT); } List AwayTeam = Team.GetRedCards(FID, Fixture_Data.AwayTeam); foreach (Teams AT in AwayTeam) { UpdateDatBaseRedCards(AT); } } catch { } } bool setIntialTime = false; bool wasPaused = false; int pausedTime = 0; private void timer_Ticke(object sender, EventArgs e) { DispatcherTimer t = (DispatcherTimer)sender; TextBlock l = dict[t]; int labelTime = 0; string Name = l.Name; var Splitter = Name.Split('_'); if (Int32.TryParse(Splitter[1], out labelTime)) { if (wasPaused) { labelTime = pausedTime; wasPaused = false; } if (!(Fixture_Data.Game_Paused == 1 || Game_status == 2)) { labelTime -= 1; } } if (labelTime >= 0) { l.Name = Convert.ToString("Sec_" + labelTime); int time = Int32.Parse(Splitter[1]) - 1; string[] IDS = Convert.ToString(l.Uid).Split('|'); UpdateTimerYellowLocation(Int32.Parse(IDS[0]), Int32.Parse(IDS[1]), Int32.Parse(IDS[2]), time); if (labelTime == 0) { t.Stop(); l.FontSize = 50; l.FontSize = 18; l.FontWeight = FontWeights.Bold; l.TextAlignment = TextAlignment.Center; l.VerticalAlignment = VerticalAlignment.Center; l.Text = "Return"; l.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#006631")); l.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#fff")); l.Margin = new Thickness(5, 0, 5, 0); l.MouseDown += new MouseButtonEventHandler(Yellow_Card_Return_Clicked); } else { if (Fixture_Data.Game_Paused == 1 || Game_status == 2) { //t.Stop(); if (!setIntialTime) { wasPaused = true; pausedTime = time; setIntialTime = true; } } else if (wasPaused) { time = pausedTime; setIntialTime = false; } else { int min = time / 60; int sec = time % 60; if (min == 0 && sec < 10) { if (time % 2 == 0) { l.Foreground = Brushes.Red; } else { l.Foreground = Brushes.Black; } } if (min < 10 && sec < 10) { l.Text = string.Format("0{0}:0{1}", min, sec); } else if (min < 10 && sec > 9) { l.Text = string.Format("0{0}:{1}", min, sec); } else if (min > 9 && sec < 10) { l.Text = string.Format("{0}:0{1}", min, sec); } else if (min > 9 && sec > 9) { l.Text = string.Format("{0}:{1}", min, sec); } } } } else { l.FontSize = 50; l.FontSize = 18; l.FontWeight = FontWeights.Bold; l.TextAlignment = TextAlignment.Center; l.VerticalAlignment = VerticalAlignment.Center; l.Text = "Return "; l.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#006631")); l.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#fff")); l.Margin = new Thickness(5, 0, 5, 0); l.MouseDown += new MouseButtonEventHandler(Yellow_Card_Return_Clicked); } } private bool UpdatePosition(int UserID, int Pos, int FID, int SID) { string sql_string = "UPDATE Teams SET " + " CurrentPos = '" + Pos + "' " + " WHERE FID = '" + FID + "' AND SID = '" + SID + "' AND UserID = '" + UserID + "' ; "; SqlDatabase SQL = new SqlDatabase(); bool done = SQL.Execute(sql_string); if (done) { return true; } else { return false; } } private bool UpdateLocation(int UserID, int FID, int SID, int location, int Started = 0) { string sql_string = "UPDATE Teams SET " + " Location = '" + location + "'," + " Started = '" + Started + "'" + " WHERE FID = '" + FID + "' AND SID = '" + SID + "' AND UserID = '" + UserID + "' ; "; SqlDatabase SQL = new SqlDatabase(); bool done = SQL.Execute(sql_string); if (done) { Process_Data(); return true; } else { return false; } } private bool UpdateLocation_HasStarted(int UserID, int FID, int SID, int location) { string sql_string = "UPDATE Teams SET " + " Location = '" + location + "' " + " WHERE FID = '" + FID + "' AND SID = '" + SID + "' AND UserID = '" + UserID + "' ; "; SqlDatabase SQL = new SqlDatabase(); bool done = SQL.Execute(sql_string); if (done) { Process_Data(); return true; } else { return false; } } private bool UpdateLocation_Return(int UserID, int FID, int SID, int returned) { SquadName = Fixture_Data.HomeName; if (Fixture_Data.AwayTeam == SID) { SquadName = Fixture_Data.AwayName; } Guid guid = Guid.NewGuid(); string ID = guid.ToString(); string Time = Game_Duration.Text; var time_split = Time.Split(':'); Teams PlayeDBr = new Teams(); Teams Player = PlayeDBr.GetPlayer(FID, SID, UserID); EventID = 12; Events evt = new Events(); Events Data = evt.GetEvent(EventID); EventName = Data.CommName; Group = Data.Group; //Time = time_playing; Player_ID = Player.UserID; PlayerName = Player.FirstName + " " + Player.LastName; //int Session = 0; int No = Convert.ToInt32(time_split[0] + time_split[1]); string sql_string = "insert into Commentary (FID, ID,Time,Session,SID," + "EventID,PlayerID,ReplcamentID,SquadName,EventName,ReplacementName,PlayerName,No,Comment)" + " values ('" + FID + "', '" + ID + "','" + Playing_Time.Text + "','" + Session + "'," + "'" + SID + "','" + EventID + "','" + UserID + "','" + Replacemant_ID + "'," + "'" + SquadName + "','" + EventName + "','" + ReplacementName + "','" + PlayerName + "','" + No + "','" + Commentary + "')"; Comments Comm = new Comments(); bool Saved = Comm.insertData(sql_string); var location = 0; sql_string = "UPDATE Teams SET " + " Location = '" + location + "'," + " Returned = '" + returned + "' " + " WHERE FID = '" + FID + "' AND SID = '" + SID + "' AND UserID = '" + UserID + "' ; "; SqlDatabase SQL = new SqlDatabase(); bool done = SQL.Execute(sql_string); if (done) { getCommentary(); return true; } else { return false; } } private bool UpdateTimerYellowLocation(int UserID, int FID, int SID, int Time) { string sql_string = "UPDATE Teams SET " + " Time = '" + Time + "' " + " WHERE FID = '" + FID + "' AND SID = '" + SID + "' AND UserID = '" + UserID + "' ; "; SqlDatabase SQL = new SqlDatabase(); bool done = SQL.Execute(sql_string); if (done) { return true; } else { return false; } } private void GetSessionButtons() { GetSession(); FooterMainButtonsArea.Children.Clear(); if (Game_status == 0) { time_playing = "00:00"; time_duration = "00:00"; time_stopped = "00:00"; StartGameBtb(); } else if (Game_status > 0) { time_playing = Fixture_Data.Playing_Time.ToString(); time_duration = Fixture_Data.Game_Duration.ToString(); time_stopped = Fixture_Data.Total_Stoppage.ToString(); if (set_half_time == 1) { if (string.IsNullOrEmpty(Fixture_Data.HalfTime.ToString())) { // time_playing = "40:00"; } else { time_playing = Fixture_Data.HalfTime.ToString() + ":00"; } set_half_time = 0; sw_stop_dur.Reset(); sw_pt.Reset(); sw_stop.Reset(); } Playing_Time.Text = time_playing; Game_Duration.Text = time_duration; Stoppage_Time.Text = time_stopped; if (Game_status == 1 || Game_status == 3 || Game_status == 5 || Game_status == 7) { //Hide HT Scores Home_HT_Label.Visibility = Visibility.Collapsed; Home_HScore.Visibility = Visibility.Collapsed; Away_HScore.Visibility = Visibility.Collapsed; Away_HT_Label.Visibility = Visibility.Collapsed; if (Game_Paused == 0) { //NOT PAUSED RESUME sw.Start(); ST.Start(); sw_pt.Start(); dt_pt.Start(); sw_stop_dur.Reset(); GetSessionBTNS(); PauseGameBtn(); Playing_Time.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#666")); } else { //STOP MAIN TIME sw.Stop(); //START STOPPEAGE TIME sw_stop.Start(); dt_stop.Start(); sw_stop_dur.Start(); dt_stop_dur.Start(); sw_pt.Start(); dt_pt.Start(); Playing_Time.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#F00")); ResumeGameBtn(); } } else if (Game_status == 2 || Game_status == 4 || Game_status == 6) { //HALF TIME //STOP MAIN TIME sw.Stop(); //START STOPPEAGE TIME sw_stop.Start(); dt_stop.Start(); sw_stop_dur.Start(); dt_stop_dur.Start(); sw_pt.Start(); dt_pt.Start(); Playing_Time.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#F00")); GetSessionBTNS(); } } else if (Game_status == 10) { Playing_Time.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#F00")); Game_Duration.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#F00")); if (sw.IsRunning) { sw.Stop(); } if (sw_pt.IsRunning) { sw_pt.Stop(); } if (sw_stop.IsRunning) { sw_stop.Stop(); } if (sw_stop_dur.IsRunning) { sw_stop_dur.Stop(); } } } private void PauseGameBtn() { string text = "Time OFF"; string ID = "01"; string Background = "Yellow"; TextBlock btn = CreateButtons(text, ID, Background, 1); FooterMainButtonsArea.Children.Add(btn); } private void ResumeGameBtn() { string text = "Time ON"; string ID = "02"; string Background = "Green"; TextBlock btn = CreateButtons(text, ID, Background); FooterMainButtonsArea.Children.Add(btn); } private TextBlock CreateButtons(string text, string ID, string Background, int color = 0) { TextBlock bt = new TextBlock(); bt.FontSize = 20; bt.Padding = new Thickness(20); bt.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString(Background)); if (color == 1) { bt.Foreground = Brushes.Black; } else { bt.Foreground = Brushes.White; } bt.Margin = new Thickness(10); bt.Uid = ID; bt.Text = text; bt.MouseDown += new MouseButtonEventHandler(buttons_rutine); return bt; } private void buttons_rutine(object sender, MouseButtonEventArgs e) { TextBlock btn = (TextBlock)sender; string ui = btn.Uid.ToString(); if (ui == "1") { Start_Game(sender, e); } if (ui == "2") { First_Half_End_Action(sender, e); } if (ui == "10") { GameEnd_Action(sender, e); } // Pause Actions if (ui == "01") //pause game { Pause_Game(sender, e); StoppagePopUp.Focus(); StoppagePopUp.IsOpen = true; } if (ui == "02") //pause game { Resume_Game(sender, e); StoppagePopUp.IsOpen = false; } } private void Start_Game(object sender, MouseButtonEventArgs e) { time_playing = "00:00"; Kickoff_HomeTeam.Text = Fixture_Data.HomeName; Kickoff_AwayTeam.Text = Fixture_Data.AwayName; GameStart_Popup.Visibility = Visibility.Visible; } private void First_Half_End_Action(object sender, MouseButtonEventArgs e) { if (sw.IsRunning) { //STOP MAIN TIME sw.Stop(); sw.Reset(); //START STOPPEAGE TIME sw_stop.Stop(); //dt_stop.Start(); //START STOPPEAGE DURATION TIME sw_stop_dur.Start(); dt_stop_dur.Start(); } Home_HT_Label.Visibility = Visibility.Visible; Home_HScore.Visibility = Visibility.Visible; Away_HScore.Visibility = Visibility.Visible; Away_HT_Label.Visibility = Visibility.Visible; Game_status++; string sql_string = "UPDATE Fixture SET " + " Game_status = '" + Game_status + "' " + " WHERE FID = '" + FID + "' ; "; SqlDatabase SQL = new SqlDatabase(); bool updated = SQL.Execute(sql_string); if (updated) { var time_arr = time_playing.Split(':'); TimeSpan duration = new System.TimeSpan(0, 0, int.Parse(time_arr[0]), int.Parse(time_arr[1])).Subtract(new System.TimeSpan(0, 0, 40, 0)); if (duration >= new TimeSpan(0, 0, 0)) { Commentary = "REF TIME +" + duration.ToString(); } FooterMainButtonsArea.Children.Clear(); Playing_Time.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#F00")); End_sessionActions(); GetSessionBTNS(); } } private void GameEnd_Action(object sender, MouseButtonEventArgs e) { //STOP MAIN TIME sw.Stop(); //START STOPPEAGE TIME sw_stop.Stop(); dt_stop.Stop(); sw_stop_dur.Stop(); dt_stop_dur.Stop(); sw_pt.Stop(); ST.Stop(); Game_status = 10; string sql_string = "UPDATE Fixture SET " + " Game_status = '" + Game_status + "' " + " WHERE FID = '" + FID + "' ; "; SqlDatabase SQL = new SqlDatabase(); bool updated = SQL.Execute(sql_string); if (updated) { FooterMainButtonsArea.Children.Clear(); Playing_Time.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#F00")); Game_Duration.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#F00")); Stoppage_Time.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#F00")); End_sessionActions(); GetSessionButtons(); } } private bool Pause_Game(object sender, MouseButtonEventArgs e) { if (sw.IsRunning) { //STOP MAIN TIME sw.Stop(); //START STOPPEAGE TIME sw_stop.Start(); dt_stop.Start(); sw_stop_dur.Start(); dt_stop_dur.Start(); } //window.Show(); Game_Paused = 1; string sql_string = "UPDATE Fixture SET " + " Game_Paused = '1' " + " WHERE FID = '" + FID + "' ; "; SqlDatabase SQL = new SqlDatabase(); bool updated = SQL.Execute(sql_string); if (updated) { FooterMainButtonsArea.Children.Clear(); if (!StoppagePopUp.IsOpen) { ResumeGameBtn(); } Playing_Time.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#F00")); } return true; } private bool Resume_Game(object sender, MouseButtonEventArgs e) { sw.Start(); ST.Start(); sw_stop.Stop(); sw_stop_dur.Reset(); window.Hide(); Game_Paused = 0; if (PushOnResume.Count > 0) { foreach (var identifier in PushOnResume) { HandlePushOnResume(identifier); } PushOnResume.Clear(); } if (InjuryOnResume.Count > 0) { foreach (var identifier in InjuryOnResume) { HandleInjuryOnResume(identifier); } InjuryOnResume.Clear(); } if (InjuryPermanentOnResume.Count > 0) { foreach (var identifier in InjuryPermanentOnResume) { HandleInjuryPermanentOnResume(identifier); } InjuryPermanentOnResume.Clear(); } if (InjuryReverseOnResume.Count > 0) { foreach (var identifier in InjuryReverseOnResume) { HandleInjuryReverseOnResume(identifier); } InjuryReverseOnResume.Clear(); } string sql_string = "UPDATE Fixture SET " + " Game_Paused = '0' " + " WHERE FID = '" + FID + "' ; "; SqlDatabase SQL = new SqlDatabase(); bool updated = SQL.Execute(sql_string); if (updated) { FooterMainButtonsArea.Children.Clear(); GetSessionBTNS(); PauseGameBtn(); Playing_Time.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#666")); } //add to commentary and load on screen Guid guid = Guid.NewGuid(); string ID = guid.ToString(); string Timerr = Game_Duration.Text; string stoppageDuration = Stoppage_Time_dur.Text; string comment = "Duration: " + stoppageDuration; Time = Timerr; var time_split = Time.Split(':'); string eventdescription = "Play resumed"; int No = 0; try { No = Convert.ToInt32(time_split[0] + time_split[1]); No++; } catch { } string sql_string_Insert_resume = "insert into Commentary (Time, FID, ID,Session,SID," + "EventID,PlayerID,ReplcamentID,SquadName,EventName,PlayerName,No,Comment)" + " values ('" + Playing_Time.Text + "','" + FID + "', '" + ID + "','" + Session + "'," + "'" + TeamID + "','" + EventID + "','" + Player_ID + "','" + Replacemant_ID + "'," + "'" + SquadName + "','" + eventdescription + "','" + PlayerName + "','" + No + "','" + comment + "')"; Comments Comm = new Comments(); bool Saved = Comm.insertData(sql_string_Insert_resume); if (Saved == true) { getCommentary(); } else { MessageBox.Show("Did not save!"); } ResetValues(); GetFixture(); return true; } void dt_Tick(object sender, EventArgs e) { if (sw.IsRunning) { try { string time = time_playing; if (set_half_time == 1) { time = Fixture_Data.HalfTime + ":00"; if (String.IsNullOrEmpty(Fixture_Data.HalfTime)) { time = "40:00"; } set_half_time = 0; } var time_split = time.Split(':'); TimeSpan ts = new System.TimeSpan(0, int.Parse(time_split[0]), int.Parse(time_split[1])).Add(sw.Elapsed); int TotalMinutes = ts.Hours * 60; TotalMinutes = TotalMinutes + ts.Minutes; currentTime = String.Format("{0:00}:{1:00}", TotalMinutes, ts.Seconds, ts.Milliseconds / 10); Playing_Time.Text = currentTime; string sql_string = "UPDATE Fixture SET " + " Playing_Time = '" + currentTime + "' " + " WHERE FID = '" + FID + "' ; "; SqlDatabase SQL = new SqlDatabase(); SQL.Execute(sql_string); if (Fixture_Data.Game_status == 1 && TotalMinutes >= 40 && TotalMinutes <= 45) { break_time_timer.Text = "+ " + currentTime.Substring(1); break_time_timer.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#F70909")); } else if (TotalMinutes >= 35 && Fixture_Data.Game_status == 1 && TotalMinutes <= 40) { warningTime = new DispatcherTimer(); warningTime.Interval = TimeSpan.FromSeconds(1); warningTime.Tick += WarningTime_Tick; //warningTime.Start(); var time_arr = currentTime.Substring(1).Split(':'); //TimeSpan duration = new System.TimeSpan(0, 0, int.Parse(time_arr[0]), int.Parse(time_arr[1])).Subtract(new System.TimeSpan(0, 0, 5, 0)); TimeSpan duration = new System.TimeSpan(0, 0, 10, 0).Subtract(new System.TimeSpan(0, 0, int.Parse(time_arr[0]), int.Parse(time_arr[1]))); break_time_timer.Visibility = Visibility.Visible; break_time_label.Visibility = Visibility.Visible; break_time_timer.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#006400")); break_time_timer.Text = duration.ToString(); } else { break_time_timer.Visibility = Visibility.Collapsed; break_time_label.Visibility = Visibility.Collapsed; } } catch { } } } private void WarningTime_Tick(object sender, EventArgs e) { TimeSpan t = TimeSpan.FromSeconds(countTime); if (countTime > 0 && !performedCountDown) { countTime--; break_time_timer.Text = string.Format("0{0}:{1}", t.Minutes, t.Seconds); break_time_timer.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#000000")); } else { performedCountDown = true; countTime++; break_time_timer.Text = string.Format("0{0}:{1}", countTime / 60, countTime % 60); break_time_timer.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#F70909")); } } void dt_Tick_pT(object sender, EventArgs e) { if (sw_pt.IsRunning) { try { string time = time_duration; var time_split = time.Split(':'); TimeSpan ts = new System.TimeSpan(0, int.Parse(time_split[0]), int.Parse(time_split[1])).Add(sw_pt.Elapsed); int TotalMinutes = ts.Hours * 60; TotalMinutes = TotalMinutes + ts.Minutes; currentTime_pt = String.Format("{0:00}:{1:00}", TotalMinutes, ts.Seconds, ts.Milliseconds / 10); Game_Duration.Text = currentTime_pt; string sql_string = "UPDATE Fixture SET " + " Game_Duration = '" + currentTime_pt + "' " + " WHERE FID = '" + FID + "' ; "; SqlDatabase SQL = new SqlDatabase(); SQL.Execute(sql_string); } catch { } } } void dt_Tick_Stop(object sender, EventArgs e) { if (sw_stop.IsRunning) { try { string time = time_stopped; var time_split = time.Split(':'); TimeSpan ts = new System.TimeSpan(0, int.Parse(time_split[0]), int.Parse(time_split[1])).Add(sw_stop.Elapsed); int TotalMinutes = ts.Hours * 60; TotalMinutes = TotalMinutes + ts.Minutes; currentTime_stop = String.Format("{0:00}:{1:00}", TotalMinutes, ts.Seconds); Stoppage_Time.Text = currentTime_stop; string sql_string = "UPDATE Fixture SET " + " Total_Stoppage = '" + currentTime_stop + "' " + " WHERE FID = '" + FID + "' ; "; SqlDatabase SQL = new SqlDatabase(); SQL.Execute(sql_string); } catch { } } } void dt_Tick_Stop_dur(object sender, EventArgs e) { if (sw_stop_dur.IsRunning) { string time = "00:00:00"; var time_split = time.Split(':'); TimeSpan ts = new System.TimeSpan(int.Parse(time_split[0]), int.Parse(time_split[1]), int.Parse(time_split[2])).Add(sw_stop_dur.Elapsed); int TotalMinutes = ts.Hours * 60; TotalMinutes = TotalMinutes + ts.Minutes; string currentTime_stop = String.Format("{0:00}:{1:00}", TotalMinutes, ts.Seconds); Stoppage_Time_dur.Text = currentTime_stop; } } private void EventsDropDown_SelectionChanged(object sender, SelectionChangedEventArgs e) { //string content =EventsDropDown.SelectedItem.ToString(); int index = EventsDropDown.SelectedIndex; //comboBox1.SelectedIndex = index; ReplacementWrapa.Visibility = Visibility.Hidden; if (index > 0) { if (Events_Data[index].Group > 2 && Events_Data[index].Session != 1 && Events_Data[index].CEID != 12) { Reason.Text = Events_Data[index].CommName; ReplacementWrapa.Visibility = Visibility.Visible; index = SquadDropDown.SelectedIndex; if (index == 0) { SID = Fixture_Data.HomeTeam; } else { SID = Fixture_Data.AwayTeam; } //get team Teams Ts = new Teams(); Team_Data = Ts.GetTeam(FID, SID); List Team = GetLineUpPlayers(false, Fixture_Data.HomeTeam, Int32.Parse(Fixture_Data.Code)); // Add Off field players to list Teams PlayerX = Ts.GetPlayer(FID, SID, Commentry_Edit_Data.ReplacementID); Team.Add(PlayerX); for (int i = 0; i < Team.Count; i++) { if (Team[i].UserID == Commentry_Edit_Data.PlayerID) { Team.Remove(Team[i]); i = Team.Count; } } ReplacementDropDown.Items.Clear(); int R = 0; int R_Selected = -1; foreach (Teams item in Team) { if (item.UserID == Commentry_Edit_Data.ReplacementID) { R_Selected = R; } R++; ReplacementDropDown.Items.Add(item.FullName + " (" + item.Jersey + ")"); } ReplacementDropDown.SelectedIndex = R_Selected; } else { Reason.Text = ""; } } } private void SquadDropDown_SelectionChanged(object sender, SelectionChangedEventArgs e) { int index = SquadDropDown.SelectedIndex; if (index == 0) { SID = Fixture_Data.HomeTeam; } else { SID = Fixture_Data.AwayTeam; } //get team Teams Ts = new Teams(); List Team = GetLineUpPlayers(true, SID, Int32.Parse(Fixture_Data.Code));// Add Onfield players to list Teams PlayerX = Ts.GetPlayer(FID, SID, Commentry_Edit_Data.PlayerID); Team.Add(PlayerX); for (int i = 0; i < Team.Count; i++) { if (Team[i].UserID == Commentry_Edit_Data.ReplacementID) { Team.Remove(Team[i]); } } Team_Data = Ts.GetTeam(FID, SID); PlayerDropDown.Items.Clear(); int E = 0; int E_Selected = -1; foreach (Teams item in Team) { if (item.UserID == Commentry_Edit_Data.PlayerID) { E_Selected = E; } E++; PlayerDropDown.Items.Add(item.FullName + " (" + item.Jersey + ")"); } PlayerDropDown.SelectedIndex = E_Selected; //get team //List Team = Ts.GetTeam(FID, SID); Team = GetLineUpPlayers(false, SID, Int32.Parse(Fixture_Data.Code)); // Add Off field players to list PlayerX = Ts.GetPlayer(FID, SID, Commentry_Edit_Data.ReplacementID); Team.Add(PlayerX); for (int i = 0; i < Team.Count; i++) { if (Team[i].UserID == Commentry_Edit_Data.PlayerID) { Team.Remove(Team[i]); } } ReplacementDropDown.Items.Clear(); int R = 0; int R_Selected = -1; foreach (Teams item in Team) { if (item.UserID == Commentry_Edit_Data.ReplacementID) { R_Selected = R; } R++; ReplacementDropDown.Items.Add(item.FullName + " (" + item.Jersey + ")"); } ReplacementDropDown.SelectedIndex = R_Selected; //ReplacementDropDown.SelectedIndex = R_Selected; //Commentry_Edit_Data } private void PlayerDropDown_SelectionChanged(object sender, SelectionChangedEventArgs e) { } private void ReplacementDropDown_SelectionChanged(object sender, SelectionChangedEventArgs e) { } private void Cancel_Edit(object sender, MouseButtonEventArgs e) { CommentaryID = ""; Edit_Popup.Visibility = Visibility.Hidden; } private void SessionEdit_Process(object sender, MouseButtonEventArgs e) { string Time = MinuteSessionsDropDown_1.SelectedIndex.ToString() + MinutesSessionDropDown_2.SelectedIndex.ToString() + ":" + SecondsSessionDropDown_1.SelectedIndex.ToString() + SecondsSessionDropDown_2.SelectedIndex.ToString(); string n = MinutesDropDown_1.SelectedIndex.ToString() + MinutesDropDown_2.SelectedIndex.ToString() + SecondsDropDown_1.SelectedIndex.ToString() + SecondsDropDown_2.SelectedIndex.ToString(); int index = SessionSquadDropDown.SelectedIndex; if (index == 0) { TeamID = Fixture_Data.HomeTeam; SquadName = Fixture_Data.HomeName; } else { TeamID = Fixture_Data.AwayTeam; SquadName = Fixture_Data.AwayName; } //player int p_index = SessionPlayerDropDown.SelectedIndex; try { Player_ID = Team_Data[p_index].UserID; PlayerName = Team_Data[p_index].FullName; string sql_string = "UPDATE Commentary SET " + " FID = '" + FID + "'," + " Time = '" + Time + "'," + " SID = '" + TeamID + "'," + " PlayerID = '" + Player_ID + "'," + " SquadName = '" + SquadName + "'," + " PlayerName = '" + PlayerName + "' " + " WHERE ID = '" + CommentaryID + "'; "; Comments Comm = new Comments(); bool Saved = Comm.insertData(sql_string); if (Saved == true) { getCommentary(); } else { MessageBox.Show("Did not save!"); } ResetValues(); GetFixture(); SessionEdit_Popup.Visibility = Visibility.Hidden; } catch (Exception Error) { MessageBox.Show(Error.ToString()); } } private void Edit_Process(object sender, MouseButtonEventArgs e) { string Time = MinutesDropDown_1.SelectedIndex.ToString() + MinutesDropDown_2.SelectedIndex.ToString() + ":" + SecondsDropDown_1.SelectedIndex.ToString() + SecondsDropDown_2.SelectedIndex.ToString(); //string n = MinutesDropDown_1.SelectedIndex.ToString() + MinutesDropDown_2.SelectedIndex.ToString() + SecondsDropDown_1.SelectedIndex.ToString() + SecondsDropDown_2.SelectedIndex.ToString(); int index = SquadDropDown.SelectedIndex; if (index == 0) { TeamID = Fixture_Data.HomeTeam; SquadName = Fixture_Data.HomeName; } else { TeamID = Fixture_Data.AwayTeam; SquadName = Fixture_Data.AwayName; } int E_index = EventsDropDown.SelectedIndex; try { EventID = Events_Data[E_index].CEID; EventName = Events_Data[E_index].CommName; if (Events_Data[E_index].Group > 2 && Events_Data[index].Session != 1) { Reason.Text = EventName; Commentary = EventName; EventName = "Substitution"; } } catch { } Teams Ts = new Teams(); //player List TeamP = GetLineUpPlayers(true, TeamID, Int32.Parse(Fixture_Data.Code));// Add Onfield players to list Teams PlayerX = Ts.GetPlayer(FID, SID, Commentry_Edit_Data.PlayerID); TeamP.Add(PlayerX); for (int i = 0; i < TeamP.Count; i++) { if (TeamP[i].UserID == Commentry_Edit_Data.ReplacementID) { TeamP.Remove(TeamP[i]); } } int p_index = PlayerDropDown.SelectedIndex; try { Player_ID = TeamP[p_index].UserID; PlayerName = TeamP[p_index].FullName; } catch { } //replcament List TeamR = GetLineUpPlayers(false, TeamID, Int32.Parse(Fixture_Data.Code));// Add Off field players to list PlayerX = Ts.GetPlayer(FID, SID, Commentry_Edit_Data.ReplacementID); TeamR.Add(PlayerX); for (int i = 0; i < TeamR.Count; i++) { if (TeamR[i].UserID == Commentry_Edit_Data.PlayerID) { TeamR.Remove(TeamR[i]); } } int r_index = ReplacementDropDown.SelectedIndex; try { Replacemant_ID = TeamR[r_index].UserID; ReplacementName = TeamR[r_index].FullName; } catch { } //Positions if (EventName == "Substitution") { if (Commentry_Edit_Data.EventID == 11 || Commentry_Edit_Data.EventID == 14) { Comments Row = Comments.GetRow(CommentaryID); Old_Player_ID = Row.PlayerID; Teams Team = new Teams(); Teams New_Player = Team.GetPlayer(FID, TeamID, Player_ID); Teams Old_Player = Team.GetPlayer(FID, TeamID, Old_Player_ID); UpdateLocation(New_Player.UserID, FID, TeamID, Old_Player.Location); UpdateLocation(Old_Player.UserID, FID, TeamID, New_Player.Location); bool foundCard = false; for (int i = 0; i < allCards.Count; i++) { if (allCards[i].FID == Row.FID && allCards[i].SID == Row.SID && allCards[i].EventID == Row.EventID && allCards[i].PlayerID == Row.PlayerID && allCards[i].ReplacementID == Row.ReplacementID) { foundCard = true; i = allCards.Count - 1; try { Grid grid = (Grid)this.FindName(allCards[i].Identfier); if (grid != null) { allCards[i].PlayerID = New_Player.UserID; } } catch (Exception) { } } } } else {//player try { Comments Row = Comments.GetRow(CommentaryID); Old_Player_ID = Row.PlayerID; Old_Replacemant_ID = Row.ReplacementID; Teams Team = new Teams(); Teams New_Player = Team.GetPlayer(FID, TeamID, Player_ID); Teams Old_Player = Team.GetPlayer(FID, TeamID, Old_Player_ID); Teams New_Replacement = Team.GetPlayer(FID, TeamID, Replacemant_ID); Teams Old_Replacement = Team.GetPlayer(FID, TeamID, Old_Replacemant_ID); int Player_Pos = New_Player.CurrentPos; int Old_Player_Pos = Old_Player.CurrentPos; int Replacement_Pos = New_Replacement.CurrentPos; int Old_Replacement_Pos = Old_Replacement.CurrentPos; if (New_Player.CurrentPos == 0 || New_Player.CurrentPos == Old_Player.CurrentPos) { New_Player = Old_Player; Player_ID = New_Player.UserID; PlayerName = New_Player.FullName; Player_Pos = Old_Replacement_Pos; } if (New_Replacement.CurrentPos == 0 || New_Replacement.CurrentPos == Old_Replacement.CurrentPos) { New_Replacement = Old_Replacement; Replacemant_ID = New_Replacement.UserID; ReplacementName = New_Replacement.FullName; Replacement_Pos = Old_Player_Pos; } //update new player and old player UpdatePosition(Old_Player.UserID, Old_Replacement_Pos, Fixture_Data.FID, TeamID); UpdatePosition(Old_Replacement.UserID, Old_Player_Pos, Fixture_Data.FID, TeamID); UpdatePosition(New_Player.UserID, Replacement_Pos, Fixture_Data.FID, TeamID); UpdatePosition(New_Replacement.UserID, Player_Pos, Fixture_Data.FID, TeamID); bool foundCard = false; for (int i = 0; i < allCards.Count; i++) { if (allCards[i].FID == Row.FID && allCards[i].SID == Row.SID && allCards[i].EventID == Row.EventID && allCards[i].PlayerID == Row.PlayerID && allCards[i].ReplacementID == Row.ReplacementID) { foundCard = true; i = allCards.Count - 1; try { Grid grid = (Grid)this.FindName(allCards[i].Identfier); if (grid != null) { Border brd = (Border)grid.Children[0]; TextBlock Title = (TextBlock)brd.Child; brd = (Border)grid.Children[1]; TextBlock Number = (TextBlock)brd.Child; var _Split = Title.Uid.Split('|'); int Player_ID = Convert.ToInt32(_Split[0]); int F_ID = Convert.ToInt32(_Split[1]); int S_ID = Convert.ToInt32(_Split[2]); int sub_ID = Convert.ToInt32(_Split[3]); var identifier = _Split[4]; var eventId = Convert.ToInt32(_Split[5]); Title.Uid = New_Replacement.UserID.ToString() + "|" + New_Player.FID + "|" + New_Player.SID + "|" + New_Player.UserID.ToString() + "|" + identifier + "|" + EventID; Number.Text = New_Replacement.Jersey.ToString() + " ON ↑" + Environment.NewLine + New_Player.Jersey.ToString() + " OFF ↓"; allCards[i].PlayerID = New_Player.UserID; allCards[i].ReplacementID = New_Replacement.UserID; } } catch (Exception) { } } } } catch { } } } //Session int SessionNo = SessionDropDown.SelectedIndex; Commentary = Reason.Text; //int No = 0; //try //{ // No = Convert.ToInt32(n); //} //catch //{ //} string sql_string = "UPDATE Commentary SET " + " FID = '" + FID + "'," + " Time = '" + Time + "'," + " Session = '" + Session + "'," + " SID = '" + TeamID + "'," + " EventID = '" + EventID + "'," + " PlayerID = '" + Player_ID + "'," + " ReplcamentID = '" + Replacemant_ID + "'," + " SquadName = '" + SquadName + "'," + " EventName = '" + EventName + "'," + " ReplacementName = '" + ReplacementName + "', " + " PlayerName = '" + PlayerName + "', " + //" No = '" + No + "', " + " Comment = '" + Commentary + "'" + " WHERE ID = '" + CommentaryID + "'; "; Comments Comm = new Comments(); bool Saved = Comm.insertData(sql_string); if (Saved == true) { getCommentary(); } else { MessageBox.Show("Did not save!"); } ResetValues(); GetFixture(); Edit_Popup.Visibility = Visibility.Hidden; } private void MinutesDropDown_1_SelectionChanged(object sender, SelectionChangedEventArgs e) { int index = MinutesDropDown_1.SelectedIndex; //MessageBox.Show(index.ToString()); } private void Start_Session() { Process_Data(1); sw.Start(); ST.Start(); sw_pt.Start(); dt_pt.Start(); GetSessionButtons(); } private void Kickoff_HomeTeam_MouseDown(object sender, MouseButtonEventArgs e) { GAMESTARTED = 1; DateTime localDate = DateTime.Now; Game_status++; time_stopped = Stoppage_Time.Text; string sql_string = "UPDATE Fixture SET " + " Game_status = '" + Game_status + "', " + " Playing_Time = '" + time_playing + "', " + " Game_Duration = '" + time_duration + "', " + " Total_Stoppage = '" + time_stopped + "', " + "Time_Started = '" + Convert.ToString(localDate) + "' " + " WHERE FID = '" + FID + "' ; "; SqlDatabase SQL = new SqlDatabase(); bool updated = SQL.Execute(sql_string); if (updated) { Home_sessionActions(); // } } private void Kickoff_AwayTeam_MouseDown(object sender, MouseButtonEventArgs e) { GAMESTARTED = 1; DateTime localDate = DateTime.Now; Game_status++; time_stopped = Stoppage_Time.Text; string sql_string = "UPDATE Fixture SET " + " Game_status = '" + Game_status + "', " + " Playing_Time = '" + time_playing + "', " + " Game_Duration = '" + time_duration + "', " + " Total_Stoppage = '" + time_stopped + "', " + "Time_Started = '" + Convert.ToString(localDate) + "' " + " WHERE FID = '" + FID + "' ; "; SqlDatabase SQL = new SqlDatabase(); bool updated = SQL.Execute(sql_string); if (updated) { Away_sessionActions(); } } //**************************************************************************************************************************** private void Home_sessionActions() { SessionStartActions(); SID = Fixture_Data.HomeTeam; TeamID = SID; SquadName = Fixture_Data.HomeName; Home_Cancel.Visibility = Visibility.Visible; GetPlayers(FID, SID, 0, Int32.Parse(Fixture_Data.Code), 0, 1); } private void Away_sessionActions() { SessionStartActions(); SID = Fixture_Data.AwayTeam; TeamID = SID; SquadName = Fixture_Data.AwayName; Away_Cancel.Visibility = Visibility.Visible; GetPlayers(FID, SID, 1, Int32.Parse(Fixture_Data.Code), 0, 1); } private void End_sessionActions() { switch (Game_status) { case 2: EventID = 28; EventName = GetEventName(EventID); Process_Data(); break; case 4: EventID = 39; EventName = GetEventName(EventID); Process_Data(); break; case 6: EventID = 32; EventName = GetEventName(EventID); Process_Data(); break; case 8: EventID = 33; EventName = GetEventName(EventID); Process_Data(); break; case 10: EventID = 30; EventName = GetEventName(EventID); Process_Data(); break; } } private void SessionStartActions() { switch (Game_status) { case 1: EventID = 27; EventName = GetEventName(EventID); break; case 3: EventID = 29; EventName = GetEventName(EventID); Session = 1; break; case 5: EventID = 31; EventName = GetEventName(EventID); Session = 2; break; case 7: EventID = 33; EventName = GetEventName(EventID); Session = 3; break; } } private string GetEventName(int EventID) { Events evt = new Events(); Events Data = evt.GetEvent(EventID); return Data.CommName; } private void GameStart_Popup_MouseDown(object sender, MouseButtonEventArgs e) { GameStart_Popup.Visibility = Visibility.Hidden; } private void GetSessionBTNS() { if (Game_status == 1) { FirstHalfEndBtb(); } if (Game_status == 2) { SecondHalfBtb(); } if (Game_status == 3) { SecondHalfEndBtb(); } //EXTRA TIME if (Game_status == 4) { ExtraTimeStartBtb(); } if (Game_status == 5) { ExtraTimeEndFirstHalfBtb(); } if (Game_status == 6) { ExtraTimeStartSecondBtb(); } if (Game_status == 7) { ExtraTimeEndBtb(); } if (Game_status > 3) { EndGameEndBtb(); } } private void StartGameBtb() { string text = "MATCH START"; string ID = "1"; string Background = "Green"; TextBlock btn = CreateButtons(text, ID, Background); FooterMainButtonsArea.Children.Add(btn); } private void SecondHalfBtb() { string text = "2H START"; string ID = "1"; string Background = "Green"; TextBlock btn = CreateButtons(text, ID, Background); FooterMainButtonsArea.Children.Add(btn); } private void FirstHalfEndBtb() { string text = "1H End"; string ID = "2"; string Background = "Red"; TextBlock btn = CreateButtons(text, ID, Background); FooterMainButtonsArea.Children.Add(btn); } private void SecondHalfEndBtb() { string text = "2H End"; string ID = "2"; string Background = "Red"; TextBlock btn = CreateButtons(text, ID, Background); FooterMainButtonsArea.Children.Add(btn); } private void ExtraTimeStartBtb() { string text = "ET 1H START"; string ID = "1"; string Background = "Green"; TextBlock btn = CreateButtons(text, ID, Background); FooterMainButtonsArea.Children.Add(btn); } private void ExtraTimeEndFirstHalfBtb() { string text = "ET 1H END"; string ID = "2"; string Background = "Red"; TextBlock btn = CreateButtons(text, ID, Background); FooterMainButtonsArea.Children.Add(btn); } private void ExtraTimeStartSecondBtb() { string text = "ET 2H START 2H"; string ID = "1"; string Background = "Green"; TextBlock btn = CreateButtons(text, ID, Background); FooterMainButtonsArea.Children.Add(btn); } private void ExtraTimeEndBtb() { string text = "ET 2H END "; string ID = "2"; string Background = "Red"; TextBlock btn = CreateButtons(text, ID, Background); FooterMainButtonsArea.Children.Add(btn); } private void EndGameEndBtb() { string text = "END GAME"; string ID = "10"; string Background = "Red"; TextBlock btn = CreateButtons(text, ID, Background); FooterMainButtonsArea.Children.Add(btn); } private void Border_MouseDown(object sender, MouseButtonEventArgs e) { try { string sql_string = "DELETE FROM Commentary " + " WHERE FID = '" + FID + "' ; "; SqlDatabase SQL = new SqlDatabase(); bool done = SQL.Execute(sql_string); if (done) { } sql_string = "UPDATE Fixture SET " + " Game_Duration = '00:00' ," + " Running_time = '00:00' ," + " Running_time = '00:00' ," + " Game_status = '0' " + " WHERE FID = '" + FID + "'; "; done = SQL.Execute(sql_string); if (done) { ST.Stop(); sw.Stop(); dt_pt.Stop(); dt_stop.Stop(); sw_pt.Stop(); sw_stop.Stop(); dt_stop_dur.Stop(); sw_stop_dur.Stop(); Loginn User_Logged = new Loginn(); USERID = User_Logged.IsLoggedIN_AlReady(); this.FID = FID; InitializeComponent(); GetFixture(); LoadCurrentYellowCards(); ST.Tick += new EventHandler(dt_Tick); ST.Interval = new TimeSpan(0, 0, 0, 0, 1); dt_pt.Tick += new EventHandler(dt_Tick_pT); dt_pt.Interval = new TimeSpan(0, 0, 0, 0, 1); dt_stop.Tick += new EventHandler(dt_Tick_Stop); dt_stop.Interval = new TimeSpan(0, 0, 0, 0, 1); dt_stop_dur.Tick += new EventHandler(dt_Tick_Stop_dur); dt_stop_dur.Interval = new TimeSpan(0, 0, 0, 0, 1); GetSessionButtons(); Kickoff_HomeTeam.Text = Fixture_Data.HomeName; Kickoff_AwayTeam.Text = Fixture_Data.AwayName; //timesec = Fixture_Data.YellowCard_Counter * 60; timesecYellowCardTimer = Fixture_Data.YellowCardTimer * 60; timesecBloodTimer = Fixture_Data.BloodTimer * 60; timesecHIATimer = Fixture_Data.HIATimer * 60; GetSessionButtons(); } } catch { } } private void Upload_data(object sender, MouseButtonEventArgs e) { List commentsList = Comments.GetCommentary(FID); var json = JsonConvert.SerializeObject(commentsList); bool upload = Webservices.PostComment(FID, json); } private void Minus_Process(object sender, MouseButtonEventArgs e) { } private void Add_Process(object sender, MouseButtonEventArgs e) { } private void Cancel_Clock_Update(object sender, MouseButtonEventArgs e) { EditClock_Popup.Visibility = Visibility.Hidden; } private void Clock_Update_MouseDown(object sender, MouseButtonEventArgs e) { EditClock_Popup.Visibility = Visibility.Visible; } private void Update_clock_time(object sender, MouseButtonEventArgs e) { } private void minimiz_app(object sender, MouseButtonEventArgs e) { MainWindow Form = new MainWindow(); Form.WindowState = WindowState.Minimized; } private void Exit_app(object sender, MouseButtonEventArgs e) { // Console app System.Environment.Exit(1); } private void Cancel_Session_Edit(object sender, MouseButtonEventArgs e) { SessionEdit_Popup.Visibility = Visibility.Hidden; } private void SessionPlayerDropDown_SelectionChanged(object sender, SelectionChangedEventArgs e) { } private void SessionSquadDropDown_SelectionChanged(object sender, SelectionChangedEventArgs e) { } private void Button_Click(object sender, RoutedEventArgs e) { Listfixturs FixturePage = new Listfixturs(); FixturePage.MainFrame = MainFrame; MainFrame.Content = FixturePage; } private void Button_Click_ContinueMatch(object sender, RoutedEventArgs e) { BackPopup.IsOpen = false; SubPopup.IsOpen = false; InjuryPopup.IsOpen = false; btnPush.Visibility = Visibility.Visible; btnPush.Margin = new Thickness(32, 50, 0, 0); btnPush.Content = "Push"; btnPark.Visibility = Visibility.Visible; btnPark.Margin = new Thickness(32, 100, 0, 0); btnPark.Content = "Confirm"; btnCancel.Visibility = Visibility.Visible; btnCancel.Margin = new Thickness(32, 150, 0, 0); btnCancel.Content = "Cancel"; SubPopup.Height = 200; } private void StoppageReason_Click(object sender, RoutedEventArgs e) { Button button = sender as Button; string source = button.Name; switch (source) { case "weather_other": source = "Weather or Other"; break; case "Substitution": break; case "TMO": break; case "StrategicBreak": source = "Strategic Break"; break; case "FoulPlay": source = "Foul Play"; break; case "Clothing": break; case "HIA": source = "H.I.A"; break; case "TalkingtoAR": source = "Talking to AR"; break; case "Injury": break; } StoppagePopUp.IsOpen = false; Guid guid = Guid.NewGuid(); string ID = guid.ToString(); string Timerr = Game_Duration.Text; Time = Timerr; var time_split = Time.Split(':'); string eventdescription = "Time off"; int No = 0; try { No = Convert.ToInt32(time_split[0] + time_split[1]); } catch { } string sql_string = "insert into Commentary (Time, FID, ID,Session,SID," + "EventID,PlayerID,ReplcamentID,SquadName,EventName,PlayerName,No,Comment)" + " values ('" + Playing_Time.Text + "','" + FID + "', '" + ID + "','" + Session + "'," + "'" + TeamID + "','" + EventID + "','" + Player_ID + "','" + Replacemant_ID + "'," + "'" + SquadName + "','" + eventdescription + "','" + PlayerName + "','" + No + "','" + source + "')"; Comments Comm = new Comments(); bool Saved = Comm.insertData(sql_string); if (Saved == true) { getCommentary(); } else { MessageBox.Show("Did not save!"); } ResetValues(); GetFixture(); } private void Button_Click_AbandonMatch(object sender, RoutedEventArgs e) { //STOP MAIN TIME sw.Stop(); //START STOPPEAGE TIME sw_stop.Stop(); dt_stop.Stop(); sw_stop_dur.Stop(); dt_stop_dur.Stop(); sw_pt.Stop(); ST.Stop(); Game_status = 10; string sql_string = "UPDATE Fixture SET " + " Game_status = '" + Game_status + "' " + " WHERE FID = '" + FID + "' ; "; SqlDatabase SQL = new SqlDatabase(); bool updated = SQL.Execute(sql_string); if (updated) { FooterMainButtonsArea.Children.Clear(); Playing_Time.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#F00")); Game_Duration.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#F00")); End_sessionActions(); GetSessionButtons(); } BackPopup.IsOpen = false; } } } //private void CreateInjuryTimers(int jerseryNumber, string injury_type) //{ // Teams DB = new Teams(); // Teams Player = DB.GetPlayer(FID, TeamID, Player_ID); // int UserID = Player.UserID; // Grid Maingrd = new Grid(); // //Maingrd.MouseDown += new MouseButtonEventHandler(RemoveInjuryCard); // var identifier = DateTime.Now.ToString("ddddddMMMMyyyyHHmmss"); // Maingrd.Uid = UserID.ToString(); // Maingrd.Margin = new Thickness(10, 30, 0, 20); // Maingrd.Background = Brushes.White; // RowDefinition row1 = new RowDefinition(); // RowDefinition row2 = new RowDefinition(); // row1.Height = new GridLength(40); // row2.Height = new GridLength(40); // Maingrd.RowDefinitions.Add(row1); // Maingrd.RowDefinitions.Add(row2); // //Add Text // TextBlock Title = new TextBlock(); // Title.Text = injury_type; // Title.FontSize = 14; // Title.FontWeight = FontWeights.Bold; // Title.TextAlignment = TextAlignment.Center; // Title.VerticalAlignment = VerticalAlignment.Center; // Title.Margin = new Thickness(10); // Grid GRD = new Grid(); // Grid.SetRow(Title, 0); // Grid.SetRow(GRD, 1); // Maingrd.Children.Add(Title); // Maingrd.Children.Add(GRD); // ColumnDefinition Col1 = new ColumnDefinition(); // ColumnDefinition Col2 = new ColumnDefinition(); // ColumnDefinition Col3 = new ColumnDefinition(); // Col1.Width = new GridLength(25); // Col2.Width = new GridLength(55); // Col3.Width = new GridLength(35); // GRD.ColumnDefinitions.Add(Col1); // GRD.ColumnDefinitions.Add(Col2); // GRD.ColumnDefinitions.Add(Col3); // TextBlock Number = new TextBlock(); // Number.Text = jerseryNumber.ToString(); // Number.FontSize = 16; // Number.FontWeight = FontWeights.Bold; // Number.TextAlignment = TextAlignment.Center; // Number.VerticalAlignment = VerticalAlignment.Center; // TextBlock Timm = new TextBlock(); // Timm.Uid = jerseryNumber.ToString() + "|" + FID + "|" + SID + "|" + Game_Duration.Text + "|"; // Timm.FontSize = 50; // Timm.FontSize = 16; // Timm.FontWeight = FontWeights.Bold; // Timm.TextAlignment = TextAlignment.Center; // Timm.VerticalAlignment = VerticalAlignment.Center; // Timm.Text = "Start"; // Timm.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#808080")); // Timm.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#fff")); // Timm.Margin = new Thickness(5, 0, 5, 0); // Timm.MouseDown += new MouseButtonEventHandler(Start_Injury_Clock_Clicked); // /* // */ // Border BRD = new Border(); // BRD.BorderBrush = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#999")); // BRD.BorderThickness = new Thickness(0, 0, 1, 0); // BRD.Child = Number; // TextBlock Close = new TextBlock(); // //Close.Uid = c; // Close.Text = "Close"; // Close.FontSize = 11; // Close.FontWeight = FontWeights.Bold; // Close.TextAlignment = TextAlignment.Center; // Close.VerticalAlignment = VerticalAlignment.Center; // Close.MouseDown += RemoveInjuryCard; // Grid.SetColumn(BRD, 0); // Grid.SetColumn(Timm, 1); // Grid.SetColumn(Close, 2); // GRD.Children.Add(BRD); // GRD.Children.Add(Timm); // GRD.Children.Add(Close); // //Check Team // if (SID == Fixture_Data.HomeTeam) // { // HomePlayers_Cards.Children.Add(Maingrd); // HomePlayers_Cards.RegisterName(identifier, Maingrd); // } // else if (SID == Fixture_Data.AwayTeam) // { // AwayPlayers_Cards.Children.Add(Maingrd); // AwayPlayers_Cards.RegisterName(identifier, Maingrd); // } // Close.Uid = identifier; // //Update Player Location // UpdateLocation(Player_ID, FID, SID, 5, 0); //5 for now //} //private void Sub_In_Click(object sender, MouseButtonEventArgs e) //{ // //Process_Data(); // Grid button = (Grid)sender; // string UserID_ID = button.Uid; // var _Split = UserID_ID.Split('|'); // int Player_ID = Convert.ToInt32(_Split[0]); // int F_ID = Convert.ToInt32(_Split[1]); // int S_ID = Convert.ToInt32(_Split[2]); // int sub_ID = Convert.ToInt32(_Split[3]); // Grid grid = null; // //if user clicks in the textblock // try // { // grid = (Grid)e.OriginalSource; // UpdateLocation_ReturnSubstitute(Player_ID, F_ID, S_ID, sub_ID, grid); // } // catch // { // //var grid = (Grid)e.OriginalSource; // } //}