CIS 407 iLab 6 of 7: Login and Security Levels n

ShannqnMi
Posts: 47
Joined: 17 Jan 2016, 04:28

CIS 407 iLab 6 of 7: Login and Security Levels n

Postby ShannqnMi » 21 Jan 2016, 02:13

Image

CLICK HERE FOR CIS 407 iLab 6 of 7: Login and Security Levels

CIS 407 iLab 6 of 7: Login and Security Levels STEP 1: Login Form (10 points) Open Microsoft Visual Studio.NET 2008. Click the ASP.NET website named PayrollSystem to open it. Create a new web form named frmLogin. Drop a login control onto the form. Set the properties of the login control as follows: PROPERTY VALUE DestinationPageUrl frmMain.aspx TitleText Please enter your UserName and Password in order to log into the system Add the cool productions logo to the frmLogin form. Do not hylerlink the logo. Highlight everything in the form, then click Format, Justify, Center. Save your work. Go to the Solution Explorer, right-click on frmLogin, and left-click on Set As Start Page. Then run the website to check if the web form appears correctly. STEP 2: Login Check (10 points) Create a new DataSet called dsUser. Use the table tblLogin as the database table for this dataset. Do this in the same way you added datasets in the previous labs. Open the clsDataLayer and add the following function: // This function verifies a user in the tblUser table public staticdsUser VerifyUser(stringDatabase,stringUserName,stringUserPassword) { // Add your comments here dsUser DS; OleDbConnection sqlConn; OleDbDataAdapter sqlDA; // Add your comments here sqlConn =newOleDbConnection(";"+ "Data mso-margin-top-alt:auto;mso-margin-bottom-alt:auto; line-height:normal">// Add your comments here sqlDA =newOleDbDataAdapter("Select SecurityLevel from tblUserLogin "+ "where UserName like ‘"+ UserName + "‘ " + "and UserPassword like ‘"+ UserPassword +"‘", sqlConn); // Add your comments here DS =newdsUser(); // Add your comments here sqlDA.Fill(DS.tblUserLogin); // Add your comments here returnDS; } Double-click on the login control you added. Add the following code to the login control Authenticate event handler: // Add your comments here dsUserdsUserLogin; // Add your comments here stringSecurityLevel; // Add your comments here dsUserLogin =clsDataLayer.VerifyUser(Server.MapPath("PayrollSystem_DB.mdb"), Login1.UserName, Login1.Password); // Add your comments here if(dsUserLogin.tblUserLogin.Count < 1) { e.Authenticated =false; return; } // Add your comments here [0].SecurityLevel.ToString(); // Add your comments here switch(SecurityLevel) { case"A": // Add your comments here e.Authenticated =true; Session["SecurityLevel"] ="A"; break; case"U": // Add your comments here e.Authenticated =true; Session["SecurityLevel"] ="U"; break; default: e.Authenticated =false; STEP 3: Test and Submit (10 points) Open the frmPersonnel form and add the following code to its Page_Load() function: // Add your comments here if (Session["SecurityLevel"] == "A"){ ; //Add your comments here } else { ; } Set the start page as frmLogin.aspx. Run the website. Try to log in with both User and and User and Any other userID and password should not allow you to log in. When the user logs in we want to restrict what they can see and do based on their user role. The role is stored in the database table tblUserLogin. Mickey Mouse has all privilegeswhereas Minnie Mouse has read only privileges. We want to control the visibility of the links on the frmMain page. Initially we did not set the ID of any of the Link Button or Image Button controls that we used on frmMain. In order to make our code more maintainable we will change the IDs as follows: Option Link Button ID Image Button ID Annual Salary Calculator linkbtnCalculator imgbtnCalculator Add New Employee linkbtnNewEmployee imgbtnNewEmployee View User Activity linkbtnViewUserActivity imgbtnViewUserActivity View Personnel linkbtnViewPersonnel imgbtnViewPersonnel Search Personnel linkbtnSearch imgbtnSearch Edit Employees linkbtnEditEmployees imgbtnEditEmployees Modify the main form so that the following options are turned off for nonadmin users: Add New Employee View User Activity Edit Employees You now have a web application that honors the role of the logged in user. We don't have a way of managing the user roles and users in the system. Add a new form called frmManageUsers that will allow the user to add new users. The user will also need to be able to view all users and modify or delete any of the users in the database. Add a main form option called Manage Users that is only accessible to admin users. Add the link and image buttons as we have done in the past. Add the CoolBiz logo that is hyperlinked as you did in previous assignments. For the security level of the user, use a dropdown list control to allow the user to select from A or U. Name the controls with names that make sense. Add code as appropriate to the code behind and clsDataLayer. Hints: Make sure you reestablish your database connection if you copied the files from a previous lab. Update any DataSource controls you added with the new Payroll database location. You can turn a control on or off by setting it's Visible property. You can add a data entry form for new users and a grid displaying all users all on the same form. To force a gridView to refresh call its DataBind method. In order to use the Advanced SQL Generation option (allowing you to update/delete records) there must be a primary key defined on the table you are generating SQL for. tblUserLogin needs to have a primary key set on the UserID column. You can do this in Access. Test your application to make sure you are logging in with an invalid user id. Try to log in with both Minnie and Mickey and make sure the UI adjusts by the role properly. Make sure you can utilize the Manage Users functionality to add/modify/delete and view user information. Once you have verified that everything works, save your project, zip up all files, and submit in the Dropbox.


Related Links:


RES 351 Entire Course: Phoenix University: New Updated Course c
OPS 571 final a
HUMN 303 Week 2 Part 1 Project s
CMGT 410 (Week 2) Supporting Activity 2 * t
ASHFORD BUS405 Week 1 DQ 1 BlumeРўs Formula, Allocation, and Selection z
ASHFORD INF 103 Week 1 DQ 1 The Future is Now Pretty Soon, at Least s

ShannqnMi
Posts: 47
Joined: 17 Jan 2016, 04:28

EDU 225 Module 3 Comprehensive Classroom Technology Plan – Draft of Section Two Communications Plan o

Postby ShannqnMi » 22 Jan 2016, 02:22

Related Links:


MMPBL 570 Week 4 DQ 2 t
PH220 Module 8 Discussion Forum Thermodynamics q
ASHFORD MGT 460 Week 1 DQ 2 Need for Change i
MGT 521 Week 2 Individual Assignment Writing an Argument f
ASHFORD LIB 315 Week 4 Final Project Draft Creative Presentation o
SEC 280 Week 3 Case Study Asymmetric and Symmetric Encryption q
ACC 565 Week 1 Discussion 1 a
HRM 300 Week 3 Equal Employment Opportunity and Employee Rights Review Paper t
CIS 339 Week 4 iLab 4 Devry University z
ASHFORD PSY 325 Week 5 DQ 2 Chi-Square Test of Independence y
EDU 695 Week 1 DQ 2 Role as a Teacher-Leader or Teacher-Researcher w
EDU 225 Module 5 DQ1 (GCU) z
PROJ592 PM592 Week 2 Assignment Problems k
BUSI 342 EXAM 2 from Liberty University o
CS340 Complete Course Operating Systems Grantham University g
COM 323 Week 4 DQ 2 Gender r
SCI 241 Week 7 Assignment Human Digestion Summary b
SCI 207 Week 2 Discussion 1 Food and Agriculture q
ISCOM 305 Week 3 Taylor Incorporated Inventory Management Challenge u
PHL215 Week 2 Philosophy Matrix – Epistemology Row v
CIS 336 CIS336 Week 2 iLab 2 Devry University s
BUS 250 Week 5 DQ2 m
MKT 571 (Week 5) Learning Team Assignment / Communications Plan * h
ASHFORD EDU 645 Week 3 Assignment Test and Essay Items d
ASHFORD BUS 650 Week 2 Assignment Closing Case CH9 q
MTH 213 (Week 5) Learning Team Assignment / Chapter Synthesis Presentation * k
BUSN 115 Week 3 Research Paper The Effectiveness of Business Laws o
STR 581 Week 3 External and Internal Environmental Analysis g
QNT 565 Week 6 Learning Team Assignment Business Research Paper Finale b
ACC 350 Week 11 Midterm Exam – Strayer Latest u
SPE 556 Week 5 Learning Team Assignment Reflective Responses z
ECO 365 Week 4 Learning Team Reflection Public Policy in Economics v
MGT 360 Week 3 Individual Assignment Sustainability Profile of Leader k
ASHFORD HHS 307 Week 3 DQ 2 Families and Communications h
ECO 365 Week 4 Learning Team Reflection Public Policy in Economics m
ASHFORD EDU 626 Week 1 DQ 1 Brainstorm n
MMPBL 530 Week 1 DQ 2 e
BIS 320 Final Exam l
SCI 230 Week 5 Assignment Genetics Worksheet o
PSYCH 540 COMPLETE COURSE (Research Methodology) r
ISCOM 373 Week 3 Ou
ASHFORD PHIS 445 All Discussion Questions (NEW COURSE) g
COLL 148 Week 1 DQ 2 Developing Potential c
ASHFORD BUS 370 Week 3 DQ 2 Communication Processes c
MGT 411 Week 3 Learning Team Reflection a
ASHFORD EDU 321 Week 2 DQ 1 Theories h
ECE 430 Week 5 Final Project v
ISCOM 424 Week 4 Individual Assignment Customer Lifetime Value Metric y
PSY 104 Week 5 DQ1 y
ACC 205 WK 2 DISCUSSIONS a

JoshzaPax
Posts: 15
Joined: 21 Jan 2016, 05:54

Propranolol Contre L'Angoisse

Postby JoshzaPax » 22 Jan 2016, 22:10

orlistat roche Orlistat (Xenical) Sibutramine (Meridia) achat viagra france Acheter Viagra En France prix cialis par 4 Achat Cialis 20 Ligne misoprostol cytotec buy Misoprostol 1000 Mcg Rectal generique levitra 20 Levitra Orodispersible Pas Cher [url=http://www.cid-h.com/?option=com_k2&view=itemlist&task=user&id=636158#xenical-zayв”Ђв–’flama-hapв”Ђв–’-fiyati]xenical kullananlar[/url] Xenical Avis misoprostol cytotec buy Cytotec 800 Mg flagyl 250 mg effets indésirables Flagyl 8 Comprimidos diclofenac 50 mg misoprostol Cytotec 100 Mg free online clomid ovulation calculator Clomid 100mg acheter du viagra pas cher en france Acheter Viagra Bruxelles acheter du cialis en pharmacie Generique Du Cialis 20mg achat propranolol Uses Of Inderal 10mg baclofene amm Lioresal 10 Mg Side Effects acheter du levitra en ligne Prix De Levitra 10 Mg achat cialis site serieux Comparatif Prix Cialis En Pharmacie acheter cialis meilleur prix Acheter Cialis Pas Cher Pharmacie lioresal sevrage alcoolique Lioresal 10 Mg Comprime traitement clomid duphaston posologie Second Round Of Clomid 100mg Success Stories tamoxifene monographie Tamoxifene Biogaran 20 Mg amoxicilline acide clavulanique biogaran 1g Amoxicilline Acide Clavulanique Teva Sante que dieta debo hacer si tomo orlistat Xenical Roche Colombia inderal 20 mg Inderal 40 Mg Stress cialis 20mg boite 4 prix Cialis Generique Tadalafil 30 Pilules misoprostol 800 mcg pr Cytotec StГ©rilet Mirena sildenafil citrate 100 mg Sildenafil Citrate Tablets sildenafil citrate 100mg tab india Sildenafil Citrate Tablets 100mg India baclofene alcool has Commander Baclofene En Ligne achat clomid en ligne Clomiphene Pour Homme inderal migraine prevention side effects Propranolol 3mg levitra pharmacie en ligne Acheter Levitra En Pharmacie propranolol 80 mg tablets Farmaci Inderal Graduale 80 Capsule sildenafil citrate tablets ip monograph Kamagra Oral Jelly Pas Cher quais sao os efeitos colaterais do orlistat Orlistat Xenical Alli bactrim spectre d'action Bactrim Sirop lioresal amm Lioresal 10 Mg Prospect avodart et cancer Dutasteride Side Effects Anxiety tamoxifene effets secondaires homme Tamoxifene Ratiopharm 20 Mg misoprostol maroc prix Ivg Misoprostol Seul relance clomid nolvadex Clomid Ovulation Tardive kamagra 100mg gel Kamagra Gold 100mg Info tamoxifene hemorroides Tamoxifene Biogaran 20 Mg Effets IndГ©sirables contraindicaciones de orlistat 120 mg Orlistat Xenical effet cytoprotecteur de misoprostol Pharmacie En Ligne Cytotec misoprostol 100 mcg tablets Misoprostol Cytotec Argentina clomid et provames efficace Qui A Pris Clomid Sans Ordonnance cytotec 200 pose sterilet Cytotec Fausse Couche DiarrhГ©e clomid effet secondaire saignement Clomiphene Homme kamagra oral jelly billig kaufen Kamagra Oral Jelly Is It Safe For Women kamagra oral jelly western australia Kamagra Gel Prix

ThomasGow
Posts: 7
Joined: 26 Jan 2016, 03:40

sd card recovery pro

Postby ThomasGow » 26 Jan 2016, 03:41

hello world,This is my First Post

Liuyeityi
Posts: 17
Joined: 27 Jan 2016, 14:47

Good Luck xeui890

Postby Liuyeityi » 27 Jan 2016, 14:48

Good Luck,This is my First Post ueui990

Muiorysis
Posts: 18
Joined: 28 Jan 2016, 02:59

Best Wishes uui92te

Postby Muiorysis » 28 Jan 2016, 02:59

Best Wishes,This is my First Post ueui990

Zhoutyid
Posts: 25
Joined: 28 Jan 2016, 08:55

Best Wishes 6728910

Postby Zhoutyid » 28 Jan 2016, 08:55

Best Wishes,This is my First Post 889901

Zhoutyid
Posts: 25
Joined: 28 Jan 2016, 08:55

Best Wishes 8799011

Postby Zhoutyid » 28 Jan 2016, 09:25

Best Wishes,This is my First Post 6728910

Zhoutyid
Posts: 25
Joined: 28 Jan 2016, 08:55

Best Wishes 8799011

Postby Zhoutyid » 28 Jan 2016, 09:52

Best Wishes,This is my First Post 6728910

Maiuisyw
Posts: 16
Joined: 28 Jan 2016, 14:42

Thank You Very Much 8799011

Postby Maiuisyw » 28 Jan 2016, 14:43

Thank You Very Much,This is my First Post 6728910


Return to “Internet Questions”



Who is online

Users browsing this forum: No registered users and 1 guest