//saves an hotel
private void saveHotel()
{
try
{
if (!cmbHotelByLocation.Enabled)
{
Model.Hotel mAirport = new Model.Hotel();
int select = dgvAirport.CurrentCell.RowIndex;
mAirport.name = dgvHotel.Rows[select].Cells["cHotelName"].Value.ToString();
mAirport.roomAmount = Convert.ToInt32(dgvHotel.Rows[select].Cells["cHotelRooms"].Value.ToString());
mAirport.id = Convert.ToInt32(dgvHotel.Rows[select].Cells["cHotelId"].Value.ToString());
mAirport.idPlace = Convert.ToInt32(dgvHotel.Rows[select].Cells["cHotelPlace"].Value.ToString());
Controller.Hotel cAirport = new Controller.Hotel(mAirport);
cAirport.insert();
refreshHotel();
return;
}
else
{
Model.Hotel mAirport = new Model.Hotel();
mAirport.name = dgvHotel.Rows[dgvHotel.Rows.Count - 1].Cells["cHotelName"].Value.ToString();
mAirport.roomAmount = Convert.ToInt32(dgvHotel.Rows[dgvHotel.Rows.Count - 1].Cells["cHotelRooms"].Value.ToString());
mAirport.idPlace = Convert.ToInt32(cmbHotelByLocation.SelectedValue);;
Controller.Hotel cAirport = new Controller.Hotel(mAirport);
cAirport.insert();
}
refreshHotel();
}
catch
{
}
}
//Hotel's actions
private void doHotel()
{
Model.Hotel mAirport = new Model.Hotel();
Controller.Hotel cAirport = new Controller.Hotel();
if (cmbHotelAction.SelectedIndex == 0)//insert
{
MessageBox.Show("Please, choose an action!");
}
else if (cmbHotelAction.SelectedIndex == 1)//insert
{
saveHotel();
}
else if (cmbHotelAction.SelectedIndex == 2)//delete
{
int select = dgvAirport.CurrentCell.RowIndex;
mAirport.id = Convert.ToInt32(dgvHotel.Rows[select].Cells["cHotelId"].Value.ToString());
cAirport = new Controller.Hotel(mAirport);
cAirport.delete();
refreshHotel();
}
else if (cmbHotelAction.SelectedIndex == 3)//update
{
dgvHotel.Enabled = true;
saveHotel();
}
else if (cmbHotelAction.SelectedIndex == 4)//refresh
{
refreshHotel();
}
}
//loads all the hotels
private void refreshHotel()
{
try
{
dgvHotel.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
Controller.Hotel cPlace = new Controller.Hotel();
DataTable dtAirport = cPlace.select();
dgvHotel.Rows.Clear();
foreach (DataRow row in dtAirport.Rows)
{
dgvHotel.Rows.Add(row["id"], row["name"], row["id_place"], row["room_ammount"]);
}
cmbHotelRate.DisplayMember = "Name";
cmbHotelRate.ValueMember = "id";
cmbHotelRate.DataSource = dtAirport;
}
catch
{
}
}
