system login to connect database use c#

Project Description:

login form
• if login button is clicked, then validate:
- if the username is empty, then show the error message “username must be filled”
- if the password is empty, then show the error message “password must be filled”
- if the role is not chosen, then show the error message “role must be chosen”
- if the chosen role is admin, then the username and password must match with msemployee. and if the chosen role is student, then the username and password must match with msstudent.
- if the username and password combination doesn’t match with data in msemployee and msstudent, then show the error message “invalid username and password!”
- if the username and password combination matches, then show the message “welcome, [employee name/student name]”, the login form will be closed, and other menus will be active according to the role (admin or student).
• if cancel button is clicked, then the login form will be closed.

master form:
• the initial state of form:
- show all data from msstudent in datagridview.
- the datagridview is enabled.
- all fields to input student data are disabled.
- input options for the major combobox (ti, si, and ka).
- set the semester numericupdown minimal value to 1 and maximal value to 8.
- insert, update, delete, and close buttons are enabled.
- browse, submit and cancel buttons are disabled.
• if datagridview is clicked, then show all information from selected row to the existing fields.
• if the role user login is student, then browse, insert, update, delete, submit, and cancel buttons are disabled.
• if insert button is clicked, then:
- the datagridview is disabled.
- all fields to input student data except id are enabled and empty.
- id textbox is automatically generated from msstudent table with format [stxxx] added by 1. for example: if the last id is “st003”, then the program will generate the new id into “st004”. if it is the first student, then the program will generate the new id into “st001”.
- update and delete buttons will be disabled.
- browse, submit, and cancel buttons will be enabled.
• if update button is clicked, then:
- if there isn’t data that is selected, then show the message “pick the data first!”
- all fields to input student data except id are enabled and contain the selected data.
- insert and delete buttons will be disabled.
- browse, submit, and cancel buttons will be enabled.
• if delete button is clicked, then:
- if there isn’t data that is selected, then show the message “you have to choose a data first!”
- show the confirmation message “are you sure want to delete this data?” if the user chooses ‘yes’, then the data will be deleted. if the user chooses ‘no’, the confirmation dialog will be closed.
• if browse button is clicked, then:
- show an openfiledialog to input external image.
- give the openfiledialog a filter, so it could only open .jpg, .jpeg, and .png files.
- copy the chosen image to a certain folder inside the application.
- then the picturebox will show image according to the openfiledialog.
• if submit button is clicked, then validate:
- if the name is empty, then show an error message “name must be filled!”
- if the name length isn’t between 5-15 characters, then show an error message “name must be between 5 and 15 characters!”
- if the name contains any special characters, then show an error message “name may not contain any special characters”.
- if the username is empty, then show an error message “username must be filled!”
- if the username length isn’t between 3-10 characters, then show an error message “username must be between 3 and 10 characters!”
- if the email is empty, then show an error message “email must be filled!”
- if email does not contain the name of the student, then show the warning message “email is not valid”. for example: if the name is joni pohan, then the email format must be [xjonix.xpohanx]@xxx.com. x means you can put anything there, but the first word before dot contain the same word like the first word of the name and the second word after dot contain the second word of the name. the email only contains two words of the name even though the name contains 3 words.
- if major is not selected, then show the message “choose the major”.
- if gender is not selected, then show the message “gender must be selected”.
- if credit is empty, then show the message “credit must be filled”.
- if credit is not numeric, then show the message “credit must be numeric”.
- if picture is not chosen, then show the message “select one picture”.
- if all data have been inputted correctly, then:
1) if the user previously click “insert” button, the application will insert into msstudent. (the password will be generated automatically from the first word of the name combines with random numbers consist of 4 digits)
2) if the user previously click “update” button, the application will update into msstudent according to the selected data before.
3) then the form will return to initial state.
• if cancel button is clicked, then the form will return to initial state.
• if close button is clicked, then the form will be closed.
Skills Required:
Project Stats:

Price Type: Negotiable

Expired
Total Proposals: 4
1 Current viewersl
11 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
  • 4.9
    7 Jobs 7 Reviews
    $0 in 0 Day
  • 0.0
    0 Jobs 0 Reviews
    $0 in 0 Day