Example #1
0
 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);
        }