Plz,I need your help

[sara_22]

Hi all of you
I am student , and our supervisor ask us to make a short course
registration system, but i couldn't do the following
(The user is allowed to attempt to log-in to course database a maximum
of 3 times in a session. If they fail to log in after 3 attempts, they
are prevented from logging into the session from this or any other
terminal.
If the user-id is not recognized at all, the terminal is frozen for 5
minutes.
If the user-id is recognized but the password isn't, the student
record is 'locked' for the full session.
In either type of log-in failure, the attempt is logged on a fault
logging database. If the log-in is successful the student is added to
the session's attendance list.
If the login is successful, the student's attendance record for the
whole course is updated).

plz, i need your help because i am vb.net beginner

 

[Sahil Malik]

Sara,

What exact help do you need?

AT a very top level I can tell you that this is going to be a winforms app
written in either VB.NET or C#.NET, that uses ADO.NET for the database
interaction and simple winforms operations that you need.

The people on this board are extremely helpful but I doubt they'll do your
homework for you though.

- Sahil Malik
http://codebetter.com/blogs/sahil.malik/

Hi all of you
I am student , and our supervisor ask us to make a short course
registration system, but i couldn't do the following
(The user is allowed to attempt to log-in to course database a maximum
of 3 times in a session. If they fail to log in after 3 attempts, they
are prevented from logging into the session from this or any other
terminal.
If the user-id is not recognized at all, the terminal is frozen for 5
minutes.
If the user-id is recognized but the password isn't, the student
record is 'locked' for the full session.
In either type of log-in failure, the attempt is logged on a fault
logging database. If the log-in is successful the student is added to
the session's attendance list.
If the login is successful, the student's attendance record for the
whole course is updated).

plz, i need your help because i am vb.net beginner

 

[sara_22]

Dear Sahil Malik,
Thank you for your replay
I need the steps to do this homework , i will use vb.net as
programming language and ado.net to connect with the course database
but really i can't imagine or understand how the record is locked if
the password is wrong or how the terminal is frozen for five minutes
if the user name is wrong. that is the problem now , i did simple
database and i did the connection.
thankx

 

[Sahil Malik]

sara,

Even though you could implement locking as such, I don't think your exercise
expects you to do so.

I think you should design the windows application as any standard windows
app. And say for this requirement -

The user is allowed to attempt to log-in to course database a maximum
of 3 times in a session. If they fail to log in after 3 attempts, they
are prevented from logging into the session from this or any other
terminal.


Here is how you could implement this --

try login, if it fails, update a "failed count".
If "failed count" ==3
Update a column in the user_password table specifying a "freeze time".

At any login attempt you should check and see if "Freeze Time" + 5 minutes <
TimeRightNow. If it is, simply disallow logon (hence prevented from logging
in).

This way, your requirement is met, and your architecture is disconnected.


- Sahil Malik
http://codebetter.com/blogs/sahil.malik/

Dear Sahil Malik,
Thank you for your replay
I need the steps to do this homework , i will use vb.net as
programming language and ado.net to connect with the course database
but really i can't imagine or understand how the record is locked if
the password is wrong or how the terminal is frozen for five minutes
if the user name is wrong. that is the problem now , i did simple
database and i did the connection.
thankx

 

[sara_22]

Dear Sahil Malik,
you are right, now i understood this but plz i have 2 questions:-
1. In the password fail ,I will start the fai count 3 and with every
fail login , it decrease by one , if it it zero , i should prevent
the user from login by setting the enable of textbox to false , Did
you mean this.
2. Plz , if you can explain more to me as code example
thanx
best regards
sara

 

[Sahil Malik]

Actually what I meant was,

1. Start with a fail count of 0.
2. At every failed login attempt, increment this count.
3. Once the count reaches 3, update another column with the time right now;
this column lets say is "userfailtime".

Now at every login attempt (Step #2 above), you should be checking the
"userfailtime". If "userfailtime" + 5 minutes < "timerightnow" --> Don't let
login, otherwise validate password.

- Sahil Malik
http://codebetter.com/blogs/sahil.malik/

Dear Sahil Malik,
you are right, now i understood this but plz i have 2 questions:-
1. In the password fail ,I will start the fai count 3 and with every
fail login , it decrease by one , if it it zero , i should prevent
the user from login by setting the enable of textbox to false , Did
you mean this.
2. Plz , if you can explain more to me as code example
thanx
best regards
sara

 

[sara_22]

Dear Sahil Malik,
Thank you very much , i will tray it

 

[Sahil Malik]

You're welcome.


--

- Sahil Malik
http://codebetter.com/blogs/sahil.malik/

Dear Sahil Malik,
Thank you very much , i will tray it