public void CheckActivateCabinet() { string[] args = { Login + "@localhost" }; AvailableTicketsCount = AL.CatchIntResult(Connected, "call throwCountAvailableTickets", args); if (AvailableTicketsCount == 0) { LK_Empty.Visibility = Visibility.Visible; LK_NotEmpty.Visibility = Visibility.Collapsed; } else { LK_Empty.Visibility = Visibility.Collapsed; LK_NotEmpty.Visibility = Visibility.Visible; MySqlDataAdapter ad = new MySqlDataAdapter(); string Query = "call throwAvailableTicketsWithInfo('" + Login + "@localhost')"; ad.SelectCommand = new MySqlCommand(Query, Connected); System.Data.DataTable table = new System.Data.DataTable(); ad.Fill(table); table.Columns[0].ColumnName = "Номер билета"; table.Columns[1].ColumnName = "Номер поезда"; table.Columns[2].ColumnName = "Номер вагона"; table.Columns[3].ColumnName = "Номер места"; table.Columns[4].ColumnName = "Время отправления"; table.Columns[5].ColumnName = "Дата отправления"; table.Columns[6].ColumnName = "Станция отправления"; table.Columns[7].ColumnName = "Время прибытия"; table.Columns[8].ColumnName = "Дата прибытия"; table.Columns[9].ColumnName = "Станция прибытия"; ShowBuyedTickets.ItemsSource = table.DefaultView; } }
private void ThrowTrainListToTable() { var test = new List <TableFillKostil>(); for (int i = 0; i < Routs.Count; i++) { for (int j = 0; j < TrainsList.Count; j++) { if (TrainsList[j] != "-1") { string[] Args = { ArrivalStation, Routs[i], TrainsList[j] }; Arrival_ID = AL.CatchIntResult(_connection, "select GetArrivalID", Args); string[] args = { DepartureStation, Routs[i], TrainsList[j] }; Departure_ID = AL.CatchIntResult(_connection, "select GetDepartureID", args); if ((Arrival_ID != -1) && (Departure_ID != -1)) { var TrainData = AL.TrainInfo(_connection, TrainsList[j], Arrival_ID, Departure_ID); test.Add(new TableFillKostil(TrainData[0], TrainData[1], TrainData[2], TrainData[3], TrainData[4], TrainData[5])); } } } } if (test.Count != 0) { ChooseTrainGRID.ItemsSource = test; } else { AL.MessageErrorShow("При загрузке поездов произошла ошибка. Сообщите об этом администратору", "Ошибка"); } }