Ejemplo n.º 1
0
        public async Task LikePost(int PostId, int likes)
        {
            Console.WriteLine(PostId);
            try
            {
                string mylike;
                using (IServiceScope scope = _sp.CreateScope())
                {
                    SwishDBContext dbContext = scope.ServiceProvider.GetRequiredService <SwishDBContext>();
                    likes = dbContext.UserPost.FromSqlRaw("EXECUTE dbo.LikePost @UName={0}, @PostID={1}",
                                                          Context.User.Identity.Name,
                                                          PostId).ToList().FirstOrDefault().PLikes;

                    mylike = (from AllMessages in dbContext.LikedPosts
                              where (AllMessages.UName == Context.User.Identity.Name && AllMessages.PostId == PostId)
                              select new
                    {
                        AllMessages.UName
                    }).FirstOrDefault().UName;
                }
                Console.WriteLine("PostID: " + PostId + "\nLikes: " + likes);
                await Clients.All.SendAsync("GetPostLikes", PostId, likes, "1" + mylike);
            }
            catch (Exception ex)
            {
                await Clients.All.SendAsync("GetPostLikes", PostId, likes, "0" + Context.User.Identity.Name);

                Console.WriteLine(ex.ToString());
            }
        }
Ejemplo n.º 2
0
        public async Task SaveComment(int PostId, string Comment)
        {
            try
            {
                using (IServiceScope scope = _sp.CreateScope())
                {
                    SwishDBContext dbContext = scope.ServiceProvider.GetRequiredService <SwishDBContext>();
                    CommentModel   t         = new CommentModel
                    {
                        UserID  = Context.User.Identity.Name,
                        PostId  = PostId,
                        Comment = Comment,
                        CLikes  = 0,
                        Deleted = false
                    };

                    Console.WriteLine(PostId + " : " + Comment);

                    dbContext.CommentsModels.Add(t);
                    dbContext.SaveChanges();

                    await Clients.Caller.SendAsync("LikedCom", t.CommentID);
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
            }
        }
Ejemplo n.º 3
0
        public async Task SendNotifs(string User, string Message, int MsgType)
        {
            try
            {
                switch (MsgType)
                {
                case 0:
                    await Clients.User(User).SendAsync("PopupNotifRFR");

                    break;

                case 1:
                    SwishUser UserDet;
                    using (IServiceScope scope = _sp.CreateScope())
                    {
                        SwishDBContext dbContext = scope.ServiceProvider.GetRequiredService <SwishDBContext>();
                        UserDet = (from Userdet in dbContext.Users
                                   where Userdet.UserName == Context.User.Identity.Name
                                   select Userdet).FirstOrDefault();
                    }
                    await Clients.User(User).SendAsync("PopupNotifSFR", Message, JsonConvert.SerializeObject(UserDet), Guid.NewGuid());

                    break;
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
            }
        }
Ejemplo n.º 4
0
        public async Task AddFriend(string User, string ForConfirm, string Confirmed, bool forremove = false)
        {
            try
            {
                using (IServiceScope scope = _sp.CreateScope())
                {
                    SwishDBContext dbContext = scope.ServiceProvider.GetRequiredService <SwishDBContext>();

                    if (forremove)
                    {
                        dbContext.Database.ExecuteSqlRaw("EXECUTE dbo.RemoveFriend @MyUserName={0}, @UserName={1}", Context.User.Identity.Name, User);
                        return;
                    }

                    if (ForConfirm == "true")
                    {
                        if (Confirmed == "true")
                        {
                            FriendsModel entity = dbContext.Friends.FirstOrDefault(item => item.FriendKey == (Context.User.Identity.Name + User));
                            if (entity != null)
                            {
                                entity.Confirmed = true;
                                dbContext.Friends.Update(entity);
                                dbContext.SaveChanges();
                            }
                        }
                        else
                        {
                            FriendsModel entity = dbContext.Friends.FirstOrDefault(item => item.FriendKey == (Context.User.Identity.Name + User));
                            if (entity != null)
                            {
                                entity.Confirmed = true;
                                dbContext.Friends.Remove(entity);
                                dbContext.SaveChanges();
                            }
                        }
                    }
                    else
                    {
                        FriendsModel t = new FriendsModel
                        {
                            FriendKey = User + Context.User.Identity.Name,
                            User1     = Context.User.Identity.Name,
                            User2     = User
                        };

                        dbContext.Friends.Add(t);
                        dbContext.SaveChanges();
                    }

                    await Clients.User(User).SendAsync("ReceiveNotif", ForConfirm, Context.User.Identity.Name);
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
            }
        }
Ejemplo n.º 5
0
 public async Task LikeComment(int CommentId, int likes)
 {
     try
     {
         using (IServiceScope scope = _sp.CreateScope())
         {
             SwishDBContext dbContext = scope.ServiceProvider.GetRequiredService <SwishDBContext>();
             likes = dbContext.CommentsModels.FromSqlRaw("EXECUTE dbo.LikeComment @UName={0}, @CommentID={1}",
                                                         Context.User.Identity.Name,
                                                         CommentId).FirstOrDefault().CLikes;
         }
     }
     catch (Exception ex)
     {
         Console.WriteLine(ex.ToString());
     }
     await Clients.All.SendAsync("GetCommentLikes", CommentId, likes);
 }
Ejemplo n.º 6
0
        public async Task GetNotifs()
        {
            try
            {
                List <SwishUser> MyNotifs;

                using (IServiceScope scope = _sp.CreateScope())
                {
                    SwishDBContext dbContext = scope.ServiceProvider.GetRequiredService <SwishDBContext>();

                    MyNotifs = dbContext.Users.FromSqlRaw("EXECUTE dbo.GetNotifications @UserName={0}", Context.User.Identity.Name).ToList();
                }

                await Clients.Caller.SendAsync("RecieveNotifs", JsonConvert.SerializeObject(MyNotifs), Context.User.Identity.Name);
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
            }
        }
Ejemplo n.º 7
0
        public async Task RetrievePosts(int skip, string User = "******")
        {
            try
            {
                List <PostViewModel> Posts;
                List <SwishUser>     MyFriends;

                using (IServiceScope scope = _sp.CreateScope())
                {
                    SwishDBContext dbContext = scope.ServiceProvider.GetRequiredService <SwishDBContext>();

                    MyFriends = dbContext.Users.FromSqlRaw("EXECUTE dbo.GetFriends @MyUserName={0}", Context.User.Identity.Name).ToList();

                    Posts = (from allposts in dbContext.UserPost
                             orderby allposts.PDate descending
                             where (User == "All" ? true : allposts.UserID == User)
                             select new PostViewModel
                    {
                        PostID = allposts.PostID,
                        PLikes = allposts.PLikes,
                        PostTxt = allposts.PText,
                        PostDt = allposts.PDate,
                        PostImages = (from PImages in dbContext.PostImages
                                      where PImages.postModel.PostID == allposts.PostID
                                      select new pImage
                        {
                            Image = PImages.ImageFileName,
                            IsVideo = PImages.IsVideo
                        }).ToList(),
                        Comments = (from allcomments in dbContext.CommentsModels
                                    join Commenter in dbContext.Users on allcomments.UserID equals Commenter.UserName
                                    orderby allcomments.CommentID descending
                                    where allcomments.PostId == allposts.PostID
                                    select new CommentViewModel
                        {
                            ComID = allcomments.CommentID,
                            UName = Commenter.UserName,
                            Fname = Commenter.FName,
                            Lname = Commenter.LName,
                            PPicPath = Commenter.PPicPath,
                            CommentTxt = allcomments.Comment,
                            CommentLikes = allcomments.CLikes,
                            Deleted = allcomments.Deleted
                        }).Take(5).ToList(),
                        PosterUser = (from Poster in dbContext.Users
                                      where (allposts.UserID == Poster.UserName)
                                      select Poster
                                      ).FirstOrDefault(),
                        mylike = (from AllMessages in dbContext.LikedPosts
                                  where (AllMessages.UName == Context.User.Identity.Name && AllMessages.PostId == allposts.PostID)
                                  select new
                        {
                            AllMessages.UName
                        }).Count()
                    }).Where(Poster => MyFriends.Contains(Poster.PosterUser) || Poster.PosterUser.UserName == Context.User.Identity.Name).Skip(skip).Take(5).ToList();
                }

                Console.WriteLine("<---------------------Posts------------------->");
                Console.WriteLine(JsonConvert.SerializeObject(Posts));
                Console.WriteLine("<---------------------Friends------------------->");
                Console.WriteLine(JsonConvert.SerializeObject(MyFriends));
                Console.WriteLine("<---------------------End------------------->");
                await Clients.Caller.SendAsync("GetPosts", JsonConvert.SerializeObject(Posts));

                //await Clients.Caller.SendAsync("GetPosts", Posts);
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
            }
        }