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