Exemplo n.º 1
0
        public static void AddBookmarks(string username, string title, string url, string[] tags, string notes)
        {
            var dbCon = new BookmarksEntities();

            using (dbCon)
            {
                var bookmark = new Bookmark();
                bookmark.Notes = notes;
                bookmark.URL = url;
                bookmark.Title = title;

                bookmark.User = CreateOrLoadUser(dbCon, username);

                foreach (var tagName in tags)
                {
                    var tag = CreateOrLoadTag(dbCon, tagName);

                    bookmark.Tags.Add(tag);
                }

                var titleTags = Regex.Split(title, @"[ ,-\.;!?]+");

                foreach (var titleTag in titleTags)
                {
                    var tag = CreateOrLoadTag(dbCon, titleTag);

                    bookmark.Tags.Add(tag);
                }

                dbCon.Bookmarks.Add(bookmark);
                dbCon.SaveChanges();
            }
        }
Exemplo n.º 2
0
        private static User CreateOrLoadUser(BookmarksEntities context, string username)
        {
            var existingUser = (from u in context.Users
                                where u.Username.ToLower() == username.ToLower()
                                select u).FirstOrDefault();

            if (existingUser != null)
            {
                return existingUser;
            }

            var newUser = new User();
            newUser.Username = username;
            context.Users.Add(newUser);
            context.SaveChanges();
            return newUser;
        }
Exemplo n.º 3
0
        private static Tag CreateOrLoadTag(BookmarksEntities context, string tagName)
        {
            var existingTag = (from t in context.Tags
                               where t.Name.ToLower() == tagName.ToLower()
                               select t).FirstOrDefault();

            if (existingTag != null)
            {
                return existingTag;
            }

            var newTag = new Tag();
            newTag.Name = tagName.ToLower();
            context.Tags.Add(newTag);
            context.SaveChanges();
            return newTag;
        }
Exemplo n.º 4
0
    private static void InsertBookmarks(int count)
    {
        BookmarksEntities context = new BookmarksEntities();
        var userIDs =
            context.Users.Select(u => u.UserId).ToList();

        for (int i = 0; i < count; i++)
        {
            Bookmark bookmark = new Bookmark();
            bookmark.Title  = "Title" + i;
            bookmark.URL    = "http://telerikacademy.com/bookmarks/" + i;
            bookmark.UserId = userIDs[i % userIDs.Count];
            context.Bookmarks.Add(bookmark);
        }

        context.SaveChanges();
    }
Exemplo n.º 5
0
        private static Tag CreateOrLoadTag(BookmarksEntities context, string tagName)
        {
            var tag = context.Tags.FirstOrDefault(x => x.TagName == tagName);

            if (tag != null)
            {
                return(tag);
            }

            var newTag = new Tag()
            {
                TagName = tagName
            };

            context.Tags.Add(newTag);
            context.SaveChanges();
            return(newTag);
        }
Exemplo n.º 6
0
        private static User CreateOrLoadUser(BookmarksEntities context, string username)
        {
            var user = context.Users.FirstOrDefault(x => x.Username == username);

            if (user != null)
            {
                return(user);
            }

            var newUser = new User()
            {
                Username = username
            };

            context.Users.Add(newUser);
            context.SaveChanges();
            return(newUser);
        }
Exemplo n.º 7
0
        public static void InsertData(string username, string title, string url, string[] tags, string notes)
        {
            using (var scope = new TransactionScope(TransactionScopeOption.Required,
                                                    new TransactionOptions {
                IsolationLevel = IsolationLevel.RepeatableRead
            }))
            {
                var  context  = new BookmarksEntities();
                User user     = CreateOrLoadUser(context, username);
                var  bookmark = new Bookmark {
                    User = user, Title = title, Notes = notes, Url = url
                };

                foreach (var tagName in tags)
                {
                    var tag = CreateOrLoadTag(context, tagName);
                    bookmark.Tags.Add(tag);
                }

                context.Bookmarks.Add(bookmark);
                context.SaveChanges();
            }
        }