// GET: Trajets/Details/5
public ActionResult VMChauffeurDeTrajet(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
VMChauffeurDeTrajet rez = _st.DetailTragetChauffeur(id);
ViewBag.idTrajet = id;
if (TempData["shortMessage"] != null)
{
ViewBag.Message = TempData["shortMessage"].ToString();
}
Trajet t = db.Trajets.Where(x => x.Id == id).FirstOrDefault();
rez.Chauffeur = t.Chauffeur;
//test
if (rez == null)
{
return(HttpNotFound());
}
return(View(rez));
}
public VMChauffeurDeTrajet DetailTragetChauffeur(int?id)
{
Trajet trajCourant = uw.TrajetRepository.GetByID(id);
// Chauffeur ch = uw.ChauffeurRepository.GetByID(trajCourant.Chauffeur);
DateTime dToday = DateTime.Today;
var rezz = this.ListeTrajets().ToList();
rezz = rezz.Where(x => x.Chauffeur == trajCourant.Chauffeur && x.HeureArrivee < dToday).ToList();
int qtyTraj = rezz.Count;
int kilometreTotal = 0;
decimal ponctual = 0;
decimal securite = 0;
decimal comfort = 0;
decimal courtoisie = 0;
decimal fiabilite = 0;
int p = 0;
int s = 0;
int comf = 0;
int cour = 0;
int fiab = 0;
var notss = ListeNotes();
List <NotesChauffeurs> nots = new List <NotesChauffeurs>();
foreach (NotesChauffeurs n in notss)
{
if (n.chaufeurs == trajCourant.Chauffeur)
{
nots.Add(n);
}
}
// nots = nots.Where(x => x.chaufeurs == trajCourant.Chauffeur);
if (nots.Count() > 0)
{
foreach (NotesChauffeurs n in nots)
{
p = p + n.notePonctualite;
s = s + n.noteSecurite;
comf = comf + n.noteConfort;
cour = cour + n.noteCourtoisie;
fiab = fiab + n.noteFiabilite;
}
ponctual = (decimal)p / (decimal)nots.Count();
securite = (decimal)s / (decimal)nots.Count();
comfort = (decimal)comf / (decimal)nots.Count();
courtoisie = (decimal)cour / (decimal)nots.Count();
fiabilite = (decimal)fiab / (decimal)nots.Count();
}
foreach (Trajet t in rezz)
{
kilometreTotal += t.Kilometrage;
}
/* var rez = (from repons in ListeTrajets()//GetReponsesByTous(datD, datF, a, n, progr, m, session)
* // join emo in listE on repons.idEmotion equals emo.idEmotion
* group repons by new
* {
* n = lang.ToString() == "fr" || lang == null ? emo.nom : emo.nomE
* } into gr
* select new ChartDay
* {
* nom = gr.Key.n,
* qty = gr.Count()
* }).ToList();*/
VMChauffeurDeTrajet v = new VMChauffeurDeTrajet()
{
nbTrajets = qtyTraj.ToString(),
nbKilometres = kilometreTotal.ToString(),
moyennePonctualite = ponctual, //.ToString("F"),///Pomeniat!!! moyennes des appréciations de ses clients 1 ) sozdat tablicy Apreciation c itTarjet
moyenneSecurite = securite, //.ToString("F"),
moyenneConfort = comfort, //.ToString("F"),
moyenneCourtoisie = courtoisie, //.ToString("F"),
moyenneFiabilite = fiabilite, //.ToString("F"),
HeureDepart = trajCourant.HeureDepart,
HeureArrivee = trajCourant.HeureArrivee,
NbPassagers = trajCourant.PlaceRestante,
Prix = trajCourant.Prix,
Kilometrage = trajCourant.Kilometrage,
VilleDepart = trajCourant.VilleDepart,
PointDepart = trajCourant.PointArrivee,
VilleDestination = trajCourant.VilleDestination,
PointArrivee = trajCourant.PointArrivee,
};
return(v);
}
