Problem I eBanking You need to build an e-Banking web application to create customers and to manage transactions for a bank. In this exam, you will have to create the ListCustomers.aspx and the ListTransactions.aspx pages related to a customer. All the pages will need to interact with a MS SQL database named ebank stored on the local machine. Your database contains the following tables: - Customers (cust_id integer (PK ), cust_name: varchar (150), cust_iban: varchar (250), cust_status: varchar (30)) - Transactions (trans_id: integer (PK), cust_id: integer, trans_type: integer , ,trans_amount: integer, trans_date: date) *Make sure that your connection string is stored in your Web.config file. *In all of the questions, you dont need to stick to the design. ListCustomersYOURNAME.aspx (70 points) This page allows the user to search, add, update, generate/import xml and delete a Customer. Display the list of customers using the necessary control(s) and allows the user to: a) Search for a customer using iban and customer name (10 points) b) Add a new customer to the Customers table. (10 points) c) Delete a customer from the Customers table. (10 points) d) Update a certain product in the Customers table. (10 points)

The list of customers will be displayed as follows: The button manage transaction allows the user to open the list of transactions related to the customer. The customer id, IBAN and customer Name should be sent as querystring parameters. Also store the customer name in a session with name YOURNAMESession (5 points)

e) Add button to Generate XML for all customers stored (10 points) f) Add a button that read the data from the below xml and store the data in the database o Save the xml into a file yourname.xml and save the data to Customers and Transactions Table (15 points) < Customers > < Customer id=1> toni LBP0123365 Active 1 1000 15/01/2021 2 15/01/2021 < Customer id=2> Sami LB15698 Active 1 15000 18/01/2021