//login user with password decription
public Boolean loginUser(string username, string password)
{
DBconnection dBconnection = new DBconnection();
dBconnection.sqlConnection.ConnectionString = dBconnection.dataString;
dBconnection.sqlConnection.Open();
string login_user = "******" + username + "'";
dBconnection.sqlCommand.Connection = dBconnection.sqlConnection;
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(login_user, dBconnection.sqlConnection);
DataTable dataTable = new DataTable();
sqlDataAdapter.Fill(dataTable);
dBconnection.sqlConnection.Close();
foreach (DataRow row in dataTable.Rows)
{
string loginpassword = PasswordEncryption.decryptPassword(row["password"].ToString());
if (loginpassword.Equals(password))
{
return(true);
}
else
{
return(false);
}
}
return(false);
}
