//тут надо добавить информацию о постах
private void GetParametrUsersAndGroupPosts()
{
using (ContextUserAndGroup db = new ContextUserAndGroup())
{
//var tt = db.UserAndGroups
}
}
private IEnumerable <UserAndGroup> UserAndGroupCheked(int User_Id, int Group_Id)
{
using (ContextUserAndGroup bd = new ContextUserAndGroup())
{
var tt = bd.UserAndGroups.Where(p => p.User_id == User_Id).Intersect(bd.UserAndGroups.Where(p => p.Group_Id == Group_Id)).ToList();
return(tt);
}
}
private bool UserAndGroupAddBd(int User_Id, int Group_Id)
{
using (ContextUserAndGroup db = new ContextUserAndGroup())
{
IEnumerable <UserAndGroup> query = UserAndGroupCheked(User_Id, Group_Id);
if (query.Count() == 0)
{
UserAndGroup UAG = new UserAndGroup
{
User_id = User_Id,
Group_Id = Group_Id
};
db.UserAndGroups.Add(UAG);
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}