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); }
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(); }