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