CMDTgest/mainwindow.cpp at master · Yugo19/CMDTgest · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
#include "mainwindow.h"
#include "./ui_mainwindow.h"
#include "server.h"
#include <QSqlQuery>
#include <QString>
#include <QTextStream>
#include <QFile>
#include <QDebug>
#include <iostream>
#include <QMessageBox>
#include <QSqlDatabase>
#include "home.h"

MainWindow::MainWindow(QWidget *parent)
    : QMainWindow(parent)
    , ui(new Ui::MainWindow)
{
    ui->setupUi(this);

    setWindowIcon(QIcon("C:\\Users\\Wakfu\\Documents\\Inventaire_cmd\\cmdt.ico"));
    /*
    con.connect();
    QSqlQuery *requet = new QSqlQuery;
    requet->prepare("select libelle from fournisseur");
    requet->exec();
    while (requet->next())
    {
        qDebug() << requet->value(0).toString() << requet->value(1).toString();
        //qDebug() << requet->value(1).toString();

    }
    con.disconnect();
    */

    this->setWindowTitle("Connection");

}

MainWindow::~MainWindow()
{
    delete ui;
   // qDebug() << "ui deleted";
}


void MainWindow::on_pushButton_clicked()
{
   con.connect();
   qry = new QSqlQuery();

   qry->prepare("select * from users where Nom='"+ui->lineEdit_2->text()+"' and mot_passe='"+ui->lineEdit->text()+"'");
   qry->exec();

   if(qry->numRowsAffected() ==1)
   {


       con.disconnect();
       window = new Home();
       window->show();
       //delete ui;
       this->close();

       QFile file(filename);

           if (!file.open(QIODevice::ReadOnly | QIODevice::Text | QIODevice::ReadWrite))
           {
               qDebug() << "FAILED TO CREATE FILE / FILE DOES NOT EXIST";
               msg= new QMessageBox;
               msg->setText("Erreur {000x1}");
               msg->show();

           }else
           {
               QTextStream stream(&file);
               stream << ui->lineEdit_2->text();
               stream.flush();
               w = 1;


           }


   }else
   {
       qDebug() << "No query exec";
       QMessageBox *msg = new QMessageBox();
       msg->setText("Erreur veillez réeassyer encore");
       msg->show();

   }

  con.disconnect();


  qDebug() << w ;
  //if(w ==1)
  //{
  //}


}