private void ToRent(object sender, RoutedEventArgs e)
{
pavilions_class row = (pavilions_class)grid.SelectedItem;
if (row != null)
{
string id_selected_pavilion = row.id_pavilion;
this.Visibility = Visibility.Hidden;
new Rentors(connection, this, selected_id_shop_center, id_selected_pavilion, id_employee);
}
}
public ShowPavilions(SqlConnection connection, Window parent, string selected_id_shop_center, string id_employee)
{
InitializeComponent();
this.Show();
parent.Visibility = Visibility.Hidden;
this.connection = connection;
this.parent = parent;
this.selected_id_shop_center = selected_id_shop_center;
this.id_employee = id_employee;
string sqlExpression = "SELECT * FROM ShowPavilions WHERE shop_center_id = " + selected_id_shop_center + "";
List <pavilions_class> pavilions_list = new List <pavilions_class>();
try
{
SqlCommand command = new SqlCommand(sqlExpression, connection);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
pavilions_class st_rec = new pavilions_class();
st_rec.id_shop_center = reader.GetValue(0).ToString();
st_rec.id_pavilion = reader.GetValue(1).ToString();
st_rec.name_center = reader.GetValue(2).ToString();
st_rec.floor = reader.GetValue(3).ToString();
st_rec.status = reader.GetValue(4).ToString();
st_rec.area = reader.GetValue(5).ToString();
st_rec.price = reader.GetValue(6).ToString();
st_rec.var_coefficient = reader.GetValue(7).ToString();
pavilions_list.Add(st_rec);
}
reader.Close();
grid.ItemsSource = pavilions_list;
grid.Columns[0].Visibility = Visibility.Hidden;
grid.Columns[1].Header = "No-Павильона";
grid.Columns[2].Header = "Торговый центр";
grid.Columns[3].Header = "Этаж";
grid.Columns[4].Header = "Статус";
grid.Columns[5].Header = "Площадь кв.м";
grid.Columns[6].Header = "Цена (кв.м/руб.)";
grid.Columns[7].Header = "Коэффициент";
}
else
{
reader.Close();
grid.ItemsSource = null;
}
}
catch (SqlException e)
{
MessageBox.Show("Произошла ошибка: " + e.Number + "." + e.Message);
this.Close();
}
}
