public static void Offers() { Offers offers = new Offers(); offers.Show(); }
private void PictureBoxSave_Click(object sender, EventArgs e) { string country = textBoxCountry.Text.Trim(); string city = textBoxCity.Text.Trim(); string days = textBoxDays.Text.Trim(); DateTime dateDeparture = dateTimePickerDateDeparture.Value; DateTime dateReturn = dateTimePickerDateReturn.Value; string description = textBoxDescription.Text.Trim(); string price = textBoxPrice.Text.Trim(); string transportPrice = textBoxTransportPrice.Text.Trim(); string capacityAvailable = textBoxCapacityAvailable.Text.Trim(); string hotel = labelHotelID.Text.Trim(); string touristGuide = labelTouristGuideID.Text.Trim(); string visaRequired, room, meals, offerType; visaRequired = (radioButtonVisaRequiredYes.Checked == true) ? "Yes" : "No"; meals = (checkBoxMealsBreakfast.Checked == true) ? "Breakfast " : ""; meals += (checkBoxMealsLunch.Checked == true) ? "Lunch " : ""; meals += (checkBoxMealsDinner.Checked == true) ? "Dinner " : ""; offerType = (radioButtonTypeStandard.Checked == true) ? "Standard" : (radioButtonTypeCruise.Checked == true) ? "Cruise" : (radioButtonTypeLastMinute.Checked == true) ? "Last minute" : ""; room = (radioButtonRoom1Bed.Checked == true) ? "1 bed" : (radioButtonRoom2Beds.Checked == true) ? "2 beds" : (radioButtonRoom3Beds.Checked == true) ? "3 beds" : (radioButtonRoom4Beds.Checked == true) ? "4 beds" : ""; //If there is not empty field insert new offer if (country == "" || city == "" || days == "" || description == "" || price == "" || transportPrice == "" || capacityAvailable == "" || hotel == "0" || touristGuide == "0" || visaRequired == "" || room == "" || offerType == "") { MessageBox.Show("All fields are required, please try again."); } else if (dateDeparture < DateTime.Now || dateReturn < dateDeparture) { MessageBox.Show("There is invalid date, please try again."); } else { SqlCommand cmd = conn.Command("INSERT INTO Offers(country, city, days, date_departure, date_return, visa_required, description, room, meals," + "price, transport_price, capacity_available, offer_type, hotel_id, tourist_guide_id) VALUES " + "(@Country, @City, @Days, @DateDeparture, @DateReturn, @VisaRequired, @Description, @Room, @Meals, @Price, @TransportPrice, " + "@CapacityAvailable, @OfferType, @HotelID, @TouristGuideID)"); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@Country", country); cmd.Parameters.AddWithValue("@City", city); cmd.Parameters.AddWithValue("@Days", Convert.ToInt32(days)); cmd.Parameters.AddWithValue("@DateDeparture", dateDeparture); cmd.Parameters.AddWithValue("@DateReturn", dateReturn); cmd.Parameters.AddWithValue("@VisaRequired", visaRequired); cmd.Parameters.AddWithValue("@Description", description); cmd.Parameters.AddWithValue("@Room", room); cmd.Parameters.AddWithValue("@Meals", meals); cmd.Parameters.AddWithValue("@Price", Convert.ToDecimal(price)); cmd.Parameters.AddWithValue("@TransportPrice", Convert.ToDecimal(transportPrice)); cmd.Parameters.AddWithValue("@CapacityAvailable", Convert.ToInt32(capacityAvailable)); cmd.Parameters.AddWithValue("@OfferType", offerType); cmd.Parameters.AddWithValue("@HotelID", Convert.ToInt32(hotel)); cmd.Parameters.AddWithValue("@TouristGuideID", Convert.ToInt32(touristGuide)); try { conn.OpenConnection(); int result = cmd.ExecuteNonQuery(); if (result > 0) { MessageBox.Show("New offer is successfully added."); Offers offers = new Offers(); offers.Show(); this.Hide(); this.Dispose(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.CloseConnection(); } } }