//AUTHOR Midas public static List <EventType> GetEventTypes() { using (var entities = new ArtminEntities()) { return(entities.EventTypes .OrderBy(e => e.Name) .ToList()); } }
//AUTHOR Midas public static List <Event> GetEvents() { using (var entities = new ArtminEntities()) { return(entities.Events .OrderByDescending(e => e.Date) .Include(e => e.EventType) .ToList()); } }
//AUTHOR Kevin public static List <Artist> GetArtists(Event e) { using (var entities = new ArtminEntities()) { return(entities.Artists .Where(x => x.EventID == e.EventID) .OrderBy(x => x.Name) .ToList()); } }
//AUTHOR Dajo Vandoninck public static List <Note> GetNotes(int id) { using (var entities = new ArtminEntities()) { return(entities.Notes .OrderByDescending(e => e.creationdate) .Include(e => e.Event) .Where(e => e.Event.EventID == id) .ToList()); } }
//AUTHOR Midas public static EventDetailsVM GetEventDetails(Event e) { using (var entities = new ArtminEntities()) { return(new EventDetailsVM { NotesCount = entities.Notes.Where(n => n.EventID == e.EventID).Count(), ArtistsCount = entities.Artists.Where(a => a.EventID == e.EventID).Count() }); } }
//AUTHOR Midas public static int UpdateEvent(Event e) { try { using (var entities = new ArtminEntities()) { entities.Entry(e).State = EntityState.Modified; return(entities.SaveChanges()); } } catch (Exception ex) { FileOperations.Foutloggen(ex); return(0); } }
//AUTHOR Midas public static int AddEvent(Event e) { try { using (var entities = new ArtminEntities()) { entities.Events.Add(e); return(entities.SaveChanges()); } } catch (Exception ex) { FileOperations.Foutloggen(ex); return(0); } }
//AUTHOR Dajo Vandoninck public static int AddNote(Note n) { try { using (ArtminEntities entities = new ArtminEntities()) { entities.Notes.Add(n); return(entities.SaveChanges()); } } catch (Exception ex) { FileOperations.Foutloggen(ex); return(0); } }
//AUTHOR Dajo Vandoninck public static int AanpassenNote(Note n) { try { using (ArtminEntities entities = new ArtminEntities()) { entities.Entry(n).State = EntityState.Modified; return(entities.SaveChanges()); } } catch (Exception ex) { FileOperations.Foutloggen(ex); return(0); } }
//AUTHOR Kevin public static int DeleteArtist(Artist a) { try { using (ArtminEntities entities = new ArtminEntities()) { entities.Entry(a).State = EntityState.Deleted; return(entities.SaveChanges()); } } catch (Exception ex) { FileOperations.Foutloggen(ex); return(0); } }
//AUTHOR Midas public static int DeleteEvent(Event e) { try { using (var entities = new ArtminEntities()) { entities.Entry(e).State = EntityState.Deleted; entities.Notes.RemoveRange(entities.Notes.Where(n => n.EventID == e.EventID)); entities.Artists.RemoveRange(entities.Artists.Where(a => a.EventID == e.EventID)); return(entities.SaveChanges()); } } catch (Exception ex) { FileOperations.Foutloggen(ex); return(0); } }