Exemple #1
0
void MainWindow::on_pushButton_login_clicked()
{
    QString username;
    QString password;
    QSqlQuery qry;
    int counter;

    //PROC - Assign input data to QStrings
    username = ui->usernameInputBox->text();
    password = ui->passwordInputBox->text();
    counter = 0;

    if(!database.isOpen())
    {
        qDebug()<< "Failed to open the database!";
    }
    else
    {
        if(qry.exec("SELECT username, password, admin FROM users WHERE username = '******' and password = MD5('" + password + "')"))
        {
            if(qry.next())
            {
                ui->label_status->setText("Username and password is correct.");

                if(qry.value(2).toBool() == true)
                {
                    // Switch to dashboard
                    DashBoardAdminWindow *dashboardWindow;
                    dashboardWindow = new DashBoardAdminWindow();
                    dashboardWindow->show();
                    qDebug() << "Logged in as Admin";
                }
                else
                {
                    // Switch to dashboard
                    DashboardWindow *dashboardWindow;
                    dashboardWindow = new DashboardWindow();
                    dashboardWindow->show();
                    qDebug() << "Logged in as User";
                }

            }
            else
            {
                ui->label_status->setText("Username and password is not correct.");
            }
        }
    }
}
void DashboardWindow::on_actionOpen_triggered() {
    DashboardWindow *dashboard = DashboardWindow::makeDashboard();
    if (dashboard != nullptr)
        dashboard->show();

}