Exemplo n.º 1
0
        public List <ShowAllDashboardItemTeams> ShowAllItemsAndTeams(string DashboardID)
        {
            int dashboardID = Convert.ToInt32(DashboardID);
            StoredProcedureDataContext dbmlObject     = new StoredProcedureDataContext();
            var ShowAllItemsAndTeamsResult            = dbmlObject.ShowAllItemsAndTeamsOuterJoin(dashboardID).ToList();
            List <ShowAllDashboardItemTeams> UserList = new List <ShowAllDashboardItemTeams>();

            foreach (var i in ShowAllItemsAndTeamsResult)
            {
                UserList.Add(new ShowAllDashboardItemTeams
                {
                    ItemID   = i.ItemID,
                    ItemName = i.ItemName,
                    TeamID   = Convert.ToInt32(i.TeamID),
                    TeamName = i.TeamName
                });
            }
            return(UserList);
        }
Exemplo n.º 2
0
        public List<ShowAllDashboardItemTeams> ShowAllItemsAndTeams(string DashboardID)
        {
            int dashboardID = Convert.ToInt32(DashboardID);
            StoredProcedureDataContext dbmlObject = new StoredProcedureDataContext();
            var ShowAllItemsAndTeamsResult = dbmlObject.ShowAllItemsAndTeamsOuterJoin(dashboardID).ToList();
            List<ShowAllDashboardItemTeams> UserList = new List<ShowAllDashboardItemTeams>();

            foreach (var i in ShowAllItemsAndTeamsResult)
            {
                UserList.Add(new ShowAllDashboardItemTeams
                {
                    ItemID = i.ItemID,
                    ItemName = i.ItemName,
                    TeamID = Convert.ToInt32(i.TeamID),
                    TeamName = i.TeamName

                });
            }
            return UserList;
        }