private DataTable getTable(int selectedIndex) { DataTable dt = new DataTable(); // Game List if (selectedIndex == 1) { IList <GameModel> games = null; using (var context = new CVGSEntities()) { games = context.games.Select(s => new GameModel() { name = s.name }).ToList <GameModel>(); } dt.Columns.Add("Name", typeof(string)); dt.Rows.Add("Name"); foreach (GameModel row in games) { dt.Rows.Add(row.name.ToString()); } } // Game Detail else if (selectedIndex == 2) { IList <GameModel> games = null; using (var context = new CVGSEntities()) { games = context.games.Select(s => new GameModel() { name = s.name, description = s.description, publisher = s.publisher, publishDate = s.publishDate, genre = s.genre, rating = s.rating, price = s.price }).ToList <GameModel>(); } dt.Columns.Add("Name", typeof(string)); dt.Columns.Add("Description", typeof(string)); dt.Columns.Add("Publisher", typeof(string)); dt.Columns.Add("PublishDate", typeof(DateTime)); dt.Columns.Add("Genre", typeof(string)); dt.Columns.Add("Rating", typeof(string)); dt.Columns.Add("Price", typeof(decimal)); foreach (GameModel row in games) { dt.Rows.Add(row.name.ToString(), row.description.ToString(), row.publisher.ToString(), row.publishDate.ToString(), row.genre.ToString(), row.rating.ToString(), row.price.ToString()); } } // Member List else if (selectedIndex == 3) { IList <UserModel> users = null; using (var context = new CVGSEntities()) { users = context.users.Select(s => new UserModel() { firstName = s.firstName, lastname = s.lastName }).ToList <UserModel>(); } dt.Columns.Add("Name", typeof(string)); dt.Rows.Add("Name"); foreach (UserModel user in users) { dt.Rows.Add(user.firstName.ToString() + ' ' + user.lastname.ToString()); } } // Member Detail else if (selectedIndex == 4) { IList <UserModel> users = null; using (var context = new CVGSEntities()) { users = context.users.Select(s => new UserModel() { username = s.username, firstName = s.firstName, lastname = s.lastName, email = s.email, age = s.age }).ToList <UserModel>(); } dt.Columns.Add("username", typeof(string)); dt.Columns.Add("firstName", typeof(string)); dt.Columns.Add("lastname", typeof(string)); dt.Columns.Add("email", typeof(string)); dt.Columns.Add("age"); dt.Rows.Add("Name", "Firest Name", "Last Name", "Email", "Age"); foreach (UserModel row in users) { dt.Rows.Add(row.username.ToString(), row.firstName.ToString(), row.lastname.ToString(), row.email.ToString(), row.age.ToString()); } } // wishList else if (selectedIndex == 5) { IList <WishListModel> wish = null; using (var context = new CVGSEntities()) { wish = context.wishLists.Select(s => new WishListModel() { username = s.username, }).ToList <WishListModel>(); } dt.Columns.Add("Name", typeof(string)); dt.Rows.Add("Name"); foreach (WishListModel row in wish) { dt.Rows.Add(row.username.ToString()); } } // Sales Report else if (selectedIndex == 6) { IList <SalesModel> sales = null; using (var context = new CVGSEntities()) { sales = context.orders.Select(s => new SalesModel() { username = s.username, gameId = s.gameId, orderDate = s.orderDate }).ToList <SalesModel>(); } dt.Columns.Add("Name"); dt.Columns.Add("Game Id"); dt.Columns.Add("Order Date"); dt.Rows.Add("Name", "Game Id", "Order Date"); foreach (SalesModel row in sales) { dt.Rows.Add(row.username.ToString(), row.gameId.ToString(), row.orderDate.ToString()); } } return(dt); }