Ejemplo n.º 1
0
        public static void TouristGuides()
        {
            TouristGuides touristGuides = new TouristGuides();

            touristGuides.Show();
        }
Ejemplo n.º 2
0
        private void PictureBoxSave_Click(object sender, EventArgs e)
        {
            string   firstName         = textBoxFirstName.Text.Trim();
            string   lastName          = textBoxLastName.Text.Trim();
            string   JMBG              = textBoxJMBG.Text.Trim();
            string   gender            = textBoxGender.Text.Trim();
            string   address           = textBoxAddress.Text.Trim();
            string   phone             = textBoxPhone.Text.Trim();
            string   email             = textBoxEmail.Text.Trim();
            string   education         = textBoxEducation.Text.Trim();
            DateTime dateOfHire        = dateTimePickerDateOfHire.Value;
            string   jobTitle          = textBoxJobTitle.Text.Trim();
            string   salary            = textBoxSalary.Text.Trim();
            string   availableLocation = textBoxLocationCapable.Text.Trim();

            //If there is not empty field insert new tourist guide
            if (firstName != "" || lastName != "" || JMBG != "" || gender != "" || address != "" || phone != "" || email != "" || education != "" || jobTitle != "" || salary != "" || availableLocation != "")
            {
                SqlCommand cmd = conn.Command("INSERT INTO TouristGuides(first_name, last_name, email, JMBG, gender, address, phone, education, date_of_hire, job_title, salary, available_for_location) VALUES " +
                                              "(@FirstName, @LastName, @Email, @JMBG, @Gender, @Address, @Phone, @Education, @DateOfHire, @JobTitle, @Salary, @AvailableForLocation)");
                cmd.Parameters.Clear();
                cmd.Parameters.AddWithValue("@FirstName", firstName);
                cmd.Parameters.AddWithValue("@LastName", lastName);
                cmd.Parameters.AddWithValue("@Email", email);
                cmd.Parameters.AddWithValue("@JMBG", JMBG);
                cmd.Parameters.AddWithValue("@Gender", gender);
                cmd.Parameters.AddWithValue("@Address", address);
                cmd.Parameters.AddWithValue("@Phone", phone);
                cmd.Parameters.AddWithValue("@Education", education);
                cmd.Parameters.AddWithValue("@DateOfHire", dateOfHire);
                cmd.Parameters.AddWithValue("@JobTitle", jobTitle);
                cmd.Parameters.AddWithValue("@Salary", Convert.ToInt32(salary));
                cmd.Parameters.AddWithValue("@AvailableForLocation", availableLocation);

                try
                {
                    conn.OpenConnection();
                    int result = cmd.ExecuteNonQuery();

                    if (result > 0)
                    {
                        MessageBox.Show("New tourist guide is successfully added.");

                        TouristGuides touristGuides = new TouristGuides();
                        touristGuides.Show();
                        this.Hide();
                        this.Dispose();
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
                finally
                {
                    conn.CloseConnection();
                }
            }
            else
            {
                MessageBox.Show("All fields are required, please try again.");
            }
        }