public static List <Etudiant> GetAllStudent() { var db = SqliteDB.connect(); List <Etudiant> allStudent = db.Table <Etudiant>().OrderBy(x => x.Id).ToList(); db.Close(); return(allStudent); }
public static void Insert(string nom) { var db = SqliteDB.connect(); var newLesson = new Lesson(); newLesson.Nom = nom; db.Insert(newLesson); db.Close(); }
public static void Insert(string username, string password, string email) { var db = SqliteDB.connect(); var newProfesseur = new Professeur(); newProfesseur.Username = username; newProfesseur.Password = password; newProfesseur.Email = email; db.Insert(newProfesseur); db.Close(); }
public static void Insert(int cne, string nom, string prenom, string email, string tele, string filiere) { var db = SqliteDB.connect(); var newEtudiant = new Etudiant(); newEtudiant.Cne = cne; newEtudiant.Nom = nom; newEtudiant.Prenom = prenom; newEtudiant.Email = email; newEtudiant.Telephone = tele; newEtudiant.Filiere = filiere; db.Insert(newEtudiant); db.Close(); }
public static Boolean IsExistedEmail(string email) { var db = SqliteDB.connect(); var data = db.Table <Professeur>(); var d1 = data.Where(x => x.Email == email).FirstOrDefault(); db.Close(); if (d1 != null) { return(true); } else { return(false); } }
public static Boolean Login(string username, string password) { var db = SqliteDB.connect(); var data = db.Table <Professeur>(); var d1 = data.Where(x => x.Username == username && x.Password == password).FirstOrDefault(); db.Close(); if (d1 != null) { return(true); } else { return(false); } }
public static List <Etudiant> GetAllFiliere() { var db = SqliteDB.connect(); return(db.Query <Etudiant>("select Filiere from Etudiant").ToList()); }