public void Insert(Eleve eleve)
{
string idAuth = lastInsert();
MySqlCommand insertAuth = new MySqlCommand("INSERT INTO aauth_users(email,pass,username,banned,last_login,last_activity,date_created,forgot_exp,remember_time,remember_exp,verification_code,totp_secret,ip_address) " +
"VALUES(@email,@pass,NULL,0,NULL,NULL,NOW(),NULL,NULL,NULL,NULL,NULL,0)", Connection.GetCnx());
insertAuth.Parameters.Add(new MySqlParameter("@email", eleve.GetLogin()));
insertAuth.Parameters.Add(new MySqlParameter("@pass", HashPhp.Salt(eleve.GetPassword(), idAuth + 1)));
Connection.GetCnx().Open();
insertAuth.ExecuteNonQuery();
long lastidAuth = insertAuth.LastInsertedId;
Connection.GetCnx().Close();
MySqlCommand insert = new MySqlCommand("INSERT INTO Eleve(idClasse,nom,prenom,login,idAuth) VALUES(@idClasse,@nom,@prenom,@login,@idAuth)", Connection.GetCnx());
insert.Parameters.Add(new MySqlParameter("@idClasse", eleve.GetIdClasse()));
insert.Parameters.Add(new MySqlParameter("@nom", eleve.GetNom()));
insert.Parameters.Add(new MySqlParameter("@prenom", eleve.GetPrenom()));
insert.Parameters.Add(new MySqlParameter("@login", eleve.GetLogin()));
insert.Parameters.Add(new MySqlParameter("@idAuth", lastidAuth));
Connection.GetCnx().Open();
insert.ExecuteNonQuery();
Connection.GetCnx().Close();
MySqlCommand insertAuthToGroup = new MySqlCommand("INSERT INTO aauth_user_to_group(user_id,group_id)VALUES (@lastidAuth,4) ", Connection.GetCnx());
insertAuthToGroup.Parameters.Add(new MySqlParameter("@lastidAuth", lastidAuth));
Connection.GetCnx().Open();
insertAuthToGroup.ExecuteNonQuery();
Connection.GetCnx().Close();
}
public Boolean Access(string login, string password)
{
Boolean access = false;
Connection.Ouvrir();
string idAuth = GetIdAuthByLogin(login);
Connection.Fermer();
if (idAuth == "Null")
{
return(access);
}
MySqlCommand req = new MySqlCommand("SELECT * FROM enseignant INNER JOIN aauth_users ON idAuth=aauth_users.id WHERE login=@login and pass=@password", Connection.GetCnx());
req.Parameters.Add(new MySqlParameter("@login", login));
req.Parameters.Add(new MySqlParameter("@password", HashPhp.Salt(password, idAuth)));
Connection.Ouvrir();
MySqlDataReader rdr = req.ExecuteReader();
if (rdr.Read())
{
access = true;
}
Connection.Fermer();
return(access);
}