public Group LoadGroup(int groupId)
{
bool exist = db.GroupMembers.Any(x => x.GroupId == groupId);
if (exist)
{
IQueryable <Models.GroupMember> list = db.GroupMembers.Where(x => x.GroupId == groupId);
Group group = new Group {
groupId = groupId
};
foreach (Models.GroupMember groupMemberDB in list)
{
var groupMember = new GroupMember();
groupMember.user.username = groupMemberDB.Username;
groupMember.role = groupMemberDB.GroupRole;
groupMember.groupID = groupId;
group.AddMember(groupMember);
}
Console.WriteLine(group.groupMembers[0].role);
return(group);
}
return(null);
}
public bool ChangeRole(GroupMember groupMember)
{
try
{
var role = groupMember.role;
var groupMemberItem = db.GroupMembers.Find(groupMember.user.username);
groupMemberItem.GroupRole = role;
db.SaveChanges();
return(true);
}
catch (Exception e)
{
Console.WriteLine(e);
return(false);
}
}
public bool AddMember(GroupMember groupMember)
{
try
{
db.Add(new Models.GroupMember
{
Username = groupMember.user.username,
GroupId = groupMember.groupID,
GroupRole = groupMember.role,
});
db.SaveChanges();
return(true);
}
catch (Exception e)
{
Console.WriteLine(e);
return(false);
}
}
public bool RemoveMember(GroupMember groupMember)
{
try
{
var memberItem = db.GroupMembers.Find(groupMember.user.username);
var groupId = db.GroupMembers.Find(groupMember.user.username).GroupId;
var counter = db.GroupMembers.Count(x => x.GroupId == groupId);
if (counter > 1)
{
db.GroupMembers.Remove(memberItem);
db.SaveChanges();
return(true);
}
return(false);
}
catch (Exception e)
{
Console.WriteLine(e);
return(false);
}
}
