Example #1
0
        public ActionResult Add(pictures image, string post, string description)
        {
            string file      = Path.GetFileNameWithoutExtension(image.imageFile.FileName);
            string extension = Path.GetExtension(image.imageFile.FileName);
            string filename  = file + DateTime.Now.ToString("yymmssfff") + extension;

            using (imagesGalleryEntities db = new imagesGalleryEntities())
            {
                pictures addpicture = new pictures();
                try
                {
                    addpicture.id = (from picture in db.pictures
                                     select picture.id).Max() + 1;
                }
                catch (System.InvalidOperationException ex)
                {
                    addpicture.id = 0;
                };
                addpicture.name             = post;
                addpicture.description      = description;
                addpicture.publication_date = DateTime.Now;
                var Ouser = (user)Session["User"];
                addpicture.user_id      = Ouser.id;
                addpicture.picture_path = "/img/userspictures/" + filename;
                filename = Path.Combine(Server.MapPath("~/img/userspictures/"), filename);
                image.imageFile.SaveAs(filename);


                db.pictures.Add(addpicture);
                db.SaveChanges();
            }
            ModelState.Clear();

            return(View());
        }
Example #2
0
        public ActionResult signup(String nickname, String email, String password)
        {
            user adduser = new user();

            using (imagesGalleryEntities db = new imagesGalleryEntities())
            {
                try
                {
                    adduser.id = (from user in db.user
                                  select user.id).Max() + 1;
                }
                catch (System.InvalidOperationException ex)
                {
                    adduser.id = 0;
                }
                adduser.name     = nickname;
                adduser.username = email;
                adduser.password = password;
                db.user.Add(adduser);
                db.SaveChanges();

                Session["user"] = adduser;
                return(Redirect("~/Dashboard/index"));
            }
            return(View());
        }
Example #3
0
        // GET: Dashboard
        public ActionResult Index()
        {
            user currentUser = (user)Session["user"];
            List <PicturesTableViewModel> lst = null;

            using (imagesGalleryEntities db = new imagesGalleryEntities())
            {
                try
                {
                    lst = (from p in db.pictures
                           where p.user_id == currentUser.id
                           select new PicturesTableViewModel
                    {
                        id = p.id,
                        name = p.name,
                        description = p.description,
                        user_id = p.user_id,
                        picture_varchar = p.picture_path
                    }).ToList();

                    return(View(lst));
                }
                catch (System.NullReferenceException e)
                {
                    return(Redirect("~/home"));
                }
            }
        }
Example #4
0
        public ActionResult Index(int pictureId)
        {
            PictureWithCommentsModel model = new PictureWithCommentsModel();

            List <ComentsTableViewModel>  allcomments = null;
            List <PicturesTableViewModel> thepicture  = null;
            List <UserTableViewModel>     UserInfo    = null;;

            using (imagesGalleryEntities db = new imagesGalleryEntities())
            {
                allcomments = (from c in db.comments
                               join us in db.user on c.user_id equals us.id
                               where c.picture_id == pictureId && c.parent_comment_id == null
                               select new ComentsTableViewModel
                {
                    id = c.id,
                    comments = c.comment,
                    data_coment = c.comment_date.ToString(),
                    parent_id = c.parent_comment_id,
                    username = us.name,
                    pictureId = c.picture_id,
                }).ToList();

                thepicture = (from p in db.pictures
                              where p.id == pictureId
                              select new PicturesTableViewModel
                {
                    id = p.id,
                    name = p.name,
                    description = p.description,
                    publicationDate = p.publication_date.ToString(),
                    picture_varchar = p.picture_path,
                }).ToList();

                UserInfo = (from u in db.user
                            join p in db.pictures on u.id equals p.user_id
                            select new UserTableViewModel
                {
                    id = u.id,
                    username = u.name,
                    nickname = u.username,
                }).Distinct().ToList();
            }

            getChildComments(ref allcomments, null, 0, pictureId);
            model.comments = allcomments;
            model.picture  = thepicture;
            model.user     = UserInfo;
            return(View(model));
        }
Example #5
0
        public void getChildComments(ref List <ComentsTableViewModel> Comments, List <ComentsTableViewModel> ActualChilds, int position, int pictureId)
        {
            int i = 0;

            for (i = 0; i < Comments.Count; i++)
            {
                using (imagesGalleryEntities db = new imagesGalleryEntities())
                {
                    int id_parent = Comments.ElementAt(i).id;
                    Comments.ElementAt(i).childComments = (from c in db.comments
                                                           join us in db.user on c.user_id equals us.id
                                                           where c.picture_id == pictureId && c.parent_comment_id == id_parent
                                                           select new ComentsTableViewModel
                    {
                        id = c.id,
                        comments = c.comment,
                        data_coment = c.comment_date.ToString(),
                        parent_id = c.parent_comment_id,
                        username = us.name,
                        pictureId = c.picture_id,
                    }).ToList();

                    if (Comments.ElementAt(i).childComments.Count > 0)
                    {
                        for (int j = 0; j < Comments.ElementAt(i).childComments.Count; j++)
                        {
                            int id_parent_last_lvl = Comments.ElementAt(i).childComments.ElementAt(j).id;
                            Comments.ElementAt(i).childComments.ElementAt(j).childComments =
                                (from c in db.comments
                                 join us in db.user on c.user_id equals us.id
                                 where c.picture_id == pictureId && c.parent_comment_id == id_parent_last_lvl
                                 select new ComentsTableViewModel
                            {
                                id = c.id,
                                comments = c.comment,
                                data_coment = c.comment_date.ToString(),
                                parent_id = c.parent_comment_id,
                                username = us.name,
                                pictureId = c.picture_id,
                            }).ToList();
                        }
                    }
                }
            }
        }
Example #6
0
        public ActionResult index(String username, String password)
        {
            ViewBag.Title = "Your contact page." + username + " y " + password;
            using (imagesGalleryEntities db = new imagesGalleryEntities())
            {
                var lst = from d in db.user
                          where d.username == username && d.password == password
                          select d;
                if (lst.Count() == 1)
                {
                    user Ouser = lst.First();
                    Session["user"] = Ouser;
                    return(Redirect("~/Dashboard/index"));
                }
                else
                {
                }
            }

            return(View());
        }
Example #7
0
        public async Task <List <ComentsTableViewModel> > loadComments(string CommentId, string pictureId)
        {
            List <ComentsTableViewModel> MoreComments = null;

            using (imagesGalleryEntities db = new imagesGalleryEntities())
            {
                int CommentIdInt = Int32.Parse(CommentId);
                int PictureIdInt = Int32.Parse(pictureId);
                MoreComments = (from c in db.comments
                                join us in db.user on c.user_id equals us.id
                                where c.picture_id == PictureIdInt && c.parent_comment_id == CommentIdInt
                                select new ComentsTableViewModel
                {
                    id = c.id,
                    comments = c.comment,
                    data_coment = c.comment_date.ToString(),
                    parent_id = c.parent_comment_id,
                    username = us.name,
                    pictureId = c.picture_id,
                }).ToList();
            }
            return(MoreComments);
        }