private void btnEditAirportRoute_Click(object sender, EventArgs e)//____________________________Edit_________________________________
{
int selectedRowCount = dgAirportRoute.Rows.GetRowCount(DataGridViewElementStates.Selected);
if (selectedRowCount == 1)
{
AirportRoute airportRoute = new AirportRoute()
{
AirportRouteID = (int)dgAirportRoute.SelectedRows[0].Cells[0].Value,
Start = dgAirportRoute.SelectedRows[0].Cells[1].Value.ToString(),
Finish = dgAirportRoute.SelectedRows[0].Cells[2].Value.ToString()
};
editAirportRoute.cbEditAirportRoute.Items.Clear();
editAirportRoute.cbEditAirportRoute.ResetText();
IEnumerable <Route> routes = routesDataLink.RetrieveAll();
foreach (Route route in routes)
{
editAirportRoute.cbEditAirportRoute.Items.Add(route.Start + " - " + route.Finish);
}
editAirportRoute.cbEditAirportRoute.SelectedItem = airportRoute.Start + " - " + airportRoute.Finish;
editAirportRoute.airportRouteToEdit = airportRoute;
editAirportRoute.Show();
}
}
private void btnDelAirportRoute_Click(object sender, EventArgs e)//________________________________Del________________________________
{
int selectedRowCount = dgAirportRoute.Rows.GetRowCount(DataGridViewElementStates.Selected);
if (selectedRowCount == 1)
{
AirportRoute selectedAirportRoute = new AirportRoute()
{
AirportRouteID = (int)dgAirportRoute.SelectedRows[0].Cells[0].Value,
Start = dgAirportRoute.SelectedRows[0].Cells[1].Value.ToString(),
Finish = dgAirportRoute.SelectedRows[0].Cells[2].Value.ToString()
};
if (airportEntities.AirportRoutes.Any(airportRoute => airportRoute.AirportRouteID == selectedAirportRoute.AirportRouteID))
{
AirportRoute airportRouteToDelete = airportEntities.AirportRoutes.Single(airportRoute => airportRoute.AirportRouteID == selectedAirportRoute.AirportRouteID);
airportEntities.AirportRoutes.Remove(airportRouteToDelete);
airportEntities.SaveChanges();
delTime();
fillAirportRouteTable();
}
else
{
MessageBox.Show("Маршрут не может быть удален");
}
}
}
/// <summary>
/// Adds a pre-defined AirportRoute to the database.
/// </summary>
///
/// <param name="airportRoute">The AirportRoute to add.</param>
/// <returns>The added AirportRoute.</returns>
public AirportRoute Add(AirportRoute airportRoute)
{
AirportRoute addedAirportRoute = _AirportEntities.AirportRoutes.Add(airportRoute);
_AirportEntities.SaveChanges();
return(addedAirportRoute);
}
/// <summary>
/// Retrieves a AirportRoute from the database.
/// </summary>
///
/// <param name="airportRouteID">The ID of the AirportRoute to retrieve.</param>
///
/// <returns>A AirportRoute object.</returns>
public AirportRoute Retrieve(int airportRouteID)
{
if (!Exists(airportRouteID))
{
throw new ArgumentException("The airportRouteID provided does not exist.");
}
AirportRoute foundAirportRoute = _AirportEntities.AirportRoutes.Single(airportRoute => airportRoute.AirportRouteID == airportRouteID);
return(foundAirportRoute);
}
/// <summary>
/// Updates a AirportRoute in the database.
/// </summary>
///
/// <param name="airportRoute">The updated AirportRouteto modify in the database.</param>
public void Update(AirportRoute airportRoute)
{
if (!Exists(airportRoute.AirportRouteID))
{
throw new ArgumentException("The airportRouteID provided does not exist.");
}
AirportRoute airportRouteToUpdate = _AirportEntities.AirportRoutes.Single(selectedairportRoute => selectedairportRoute.AirportRouteID == airportRoute.AirportRouteID);
airportRouteToUpdate = airportRoute;
_AirportEntities.SaveChanges();
}
private void btnAirportRouteSave_Click(object sender, EventArgs e)
{
if (isValid.isAirportRouteValid(cbEditAirportRoute.SelectedIndex))
{
string s = cbEditAirportRoute.Text;
if ((airportRoutesDataLink.Exists(s.Substring(0, s.IndexOf("-") - 1), s.Substring(s.IndexOf("-") + 2))))
{
MessageBox.Show("Данный маршрут уже выбран");
}
else
{
AirportRoute airportRoute = airportRoutesDataLink.Retrieve(airportRouteToEdit.AirportRouteID);
airportRoute.Start = s.Substring(0, s.IndexOf("-") - 1);
airportRoute.Finish = s.Substring(s.IndexOf("-") + 2);
airportRoutesDataLink.Update(airportRoute);
this.Hide();
}
}
}
private void btnAddAirportRoute_Click(object sender, EventArgs e)//__________________________________Add____________________________________
{
if (isValid.isAirportRouteValid(cbAirportRoute.SelectedIndex))
{
string s = cbAirportRoute.Text;
if (airportRoutesDataLink.Exists(s.Substring(0, s.IndexOf("-") - 1), s.Substring(s.IndexOf("-") + 2)))
{
MessageBox.Show("Данный маршрут уже выбран");
}
else
{
AirportRoute airportRoute = new AirportRoute()
{
Start = s.Substring(0, s.IndexOf("-") - 1),
Finish = s.Substring(s.IndexOf("-") + 2)
};
airportRoutesDataLink.Add(airportRoute);
fillAirportRouteTable();
}
cbAirportRoute.SelectedIndex = -1;
}
}
