import sys
import pymssql
from MainForm import Ui_MainFrom
from PyQt5.QtWidgets import *

class Main(QWidget):
    def __init__(self):
        super(Main, self).__init__()
        self.conn = None

        self.ui = Ui_MainFrom()
        self.ui.setupUi(self)

        self.ui.Log.clicked.connect(self.btn_login_clicked)

        self.show()

    def btn_login_clicked(self):
        try:
            self.conn = pymssql.connect(host="Я-ПК\SQLEXPRESS", user=self.auth.uiauth.Line_login.text(),
                                        password=self.auth.uiauth.Line_password.text(), database="PersonDepartment")
            self.conn.autocommit(True)
            if self.auth.uiauth.Line_login.text() == "admin" and self.auth.uiauth.Line_password.text() == "admin":
                print("admin")
                #self.fadmin = AdminForm(self.conn)
            self.auth.close()
        except pymssql.OperationalError:
            self.auth.uiauth.label_status.setText("Invalid login or password")


if __name__ == '__main__':
    app = QApplication(sys.argv)
    window = Main()

    sys.exit(app.exec_())