help po sql user level in login

[heore25]

pahelp po admin and user or client user po kumpleto na po ako sa forms sa login nlng ng admin at user using sql server po ako halos lahat na kase oledb o msword database eh!! need ko po sa sql server po pahelp po!! ty

- - - Updated - - -

up up up help po codes

- - - Updated - - -

visual studio po na codes salamat po!

 

[denmau09]

ano yun TS? gawa ka ng restrictions sa codes mo na tanging admin level lang pede makaaccess. like may column ka na "User Level" tapos ang laman ay 0 (admin) at 1 (user)

 

[arvinpastoraquio]

pahelp po admin and user or client user po kumpleto na po ako sa forms sa login nlng ng admin at user using sql server po ako halos lahat na kase oledb o msword database eh!! need ko po sa sql server po pahelp po!! ty

- - - Updated - - -

up up up help po codes

- - - Updated - - -

visual studio po na codes salamat po!

add atleast 1 field to your USER table that will distinguish the user only and admin accounts. I cannot give you sample code of the front-end kasi iba2 ang diskarte jan, at d ko din alam kung alin sa login ng user at admin ang problema mo. Anyway, this is the logic:

assuming ang field na ida-dagdag mo is isadmin and 1 = true, 0 = false:

Upon clicking the Login button, query the user id if existing, then fetch the details most especially the isadmin field then
construct an if statement that will determine if the value is 1 then everything on the system is accessible, otherwise, load only those features/modules appropriate to the user.

Hope that will help you sir

 

[heore25]

salamat po sa mga views and reply ang need ko po kase yung pag mag login pag admin userid is for admin lang yung form n gnwa ko hiwalay po sa users or client.. sa sql ko kase may user,pass at utype ako pag abasa ng code na ung utype ko ehh admin.. admin form ilalabas nya pag ang utype nman ay user or client. user form po ung lalabas..


renting system po kase thesis ko naun ehh bali sa system analysis and design po ako naun..

isa ko pa pong prob.. panu po ung pag magdisable ako ng button kahit iclose ung prog. disable pdn?? nagrereset kase pag kinoclose.. naeenabled po kase ulit ehh

- - - Updated - - -

halos lahat po kase pang ms access coding ehh.. oledb.. tntry ko idecode at iedit yung code error ehh.. kuha ko n ung logic yung codes nlang po.. 2nd year plang po ako

 

[arvinpastoraquio]

salamat po sa mga views and reply ang need ko po kase yung pag mag login pag admin userid is for admin lang yung form n gnwa ko hiwalay po sa users or client.. sa sql ko kase may user,pass at utype ako pag abasa ng code na ung utype ko ehh admin.. admin form ilalabas nya pag ang utype nman ay user or client. user form po ung lalabas..


renting system po kase thesis ko naun ehh bali sa system analysis and design po ako naun..

isa ko pa pong prob.. panu po ung pag magdisable ako ng button kahit iclose ung prog. disable pdn?? nagrereset kase pag kinoclose.. naeenabled po kase ulit ehh

- - - Updated - - -

halos lahat po kase pang ms access coding ehh.. oledb.. tntry ko idecode at iedit yung code error ehh.. kuha ko n ung logic yung codes nlang po.. 2nd year plang po ako

Para po sakin hindi ok yang design na per Form ang access restriction mo(pag ako maging panel mo sa defense mo questionable sakin yan). Mas ok siguro kung may MDI form ka, tas disabled lang ang mga specific buttons mo per user access rights. for example, si user walang rights mag delete ng record, dapat the same ang form nila ni admin, un nga lang, pag si user na ang mag login, disabled dapat ung button na delete. Otherwise pag si admin, enabled sya.

Regarding naman sa second problem mo, jan na papasok yung benefits ng sinabi ko sayo sa taas na reply ko, na dapat may unique field ka sa user table para maiset mo ung buttons na dapat disabled/enabled per user rights.

For example:

//upon loading the form after mo ma query yung details(kasama ung sinagest ko na field na isadmin ) ng naglogin na user.
//Assuming na pag 1 ang value ni isadmin field ibig sabihin si admin ang nag login, otherwise si user/client lang.
if(isadmin == 1)
{
//Enabled sya kasi si admin ang naglogin
btnDelete.Enabled = true;
}
else
{
//Disabled sya kasi si user/client lang ang naka login
btnDelete.Enabled = false;
}

Basic lang yan, gusto sana kita bigyan ng sample kaso sophomore ka pa lang pala, masyadong masalimuut yung structure ng codes ko regarding sa user rights. Sa codes ko kasi, may sariling library ako for determining user rights. At hindi lang basta determining kung admin or hindi. Sa codes ko pwede ka mag enable/disable ng access rights anytime sa GUI ng system. kahit si admin pwede mo i-edit yung access nya, meaning, kahit admin pwede mapalitan yung rights nya na maging limited. something like that. For now, sa basic restrictions ka na lang muna. Studyante ka pa lang naman e.

 

[CodingSource]

pahelp po admin and user or client user po kumpleto na po ako sa forms sa login nlng ng admin at user using sql server po ako halos lahat na kase oledb o msword database eh!! need ko po sa sql server po pahelp po!! ty

- - - Updated - - -

up up up help po codes

- - - Updated - - -

visual studio po na codes salamat po!

Pag-aralan mo itong code na ito:

Public Function log() As Boolean
        'This function search database and compatare data's from textFields and check
        'User Account level

        objConn = New SqlCeConnection(mysqconnection)
        objComm = New SqlCeCommand("SELECT Position,FullName,UserName,EmpId,password from tblUserAccount WHERE UserName='" & tbxUserName.Text & "' AND Password='" & tbxPassword.Text & "'", objConn)

        objAdap = New SqlCeDataAdapter(objComm)
        objConn.Open()
        Try
            objAdap.Fill(objDt)


            If tbxUserName.Text = "" And tbxPassword.Text = "" Then
                MsgBox("Enter your Userame and Password!", MsgBoxStyle.Information)
                'If the user entered wrong/blank username and password for 3 times,the application will close
                _mLogincount = _mLogincount + 1
                If _mLogincount >= 3 Then

                    Me.Close()
                End If
                Return False
                tbxUserName.Focus()

            ElseIf tbxUserName.Text = "" Then
                MsgBox("Enter your Username!", MsgBoxStyle.Information)
                'If the user entered wrong/blank username for 3 times, the application will close
                _mLogincount = _mLogincount + 1
                If _mLogincount >= 3 Then

                    Me.Close()
                End If
                Return False
                tbxUserName.Focus()
            ElseIf tbxPassword.Text = "" Then
                MsgBox("Enter your Password!", MsgBoxStyle.Information)
                'If user entered wrong/blank password for 3 times, the application will close
                _mLogincount = _mLogincount + 1
                If _mLogincount >= 3 Then

                    Me.Close()
                End If
                Return False
                tbxUserName.Focus()
            ElseIf objDt.Rows.Count > 0 Then

                Dim reader As SqlCeDataReader = objComm.ExecuteReader
                'call message box form to show information
                MsgForm.lblMsgForm.Text = "Log in Successful!!"
                MsgForm.ShowDialog()
                'Reads the info in the database and check for access level ow yeah!!!
                If reader.Read Then
                    If reader(0) = "ADMINISTRATOR" Then

                        Me.Hide()
                        AlumniMainForm.Show()
                       
                       

                        '*************************************************************************
                    ElseIf reader(0) = "STUDENT ASSISTANT" Then

                        Me.Hide()
                        AlumniMainForm.UserAccountsClick.Visible = False
                        AlumniMainForm.Show()
                        

                        '**************************************************************************
                    ElseIf reader(0) = "SECRETARY" Then
			'YourStatement here
                        Me.Hide()
                        AlumniMainForm.UserAccountsClick.Visible = False
                        AlumniMainForm.Show()
                      
                        'call message box  to show information
                        MsgForm.lblMsgForm.Text = "User Mode"
                        MsgForm.ShowDialog()
                    End If
                End If

            Else
                MsgBox("Incorrect Username or Password!", MsgBoxStyle.Information)
                tbxUserName.Text = ""
                tbxPassword.Text = ""
                _mLogincount = _mLogincount + 1
                If _mLogincount >= 3 Then

                    Me.Close()
                End If
                Return False
                tbxUserName.Focus()
            End If
        Catch ex As Exception
            MsgBox(ex.Message)
        End Try
    End Function

Iyan ang gamit-gamit ko. It'll be very long to explain this code one by one. Ang payo ko lang is replace the connection string sa "platform" na gamit-gamit mo. Remember na importante ang may kaunting tweak sa code na ito kasi hindi ibig sabihin na gumana sa akin ay gagana rin ng ganoon sa iyo. May mga variables dyan na gusto mong palitan, tulad ng pangalan ng textbox, kundi magkaka-error iyan, ha?

 

[heore25]

Para po sakin hindi ok yang design na per Form ang access restriction mo(pag ako maging panel mo sa defense mo questionable sakin yan). Mas ok siguro kung may MDI form ka, tas disabled lang ang mga specific buttons mo per user access rights. for example, si user walang rights mag delete ng record, dapat the same ang form nila ni admin, un nga lang, pag si user na ang mag login, disabled dapat ung button na delete. Otherwise pag si admin, enabled sya.

Regarding naman sa second problem mo, jan na papasok yung benefits ng sinabi ko sayo sa taas na reply ko, na dapat may unique field ka sa user table para maiset mo ung buttons na dapat disabled/enabled per user rights.

For example:

//upon loading the form after mo ma query yung details(kasama ung sinagest ko na field na isadmin ) ng naglogin na user.
//Assuming na pag 1 ang value ni isadmin field ibig sabihin si admin ang nag login, otherwise si user/client lang.
if(isadmin == 1)
{
//Enabled sya kasi si admin ang naglogin
btnDelete.Enabled = true;
}
else
{
//Disabled sya kasi si user/client lang ang naka login
btnDelete.Enabled = false;
}

Basic lang yan, gusto sana kita bigyan ng sample kaso sophomore ka pa lang pala, masyadong masalimuut yung structure ng codes ko regarding sa user rights. Sa codes ko kasi, may sariling library ako for determining user rights. At hindi lang basta determining kung admin or hindi. Sa codes ko pwede ka mag enable/disable ng access rights anytime sa GUI ng system. kahit si admin pwede mo i-edit yung access nya, meaning, kahit admin pwede mapalitan yung rights nya na maging limited. something like that. For now, sa basic restrictions ka na lang muna. Studyante ka pa lang naman e.

salamat po ng sir!!

nka mdi po ako! madami po kasing form for rooms, guest,checkin , check out, reservation, at mga gusto mangyari ng dormitel n gingawa ko bali po mdi yung user peu 1 form lng ang admin.. bali po andun lahat ng delete at edit! andun po yung access para mag add ng acct. users at mga restricted important na para lng po sa admin!!

salamat po sa reply!

- - - Updated - - -

Pag-aralan mo itong code na ito:

Public Function log() As Boolean
        'This function search database and compatare data's from textFields and check
        'User Account level

        objConn = New SqlCeConnection(mysqconnection)
        objComm = New SqlCeCommand("SELECT Position,FullName,UserName,EmpId,password from tblUserAccount WHERE UserName='" & tbxUserName.Text & "' AND Password='" & tbxPassword.Text & "'", objConn)

        objAdap = New SqlCeDataAdapter(objComm)
        objConn.Open()
        Try
            objAdap.Fill(objDt)


            If tbxUserName.Text = "" And tbxPassword.Text = "" Then
                MsgBox("Enter your Userame and Password!", MsgBoxStyle.Information)
                'If the user entered wrong/blank username and password for 3 times,the application will close
                _mLogincount = _mLogincount + 1
                If _mLogincount >= 3 Then

                    Me.Close()
                End If
                Return False
                tbxUserName.Focus()

            ElseIf tbxUserName.Text = "" Then
                MsgBox("Enter your Username!", MsgBoxStyle.Information)
                'If the user entered wrong/blank username for 3 times, the application will close
                _mLogincount = _mLogincount + 1
                If _mLogincount >= 3 Then

                    Me.Close()
                End If
                Return False
                tbxUserName.Focus()
            ElseIf tbxPassword.Text = "" Then
                MsgBox("Enter your Password!", MsgBoxStyle.Information)
                'If user entered wrong/blank password for 3 times, the application will close
                _mLogincount = _mLogincount + 1
                If _mLogincount >= 3 Then

                    Me.Close()
                End If
                Return False
                tbxUserName.Focus()
            ElseIf objDt.Rows.Count > 0 Then

                Dim reader As SqlCeDataReader = objComm.ExecuteReader
                'call message box form to show information
                MsgForm.lblMsgForm.Text = "Log in Successful!!"
                MsgForm.ShowDialog()
                'Reads the info in the database and check for access level ow yeah!!!
                If reader.Read Then
                    If reader(0) = "ADMINISTRATOR" Then

                        Me.Hide()
                        AlumniMainForm.Show()
                       
                       

                        '*************************************************************************
                    ElseIf reader(0) = "STUDENT ASSISTANT" Then

                        Me.Hide()
                        AlumniMainForm.UserAccountsClick.Visible = False
                        AlumniMainForm.Show()
                        

                        '**************************************************************************
                    ElseIf reader(0) = "SECRETARY" Then
			'YourStatement here
                        Me.Hide()
                        AlumniMainForm.UserAccountsClick.Visible = False
                        AlumniMainForm.Show()
                      
                        'call message box  to show information
                        MsgForm.lblMsgForm.Text = "User Mode"
                        MsgForm.ShowDialog()
                    End If
                End If

            Else
                MsgBox("Incorrect Username or Password!", MsgBoxStyle.Information)
                tbxUserName.Text = ""
                tbxPassword.Text = ""
                _mLogincount = _mLogincount + 1
                If _mLogincount >= 3 Then

                    Me.Close()
                End If
                Return False
                tbxUserName.Focus()
            End If
        Catch ex As Exception
            MsgBox(ex.Message)
        End Try
    End Function

Iyan ang gamit-gamit ko. It'll be very long to explain this code one by one. Ang payo ko lang is replace the connection string sa "platform" na gamit-gamit mo. Remember na importante ang may kaunting tweak sa code na ito kasi hindi ibig sabihin na gumana sa akin ay gagana rin ng ganoon sa iyo. May mga variables dyan na gusto mong palitan, tulad ng pangalan ng textbox, kundi magkaka-error iyan, ha?

salamat po sa codes!! magaling po ako magdecode trial and error lng po!! di lang po ako knowledgable sa mga codes! yung ako mismo gagawa!! nag aaral plang po ehh!! salamat po dito!!

 

[CodingSource]

salamat po ng sir!!

nka mdi po ako! madami po kasing form for rooms, guest,checkin , check out, reservation, at mga gusto mangyari ng dormitel n gingawa ko bali po mdi yung user peu 1 form lng ang admin.. bali po andun lahat ng delete at edit! andun po yung access para mag add ng acct. users at mga restricted important na para lng po sa admin!!

salamat po sa reply!

- - - Updated - - -





salamat po sa codes!! magaling po ako magdecode trial and error lng po!! di lang po ako knowledgable sa mga codes! yung ako mismo gagawa!! nag aaral plang po ehh!! salamat po dito!!

Mabuti naman kung ganun . I believe you are knowledgeable enough to succeed. Take your time

 

[heore25]

Mabuti naman kung ganun . I believe you are knowledgeable enough to succeed. Take your time

salamat po... ok na po yung user levels ko.. ang prob ko nlang po kung panu ko ma mamaintain yung mga disabled na buttons ko pag close ko at pag run again nagrerest pero yung mga data nakakapsok sa sql database ko.. tsaka panu ko oo b mlalagay sa system tray yung mdi ko pag uclose o minimize??

- - - Updated - - -

may binago po pala ko sa codes n binigay nyo imbus n magcclose po yung form pag 3 times mali.. hhingi nlang ng admin pass to enabled yung login ang prob pag close at run ulit enabled ulit.. dpat kase magbgay mna ng password para mpagana ung system n admin lang nkkaalam for security purposes po.