//clears the login information and disables all controls on the panel.
//Used when right username and password is provided in order to transition to the next panel.
private void LoginClear()
{
attempts = 0;
Username_txt.Clear();
Password_txt.Clear();
Username_txt.Enabled = false;
Password_txt.Enabled = false;
Login_submit.Enabled = false;
Incorrect_Login_Warning.Visible = false;
SignInPage.Visible = false;
//TODO: delete red outline on textboxes.
}
// Clear button funcionality
private void ClearBtn_Click(object sender, RoutedEventArgs e)
{
Username_txt.Clear();
Password_txt.Clear();
Username_txt.Focus();
}
private void Clear_btn_Click(object sender, EventArgs e)
{
Username_txt.Clear();
}
private void Accept_btn_Click(object sender, EventArgs e)
{
var SecretKey = "b14ca5898a4e4133bbce2ea2315a1916";
string SystemUsersquery = "Select [School_Role], [Full_Name], [Surname] FROM [System Users] WHERE [ID_Number] = @Username and [Password] = @Password";
SqlCommand SelectCommand = new SqlCommand(SystemUsersquery, connection);
SelectCommand.Parameters.Add("@Username", SqlDbType.VarChar, 8).Value = Username_txt.Text.Trim();
SelectCommand.Parameters.Add("@Password", SqlDbType.VarChar).Value = EncryptString(SecretKey, Password_txt.Text.Trim());
connection.Open();
SqlDataAdapter sda = new SqlDataAdapter(SelectCommand);
DataTable dtbl = new DataTable();
sda.Fill(dtbl);
connection.Close();
try
{
if (dtbl.Rows[0][0].ToString() == "Student")
{
#region Load Student Portal
Student_Interface.Student_Portal StudentPortal = new Student_Interface.Student_Portal(dtbl.Rows[0][1].ToString(), dtbl.Rows[0][2].ToString(), Username_txt.Text.Trim());
this.Hide();
connection.Close();
StudentPortal.Show();
#endregion
}
else if (dtbl.Rows[0][0].ToString() == "Staff Members")
{
string StaffQuery = "Select [Staff Title] FROM [Staff Members] WHERE [ID Number] = @Username";
SqlCommand SelectStaffCommand = new SqlCommand(StaffQuery, connection);
SelectStaffCommand.Parameters.Add("@Username", SqlDbType.VarChar, 8).Value = Username_txt.Text.Trim();
connection.Open();
SqlDataAdapter Staffsda = new SqlDataAdapter(SelectStaffCommand);
DataTable Staffdtbl = new DataTable();
Staffsda.Fill(Staffdtbl);
connection.Close();
if (Staffdtbl.Rows[0][0].ToString() == "Security")
{
#region Load Security Portal
Staff_Interface.Security_Portal SecurityPortal = new Staff_Interface.Security_Portal(dtbl.Rows[0][1].ToString(), dtbl.Rows[0][2].ToString(), Username_txt.Text.Trim());
this.Hide();
connection.Close();
SecurityPortal.Show();
#endregion
}
else if (Staffdtbl.Rows[0][0].ToString() == "Lecturer")
{
#region Load Lecturer Portal
Staff_Interface.Lecturer_Portal LecturerPortal = new Staff_Interface.Lecturer_Portal(dtbl.Rows[0][1].ToString(), dtbl.Rows[0][2].ToString(), Username_txt.Text.Trim());
this.Hide();
connection.Close();
LecturerPortal.Show();
#endregion
}
else if (Staffdtbl.Rows[0][0].ToString() == "Admin")
{
#region Load Admin Portal
Staff_Interface.Administration_Portal AdministrationPortal = new Staff_Interface.Administration_Portal(dtbl.Rows[0][1].ToString(), dtbl.Rows[0][2].ToString(), Username_txt.Text.Trim());
this.Hide();
connection.Close();
AdministrationPortal.Show();
#endregion
}
else
{
connection.Close();
DialogResult dialogResult = MessageBox.Show("Your Username or Password is incorrect", "Incorrect", MessageBoxButtons.OK, MessageBoxIcon.Error);
if (dialogResult == DialogResult.OK)
{
Username_txt.Text = "";
Password_txt.Text = "";
Username_txt.Focus();
}
}
}
}
catch (Exception)
{
connection.Close();
DialogResult dialogResult = MessageBox.Show("Your Username or Password is incorrect", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
if (dialogResult == DialogResult.OK)
{
Username_txt.Text = "";
Password_txt.Text = "";
Username_txt.Focus();
}
}
}
private void Button1_Click(object sender, EventArgs e)
{
try
{
if (Username_txt.Text == "")
{
MessageBox.Show("Username is empty", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
Username_txt.Focus();
}
else if (Password_txt.Text == "")
{
MessageBox.Show("Password is empty", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
Password_txt.Focus();
}
else if (Full_Name_txt.Text == "")
{
MessageBox.Show("Role is empty", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
Full_Name_txt.Focus();
}
else
{
OleDbCommand command = new OleDbCommand
{
CommandType = CommandType.Text,
CommandText = "INSERT INTO [System_Users_tbl] ([Role],[Username],[Password],[Creation_Date],[Accountant])" + "VALUES (?,?,?,?,?)"
};
command.Parameters.AddWithValue("@Role", Full_Name_txt.Text.Trim());
command.Parameters.AddWithValue("@Username", Username_txt.Text.Trim());
command.Parameters.AddWithValue("@Password", Password_txt.Text.Trim());
command.Parameters.AddWithValue("@Creation_Date", Convert.ToString(User_dateTimePicker.Text.Trim()));
command.Parameters.AddWithValue("@Accountant", User_txt.Text.Trim());
command.Connection = connection;
connection.Open();
command.ExecuteNonQuery();
connection.Close();
MessageBox.Show(Username_txt.Text.Trim() + " is now a System User, with\n" + Full_Name_txt.Text.Trim() + " privillages", "Successful", MessageBoxButtons.OK, MessageBoxIcon.Information);
Username_txt.Text = "";
Password_txt.Text = "";
Full_Name_txt.Text = "";
User_dateTimePicker.Value = DateTime.Now;
Full_Name_txt.Focus();
connection.Open();
OleDbCommand ViewCommand = connection.CreateCommand();
ViewCommand.CommandType = CommandType.Text;
ViewCommand.CommandText = "select * from [System_Users_tbl]";
ViewCommand.ExecuteNonQuery();
DataTable dta = new DataTable();
OleDbDataAdapter adapt = new OleDbDataAdapter(ViewCommand);
adapt.Fill(dta);
Users_dataGridView.DataSource = dta;
connection.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
MessageBox.Show(ex.StackTrace, "Error Location", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
