public MainWindow() { InitializeComponent(); //load all apartments using (SqlConnection cn = Connector.GetConnection()) { cn.Open(); SqlCommand cmd = new SqlCommand("GetAllApartments", cn); cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlDataReader data = cmd.ExecuteReader(); while (data.Read()) { Apartment ap = new Apartment(data[0].ToString(), data[1].ToString(), Convert.ToInt32(data[2].ToString()), Convert.ToInt32(data[3].ToString()), Convert.ToInt32(data[4].ToString()), Convert.ToInt32(data[5].ToString()), Convert.ToInt32(data[6].ToString())); this.Apartments.Items.Add(ap); } cn.Close(); } //load cities using (SqlConnection cn = Connector.GetConnection()) { cn.Open(); SqlCommand cmd = new SqlCommand("GetCities", cn); cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlDataReader data = cmd.ExecuteReader(); while (data.Read()) { this.City.Items.Add(data[0].ToString()); } cn.Close(); } //load stars this.Stars.Items.Add("1"); this.Stars.Items.Add("2"); this.Stars.Items.Add("3"); this.Stars.Items.Add("4"); this.Stars.Items.Add("5"); }
public void AddApartment(Apartment pApartment) { this.lst.Add(pApartment); }