コード例 #1
0
        public MainWindow()
        {
            InitializeComponent();
            DALConnection.OpenConnection();

            lp  = DepartementORM.listeDepartement();
            lp1 = PersonenORM.listePersonne();
            lp2 = EtudeORM.listeEtude();
            lp3 = AnimauxORM.listeAnimaux();
            lp4 = CommuneORM.listeCommune();
            lp5 = PlageORM.listePlage();
            lp7 = ZoneEtudeORM.listeZoneEtude();



            //LIEN AVEC la VIEW
            listeDepartement.ItemsSource = lp;
            listeCommune.ItemsSource     = lp4;
            listePlage.ItemsSource       = PlageZone;
            listeEtude.ItemsSource       = lp2;
            // listeDepartement2.ItemsSource = lp;
            // listeCommune2.ItemsSource = CommuneParDepartement;
            listePlage2.ItemsSource = lp5;
            // this.DataContext = lp; // bind de la liste avec la source, permettant le binding mais de façon globale sur toute la fenetre
        }
コード例 #2
0
        private void ajouterEtude_Click(object sender, EventArgs e)
        {
            myDataObject.titreEtudeProperty = Titre.Text;
            if ((EquipeViewModel)listeEquipeCombo.SelectedItem != null)
            {
                myDataObject.equipeEtude = (EquipeViewModel)listeEquipeCombo.SelectedItem;
            }
            else
            {
                myDataObject.equipeEtude = new EquipeViewModel(1, "MauvaisNumeroEquipe", 0);
            }
            //////////////////////////////////////////////////nombre especes
            string valueToParse = nbEspeces.Text;
            int    result;
            int    defaultValue = 0;

            myDataObject.nbTotalEspeceRencontreeEtudeProperty = int.TryParse(valueToParse, out result) ? result : defaultValue;
            //////////////////////////////////////////////////date
            string   valueToParse2 = Date.Text;
            DateTime result2;
            DateTime defaultValue2 = DateTime.Now;

            myDataObject.dateEtudeProperty = DateTime.TryParse(valueToParse2, out result2) ? result2 : defaultValue2;
            //////////////////////////////////////////////////insert
            EtudeViewModel nouveau = new EtudeViewModel(EtudeDAL.getMaxIdEtude() + 1, myDataObject.dateEtudeProperty, myDataObject.titreEtudeProperty, myDataObject.nbTotalEspeceRencontreeEtudeProperty, myDataObject.equipeEtudeProperty);

            lu.Add(nouveau);
            EtudeORM.insertEtude(nouveau);
            listeEquipeCombo.ItemsSource = lp;
            listeEtudes.Items.Refresh();
            listeEquipeCombo.Items.Refresh();
            listeEtudes.ItemsSource = lu;
        }
コード例 #3
0
        private void supprimerButton(object sender, RoutedEventArgs e)
        {
            EtudeViewModel toRemove = (EtudeViewModel)listeEtudes.SelectedItem;

            lp.Remove(toRemove);
            listeEtudes.Items.Refresh();
            EtudeORM.supprimerEtude(selectedEtudeId);
        }
コード例 #4
0
ファイル: EtudeViewModel.cs プロジェクト: gongwang/Ifroc-an
        private void OnPropertyChanged(string info)
        {
            PropertyChangedEventHandler handler = PropertyChanged;

            if (handler != null)
            {
                handler(this, new PropertyChangedEventArgs(info));
                EtudeORM.updateEtude(this);
            }
        }
コード例 #5
0
        private void supprimerButton_MouseDoubleClick(object sender, System.Windows.Input.MouseButtonEventArgs e)
        {
            EtudeViewModel toRemove = (EtudeViewModel)listeEtudes.SelectedItem;

            lp4.Remove(toRemove);

            EtudeORM.supprimerEtude(selectedEtudeId);

            MessageBox.Show("Etude supprimée avec succes ! ");
        }
コード例 #6
0
        ////////////////////////////////////////////////////////////////////////////////

        /////////////// Etude////////////////////////////////////////////////////////

        private void ajouterEtudeButton_MouseDoubleClick(object sender, System.Windows.Input.MouseButtonEventArgs e)
        {
            myDataObject_Etude = new EtudeViewModel();
            myDataObject_Etude.DateProperty = Date_etudeTextBox.Text;
            myDataObject_Etude.SuperficieEtudierProperty = Super_etudeTextBox.Text;
            EtudeViewModel nouveau = new EtudeViewModel(EtudeDAL.getMaxIdEtude() + 1, myDataObject_Etude.DateProperty, myDataObject_Etude.SuperficieEtudierProperty);

            lp_Et.Add(nouveau);
            EtudeORM.insertEtude(nouveau);
            listeEtude.Items.Refresh();
            compteur           = lp_Et.Count();
            myDataObject_Etude = new EtudeViewModel(EtudeDAL.getMaxIdEtude() + 1, "", "");
        }
コード例 #7
0
ファイル: MainWindow.xaml.cs プロジェクト: michy4/ifrocean
 public MainWindow()
 {
     InitializeComponent();
     DALConnection.OpenConnection();
     lu = ComptageORM.listeComptages();
     // Initialisation de la liste des personnes via la BDD.
     le = EtudeORM.listeEtudes();
     lp = PlageORM.listePlages();
     //lu = EtudeORM.getEtude(user.idPersonne);
     MainWindow.user = user;
     ListeEtude.ItemsSource = le; 
     ListePlage.ItemsSource = lp;
     //listeComptages.ItemsSource = lu;
 }
コード例 #8
0
        public AfficherEtude()
        {
            InitializeComponent();
            lp = EtudeORM.listeEtudes();
            le = EquipeORM.listeEquipes();
            listeEtudes.ItemsSource     = lp;
            idEquipeTextBox.ItemsSource = le;
            myDataObject = new EtudeViewModel();
            CultureInfo culture = (CultureInfo)CultureInfo.CurrentCulture.Clone();

            culture.DateTimeFormat.ShortDatePattern = "yyyy-MM-dd";
            culture.DateTimeFormat.LongTimePattern  = "";
            Thread.CurrentThread.CurrentCulture     = culture;
        }
コード例 #9
0
        private void etudeButton_MouseDoubleClick(object sender, MouseButtonEventArgs e)
        {
            myDataObject3 = new EtudeViewModel();
            myDataObject3.nomEtudeProperty   = nomeTextBox.Text;
            myDataObject3.dateEtudeProperty  = dateDatePicker.DisplayDate;
            myDataObject3.nbPersonneProperty = nbpersTextBox.Text;
            myDataObject3.idPersonneProperty = Convert.ToInt32(idpersTextBox.Text);
            EtudeViewModel nouveau = new EtudeViewModel(EtudeDAL.getMaxIdEtude() + 1, myDataObject3.nomEtudeProperty, myDataObject3.dateEtudeProperty, myDataObject3.nbPersonneProperty, myDataObject3.idPersonneProperty);

            et.Add(nouveau);
            EtudeORM.insertEtude(nouveau);
            listeEtudes.Items.Refresh();
            compteur      = et.Count();
            myDataObject3 = new EtudeViewModel(EtudeDAL.getMaxIdEtude() + 1, "", myDataObject3.dateEtudeProperty, "", myDataObject3.idPersonneProperty);
        }
コード例 #10
0
        public EtudeB()
        {
            InitializeComponent();

            lp1 = PlageORM.listePlages();
            listePlagesCombo.ItemsSource = lp1;
            lp4 = EtudeORM.ListeEtude();
            listeEtudes.ItemsSource = lp4;


            CultureInfo culture = (CultureInfo)CultureInfo.CurrentCulture.Clone();

            culture.DateTimeFormat.ShortDatePattern = "yyyy-MM-dd-HH-mm-ss"; //Format BDD
            culture.DateTimeFormat.LongTimePattern  = "";
            Thread.CurrentThread.CurrentCulture     = culture;
        }
コード例 #11
0
        ////////////////////////////////////////////////////////////////////////////////
        /////////////// Etude////////////////////////////////////////////////////////


        private void supprimerButton_Etude_MouseDoubleClick(object sender, System.Windows.Input.MouseButtonEventArgs e)
        {
            EtudeViewModel   toRemove = (EtudeViewModel)listeEtude.SelectedItem;
            MessageBoxResult result   = MessageBox.Show("Voulez vous bien supprimer l'Etude " + toRemove.idEtudeProperty + " de la table ?", "Table Etude", MessageBoxButton.YesNo);

            switch (result)
            {
            case MessageBoxResult.Yes:
                MessageBox.Show("L'étude a été suprimmer", "Table Etude");

                lp_Et.Remove(toRemove);
                listeEtude.Items.Refresh();
                EtudeORM.supprimerEtude(selectedEtudeId);
                break;

            case MessageBoxResult.No:
                MessageBox.Show("L'étude n'a pas été supprimer", "Table Etude");
                break;
            }
        }
コード例 #12
0
        public EspeceNombre()
        {
            InitializeComponent();
            lp8 = EspeceNombreORM.ListeEspeceNombres();
            listeEspecesNombres.ItemsSource = lp8;

            lp1 = PlageORM.listePlages();
            listePlagesCombo.ItemsSource = lp1;

            lp4 = EtudeORM.ListeEtude();
            listeEtudesCombo.ItemsSource = lp4;

            lp5 = EspeceORM.listeEspeces();
            listeEspeceCombo.ItemsSource = lp5;

            lp7 = ZoneInvestigationORM.ListeZoneInvestigation();
            listeZonesCombo.ItemsSource = lp7;

            lp8 = EspeceNombreORM.ListeEspeceNombres();
        }
コード例 #13
0
        public MainWindow()
        {
            InitializeComponent();
            DALConnection.OpenConnection();

            lp = PersonneORM.listePersonnes();

            listePersonnes.ItemsSource = lp;

            pl = PlageORM.listePlages();

            listePlages.ItemsSource = pl;

            dp = DepartementORM.listeDepartements();

            listeDepartements.ItemsSource = dp;

            et = EtudeORM.listeEtudes();

            listeEtudes.ItemsSource = et;
        }
コード例 #14
0
        /////////////////////////////////////    Etudes    /////////////////////////////////////
        /////////////////////////////////////    Etudes    /////////////////////////////////////
        ///
        private void ValideEtude_Click(object sender, RoutedEventArgs e)
        {
            myDataObject4 = new EtudeViewModel();
            myDataObject4.NbPersonneEtudeProperty = Convert.ToDecimal(NbPersonne.SelectionBoxItem);
            myDataObject4.dateCreationProperty    = Convert.ToDateTime(dateCreationDatePicker.SelectedDate);
            myDataObject4.dateFinProperty         = Convert.ToDateTime(dateFinDatePicker1.SelectedDate);
            myDataObject4.PlageEtude         = (PlageViewModel)listePlagesCombo.SelectedItem;
            myDataObject4.TitreEtudeProperty = Titre.Text;

            EtudeViewModel nouveau = new EtudeViewModel(EtudeDAL.getMaxIdEtude() + 1, myDataObject4.NbPersonneEtudeProperty, myDataObject4.TitreEtudeProperty, myDataObject4.PlageEtudeProperty, myDataObject4.dateCreationProperty, myDataObject4.dateFinProperty);

            lp4.Add(nouveau);
            EtudeORM.insertEtude(nouveau);
            compteur = lp4.Count();

            listeEtudes.ItemsSource = lp4;

            ((TextBox)Titre).Text = string.Empty;

            MessageBox.Show("Etude ajoutée avec succes ! ");
        }
コード例 #15
0
        public ZoneInvestigation()
        {
            InitializeComponent();

            lp = UsersORM.listeUsers();
            listeUsersCombo.ItemsSource = lp;
            lp1 = PlageORM.listePlages();
            listePlageCombo.ItemsSource = lp1;
            lp4 = EtudeORM.ListeEtude();
            listeEtudesCombo.ItemsSource = lp4;
            listeDateCombo.ItemsSource   = lp4;
            lp7 = ZoneInvestigationORM.ListeZoneInvestigation();
            ListeEtudeZone.ItemsSource = lp7;

            lp7 = ZoneInvestigationORM.ListeZoneInvestigation();

            CultureInfo culture = (CultureInfo)CultureInfo.CurrentCulture.Clone();

            culture.DateTimeFormat.ShortDatePattern = "yyyy-MM-dd-HH-mm-ss"; //Format BDD
            culture.DateTimeFormat.LongTimePattern  = "";
            Thread.CurrentThread.CurrentCulture     = culture;
        }
コード例 #16
0
        private void ajouterButton(object sender, RoutedEventArgs e)
        {
            myDataObject.dateEtudeProperty = (DateTime)dateTextBox.SelectedDate;
            //DateTime defaultValDate = DateTime.Now;
            //myDataObject.dateEtudeProperty = DateTime.TryParse(, out DateTime resultDate) ? resultDate : defaultValDate;


            myDataObject.titreEtudeProperty = titreTextBox.Text;

            int.TryParse(nbTotalEspeceRencontreeTextBox.Text, out int resultNbEspece);
            myDataObject.nbTotalEspeceRencontreeEtudeProperty = resultNbEspece;

            //int defaultValEquipe = 1; //si mauvaise valeur -> équipe 1 par default
            myDataObject.equipeEtude = (EquipeViewModel)idEquipeTextBox.SelectedItem;

            EtudeViewModel nouveau = new EtudeViewModel(EtudeDAL.getMaxIdEtude() + 1, myDataObject.dateEtudeProperty, myDataObject.titreEtudeProperty, myDataObject.nbTotalEspeceRencontreeEtudeProperty, myDataObject.equipeEtudeProperty);

            lp.Add(nouveau);
            EtudeORM.insertEtude(nouveau);
            listeEtudes.Items.Refresh();
            myDataObject = new EtudeViewModel(EtudeDAL.getMaxIdEtude() + 1, myDataObject.dateEtudeProperty, "", myDataObject.nbTotalEspeceRencontreeEtudeProperty, myDataObject.equipeEtudeProperty);
        }
コード例 #17
0
        public MainWindow(Window actual_window)
        {
            window = actual_window;
            InitializeComponent();
            DALConnection.OpenConnection();

            // Initialisation de la liste des personnes via la BDD.
            lp      = PersonneORM.listePersonnes();
            lp_prel = PrelevementORM.listePrelevements();
            lp_Esp  = EspeceORM.listeEspeces();
            lp_Et   = EtudeORM.listeEtude();
            lp_Pl   = PlageORM.listePlages();
            lc      = CommuneORM.listeCommunes();
            de      = DepartementORM.listeDepartements();

            //LIEN AVEC la VIEW
            listePersonnes.ItemsSource   = lp;
            listePrelevement.ItemsSource = lp_prel;
            listeEspece.ItemsSource      = lp_Esp;
            listeEtude.ItemsSource       = lp_Et;
            listePlages.ItemsSource      = lp_Pl;
            // bind de la liste avec la source, permettant le binding.
            // this.DataContext = lp; // bind de la liste avec la source, permettant le binding mais de façon globale sur toute la fenetre


            //COMBO BOX FONCTIONNEL
            foreach (var item in lc)
            {
                liste_box1.Items.Add(item.nomVilleProperty);
            }
            foreach (var item in de)
            {
                liste_box3.Items.Add(item.nomProperty);
            }
            foreach (var item2 in lp_prel)
            {
                liste_box2.Items.Add(item2.idprelevementProperty);
            }
        }
コード例 #18
0
        private void AjouterEtude_Click_1(object sender, EventArgs e)
        {
            myDataObject2 = new EtudeViewModel();
            myDataObject2.nomEtudeProperty = nomEtudeTextBox.Text;

            myDataObject6 = new PlageDeEtudeViewModel();

            EtudeViewModel nouveau = new EtudeViewModel(0, myDataObject2.nomEtudeProperty);

            lp2.Add(nouveau);
            EtudeORM.insertEtude(nouveau);
            lp2 = EtudeORM.listeEtude();
            EtudeViewModel newEtude = EtudeORM.listeEtude().Last();

            foreach (PlageViewModel plage in lp5)
            {
                if (plage.isChekedProperty)
                {
                    PlageDeEtudeViewModel ajoutNouveau = new PlageDeEtudeViewModel(newEtude, plage);
                    PlageDeEtudeORM.insertPlageDeEtude(ajoutNouveau);
                }
            }
            nomEtudeTextBox.Text = string.Empty;
        }
コード例 #19
0
 public AfficherChoixEtude()
 {
     InitializeComponent();
     le = EtudeORM.listeEtudes();
     etudeComboBox.ItemsSource = le;
 }
コード例 #20
0
 private void ListeEtude_Selected(object sender, RoutedEventArgs e)
 {
     PlageZone = new ObservableCollection <PlageViewModel>();
     PlageZone = EtudeORM.listeEtudePlage((EtudeViewModel)listeEtude.SelectedItem);
     listePlage.ItemsSource = PlageZone;
 }