//loads all the place private void refreshPlace() { try { dgvPlace.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; Controller.Place cPlace = new Controller.Place(); DataTable dtPlace = cPlace.select(); dgvPlace.Rows.Clear(); foreach (DataRow row in dtPlace.Rows) { dgvPlace.Rows.Add(row["id"], row["name"], row["id_country"]); } cmbPlace.DisplayMember = "Name"; cmbPlace.ValueMember = "id"; cmbPlace.DataSource = dtPlace; cmbAirportsByPlace.DisplayMember = "Name"; cmbAirportsByPlace.ValueMember = "id"; cmbAirportsByPlace.DataSource = dtPlace; cmbHotelByLocation.DisplayMember = "Name"; cmbHotelByLocation.ValueMember = "id"; cmbHotelByLocation.DataSource = dtPlace; } catch { } }
//Saves a place private void savePlace() { try { Model.Place mPlace = new Model.Place(); mPlace.id = Convert.ToInt32(txtPlaceId.Text); mPlace.name = txtPlaceName.Text; mPlace.idCountry = (int)cmbPlaceByPCountry.SelectedValue; Controller.Place cPlaces = new Controller.Place(mPlace); cPlaces.insert(); refreshPlace(); } catch { } }
//does an action of the country tab private void doPlace() { Model.Place mPlace = new Model.Place(); Controller.Place cPlace = new Controller.Place(); if (cmbCountryAction.SelectedIndex == 0) { MessageBox.Show("Please, choose an action!"); cmbPlace.Enabled = false; } else if (cmbPlacesActions.SelectedIndex == 1) //select { refreshCountry(); cmbPlace.Enabled = false; refreshPlace(); } else if (cmbPlacesActions.SelectedIndex == 2) //delete { cmbPlace.Enabled = true; mPlace.id = Convert.ToInt32(cmbPlace.SelectedValue.ToString()); cPlace = new Controller.Place(mPlace); cPlace.delete(); refreshPlace(); } else if (cmbPlacesActions.SelectedIndex == 3) { cmbPlace.Enabled = true; gbNewCountry.Visible = true; gbPlaceActions.Visible = true; txtPlaceId.Text = cmbPlace.SelectedValue.ToString(); } else if (cmbPlacesActions.SelectedIndex == 4) { cmbPlace.Enabled = false; gbPlaceActions.Visible = true; txtPlaceId.Text = "0"; } }