Example #1
0
        private void button3_Click(object sender, EventArgs e)
        {
            string priority;

            if (this.comboBox4.Text == "")
            {
                priority = "";
            }
            else
            {
                priority = ((int)(Priority)Enum.Parse(typeof(Priority), this.comboBox4.Text)).ToString();
            }
            if (LocalStore.currentUser.Role == Role.Admin)
            {
                filteredTickets_ = DatabaseAPI.SelectTickets(
                    this.comboBox6.Text,
                    this.comboBox7.Text,
                    priority,
                    this.comboBox8.Text,
                    this.comboBox9.Text);
            }
            else if (LocalStore.currentUser.Role == Role.Ticket_Editor)
            {
                filteredTickets_ = DatabaseAPI.SelectTicketsToUser(
                    this.comboBox6.Text,
                    this.comboBox7.Text,
                    priority,
                    this.comboBox8.Text,
                    this.comboBox9.Text,
                    LocalStore.currentUser.Username);

                filteredTickets_.AddRange(DatabaseAPI.SelectTicketsFromUser(
                                              this.comboBox6.Text,
                                              this.comboBox7.Text,
                                              priority,
                                              this.comboBox8.Text,
                                              this.comboBox9.Text,
                                              LocalStore.currentUser.Username));
            }
            else if (LocalStore.currentUser.Role == Role.Employee)
            {
                filteredTickets_ = DatabaseAPI.SelectTicketsFromUser(
                    this.comboBox6.Text,
                    this.comboBox7.Text,
                    priority,
                    this.comboBox8.Text,
                    this.comboBox9.Text,
                    LocalStore.currentUser.Username);
            }

            ClearTable(tableLayoutPanel1);
            foreach (Ticket t in filteredTickets_)
            {
                AddTicketToTable(t, tableLayoutPanel1);
            }
        }