public static void TouristGuides()
{
TouristGuides touristGuides = new TouristGuides();
touristGuides.Show();
}
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.");
}
}