//toevoegen
 public static int AddEvent(Event eventitem)
 {
     using (EventBeheerEntities entities = new EventBeheerEntities())
     {
         entities.Event.Add(eventitem);
         return(entities.SaveChanges());
     }
 }
 //deleten
 public static int DeleteEvent(Event eventitem)
 {
     using (EventBeheerEntities entities = new EventBeheerEntities())
     {
         entities.Entry(eventitem).State = EntityState.Deleted;
         return(entities.SaveChanges());
     }
 }
 //Updaten
 public static int UpdatenLocatie(Locatie locatieUpd)
 {
     using (EventBeheerEntities entities = new EventBeheerEntities())
     {
         entities.Entry(locatieUpd).State = EntityState.Modified;
         return(entities.SaveChanges());
     }
 }
 //Toevoegen
 public static int ToevoegenLocatie(Locatie locatieAdd)
 {
     using (EventBeheerEntities entities = new EventBeheerEntities())
     {
         entities.Locatie.Add(locatieAdd);
         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());
     }
 }
 //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);
     }
 }