n a coffee shop. The application will assist management with the following: 1. Keep track of all daily and monthly sales using a SQL database 2. Dailly, Monthly, and yearly backup of all sales for future use on a txt file 3. The customer order processing (Type of coffee, quantity, price, total) For the interface design you are only allowed to use Tabs for Management and order module. You will need an extra window to validate the management request to save information to a txt file or to print sales information from the database. The graphical user interface of the application will look as follows: 1. Management
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
You have been tasked to develop a program using Windows Presentation Foundation (WPF)
to be used in a coffee shop. The application will assist management with the following:
1. Keep track of all daily and monthly sales using a SQL
2. Dailly, Monthly, and yearly backup of all sales for future use on a txt file
3. The customer order processing (Type of coffee, quantity, price, total)
For the interface design you are only allowed to use Tabs for Management and order
module. You will need an extra window to validate the management request to save
information to a txt file or to print sales information from the database. The graphical user
interface of the application will look as follows:
1. Management
The management Tab will have several controls as shown on the GUI in Figure 1.1.
Among the controls you will have 3 Buttons (b1, b2, and b3). The user will have to select a
specific period (date, month, or year) they want to save, print, or view information.
Step by step
Solved in 2 steps
