Exemple #1
0
 public GroupUserList SelectAll()
 {
     lgroupu         = new GroupUserList();
     cmd.CommandText = "SELECT  * From GroupUser";
     lgroupu         = new GroupUserList(base.Select());
     return(lgroupu);
 }
        public async Task AddUserList(string groupGuid, string emoji, int?amount, params string[] description)
        {
            Guid guid = Guid.Parse(groupGuid);

            if (_groupService.TryGetGroup(Context.Guild.Id, guid, out var group))
            {
                if (group.Host.Id != Context.User.Id)
                {
                    return;
                }

                if (!group.UserLists.Any(x => x.JoinEmote.Name == emoji))
                {
                    var newList = new GroupUserList()
                    {
                        Users       = new List <SocketGuildUser>(),
                        JoinEmote   = new Emoji(emoji),
                        UserLimit   = amount,
                        Description = (description.Length > 0) ? string.Join(' ', description) : string.Empty
                    };
                    group.UserLists.Add(newList);
                    await _groupService.ReplaceWithNewerGroup(group);

                    await group.PresentationMessage.AddReactionAsync(newList.JoinEmote);
                }
                else
                {
                    await ReplyAsync("There is already list with such emoji present.");
                }
            }
            else
            {
                await ReplyAsync("No groups with such ID were found");
            }
        }
        public override void Delete(BaseEntity entity)
        {
            Person u = entity as Person;

            GroupUserDB   gudb = new GroupUserDB();
            GroupUserList gul  = new GroupUserList();

            gul = gudb.SelectByPerson(u);

            foreach (GroupUser g in gul)
            {
                gudb.Delete(g);
            }
            CommentsDB   cdb = new CommentsDB();
            CommentsList lc  = cdb.CommentsByPerson(u);

            foreach (Comments c in lc)
            {
                cdb.Delete(c);
            }
            MsgsDB   mdb = new MsgsDB();
            MsgsList ml  = new MsgsList();

            ml = mdb.MsgsBySender(u);
            foreach (Msgs m in ml)
            {
                mdb.Delete(m);
            }
            base.Delete(entity);
        }
Exemple #4
0
        public static GroupUser SelectByID(int id)
        {
            if (lgroupu == null)
            {
                GroupUserDB db = new GroupUserDB();
                lgroupu = db.SelectAll();
            }
            GroupUser groupu = lgroupu.Find(c => c.ID == id);

            return(groupu);
        }
 public GroupUserListRefence(GroupUserList groupUserList)
 {
     Description = groupUserList.Description;
     Emote       = groupUserList.JoinEmote.Name;
     UserIds     = new List <ulong>();
     for (int i = 0; i < groupUserList.Users.Count; i++)
     {
         UserIds.Add(groupUserList.Users[i].Id);
     }
     UserLimit = groupUserList.UserLimit;
 }
Exemple #6
0
        public GroupUserList SelectByPerson(Person p)
        {
            lgroupu         = new GroupUserList();
            cmd.CommandText = "SELECT  * From GroupUser WHERE User = @p";
            cmd.Parameters.Add(new OleDbParameter("@p", p.ID));
            lgroupu = new GroupUserList(base.Select());
            return(lgroupu);

            //if (lgroupu == null)
            //{
            //    GroupUserDB db = new GroupUserDB();
            //    lgroupu = db.SelectAll();
            //}
            //GroupUserList gul = new GroupUserList(lgroupu.FindAll(gu => gu.User == p));
            //return gul;
        }
        public questStatus Read(DbMgrTransaction trans, GroupId groupId, out GroupUserList groupUserList)
        {
            // Initialize
            questStatus status = null;

            groupUserList = null;


            // Read groupUser
            status = _dbGroupUsersMgr.Read(trans, groupId, out groupUserList);
            if (!questStatusDef.IsSuccess(status))
            {
                return(status);
            }
            return(new questStatus(Severity.Success));
        }
Exemple #8
0
        public UserDataHandler GetUserByToken(string token)
        {
            try
            {
                var tokenActive = _context.TokenLogs.FirstOrDefault(x => x.Token == token && x.Active == true && DateTime.Now < x.ValidThru);

                if (tokenActive == null)
                {
                    return(null);
                }
                else
                {
                    var user = _context.Users.FirstOrDefault(x => x.Id == tokenActive.UserId);

                    var groups = _context.UserGroups.Where(y => y.UserId == user.Id).ToList();

                    List <GroupUserList> groupsresult = new List <GroupUserList>();

                    foreach (var g in groups)
                    {
                        var           group        = _context.Groups.FirstOrDefault(gr => gr.Id == g.GroupId);
                        GroupUserList groupHandler = new GroupUserList();
                        groupHandler.Id        = g.Id;
                        groupHandler.Descricao = group.Description;
                        groupHandler.Funcao    = _context.Functions.FirstOrDefault(y => y.Id == group.FunctionId)?.Description;
                        groupHandler.Inserido  = g.CreationDate;

                        groupsresult.Add(groupHandler);
                    }

                    UserDataHandler response = new UserDataHandler
                    {
                        Id    = user.Id,
                        Name  = user.Name,
                        CPF   = user.CPF,
                        Group = groupsresult,
                        Token = token
                    };

                    return(response);
                }
            }
            catch (System.Exception)
            {
                throw;
            }
        }
Exemple #9
0
        public List <UserList> GetUsers()
        {
            try
            {
                List <UserList> response = new List <UserList>();

                var users = _context.Users.ToList();

                foreach (var x in users)
                {
                    UserList user = new UserList();

                    user.Id   = x.Id;
                    user.Name = x.Name;
                    user.CPF  = x.CPF;

                    var groups = _context.UserGroups.Where(y => y.UserId == x.Id).ToList();

                    List <GroupUserList> groupsresult = new List <GroupUserList>();

                    foreach (var g in groups)
                    {
                        var           group        = _context.Groups.FirstOrDefault(gr => gr.Id == g.GroupId);
                        GroupUserList groupHandler = new GroupUserList();
                        groupHandler.Id        = g.Id;
                        groupHandler.Descricao = group.Description;
                        groupHandler.Funcao    = _context.Functions.FirstOrDefault(y => y.Id == group.FunctionId)?.Description;
                        groupHandler.Inserido  = g.CreationDate;

                        groupsresult.Add(groupHandler);
                    }

                    user.Group = groupsresult;

                    response.Add(user);
                }

                return(response);
            }
            catch (System.Exception e)
            {
                var errorMessage = e.InnerException;
                throw;
            }
        }
        public questStatus Read(GroupId groupId, out GroupUserList groupUserList)
        {
            // Initialize
            questStatus status = null;

            groupUserList = null;


            // Get group
            Group group = null;

            status = _dbGroupsMgr.Read(groupId, out group);
            if (!questStatusDef.IsSuccess(status))
            {
                return(status);
            }

            // Get group users
            using (FMSEntities dbContext = new FMSEntities())
            {
                List <Quest.Services.Dbio.FMS.GroupUsers> _groupUserList = null;
                status = read(dbContext, groupId, out _groupUserList);
                if (!questStatusDef.IsSuccess(status))
                {
                    return(status);
                }
                groupUserList       = new GroupUserList();
                groupUserList.Group = group;
                foreach (Quest.Services.Dbio.FMS.GroupUsers _groupUser in _groupUserList)
                {
                    // Get user
                    UserId userId = new UserId(_groupUser.UserId);
                    User   user   = null;
                    status = _dbUsersMgr.Read(userId, out user);
                    if (!questStatusDef.IsSuccess(status))
                    {
                        return(status);
                    }
                    groupUserList.UserList.Add(user);
                }
            }
            return(new questStatus(Severity.Success));
        }