-
Notifications
You must be signed in to change notification settings - Fork 0
/
validateLogin.aspx
56 lines (44 loc) · 1.56 KB
/
validateLogin.aspx
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
<%@ Language="javascript" %>
<%
Session("errorMessage") = "";
var lemail = Request.QueryString("txtEmail");
var lpwd = Request.QueryString("txtPassword");
//Connecting to DB
Session("mycon") = new ActiveXObject("ADODB.Connection");
Session("mycon").Open("Provider=Microsoft.ACE.OLEDB.12.0;Data Source='C:\\Users\\fmtchicho\\Documents\\Visual Studio 2015\\WebSites\\prjLongueuilLifeFranciscoV1\\App_Data\\LongueuilLifeDB.accdb'");
var query = "SELECT RefProfile FROM Profiles WHERE email = '" +lemail+ "' AND Password = '" +lpwd+ "'";
var myRec = new ActiveXObject("ADODB.Recordset");
myRec.Open( query , Session("mycon") );
// Validate email and password
if( !myRec.EOF )
{
Session("refProfile") = myRec.Fields['RefProfile'].Value;
// Get the Nickname
myRec.Close();
query = "SELECT Nickname FROM Profiles WHERE RefProfile= " +Session("refProfile");
myRec = new ActiveXObject("ADODB.Recordset");
myRec.Open( query , Session("mycon") );
Session("nickname") = myRec.Fields['Nickname'].Value;
Response.Redirect("welcome.aspx");
}
else
{
Session("errorMessage") = "Email or Password are incorrect <br />";
myRec.Close();
Session("mycon").Close();
Response.Redirect("index.aspx");
}
%>
<!DOCTYPE html>
<html>
<head>
<title>Welcome</title>
<style type="text/css">
.auto-style1 {
text-align: center;
}
</style>
</head>
<body>
</body>
</html>