//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);
}
}
