private void buttoncaback_Click(object sender, EventArgs e)
{
this.Close();
FormHomePage hp = new FormHomePage();
hp.Show();
}
//Method to check user's authentication
public void loginAuthentication()
{
Boolean isMatch = false; //To find matched user
Boolean isFreeze = false; //To identify user status
User userTemp;
//MySqlCommand cmdUpdateLoginStatus = ConnectionState.CreateCommand();
//cmdUpdateLoginStatus.CommandText = "UPDATE ";
MySqlConnection connection = databaseConnection.openConnection();
try
{
//SQL COMMAND to obtain information
MySqlCommand cmdLogin = connection.CreateCommand();
cmdLogin.CommandText = "Select * FROM user";
//Data Adapter to run COMMAND
MySqlDataAdapter loginAdapter = new MySqlDataAdapter(cmdLogin);
DataSet loginDS = new DataSet();
loginAdapter.Fill(loginDS);
for (int counter = 0; counter < loginDS.Tables[0].Rows.Count; counter++)
{
userTemp = new User(loginDS.Tables[0].Rows[counter].ItemArray[0].ToString(),
loginDS.Tables[0].Rows[counter].ItemArray[1].ToString());
if (userLocal.getUserID() == userTemp.getUserID() &&
userLocal.getPassword() == userTemp.getPassword())
{
//User did NOT failed to login more than 4 times
if (userLocal.getLoginAttempt() != 0)
{
//User login success, user is valid
isMatch = true;
}//END IF
//User's username and password matched with the system,
//but user have failed to login more or equal to 4 times.
else
{
isFreeze = true;
} //END ELSE
} //END IF
} //END for
//Display messages
if (isMatch == true && isFreeze != true)
{
//User is valid, status not freezed
MessageBox.Show("Login Successful." +
"\nPlease wait while the system is preparing for you.");
//User granted permission to the main system
this.Hide();
FormHomePage formHome = new FormHomePage();
formHome.Closed += (s, arg) => this.Close();
formHome.Show();
} //END if
else //Wrong username or password
{
userLocal.setLoginAttempt(userLocal.getLoginAttempt() - 1);
//Status if Freeze or
if (isFreeze == true || userLocal.getLoginAttempt() <= 0)
{
MessageBox.Show("Your User ID have been freeze." +
"Please contact IT Department.");
//Update Query
String qrySuspendUser = "******";
qrySuspendUser += "SET userStatus = true ";
qrySuspendUser += "WHERE userID ='" + userLocal.getUserID() + "';";
MySqlCommand cmdSuspendUser = new MySqlCommand(qrySuspendUser, connection);
MySqlDataReader theReader;
theReader = cmdSuspendUser.ExecuteReader();
}
else
{
MessageBox.Show("Login failed. ID or password might be incorrect." +
"\nLogin Attempt Left: " + Convert.ToString(userLocal.getLoginAttempt()));
}
}
}//END try
catch (Exception e)
{
MessageBox.Show(e.Message);
}//END catch
finally //Close Connection
{
//Close the connection
if (connection.State == ConnectionState.Open)
{
connection.Close();
} //END if
} //END finally
} //END BUTTON
public void login(User user, string pwd)
{
MessageBox.Show("1");
//User user = new User();
if (pwd == user.Password)
{
switch (user.Acctype)
{
case "Doctor":
FormHomePage hpg = new FormHomePage();
hpg.Hide();
Doctors dctr = new Doctors();
getdatafrmdctrs(dctr, user.Userid);
View.FormDoctoracc FDA = new View.FormDoctoracc();
FDA.set_values(user, dctr);
FDA.Show();
break;
case "MLT":
FormHomePage hpg2 = new FormHomePage();
hpg2.Hide();
View.Formtechacc FTA = new View.Formtechacc();
FTA.Show();
break;
case "Radiologist":
FormHomePage hpg3 = new FormHomePage();
hpg3.Hide();
View.Formtechacc FTAr = new View.Formtechacc();
FTAr.Show();
break;
case "Nurse":
FormHomePage hpg4 = new FormHomePage();
hpg4.Hide();
View.Formtechacc FTAn = new View.Formtechacc();
FTAn.Show();
break;
case "Physiotherapist":
FormHomePage hpg5 = new FormHomePage();
hpg5.Hide();
View.Formtechacc FTAp = new View.Formtechacc();
FTAp.Show();
break;
case "Patient":
FormHomePage hpg6 = new FormHomePage();
hpg6.Hide();
View.FormPatient FPA = new View.FormPatient();
FPA.Show();
break;
case "Pharmacist":
break;
}
}
else
{
MessageBox.Show("wrong password");
MessageBox.Show(user.Password);
}
}
