//Airport's actions
private void doVehicle()
{
Model.Vehicle mAirport = new Model.Vehicle();
Controller.Vehicle cAirport = new Controller.Vehicle();
if (cmbVehicleActions.SelectedIndex == 0)//nothing
{
MessageBox.Show("Please, choose an action!");
}
else if (cmbVehicleActions.SelectedIndex == 1)//select
{
refreshVehicles();
}
else if (cmbVehicleActions.SelectedIndex == 2)//delete
{
int select = dgvVehicles.CurrentCell.RowIndex;
mAirport.id = Convert.ToInt32(dgvVehicles.Rows[select].Cells["cVehicleId"].Value.ToString());
cAirport = new Controller.Vehicle(mAirport);
cAirport.delete();
refreshAirports();
}
else if (cmbVehicleActions.SelectedIndex == 3)//update
{
saveVecicle();
}
else if (cmbVehicleActions.SelectedIndex == 4)//insert
{
saveVecicle();
}
}
//loads all the vehicles
private void refreshVehicles()
{
try
{
dgvVehicles.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
Controller.Vehicle cPlace = new Controller.Vehicle();
DataTable dtVehicle = cPlace.select();
dgvVehicles.Rows.Clear();
foreach (DataRow row in dtVehicle.Rows)
{
dgvVehicles.Rows.Add(row["id"], row["make"], row["model"], row["type"], row["price"], row["ammount"]);
}
}
catch
{
}
}
//saves an vehicle
private void saveVecicle()
{
try
{
Model.Vehicle mVehicle = new Model.Vehicle();
int select = dgvVehicles.CurrentCell.RowIndex;
mVehicle.make = dgvVehicles.Rows[select].Cells["cVehicleMake"].Value.ToString();
mVehicle.model = dgvVehicles.Rows[select].Cells["cVehicleModel"].Value.ToString();
mVehicle.id = Convert.ToInt32(dgvVehicles.Rows[select].Cells["cVehicleId"].Value.ToString());
mVehicle.type = dgvVehicles.Rows[select].Cells["cVehicleType"].Value.ToString();
mVehicle.price = Convert.ToDouble(dgvVehicles.Rows[select].Cells["cVehiclePrice"].Value.ToString());
mVehicle.ammount = Convert.ToInt32(dgvVehicles.Rows[select].Cells["cVehicleAmmount"].Value.ToString());
Controller.Vehicle cVehcle = new Controller.Vehicle(mVehicle);
cVehcle.insert();
refreshVehicles();
}
catch (Exception e)
{
}
}
