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); }