Make the functions below according to the attached class diagram and GUI program mockup. No The function to be made 1 Create Transaction Order_ID = 1 Order_Date = 11-2-2021 Customer_ID = 2 Customer_RefNo = 001 / I / S / 2021 When the TextField 'txtCustomerID' is filled and we click the 'View' Button, then the TextField 'txtViewCustomerName' will display the 'Customer_Name' field from the Customer's Table according to the input Customer_ID. If the data is not found, a notification will appear “Customer not registered”. 2 Fill in the List Combo Box Product_ID by retrieving data from the Product Fied Table Product_ID 3 If the button ‘Tambah Item’ is clicked, then data from Product_ID, txtProduct_Name, txtQuantity, txtPrice will be saved to the 'Order Detail' Tabke (according to the mockup), then also enter the Sub Total field in the 'Order Detail' table with the calculation of txtQuantity * txtPrice. 4 When the ‘Hapus’ button is clicked, data from Product_ID, txtProduct_Name, txtQuantity, txtPrice will be deleted. 5 Display txtGrandTotal based on Sum of Subtotals from 'Order Detail' Table. 6 Create Order Details with Item 1: Product_ID = 2, Quantity = 4, Price = 11,000 Item 2: Product_ID = 4, Quantity = 2, Price = 21,000 If you press the 'Simpan' button, the data will be saved to the Order and Order_Detail Tables and stock updates to the product table, with the following mechanism: Order: Order_ID = txtOrder_ID, Order_Date = txtOrder_Date, Customer_ID = txtCustomer_ID, Customer_RefNo = txtCustomer_RefNo Order_Detail: Order_ID = txtOrder_ID, Product_ID = ID From the Order Details Table, Quantity = Quantity from the Order Details Table, Price = Price from the Order Details Table Product: Update Stock added Quantity according to the same Item Code. If there are 2 items in the Order Detail Table, you must update the stock to the 2 items. By calculating Stock = Stock - Quantity. For proof, attach the output stock to the product table before and after the transaction. 7 If the 'Keluar' button is clicked it will exit the application
Make the functions below according to the attached class diagram and GUI
No |
The function to be made |
1 |
Create Transaction Order_ID = 1 Order_Date = 11-2-2021 Customer_ID = 2 Customer_RefNo = 001 / I / S / 2021
When the TextField 'txtCustomerID' is filled and we click the 'View' Button, then the TextField 'txtViewCustomerName' will display the 'Customer_Name' field from the Customer's Table according to the input Customer_ID. If the data is not found, a notification will appear “Customer not registered”. |
2 |
Fill in the List Combo Box Product_ID by retrieving data from the Product Fied Table Product_ID |
3 |
If the button ‘Tambah Item’ is clicked, then data from Product_ID, txtProduct_Name, txtQuantity, txtPrice will be saved to the 'Order Detail' Tabke (according to the mockup), then also enter the Sub Total field in the 'Order Detail' table with the calculation of txtQuantity * txtPrice. |
4 |
When the ‘Hapus’ button is clicked, data from Product_ID, txtProduct_Name, txtQuantity, txtPrice will be deleted. |
5 |
Display txtGrandTotal based on Sum of Subtotals from 'Order Detail' Table. |
6 |
Create Order Details with Item 1: Product_ID = 2, Quantity = 4, Price = 11,000 Item 2: Product_ID = 4, Quantity = 2, Price = 21,000
If you press the 'Simpan' button, the data will be saved to the Order and Order_Detail Tables and stock updates to the product table, with the following
Order: Order_ID = txtOrder_ID, Order_Date = txtOrder_Date, Customer_ID = txtCustomer_ID, Customer_RefNo = txtCustomer_RefNo
Order_Detail: Order_ID = txtOrder_ID, Product_ID = ID From the Order Details Table, Quantity = Quantity from the Order Details Table, Price = Price from the Order Details Table
Product: Update Stock added Quantity according to the same Item Code. If there are 2 items in the Order Detail Table, you must update the stock to the 2 items. By calculating Stock = Stock - Quantity. For proof, attach the output stock to the product table before and after the transaction. |
7 |
If the 'Keluar' button is clicked it will exit the application |
Please answer the questions in the order of the questions.
Submit Answers in the form of Java Coding.
Step by step
Solved in 2 steps