//Toevoegen public static int ToevoegenLocatie(Locatie locatieAdd) { using (EventBeheerEntities entities = new EventBeheerEntities()) { entities.Locatie.Add(locatieAdd); return(entities.SaveChanges()); } }
//deleten public static int DeleteEvent(Event eventitem) { using (EventBeheerEntities entities = new EventBeheerEntities()) { entities.Entry(eventitem).State = EntityState.Deleted; return(entities.SaveChanges()); } }
//toevoegen public static int AddEvent(Event eventitem) { using (EventBeheerEntities entities = new EventBeheerEntities()) { entities.Event.Add(eventitem); return(entities.SaveChanges()); } }
//Updaten public static int UpdatenLocatie(Locatie locatieUpd) { using (EventBeheerEntities entities = new EventBeheerEntities()) { entities.Entry(locatieUpd).State = EntityState.Modified; return(entities.SaveChanges()); } }
//deleten public static int DeleteToDo(ToDo todo) { using (EventBeheerEntities entities = new EventBeheerEntities()) { entities.Entry(todo).State = EntityState.Deleted; return(entities.SaveChanges()); } }
//toevoegen public static int AddToDo(ToDo todo) { using (EventBeheerEntities entities = new EventBeheerEntities()) { entities.ToDo.Add(todo); return(entities.SaveChanges()); } }
/*===================== * EventType Robbe Baeyens * =====================*/ //ophalen public static List <Eventtype> OphalenEventTypes() { using (EventBeheerEntities entities = new EventBeheerEntities()) { var query = entities.Eventtype .OrderBy(x => x.EventtypeID); return(query.ToList()); } }
/*===================== * Location (Bryan Antonis) * =====================*/ //Ophalen public static List <Locatie> OphalenLocaties() { using (EventBeheerEntities entities = new EventBeheerEntities()) { var query = entities.Locatie .OrderBy(x => x.Naam); return(query.ToList()); } }
/*===================== * TODO Andreas Steenackers * =====================*/ //ophalen public static ToDo OphalenTodo(int todoid) { using (EventBeheerEntities entities = new EventBeheerEntities()) { var query = entities.ToDo .Where(x => x.ToDoID == todoid); return(query.SingleOrDefault()); } }
//1x ophalen via ID public static Locatie OphalenLocatie(int locatieId) { using (EventBeheerEntities entities = new EventBeheerEntities()) { var query = entities.Locatie .Where(x => x.LocatieID == locatieId) .OrderBy(x => x.Naam); return(query.SingleOrDefault()); } }
/*===================== * EVENT Robbe Baeyens * =====================*/ //ophalen lijst public static List <Event> OphalenEvents() { using (EventBeheerEntities entities = new EventBeheerEntities()) { var query = entities.Event .Include(x => x.Eventtype) .OrderBy(x => x.EventID); return(query.ToList()); } }
//ophalen 1 via ID public static Event OphalenEvent(int eventId) { using (EventBeheerEntities entities = new EventBeheerEntities()) { var query = entities.Event .Include(x => x.Eventtype) .Include(x => x.ToDo) .Where(x => x.EventID == eventId); return(query.SingleOrDefault()); } }
//ophalen lijst public static List <ToDo> OphalenToDos(int eventId) { using (EventBeheerEntities entities = new EventBeheerEntities()) { var query = entities.ToDo .Include(x => x.Event) .Where(x => x.EventID == eventId) .OrderBy(x => x.Volgnr); return(query.ToList()); } }
/*===================== * TODO Robbe Baeyens * =====================*/ //ophalen lijst complete public static List <ToDo> OphalenToDosComplete(int eventId) { using (EventBeheerEntities entities = new EventBeheerEntities()) { var query = entities.ToDo .Include(x => x.Event) .Where(x => x.EventID == eventId) .Where(x => x.Afgewerkt == true) .OrderBy(x => x.ToDoID); return(query.ToList()); } }
//updaten public static int UpdateEvent(Event eventitem) { try { using (EventBeheerEntities entities = new EventBeheerEntities()) { entities.Entry(eventitem).State = EntityState.Modified; return(entities.SaveChanges()); } } catch (Exception ngex) { return(0); } }