Answered step by step
Verified Expert Solution
Question
1 Approved Answer
BgDrip is a new textile manufacturer that has recently opened in your area. They sell various clothing items in bulk to various retailers. The business
BgDrip is a new textile manufacturer that has recently opened in your area. They sell various clothing items in bulk to various retailers. The business would like to store details of orders placed in a database. You have been contracted to develop a program that can be used to capture various order details and store them in a database. The owner would like to capture the following details:
Hide
Name
Surname
Email
Product
Unit Price
Quantity
The program should store these details in the database along with the calculated order total.
The following products are sold:
Search
Plain White Tee',
Plain Black Tee, Plain Grey Tee,
'Plain Colour Tee',
'Plain Grey Tee',
'Plain Colour Tee',
'Printed White Tee',
'Printed Black Tee',
Printed Grey Tee',
'Printed Colour Tee',
'Slim Fit Jeans',
Straight Fit Jeans',
'Ripped Jeans',
'LowCut Jeans',
'Plain Sweater',
'Printed Sweater',
'Plain Denim Jacket',
'Printed Denim Jacket',
'Plain Bomber jacket"
'Printed Bomber Jacket',
'Plain Puffer jacket",
'Printed Puffer Jacket'
Write a Python GUI program that helps the business in the above scenario capture booking details and store them in a database use sqlite database The program must have the following components:
GUI: used to capture the order details as shown below.
Database: The details entered in the form must be saved in a database. The database must be implemented in a separate class. The database and the orders table must be created upon class initialization. The class should have a method to insert order details to the database. Note: All database interaction must be done through the class.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started