void MainWindow::on_actionAdd_train_triggered()
{

    Dialog e;
    if(e.exec())
    {

         if(Add(e.Cities))
         {
             QSqlDatabase db_1 = QSqlDatabase::addDatabase("QSQLITE");
                      db_1.setDatabaseName("C:\\SQLiteDatabaseBrowserPortable\\Data\\cities.db");
                       db_1.open();
                       if(db_1.open())
                           ui->textBrowser_2->append("dwd");
               QSqlQuery r;
                for(int i = 0; i< e.a[0].passangers.size();i++)
                {
             if( r.prepare("INSERT INTO "+e.train_name+"_people"+" (depart_city,arrival_city,firstname,lastname,bot,vagon,place,privileges,distance,ticket_price)"
                                             "VALUES (:depart_city,:arrival_city,:first_name,:lastname,:bot,:vagon,:place,:privileges,:distance,:ticket_price)"))
                              ui->lineEdit->setText("TTT");
             r.bindValue(":depart_city",e.a[0].passangers[0].left_city);
                               r.bindValue(":arrival_city",e.a[0].passangers[i].arrival_city);
                               r.bindValue(":first_name",e.a[0].passangers[i].name);
                              r.bindValue(":lastname",e.a[0].passangers[i].surname);
                               r.bindValue(":bot","bot");
                              r.bindValue(":vagon",e.a[0].passangers[i].wagon);
                               r.bindValue(":place",e.a[0].passangers[i].place);
                               r.bindValue(":privileges","NO");
                               r.bindValue(":distance",e.a[0].passangers[i].way_distance);
                               r.bindValue(":ticket_price",e.a[0].passangers[i].ticket_cost);
                               if(r.exec())
                                   ui->textBrowser_2->append("zbs");
                }
        }
   }

}