public VueModele(Dbal dbal, DAOxClients dAOxClients, DAOxFonction dAOxFonction, DAOxObstacles dAOxObstacles, DAOxOperateur dAOxOperateur, DAOxOperateurSalle dAOxOperateurSalle, DAOxPartieObstacles dAOxPartieObstacles, DAOxParties dAOxParties, DAOxSalle dAOxSalle, DAOxTheme dAOxTheme, DAOxTransactions dAOxTransactions, DAOxVille dAOxVille)
{
_bdd = dbal;
_clients = dAOxClients;
_fonction = dAOxFonction;
_obstacles = dAOxObstacles;
_operateur = dAOxOperateur;
_operateurSalle = dAOxOperateurSalle;
_partieObstacles = dAOxPartieObstacles;
_parties = dAOxParties;
_salle = dAOxSalle;
_theme = dAOxTheme;
_transactions = dAOxTransactions;
_ville = dAOxVille;
}
public MainWindow()
{
Dbal bdd = new Dbal("192.168.1.16", "egc", "Admin", "Admin");
//Dbal bdd = new Dbal("172.31.254.186", "egc", "Admin", "Admin");
DAOxClients clients = new DAOxClients(bdd);
DAOxFonction fonction = new DAOxFonction(bdd);
DAOxObstacles obstacles = new DAOxObstacles(bdd);
DAOxOperateur operateur = new DAOxOperateur(bdd);
DAOxOperateurSalle operateurSalle = new DAOxOperateurSalle(bdd);
DAOxPartieObstacles partieObstacles = new DAOxPartieObstacles(bdd);
DAOxParties parties = new DAOxParties(bdd);
DAOxSalle salle = new DAOxSalle(bdd);
DAOxTheme theme = new DAOxTheme(bdd);
DAOxTransactions transactions = new DAOxTransactions(bdd);
DAOxVille ville = new DAOxVille(bdd);
List <String> ListHoraire = new List <String> {
"8h30", "10h00", "11h00", "12h30", "14h00", "15h30", "17h00", "18h30"
};
InitializeComponent();
Selection_jour.SelectedDate = DateTime.Now;
Load_Planning(salle.SelectAllSalle(), Convert.ToDateTime(Selection_jour.SelectedDate));
void Load_Planning(List <DTOSalle> listSalles, DateTime date)
{
RowDefinition rowDefinition = new RowDefinition();
rowDefinition.Height = new GridLength(50);
grid_planning.RowDefinitions.Add(rowDefinition);
ColumnDefinition columnDefinition = new ColumnDefinition();
columnDefinition.Width = new GridLength(140);
grid_planning.ColumnDefinitions.Add(columnDefinition);
//Création des colonnes du planning
for (int i = 0; i < ListHoraire.Count(); i++)
{
ColumnDefinition cm = new ColumnDefinition();
cm.Width = new GridLength(80);
grid_planning.ColumnDefinitions.Add(cm);
}
//Création des lignes du planning
for (int i = 0; i < listSalles.Count(); i++)
{
RowDefinition rw = new RowDefinition();
rw.Height = new GridLength(50);
grid_planning.RowDefinitions.Add(rw);
Label lbl_salle = new Label();
lbl_salle.Content = listSalles[1].GetNom();
lbl_salle.Height = 50;
lbl_salle.Width = 140;
lbl_salle.FontSize = 15;
lbl_salle.HorizontalContentAlignment = HorizontalAlignment.Center;
lbl_salle.VerticalContentAlignment = VerticalAlignment.Center;
Grid.SetRow(lbl_salle, i + 1);
Grid.SetColumn(lbl_salle, 0);
grid_planning.Children.Add(lbl_salle);
}
for (int i = 0; i < listSalles.Count(); i++)
{
for (int j = 0; j < ListHoraire.Count(); j++)
{
Border br_planning_fin = new Border();
br_planning_fin.BorderThickness = new Thickness(1);
Grid.SetRow(br_planning_fin, i);
Grid.SetColumn(br_planning_fin, 0);
grid_planning.Children.Add(br_planning_fin);
Border br_planning = new Border();
br_planning.BorderThickness = new Thickness(1);
Grid.SetRow(br_planning, i);
Grid.SetColumn(br_planning, j);
grid_planning.Children.Add(br_planning);
Label lbl_horaire = new Label();
lbl_horaire.Content = ListHoraire[j];
lbl_horaire.Height = 50;
lbl_horaire.Width = 80;
lbl_horaire.FontSize = 15;
lbl_horaire.HorizontalContentAlignment = HorizontalAlignment.Center;
lbl_horaire.VerticalContentAlignment = VerticalAlignment.Center;
Grid.SetRow(lbl_horaire, 0);
Grid.SetColumn(lbl_horaire, j + 1);
grid_planning.Children.Add(lbl_horaire);
Button btn = new Button();
btn.Width = 140;
btn.Height = 50;
btn.FontSize = 15;
btn.Background = Brushes.White;
for (int k = 0; k < parties.SelectAllPartie().Count(); k++)
{
if (parties.SelectAllPartie()[k].GetSalle() == listSalles[k] & parties.SelectAllPartie()[k].GetDateHeure() == date & parties.SelectAllPartie()[k].GetHeure() == ListHoraire[k])
{
btn.Content = "Réservée";
}
if (!(parties.SelectAllPartie()[k].GetSalle() == listSalles[k] & parties.SelectAllPartie()[k].GetDateHeure() == date & parties.SelectAllPartie()[k].GetHeure() == ListHoraire[k]))
{
btn.Content = "Libre";
}
}
if (salle.SelectAllSalle()[i].GetHeureOuverture() == ListHoraire[j] & salle.SelectAllSalle()[i].GetHeureFermeture() == ListHoraire[j])
{
btn.Content = "Fermée";
}
btn.VerticalContentAlignment = VerticalAlignment.Center;
btn.HorizontalContentAlignment = HorizontalAlignment.Center;
Grid.SetRow(btn, i + 1);
Grid.SetColumn(btn, j + 1);
grid_planning.Children.Add(btn);
}
}
}
Calendrier.DataContext = new VueModele(bdd, clients, fonction, obstacles, operateur, operateurSalle, partieObstacles, parties, salle, theme, transactions, ville);
}