home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
41-134-104-147.dsl.mweb.co.za
/
41-134-104-147.dsl.mweb.co.za.tar
/
41-134-104-147.dsl.mweb.co.za
/
Default.aspx.vb
< prev
next >
Wrap
Text File
|
2010-08-24
|
3KB
|
59 lines
Imports System.Data
Partial Class _Default
Inherits System.Web.UI.Page
Dim myFunctions As New Functions
Protected Sub imgLogin_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles imgLogin.Click
Dim idNumber As String = txtIDNumber.Text
Dim cardNumber As String = txtHealthCardNumber.Text
Dim surname As String = txtSurname.Text
Dim password As String = txtPassword.Text
Dim validLogin As Boolean = testLogin(idNumber, cardNumber, surname, password)
If Not validLogin Then
'lblInvalidLogin.Text = "Invalid Login Details used. Please retry"
Else
myFunctions.logMe(Request.Cookies("hcUid").Value, "Logged in")
Response.Redirect("~/enquiries.aspx", True)
End If
End Sub
Protected Sub ImageButton1_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles ImageButton1.Click
Response.Redirect("~/otherEnq.aspx", True)
End Sub
Private Function testLogin(ByVal idNumber As String, ByVal cardNumber As String, ByVal surname As String, ByVal password As String) As Boolean
Dim success As Boolean = False
Dim sqlStr As String = "SELECT id, surname, cardNumber"
sqlStr &= " FROM tblMembers"
sqlStr &= " WHERE (surname = @surname) AND (password = @password) OR"
sqlStr &= " (password = @password) AND (cardNumber = @cardnumber) OR"
sqlStr &= " (password = @password) AND (idNumber = @idnumber)"
Dim params As New Hashtable
params.Add("@surname", surname)
params.Add("@idNumber", idNumber)
params.Add("@password", password)
params.Add("@cardNumber", cardNumber)
Dim ds As DataSet = myFunctions.getData(sqlStr, params)
Try
Dim myRow As DataRow = ds.Tables(0).Rows(0)
Dim uid As Integer = CInt(myRow.Item("id"))
Dim uSurname As String = myRow.Item("surname").ToString.Trim
Dim cNumber As String = myRow.Item("cardNumber").ToString.Trim
Response.Cookies.Add(New HttpCookie("hcUid", uid))
Response.Cookies.Add(New HttpCookie("hcSname", uSurname))
Response.Cookies.Add(New HttpCookie("hcCNum", cNumber))
Response.Cookies.Add(New HttpCookie("hcIDNum", idNumber))
success = True
Catch ex As Exception
lblInvalidLogin.Text = ex.Message
success = False
End Try
Return success
End Function
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If myFunctions.testLogin(Me.Context) Then Response.Redirect("~/enquiries.aspx", True)
End Sub
End Class