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
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
| # coding:utf-8
import tkinter
import sqlite3
from tkinter import *
from tkinter import messagebox
import tkinter as tk
from tkinter import ttk
main = tk.Tk()
main.title("Mainapp")
main.configure(bg='lightgrey')
main.geometry("500x300+1500+500")
def show_error():
messagebox.showerror("Erreur", "Il y a eu une erreur!")
def message_doublon():
messagebox.showerror("Erreur", "Client déjà enregistré !")
def enregistrement():
fenetre2 = tkinter.Toplevel(main)
fenetre2.title('reception BDD')
fenetre2.geometry("420x200+1550+550")
fenetre2.attributes('-topmost', True)
# ************************** R E P O N S E *****************************
nomrecu = entrynom.get()
prenomrecu = entryprenom.get()
tel1recu = entrytel1.get()
tel2recu = entrytel2.get()
villerecu = entryville.get()
codepostalrecu = entrycodepostal.get()
pubrecu = entrypub.get()
# label_pub = Label(fenetre2, text='LA PUB EST :' + pubrecu, fg='black', font=('', 10))
# label_pub.grid(row=3, column=0, sticky=W)
# ****** ECRITURE BASE DE DONNEE******************************************
if nomrecu:
connection = sqlite3.connect("D:/Bureau 1/Formation python/BDD/sqlite/base1.db")
cursor = connection.cursor()
# Vérification si le client existe déjà
cursor.execute("SELECT * FROM clients WHERE nom=? AND prenom=?", (nomrecu, prenomrecu))
existant = cursor.fetchone()
if existant:
message_doublon()
return
new_client = (cursor.lastrowid, nomrecu, prenomrecu, tel1recu, tel2recu, villerecu, codepostalrecu, pubrecu)
cursor.execute('INSERT INTO clients VALUES (?,?,?,?,?,?,?,?)', new_client)
connection.commit()
connection.close()
else:
show_error()
# ************************* Q U E S T I O N S Formulaire******************************
labelnom1 = Label(main, text='Nom :', fg='black', bg='lightgray', font=('', 10))
labelnom1.grid(row=0, column=0, sticky=E, padx=0, pady=10)
var_nom = tkinter.StringVar()
entrynom = Entry(main, textvariable=var_nom)
entrynom .grid(row=0, column=1, sticky=W)
labelprenom1 = Label(main, text='Prenom :', fg='black', bg='lightgray', font=('', 10))
labelprenom1.grid(row=0, column=1, padx=0, pady=10, sticky=E)
var_prenom = tkinter.StringVar()
entryprenom = Entry(main, textvariable=var_prenom)
entryprenom .grid(row=0, column=2, sticky=W)
labeltel1 = Label(main, text='Tel_1 :', fg='black', bg='lightgray', font=('', 10))
labeltel1.grid(row=2, column=0, sticky=E)
var_tel1 = tkinter.StringVar()
entrytel1 = Entry(main, textvariable=var_tel1, width=10)
entrytel1 .grid(row=2, column=1, padx=0, pady=10, sticky=W)
labeltel2 = Label(main, text='Tel_2 :', fg='black', bg='lightgray', font=('', 10))
labeltel2.grid(row=2, column=1, sticky=E)
var_tel2 = tkinter.StringVar()
entrytel2 = Entry(main, textvariable=var_tel2, width=10)
entrytel2 .grid(row=2, column=2, padx=0, pady=10, sticky=W)
labelville = Label(main, text='ville :', fg='black', bg='lightgray', font=('', 10))
labelville.grid(row=4, column=0, sticky=E)
var_ville = tkinter.StringVar()
entryville = Entry(main, textvariable=var_ville)
entryville .grid(row=4, column=1, padx=0, pady=10, sticky=W)
labelcodepostal = Label(main, text='codepostal :', fg='black', bg='lightgray', font=('', 10))
labelcodepostal.grid(row=4, column=1, sticky=E)
var_codepostal = tkinter.StringVar()
entrycodepostal = Entry(main, textvariable=var_codepostal, width=6)
entrycodepostal .grid(row=4, column=2, padx=0, pady=10, sticky=W)
# ******************************
labelpub = Label(main, text='pub:', fg='black', bg='lightgray', font=('', 10))
labelpub.grid(row=5, column=0, sticky=E)
listepub = ["Pages Jaunes", "Bouche à Oreille", "Internet", "Pub"]
entrypub = ttk.Combobox(main, values=listepub)
entrypub .grid(row=5, column=1, padx=0, pady=10, sticky=W)
btn_1 = Button(main, text='Enregistrer', command=enregistrement, height=2, width=30)
btn_1.grid(row=8, column=1, padx=20, pady=20, sticky=NSEW)
# Lancement de la boucle d'événement
main.mainloop() |
