Ejemplo n.º 1
0
        public static void setCompte(Utilisateur u)
        {
            var db = new dbProjetE2ProdEntities();
            var i = u.NomUtilisateur;

            var r =
                (from the in db.tblUtilisateur
                 where the.NomUtil == i
                 select the).First();

            r.NomUtil = u.NomUtilisateur;
            r.MotPasUtil = u.MotDePasse;
            r.MotPasExpire = u.Expire;
            r.PremiereConex = u.Premiere;
            r.IdEmp = u.Emp;
            r.IdRole = u.Role;
            r.Actif = u.UtilActif;

            try
            {
                db.SaveChanges();
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
            }
        }
Ejemplo n.º 2
0
        public static void ajouter(Utilisateur u)
        {
            var db = new dbProjetE2ProdEntities();
            var add = new tblUtilisateur();

            add.NomUtil = u.NomUtilisateur;
            add.MotPasUtil = u.MotDePasse;
            add.MotPasExpire = u.Expire;
            add.PremiereConex = u.Premiere;
            add.DateModifMotPas = u.DateModifMotPas;
            add.IdEmp = u.Emp;
            add.IdRole = u.Role;
            add.Actif = u.UtilActif;

            db.tblUtilisateur.Add(add);

            try
            {
                db.SaveChanges();
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
            }
        }
Ejemplo n.º 3
0
        //tblClassification
        public static IQueryable<tblClassification> getAllClassification()
        {
            var db = new dbProjetE2ProdEntities();

            var r =
                from c in db.tblClassification
                select c;
            return r;
        }
Ejemplo n.º 4
0
        //tblJeu
        public static IQueryable<tblJeu> getAllJeu()
        {
            var db = new dbProjetE2ProdEntities();

            var r =
                from c in db.tblJeu
                select c;
            return r;
        }
Ejemplo n.º 5
0
        public static IQueryable<tblUtilisateur> Recherche(string Recherche)
        {
            var db = new dbProjetE2ProdEntities();

            var r = from the in db.tblUtilisateur
                    where (the.NomUtil.Contains(Recherche)) || (the.MotPasUtil.Contains(Recherche))
                    select the;

            return r;
        }
Ejemplo n.º 6
0
        //          envoye une liste des types de test pour les relier au employe
        public static IQueryable<tblTypeTest> getTypeTest()
        {
            var bd = new dbProjetE2ProdEntities();

            var t =
                from e in bd.tblTypeTest
                select e;

            return t;
        }
Ejemplo n.º 7
0
        public static string PremiereCon(string Username)
        {
            var db = new dbProjetE2ProdEntities();

            var r = (from the in db.tblUtilisateur
                    where the.NomUtil == Username
                    select the.PremiereConex).First();

            return r;
        }
Ejemplo n.º 8
0
        public static string MotDePasseExpire(string Username)
        {
            var db = new dbProjetE2ProdEntities();

            var r = (from the in db.tblUtilisateur
                    where the.NomUtil == Username
                    select the.MotPasExpire).First();

            return r;
        }
Ejemplo n.º 9
0
        public static string GetRole(int IdRole)
        {
            var db = new dbProjetE2ProdEntities();

            var r = (from the in db.tblRole
                    where the.IdRole == IdRole
                    select the.NomRole).First();

            return r;
        }
Ejemplo n.º 10
0
        /// <summary>
        /// toutes les variables db vont etre a changé pour "dbProjetE2ProdEntities"
        /// </summary>
        public static IQueryable<tblUtilisateur> getComptes()
        {
            var db = new dbProjetE2ProdEntities();

            var r =
                from c in db.tblUtilisateur
                select c;

            return r;
        }
Ejemplo n.º 11
0
        public static void addEmploye(Employe settings)
        {
            var bd = new dbProjetE2ProdEntities();
            var ajout = new tblEmploye();
            var lstTypeTest = new List<tblTypeTest>();

            var tt =
                from e in bd.tblTypeTest
                select e;

            int i = 0;
            foreach (tblTypeTest item in tt)
            {
                foreach (TypeTest ty in settings.lstEmTypeTest)
                {
                    if (item.CodeTypeTest == ty.codeTypeTest)
                    {
                        ajout.tblTypeTest.Add(item);
                        i++;
                        break;
                    }
                }
                if (settings.lstEmTypeTest.Count == i)
                    break;
            }

            ajout.IdEmp = settings.idEmp;
            ajout.PrenomEmp = settings.prenomEmp;
            ajout.NomEmp = settings.nomEmp;
            ajout.CourrielEmp = settings.courrielEmp;
            ajout.NoTelPrincipal = settings.noTelPrincipal;
            ajout.NoTelSecondaire = settings.noTelSecondaire;
            ajout.AdressePostale = settings.adressePostale;
            ajout.DateEmbaucheEmp = settings.dateEmbaucheEmp;
            ajout.CompetenceParticuliere = settings.competenceParticuliere;
            ajout.Statut = settings.statut;
            ajout.CommentaireEmp = settings.commentaireEmp;

            //ajout.tblTypeTest = lstTypeTest;

            bd.tblEmploye.Add(ajout);

            try
            {
                bd.SaveChanges();
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
                MessageBox.Show("Une erreur est survenue lors de l'ajout du nouvel employe", "Erreur système", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Ejemplo n.º 12
0
        public static void addEmploye(Employe settings)
        {
            var bd = new dbProjetE2ProdEntities();
            var add = new tblEmploye();
            var lstTypeTest = new List<tblTypeTest>();

            var tt =
                from e in bd.tblTypeTest
                select e;

            int i = 0;
            foreach (tblTypeTest item in tt)
            {
                foreach (TypeTest ty in settings.lstEmTypeTest)
                {
                    if (item.CodeTypeTest == ty.codeTypeTest)
                    {
                        lstTypeTest.Add(item);
                        i++;
                        break;
                    }
                }
                if (settings.lstEmTypeTest.Count == i)
                    break;
            }

            add.IdEmp = settings.idEmp;
            add.PrenomEmp = settings.prenomEmp;
            add.NomEmp = settings.nomEmp;
            add.CourrielEmp = settings.courrielEmp;
            add.NoTelPrincipal = settings.noTelPrincipal;
            add.NoTelSecondaire = settings.noTelSecondaire;
            add.AdressePostale = settings.adressePostale;
            add.DateEmbaucheEmp = settings.dateEmbaucheEmp;
            add.CompetenceParticuliere = settings.competenceParticuliere;
            add.Statut = settings.statut;
            add.CommentaireEmp = settings.commentaireEmp;
            add.tblTypeTest = lstTypeTest;

            bd.tblEmploye.Add(add);

            try
            {
                bd.SaveChanges();
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
            }
        }
Ejemplo n.º 13
0
        public void ajouter(object o)
        {
            var ajout = new tblPlateforme();
            tblSysExp systemp;
            //List<tblPlateforme> lstPlat = new List<tblPlateforme>();
            //lstPlat.Add(ajout);
            //systemp.tblPlateforme = lstPlat;
            ICollection<tblSysExp> lstSysExp = new List<tblSysExp>();

            ajout.CodePlateforme = ((plateforme)o).codePlate;
            ajout.NomPlateforme = ((plateforme)o).nomPlate;
            ajout.CodeCategorie = ((plateforme)o).codeCateg;
            ajout.CPU = ((plateforme)o).cpuPlate;
            ajout.CarteMere = ((plateforme)o).carteMerePlate;
            ajout.RAM = ((plateforme)o).ramPlate;
            ajout.Stockage=((plateforme)o).stockage;
            ajout.DescPlateforme = ((plateforme)o).descPlate;
            ajout.InfoSupPlateforme = ((plateforme)o).infoSupPlate;

            var db = new dbProjetE2ProdEntities();

            foreach (SystemeExploitation item in ((plateforme)o).lstSysExpPlate)
            {
                systemp = new tblSysExp();
                systemp.CodeSysExp = item.CodeSysExp;
                systemp.EditionSysExp = item.editSysExp;
                systemp.IdSysExp = item.idSysExp;
                systemp.InfoSupSysExp = item.infoSysExp;
                systemp.NomSysExp = item.nomSysExp;
                systemp.Tag = item.tagSysExp;
                systemp.VersionSysExp = item.versionSysExp;
                systemp.IdSysExp = item.idSysExp;
               ajout.tblSysExp.Add(systemp);
               // lstSysExp.Add(systemp);
            }
            //ajout.tblSysExp = lstSysExp;
            db.tblPlateforme.Add(ajout);

            //ajout.tblSysExp = lstSysExp;
            //RequeteSql.addPlateforme(ajout);

            try
            {
                db.SaveChanges();
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
            }
        }
Ejemplo n.º 14
0
        public static Utilisateur SetAttributes(Utilisateur u)
        {
            Utilisateur User = u;
            var db = new dbProjetE2ProdEntities();

            var r = from the in db.tblUtilisateur
                    where the.NomUtil == User.NomUtilisateur
                    select the;

            foreach (var item in r)
            {
                User = new Utilisateur(item);
            }
            return User;
        }
Ejemplo n.º 15
0
        //static public void setJeu(Jeu jeu)
        //{
        //    var db = new dbProjetE2ProdEntities();
        //    var r =
        //        (from j in db.tblJeu
        //         where j.IdJeu == jeu.idJeu
        //         select j).First();
        //    r.NomJeu = jeu.nomJeu;
        //    r.DescJeu = jeu.descJeu;
        //    r.Actif = jeu.actif;
        //    r.InfoSupJeu = jeu.infoSupJeu;
        //    r.CoteESRB = jeu.coteESRB;
        //    r.IdGenre = jeu.idGenre;
        //    r.IdMode = jeu.idMode;
        //    //Manque le lien aux thèmes
        //    try
        //    {
        //        db.SaveChanges();
        //    }
        //    catch (Exception e)
        //    {
        //        Console.WriteLine(e);
        //    }
        //}
        public static void addJeu(tblJeu p)
        {
            var db = new dbProjetE2ProdEntities();

            foreach (tblTheme tblThemeTemp in p.tblTheme)
            {
                db.tblJeu.Add(p);
                try
                {
                    db.SaveChanges();
                }
                catch (Exception e)
                {
                    Console.WriteLine(e);
                }
            }
        }
Ejemplo n.º 16
0
        public static void addPlateforme(tblPlateforme p)
        {
            var db = new dbProjetE2ProdEntities();

            foreach (tblSysExp tblSysExpTemp in p.tblSysExp)
            {
                db.tblPlateforme.Add(p);
                try
                {
                    db.SaveChanges();
                }
                catch (Exception e)
                {
                    Console.WriteLine(e);
                }
            }
        }
Ejemplo n.º 17
0
        public static void addMode(Mode mode)
        {
            var db = new dbProjetE2ProdEntities();
            var add = new tblMode();

            add.NomMode = mode.nomMode;
            add.DescMode = mode.descMode;

            db.tblMode.Add(add);

            try
            {
                db.SaveChanges();
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
            }
        }
Ejemplo n.º 18
0
        public static void addGenre(Genre genre)
        {
            var db = new dbProjetE2ProdEntities();
            var add = new tblGenre();

            add.NomGenre = genre.nomGenre;
            add.ComGenre = genre.comGenre;

            db.tblGenre.Add(add);

            try
            {
                db.SaveChanges();
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
            }
        }
Ejemplo n.º 19
0
        public static void addClassification(Classification classification)
        {
            var db = new dbProjetE2ProdEntities();
            var add = new tblClassification();

            add.CoteESRB = classification.coteESRB;
            add.NomESRB = classification.nomESRB;
            add.DescESRB = classification.descESRB;

            db.tblClassification.Add(add);

            try
            {
                db.SaveChanges();
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
            }
        }
Ejemplo n.º 20
0
        public static void addCateg(Categorie settings)
        {
            var db = new dbProjetE2ProdEntities();
            var add = new tblCategorie();

            add.CodeCategorie = settings.codeCateg;
            add.ComCategorie = settings.comCateg;
            add.DescCategorie = settings.descCateg;

            db.tblCategorie.Add(add);

            try
            {
                db.SaveChanges();
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
            }
        }
Ejemplo n.º 21
0
        public static void deleteEmploye(int cle)
        {
            var bd = new dbProjetE2ProdEntities();
            var i = cle;

            var r =
                (from e in bd.tblEmploye
                 where e.IdEmp == i
                 select e).First();

            r.Statut = "n";

            try
            {
                bd.SaveChanges();
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
            }
        }
Ejemplo n.º 22
0
        public static void setClassification(Classification classification)
        {
            var db = new dbProjetE2ProdEntities();

            var r =
                (from classif in db.tblClassification
                 where classif.CoteESRB == classification.coteESRB
                 select classif).First();

            r.NomESRB = classification.nomESRB;
            r.DescESRB = classification.descESRB;

            try
            {
                db.SaveChanges();
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
            }
        }
Ejemplo n.º 23
0
        public static bool ChangerMDP(Utilisateur u,string NouvMDP)
        {
            var db = new dbProjetE2ProdEntities();

            var r = (from the in db.tblUtilisateur
                    where the.NomUtil == u.NomUtilisateur
                    select the).First();

            r.MotPasUtil = NouvMDP;
            r.PremiereConex = "n";
            r.MotPasExpire = "n";
            r.DateModifMotPas = DateTime.Now;

            try
            {
                db.SaveChanges();
            }
            catch (Exception e)
            {
                return false;
            }
            return true;
        }
Ejemplo n.º 24
0
        public static void deleteClassification(string coteESRB)
        {
            var db = new dbProjetE2ProdEntities();

            var r =
                from classif in db.tblClassification
                where classif.CoteESRB == coteESRB
                select classif;

            foreach (var item in r)
            {
                db.tblClassification.Remove(item);
            }

            try
            {
                db.SaveChanges();
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
            }
        }
Ejemplo n.º 25
0
        /// <summary>
        /// Ajouter un nouveau systeme d'exploitation.
        /// </summary>
        /// <param name="settings">code,nom,edition,version,info supplementaire</param>
        public static void addSysExp(SystemeExploitation settings)
        {
            var db = new dbProjetE2ProdEntities();
            var add = new tblSysExp();

            add.CodeSysExp = settings.CodeSysExp;
            add.NomSysExp = settings.nomSysExp;
            add.EditionSysExp = settings.editSysExp;
            add.VersionSysExp = settings.versionSysExp;
            add.InfoSupSysExp = settings.infoSysExp;

            db.tblSysExp.Add(add);

            try
            {
                db.SaveChanges();
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
            }
        }
Ejemplo n.º 26
0
        public static IQueryable<tblVersion> srchVersion(string c, int id)
        {
            var db = new dbProjetE2ProdEntities();

            var r =
                from v in db.tblVersion
                where v.Tag.Contains(c) && v.IdJeu == id
                select v;

            return r;
        }
Ejemplo n.º 27
0
        public static IQueryable<tblTheme> srchTheme(string code)
        {
            var db = new dbProjetE2ProdEntities();

            var r =
                from theme in db.tblTheme
                where theme.NomTheme == code
                select theme;

            return r;
        }
Ejemplo n.º 28
0
        public static IQueryable<tblSysExp> srchSysExp(string chaine)
        {
            var db = new dbProjetE2ProdEntities();

            var r =
                from sysexp in db.tblSysExp
                where sysexp.Tag.Contains(chaine)
                select sysexp;

            return r;
        }
Ejemplo n.º 29
0
        public static IQueryable<tblPlateforme> srchPlateforme(string chaine)
        {
            var db = new dbProjetE2ProdEntities();

            var r =
                from plate in db.tblPlateforme
                where plate.Tag.Contains(chaine)
                select plate;

            return r;
        }
Ejemplo n.º 30
0
        public static IQueryable<tblVersion> srchCodeVersion(string code)
        {
            var db = new dbProjetE2ProdEntities();

            var r =
                from v in db.tblVersion
                where v.CodeVersion == code
                select v;

            return r;
        }