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