public Users Auth(Users u)
{
ConnectDB con = new ConnectDB();
CrudDB db = new CrudDB();
try
{
con.Connexion.Open();
List <Users> listeUsers = db.Find <Users>("Users", u, "", con.Connexion);
Console.WriteLine("Tafa!!!");
return(listeUsers[0]);
}
catch (Exception e)
{
Console.WriteLine("Authentication :: Auth :: {0}", e.StackTrace);
}
finally
{
con.Connexion.Close();
}
return(null);
}
private Group GetGroupRef(Users user)
{
ConnectDB con = new ConnectDB();
CrudDB db = new CrudDB();
try
{
con.Connexion.Open();
List <Group> liste_grp = db.Find <Group>("group", new Group(), "", con.Connexion);
return(liste_grp[0]);
}
catch (Exception e)
{
}
finally
{
con.Connexion.Close();
}
return(0);
}
private string getRefMatiere(string matiere)
{
ConnectDB con = new ConnectDB();
CrudDB db = new CrudDB();
try
{
con.Connexion.Open();
List <Matiere> listeMatiere = db.Find <Matiere>("Matiere", new Matiere(), "", con.Connexion);
return(listeMatiere[0].REF_MATIERE);
}
catch (Exception e)
{
Console.WriteLine("Users :: GetMatiere :: {0}", e.StackTrace);
}
finally
{
con.Connexion.Close();
}
return(null);
}
private string getVille(string val)
{
ConnectDB con = new ConnectDB();
CrudDB db = new CrudDB();
try
{
con.Connexion.Open();
List <Ville> listVilles = db.Find <Ville>("ville", new Ville(val), "", con.Connexion);
return(listVilles[0].CP);
}
catch (Exception e)
{
Console.WriteLine("getVille :: Probleme :: {0}", e.StackTrace);
}
finally
{
con.Connexion.Close();
}
return(null);
}