private void addZoneEButton_Click(object sender, EventArgs e)
{
selectedEspeceId = (lespèces.ElementAt <EspèceViewModel>(listeEspeces.SelectedIndex)).idEspèceProperty;
EspèceViewModel espece = ORMEspèce.getEspèce(selectedEspeceId);
selectedZoneId = (lzonesP.ElementAt <ZonePrelevementViewModel>(listeZones.SelectedIndex)).idZonePrelevementProperty;
ZonePrelevementViewModel zone = ORMZonePrelevement.getZone(selectedZoneId);
selectedEtudeId = (letudes.ElementAt <EtudeViewModel>(listeEtudes2.SelectedIndex)).idEtudeProperty;
EtudeViewModel etude = ORMEtude.getEtude(selectedEtudeId);
selectedPlageId = (lplages.ElementAt <PlageViewModel>(listePlages2.SelectedIndex)).idPlageProperty;
PlageViewModel plage = ORMPlage.getPlage(selectedPlageId);
int nbr = int.Parse(nbrAnimaux.Text);
zoneEDataObject = new ZoneEspeceViewModel();
zoneEDataObject.idEspeceProperty = espece;
zoneEDataObject.idZonePrelevementProperty = zone;
zoneEDataObject.idEtudeProperty = etude;
zoneEDataObject.idPlageProperty = plage;
zoneEDataObject.nombreProperty = nbr;
ZoneEspeceViewModel nouvelle = new ZoneEspeceViewModel(DALZoneEspece.getMaxIdZone(), zoneEDataObject.idEspeceProperty, zoneEDataObject.idZonePrelevementProperty, zoneEDataObject.idEtudeProperty, zoneEDataObject.idPlageProperty, zoneEDataObject.nombreProperty);
ORMZoneEspece.addZone(nouvelle);
}
private void addZonePButton_Click(object sender, EventArgs e)
{
selectedEtudeId = (letudes.ElementAt <EtudeViewModel>(listeEtudeSelect.SelectedIndex)).idEtudeProperty;
EtudeViewModel etude = ORMEtude.getEtude(selectedEtudeId);
selectedPlageId = (lplages.ElementAt <PlageViewModel>(listePlageSelect.SelectedIndex)).idPlageProperty;
PlageViewModel plage = ORMPlage.getPlage(selectedPlageId);
selectedAdminId = (ladmins.ElementAt <PersonneViewModel>(liste2AdminSelect.SelectedIndex)).idPersonneProperty;
PersonneViewModel personne = ORMPersonne.getPersonne(selectedAdminId);
int angle1 = int.Parse(Angle1TextBox.Text);
int angle2 = int.Parse(Angle2TextBox.Text);
int angle3 = int.Parse(Angle3TextBox.Text);
int angle4 = int.Parse(Angle4TextBox.Text);
zonePDataObject = new ZonePrelevementViewModel();
zonePDataObject.idEtudeProperty = etude;
zonePDataObject.idPlageProperty = plage;
zonePDataObject.Angle1Property = angle1;
zonePDataObject.Angle2Property = angle2;
zonePDataObject.Angle3Property = angle3;
zonePDataObject.Angle4Property = angle4;
zonePDataObject.idPersonneProperty = personne;
ZonePrelevementViewModel nouvelle = new ZonePrelevementViewModel(DALZonePrelevement.getMaxIdZone(), zonePDataObject.idEtudeProperty, zonePDataObject.idPlageProperty, zonePDataObject.Angle1Property, zonePDataObject.Angle2Property, zonePDataObject.Angle3Property, zonePDataObject.Angle4Property, zonePDataObject.idPersonneProperty);
lzonesP.Add(nouvelle);
ORMZonePrelevement.addZone(nouvelle);
listeZones2.Items.Refresh();
}
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;
}
public static EtudeViewModel getEtude(int idEtude)
{
EtudeDAO pDAO = EtudeDAO.getEtude(idEtude);
EtudeViewModel p = new EtudeViewModel(pDAO.idEtudeDAO, pDAO.nomEtudeDAO, pDAO.dateEtudeDAO, pDAO.nbPersonneDAO, pDAO.idPersonneDAO);
return(p);
}
private void supprimerButton(object sender, RoutedEventArgs e)
{
EtudeViewModel toRemove = (EtudeViewModel)listeEtudes.SelectedItem;
lp.Remove(toRemove);
listeEtudes.Items.Refresh();
EtudeORM.supprimerEtude(selectedEtudeId);
}
public static EtudeViewModel getEtude(int idEtude)
{
EtudeDAO pDAO = EtudeDAO.getEtude(idEtude);
EtudeViewModel p = new EtudeViewModel(pDAO.idEtudeDAO, pDAO.DateDAO, pDAO.SuperficieEtudierDAO);
return(p);
}
public static EtudeViewModel getEtude(int idEtude)
{
EtudeDAO pDAO = EtudeDAO.getEtude(idEtude);
//int idMetier = pDAO.idMetierPersonneDAO;
//MetierViewModel m = MetierORM.getMetier(idMetier);
EtudeViewModel p = new EtudeViewModel(pDAO.id, pDAO.nom, pDAO.date, UtilisateurORM.getPersonne(pDAO.proprio) /*, m*/);
return(p);
}
public static EtudeViewModel getEtude(int idEtude)
{
EtudeDAO pDAO = EtudeDAO.getEtude(idEtude);
int idEquipe = pDAO.idEquipeEtudeDAO;
EquipeViewModel m = EquipeORM.getEquipe(idEquipe);
EtudeViewModel p = new EtudeViewModel(pDAO.idEtudeDAO, pDAO.dateEtudeDAO, pDAO.titreEtudeDAO, pDAO.nbTotalEspeceRencontreeEtudeDAO, m);
return(p);
}
public static EtudeViewModel getEtude(int idEtude)
{
EtudeDAO pDAO = EtudeDAO.getEtude(idEtude);
int idPlage = pDAO.PlageEtudeDAO;
PlageViewModel m = PlageORM.getPlage(idPlage);
EtudeViewModel p = new EtudeViewModel(pDAO.idEtudeDAO, pDAO.NbPersonneEtudeDAO, pDAO.TitreEtudeEtudeDAO, m, pDAO.dateCreationDAO, pDAO.dateFinDAO);
return(p);
}
public EspeceNombreViewModel(int IdNombreE, ZoneInvestigationViewModel IdZone, EspeceViewModel idEspece, PlageViewModel idPlage, EtudeViewModel idEtude, Decimal Nombre)
{
this.IdNombreE = IdNombreE;
this.IdZone = IdZone;
this.IdEtude = idEtude;
this.IdPlage = idPlage;
this.IdEspece = idEspece;
this.Nombre = Nombre;
}
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 ! ");
}
public static EtudeViewModel getEtude(int id)
{
DAOEtude daoetude = DAOEtude.getEtude(id);
int idPersonne = daoetude.idPersonneDAO;
PersonneViewModel personne = ORMPersonne.getPersonne(idPersonne);
EtudeViewModel etude = new EtudeViewModel(daoetude.idEtudeDAO, daoetude.nomEtudeDAO, daoetude.dateDAO, personne);
return(etude);
}
public static ObservableCollection <EtudeViewModel> listeEtudes()
{
ObservableCollection <EtudeDAO> lDAO = EtudeDAO.listeEtudes();
ObservableCollection <EtudeViewModel> l = new ObservableCollection <EtudeViewModel>();
foreach (EtudeDAO element in lDAO)
{
EtudeViewModel p = new EtudeViewModel(element.idEtudeDAO, element.nomEtudeDAO, element.dateEtudeDAO, element.nbPersonneDAO, element.idPersonneDAO);
l.Add(p);
}
return(l);
}
public static ObservableCollection <EtudeViewModel> getEtudes(int idpersonne)
{
ObservableCollection <peDAO> lDAO = peDAO.getIdEtude(idpersonne);
ObservableCollection <EtudeViewModel> Etudes = new ObservableCollection <EtudeViewModel>();
foreach (peDAO p in lDAO)
{
EtudeViewModel e = EtudeORM.getEtude(p.idEtudeDAO);
Etudes.Add(e);
}
return(Etudes);
}
public static ObservableCollection <EtudeViewModel> listeEtude()
{
ObservableCollection <EtudeDAO> lDAO = EtudeDAO.listeEtude();
ObservableCollection <EtudeViewModel> l = new ObservableCollection <EtudeViewModel>();
foreach (EtudeDAO element in lDAO)
{
EtudeViewModel p = new EtudeViewModel(element.idEtudeDAO, element.DateDAO, element.SuperficieEtudierDAO);
l.Add(p);
}
return(l);
}
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);
}
////////////////////////////////////////////////////////////////////////////////
/////////////// 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, "", "");
}
public static EtudeHasEspeceViewModel getEtudeHasEspece(int idEtude, int idEspece)
{
EtudeHasEspeceDAO eDAO = EtudeHasEspeceDAO.getEtudeHasEspece(idEtude, idEspece);
int Etude_idEtude = eDAO.Etude_idEtudeDAO;
EtudeViewModel et = EtudeORM.getEtude(Etude_idEtude);
int Espece_idEspece = eDAO.Espece_idEspeceDAO;
EspeceViewModel e = EspeceORM.getEspece(Espece_idEspece);
EtudeHasEspeceViewModel ee = new EtudeHasEspeceViewModel(et, e, eDAO.densiteTotaleEspeceDAO);
return(ee);
}
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 <EtudeViewModel> ListeEtude()
{
ObservableCollection <EtudeDAO> lDAO = EtudeDAO.listeEtudes();
ObservableCollection <EtudeViewModel> l = new ObservableCollection <EtudeViewModel>();
foreach (EtudeDAO element in lDAO)
{
int idPlage = element.PlageEtudeDAO;
PlageViewModel m = PlageORM.getPlage(idPlage);
EtudeViewModel p = new EtudeViewModel(element.idEtudeDAO, element.NbPersonneEtudeDAO, element.TitreEtudeEtudeDAO, m, element.dateCreationDAO, element.dateFinDAO);
l.Add(p);
}
return(l);
}
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;
}
public static ObservableCollection <PlageViewModel> listeEtudePlage(EtudeViewModel etude)
{
ObservableCollection <PlageDAO> lDAO = PlageDAO.listeEtudePlage(etude.idEtudeProperty);
ObservableCollection <PlageViewModel> l = new ObservableCollection <PlageViewModel>();
foreach (PlageDAO element in lDAO)
{
int id = element.idCommunePlageDAO;
CommuneViewModel m = CommuneORM.getCommune(id);
PlageViewModel p = new PlageViewModel(element.idPlageDAO, element.nomPlageDAO, m);
l.Add(p);
}
return(l);
}
public static ObservableCollection <EtudeViewModel> listeEtudes()
{
ObservableCollection <EtudeDAO> lDAO = EtudeDAO.listeEtudes();
ObservableCollection <EtudeViewModel> l = new ObservableCollection <EtudeViewModel>();
foreach (EtudeDAO element in lDAO)
{
int idEquipe = element.idEquipeEtudeDAO;
EquipeViewModel m = EquipeORM.getEquipe(idEquipe);
EtudeViewModel u = new EtudeViewModel(element.idEtudeDAO, element.dateEtudeDAO, element.titreEtudeDAO, element.nbTotalEspeceRencontreeEtudeDAO, m);
l.Add(u);
}
return(l);
}
public static ObservableCollection <EtudeViewModel> listeEtudes()
{
ObservableCollection <DAOEtude> listeDAO = DAOEtude.listeEtudes();
ObservableCollection <EtudeViewModel> listeEtudes = new ObservableCollection <EtudeViewModel>();
foreach (DAOEtude item in listeDAO)
{
int idPersonne = item.idPersonneDAO;
PersonneViewModel personneID = ORMPersonne.getPersonne(idPersonne);
EtudeViewModel etude = new EtudeViewModel(item.idEtudeDAO, item.nomEtudeDAO, item.dateDAO, personneID);
listeEtudes.Add(etude);
}
return(listeEtudes);
}
public static ObservableCollection <EtudeViewModel> listeEtudes()
{
ObservableCollection <EtudeDAO> lDAO = EtudeDAO.listeEtudes();
ObservableCollection <EtudeViewModel> l = new ObservableCollection <EtudeViewModel>();
foreach (EtudeDAO element in lDAO)
{
//int idMetier = element.idMetierPersonneDAO;
//MetierDAO m = MetierDAO.getMetier(idMetier);
//MetierViewModel metier = new MetierViewModel(m.idMetierDAO, m.libMetierDAO);
EtudeViewModel p = new EtudeViewModel(element.id, element.nom, element.date, UtilisateurORM.getPersonne(element.proprio) /*, metier*/);
l.Add(p);
}
return(l);
}
public static ObservableCollection <EtudeViewModel> listeEtudes()
{
ObservableCollection <EtudeDAO> lDAO = EtudeDAO.listeEtudes();
ObservableCollection <EtudeViewModel> l = new ObservableCollection <EtudeViewModel>();
foreach (EtudeDAO element in lDAO)
{
int idEquipe = element.idEquipeEtudeDAO;
EquipeViewModel m = EquipeORM.getEquipe(idEquipe); // Plus propre que d'aller chercher le métier dans la DAO.
EtudeViewModel p = new EtudeViewModel(element.idEtudeDAO, element.dateEtudeDAO, element.titreEtudeDAO, element.nbTotalEspeceRencontreeEtudeDAO, m);
l.Add(p);
}
return(l);
}
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);
}
public static ZonePrelevementViewModel getZone(int id)
{
DAOZonePrelevement daozone = DAOZonePrelevement.getZone(id);
int idEtude = daozone.idEtudeDAO;
int idPlage = daozone.idPlageDAO;
int idPersonne = daozone.idPersonneDAO;
EtudeViewModel etude = ORMEtude.getEtude(idEtude);
PlageViewModel plage = ORMPlage.getPlage(idPlage);
PersonneViewModel personne = ORMPersonne.getPersonne(idPersonne);
ZonePrelevementViewModel zone = new ZonePrelevementViewModel(daozone.idZoneDAO, etude, plage, daozone.Angle1DAO, daozone.Angle2DAO, daozone.Angle3DAO, daozone.Angle4DAO, personne);
return(zone);
}
public static EtudeHasPlageViewModel getEtudeHasPlage(int idEtude, int idPlage, int idZone)
{
EtudeHasPlageDAO eDAO = EtudeHasPlageDAO.getEtudeHasPlage(idEtude, idPlage, idZone);
int Etude_idEtude = eDAO.Etude_idEtudeDAO;
EtudeViewModel et = EtudeORM.getEtude(Etude_idEtude);
int Plage_idPlage = eDAO.Plage_idPlageDAO;
PlageViewModel p = PlageORM.getPlage(Plage_idPlage);
int Zone_idZone = eDAO.Zone_idZoneDAO;
ZoneViewModel z = ZoneORM.getZone(Zone_idZone);
EtudeHasPlageViewModel ep = new EtudeHasPlageViewModel(et, p, z, eDAO.name_concatenationDAO);
return(ep);
}
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);
}
