void MainWindow::on_pushButton_clicked()
{
    QSqlDatabase Databasee  = QSqlDatabase::database();
     Databasee =   QSqlDatabase::addDatabase("QMYSQL", "SeccConnection");
    Databasee.setHostName("localhost") ;
    Databasee.setUserName("root");
    Databasee.setPassword("mostafa");
    Databasee.setDatabaseName("Clinic_Database");
    if( QSqlDatabase::contains( "SeccConnection" ) )
    {
        QSqlDatabase db = QSqlDatabase::database( "SeccConnection" );
       // qDebug() << "Donnne" ;
        // now do some stuff with it
    }
    else
    {
    //    qDebug()  << "something error" ;

        // connection not found, do something
    }/*
    if(Databasee.open()){
        qDebug() <<  "Connected" ;
    }else {

       qDebug() << Databasee.lastError().text();
      qDebug() << "not Connected";
    }*/
    /*
    QSqlQuery qr (Databasee) ;
    qr.exec("select * from Employees") ;
    while(qr.next()) {
        qDebug() << qr.value(1) ;

    }*/
    QSqlQueryModel *model = new QSqlQueryModel();
    QSqlQuery *qry = new QSqlQuery(Databasee);

    QString User = ui->lineEdit_Username->text();
    QString Pass = ui->lineEdit_2_Password->text() ;
 // QString ss = "select Name , password from  Employees  WHERE (:Name) = User AND (:Password) = Pass " ;
   qry->prepare(" select Employees.Name , Employees.Password from  Employees WHERE (:Name) = User AND (:Password) = Pass ");
     qry->bindValue(":Name", User) ;
     qry->bindValue(":Password",Pass) ;

        if(qry->exec())
        {
            if(qry->next())
            {
                qDebug()<<  "ok login done";
                model->setQuery(*qry);
                qDebug()<< qry->value(1);
            }
        }
            else{
                qDebug()<< "login fail" ;
                qDebug() << qry->lastError();
            }





        if(qry->exec()){

            if(qry->next()) {
                    qDebug() << User + "Welcome" ;
            }else{
            qDebug() << "Failed" ;
            }


            }


        /*
    while (qr.next())
    {


           qDebug() << qr.value(1).toString() ;


        qDebug() << QSqlDatabase::drivers() << "Error" ;
        qDebug() << qr.lastError();}
    }*/
/*
     while (qr.next())
        {
            if (User == qr.value(1).toString() && Pass ==
                   qr.value(2).toString()
                   )
            {
                // You login a user here
                QString name = qr.value(1).toString();
                qDebug() << name << "is logged in";
            }

    else {
    qDebug() << "Login failed" ;
            }
     }


}*/

}