public RechercheContactsForm(Users SuperU,Form precedtForm)
{
InitializeComponent();
this.SuperUser = SuperU;
this.precedente = precedtForm;
}
public CreerForm(Users SuperU, Form precedant)
{
InitializeComponent();
this.formulaire_precedant = precedant;
this.TacheAcreer = new Taches();
this.SuperUser = SuperU;
}
public CreerForm(Users SuperU, Form precedant, Taches taModifier)
{
InitializeComponent();
this.ModeModif = true;
this.formulaire_precedant = precedant;
this.TacheCouranteAmodifier = taModifier;
this.CreerButt.Text = "Modifier";
this.SuperUser = SuperU;
}
public MBoyMain(Users US)
{
InitializeComponent();
this.SuperUser = US;
}
public static Users USERS_EXIST(string login)
{
string requete = "select * from users where loginuser='******'";
Users u = null;
try
{
OleDbCommand cmdaccess = new OleDbCommand(requete, BDGestionAccess2013.connexion_access);
OleDbDataReader lecteur = cmdaccess.ExecuteReader();
while (lecteur.Read())
{
u = new Users();
u.persUserId = lecteur.GetInt32(1);
u.droitsuser = lecteur.GetInt32(2);
u.prefsuser = lecteur.GetInt32(3);
u.login = lecteur.GetString(4);
u.password = lecteur.GetString(5);
}
lecteur.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + "\r\n" + ex.InnerException);
}
return u;
}