public override Guid AjouterTagForChapitre(Guid idChapitre, string libelleTexte) { Guid id = Guid.NewGuid(); using (SQLCompactContext context = GetContext()) { // TODO : Deplacer ce test dans la couche Model if (!context.Tag.Any(toc => toc.FK_ID_Chapitre == idChapitre && toc.Libelle == libelleTexte)) { Tag newTag = new Tag { ID_Tag = id, Libelle = libelleTexte, FK_ID_Chapitre = idChapitre, FK_ID_Media = null }; context.Tag.AddObject(newTag); context.SaveChanges(); return(id); } } return(Guid.Empty); }
public override Guid AjouterSignet(Guid idMedia, string libelleTexte, string duree) { Guid idSignet = Guid.NewGuid(); using (SQLCompactContext context = GetContext()) { if (!context.Signet.Any(s => s.FK_ID_Media == idMedia && s.Libelle == libelleTexte && s.Duree == duree)) { Signet newSignet = new Signet { ID_Signet = idSignet, Libelle = libelleTexte, Duree = duree, FK_ID_Media = idMedia }; context.Signet.AddObject(newSignet); context.SaveChanges(); return(idSignet); } } return(Guid.Empty); }
public override Guid AjouterTagForMedia(Guid idMedia, string libelleTexte) { Guid idTag = Guid.NewGuid(); using (SQLCompactContext context = GetContext()) { if (!context.Tag.Any(tom => tom.FK_ID_Chapitre == idMedia && tom.Libelle == libelleTexte)) { Tag newTag = new Tag { ID_Tag = idTag, Libelle = libelleTexte, FK_ID_Chapitre = null, FK_ID_Media = idMedia }; context.Tag.AddObject(newTag); context.SaveChanges(); return(idTag); } } return(Guid.Empty); }
public override Guid AjouterChapitre(Guid idMedia, string description, string debut, string fin) { Guid idChapitre = Guid.NewGuid(); using (SQLCompactContext context = GetContext()) { // TODO : Deporter ce test dans la couche Models if (!context.Chapitre.Any(c => c.Debut == debut && c.Fin == fin && c.Description == description)) { Chapitre newChapitre = new Chapitre { ID_Chapitre = idChapitre, Debut = debut, Fin = fin, Description = description, FK_ID_Media = idMedia }; context.Chapitre.AddObject(newChapitre); context.SaveChanges(); return(idChapitre); } } return(Guid.Empty); }
public override void SupprimerDossier(Guid idDossier) { using (SQLCompactContext context = GetContext()) { var dossierForDelete = context.Dossier.SingleOrDefault(d => d.ID_Dossier == idDossier); if (dossierForDelete != null) { context.Dossier.DeleteObject(dossierForDelete); context.SaveChanges(); } } }
public override void SupprimerSignet(Guid idSignet) { using (SQLCompactContext context = GetContext()) { var signetForDelete = context.Signet.SingleOrDefault(s => s.ID_Signet == idSignet); if (signetForDelete != null) { context.Signet.DeleteObject(signetForDelete); context.SaveChanges(); } } }
public override void SupprimerTag(Guid idTag) { using (SQLCompactContext context = GetContext()) { Tag tagForDelete = context.Tag.SingleOrDefault(t => t.ID_Tag == idTag); if (tagForDelete != null) { context.Tag.DeleteObject(tagForDelete); context.SaveChanges(); } } }
public override void SupprimerChapitre(Guid idChapitre) { using (SQLCompactContext context = GetContext()) { var chapitreForDelete = context.Chapitre.SingleOrDefault(s => s.ID_Chapitre == idChapitre); if (chapitreForDelete != null) { context.Chapitre.DeleteObject(chapitreForDelete); context.SaveChanges(); } } }
public override void SupprimerMedia(Guid idMedia) { using (SQLCompactContext context = GetContext()) { var mediaForDelete = context.Media.SingleOrDefault(m => m.ID_Media == idMedia); if (mediaForDelete != null) { context.Media.DeleteObject(mediaForDelete); context.SaveChanges(); } } }
public override void ModifierDossier(Guid idDossier, string nom, string chemin) { using (SQLCompactContext context = GetContext()) { var dossier = context.Dossier.SingleOrDefault(d => d.ID_Dossier == idDossier); if (dossier != null) { dossier.Nom = nom; dossier.Chemin = chemin; context.SaveChanges(); } } }
public override void ModifierMedia(Guid idMedia, string nom, string relativeURL, Guid idDossier) { using (SQLCompactContext context = GetContext()) { var media = context.Media.SingleOrDefault(m => m.ID_Media == idMedia); if (media != null) { media.Nom = nom; media.RelativeURL = relativeURL; media.FK_ID_Dossier = idDossier; context.SaveChanges(); } } }
public override Guid AjouterDossier(string nom, string chemin) { Guid id = Guid.NewGuid(); using (SQLCompactContext context = GetContext()) { Dossier newDossier = new Dossier { ID_Dossier = id, Nom = nom, Chemin = chemin }; context.Dossier.AddObject(newDossier); context.SaveChanges(); } return(id); }
public override Guid AjouterMedia(string nom, string relativeURL, Guid idDossier) { Guid id = Guid.NewGuid(); using (SQLCompactContext context = GetContext()) { Media newMedia = new Media { ID_Media = id, Nom = nom, RelativeURL = relativeURL, FK_ID_Dossier = idDossier }; context.Media.AddObject(newMedia); context.SaveChanges(); } return(id); }