private void ImportPresence(string filename)
        {
            var log = LogManager.GetLog(GetType());
            var importTime = DateTime.Now;

            log.Info("Start administration import ({0}) : {1}.{2:D3}", filename, importTime, importTime.Millisecond);

            using (var db = new PetoeterDb(PetoeterDb.FileName))
            {
                using (var import = new PetoeterDb(filename))
                {
                    var presences = import.GetCollection<Presence>(PetoeterDb.TablePresence).FindAll().ToList();
                    log.Info("Import presences (#{0})", presences.Count);

                    foreach (var presence in presences)
                    {
                        log.Info("Import presence: {0}. [{1}] {2})", presence.Id, presence.Date.ToShortDateString(), presence.Child.GetFullName());
                        presence.Updated = importTime;
                        db.Presences.Insert(presence);
                    }

                    import.DropAll();
                }
            }
        }
        private void ImportAdministration(string filename)
        {
            var log = LogManager.GetLog(GetType());
            var importTime = DateTime.Now;

            log.Info("Start administration import ({0}) : {1}.{2:D3}", filename, importTime, importTime.Millisecond);

            using (var db = new PetoeterDb(PetoeterDb.FileName))
            {
                using (var import = new PetoeterDb(filename))
                {
                    if (import.Children.Count() != 0)
                    {
                        var children = (from c in import.Children.FindAll() select c).ToList();
                        log.Info("Import children (#{0})", children.Count);

                        foreach (var child in children)
                        {
                            var update_child = db.Children.FindById(child.Id);

                            if (update_child == null)
                            {
                                log.Info("Import child: {0}. {1}", child.Id, child.GetFullName());
                                child.Updated = importTime;
                                db.Children.Insert(child);
                            }
                            else
                            {
                                log.Info("Update child: {0}. {1}", child.Id, child.GetFullName());
                                child.Updated = importTime;
                                db.Children.Update(child);
                            }

                            if (string.IsNullOrEmpty(child.FileId) == false)
                            {
                                var file = import.FileStorage.FindById(child.FileId);
                                if (file != null)
                                {
                                    if (db.FileStorage.Exists(child.FileId))
                                    {
                                        log.Info("Update child: remove picture");
                                        db.FileStorage.Delete(child.FileId);
                                    }
                                    log.Info("Update child: upload picture");
                                    db.FileStorage.Upload(child.FileId, file.OpenRead());
                                }
                            }
                        }
                    }

                    if (import.Members.Count() != 0)
                    {
                        var members = (from m in import.Members.FindAll() select m).ToList();
                        log.Info("Import members (#{0})", members.Count);

                        foreach (var member in members)
                        {
                            var update_member = db.Members.FindById(member.Id);

                            if (update_member == null)
                            {
                                log.Info("Import member: {0}. {1}", member.Id, member.GetFullName());
                                member.Updated = importTime;
                                db.Members.Insert(member);
                            }
                            else
                            {
                                log.Info("Update member: {0}. {1}", member.Id, member.GetFullName());
                                member.Updated = importTime;
                                db.Members.Update(member);
                            }
                        }
                    }

                    if (import.Accounts.Count() != 0)
                    {
                        //var accounts = (from a in import.Accounts.FindAll() select a).ToList();
                        var accounts = (from a in import.GetCollection<Account>(PetoeterDb.TableAccount).FindAll() select a).ToList();

                        log.Info("Import accounts (#{0})", accounts.Count);

                        foreach (var account in accounts)
                        {
                            //	check if account exist
                            var updateaccount = db.Accounts.FindById(account.Id);

                            if (updateaccount == null)
                            {
                                log.Info("Import account: #{0}. {1}", account.Id, account.Name);
                                account.Updated = importTime;
                                db.Accounts.Insert(account);
                            }
                            else
                            {
                                log.Info("Update account: #{0}. {1}", account.Id, account.Name);
                                account.Updated = importTime;
                                db.Accounts.Update(account);
                            }
                        }
                    }

                    if (import.Holidays.Count() != 0)
                    {
                        var holidays = (from h in import.Holidays.FindAll() select h).ToList();

                        log.Info("Import holidays (#{0})", holidays.Count);

                        foreach (var holiday in holidays)
                        {
                            //	check if account exist
                            var updateholiday = db.Accounts.FindById(holiday.Id);

                            if (updateholiday == null)
                            {
                                log.Info("Import holiday: #{0}. {1}", holiday.Id, holiday.Day);
                                holiday.Updated = importTime;
                                db.Holidays.Insert(holiday);
                            }
                            else
                            {
                                log.Info("Update holiday: #{0}. {1}", holiday.Id, holiday.Day);
                                holiday.Updated = importTime;
                                db.Holidays.Update(holiday);
                            }
                        }
                    }

                    log.Info("Drop all");
                    import.DropAll();
                }
            }
        }