public List <Voyage> GetList() { using (var contexte = new BoVoyage()) { return(contexte.Voyages.Include("Destination").ToList()); } }
public List <Client> GetList() { using (var contexte = new BoVoyage()) { return(contexte.Clients.ToList()); } }
public List <Destination> GetList() { using (var contexte = new BoVoyage()) { return(contexte.Destinations.ToList()); } }
public List <Participant> GetList() { using (var contexte = new BoVoyage()) { return(contexte.Participants.ToList()); } }
public List <DossierReservation> GetList() { using (var contexte = new BoVoyage()) { return(contexte.DossierReservations.Include("Participants").Include("Assurances").Include("Voyage").ToList()); } }
public DossierReservation GetById(int dossierReservationId) { using (var contexte = new BoVoyage()) { return(contexte.DossierReservations.Include("Participants") .Include("Assurances").Include("Voyage").Single(x => x.Id == dossierReservationId)); } }
public Voyage Ajout(Voyage voyage) { using (var contexte = new BoVoyage()) { contexte.Voyages.Add(voyage); contexte.SaveChanges(); } return(voyage); }
public Client Ajout(Client client) { using (var contexte = new BoVoyage()) { contexte.Clients.Add(client); contexte.SaveChanges(); } return(client); }
public DossierReservation Ajouter(DossierReservation dossierReservation) { using (var contexte = new BoVoyage()) { contexte.DossierReservations.Add(dossierReservation); contexte.SaveChanges(); } return(dossierReservation); }
public Voyage Update(Voyage voyage) { using (var contexte = new BoVoyage()) { contexte.Voyages.Attach(voyage); contexte.Entry(voyage).State = EntityState.Modified; contexte.SaveChanges(); } return(voyage); }
public bool Effacer(Voyage voyage) { using (var contexte = new BoVoyage()) { contexte.Voyages.Attach(voyage); contexte.Voyages.Remove(voyage); contexte.SaveChanges(); } return(true); }
public DossierReservation Update(DossierReservation dossierReservation) { using (var contexte = new BoVoyage()) { contexte.DossierReservations.Attach(dossierReservation); contexte.Entry(dossierReservation).State = EntityState.Modified; contexte.SaveChanges(); } return(dossierReservation); }
//public List<Client> GetList() //{ // using (var contexte = new BoVoyage()) // { // return contexte.Assurances.ToList(); // } //} public bool Ajout(int assuranceId, int dossierReservationId) { using (var contexte = new BoVoyage()) { var dossier = contexte.DossierReservations.Single(x => x.Id == dossierReservationId); var assurance = contexte.Assurances.Single(x => x.Id == assuranceId); dossier.Assurances.Add(assurance); contexte.SaveChanges(); } return(true); }
public Voyage GetById(int voyageId) { try { using (var contexte = new BoVoyage()) { return(contexte.Voyages.Single(x => x.Id == voyageId)); } } catch { return(null); } }
public Destination GetById(int destinationId) { try { using (var contexte = new BoVoyage()) { return(contexte.Destinations.Single(x => x.Id == destinationId)); } } catch { return(null); } }
public Destination Ajout(Destination destination) { try { using (var contexte = new BoVoyage()) { contexte.Destinations.Add(destination); contexte.SaveChanges(); } return(destination); } catch { return(null); } }
public bool Delete(DossierReservation dossierReservation) { try { using (var contexte = new BoVoyage()) { contexte.DossierReservations.Attach(dossierReservation); contexte.DossierReservations.Remove(dossierReservation); contexte.SaveChanges(); return(true); } } catch { return(false); } }
public Participant Ajouter(Participant participant) { try { using (var contexte = new BoVoyage()) { contexte.Participants.Add(participant); contexte.SaveChanges(); } return(participant); } catch { return(null); } }