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();
}