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