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); }