public List <Eleve> LoadCsv(PassWordType type, string nomfichier)
{
StreamReader reader = new StreamReader(nomfichier);
while (!reader.EndOfStream)
{
var ligne = reader.ReadLine();
var values = ligne.Split(';');
string login;
login = values[0] + values[1] + "@sio.jjr.fr";
Eleve unEleve = new Eleve(values[0], values[1], login, type);
lesEleves.Add(unEleve);
}
return(lesEleves);
}
public void Insert(Eleve eleve)
{
// récupére l'id de la classe
this.connection = ConnexionMySql.GetConnexion;
this.connection.Open();
MySqlCommand cmdSql4 = new MySqlCommand();
cmdSql4.Connection = this.connection;
cmdSql4.CommandText = "select max(id) from classe";
cmdSql4.CommandType = CommandType.Text;
int idClasse = (int)cmdSql4.ExecuteScalar();
this.connection.Close();
// récupére le dernier l'id de aauth_user
this.connection.Open();
MySqlCommand cmdSql9 = new MySqlCommand();
cmdSql9.Connection = this.connection;
cmdSql9.CommandText = "select max(id) from aauth_users";
cmdSql9.CommandType = CommandType.Text;
int idAuthSalt = Convert.ToInt32(cmdSql9.ExecuteScalar());
this.connection.Close();
// hash le mot de passe
Hash h = new Hash();
string mdpHash = h.Salt(eleve.PassWord, Convert.ToString(idAuthSalt + 1));
this.connection = ConnexionMySql.GetConnexion;
// insert dans aauth_user
string prenomEleve;
this.connection.Open();
MySqlCommand cmdSql = new MySqlCommand();
cmdSql.Connection = this.connection;
cmdSql.CommandText = "insert into aauth_users(email,pass,username) values(@email,@pass,@username)";
cmdSql.CommandType = CommandType.Text;
cmdSql.Parameters.Add("@pass", MySqlDbType.String);
cmdSql.Parameters["@pass"].Value = mdpHash;
cmdSql.Parameters.Add("@username", MySqlDbType.String);
prenomEleve = eleve.Prenom;
cmdSql.Parameters["@username"].Value = prenomEleve[0] + eleve.Nom;
cmdSql.Parameters.Add("@email", MySqlDbType.String);
cmdSql.Parameters["@email"].Value = eleve.Nom + eleve.Prenom + "@sio.jjr.fr";
cmdSql.ExecuteNonQuery();
this.connection.Close();
/*
* // récupére le dernier l'id de aauth_user
*
* this.connection.Open();
* MySqlCommand cmdSql2 = new MySqlCommand();
* cmdSql2.Connection = this.connection;
* cmdSql2.CommandText = "select max(id) from aauth_users";
* cmdSql2.CommandType = CommandType.Text;
* int idAuth = Convert.ToInt32(cmdSql2.ExecuteScalar());
* this.connection.Close();
*/
//insert les eleves
this.connection.Open();
MySqlCommand cmdSql1 = new MySqlCommand();
cmdSql1.Connection = this.connection;
cmdSql1.CommandText = "insert into eleve(idclasse,nom,prenom,login,idAuth) values(@idclasse,@nom,@prenom,@login,@idAuth)";
cmdSql1.CommandType = CommandType.Text;
cmdSql1.Parameters.Add("@idclasse", MySqlDbType.Int32);
cmdSql1.Parameters["@idclasse"].Value = idClasse;
cmdSql1.Parameters.Add("@nom", MySqlDbType.String);
cmdSql1.Parameters["@nom"].Value = eleve.Nom;
cmdSql1.Parameters.Add("@prenom", MySqlDbType.String);
cmdSql1.Parameters["@prenom"].Value = eleve.Prenom;
cmdSql1.Parameters.Add("@login", MySqlDbType.String);
cmdSql1.Parameters["@login"].Value = eleve.Login;
cmdSql1.Parameters.Add("@idAuth", MySqlDbType.Int32);
cmdSql1.Parameters["@idAuth"].Value = idAuthSalt + 1;
cmdSql1.ExecuteNonQuery();
this.connection.Close();
// insert dans aauth_user_to_group
this.connection.Open();
MySqlCommand cmdSql3 = new MySqlCommand();
cmdSql3.Connection = this.connection;
cmdSql3.CommandText = "insert into aauth_user_to_group(user_id,group_id) values(@user,@group)";
cmdSql3.CommandType = CommandType.Text;
cmdSql3.Parameters.Add("@user", MySqlDbType.Int32);
cmdSql3.Parameters["@user"].Value = idAuthSalt + 1;
cmdSql3.Parameters.Add("@group", MySqlDbType.Int32);
cmdSql3.Parameters["@group"].Value = 4;
cmdSql3.ExecuteNonQuery();
this.connection.Close();
}
