public List <taches> getTaches(mediametrieEntities bdd) { List <taches> list = (from t in bdd.taches1 select t).ToList(); return(list); }
public List <container> getContainer(mediametrieEntities bdd) { List <container> list = (from t in bdd.containers select t).ToList(); return(list); }
public int getNbTacheContainer(mediametrieEntities bdd, string nomContainer) { int nbTache = (from t in bdd.taches1 where t.label_container == nomContainer select t).Count(); return(nbTache); }
public void change_container_Day(mediametrieEntities bdd, taches laTache) { if (laTache.label_tache_parent == null) { laTache.label_container = "Tâches de la journée"; bdd.SaveChanges(); } }
public void change_container_boite_rec(mediametrieEntities bdd, taches laTache) { if (laTache.label_tache_parent == null) { laTache.label_container = "Boite de réception"; bdd.SaveChanges(); } }
public taches getSTaches(mediametrieEntities bdd, string label) { taches task = (from t in bdd.taches1 where (t.label_tache == label) select t).FirstOrDefault();; return(task); }
public List <taches> getSousTaches(mediametrieEntities bdd, string nomTache) { List <taches> list = (from t in bdd.taches1 where (t.label_tache_parent == nomTache) select t).ToList(); return(list); }
public container getSContainer(mediametrieEntities bdd, string label) { container c = (from t in bdd.containers where (t.label == label) select t).FirstOrDefault(); return(c); }
public List <taches> getTachesContainer(mediametrieEntities bdd, string nomContainer) { List <taches> list = (from t in bdd.taches1 where (t.label_container == nomContainer) select t).ToList(); return(list); }
/**************************************************************/ /* Requete Suppression */ /**************************************************************/ public void supTaches(mediametrieEntities bdd, taches laTaches) { taches s = getSTaches(bdd, laTaches.label_tache); if (s != null) { bdd.taches1.Remove(laTaches); bdd.SaveChanges(); } }
public int getNbTaskDay(mediametrieEntities bdd) { int nbTache = (from t in bdd.taches1 where t.date_debut == DateTime.Today || t.date_fin == DateTime.Today || t.date_debut <DateTime.Today && t.date_fin> DateTime.Today select t).Count(); return(nbTache); }
public CustomTreeViewItem(string title) { bdd = new mediametrieEntities(); req = new requete(); Title.Text = title; chkBox.Content = Title; Title.AddHandler(TextBlock.MouseDownEvent, new MouseButtonEventHandler(change_label)); chkBox.AddHandler(CheckBox.CheckedEvent, new RoutedEventHandler(chkBox_Checked)); Header = chkBox; }
public List <taches> getTachesDay(mediametrieEntities bdd) { List <taches> list = (from t in bdd.taches1 where t.date_debut == DateTime.Today || t.date_fin == DateTime.Today || t.date_debut <DateTime.Today && t.date_fin> DateTime.Today select t).ToList(); return(list); }
public void modifContainer(mediametrieEntities bdd, container leContainer) { /* Ajouter le changement */ container original = bdd.containers.Find(leContainer.label); if (original != null) { bdd.Entry(original).CurrentValues.SetValues(leContainer); bdd.SaveChanges(); } }
public void supContainer(mediametrieEntities bdd, container leContainer) { List <taches> l = (from t in bdd.taches1 where t.label_container == leContainer.label select t).ToList(); foreach (taches e in l) { supTaches(bdd, e); } bdd.containers.Remove(leContainer); bdd.SaveChanges(); }
public MainWindow() { InitializeComponent(); m_containers = new List <Container>(); bdd = new mediametrieEntities(); req = new requete(); checkTaskDay(); LoadDB(); comboBox.SelectedIndex = 0; remContainer.IsEnabled = true; currentIndex = 0; treeView.ItemsSource = m_containers[0].m_Tasks; }
/**************************************************************/ /* Requete d'accès */ /**************************************************************/ public bool checkTaches(mediametrieEntities bdd, string label) { bool exist; int nbTask = (from t in bdd.taches1 where (t.label_tache == label) select t).Count(); if (nbTask == 0) { exist = false; } else { exist = true; } return(exist); }
public bool checkContainer(mediametrieEntities bdd, string label) { bool exist; int nbContainer = (from t in bdd.containers where (t.label == label) select t).Count(); if (nbContainer == 0) { exist = false; } else { exist = true; } return(exist); }
/**************************************************************/ /* Requete Modification */ /**************************************************************/ public void modifTaches(mediametrieEntities bdd, taches laTaches) { /* Ajouter le changement */ taches original = bdd.taches1.Find(laTaches.label_tache); if (original != null) { bdd.Entry(original).CurrentValues.SetValues(laTaches); original.label_container = laTaches.label_container; original.label_tache = laTaches.label_tache; original.label_tache_parent = laTaches.label_tache_parent; original.date_debut = laTaches.date_debut; original.date_fin = laTaches.date_fin; original.commentaire = laTaches.commentaire; original.effectuer = laTaches.effectuer; bdd.SaveChanges(); } }
public Container() { bdd = new mediametrieEntities(); req = new requete(); this.m_Tasks = new ObservableCollection <CustomTreeViewItem>(); }
/**************************************************************/ /* Requete Ajout */ /**************************************************************/ public void ajoutTaches(mediametrieEntities bdd, taches laTaches) { bdd.taches1.Add(laTaches); bdd.SaveChanges(); }
public void ajoutContainer(mediametrieEntities bdd, container leContainer) { bdd.containers.Add(leContainer); bdd.SaveChanges(); }