Esempio n. 1
0
        public List<User> GetUsers()
        {
            List<User> results = null;
            using (var db = new ForumContext())
            {
                var query = from u in db.users
                            select u;
                results = query.ToList<User>();
            }

            return results;
        }
Esempio n. 2
0
        public User Login(String login, String password)
        {
            using (var db = new ForumContext())
            {
                var query = from u in db.users
                            where u.login.Equals(login) && u.password.Equals(password)
                            select u;

                if (query.Any())
                    return query.ToArray<User>().First();
                else
                    return null;
            }
        }
Esempio n. 3
0
        public bool IsAdmin(User user)
        {
            using (var db = new ForumContext())
            {
                var query = from u in db.users
                            where u.usrID == user.usrID && u.role == Role.ADMIN
                            select u;

                if (query.Any())
                    return true;
                else
                    return false;
            }
        }
Esempio n. 4
0
        public List<Topic> GetTopics()
        {
            List<Topic> retults = null;
            using (var db = new ForumContext())
            {
                var query = from t in db.topics
                            select t;
                retults = query.ToList<Topic>();

                foreach (Topic topic in retults)
                {
                    var user = topic.author;
                    string login = null;
                    if (user != null)
                        login = user.login;
                }
            }



            return retults;
        }
Esempio n. 5
0
        static void Main(string[] args)
        {
            using (var db = new ForumContext())
            {
                var user = new User()
                {
                    login = "******",
                    password = "******",
                    role = Role.ADMIN
                };

                var topic = new Topic()
                {
                    title = "Java",
                    createdAt = DateTime.Now

                };
                

                var post = new Post()
                {
                    content = "Java 8 jest fajna!",
                    createdAt = DateTime.Now,
                };

                post.topic = topic;
                post.user = user;

                topic.posts.Add(post);

                user.topics.Add(topic);
                user.posts.Add(post);

                db.users.Add(user);
                db.topics.Add(topic);
                db.posts.Add(post);
                db.SaveChanges();
            }
        }
Esempio n. 6
0
        public List<Post> GetPosts(Topic topic)
        {
            List<Post> results = null;
            using (var db = new ForumContext())
            {
                var query = from p in db.posts
                            where p.topID == topic.topID
                            select p;
                results = query.ToList<Post>();

                foreach (Post post in results)
                {
                    var user = post.user;
                    string login = null;
                    if (user != null)
                        login = user.login;
                }
            }

            return results;
        }
Esempio n. 7
0
        public bool EditUser(User user)
        {
            using (var db = new ForumContext())
            {
                //check if exists
                var query = from u in db.users
                            where u.login.Equals(user.login) && u.usrID != user.usrID
                            select u;

                if (query.Any())
                    return false;

                var found = db.users.Find(user.usrID);
                if (found == null)
                    return false;
                found.login = user.login;
                found.password = user.password;
                found.role = user.role;
                db.SaveChanges();
            }
            return true;
        }
Esempio n. 8
0
 public bool DeleteUser(User user)
 {
     using (var db = new ForumContext())
     {
         var found = db.users.Find(user.usrID);
         if (found.posts.Any() || found.topics.Any())
             return false;
         db.users.Remove(found);
         db.SaveChanges();
         return true;
     }
 }
Esempio n. 9
0
        public bool AddUser(String login, String pswd, Role role)
        {
            using (var db = new ForumContext())
            {
                //check if exists
                var query = from u in db.users
                            where u.login.Equals(login)
                            select u;

                if (query.Any())
                {
                    return false;
                }

                User newUser = new User()
                {
                    login = login,
                    password = pswd,
                    role = role
                };

                db.users.Add(newUser);
                db.SaveChanges();
                return true;
            }
        }
Esempio n. 10
0
        public void AddPost(String content, int topID, User user)
        {
            using (var db = new ForumContext())
            {
                var post = new Post();
                post.content = content;
                post.createdAt = DateTime.Now;


                var query = from t in db.topics
                            where t.topID == topID
                            select t;

                List<Topic> results = query.ToList<Topic>();
                Topic findTopic = results[0];

                if (findTopic != null)
                {
                    findTopic.posts.Add(post);
                    post.topic = findTopic;
                }

                var findUser = db.users.Find(user.usrID);
                if (findUser != null)
                {
                    findUser.posts.Add(post);
                    post.user = findUser;
                }

                db.SaveChanges();
            }
        }
Esempio n. 11
0
        public void AddPost(String content, Topic topic, User user)
        {
            using (var db = new ForumContext())
            {
                var post = new Post();
                post.content = content;
                post.createdAt = DateTime.Now;

                var findTopic = db.topics.Find(topic.topID);
                if (findTopic != null)
                {
                    findTopic.posts.Add(post);
                    post.topic = findTopic;
                }

                var findUser = db.users.Find(user.usrID);
                if (findUser != null)
                {
                    findUser.posts.Add(post);
                    post.user = findUser;
                }

                db.SaveChanges();
            }
        }
Esempio n. 12
0
        public void AddTopic(String title, User user)
        {
            using (var db = new ForumContext())
            {
                var topic = new Topic();
                topic.title = title;
                topic.createdAt = DateTime.Now;

                var founded = db.users.Find(user.usrID);
                if (founded != null)
                    founded.topics.Add(topic);
                topic.author = founded;
                db.topics.Add(topic);
                db.SaveChanges();
            }
        }
Esempio n. 13
0
        public bool EditTopicTitle(int topID, string newTitle)
        {
            using (var db = new ForumContext())
            {
                var query = from t in db.topics
                            where t.topID == topID
                            select t;

                if (!query.Any())
                    return false;

                var toEdit = query.First();
                toEdit.modifiedAt = DateTime.Now;
                toEdit.title = newTitle;
                db.SaveChanges();
            }
            return true;
        }
Esempio n. 14
0
        public bool EditPostContent(int posID, string newContent)
        {
            using (var db = new ForumContext())
            {
                var query = from p in db.posts
                            where p.posID == posID
                            select p;

                if (!query.Any())
                    return false;

                var toEdit = query.First();
                toEdit.modifiedAt = DateTime.Now;
                toEdit.content = newContent;
                db.SaveChanges();
            }
            return true;
        }