-
Notifications
You must be signed in to change notification settings - Fork 0
/
frm_Login.cs
110 lines (89 loc) · 2.88 KB
/
frm_Login.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
using Barroc_IT_Groep5;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Data.SqlTypes;
namespace Barroc_IT_5
{
public partial class frm_Login : Form
{
SQLDatabaseHandler dbh;
frm_Main frm_Main;
public string uN, pW;
public bool temp;
public int permission;
public frm_Login()
{
InitializeComponent();
dbh = new SQLDatabaseHandler();
}
private void btn_Login_Click(object sender, EventArgs e)
{
IsLoggedIn(tb_Username.Text, tb_Password.Text);
SetPermissions();
}
public bool IsLoggedIn(string user, string pass)
{
user = tb_Username.Text;
pass = tb_Password.Text;
frm_Main = new Barroc_IT_5.frm_Main();
string query = "SELECT * FROM TBL_LOGIN WHERE USERNAME = @USERNAME AND PASSWORD = @PASSWORD";
dbh.openCon();
SqlCommand com = new SqlCommand(query, dbh.getCon());
com.Parameters.Add(new SqlParameter("@USERNAME", user));
com.Parameters.Add(new SqlParameter("@PASSWORD", pass));
SqlDataReader reader = com.ExecuteReader();
while (reader.Read())
{
uN = reader.GetString(0);
pW = reader.GetString(1);
}
if (uN == user && pW == pass)
{
MessageBox.Show("Login Successful.");
temp = true;
this.Hide();
frm_Main.Show();
}
else if (uN != user || pW != pass)
{
MessageBox.Show("Invalid Username and/or Password.");
temp = false;
}
dbh.closeCon();
return temp;
}
public int SetPermissions()
{
string query = "SELECT PERMISSIONS FROM TBL_LOGIN WHERE USERNAME = @USERNAME AND PASSWORD = @PASSWORD";
SqlCommand com = new SqlCommand(query, dbh.getCon());
com.Parameters.Add(new SqlParameter("@USERNAME", tb_Username.Text));
com.Parameters.Add(new SqlParameter("@PASSWORD", tb_Password.Text));
//SqlDataReader reader = com.ExecuteReader();
//while (reader.Read())
//{
// permission = reader.GetInt32(2);
//}
return permission;
}
public int GetPermissions()
{
return permission;
}
private void tb_Password_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
btn_Login_Click(sender, e);
}
}
}
}