public static PrelevementViewModel getPrelevement(int idprelevement)
{
PrelevementDAO pDAO = PrelevementDAO.getPrelevement(idprelevement);
// int idMetier = pDAO.idMetierPrelevementDAO;
PrelevementViewModel p = new PrelevementViewModel(pDAO.idprelevementDAO, pDAO.PositionGPSDAO, pDAO.TypeDAO);
return(p);
}
public static ObservableCollection <PrelevementViewModel> listePrelevements()
{
ObservableCollection <PrelevementDAO> lDAO = PrelevementDAO.listePrelevements();
ObservableCollection <PrelevementViewModel> l = new ObservableCollection <PrelevementViewModel>();
foreach (PrelevementDAO element in lDAO)
{
// int idMetier = element.idMetierPrelevementDAO;
PrelevementViewModel p = new PrelevementViewModel(element.idprelevementDAO, element.PositionGPSDAO, element.TypeDAO);
l.Add(p);
}
return(l);
}
public static ObservableCollection <PlageViewModel> listePlages()
{
ObservableCollection <PlageDAO> lDAO = PlageDAO.listePlages();
ObservableCollection <PlageViewModel> l = new ObservableCollection <PlageViewModel>();
foreach (PlageDAO element in lDAO)
{
int idPrelevement = element.prelevement_idprelevementDAO;
int idVille = element.Ville_idVilleDAO;
int iDepartement = element.Departement_idDepartementDAO;
PrelevementDAO m = PrelevementDAO.getPrelevement(idPrelevement);
CommuneDAO c = CommuneDAO.getCommune(idVille);
DepartementDAO d = DepartementDAO.getDepartement(iDepartement);
PrelevementViewModel prelevement = new PrelevementViewModel(m.idprelevementDAO, m.PositionGPSDAO, m.TypeDAO);
CommuneViewModel commune = new CommuneViewModel(c.idVilleDAO, c.nomSpecialisteDAO, c.nomVilleDAO);
DepartementViewModel departement = new DepartementViewModel(d.idDepartementDAO, d.nomDAO);
PlageViewModel p = new PlageViewModel(element.idPlageDAO, element.nomDAO, commune, prelevement, departement);
l.Add(p);
}
return(l);
}
public static void insertPrelevement(PrelevementViewModel p)
{
PrelevementDAO.insertPrelevement(new PrelevementDAO(p.idprelevementProperty, p.PositionGPSProperty, p.TypeProperty));
}
public static void supprimerPrelevement(int id)
{
PrelevementDAO.supprimerPrelevement(id);
}
