private void btnHome_Click(object sender, RoutedEventArgs e)
        {
            Technician_Dispatch dispatch = new Technician_Dispatch();

            dispatch.Show();
            this.Close();
        }
Beispiel #2
0
        private void btnSaveFault_Click(object sender, RoutedEventArgs e)
        {
            int      staffID        = Convert.ToInt32(txtStaffID.Text);
            int      staffMachineID = Convert.ToInt32(txtMachineID.Text);
            int      techID         = Convert.ToInt32(txtTechID.Text);
            int      zone           = Convert.ToInt32(cmbZone.Text);
            string   comments       = txtComments.Text;
            string   status         = "Waiting";
            DateTime date           = DateTime.Now;

            string insertNewJob = "INSERT INTO jobs (reportingStaffID, reportingMachineID, assignedTechnicianID, zoneNo, date_time, status, comments) VALUES (@staffID, @staffMachineID, @techID, @zone, @dateTime, @status, @comments)";

            var cmd = database2.dataConnection(insertNewJob);

            cmd.Parameters.Add("@staffID", OleDbType.Integer).Value        = staffID;
            cmd.Parameters.Add("@staffMachineID", OleDbType.Integer).Value = staffMachineID;
            cmd.Parameters.Add("@techID", OleDbType.Integer).Value         = techID;
            cmd.Parameters.Add("@zone", OleDbType.Integer).Value           = zone;
            cmd.Parameters.Add("@dateTime", OleDbType.Date).Value          = date;
            cmd.Parameters.Add("@status", OleDbType.VarChar).Value         = status;
            cmd.Parameters.Add("@comments", OleDbType.VarChar).Value       = comments;

            var data = database2.parameters();

            try
            {
                MessageBoxResult result = MessageBox.Show("Are you sure you wish to add this job?", "Fault report", MessageBoxButton.YesNo, MessageBoxImage.Warning);

                switch (result)
                {
                case MessageBoxResult.Yes:
                    MessageBox.Show("Job seccessfuly added!", "Fault report", MessageBoxButton.OK, MessageBoxImage.Information);

                    string newRecord = "Added new user reported job: " + staffID + "," + staffMachineID + "," + techID + "," + zone + "," + date + "," + status + "," + comments + "<br>";
                    using (StreamWriter writer = new StreamWriter(@"..\..\..\log.txt", true))
                    {
                        writer.WriteLine(newRecord);
                    }

                    Technician_Dispatch dispatch = new Technician_Dispatch();
                    dispatch.Show();
                    this.Close();

                    break;

                case MessageBoxResult.No:
                    break;
                }
            }
            catch
            {
                MessageBox.Show("Ooops. Something went wrong!", "Fault report", MessageBoxButton.OK, MessageBoxImage.Warning);
            }
        }
        private void userLogin()
        {
            string username = txtUsername.Text;
            string password = txtPassword.Password;

            if (username != "" && password != "")
            {
                var enteredPassword = encrypt.sha256_hash(password);//encrypt entered password

                try
                {
                    string sql = "SELECT username, password, jobTitle FROM users WHERE username= @username AND password= @password";
                    var    cmd = database.dataConnection(sql);

                    cmd.Parameters.Add("@username", OleDbType.VarChar).Value = username;
                    cmd.Parameters.Add("@password", OleDbType.VarChar).Value = enteredPassword;
                    var data = database.parameters();

                    var userUsername = data.Tables[0].Rows[0]["username"].ToString();
                    var userPassword = data.Tables[0].Rows[0]["password"].ToString();
                    var jobTitle     = data.Tables[0].Rows[0]["jobTitle"].ToString();

                    if (username == userUsername && enteredPassword == userPassword && jobTitle == "dispatch manager")//if username, password and job title are correct
                    {
                        Application.Current.Properties["sessionUsername"] = userUsername;

                        Technician_Dispatch dispatch = new Technician_Dispatch();
                        dispatch.Show();
                        this.Close();

                        checkJobs checkJobStatus = new checkJobs();//get the number of waiting and unresolved jobs
                        Array     jobs           = checkJobStatus.checkPendingJobs();

                        int waiting    = Convert.ToInt32(jobs.GetValue(0));
                        int unresolved = Convert.ToInt32(jobs.GetValue(1));

                        if (waiting != 0 || unresolved != 0)
                        {
                            MessageBox.Show("Attention! It appears that there are a few uncompleted jobs!" + "\n" + "\nWaiting: " + waiting + "\nUnresolved: " + unresolved, "Job status", MessageBoxButton.OK, MessageBoxImage.Warning);
                        }
                    }
                    else if (jobTitle != "dispatch manager")
                    {
                        MessageBox.Show("Only dispatch managers are authorized to use this application!", "Login", MessageBoxButton.OK, MessageBoxImage.Error);
                    }
                    else
                    {
                        MessageBox.Show("Failed to LogIn!", "Login", MessageBoxButton.OK, MessageBoxImage.Error);
                    }
                }
                catch
                {
                    MessageBox.Show("Wrong username/password. Please try again!", "Login", MessageBoxButton.OK, MessageBoxImage.Error);
                    txtPassword.Password = "";
                }
            }
            else
            {
                txtUsername.BorderBrush = Brushes.Red;//paint the textbox boarder red if one of the fields is not entered
                txtPassword.BorderBrush = Brushes.Red;
                MessageBox.Show("Username and Password required!", "Login", MessageBoxButton.OK, MessageBoxImage.Information);
            }
        }