public void TestAddAbsence() { //On ajoute dans un premier temps une classe pour vérifier la relation Classe/Eleve Manager.Instance.AddClasse(new Classe { NomEtablissement = "test", Niveau = "term" }); Assert.AreEqual(1, Manager.Instance.GetAllClasses().Count); Classe classe = Manager.Instance.GetAllClasses().LastOrDefault(); //On ajoute dans un premier temps un élève pour vérifier la relation Eleve/Absence Manager.Instance.AddEleve(new Eleve { Nom = "Bassinet", Prenom = "Dylan", DateNaissance = new DateTime(1999, 3, 1), ClassId = classe.ClassId }); Assert.AreEqual(1, Manager.Instance.GetAllEleves("").Count); Eleve eleve = Manager.Instance.GetAllEleves("").LastOrDefault(); Manager.Instance.AddAbsence(new Absence { DateAbsence = DateTime.Now, Motif = "Malade", EleveId = eleve.EleveId }); Assert.AreEqual(1, Manager.Instance.GetAllAbsences().Count); int nbAbsenceEleve1 = Manager.Instance.GetEleveById(eleve.EleveId).Absences.Count(); Assert.AreEqual(1, nbAbsenceEleve1); }
public ActionResult Details(int id) { BusinessManager bm = BusinessManager.GetInstance(); List <Note> notes = bm.GetNotesByEleve(id); List <NoteViewModel> notesViewModel = new List <NoteViewModel>(); foreach (Note note in notes) { notesViewModel.Add(new NoteViewModel { EleveId = note.EleveId , NoteEleve = note.NoteEleve , Appreciation = note.Appreciation , DateNote = note.DateNote , Matiere = note.Matiere , NoteId = note.NoteId }); } List <Absence> absences = bm.GetAbsenceByEleveId(id); List <AbsenceViewModel> absencesViewModels = new List <AbsenceViewModel>(); absences.ForEach(absence => { absencesViewModels.Add(new AbsenceViewModel { AbsenceId = absence.AbsenceId, DateAbsence = absence.DateAbsence, EleveId = absence.EleveId, Motif = absence.Motif }); }); Eleve eleve = bm.GetEleve(id); EleveViewModel eleveViewModel; if (notes != null && notes.Count > 0) { double moyenne = notes.Average(n => n.NoteEleve); eleveViewModel = new EleveViewModel { ClassId = eleve.ClassId, DateNaissance = eleve.DateNaissance, EleveId = eleve.EleveId, Nom = eleve.Nom, Prenom = eleve.Prenom, Moyenne = moyenne, Notes = notesViewModel }; } else { eleveViewModel = new EleveViewModel { ClassId = eleve.ClassId, DateNaissance = eleve.DateNaissance, EleveId = eleve.EleveId, Nom = eleve.Nom, Prenom = eleve.Prenom }; } if (absences != null && absences.Count > 0) { eleveViewModel.Absences = absencesViewModels; } ViewData.Model = eleveViewModel; return(View()); }
public static void AjoutEleve(string nom, string prenom, string dateDeNaissance, string sante, string telEleve, string telPere, string telMere, bool archive, bool tiersTemps, Classe uneClasse) { Eleve el; el = new Eleve(nom, prenom, dateDeNaissance, sante, telEleve, telPere, telMere, archive, tiersTemps, uneClasse); EleveDAO.AjoutEleve(el); }
//Cette méthode modfie un élève dans la BD public static void ModifieEleve(Eleve unEleve) { int tiersTemps = 0; // Connexion à la BD SqlConnection maConnexion = ConnexionBDD.GetConnexionBD().GetSqlConnexion(); if (unEleve.unTiers_Temps == true) { tiersTemps = 1; } else { tiersTemps = 0; } SqlCommand cmd = new SqlCommand(); cmd.Connection = maConnexion; cmd.CommandText = "UPDATE Eleve SET Nom_eleve='" + unEleve.unNom_eleve.Replace("'", "''") + "', Prenom_eleve='" + unEleve.unPrenom_eleve.Replace("'", "''") + "', DateNaissance_eleve='" + unEleve.uneDateNaissance_eleve + "',TiersTemps_eleve=" + tiersTemps + ", Sante_eleve='" + unEleve.uneSante_eleve.Replace("'", "''") + "', Tel_eleve='" + unEleve.unTel_eleve + "',TelPere_eleve='" + unEleve.unTel_Pere_eleve + "',TelMere_eleve='" + unEleve.unTel_Mere_eleve + "', Id_classe=" + unEleve.UneClasse.unId_classe + " Where Id_eleve=" + unEleve.unId_eleve + ";"; cmd.ExecuteNonQuery(); // Fermeture de la connexion maConnexion.Close(); }
public async Task <IActionResult> UpdateEleve([FromBody] long id, EleveCreateDto eleveCreateDto) { if (eleveCreateDto.name == null) { return(BadRequest()); } Eleve eleve = await _eleveRepository.GetById(id); if (eleve == null) { return(NotFound()); } eleve.Name = eleveCreateDto.name; var res = await _eleveRepository.SaveAsync(); if (!res) { return(BadRequest()); } return(Ok()); }
/// <summary> /// Ajouter un élève en base /// </summary> /// <param name="e">Eleve à ajouter</param> /// <returns>identifiant du nouvel élève</returns> public int AjouterEleve(Eleve e) { // TODO : ajouter des contrôles sur l'élève (exemple : vérification de champ, etc.) EleveCommand ec = new EleveCommand(contexte); return(ec.Ajouter(e)); }
/// <summary> /// Converti une entité <see cref="Eleve"/> en ViewModel <see cref="EleveViewModel"/> /// </summary> /// <param name="note">Entité <see cref="Eleve"/></param> /// <returns>Objet ViewModel <see cref="EleveViewModel"/></returns> public EleveViewModel ConvertToViewModel(Eleve eleve) { AbsenceAdapter absenceAdapter = new AbsenceAdapter(); NoteAdapter noteAdapter = new NoteAdapter(); if (eleve == null) { return(null); } var vm = new EleveViewModel { EleveId = eleve.EleveId, Nom = eleve.Nom, Prenom = eleve.Prenom, DateNaissance = eleve.DateNaissance, ClassId = eleve.ClassId, Absences = absenceAdapter.ConvertToViewModels(eleve.Absences.ToList()), Notes = noteAdapter.ConvertToViewModels(eleve.Notes.ToList()) }; if (vm.Notes != null) { vm.Moyenne = vm.Notes.Average(n => n.ValeurNote); } return(vm); }
public static int ModifierEleve(int id, string nom, string prenom, DateTime naissance, string sante, int telEleve, int telParent, bool archive, bool tierstemps, bool visite) { Eleve el; el = new Eleve(id, nom, prenom, naissance, sante, telEleve, telParent, archive, tierstemps, visite); return(InfirmerieDAO.UpdateEleve(el)); }
public bool supprimerEleve(int id, string nom, string prenom, DateTime naissance, string sante, int telEleve, int telParent, bool archive, bool tierstemps, bool visite, int classe) { Eleve unEleve; unEleve = new Eleve(id, nom, prenom, naissance, sante, telEleve, telParent, archive, tierstemps, visite, classe); return(InfirmerieDAO.supprimerEleve(unEleve)); }
public async Task <Professeur> Create(Professeur professeur) { Professeur p = new Professeur { Id = 4, Nom = "Luzolo", Postnom = "Lusembo", Prenom = "Plamedi", Email = "*****@*****.**", TitreFormation = "Informaticien" }; Eleve e = new Eleve { Id = 45, Nom = "Luzolo", Postnom = "Matanu", Prenom = "Hervé", Email = "*****@*****.**", AnneeScolaire = "4e SC" }; Utilisateur u = new Utilisateur { NomUtilisateur = "*****@*****.**", MotDePasse = "jkhfdb", MembreId = p.Id, Discriminator = 'P' }; Context.Set <Utilisateur>().Add(u); Context.Set <Professeur>().Add(p); await Context.SaveChangesAsync(); return(professeur); }
// Méthode qui créer un nouvel élève à partir de ses attributs et qui le renvoie en l'ajoutant à la BD avec la méthode AjoutEleve de la DAL public static int CreerEleve(string nom, string prenom, DateTime naissance, string sante, int telEleve, int telParent, bool archive, bool tierstemps, bool visite, int classe) { Eleve el; el = new Eleve(nom, prenom, naissance, sante, telEleve, telParent, archive, tierstemps, visite, classe); return(InfirmerieDAO.AjoutEleve(el)); }
/// <summary> /// Retourne l'élève correspondant à l'identifiant /// </summary> /// <param name="id">Identifiant de l'élève</param> /// <returns>Entité <see cref="Eleve"/></returns> public Eleve GetEleveById(int id) { EleveQuery query = new EleveQuery(monContexte); Eleve result = query.GetById(id); return(result); }
public EleveVM(Eleve eleve) { this.Id = eleve.Id; this.Nom = eleve.Nom; this.Prenom = eleve.Prenom; this.DateDeNaissance = eleve.DateDeNaissance; this.ClasseId = eleve.ClasseId; this.Moyenne = eleve.Moyenne; this.Notes = new ObservableCollection <NoteVM>(); this.Absences = new ObservableCollection <AbsenceVM>(); if (eleve.Notes != null) { foreach (Note n in eleve.Notes) { this.Notes.Add(new NoteVM(n)); } } if (eleve.Absences != null) { foreach (Absence a in eleve.Absences) { this.Absences.Add(new AbsenceVM(a)); } } }
private void Save() { List <Note> notesTmp = new List <Note>(); List <Absence> absencesTmp = new List <Absence>(); foreach (NoteVM noteVM in Notes) { Note n = new Note() { Appreciation = noteVM.Appreciation, DateNote = noteVM.DateNote, EleveId = noteVM.EleveId, Matiere = noteVM.Matiere, Valeur = noteVM.Valeur }; notesTmp.Add(n); } foreach (AbsenceVM absenceVM in Absences) { Absence a = new Absence() { DateAbsence = absenceVM.DateAbsence, EleveId = absenceVM.EleveId, Motif = absenceVM.Motif }; absencesTmp.Add(a); } Eleve e = new Eleve() { Absences = absencesTmp, Notes = notesTmp, ClasseId = this.ClasseId, DateDeNaissance = this.DateDeNaissance, Moyenne = this.Moyenne, Nom = this.Nom, Prenom = this.Prenom, Id = this.Id }; Manager.Instance.ModifyEleve(e); }
public static void AjoutEleve(BusinessManager bm) { Eleve e = new Eleve { Nom = "YouThere", Prenom = "Hey", ClassId = 1, DateNaissance = DateTime.Now }; bm.AddEleve(e); Eleve e1 = new Eleve { Nom = "UnAutre", Prenom = "Eleve", ClassId = 1, DateNaissance = DateTime.Now }; bm.AddEleve(e1); Eleve e2 = new Eleve { Nom = "Rouana", Prenom = "Marie", ClassId = 2, DateNaissance = DateTime.Now }; bm.AddEleve(e2); Eleve e3 = new Eleve { Nom = "Terieur", Prenom = "Alain", ClassId = 2, DateNaissance = DateTime.Now }; bm.AddEleve(e3); Eleve e4 = new Eleve { Nom = "Terieur", Prenom = "Alex", ClassId = 1, DateNaissance = DateTime.Now }; bm.AddEleve(e4); }
public FrmModuleModifierEleve(int idEleve) { InitializeComponent(); // Récupération de chaîne de connexion à la BD à l'ouverture du formulaire GestionUtilisateurs.SetchaineConnexion(ConfigurationManager.ConnectionStrings["GestionInfirmerie"]); Eleve unEleve = GestionInfirmerieBLL.GestionEleves.InfoEleve(idEleve); txtBoxNom.Text = unEleve.unNom_eleve; lblIdEleve.Text = idEleve.ToString(); txtBoxPrenom.Text = unEleve.unPrenom_eleve; comboBoxClasse.Text = unEleve.UneClasse.unLibelle_classe; richTextBoxSante.Text = unEleve.uneSante_eleve; telEleve.Text = unEleve.unTel_eleve; telMere.Text = unEleve.unTel_Mere_eleve; telPere.Text = unEleve.unTel_Pere_eleve; monthCalendarDateNaiMod.SelectionStart = Convert.ToDateTime(unEleve.uneDateNaissance_eleve); monthCalendarDateNaiMod.SelectionEnd = Convert.ToDateTime(unEleve.uneDateNaissance_eleve); //condition Tiers Temps if (unEleve.unTiers_Temps == true) { radioBoxTTOuiMod.Checked = true; } else { radioBoxTTNonMod.Checked = true; } }
public JsonResult Create(Eleve eleve) { eleveCommand.Ajouter(eleve); return(Json(null)); }
private void buttonModifMod_Click(object sender, EventArgs e) { if (ValidateChildren(ValidationConstraints.Enabled)) { System.DateTime dt; System.DateTime dateNaissance = this.monthCalendarDateNaiMod.SelectionStart.Date; dt = dateNaissance; string date = dt.ToString("yyyy-MM-dd"); bool tieTem = false; if (radioBoxTTOuiMod.Checked == true) { tieTem = true; } else if (radioBoxTTNonMod.Checked == true) { tieTem = false; } int idClasse = Convert.ToInt32(comboBoxClasse.SelectedValue); Classe uneClasse; uneClasse = new Classe(idClasse); Eleve unEleve = new Eleve(Int32.Parse(lblIdEleve.Text), txtBoxNom.Text, txtBoxPrenom.Text, date, richTextBoxSante.Text, telEleve.Text, telPere.Text, telMere.Text, false, tieTem, uneClasse); GestionEleves.ModifieEleve(unEleve); FrmModuleListeEleve frm = new FrmModuleListeEleve(); frm.Show(); this.Hide(); MessageBox.Show("Votre élève a bien été modifié !"); } }
/// <summary> /// Modifier un élève en base /// </summary> /// <param name="e">Eleve à modifier</param> public void ModifierEleve(Eleve e) { // TODO : ajouter des contrôles sur l'élève (exemple : vérification de champ, etc.) EleveCommand ec = new EleveCommand(contexte); ec.Modifier(e); }
static void Main(string[] args) { try { Contexte contexte = new Contexte(); contexte.Classes.ToList(); contexte.Eleves.ToList(); contexte.Notes.ToList(); contexte.Absences.ToList(); Classe classe1 = new Classe { NomEtablissement = "Etablissement 1", Niveau = "Seconde" }; Classe classe2 = new Classe { NomEtablissement = "Etablissement 1", Niveau = "Terminal" }; contexte.Classes.Add(classe1); contexte.Classes.Add(classe2); contexte.SaveChanges(); Eleve eleve1 = new Eleve { Nom = "FAGUE", Prenom = "Thibault", DateNaissance = new DateTime(1999, 6, 3), ClasseId = classe1.ClasseId }; Eleve eleve2 = new Eleve { Nom = "BASSINET", Prenom = "Dylan", DateNaissance = new DateTime(1998, 10, 4), ClasseId = classe1.ClasseId }; Eleve eleve3 = new Eleve { Nom = "BUISSON", Prenom = "Yoann", DateNaissance = new DateTime(1999, 8, 10), ClasseId = classe2.ClasseId }; contexte.Eleves.Add(eleve1); contexte.Eleves.Add(eleve2); contexte.Eleves.Add(eleve3); contexte.SaveChanges(); contexte.Notes.Add(new Note { Matiere = "Mathématiques", Appreciation = "Bon travail", Valeur = 15, DateNote = new DateTime(2019, 8, 6), EleveId = eleve1.EleveId }); contexte.Notes.Add(new Note { Matiere = "Français", Appreciation = "Moyen", Valeur = 9, DateNote = new DateTime(2020, 7, 10), EleveId = eleve1.EleveId }); contexte.Notes.Add(new Note { Matiere = "Mathématiques", Appreciation = "Assez mauvais", Valeur = 7, DateNote = new DateTime(2019, 10, 1), EleveId = eleve2.EleveId }); contexte.SaveChanges(); contexte.Absences.Add(new Absence { Motif = "Malade", DateAbsence = new DateTime(2019, 6, 11), EleveId = eleve1.EleveId }); contexte.Absences.Add(new Absence { Motif = "Malade", DateAbsence = new DateTime(2020, 7, 1), EleveId = eleve1.EleveId }); contexte.Absences.Add(new Absence { Motif = "Malade", DateAbsence = new DateTime(2019, 9, 6), EleveId = eleve3.EleveId }); contexte.SaveChanges(); } catch (Exception) { } }
/// <summary> /// Converti un Objet ViewModel <see cref="EleveViewModel"/> en entité <see cref="Eleve"/> /// </summary> /// <param name="entity">Entité <see cref="Eleve"/></param> /// <param name="vm">Objet ViewModel <see cref="EleveViewModel"/></param> public void ConvertToEntity(Eleve entity, EleveViewModel vm) { entity.Nom = vm.Nom; entity.Prenom = vm.Prenom; entity.DateNaissance = vm.DateNaissance; entity.ClassId = vm.ClassId; }
public async Task <IActionResult> PutEleve(string id, Eleve eleve) { if (id != eleve.Cin_Eleve) { return(BadRequest()); } _context.Entry(eleve).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!EleveExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> CreateEleve([FromBody] long ecoleId, EleveCreateDto eleveCreateDto) { if (eleveCreateDto.name == null) { return(BadRequest()); } Ecole ecole = await _ecoleRepository.GetById(ecoleId); if (ecole == null) { return(NotFound()); } Eleve eleve = eleve.From(eleveCreateDto); eleve.Ecole = ecole; await _eleveRepository.CreateEntity(eleve); var res = await _ecoleRepository.SaveAsync(); if (!res) { return(BadRequest()); } return(Created("professeur/me", eleve)); }
public async Task <ActionResult <Eleve> > PostEleve(Eleve eleve) { _context.Eleve.Add(eleve); await _context.SaveChangesAsync(); return(CreatedAtAction("GetEleve", new { id = eleve.Cin_Eleve }, eleve)); }
public IActionResult Create(int idclasse, int idecole, Eleve model) { if (ModelState.IsValid) { db.Add(model); db.SaveChanges(); } if (ModelState.IsValid) { var mod = new Inscription { ClasseID = idclasse, AnneeScolaire = DateTime.Now, EleveID = model.EleveID }; db.Add(mod); db.SaveChanges(); return(RedirectToAction("Detail", "Classe", new { id = idclasse })); } Ecole mode = db.Ecoles.Include(c => c.Classes).AsNoTracking().FirstOrDefault(e => e.EcoleID == idecole); ViewData["cl"] = new SelectList(mode.Classes, "ClasseID", "Nomcomplet"); ViewData["PrefetID"] = db.Ecoles.Find(idecole).PrefetID; return(View(model)); }
public IHttpActionResult AddEleve(Eleve _Eleve) { DateTime?_DtNaissanceF = null; if (!String.IsNullOrEmpty(_Eleve.DtNaissance)) { _DtNaissanceF = DateTime.Parse(_Eleve.DtNaissance); } return(Ok(ElevesManager.AddEleve( _Nom: _Eleve.Nom, _Prenom: _Eleve.Prenom, _Email: _Eleve.Email, _Password: _Eleve.Password, _DtNaissance: _Eleve.DtNaissance, _Sexe: _Eleve.Sexe, _Club: _Eleve.Club, _Photo: _Eleve.Photo, _Fixe: _Eleve.Fixe, _Portable: _Eleve.Portable, _Commentaire: _Eleve.Commentaire, _License: _Eleve.License, _Classement: _Eleve.Classement, _Suivi: _Eleve.Suivi ))); }
/// <summary> /// Modifie ou crée une absence /// </summary> /// <param name="vm">Objet ViewModel <see cref="AbsenceViewModel"/></param> /// <returns></returns> public ActionResult EditAbsence(AbsenceViewModel vm) { if (!ModelState.IsValid) { return(View("EditAbsence", vm)); } AbsenceAdapter absenceAdapter = new AbsenceAdapter(); EleveAdapter eleveAdapter = new EleveAdapter(); if (vm.AbsenceId == 0) //Création { Absence absence = new Absence(); absenceAdapter.ConvertToEntity(absence, vm); Manager.Instance.AddAbsence(absence); } else //Modification { Absence absence = Manager.Instance.GetAbsenceById(vm.AbsenceId); absenceAdapter.ConvertToEntity(absence, vm); Manager.Instance.EditAbsence(absence); } Eleve eleve = Manager.Instance.GetEleveById(vm.EleveId); EleveViewModel eleveVM = eleveAdapter.ConvertToViewModel(eleve); return(RedirectToAction("DetailEleve", "Eleve", new { eleveId = vm.EleveId })); }
public FrmDetailsEleve(int idEleve) { InitializeComponent(); // Récupération de chaîne de connexion à la BD à l'ouverture du formulaire GestionEleves.SetchaineConnexion(ConfigurationManager.ConnectionStrings["GestionInfirmerie"]); Eleve unEleve = GestionInfirmerieBLL.GestionEleves.InfoEleve(idEleve); DateTime Date = Convert.ToDateTime(unEleve.uneDateNaissance_eleve); string uneDate = Date.ToString("d"); TimeSpan span = DateTime.Now.Subtract(Date); if (unEleve.unTiers_Temps == true) { radioOuiTT.Checked = true; } else { radioNonTT.Checked = true; } lblAgeEleve.Text = "Age : " + span.Days / 365; lblDateNaissance.Text = "Date de naissance : " + uneDate; lblSante.Text = "Sante : " + unEleve.uneSante_eleve; lblNomEleve.Text = "Nom : " + unEleve.unNom_eleve + " " + unEleve.unPrenom_eleve; lblTelEleve.Text = "Tel élève : " + unEleve.unTel_eleve; lblTelMere.Text = "Tel mère : " + unEleve.unTel_Mere_eleve; lblNumPere.Text = "Tel père : " + unEleve.unTel_Pere_eleve; lblClasseEleve.Text = "Classe : " + unEleve.UneClasse.unLibelle_classe; lblIdEleve.Text = idEleve.ToString(); }
private void saveBtn_Click(object sender, EventArgs e) { #region Création de la liste pour récupérer les élèves List <Eleve> liste = new List <Eleve>(); liste = GestionEleve.GetEleves(); #endregion string dateNaissance = dateTimePicker1.Text; DateTime laDateNaissance = DateTime.Parse(dateNaissance); string telEleve = telEleve_txt.Text; int leTelEleve = int.Parse(telEleve); string telParent = telParent_txt.Text; int leTelParent = int.Parse(telParent); int id_classe = lblClasse_cmbx.SelectedIndex + 1; //int id_eleve = (int)nomElv_cmbx.SelectedValue; Eleve unEleve = new Eleve(id_eleve, nomElv_cmbx.Text, prenomEleve_txt.Text, laDateNaissance, leTelEleve, leTelParent, bool.Parse(tierTemps_txt.Text), commentSante_text.Text, id_classe, false); GestionEleve.ModifierEleve(unEleve); MessageBox.Show("idElv = " + id_eleve + ", nom eleve = " + nomElv_cmbx.Text + ", prenom = " + prenomEleve_txt.Text + ", date naissance : " + laDateNaissance + ", tel eleve =" + leTelEleve + ", tel Parent " + leTelParent + ", Tiers temps = " + tierTemps_txt.Text + ", Commentaire santé = " + commentSante_text.Text + ", index Classe = " + lblClasse_cmbx.SelectedIndex.ToString() + ""); }
public void TestEditNote() { Manager.Instance.AddClasse(new Classe { Niveau = "DUT", NomEtablissement = "uca" }); Classe classe = Manager.Instance.GetAllClasses().LastOrDefault(); Assert.AreEqual("DUT", classe.Niveau); Assert.AreEqual("uca", classe.NomEtablissement); Manager.Instance.AddEleve(new Eleve { Nom = "Kolac", Prenom = "Jean", DateNaissance = DateTime.Now.Date, ClassId = classe.ClassId }); Eleve eleve = Manager.Instance.GetAllEleves("").LastOrDefault(); Assert.AreEqual("Kolac", eleve.Nom); Assert.AreEqual("Jean", eleve.Prenom); Manager.Instance.AddNote(new Note { Matiere = "Histoire", ValeurNote = 12, Appreciation = "à améliorer", DateNote = DateTime.Now.Date, EleveId = eleve.EleveId }); Note note = Manager.Instance.GetAllNotes().LastOrDefault(); Assert.AreEqual("à améliorer", note.Appreciation); Assert.AreEqual(12, note.ValeurNote); //Modification note note.ValeurNote = 18; note.Appreciation = "très bien"; Manager.Instance.EditNote(note); Note expectedNote = Manager.Instance.GetNoteById(note.NoteId); Assert.AreEqual(expectedNote.ValeurNote, note.ValeurNote); Assert.AreEqual(expectedNote.Appreciation, note.Appreciation); }