Exemplo n.º 1
0
        private void label2_Click(object sender, EventArgs e)
        {
            var user         = Cache.Get <User>("user");
            var selectedRows = table.SelectedCells[0].Value as string;

            using (var ctx = new Database.ApplicationContext())
            {
                var allFriends = ctx.FriendDetails.Include(it => it.Friend).Where(it => it.UserId == user.UserId && it.Friend.AreFriends).Select(it => it.Friend)
                                 .ToList();

                foreach (var friend in allFriends)
                {
                    var fr = ctx.FriendDetails.FirstOrDefault(it => it.FriendId == friend.FriendId && it.User.Email == selectedRows);

                    if (fr != null)
                    {
                        ctx.Friends.Remove(friend);
                        ctx.SaveChanges();
                    }
                }
            }

            table.Columns.Clear();
            table.Columns.Add(new DataGridViewTextBoxColumn()
            {
                DataPropertyName = "Surname",
                HeaderText       = "Фамилия"
            });
            table.Columns.Add(new DataGridViewTextBoxColumn()
            {
                DataPropertyName = "Firstname",
                HeaderText       = "Имя"
            });
            table.Columns.Add(new DataGridViewTextBoxColumn()
            {
                DataPropertyName = "Lastname",
                HeaderText       = "Отчество"
            });
            table.Columns.Add(new DataGridViewTextBoxColumn()
            {
                DataPropertyName = "Email",
                HeaderText       = "Электронная почта"
            });
            table.AutoGenerateColumns = false;

            using (var ctx = new ApplicationContext())
            {
                var allFriends = ctx.FriendDetails.Include(it => it.Friend).Where(it => it.UserId == user.UserId && it.Friend.AreFriends).Select(it => it.Friend)
                                 .ToList();

                var list = new List <User>();

                foreach (var friend in allFriends)
                {
                    list.AddRange(ctx.FriendDetails.Where(it => it.FriendId == friend.FriendId && it.UserId != user.UserId).Select(it => it.User).ToList());
                }

                table.DataSource = list;
            }
        }
Exemplo n.º 2
0
        private void label1_Click(object sender, EventArgs e)
        {
            var user         = Cache.Get <User>("user");
            var selectedRows = Subscribers.SelectedCells;

            if (selectedRows.Count == 0)
            {
                Add_Failed_2.Visible = true;
                return;
            }
            Add_Sucess.Visible = true;

            var secondUser = selectedRows[0].Value as string;

            using (var ctx = new Database.ApplicationContext())
            {
                var secUserList = ctx.FriendDetails.Where(it => it.User.Email == secondUser).ToList();
                var userList    = ctx.FriendDetails.Where(it => it.UserId == user.UserId).ToList();

                foreach (var secUserDetail in secUserList)
                {
                    if (userList.FirstOrDefault(it => it.FriendId == secUserDetail.FriendId) != null)
                    {
                        var friend = ctx.Friends.FirstOrDefault(it => it.FriendId == secUserDetail.FriendId);
                        friend.AreFriends = true;
                        ctx.Friends.Update(friend);
                        ctx.SaveChanges();
                        break;
                    }
                }
            }

            refreshTable();
        }