public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
BullNote rpt = new BullNote();
rpt.Site = this.Site;
return(rpt);
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
var data = db.Notes
.Join(
db.Etudiants,
Note => Note.IdEtudiant,
Etudiant => Etudiant.IdEtudiant,
(Note, Etudiant) => new
{
IdEtudiant = Etudiant.IdEtudiant,
IdCollege = Etudiant.IdCollege,
Nom = Etudiant.Nom,
Prenom = Etudiant.Prenom,
IdMatiere = Note.IdMatiere,
NoteControle = Note.NoteControle
}
).Join(
db.Matieres,
Note => Note.IdMatiere,
Matiere => Matiere.IdMatiere,
(Note, Matiere) => new
{
IdEtudiant = Note.IdEtudiant,
IdCollege = Note.IdCollege,
Nom = Note.Nom,
Prenom = Note.Prenom,
IdMatiere = Note.IdMatiere,
NoteControle = Note.NoteControle,
libelle = Matiere.libelle
}
).Join(
db.Colleges,
Note => Note.IdCollege,
College => College.IdCollege,
(Note, College) => new
{
IdEtudiant = Note.IdEtudiant,
IdCollege = Note.IdCollege,
Nom = Note.Nom,
Prenom = Note.Prenom,
IdMatiere = Note.IdMatiere,
NoteControle = Note.NoteControle,
libelle = Note.libelle,
nomCo = College.nomCo,
AdresseSite = College.AdresseSite
}
).Where(c => c.IdEtudiant == Id).ToList();
BullNote a = new BullNote();
a.SetDataSource(data);
Crystalbul.ViewerCore.ReportSource = a;
}
