forked from nooraintahir/Degree-Issuance-System
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Login.aspx.cs
123 lines (104 loc) · 4.5 KB
/
Login.aspx.cs
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
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
public partial class Login : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=DESKTOP-A1B8R5V\\SQLEXPRESS;Initial Catalog=project;Integrated Security=True");
con.Open();
SqlCommand cm;
Application["Username"] = username.Text;
if (DropDownList1.SelectedValue.ToString() == "Student")
{
string query1 = "select * from Student where Roll_no like " + username.Text + " AND password like '" + password.Text + "'";
cm = new SqlCommand(query1, con);
SqlDataReader read1 = cm.ExecuteReader();
if (read1.HasRows)
{
Response.Redirect("Mainstudent.aspx");
}
else
{
int x = 550;
int y = 500;
Response.Write("<div style='position:absolute;font-size:20px;font-weight:bold;font-style:italic;top:" + y.ToString() + "px;left:" + x.ToString() + "px'>The id or password is incorrect</div>");
}
}
else if (DropDownList1.SelectedValue.ToString() == "FYP Department")
{
string query2 = "select * from FYP where FYP_NO like " + username.Text + " AND password like '" + password.Text + "'";
cm = new SqlCommand(query2, con);
SqlDataReader read2 = cm.ExecuteReader();
if (read2.HasRows)
{
Response.Redirect("FYPUI.aspx");
}
else
{
int x = 700;
int y = 500;
Response.Write("<div style='position:absolute;font-size:20px;font-weight:bold;font-style:italic;top:" + y.ToString() + "px;left:" + x.ToString() + "px'>The id or password is incorrect</div>");
}
}
else if (DropDownList1.SelectedValue.ToString() == "Finance Department")
{
string query2 = "select * from Finance where Id like " + username.Text + " AND Password like '" + password.Text + "'";
cm = new SqlCommand(query2, con);
SqlDataReader read2 = cm.ExecuteReader();
if (read2.HasRows)
{
Response.Redirect("FinanceUI.aspx");
}
else
{
int x = 700;
int y = 500;
Response.Write("<div style='position:absolute;font-size:20px;font-weight:bold;font-style:italic;top:" + y.ToString() + "px;left:" + x.ToString() + "px'>The id or password is incorrect</div>");
}
}
else if (DropDownList1.SelectedValue.ToString() == "One Stop Admin")
{
string query2 = "select * from OneStop where O_Id like " + username.Text + " AND Password like '" + password.Text + "'";
cm = new SqlCommand(query2, con);
SqlDataReader read2 = cm.ExecuteReader();
if (read2.HasRows)
{
Response.Redirect("OnestopUI.aspx");
}
else
{
int x = 700;
int y = 500;
Response.Write("<div style='position:absolute;font-size:20px;font-weight:bold;font-style:italic;top:" + y.ToString() + "px;left:" + x.ToString() + "px'>The id or password is incorrect</div>");
}
}
else if (DropDownList1.SelectedValue.ToString() == "Director")
{
string query2 = "select * from Dir_Id where dir_Id like " + username.Text + " AND Password like '" + password.Text + "'";
cm = new SqlCommand(query2, con);
SqlDataReader read2 = cm.ExecuteReader();
if (read2.HasRows)
{
Response.Redirect("Director.aspx");
}
else
{
int x = 700;
int y = 500;
Response.Write("<div style='position:absolute;font-size:20px;font-weight:bold;font-style:italic;top:" + y.ToString() + "px;left:" + x.ToString() + "px'>The id or password is incorrect</div>");
}
}
con.Close();
}
}