public static ZoneEtudeViewModel getZoneEtude(int idZoneEtude) { ZoneEtudeDAO pDAO = ZoneEtudeDAO.getZoneEtude(idZoneEtude); int idPersonne = pDAO.idPersonneDAO; PersonneViewModel personne = PersonenORM.getPersonne(2); int idEtude = pDAO.idEtudeDAO; EtudeViewModel etude = EtudeORM.getEtude(idEtude); int idPlage = pDAO.idPlageDAO; PlageViewModel plage = PlageORM.getPlage(idPlage); ZoneEtudeViewModel p = new ZoneEtudeViewModel(pDAO.dateEtudeDAO, pDAO.CoordonnéeADAO, pDAO.CoordonnéeBDAO, pDAO.CoordonnéeCDAO, pDAO.CoordonnéeDDAO, pDAO.superficieZoneEtudeDAO, pDAO.idZoneEtudeDAO, personne, etude, plage); return(p); }
private void AjoutZone_Click_1(object sender, EventArgs e) { try { Regex coordonne = new Regex(@"^[-+]?([1-8]?\d(\.\d+)?|90(\.0+)?),\s*[-+]?(180(\.0+)?|((1[0-7]\d)|([1-9]?\d))(\.\d+)?)$"); if (!coordonne.Match(CoordonneATextBox.Text).Success) { throw new CoordonneInvalidExeption("Coordonnée A invalide"); } if (!coordonne.Match(CoordonneBTextBox.Text).Success) { throw new CoordonneInvalidExeption("Coordonnée B invalide"); } if (!coordonne.Match(CoordonneCTextBox.Text).Success) { throw new CoordonneInvalidExeption("Coordonnée C invalide"); } if (!coordonne.Match(CoordonneDTextBox.Text).Success) { throw new CoordonneInvalidExeption("Coordonnée D invalide"); } string pointA = coordonnee(CoordonneATextBox.Text); string pointB = coordonnee(CoordonneBTextBox.Text); string pointC = coordonnee(CoordonneCTextBox.Text); string pointD = coordonnee(CoordonneDTextBox.Text); myDataObject7 = new ZoneEtudeViewModel(); EtudeViewModel etude = (EtudeViewModel)listeEtude.SelectedItem; PlageViewModel plage = (PlageViewModel)listePlage.SelectedItem; int idZone = ZoneEtudeORM.getMaxIdZone(etude, plage); idZone += 1; PersonneViewModel personne = new PersonneViewModel(2, "", "", "", "", "", 0); ZoneEtudeViewModel nouveau = new ZoneEtudeViewModel(DateTime.Now, pointA, pointB, pointC, pointD, 10, idZone, personne, etude, plage); lp7.Add(nouveau); ZoneEtudeORM.insertZoneEtude(nouveau); lp7 = ZoneEtudeORM.listeZoneEtude(); } catch (CoordonneInvalidExeption coordExpte) { MessageBox.Show(coordExpte.Message); } CoordonneATextBox.Text = string.Empty; CoordonneBTextBox.Text = string.Empty; CoordonneCTextBox.Text = string.Empty; CoordonneDTextBox.Text = string.Empty; listeEtude.Items.Refresh(); listePlage.Items.Refresh(); }
public static ObservableCollection <ZoneEtudeViewModel> listeZoneEtude() { ObservableCollection <ZoneEtudeDAO> lDAO = ZoneEtudeDAO.listeZoneEtude(); ObservableCollection <ZoneEtudeViewModel> l = new ObservableCollection <ZoneEtudeViewModel>(); foreach (ZoneEtudeDAO element in lDAO) { int idPersonne = element.idPersonneDAO; PersonneViewModel personne = PersonenORM.getPersonne(2); int idEtude = element.idEtudeDAO; EtudeViewModel etude = EtudeORM.getEtude(idEtude); int idPlage = element.idPlageDAO; PlageViewModel plage = PlageORM.getPlage(idPlage); ZoneEtudeViewModel p = new ZoneEtudeViewModel(element.dateEtudeDAO, element.CoordonnéeADAO, element.CoordonnéeBDAO, element.CoordonnéeCDAO, element.CoordonnéeDDAO, element.superficieZoneEtudeDAO, element.idZoneEtudeDAO, personne, etude, plage); l.Add(p); } return(l); }
public static void insertZoneEtude(ZoneEtudeViewModel d) { ZoneEtudeDAO.insertZoneEtude(new ZoneEtudeDAO(d.dateEtudeProperty, d.coordonneeAProperty, d.coordonneeBProperty, d.coordonneeCProperty, d.coordonneeDProperty, d.superficieEtudeProperty, d.idZoneEtudeProperty, d.personneProperty.idPersonneProperty, d.etudeProperty.idEtudeProperty, d.plageProperty.idPlageProperty)); }
public static void updateZoneEtude(ZoneEtudeViewModel d) { //ZoneEtudeDAO.updateZoneEtude(new ZoneEtudeDAO(d.idZoneEtudeProperty, d.nomZoneEtudeProperty, d.communeProperty.idCommuneProperty)); }