/*.........................
btnLogIn_Click - check the insert details into the log form.
* If everything is ok close thit form and open the mainMenu form
.........................*/
private void btnLogIn_Click(object sender, EventArgs e)
{
int errorNumber = 0; //error counter
sUsername = txtLogName.Text;
if (txtLogName.Text != "" && txtLogPass.Text != "")
{
MySqlDataAdapter dAdapter = new MySqlDataAdapter("SELECT * FROM users", connStr);
DataTable dTable = new DataTable();
dAdapter.Fill(dTable);
string name = txtLogName.Text;
string password = txtLogPass.Text;
//encrypt the inserted password to check it with the one into the database - md5
byte[] encodedPassword = new UTF8Encoding().GetBytes(password);
byte[] hash = ((HashAlgorithm)CryptoConfig.CreateFromName("MD5")).ComputeHash(encodedPassword);
string encodedPass = BitConverter.ToString(hash).Replace("-", string.Empty).ToLower();
foreach (DataRow row in dTable.Rows)
{
if (row["name"].ToString() == name && row["password"].ToString() == encodedPass)
{
iUserId = Convert.ToInt32(row["id"]);
iUserWeight = Convert.ToInt32(row["weight"]);
mainMenu newMainMenu = new mainMenu();
newMainMenu.Show();
this.Hide();
}
else {
lblTest.Text = "Wrong user or pass";
}
}
dAdapter.Dispose();
}
else {
lblTest.Text = "Please fill all the fields";
}
}
/*.........................
btnBack_Click - close this form and open the mainMenu form
.........................*/
private void btnBack_Click(object sender, EventArgs e)
{
mainMenu newMainMenu = new mainMenu();
newMainMenu.Show();
this.Hide();
}