public List<Tuple<string, string, string>> afficheApprov(int b)
        {
            List<Tuple<string, string, string>> PC = new List<Tuple<string, string, string>>();

            VehiculeList user = new VehiculeList();

            var vehiculo = from app in db.Ligne_depot
                           where app.id_superviseur == b
                           join lig in db.Ligne_Production on app.id_ligne_production equals lig.id
                           join prod in db.Produits on app.id_produit equals prod.id
                           select new
                           {
                              date =  app.date_ligne_depot,
                              lign = lig.nom,
                              produit =  prod.nom


                           }; 

            PC.Add(Tuple.Create("", "", ""));

            foreach (var a in vehiculo)
            {

                PC.Add(Tuple.Create(a.date.ToString("dd-MM-yyyy"), a.lign.ToString(), a.produit.ToString()));

            }
            return PC;
        }
        public List<Tuple<string, string, string>> afficheLoading(int b)
        {
            List<Tuple<string, string, string>> PC = new List<Tuple<string, string, string>>();

            VehiculeList user = new VehiculeList();

            var vehiculo = from load in db.Loadings
                           where load.id_superviseur == b
                           select new
                           {
                               load.date_loading,
                               load.numero_sp,
                               load.numero_emb

                           };

                PC.Add(Tuple.Create("", "", ""));

                foreach (var a in vehiculo)
                    {
                
                       PC.Add(Tuple.Create(a.date_loading.ToString("dd-MM-yy"), a.numero_sp, a.numero_emb));
                
                    }
                    return PC;
        }
        public List<Tuple<string, string, int>> afficheTransfert(int b)
        {
            List<Tuple<string, string, int>> PC = new List<Tuple<string, string, int>>();

            VehiculeList user = new VehiculeList();

            var vehiculo = from trasf in db.Transferts
                           where trasf.id_superviseur == b
                           select new
                           {
                               trasf.date_transfert,
                               trasf.num_transfert,
                               trasf.id_chauffeur

                           };

            PC.Add(Tuple.Create("", "", 0));

            foreach (var a in vehiculo)
            {

                PC.Add(Tuple.Create(a.date_transfert.ToString("dd-MM-yyyy"), a.num_transfert.ToString(), a.id_chauffeur));

            }
            return PC;
        }
        public List<VehiculeList> ListVehicule()
        {
            List<VehiculeList> PC = new List<VehiculeList>();

            VehiculeList user = new VehiculeList();

            var vehiculo = from prod in bdd.Vehicules
                             select new
                             {
                                 prod.id,
                                 prod.numero
                         
                             };


            foreach (var a in vehiculo)
            {

                PC.Add(new VehiculeList() { id = a.id, numeroCamion = a.numero });

            }
            return PC;

        }