private void Button_Click(object sender, RoutedEventArgs e)
{
var regexItem = new Regex("^[a-zA-Z0-9 ]*$");
if (!regexItem.IsMatch(txtUsername.Text) || !regexItem.IsMatch(txtPassword.Password))
{
MessageBox.Show("Symbols are not allowed.", "Login Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
else
{
getter.conn.Open();
using (getter.conn)
{
MySqlCommand command = new MySqlCommand("SELECT * FROM tbl_admin WHERE Username ='******' AND Password='******'", getter.conn);
MySqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
MessageBox.Show("Greetings!, Admin", "Login Successful", MessageBoxButton.OK, MessageBoxImage.Information);
//for passing value in getter class
getter.getId = Int32.Parse(reader["Admin_ID"].ToString());
getter.getUsername = reader["Username"].ToString();
var time = System.DateTime.Now.DayOfWeek.ToString() + " | " + DateTime.Now;
getTime = time.ToString();
getter.getTimeAndDate = getTime;
getter.conn.Close();
//for inserting in historyLog
String sql = "INSERT INTO tbl_history(Admin_ID,Activities,Date_Time) VALUES ('" + getter.getId + "','logged in ','" + getter.getTimeAndDate + "')";
executeQuery(sql, "Failed to insert in tbl_history");
reader.Close();
this.Hide();
new AdminModule().Show();
this.Close();
}
else if (txtUsername.Text == "superadmin" && txtPassword.Password == "superadmin")
{
MessageBox.Show("Greetings!, Super Admin", "Login Successful", MessageBoxButton.OK, MessageBoxImage.Information);
this.Hide();
new AdminModule().Show();
this.Close();
}
else
{
MessageBox.Show("Wrong Username or Password", "Login Failed", MessageBoxButton.OK, MessageBoxImage.Error);
reader.Close();
}
}
getter.conn.Close();
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
var regexItem = new Regex("^[a-zA-Z0-9 ]*$");
if (txtUsername.Text.Equals("") || txtPassword.Password.Equals("") || txtConfirmPassword.Password.Equals(""))
{
MessageBox.Show("Please input properply", "Add Failed", MessageBoxButton.OK, MessageBoxImage.Error);
}
else if (!txtPassword.Password.Equals(txtConfirmPassword.Password))
{
MessageBox.Show("Password don`t match", "Add Failed", MessageBoxButton.OK, MessageBoxImage.Error);
}
else if (!regexItem.IsMatch(txtUsername.Text) || !regexItem.IsMatch(txtPassword.Password))
{
MessageBox.Show("Symbols are not allowed.", "Add Failed", MessageBoxButton.OK, MessageBoxImage.Error);
}
else
{
//for inserting in database
String sql = "INSERT INTO tbl_admin(Full_Name,Username,Password) VALUES ('" + txtFullName.Text + "','" + txtUsername.Text + "','" + SAES.Encrypt(txtPassword.Password) + "')";
ExecuteAddAdmin(sql, "Failed to Add Admin");
//for recording in history
var time = System.DateTime.Now.DayOfWeek.ToString() + " | " + DateTime.Now;
getTime = time.ToString();
String sql1 = "INSERT INTO tbl_history(Admin_ID,Activities,Date_Time) VALUES ('" + getter.getId + "', CONCAT('Added Admin with an ID of ', (SELECT MAX(Candidate_id)FROM tbl_candidates)) , '" + getTime + "')";
ExecuteInsertHistory(sql1, "Failed to insert in tbl_history");
Reset();
}
}
