quickly: SECTION $2-[40$ Marks$]$

Question $1$: $(30$ marks$)$

In the provided project the first form is the login screen, amend the code in the login form and the tables in Database to create a log of username and login time for any login attempt.

For example, if the Student$1$ logged in successfully at $10$:$30$ a record must be added to the logs table with $(1,$ Student$1,2024-12-3110$:$30$:$02\mathrm{.}047,$ successful$)$ as $($RecordID$,$ Username, logTime$).$ If the login attempt failed then it should be$(1,$ Student$1,2024-12-3110$:$30$:$02\mathrm{.}047,$ failed$).$ Include also the following requirements:

$$ Verify if the username and password is correct. If correct, the AdminMenu form will be available otherwise, a message that shows $$User does not exist!$$ will be displayed

$$ Save the log in attempt in the Log

You can use GETDATE$()$ to insert the current date and time to your SQL insert statement.

Knowing that the date field should be set to a $($DATETIME$)$ type.

Note: You will need to create the Logs table in your DB in order to insert into it$.$ Logs$($RecordID$,$ Username, logTime$,$ status$)$

Question $2$: $(10$ marks$)$

Create a report form that shows each user attempts and the total attempts for all users.

Make a form and add it to the project to display this report, the form name must be $($AttemptsReport$)$ and it should be linked through the main form of the admin control panel.

Note: you will need to amend the connection string in order to use the provided MDF file. Note: You will need to create the Logs table in your DB in order to insert into it$.$ Logs$($RecordID$,$ Username, logTime$,$ status$)$

Question $2$:

$(10$ marks$)$

Create a report form that shows each user attempts and the total attempts for all users.

Make a form and add it to the project to display this report, the form name must be $($AttemptsReport$)$ and it should be linked through the main form of the admin control panel.

Note: you will need to amend the connection string in order to use the provided MDF file.