1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
| public ObservableCollection<MoiCalendrier> MesMois = new ObservableCollection<MoiCalendrier>();
public ObservableCollection<MoiCalendrier> MaListeDeMois
{
get
{
return MesMois;
}
}
public void LoadData(string rdr, DateTime debut, DateTime fin)
{
monPlanning = Societe.Relance.Client.ModelControl.PlanningService.GetMiniPlanning(rdr, debut, fin);
var req =
from tb2 in
(
from tb in monPlanning
orderby ((MiniPlanning)tb).Echeance
select new {Annee = ((MiniPlanning)tb).Echeance.Year, Moi =((MiniPlanning)tb).Echeance.Month }
).Distinct()
select tb2;
foreach (var date in req)
{
var req2 =
from tb2 in
(
from tb in monPlanning
where
((MiniPlanning)tb).Echeance.Month == date.Moi &&
((MiniPlanning)tb).Echeance.Year == date.Annee
orderby ((MiniPlanning)tb).Echeance
select ((MiniPlanning)tb).Echeance
).Distinct()
select tb2;
ObservableCollection<JourCalendier> MesJours = new ObservableCollection<JourCalendier>();
foreach (DateTime jour in req2)
{
var req3 =
from tb in monPlanning
where
((MiniPlanning)tb).Echeance == jour
orderby ((MiniPlanning)tb).Echeance
select new TacheCalendier
{
Bureau = ((MiniPlanning)tb).Bureau,
EC = ((MiniPlanning)tb).EC,
ECPseudo = ((MiniPlanning)tb).ECPseudo,
Genre = ((MiniPlanning)tb).Nom,
IdGenre = ((MiniPlanning)tb).Genre,
Nb = ((MiniPlanning)tb).Nb,
SocRegion = ((MiniPlanning)tb).SocRegion
};
MesJours.Add(new JourCalendier { Jour = jour, Taches = req3.ToList() });
}
MesMois.Add(new MoiCalendrier { Moi = date.Moi, Annee = date.Annee, Jours = MesJours });
}
}
}
public class MoiCalendrier
{
static private List<string> ListeMois =
new List<string>() {
"janvier",
"février",
"mars",
"avril",
"mai",
"juin",
"juillet",
"août",
"septembre",
"octobre",
"novembre",
"décembre"};
private int moi;
public int Moi
{
get { return moi; }
set { moi = value; }
}
private int annee;
public int Annee
{
get { return annee; }
set { annee = value; }
}
public string TexteMoi
{
get { return ListeMois[moi - 1];}
}
public ObservableCollection<JourCalendier> Jours = new ObservableCollection<JourCalendier>();
public ObservableCollection<JourCalendier> MesJours
{
get { return Jours; }
}
}
public class JourCalendier
{
DateTime jour;
public DateTime Jour
{
get { return jour; }
set { jour = value; }
}
public string TexteJour
{
get { return jour.Day.ToString(); }
}
public List<TacheCalendier> Taches = new List<TacheCalendier>();
public List<TacheCalendier> MesTaches
{
get { return Taches; }
}
}
public class TacheCalendier
{
private string bureau;
public string Bureau
{
get { return bureau; }
set { bureau = value; }
}
private string eCPseudo;
public string ECPseudo
{
get { return eCPseudo; }
set { eCPseudo = value; }
}
private string eC;
public string EC
{
get { return eC; }
set { eC = value; }
}
private int idGenre;
public int IdGenre
{
get { return idGenre; }
set { idGenre = value; }
}
private string socRegion;
public string SocRegion
{
get { return socRegion; }
set { socRegion = value; }
}
private int nb;
public int Nb
{
get { return nb; }
set { nb = value; }
}
private string genre;
public string Genre
{
get { return genre; }
set { genre = value; }
}
public override string ToString()
{
return "Tache : " + genre;
}
} |
WPF - Liste de taches par mois et regroupé par jours
Répondre avec citation
Partager