Exemple #1
0
        private void AddUserBtn_Click(object sender, EventArgs e)
        {
            if (!FormValidator.FirstNameValidation(FirstNameBox.Text))
            {
                string invalidMessage = "Invalid first name.\nValid first name contains:" +
                                        "\n-letters only\n-one uppercase letter at the beginnig" +
                                        "\n-at least one lowercase letter\n-max 25 letters";

                errorProvider1.SetError(FirstNameBox, invalidMessage);
                return;
            }
            if (!FormValidator.LastNameValidation(LastNameBox.Text))
            {
                string invalidMessage = "Invalid last name.\nValid last name contains:" +
                                        "\n-letters only\n-one uppercase letter at the beginnig\n-max 25 letters";

                errorProvider1.SetError(LastNameBox, invalidMessage);
                return;
            }

            errorProvider1.Clear();

            _dataBase.AddUser(FirstNameBox.Text, LastNameBox.Text);

            FirstNameBox.Clear();
            LastNameBox.Clear();
            UpdateUsersBox();
        }
 private void EmptyTextBox()
 {
     FirstNameBox.Clear();
     LastNameBox.Clear();
     EmailBox.Clear();
     PasswordBox.Clear();
     ConPasswordBox.Clear();
 }
Exemple #3
0
 private void ClearFormFields()
 {
     FirstNameBox.Clear();
     SecondNameBox.Clear();
     FacultyBox.Clear();
     DegreeGraduationDate.SelectedDate = DateTime.Today;
     DegreeDomain.Clear();
     DegreeForm.Visibility       = Visibility.Collapsed;
     MakeMasterButton.Visibility = Visibility.Collapsed;
 }
        private void Button_Add(object sender, RoutedEventArgs e)
        {
            Contact Contact = new Contact();

            Contact.FirstName = FirstNameBox.Text;
            Contact.LastName  = LastNameBox.Text;
            Contact.Email     = EmailAddressBox.Text;
            Contact.Phone     = PhoneNumberBox.Text;
            Contacts.Add(Contact);
            FirstNameBox.Clear();
            LastNameBox.Clear();
            EmailAddressBox.Clear();
            PhoneNumberBox.Clear();
        }
        public Student CreateStudent()
        {
            Student NewStudent = new Student();

            NewStudent.FirstName = FirstNameBox.Text;
            NewStudent.LastName  = LastNameBox.Text;
            double.TryParse(GPABox.Text, out double GPA);
            NewStudent.GPA   = GPA;
            NewStudent.Major = MajorBox.Text;

            StudentListBox.Items.Add(NewStudent);

            FirstNameBox.Clear();
            LastNameBox.Clear();
            GPABox.Clear();
            MajorBox.Clear();

            return(NewStudent);
        }
Exemple #6
0
        private void saveBtn(object sender, RoutedEventArgs e)
        {
            try
            {
                var suppModel = new supplier
                {
                    SupplierID  = int.Parse(SuppIdBox.Text),
                    FirstName   = FirstNameBox.Text,
                    LastName    = LastNameBox.Text,
                    Address     = AddressBox.Text,
                    City        = CityBox.Text,
                    PinCode     = int.Parse(PinCodeBox.Text),
                    PhoneNumber = int.Parse(PhoneNrBox.Text),
                    Email       = EmailBox.Text,
                    DateJoin    = DateJoinPicker.SelectedDate,
                    SupplierOf  = SuppBox.Text,
                };

                SuppIdBox.Clear();
                FirstNameBox.Clear();
                LastNameBox.Clear();
                AddressBox.Clear();
                CityBox.Clear();
                PinCodeBox.Clear();
                PhoneNrBox.Clear();
                EmailBox.Clear();
                SuppBox.Clear();

                dc.suppliers.InsertOnSubmit(suppModel);
                dc.SubmitChanges();

                MessageBox.Show("Supplier has been added");
                LoadData();
                LoadWindow();
            }
            catch
            {
                MessageBox.Show("u need to fill out all fields correct");
            }
        }
Exemple #7
0
 private void Clear_form()
 {
     modify               = false;
     SaveButton.Enabled   = false;
     DeleteButton.Enabled = false;
     FirstNameBox.Clear();
     MiddleNmeBox.Clear();
     LastNameBox.Clear();
     GenderBox.Clear();
     Address1Box.Clear();
     Address2Box.Clear();
     CityBox.Clear();
     StateBox.Clear();
     ZipCodeBox.Clear();
     EmailBox.Clear();
     PhoneNumberBox.Clear();
     ResultList.SelectedItems.Clear();
     DateReceivedPicker.Value = DateTime.Today;
     StartTimeBox.Clear();
     SaveTimeBox.Clear();
     BackNumBox.Clear();
 }
Exemple #8
0
        private void saveBtn(object sender, RoutedEventArgs e)
        {
            try
            {
                var empModel = new employee
                {
                    EmployeeID  = int.Parse(EmpIdBox.Text),
                    FirstName   = FirstNameBox.Text,
                    LastName    = LastNameBox.Text,
                    Address     = AddressBox.Text,
                    City        = CityBox.Text,
                    PinCode     = int.Parse(PinCodeBox.Text),
                    PhoneNumber = int.Parse(PhoneNrBox.Text),
                    Email       = EmailBox.Text,
                    JoinDate    = DateJoinPicker.SelectedDate
                };

                EmpIdBox.Clear();
                FirstNameBox.Clear();
                LastNameBox.Clear();
                AddressBox.Clear();
                CityBox.Clear();
                PinCodeBox.Clear();
                PhoneNrBox.Clear();
                EmailBox.Clear();

                dc.employees.InsertOnSubmit(empModel);
                dc.SubmitChanges();

                MessageBox.Show("Employee has been added");
                LoadData();
                LoadWindow();
            }
            catch
            {
                MessageBox.Show("Thats not a valid action");
            }
        }
Exemple #9
0
        /// <summary>
        /// Clears all fields and sets necessary enables/disables to
        /// prepare for new customer entry into database.
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void NewCustomerButton_Click(object sender, EventArgs e)
        {
            FirstNameBox.Clear();
            LastNameBox.Clear();
            AddressBox.Clear();
            CityBox.Clear();
            StateBox.Clear();
            ZipBox.Clear();
            PhoneBox.Clear();
            EmailBox.Clear();
            CustomerSelectBox.Enabled = false;
            CancelButton.Enabled      = true;
            SaveButton.Enabled        = true;
            return;

            /*
             * // When add customer button is first clicked, display message and disable box.
             * if (CustomerSelectBox.Enabled == true)
             * {
             *  MessageBox.Show("To add a customer, fill in the fields and click Add Customer again", "Add Customer");
             *  CustomerSelectBox.Enabled = false;
             *  return;
             * }
             *
             * // Once form is in "add customer" mode, add customer normally.
             * else
             * {
             *  bool valid = true; // Boolean will be set to false if any tests fail, used to check if customer should be saved.
             *  if (FirstNameBox.Text == "" || Regex.IsMatch(FirstNameBox.Text, name))
             *  {
             *      MessageBox.Show("Please enter your first name", "First name is a required field");
             *      FirstNameBox.Focus();
             *      valid = false;
             *  }
             *  if (LastNameBox.Text == "" || Regex.IsMatch(LastNameBox.Text, name))
             *  {
             *      MessageBox.Show("Please enter your last name", "Last name is a required field");
             *      LastNameBox.Focus();
             *      valid = false;
             *  }
             *  if (AddressBox.Text == "" || Regex.IsMatch(AddressBox.Text, address))
             *  {
             *      MessageBox.Show("Please enter your address", "Address is a required field");
             *      AddressBox.Focus();
             *      valid = false;
             *  }
             *  if (CityBox.Text == "" || Regex.IsMatch(CityBox.Text, name))
             *  {
             *      MessageBox.Show("Please enter your city", "City is a required field");
             *      CityBox.Focus();
             *      valid = false;
             *  }
             *  if (StateBox.Text == "" || Regex.IsMatch(StateBox.Text, name))
             *  {
             *      MessageBox.Show("Please enter your state", "State is a required field");
             *      StateBox.Focus();
             *      valid = false;
             *  }
             *  if (ZipBox.Text == "" || Regex.IsMatch(ZipBox.Text, zip))
             *  {
             *      MessageBox.Show("Please enter your zip code", "Zip Code is a required field");
             *      ZipBox.Focus();
             *      valid = false;
             *  }
             *  if (PhoneBox.Text == "" || Regex.IsMatch(PhoneBox.Text, phone))
             *  {
             *      MessageBox.Show("Please enter your phone number", "Phone number is a required field");
             *      PhoneBox.Focus();
             *      valid = false;
             *  }
             *  if (EmailBox.Text == "" || Regex.IsMatch(EmailBox.Text, email))
             *  {
             *      MessageBox.Show("Please enter your email address", "Email is a required field");
             *      EmailBox.Focus();
             *      valid = false;
             *  }
             *
             *  // If no issues, add customer to text file and ComboBox.
             *  if (valid)
             *  {
             *      Customer tempCustomer = new Customer(FirstNameBox.Text, LastNameBox.Text, AddressBox.Text, CityBox.Text, StateBox.Text, ZipBox.Text, PhoneBox.Text, EmailBox.Text);
             *      customers.Add(tempCustomer);
             *
             *      // Close reader and inFile even if exception is thrown.
             *      // SRC:https://stackoverflow.com/questions/86766/how-to-properly-handle-exceptions-when-performing-file-io
             *      try
             *      {
             *          using (FileStream outFile = new FileStream("customers.txt", FileMode.Append, FileAccess.Write))
             *          using (StreamWriter writer = new StreamWriter(outFile))
             *          {
             *              // Write info to file.
             *              writer.WriteLine($"{FirstNameBox.Text},{LastNameBox.Text},{AddressBox.Text},{CityBox.Text},{StateBox.Text},{ZipBox.Text},{PhoneBox.Text},{EmailBox.Text}");
             *              // Clear Text Boxes.
             *              FirstNameBox.Clear();
             *              LastNameBox.Clear();
             *              AddressBox.Clear();
             *              CityBox.Clear();
             *              StateBox.Clear();
             *              ZipBox.Clear();
             *              PhoneBox.Clear();
             *              EmailBox.Clear();
             *              CustomerSelectBox.Items.Add(tempCustomer);
             *              CustomerSelectBox.Enabled = true;
             *          }
             *      }
             *      catch (FileNotFoundException)
             *      {
             *          MessageBox.Show("File 'customers.txt' not found to write.", "File Write Error");
             *      }
             *      // Catch generic I/O exceptions.
             *      catch (IOException ex)
             *      {
             *          MessageBox.Show(ex.ToString(), "Error");
             *      }
             *
             *  }
             * }
             */
        }
Exemple #10
0
        /// <summary>
        /// Clicking button checks if all fields have plausible entires (not empty or wrong format). Then
        /// updates currently selected customer with new information. Uses email as unique identifier, but
        /// does not check if email already exists. (Not sure how...)
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void SaveButton_Click(object sender, EventArgs e)
        {
            bool valid = true; // Boolean will be set to false if any tests fail, used to check if customer should be saved.

            if (FirstNameBox.Text == "" || !Regex.IsMatch(FirstNameBox.Text, name))
            {
                MessageBox.Show("Please enter your first name", "First name is a required field");
                FirstNameBox.Focus();
                valid = false;
            }
            if (LastNameBox.Text == "" || !Regex.IsMatch(LastNameBox.Text, name))
            {
                MessageBox.Show("Please enter your last name", "Last name is a required field");
                LastNameBox.Focus();
                valid = false;
            }
            if (AddressBox.Text == "" || !Regex.IsMatch(AddressBox.Text, address))
            {
                MessageBox.Show("Please enter your address", "Address is a required field");
                AddressBox.Focus();
                valid = false;
            }
            if (CityBox.Text == "" || !Regex.IsMatch(CityBox.Text, city))
            {
                MessageBox.Show("Please enter your city", "City is a required field");
                CityBox.Focus();
                valid = false;
            }
            if (StateBox.Text == "" || !Regex.IsMatch(StateBox.Text, name))
            {
                MessageBox.Show("Please enter your state", "State is a required field");
                StateBox.Focus();
                valid = false;
            }
            if (ZipBox.Text == "" || !Regex.IsMatch(ZipBox.Text, zip))
            {
                MessageBox.Show("Please enter your zip code", "Zip Code is a required field");
                ZipBox.Focus();
                valid = false;
            }
            if (PhoneBox.Text == "" || !Regex.IsMatch(PhoneBox.Text, phone))
            {
                MessageBox.Show("Please enter your phone number", "Phone number is a required field");
                PhoneBox.Focus();
                valid = false;
            }
            if (EmailBox.Text == "" || !Regex.IsMatch(EmailBox.Text, email))
            {
                MessageBox.Show("Please enter your email address", "Email is a required field");
                EmailBox.Focus();
                valid = false;
            }

            // If invalid entry, do not save.
            if (!valid)
            {
                return;
            }

            // Else
            string          ConnectionString = "server=localhost;user=root;database=book store;password="******"Insert into customer values" +
                                  $"('null','{FirstNameBox.Text}'," +
                                  $"'{LastNameBox.Text}'," +
                                  $"'{AddressBox.Text}'," +
                                  $"'{CityBox.Text}'," +
                                  $"'{StateBox.Text}'," +
                                  $"'{ZipBox.Text}'," +
                                  $"'{PhoneBox.Text}'," +
                                  $"'{EmailBox.Text}')";

                cmd.Connection = DBConnect;
                cmd.ExecuteNonQuery();
                DBConnect.Close();

                FirstNameBox.Clear();
                LastNameBox.Clear();
                AddressBox.Clear();
                CityBox.Clear();
                StateBox.Clear();
                ZipBox.Clear();
                PhoneBox.Clear();
                EmailBox.Clear();

                // Call function to update the combobox with new customer added.
                CustomerSelectBox_Click(sender, e);

                CustomerSelectBox.Enabled = true;
                SaveButton.Enabled        = false;
                MessageBox.Show("Customer added to database.");
                return;
            }
            // Else update the currently selected customer with textbox info

            // Extract first and last name into string array.
            string[] custName = new string[2];
            custName = CustomerSelectBox.Text.Split();

            cmd.CommandText = $"Update customer set" +
                              $" first='{FirstNameBox.Text}'," +
                              $"last='{LastNameBox.Text}'," +
                              $"address='{AddressBox.Text}'," +
                              $"city='{CityBox.Text}'," +
                              $"state='{StateBox.Text}'," +
                              $"zip='{ZipBox.Text}'," +
                              $"phone='{PhoneBox.Text}'," +
                              $"email='{EmailBox.Text}'" +
                              $" where first='{custName[0]}' AND last ='{custName[1]}'";
            cmd.Connection = DBConnect;
            cmd.ExecuteNonQuery();
            DBConnect.Close();
            MessageBox.Show("Customer successfully updated.");
            return;



            /*
             * SaveButton.Enabled = false;     // Disable the save button again until new customer is selected from the comboBox.
             *
             * // Rewrite the entire file, omitting the line with the email of the customer that is being updated, since email is unique.
             * // SRC: https://stackoverflow.com/questions/10371630/c-sharp-text-file-search-for-specific-word-and-delete-whole-line-of-text-that-co
             * Customer tempCustomer = (Customer)(CustomerSelectBox.SelectedItem);
             * var oldLines = File.ReadAllLines("customers.txt");
             * var newLines = oldLines.Where(line => !line.Contains(tempCustomer.email));
             * File.WriteAllLines("customers.txt", newLines);
             *
             * customers.Remove((Customer)CustomerSelectBox.SelectedItem);  // Remove old customer info from customer list.
             *
             * // Add new info to list.
             * tempCustomer = new Customer(FirstNameBox.Text, LastNameBox.Text, AddressBox.Text, CityBox.Text, StateBox.Text, ZipBox.Text, PhoneBox.Text, EmailBox.Text);
             * customers.Add(tempCustomer);
             *
             * // Close reader and inFile even if exception is thrown.
             * // SRC:https://stackoverflow.com/questions/86766/how-to-properly-handle-exceptions-when-performing-file-io
             * try
             * {
             *  using (FileStream outFile = new FileStream("customers.txt", FileMode.Append, FileAccess.Write))
             *  using (StreamWriter writer = new StreamWriter(outFile))
             *  {
             *      // Write info to file.
             *      writer.WriteLine($"{FirstNameBox.Text},{LastNameBox.Text},{AddressBox.Text},{CityBox.Text},{StateBox.Text},{ZipBox.Text},{PhoneBox.Text},{EmailBox.Text}");
             *  }
             *
             *  // Clear Text Boxes.
             *  FirstNameBox.Clear();
             *  LastNameBox.Clear();
             *  AddressBox.Clear();
             *  CityBox.Clear();
             *  StateBox.Clear();
             *  ZipBox.Clear();
             *  PhoneBox.Clear();
             *  EmailBox.Clear();
             *
             *  // Update comboBox with new info.
             *  CustomerSelectBox.Items.Remove(CustomerSelectBox.SelectedItem);
             *  CustomerSelectBox.Items.Add(tempCustomer);
             * }
             * catch (FileNotFoundException)
             * {
             *  MessageBox.Show("File 'customers.txt' not found to write.", "File Write Error");
             * }
             * // Catch generic I/O exceptions.
             * catch (IOException ex)
             * {
             *  MessageBox.Show(ex.ToString(), "Error");
             * }
             */
        }
        private void RegisterButton_Click(object sender, EventArgs e)
        {
            //sets connection
            var           connectionString = ConfigurationManager.ConnectionStrings["EmployeeManagement"].ConnectionString;
            SqlConnection con = new SqlConnection(connectionString);


            //opens connection
            con.Open();
            //Creates a command/sql query to select the userid from the database
            SqlCommand checkUserName = new SqlCommand("Select * from Employees where UserID=@Username", con);
            SqlCommand checkEmail    = new SqlCommand("Select * from Employees where Email=@Email", con);

            //Trys to add the current data in the UserID text box to the database
            checkUserName.Parameters.AddWithValue("@Username", this.Username.Text);
            // same checks for the user id the only diffrence is its the email
            checkEmail.Parameters.AddWithValue("@Email", this.EmailBox.Text);
            var result      = checkUserName.ExecuteScalar();
            var emailResult = checkEmail.ExecuteScalar();

            //checks to see if any textboxes are empty if so then it carrys on
            if (FirstNameBox.Text == "" || LastNameBox.Text == "" || DOBpicker.Text == "" || JobTitleBox.Text == "" || EmailBox.Text == "" || Username.Text == "" || Password.Text == "")
            {
                // if a empty a message box shows to ask to enter all fields
                MessageBox.Show("Please enter all fields!");
                //simple return function as we dont want the rest of the code to continue
                return;
            }

            // if both useername and email are not empty and are equal to values in the database it does the following commands
            if (result != null || emailResult != null)
            {
                //if the user name and email is null then set them to red
                if (result != null && emailResult != null)
                {
                    Username.BackColor = Color.LightCoral;
                    EmailBox.BackColor = Color.LightCoral;

                    MessageBox.Show("This Username & Email already exist!");
                }
                //if the username is null set the email to green but the username to red
                else if (result != null)
                {
                    EmailBox.BackColor = Color.LightGreen;
                    Username.BackColor = Color.LightCoral;
                    MessageBox.Show("This Username already exist!");
                }
                //if the email is null set the email to red and the username to green
                else if (emailResult != null)
                {
                    EmailBox.BackColor = Color.LightCoral;
                    Username.BackColor = Color.LightGreen;
                    MessageBox.Show("This Email already exist!");
                }

                //close connection to database
                con.Close();
            }
            //if no duplicates are found it will move on to adding the data to the database
            else
            {
                // creates a new connection
                {
                    //creates the new command to insert values into the database but uses values for neater code
                    Random rnd        = new Random();
                    int    ID         = rnd.Next(2000, 4000);
                    int    Employeeid = ID;

                    //SAME AS REGISTER PAGE
                    SqlCommand EmployeeCheck = new SqlCommand("SELECT * from Employees where EmployeeID='" + Employeeid + "'", con);
                    SqlCommand cmd           = new SqlCommand("insert into Employees (EmployeeID, FirstName, LastName, DOB, Address, Salary, Department, JobTitle, Role, Email, UserID, Password) " + " values(@EmployeeID, @FirstName, @LastName, @DOB, @Address, @Salary, @Department, @JobTitle, @Role, @Email, @UserID, @Password)", con);

                    SqlDataAdapter da = new SqlDataAdapter(EmployeeCheck);
                    DataSet        ds = new DataSet();
                    da.Fill(ds);
                    int i = ds.Tables[0].Rows.Count;
                    if (i > 0)
                    {
                        MessageBox.Show(i.ToString());

                        //create a new id
                        int newID = rnd.Next(2000, 10000);
                        cmd.Parameters.AddWithValue("@EmployeeID", newID);
                        cmd.Parameters.AddWithValue("@FirstName", FirstNameBox.Text);
                        cmd.Parameters.AddWithValue("@LastName", LastNameBox.Text);
                        cmd.Parameters.AddWithValue("@DOB", DOBpicker.Text);
                        cmd.Parameters.AddWithValue("@Address", Address.Text);
                        //sets the salary value to the variable based on which role is selected
                        // CLEAN UP ALL IFS STATEMENTS
                        if (RoleBox.GetItemText(RoleBox.SelectedItem) == "Manager")
                        {
                            cmd.Parameters.AddWithValue("@Salary", Manager);
                        }
                        else if (RoleBox.GetItemText(RoleBox.SelectedItem) == "Engineer")
                        {
                            cmd.Parameters.AddWithValue("@Salary", Engineer);
                        }
                        else if (RoleBox.GetItemText(RoleBox.SelectedItem) == "Team Leader")
                        {
                            cmd.Parameters.AddWithValue("@Salary", TeamLeader);
                        }
                        else if (RoleBox.GetItemText(RoleBox.SelectedItem) == "Engineer Scheduler")
                        {
                            cmd.Parameters.AddWithValue("@Salary", EngineerScheduler);
                        }
                        else if (RoleBox.GetItemText(RoleBox.SelectedItem) == "Senior Developer")
                        {
                            cmd.Parameters.AddWithValue("@Salary", SeniorDevelopment);
                        }
                        else if (RoleBox.GetItemText(RoleBox.SelectedItem) == "Programmer")
                        {
                            cmd.Parameters.AddWithValue("@Salary", Programmer);
                        }
                        else if (RoleBox.GetItemText(RoleBox.SelectedItem) == "Anaylst")
                        {
                            cmd.Parameters.AddWithValue("@Salary", Anaylst);
                        }
                        cmd.Parameters.AddWithValue("@Department", DepartmentBox.GetItemText(DepartmentBox.SelectedItem));
                        cmd.Parameters.AddWithValue("@JobTitle", JobTitleBox.Text);
                        cmd.Parameters.AddWithValue("@Role", RoleBox.GetItemText(RoleBox.SelectedItem));
                        cmd.Parameters.AddWithValue("@Email", EmailBox.Text);
                        cmd.Parameters.AddWithValue("@UserID", Username.Text);
                        decryptedPassword = Password.Text;
                        //adds the password as normal but adds it as an encrypted value
                        cmd.Parameters.AddWithValue("@Password", PasswordLogin.encryptPassword(Password.Text.Trim()));
                        //passing id
                        cmd.ExecuteNonQuery();

                        //shows a succesful message
                        MessageBox.Show("Succesfully Registerd!");

                        FirstNameBox.Clear();
                        LastNameBox.Clear();
                        JobTitleBox.Clear();
                        EmailBox.Clear();
                        Username.Clear();
                        Password.Clear();
                        Address.Clear();
                        DOBpicker.ResetText();
                        RoleBox.ResetText();
                        DepartmentBox.ResetText();
                    }
                    else
                    {
                        cmd.Parameters.AddWithValue("@EmployeeID", Employeeid);
                        cmd.Parameters.AddWithValue("@FirstName", FirstNameBox.Text);
                        cmd.Parameters.AddWithValue("@LastName", LastNameBox.Text);
                        cmd.Parameters.AddWithValue("@DOB", DOBpicker.Text);
                        cmd.Parameters.AddWithValue("@Address", Address.Text);
                        //sets the salary value to the variable based on which role is selected
                        // CLEAN UP ALL IFS STATEMENTS
                        if (RoleBox.GetItemText(RoleBox.SelectedItem) == "Manager")
                        {
                            cmd.Parameters.AddWithValue("@Salary", Manager);
                        }
                        else if (RoleBox.GetItemText(RoleBox.SelectedItem) == "Engineer")
                        {
                            cmd.Parameters.AddWithValue("@Salary", Engineer);
                        }
                        else if (RoleBox.GetItemText(RoleBox.SelectedItem) == "Team Leader")
                        {
                            cmd.Parameters.AddWithValue("@Salary", TeamLeader);
                        }
                        else if (RoleBox.GetItemText(RoleBox.SelectedItem) == "Engineer Scheduler")
                        {
                            cmd.Parameters.AddWithValue("@Salary", EngineerScheduler);
                        }
                        else if (RoleBox.GetItemText(RoleBox.SelectedItem) == "Senior Developer")
                        {
                            cmd.Parameters.AddWithValue("@Salary", SeniorDevelopment);
                        }
                        else if (RoleBox.GetItemText(RoleBox.SelectedItem) == "Programmer")
                        {
                            cmd.Parameters.AddWithValue("@Salary", Programmer);
                        }
                        else if (RoleBox.GetItemText(RoleBox.SelectedItem) == "Anaylst")
                        {
                            cmd.Parameters.AddWithValue("@Salary", Anaylst);
                        }
                        cmd.Parameters.AddWithValue("@Department", DepartmentBox.GetItemText(DepartmentBox.SelectedItem));
                        cmd.Parameters.AddWithValue("@JobTitle", JobTitleBox.Text);
                        cmd.Parameters.AddWithValue("@Role", RoleBox.GetItemText(RoleBox.SelectedItem));
                        cmd.Parameters.AddWithValue("@Email", EmailBox.Text);
                        cmd.Parameters.AddWithValue("@UserID", Username.Text);
                        decryptedPassword = Password.Text;
                        //adds the password as normal but adds it as an encrypted value
                        cmd.Parameters.AddWithValue("@Password", PasswordLogin.encryptPassword(Password.Text.Trim()));
                        cmd.ExecuteNonQuery();
                        //closes connection
                        con.Close();

                        //shows a succesful message
                        MessageBox.Show("Succesfully Registerd!");

                        FirstNameBox.Clear();
                        LastNameBox.Clear();
                        JobTitleBox.Clear();
                        EmailBox.Clear();
                        Username.Clear();
                        Password.Clear();
                        Address.Clear();
                        DOBpicker.ResetText();
                        RoleBox.ResetText();
                        DepartmentBox.ResetText();
                    }
                }
            }
        }
Exemple #12
0
        private void SubmitInfor_Click(object sender, RoutedEventArgs e)
        {
            double GPA;
            bool   Success;
            int    streetnumber;

            if (int.TryParse(streetNumberBox.Text, out streetnumber) == false)
            {
                Success = false;
                MessageBox.Show("Enter a valid Street Number");
            }
            int Zip;

            if (int.TryParse(ZipcodeBox.Text, out Zip) == false)
            {
                Success = false;
                MessageBox.Show("Enter valid Zip Code");
            }

            Student NewStudent = new Student()
            {
                FirstName = FirstNameBox.Text,
                LastName  = LastNameBox.Text,
                GPA       = Convert.ToDouble(GPABox.Text),
                Major     = MajorBox.Text
            };
            Address StudentAddress = new Address()
            {
                StreetNumber = streetnumber,
                StreetName   = streetNameBox.Text,
                State        = stateBox.Text,
                City         = cityBox.Text,
                ZipCode      = Zip
            };

            NewStudent.SetAddress(
                streetnumber,
                streetNameBox.Text,
                stateBox.Text,
                cityBox.Text,
                Zip
                );
            cityBox.Clear();
            FirstNameBox.Clear();
            LastNameBox.Clear();
            GPABox.Clear();
            MajorBox.Clear();
            stateBox.Clear();
            streetNameBox.Clear();
            streetNumberBox.Clear();
            ZipcodeBox.Clear();

            //Address NewStudentAddress = new Address();
            //{
            //    NewStudentAddress.StreetNumber = streetnumber;
            //    NewStudentAddress.StreetName = streetNameBox.Text;
            //    NewStudentAddress.State = stateBox.Text;
            //    NewStudentAddress.City = cityBox.Text;
            //    NewStudentAddress.ZipCode = Zip;

            //}
            ////NewStudentAddress(streetnumber, streetNameBox.Text, stateBox.Text, cityBox.Text, Zip);
            //NewStudent.SetAddress(NewStudentAddress);

            StudentListBox.Items.Add(NewStudent);
        }