private void ChargementComboClients(ComboBox combo)
{
try
{
combo.Items.Clear();
using (var db = new ModelBooking())
{
var resultQuery = (from clients in db.ClientsSet select clients);
if (resultQuery.Any())
{
HashSet <ClientsSet> SetComboClients = resultQuery.ToHashSet();
foreach (ClientsSet client in SetComboClients)
{
combo.Items.Add(client.Id);
}
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void CbHotels_TabReservations_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
if (CbHotels_TabReservations.SelectedValue == null)
{
return;
}
using (var db = new ModelBooking())
{
var resultQuery = (from hotels in db.HotelsSet
where hotels.Id == (int)this.CbHotels_TabReservations.SelectedValue
select hotels.Nom);
if (resultQuery.Any())
{
this.LbNomHotel_TabReservations.Content = resultQuery.First();
ChargementComboChambres(this.CbChambres);
this.CbChambres.IsEnabled = true;
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void LoadChambres()
{
try
{
using (var db = new ModelBooking())
{
var resultQuery = (from chambres in db.ChambresSet select chambres);
if (resultQuery.Any())
{
HashSet <ChambresSet> SetChambres = resultQuery.ToHashSet();
DataTable data = new DataTable();
data.Columns.Add("N° chambre");
data.Columns.Add("Nom de la chambre");
data.Columns.Add("Climatisation");
data.Columns.Add("Nombre de lits");
data.Columns.Add("N° hotel de la chambre");
foreach (ChambresSet ch in SetChambres)
{
data.Rows.Add(new object[] { ch.Id, ch.Nom, ch.Climatisation, ch.NbLits, ch.keyHotel });
}
this.ChambresDataGrid.ItemsSource = SetChambres;
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void ChargementComboHotels(ComboBox combo)
{
try
{
combo.Items.Clear();
using (var db = new ModelBooking())
{
var resultQuery = (from hotels in db.HotelsSet select hotels);
if (resultQuery.Any())
{
HashSet <HotelsSet> SetComboHotels = resultQuery.ToHashSet();
foreach (HotelsSet hotel in SetComboHotels)
{
combo.Items.Add(hotel.Id);
}
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
//TODO : pour les ajouts penser à l'objet en plus de la foreign key
private void BtValiderReservation_Click(object sender, RoutedEventArgs e)
{
try
{
if (CbChambres.SelectedValue == null)
{
MessageBox.Show("Veuillez choisir un hotel puis une chambre");
return;
}
using (var db = new ModelBooking())
{
bool isNewReservation;
ReservationSet reservation;
if ((string)this.LbIdReservation.Content != "" && this.LbIdReservation.Content != null)
{
isNewReservation = false;
int idReservation = Convert.ToInt32(this.LbIdReservation.Content);
var resultQuery = (from reservations in db.ReservationsSet
where reservations.Id == idReservation
select reservations);
if (resultQuery.Any())
{
reservation = resultQuery.First();
}
else
{
return;
}
}
else
{
isNewReservation = true;
reservation = new ReservationSet();
}
reservation.dateDebut = (DateTime)this.DtDebutReservation.SelectedDate;
reservation.dateFin = (DateTime)this.DtFinReservation.SelectedDate;
reservation.keyClient = Convert.ToInt32(this.CbClient.SelectedValue);
reservation.keyChambre = Convert.ToInt32(this.CbChambres.SelectedValue);
if (isNewReservation)
{
db.ReservationsSet.Add(reservation);
}
db.SaveChanges();
}
MessageBox.Show("Enregistré !");
LoadReservations();
ActiverDesactiverControlesReservations(false);
}
catch (Exception ex)
{
throw;
}
}
private void BtValiderChambre_Click(object sender, RoutedEventArgs e)
{
try
{
if (CbHotels_TabChambres.SelectedValue == null)
{
MessageBox.Show("Veuillez choisir un hotel");
return;
}
using (var db = new ModelBooking())
{
bool isNewChambre;
ChambresSet chambre;
if ((string)this.LbIdChambre.Content != "" && this.LbIdChambre.Content != null)
{
isNewChambre = false;
int idChambre = Convert.ToInt32(this.LbIdChambre.Content);
var resultQuery = (from chambres in db.ChambresSet
where chambres.Id == idChambre
select chambres);
if (resultQuery.Any())
{
chambre = resultQuery.First();
}
else
{
return;
}
}
else
{
isNewChambre = true;
chambre = new ChambresSet();
}
chambre.Nom = this.TbNomChambre.Text;
chambre.Climatisation = (bool)this.RdHasClimO.IsChecked;
chambre.NbLits = Convert.ToInt32(this.TbNbLits.Text);
chambre.keyHotel = Convert.ToInt32(this.CbHotels_TabChambres.SelectedValue);
if (isNewChambre)
{
db.ChambresSet.Add(chambre);
}
db.SaveChanges();
}
MessageBox.Show("Enregistré !");
LoadChambres();
ActiverDesactiverControlesChambres(false);
}
catch (Exception ex)
{
throw;
}
}
private void BtValiderHotel_Click(object sender, RoutedEventArgs e)
{
try
{
using (var db = new ModelBooking())
{
bool isNewHotel;
HotelsSet hotel;
if ((string)this.LbIdHotel.Content != "" && this.LbIdHotel.Content != null)
{
isNewHotel = false;
int idHotel = Convert.ToInt32(this.LbIdHotel.Content);
var resultQuery = (from hotels in db.HotelsSet
where hotels.Id == idHotel
select hotels);
if (resultQuery.Any())
{
hotel = resultQuery.First();
}
else
{
return;
}
}
else
{
isNewHotel = true;
hotel = new HotelsSet();
}
hotel.Nom = this.TbNomHotel.Text;
hotel.Capacite = Convert.ToInt32(this.TbCapacite.Text);
hotel.Localisation = this.TbLocalisation.Text;
hotel.Pays = this.TbPays.Text;
if (isNewHotel)
{
db.HotelsSet.Add(hotel);
}
db.SaveChanges();
}
MessageBox.Show("Enregistré !");
LoadHotels();
ActiverDesactiverControlesHotels(false);
}
catch (Exception ex)
{
throw;
}
}
private void BtValiderClient_Click(object sender, RoutedEventArgs e)
{
try
{
using (var db = new ModelBooking())
{
bool isNewClient;
ClientsSet client;
if ((string)this.LbIdClient.Content != "" && this.LbIdClient.Content != null)
{
isNewClient = false;
int idClient = Convert.ToInt32(this.LbIdClient.Content);
var resultQuery = (from clients in db.ClientsSet
where clients.Id == idClient
select clients);
if (resultQuery.Any())
{
client = resultQuery.First();
}
else
{
return;
}
}
else
{
isNewClient = true;
client = new ClientsSet();
}
client.Nom = this.TbNomClient.Text;
client.Prenom = this.TbPrenomClient.Text;
client.DateNaissance = (DateTime)this.DtDateNaissance.SelectedDate;
if (isNewClient)
{
db.ClientsSet.Add(client);
}
db.SaveChanges();
}
MessageBox.Show("Enregistré !");
LoadClients();
ActiverDesactiverControlesClients(false);
}
catch (Exception ex)
{
throw;
}
}
private void ReservationDataGrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
if (this.ReservationDataGrid.SelectedItem == null)
{
return;
}
ReservationSet reservation = (ReservationSet)ReservationDataGrid.SelectedItem;
if (reservation == null)
{
return;
}
ChargementComboHotels(this.CbHotels_TabReservations);
ChargementComboClients(this.CbClient);
this.BtNouvelleReservation.IsEnabled = true;
this.BtSupprimerReservation.IsEnabled = true;
this.LbIdReservation.Content = reservation.Id.ToString();
this.DtDebutReservation.SelectedDate = reservation.dateDebut;
this.DtFinReservation.SelectedDate = reservation.dateFin;
this.CbClient.SelectedItem = reservation.keyClient;
this.CbChambres.SelectedItem = reservation.keyChambre;
using (var db = new ModelBooking())
{
var resultQuery = (from chambre in db.ChambresSet
where chambre.Id == reservation.keyChambre
select chambre.keyHotel);
if (resultQuery.Any())
{
this.CbHotels_TabReservations.SelectedItem = resultQuery.First();
}
}
ActiverDesactiverControlesReservations(true);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void LoadClients()
{
try
{
using (var db = new ModelBooking())
{
var resultQuery = (from clients in db.ClientsSet select clients);
if (resultQuery.Any())
{
HashSet <ClientsSet> SetClients = resultQuery.ToHashSet();
this.ClientsDataGrid.ItemsSource = SetClients;
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void LoadHotels()
{
try
{
using (var db = new ModelBooking())
{
var resultQuery = (from hotels in db.HotelsSet select hotels);
if (resultQuery.Any())
{
HashSet <HotelsSet> SetHotels = resultQuery.ToHashSet();
this.HotelsDataGrid.ItemsSource = SetHotels;
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void LoadReservations()
{
try
{
using (var db = new ModelBooking())
{
var resultQuery = (from reservations in db.ReservationsSet select reservations);
if (resultQuery.Any())
{
HashSet <ReservationSet> SetReservations = resultQuery.ToHashSet();
this.ReservationDataGrid.ItemsSource = SetReservations;
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void BtSupprimerReservation_Click(object sender, RoutedEventArgs e)
{
try
{
this.BtSupprimerReservation.IsEnabled = false;
int idReservation;
if (this.ReservationDataGrid.SelectedItem == null)
{
return;
}
else
{
idReservation = Convert.ToInt32(((ReservationSet)this.ReservationDataGrid.SelectedItem).Id);
}
using (var db = new ModelBooking())
{
var resultQuery = (from reservation in db.ReservationsSet
where reservation.Id == idReservation
select reservation);
if (resultQuery.Any())
{
db.ReservationsSet.Remove(resultQuery.First());
db.SaveChanges();
}
}
MessageBox.Show("Suppression effectuée !");
LoadReservations();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
