Example #1
0
        public List <PendingUsers> GetPending()
        {
            List <PendingUsers>            resultUsers = new List <PendingUsers>();
            List <get_pending_user_Result> pUsers      = new List <get_pending_user_Result>();

            using (var data = new digimarketEntities1().get_pending_user())
            {
                pUsers = data.ToList <get_pending_user_Result>();
            }

            foreach (var user in pUsers)
            {
                PendingUsers temp = new PendingUsers()
                {
                    uid = user.uid, fullname = user.fullname, photourl = user.photourl, status = user.status, username = user.username, date = user.date, sources = new List <get_user_sources_Result>()
                };
                using (var data = new digimarketEntities1().get_user_sources(temp.uid))
                {
                    temp.sources = data.ToList <get_user_sources_Result>();
                }

                resultUsers.Add(temp);
            }
            return(resultUsers);
        }
Example #2
0
 static DB()
 {
     ActiveEvents        = new ActiveEvents();
     ActiveGiveaways     = new ActiveGiveaways();
     BackgroundInventory = new BackgroundInventory();
     Cooldowns           = new Cooldowns();
     Events             = new Database.Events();
     EventLogs          = new EventLogs();
     EventSchedule      = new EventSchedule();
     GiveawayLogs       = new GiveawayLogs();
     Giveaways          = new Giveaways();
     Inventory          = new Inventory();
     LeagueData         = new LeagueData();
     Mappings           = new Mappings();
     ModerationLogs     = new ModerationLogs();
     PendingUsers       = new PendingUsers();
     ProfileBackgrounds = new ProfileBackgrounds();
     Rewards            = new Rewards();
     RoleInventory      = new RoleInventory();
     Roles        = new Roles();
     Settings     = new Settings();
     Statistics   = new Statistics();
     Streamers    = new Streamers();
     SystemTimers = new SystemTimers();
     TempRoles    = new TempRoles();
     Toxicity     = new Toxicity();
     Users        = new Users();
 }