public Directure LoginDirecture(string user, string pass)
{
string query;
if (user.Contains('@'))
{
query = "SELECT * FROM directure WHERE email = \"" + user + "\" and password = md5(\"" + pass + "\"); ";
}
else
{
query = "SELECT * FROM directure WHERE username = \"" + user + "\" and password = md5(\"" + pass + "\"); ";
}
if (this.OpenConnection() == true)
{
MySqlCommand cmd = connection.CreateCommand();
cmd.CommandText = query;
using (DbDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
reader.Read();
string nom = reader.GetString(0);
string prenom = reader.GetString(1);
DateTime date_niass = reader.GetDateTime(2);
string lieu_naiss = reader.GetString(3);
string adress = reader.GetString(4);
string username = reader.GetString(5);
string password = reader.GetString(6);
string email = reader.GetString(7);
string sexe = reader.GetString(8);
string interetString = reader.GetString(9);
string[] interet = interetString.Split(',');
string domaine = reader.GetString(10);
Directure directure = new Directure(nom, prenom, date_niass, lieu_naiss, adress, username, password, email, sexe, interet, domaine);
this.CloseConnection();
return(directure);
}
else
{
this.CloseConnection();
return(null);
}
}
}
return(null);
}
public List <Directure> SearchDirectures(string word)
{
List <Directure> directures = new List <Directure>();
string query = "SELECT * FROM directure WHERE nom like '%" + word + "%' or prenom like '%" + word + "%' or lieu_naiss like '%" + word + "%' or adress like '%" + word + "%'or username like '%" + word + "%' or email like '%" + word + "%' or sexe like '%" + word + "%' or interet like '%" + word + "%' or domaine like '%" + word + "%';";
if (this.OpenConnection() == true)
{
MySqlCommand cmd = connection.CreateCommand();
cmd.CommandText = query;
using (DbDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
string nom = reader.GetString(0);
string prenom = reader.GetString(1);
DateTime date_niass = reader.GetDateTime(2);
string lieu_naiss = reader.GetString(3);
string adress = reader.GetString(4);
string username = reader.GetString(5);
string password = reader.GetString(6);
string email = reader.GetString(7);
string sexe = reader.GetString(8);
string interetString = reader.GetString(9);
string[] interet = interetString.Split(',');
string domaine = reader.GetString(10);
Directure directure = new Directure(nom, prenom, date_niass, lieu_naiss, adress, username, password, email, sexe, interet, domaine);
directures.Add(directure);
Debug.WriteLine(directure.username);
}
}
}
this.CloseConnection();
}
return(directures);
}
