public void AddAirport(String name, Location location)
{
Airport airport = new Airport(name, location);
ServiceFactory.GetAirports().AddAirport(airport);
Guid airportID = DBFacade.InsertAirportAndReturnID(name, location);
airport.SetID(airportID);
MessageBox.Show("فرودگاه با موفقیت اضافه شد");
}
public void UpdateTable()
{
airports.Clear();
airpotTable = DBFacade.GetAirports();
for (int i = 0; i < airpotTable.Rows.Count; i++)
{
Guid ID = Guid.Parse(airpotTable.Rows[i]["ID"].ToString());
String name = airpotTable.Rows[i]["name"].ToString();
String country = airpotTable.Rows[i]["country"].ToString();
String city = airpotTable.Rows[i]["city"].ToString();
Location location = new Location(country, city);
airports.Add(new Airport(ID, name, location));
}
}
public static Guid InsertAirportAndReturnID(String name, Location location)
{
SqlCommand cmd = new SqlCommand("InsertAirport", connection);
cmd.Parameters.AddWithValue("@Name", name);
cmd.Parameters.AddWithValue("@Country", location.country);
cmd.Parameters.AddWithValue("@City", location.city);
cmd.CommandType = CommandType.StoredProcedure;
return Guid.Parse(SqlSelect(cmd).Rows[0]["ID"].ToString());
}
private void Initial(Guid ID, String name , Location location)
{
this.ID = ID;
this.name = name;
this.location = location;
}
public Airport(String name, Location location)
{
Initial(new Guid(), name, location);
}
public Airport(Guid ID, String name , Location location)
{
Initial(ID, name, location);
}
