from PyQt5.QtWidgets import *
from PyQt5.QtGui import *

from PyQt5.uic import loadUiType
import os,sqlite3

from tensorflow.python.ops.gen_dataset_ops import sql_dataset

PRO_ADDUSER,_ = loadUiType(os.path.join(os.path.dirname(__file__),'AddUser.ui'))

class AddUser(QMainWindow,PRO_ADDUSER):
    def __init__(self,parent=None):
        super(AddUser,self).__init__(parent)
        self.setupUi(self)

        # Here is Clicked Button
        self.btn_Cancel.clicked.connect(self.BtnCancel)
        self.btn_AddNew.clicked.connect(self.insertUserName)
        self.OpenImages.clicked.connect(self.OpenFiles)
        self.lblImages.setText('')


    # Here the Methods
    def BtnCancel(self):
        self.hide()

    def insertUserName(self):
        if self.txtNewUser.text() is '' and self.txtNewWork.text() is '' or  self.txtNewPhone.text() is '':
            QMessageBox.question(self,'Message','الرجاء عدم ترك الحقول فارغة',QMessageBox.Ok)
        else:
            self.name = self.txtNewUser.text()
            self.works = self.txtNewWork.text()
            self.phone = self.txtNewPhone.text()
            self.images = self.fileName
            self.db = sqlite3.connect('dbUser.db')
            self.con = self.db
            if self.con:
                self.cur = self.con
                self.cur.execute('insert into Usr(username,userworks,userphone,userimages) values (?,?,?,?)',(self.name,self.works,self.phone,self.images))
                self.cur.commit()
                self.cur.close()
                print('Insert Database')
            else:
                print('Disconnect Database')

    def OpenFiles(self):
        self.options = QFileDialog.Options()
        self.options |= QFileDialog.DontUseNativeDialog
        self.fileName, _ = QFileDialog.getOpenFileName(self, "QFileDialog.getOpenFileName()", "","All Files (*);;Text Files (*.jpg *.png *.gif)",options=self.options)
        if self.fileName:
            self.lblImages.setPixmap(QPixmap(self.fileName))