//Function that is performed when button is clicked
        //Adjusts depending on action to be performed and node being performed on
        private async void Add_Click(object sender, RoutedEventArgs e)
        {
            object           data = null;                                         //Data that is added to databse
            object           obj  = null;                                         //obj is used to get unique key data
            FirebaseResponse resp = await client.GetTaskAsync("Counter/" + Node); //Gets data for counter

            Counter get = resp.ResultAs <Counter>();                              //Sets counter object to response from database

            //MessageBox.Show(get.cnt.ToString());

            if (Action == "Add") //Add
            {
                //Catches exception
                try
                {
                    if (Node == "Coaches") //Coaches
                    {
                        //Sets data to new coaches object with information that was inserted from user
                        data = new Coaches
                        {
                            CoachId  = Convert.ToInt32(get.cnt) + 1,
                            Age      = int.Parse(txt2.Text),
                            FName    = txt3.Text,
                            LName    = txt4.Text,
                            Phone_no = txt5.Text,
                            Role     = txt6.Text,
                            TeamID   = int.Parse(txt7.Text)
                        };

                        //Sets obj to new counter object and increases count by 1 to represent amount of unique key IDs in a node
                        obj = new Counter
                        {
                            cnt = Convert.ToInt32(get.cnt) + 1
                        };
                    }
                    else if (Node == "Extras") //Extras
                    {
                        //Sets data to new Extras object with user inputs
                        data = new Extras
                        {
                            ExtraID  = Convert.ToInt32(get.cnt) + 1,
                            Age      = int.Parse(txt2.Text),
                            FName    = txt3.Text,
                            LName    = txt4.Text,
                            Phone_no = txt5.Text,
                            Role     = txt6.Text,
                            TeamID   = int.Parse(txt7.Text)
                        };

                        //Sets obj to new Counter object and increasing amount of key IDs by 1
                        obj = new Counter
                        {
                            cnt = Convert.ToInt32(get.cnt) + 1
                        };
                    }
                }
                catch (Exception ex) //Catch exception when a string is inserted in a textbox but an integer is needed
                {
                    MessageBox.Show(ex.Message + ", Check what you inserted in the Textboxes");
                    return;
                }


                //Used to access the correct data for node and not overwriting data
                string index = (get.cnt + 1).ToString();

                SetResponse response = await client.SetTaskAsync(Node + "/" + index, data); //Updates data in Node



                SetResponse response1 = await client.SetTaskAsync("Counter/" + Node, obj); //Updates count

                //After button pressed all textboxes will clear
                this.txt1.Text = "";
                this.txt2.Text = "";
                this.txt3.Text = "";
                this.txt4.Text = "";
                this.txt5.Text = "";
                this.txt6.Text = "";
                this.txt7.Text = "";

                //Messagebox that informs user data was inserted
                MessageBox.Show("Data Inserted");
                return;
            }
            else if (Action == "Update")  //Update
            {
                //Catches exception
                try
                {
                    if (Node == "Coaches")
                    {
                        //Sets data to new coaches object with user inputted data
                        data = new Coaches
                        {
                            CoachId  = int.Parse(txt1.Text),
                            Age      = int.Parse(txt2.Text),
                            FName    = txt3.Text,
                            LName    = txt4.Text,
                            Phone_no = txt5.Text,
                            Role     = txt6.Text,
                            TeamID   = int.Parse(txt7.Text)
                        };
                    }
                    else if (Node == "Extras")
                    {
                        //Sets data to new Extras object with user inputted data
                        data = new Extras
                        {
                            ExtraID  = int.Parse(txt1.Text),
                            Age      = int.Parse(txt2.Text),
                            FName    = txt3.Text,
                            LName    = txt4.Text,
                            Phone_no = txt5.Text,
                            Role     = txt6.Text,
                            TeamID   = int.Parse(txt7.Text)
                        };
                    }
                }
                catch (Exception ex) //Catches exception when input data is not correct
                {
                    MessageBox.Show(ex.Message + ", Check what you inserted in the Textboxes");
                    return;
                }


                FirebaseResponse response = await client.UpdateTaskAsync(Node + "/" + txt1.Text, data); //Updates node data

                MessageBox.Show("Data Updated");                                                        //Messagebox that showws after data has been updated
            }
            else if (Action == "Retrieve")                                                              //Retrieve
            {
                string print = null;                                                                    //String that used for returning data wanting to be retrieved
                if (txt1.IsEnabled == true)                                                             //If ID textbox is enabled on window
                {
                    FirebaseResponse response = await client.GetTaskAsync("Counter/" + Node);           //Gets counter to check if ID entered is valid

                    Counter cnt = response.ResultAs <Counter>();                                        //Sets response to a counter object

                    try                                                                                 //Catches exception
                    {
                        int count = cnt.cnt;                                                            //Sets count

                        int ID = int.Parse(txt1.Text);                                                  //Sets ID

                        if (ID > count || ID < 1)                                                       //Checks if ID entered is between 1 and count
                        {
                            MessageBox.Show(txt1.Text + " is not a valid ID");
                            return;
                        }
                    }
                    catch (Exception ex) //Catches exception when input data is entered wrong
                    {
                        MessageBox.Show(ex.Message + ", Check what you inserted in the Textboxes");
                        return;
                    }

                    response = await client.GetTaskAsync(Node + "/" + txt1.Text); //Get data with ID inputted

                    //Creates correct object data and calls print function
                    if (Node == "Coaches")
                    {
                        Coaches result = response.ResultAs <Coaches>();
                        print = result.printAll();
                    }
                    else if (Node == "Extras")
                    {
                        Extras result = response.ResultAs <Extras>();
                        print = result.printAll();
                    }

                    MessageBox.Show(print); //Prints data to a messagebox

                    //List<string> elements = new List<string>();
                    //elements.Add(print);

                    //DataWindow dataWindow = new DataWindow(Node, elements);

                    //dataWindow.Show();
                }
                else
                {
                    List <string> elements = new List <string>(); //List of strings that hold different data from databse.

                    //Runs through all key IDs
                    for (int i = 1; i <= get.cnt; i++)
                    {
                        FirebaseResponse result = await client.GetTaskAsync(Node + "/" + i); //Gets node

                        //Catches exceptions
                        try {
                            if (Node == "Coaches")
                            {
                                Coaches coach      = result.ResultAs <Coaches>(); //Turns response into coaches object
                                bool    addElement = true;                        //Sets add element to true
                                //******The next lines of code was a lot of copy and paste and save myself I will explain it clearly once
                                if (AgeLabel)                                     //Checks if Label is enabled on window
                                {
                                    if (txt2.Text != "")                          //Checks if user inputted into textbox that corresponds with label
                                    {
                                        if (coach.Age != int.Parse(txt2.Text))    //If the data inserted by the user and data in the databse does not match
                                        {
                                            addElement = false;                   //Sets to false because this element is not being added
                                        }
                                    }
                                }
                                if (FNameLabel)
                                {
                                    if (txt3.Text != "")
                                    {
                                        if (coach.FName != txt3.Text)
                                        {
                                            addElement = false;
                                        }
                                    }
                                }
                                if (LNameLabel)
                                {
                                    if (txt4.Text != "")
                                    {
                                        if (coach.LName != txt4.Text)
                                        {
                                            addElement = false;
                                        }
                                    }
                                }
                                if (PhoneNumLabel)
                                {
                                    if (txt5.Text != "")
                                    {
                                        if (coach.Phone_no != txt5.Text)
                                        {
                                            addElement = false;
                                        }
                                    }
                                }
                                if (RoleLabel)
                                {
                                    if (txt6.Text != "")
                                    {
                                        if (coach.Role != txt6.Text)
                                        {
                                            addElement = false;
                                        }
                                    }
                                }
                                if (TeamIDLabel)
                                {
                                    if (txt7.Text != "")
                                    {
                                        if (coach.TeamID != int.Parse(txt7.Text))
                                        {
                                            addElement = false;
                                        }
                                    }
                                }

                                if (addElement)                                                                                                    // If addElement is not false
                                {
                                    elements.Add(coach.printRestirction(AgeLabel, FNameLabel, LNameLabel, PhoneNumLabel, RoleLabel, TeamIDLabel)); //Calss print function and adds to list of strings
                                }
                            }
                            else if (Node == "Extras")
                            {
                                Extras extras     = result.ResultAs <Extras>(); //Turns respons into Extra object
                                bool   addElement = true;                       //Sets add element to true
                                //******The next lines of code was a lot of copy and paste and save myself it is explained above at line 297
                                if (AgeLabel)
                                {
                                    if (txt2.Text != "")
                                    {
                                        if (extras.Age != int.Parse(txt2.Text))
                                        {
                                            addElement = false;
                                        }
                                    }
                                }
                                if (FNameLabel)
                                {
                                    if (txt3.Text != "")
                                    {
                                        if (extras.FName != txt3.Text)
                                        {
                                            addElement = false;
                                        }
                                    }
                                }
                                if (LNameLabel)
                                {
                                    if (txt4.Text != "")
                                    {
                                        if (extras.LName != txt4.Text)
                                        {
                                            addElement = false;
                                        }
                                    }
                                }
                                if (PhoneNumLabel)
                                {
                                    if (txt5.Text != "")
                                    {
                                        if (extras.Phone_no != txt5.Text)
                                        {
                                            addElement = false;
                                        }
                                    }
                                }
                                if (RoleLabel)
                                {
                                    if (txt6.Text != "")
                                    {
                                        if (extras.Role != txt6.Text)
                                        {
                                            addElement = false;
                                        }
                                    }
                                }
                                if (TeamIDLabel)
                                {
                                    if (txt7.Text != "")
                                    {
                                        if (extras.TeamID != int.Parse(txt7.Text))
                                        {
                                            addElement = false;
                                        }
                                    }
                                }

                                if (addElement)
                                {
                                    elements.Add(extras.printRestirction(AgeLabel, FNameLabel, LNameLabel, PhoneNumLabel, RoleLabel, TeamIDLabel));
                                }
                            }
                        }
                        catch (Exception ex) //Catches exception when input data is incorrect
                        {
                            MessageBox.Show(ex.Message + ", Check what you inserted in the Textboxes");
                            return;
                        }
                    }


                    if (elements.Count == 0) //If there are no strings in list shows that no elements cooresponded with what the user was looking for
                    {
                        MessageBox.Show("There are no elements with the inputs inserted!");
                        return;
                    }

                    //DataWindow dataWindow = new DataWindow(Node, elements);

                    //dataWindow.Show();

                    foreach (string ele in elements)  //Shows all data in message boxes
                    {
                        MessageBox.Show(ele);
                    }
                }



                //foreach (string ele in arr){
                //  MessageBox.Show(ele);
                //}
            }
        }
示例#2
0
        //Function that calls when delete button is clicked
        //Adjust depending on node that was selected
        private async void Delete_Click(object sender, RoutedEventArgs e)
        {
            int startID = 0;


            FirebaseResponse response = await client.GetTaskAsync(Node + "/" + txt1.Text); //Get instance from databse

            FirebaseResponse resp = await client.GetTaskAsync("Counter/" + Node);          //Get amount of instances for a certain node

            Counter cnt = resp.ResultAs <Counter>();                                       //Set counter object to the response

            try
            {
                //Check if ID entered is valid

                int count = cnt.cnt;

                int ID = int.Parse(txt1.Text);
                if (ID > count || ID < 1)
                {
                    MessageBox.Show(txt1.Text + " is not a valid ID");
                    return;
                }
            }
            catch (Exception ex) //Catch exception when input data is incorrect
            {
                MessageBox.Show(ex.Message + ", Check what you inserted in the Textbox");
                return;
            }

            //Depending on node that is selected
            //Create new instance and set starting ID to the instance ID
            if (Node == "Coaches")
            {
                Coaches data = response.ResultAs <Coaches>();
                startID = data.CoachId;
            }
            else if (Node == "Extras")
            {
                Extras data = response.ResultAs <Extras>();
                startID = data.ExtraID;
            }
            else if (Node == "League")
            {
                League data = response.ResultAs <League>();
                startID = data.LeagueID;
            }
            else if (Node == "Sports")
            {
                Sport data = response.ResultAs <Sport>();
                startID = data.SportID;
            }
            else if (Node == "Sport Teams")
            {
                SportTeams data = response.ResultAs <SportTeams>();
                startID = data.SportID;
            }
            else if (Node == "Players")
            {
                Players data = response.ResultAs <Players>();
                startID = data.PlayerID;
            }



            //In order to keep unique IDs and count we had to overwrite data
            //This for loop goes througth all instances from the startId to the last instance in database
            //It overwrites the startId instance with the next instance in the database and so on
            //While overwriting it is changing the unique ID
            //If it is on the last instance then it deletes that instance
            for (int i = startID; i <= cnt.cnt; i++)
            {
                if (i == cnt.cnt)
                {
                    FirebaseResponse delete = await client.DeleteTaskAsync(Node + "/" + cnt.cnt);

                    cnt.cnt -= 1;
                    resp     = await client.UpdateTaskAsync("Counter/" + Node, cnt);

                    break;
                }

                FirebaseResponse overwrite = await client.GetTaskAsync(Node + "/" + (i + 1));

                if (Node == "Coaches")
                {
                    Coaches data = overwrite.ResultAs <Coaches>();
                    data.CoachId = i;
                    FirebaseResponse updateIndex = await client.UpdateTaskAsync(Node + "/" + i, data);
                }
                else if (Node == "Extras")
                {
                    Extras data = overwrite.ResultAs <Extras>();
                    data.ExtraID = i;
                    FirebaseResponse updateIndex = await client.UpdateTaskAsync(Node + "/" + i, data);
                }
                else if (Node == "League")
                {
                    League data = overwrite.ResultAs <League>();
                    data.LeagueID = i;
                    FirebaseResponse updateIndex = await client.UpdateTaskAsync(Node + "/" + i, data);
                }
                else if (Node == "Sports")
                {
                    Sport data = overwrite.ResultAs <Sport>();
                    data.SportID = i;
                    FirebaseResponse updateIndex = await client.UpdateTaskAsync(Node + "/" + i, data);
                }
                else if (Node == "Sport Teams")
                {
                    SportTeams data = overwrite.ResultAs <SportTeams>();
                    data.TeamID = i;
                    FirebaseResponse updateIndex = await client.UpdateTaskAsync(Node + "/" + i, data);
                }
                else if (Node == "Players")
                {
                    Players data = overwrite.ResultAs <Players>();
                    data.PlayerID = i;
                    FirebaseResponse updateIndex = await client.UpdateTaskAsync(Node + "/" + i, data);
                }
            }

            MessageBox.Show("Deleted Element of ID: " + txt1.Text);
        }
        //Function when label is enabled and allowed for user interaction
        //For Update: Label ID is used to grab data of certain key
        //For Retrieve: Select labels that you want to be retruned to you
        private async void Select(object sender, MouseButtonEventArgs e)
        {
            if (Action == "Retrieve")
            {
                Label label = sender as Label;              //Sets label

                if (label.FontWeight == FontWeights.Normal) //If font weight is Normal - dont be retrieved
                {
                    label.FontWeight = FontWeights.Bold;    //Set font weight to bold

                    switch (label.Name)                     //Uses label name for switch
                    {
                    case "ID":                              //If ID label
                        //Enables only ID label and textbox
                        //Disables all other labels and textboxes and sets the labels font weight to normal
                        txt1.IsEnabled      = true;
                        AgeLabel            = false;
                        Age.FontWeight      = FontWeights.Normal;
                        Age.IsEnabled       = AgeLabel;
                        txt2.IsEnabled      = false;
                        FNameLabel          = false;
                        FName.FontWeight    = FontWeights.Normal;
                        FName.IsEnabled     = FNameLabel;
                        txt3.IsEnabled      = false;
                        LNameLabel          = false;
                        LName.FontWeight    = FontWeights.Normal;
                        LName.IsEnabled     = LNameLabel;
                        txt4.IsEnabled      = false;
                        PhoneNumLabel       = false;
                        PhoneNum.FontWeight = FontWeights.Normal;
                        PhoneNum.IsEnabled  = PhoneNumLabel;
                        txt5.IsEnabled      = false;
                        RoleLabel           = false;
                        Role.FontWeight     = FontWeights.Normal;
                        Role.IsEnabled      = RoleLabel;
                        txt6.IsEnabled      = false;
                        TeamIDLabel         = false;
                        TeamID.FontWeight   = FontWeights.Normal;
                        TeamID.IsEnabled    = TeamIDLabel;
                        txt7.IsEnabled      = false;
                        break;

                    case "Age":     //Changes cooresponding label and textbox to enabled for all below cases
                        AgeLabel       = true;
                        txt2.IsEnabled = true;
                        break;

                    case "FName":
                        FNameLabel     = true;
                        txt3.IsEnabled = true;
                        break;

                    case "LName":
                        LNameLabel     = true;
                        txt4.IsEnabled = true;
                        break;

                    case "PhoneNum":
                        PhoneNumLabel  = true;
                        txt5.IsEnabled = true;
                        break;

                    case "Role":
                        RoleLabel      = true;
                        txt6.IsEnabled = true;
                        break;

                    case "TeamID":
                        TeamIDLabel    = true;
                        txt7.IsEnabled = true;
                        break;
                    }
                }
                else
                {
                    label.FontWeight = FontWeights.Normal; //Changes weight to normal

                    switch (label.Name)
                    {
                    case "ID":     //If ID label is pressed
                        //Disables ID textbox
                        //Enables all other textboxes and labels
                        txt1.IsEnabled     = false;
                        AgeLabel           = false;
                        Age.IsEnabled      = true;
                        FNameLabel         = false;
                        FName.IsEnabled    = true;
                        LNameLabel         = false;
                        LName.IsEnabled    = true;
                        PhoneNumLabel      = false;
                        PhoneNum.IsEnabled = true;
                        RoleLabel          = false;
                        Role.IsEnabled     = true;
                        TeamIDLabel        = false;
                        TeamID.IsEnabled   = true;
                        break;

                    case "Age":     //Changes cooresponding label and textbox to disables for below cases
                        AgeLabel       = false;
                        txt2.IsEnabled = false;
                        break;

                    case "FName":
                        FNameLabel     = false;
                        txt3.IsEnabled = false;
                        break;

                    case "LName":
                        LNameLabel     = false;
                        txt4.IsEnabled = false;
                        break;

                    case "PhoneNum":
                        PhoneNumLabel  = false;
                        txt5.IsEnabled = false;
                        break;

                    case "Role":
                        RoleLabel      = false;
                        txt6.IsEnabled = false;
                        break;

                    case "TeamID":
                        TeamIDLabel    = false;
                        txt7.IsEnabled = false;
                        break;
                    }
                }
            }
            else if (Action == "Update")
            {
                if (txt1.IsEnabled == false) //If ID textbox is not enabled then enables that textbox and disables and clears all other textboxes
                {
                    txt1.IsEnabled      = true;
                    this.txt2.IsEnabled = false;
                    this.txt3.IsEnabled = false;
                    this.txt4.IsEnabled = false;
                    this.txt5.IsEnabled = false;
                    this.txt6.IsEnabled = false;
                    this.txt7.IsEnabled = false;
                    this.txt2.Text      = "";
                    this.txt3.Text      = "";
                    this.txt4.Text      = "";
                    this.txt5.Text      = "";
                    this.txt6.Text      = "";
                    this.txt7.Text      = "";
                    return;
                }

                FirebaseResponse resp = await client.GetTaskAsync("Counter/" + Node); //Gets count data

                Counter cnt = resp.ResultAs <Counter>();                              //Sets to counter object

                try                                                                   //Catches exception
                {
                    int count = cnt.cnt;

                    int ID = int.Parse(txt1.Text);
                    if (ID > count || ID < 1) //If ID entered is not valid informs user
                    {
                        MessageBox.Show(txt1.Text + " is not a valid ID");
                        return;
                    }
                }
                catch (Exception ex) //Catches exception when input data is incorrect
                {
                    MessageBox.Show(ex.Message + ", Check what you inserted in the Textboxes");
                    return;
                }



                resp = await client.GetTaskAsync(Node + "/" + txt1.Text); //Gets data for cooresponding ID

                //Disables ID textbox
                //Enables all other textboxes
                this.txt1.IsEnabled = false;
                this.txt2.IsEnabled = true;
                this.txt3.IsEnabled = true;
                this.txt4.IsEnabled = true;
                this.txt5.IsEnabled = true;
                this.txt6.IsEnabled = true;
                this.txt7.IsEnabled = true;

                //Puts information from cooresponding ID into textboxes to let user update data
                if (Node == "Coaches")
                {
                    Coaches result = resp.ResultAs <Coaches>();
                    this.txt2.Text = result.Age.ToString();
                    this.txt3.Text = result.FName;
                    this.txt4.Text = result.LName;
                    this.txt5.Text = result.Phone_no;
                    this.txt6.Text = result.Role;
                    this.txt7.Text = result.TeamID.ToString();
                }
                else if (Node == "Extras")
                {
                    Extras result = resp.ResultAs <Extras>();
                    this.txt2.Text = result.Age.ToString();
                    this.txt3.Text = result.FName;
                    this.txt4.Text = result.LName;
                    this.txt5.Text = result.Phone_no;
                    this.txt6.Text = result.Role;
                    this.txt7.Text = result.TeamID.ToString();
                }
            }
        }