Пример #1
0
        private void button1_Click(object sender, EventArgs e)
        {
            Console.WriteLine(this.textBox1.Text);
            Console.WriteLine(this.textBox2.Text);

            LocalStore.currentUser = DatabaseAPI.SelectUser(this.textBox1.Text);
            if (LocalStore.currentUser == null)
            {
                Console.WriteLine("Invalid username.");
                label3.Text        = "Invalid username!";
                this.textBox1.Text = "";
                this.textBox2.Text = "";
            }
            else
            {
                label3.Text = "";
                string hashedPassword = sha256(this.textBox2.Text);
                if (LocalStore.currentUser.Password == hashedPassword)
                {
                    FormStorer.Add("Dashboard", new Dashboard());
                    FormStorer.Get("Login").Visible = false;
                    ((Dashboard)FormStorer.Get("Dashboard")).SetCurrentUser();
                    FormStorer.Get("Dashboard").Visible = true;
                }
                else
                {
                    Console.WriteLine("Invalid password.");
                    label3.Text        = "Invalid password!";
                    this.textBox1.Text = "";
                    this.textBox2.Text = "";
                }
            }
        }
Пример #2
0
        private void button2_Click(object sender, EventArgs e)
        {
            Ticket ticket = new TicketManager.Ticket()
            {
                Name        = this.textBox1.Text,
                Department  = (Department)Enum.Parse(typeof(Department), this.comboBox1.Text),
                ToUser      = this.comboBox2.Text,
                Priority    = (Priority)Enum.Parse(typeof(Priority), this.comboBox3.Text),
                Category    = (Category)Enum.Parse(typeof(Category), this.comboBox5.Text),
                FromUser    = LocalStore.currentUser.Username,
                Date        = DateTime.Now,
                State       = State.Assigned,
                Description = this.richTextBox1.Text
            };

            Console.Write("Created ticket:\n" + ticket);
            DatabaseAPI.AddTicket(ticket);

            this.textBox1.Text     = "";
            this.comboBox1.Text    = "";
            this.comboBox2.Text    = "";
            this.comboBox3.Text    = "";
            this.comboBox5.Text    = "";
            this.richTextBox1.Text = "";
        }
Пример #3
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);
            }
        }
Пример #4
0
 public static void UpdateUsers(ArrayList userList)
 {
     Console.WriteLine("Updated users: ");
     foreach (User u in userList)
     {
         Console.Write(u);
     }
     users = userList;
     DatabaseAPI.UpdateUsers(userList);
 }
Пример #5
0
        static void Main()
        {
            Application.EnableVisualStyles();
            Application.SetCompatibleTextRenderingDefault(false);
            FormStorer.Add("Login", new Login());

            Database.Instance().SetConnection("C:\\Madalin\\TicketManager\\database.mdf");
            Database.Instance().ExecuteQueryFromFile("..\\..\\PopulateUsersTable.sql");
            Database.Instance().ExecuteQueryFromFile("..\\..\\PopulateTicketsTable.sql");

            ArrayList users = DatabaseAPI.SelectUsers();

            foreach (User u in users)
            {
                Console.Write(u);
            }
            DatabaseAPI.SelectTickets();

            Application.Run(FormStorer.Get("Login"));
        }
Пример #6
0
        private void button4_Click(object sender, EventArgs e)
        {
            // gather tickets from table
            ArrayList gatheredTickets = new ArrayList();

            for (int i = 1; i < tableLayoutPanel1.RowCount; i++)
            {
                Ticket t = new Ticket();
                t.Name        = tableLayoutPanel1.GetControlFromPosition(1, i).Text;
                t.FromUser    = tableLayoutPanel1.GetControlFromPosition(2, i).Text;
                t.ToUser      = tableLayoutPanel1.GetControlFromPosition(3, i).Text;
                t.Priority    = (Priority)Enum.Parse(typeof(Priority), tableLayoutPanel1.GetControlFromPosition(4, i).Text);
                t.Department  = (Department)Enum.Parse(typeof(Department), tableLayoutPanel1.GetControlFromPosition(5, i).Text);
                t.Category    = (Category)Enum.Parse(typeof(Category), tableLayoutPanel1.GetControlFromPosition(6, i).Text);
                t.Date        = DatabaseAPI.ParseDateFromDB(tableLayoutPanel1.GetControlFromPosition(7, i).Text);
                t.State       = (State)Enum.Parse(typeof(State), tableLayoutPanel1.GetControlFromPosition(8, i).Text);
                t.Description = tableLayoutPanel1.GetControlFromPosition(9, i).Text;

                gatheredTickets.Add(t);
            }

            // update database with tickets
            DatabaseAPI.ReplaceTickets(filteredTickets_, gatheredTickets);
        }
Пример #7
0
 public static void LoadUsersFromDB()
 {
     Console.WriteLine("Loading users from database...");
     users = DatabaseAPI.SelectUsers();
 }