// check if the username already exists
public bool checkUsername(string username)
{
if (CcnSession.GetColumn("EMPLOYEE", "username", username).Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
/* original code, kept for archive purposes
* DB db = new DB();
*
* String username = textBoxUsername.Text;
*
* DataTable table = new DataTable();
*
* MySqlDataAdapter adapter = new MySqlDataAdapter();
*
* MySqlCommand command = new MySqlCommand("SELECT * FROM `Login_SignUP` WHERE `username` = @usn", db.getConnection());
*
* command.Parameters.Add("@usn", MySqlDbType.VarChar).Value = username;
*
* adapter.SelectCommand = command;
*
* adapter.Fill(table);
*
* // check if this username already exists in the database
* if (table.Rows.Count > 0)
* {
* return true;
* }
* else
* {
* return false;
* }
*/
}
private void buttonLogin_Click(object sender, EventArgs e)
{
/* - First itration of code. Kept for comparison purposes.
*
* Programed by Salem
*
*
* DB db = new DB();
*
* String username = textBoxUsername.Text;
* String password = textBoxPassword.Text;
*
* DataTable table = new DataTable();
*
* MySqlDataAdapter adapter = new MySqlDataAdapter();
*
* MySqlCommand command = new MySqlCommand("SELECT * FROM `Login_SignUP` WHERE `username` = @usn and `password` = @pass", db.getConnection());
*
* command.Parameters.Add("@usn", MySqlDbType.VarChar).Value = username;
* command.Parameters.Add("@pass", MySqlDbType.VarChar).Value = password;
*
* adapter.SelectCommand = command;
*
* adapter.Fill(table);
* // check if the user exists or not
* if (table.Rows.Count > 0)
* {
* this.Hide();
* MainForm mainform = new MainForm();
* mainform.Show();
* }
* else
* {
* if (username.Trim().Equals(""))
* {
* MessageBox.Show("Enter Your Username To Login", "Empty Username", MessageBoxButtons.OK, MessageBoxIcon.Error);
* }
* else if (password.Trim().Equals(""))
* {
* MessageBox.Show("Enter Your Password To Login", "Empty Password", MessageBoxButtons.OK, MessageBoxIcon.Error);
* }
* else
* {
* MessageBox.Show("Wrong Username Or Password", "Wrong Data", MessageBoxButtons.OK, MessageBoxIcon.Error);
* }
* }
*/
String username = textBoxUsername.Text;
String password = textBoxPassword.Text;
//Set up the username and the Permission level for if Employee or Manager.
// Only needs to be done THIS ONE TIME - doesn't need to be done again.
CcnSession.Setup(username, password);
var dTable = new DataTable();
//Call to database to verify the username.
// username field is unique
dTable = CcnSession.GetColumn("EMPLOYEE", "username", username);
// check to see of the username exists.
if (dTable == null || dTable.Rows.Count == 0)
{
if (username.Trim().Equals(""))
{
MessageBox.Show("Enter Your Username To Login", "Empty Username", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (password.Trim().Equals(""))
{
MessageBox.Show("Enter Your Password To Login", "Empty Password", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("Our Records do not match this data. Please try again.", "Wrong Data", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (dTable.Rows.Count == 1)
{
//verify the password
if (CcnSession.PwCorrect)
{
this.Hide();
MainForm mainform = new MainForm();
mainform.Show();
}
else
{
MessageBox.Show("Our Records do not match this data. Please Try again.", "Wrong Data", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else //if dTable.Rows.Count >1
{
/* this should never happen - username being unique, and the sql library searches
* for exact strings, not partial matches, this is an edge case error that is here
* just in case
*/
MessageBox.Show("Something went wrong. Please contact IT.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}