public Step Load(VOYAGE_ETAPE step) { Id = step.ID; Type = Type.GetEnum <TypeStep>(step.ID_TYPE_ETAPE); Address = step.ADRESSE; Order = step.ORDRE; Latitude = (double)step.COORD_Y; Longitude = (double)step.COORD_X; return(this); }
public int GetKm(VOYAGE_ETAPE De, VOYAGE_ETAPE A) { var guidageDe = GetAll().Where(l => l.ID_VOYAGE_ETAPE_DE == De.ID).OrderBy(p => p.ORDRE_VOYAGE).First(); var guidateA = GetAll().Where(l => l.ID_VOYAGE_ETAPE_A == A.ID).OrderByDescending(p => p.ORDRE_VOYAGE).First(); //return (GetAll().Where(l => l.ORDRE_VOYAGE >= guidageDe.ORDRE_VOYAGE && l.ORDRE_VOYAGE <= guidateA.ORDRE_VOYAGE) // .Sum(l => l.DISTANCE_M)) / 1000; var voyage = De.VOYAGE; return((from guidage in _context.VOYAGE_GUIDAGE join etape in _context.VOYAGE_ETAPE on guidage.ID_VOYAGE_ETAPE_DE equals etape.ID where etape.ID_VOYAGE == voyage.ID && guidage.ORDRE_VOYAGE >= guidageDe.ORDRE_VOYAGE && guidage.ORDRE_VOYAGE <= guidateA.ORDRE_VOYAGE select new { Guidage = guidage, Etape = etape }).Sum(g => g.Guidage.DISTANCE_M) / 1000); }
internal SaveResult Save(Trip trip) { try { var data = new VOYAGE_ETAPE(); data.ID_VOYAGE = trip.Id; data.ID_TYPE_ETAPE = Type.GetGuid().Value; data.ADRESSE = Address; data.ORDRE = Order; data.COORD_Y = (decimal)Latitude; data.COORD_X = (decimal)Longitude; Container.Manager.EtapeOperation.Add(data); Container.Manager.Save(); Id = data.ID; return(new SaveResult(true, Id)); } catch (Exception ex) { Logger.Error(ex, "Passager.Save()"); return(new SaveResult(ex)); } }
public float GetPrixVoyage(VOYAGE voyage, VOYAGE_ETAPE etapeDe, VOYAGE_ETAPE etapeA) { VoyageGuidageOperation voyageGuidageOperation = new VoyageGuidageOperation(_contextTrip); return(voyage.COUT_AU_KM / voyageGuidageOperation.GetKm(voyage) * voyageGuidageOperation.GetKm(etapeDe, etapeA)); }