//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";
}
}
