static void Main(string[] args) { ProductManagement productManagement = new ProductManagement(); DataTableForProductManagement dataTableForProductManagement = new DataTableForProductManagement(); //master Console.WriteLine("Welcome to Product Review Management"); //UC1 List <ProductReview> productReviewList = new List <ProductReview>() { new ProductReview() { ProductId = 1, UserId = 1, Rating = 5, Review = "Good", isLike = true }, new ProductReview() { ProductId = 2, UserId = 2, Rating = 4, Review = "nice", isLike = true }, new ProductReview() { ProductId = 3, UserId = 3, Rating = 5, Review = "Good", isLike = true }, new ProductReview() { ProductId = 4, UserId = 4, Rating = 4, Review = "nice", isLike = true }, new ProductReview() { ProductId = 5, UserId = 02, Rating = 3, Review = "Average", isLike = false }, new ProductReview() { ProductId = 6, UserId = 03, Rating = 5, Review = "Good", isLike = true }, new ProductReview() { ProductId = 7, UserId = 14, Rating = 4, Review = "nice", isLike = true }, new ProductReview() { ProductId = 8, UserId = 13, Rating = 4, Review = "nice", isLike = true }, new ProductReview() { ProductId = 9, UserId = 9, Rating = 2, Review = "Bad", isLike = false }, new ProductReview() { ProductId = 10, UserId = 10, Rating = 5, Review = "Good", isLike = true }, new ProductReview() { ProductId = 11, UserId = 05, Rating = 5, Review = "Good", isLike = true }, new ProductReview() { ProductId = 12, UserId = 08, Rating = 5, Review = "Good", isLike = true }, new ProductReview() { ProductId = 13, UserId = 06, Rating = 3, Review = "Average", isLike = true }, new ProductReview() { ProductId = 14, UserId = 08, Rating = 5, Review = "Good", isLike = true }, new ProductReview() { ProductId = 15, UserId = 02, Rating = 3, Review = "Average", isLike = false }, new ProductReview() { ProductId = 16, UserId = 01, Rating = 4, Review = "nice", isLike = true }, new ProductReview() { ProductId = 17, UserId = 07, Rating = 2, Review = "Bad", isLike = false }, new ProductReview() { ProductId = 18, UserId = 03, Rating = 5, Review = "Good", isLike = true }, new ProductReview() { ProductId = 19, UserId = 10, Rating = 4, Review = "nice", isLike = true }, new ProductReview() { ProductId = 20, UserId = 10, Rating = 5, Review = "Good", isLike = true }, new ProductReview() { ProductId = 21, UserId = 10, Rating = 3, Review = "Average", isLike = true }, new ProductReview() { ProductId = 22, UserId = 13, Rating = 5, Review = "Good", isLike = true }, new ProductReview() { ProductId = 23, UserId = 15, Rating = 4, Review = "nice", isLike = true }, new ProductReview() { ProductId = 24, UserId = 12, Rating = 2, Review = "Bad", isLike = false }, new ProductReview() { ProductId = 25, UserId = 11, Rating = 4, Review = "nice", isLike = true }, }; bool check = true; dataTableForProductManagement.AddDataTable(); while (check) { Console.WriteLine("\nPlease enter 1 to print all the product details"); Console.WriteLine("Please enter 2 to get top records of data based on product ratings"); Console.WriteLine("Pleae enter 3 to get records with rating greater than 3 and product id in 1,4,9."); Console.WriteLine("please press 4 to get count of reviews grouped by user id"); Console.WriteLine("Please enter 5 to get product id and review from data"); Console.WriteLine("Please enter 6 to skip top 5 records"); Console.WriteLine("Please enter 7 to retrieve records where is like is true using data table"); Console.WriteLine("Please enter 8 to get average ratings based on user id using data table "); Console.WriteLine("Please enter 9 to get all the records for average review"); Console.WriteLine("Please enter 10 to get all records sorted for user id =10"); Console.WriteLine("Please press any other key to exit"); string option = Console.ReadLine(); switch (option) { case "1": foreach (var list in productReviewList) { Console.WriteLine("ProductId:-" + list.ProductId + " UserId:-" + list.UserId + " Ratings:-" + list.Rating + " Review:-" + list.Review + " IsLike:-" + list.isLike); } break; case "2": //UC2 productManagement.TopRecords(productReviewList); break; case "3": //UC3 productManagement.SelectedRecords(productReviewList); break; case "4": //UC4 productManagement.countOfReviews(productReviewList); break; case "5": //UC5 productManagement.retrieveProductIDandreview(productReviewList); break; case "6": //UC6 productManagement.SkippingRecords(productReviewList); break; case "7": //UC9 //dataTableForProductManagement.AddDataTable(); dataTableForProductManagement.CallForRetrievingData(); break; case "8": //UC10 productManagement.AverageRatingForUserId(productReviewList); //dataTableForProductManagement.AddDataTable(); dataTableForProductManagement.CallForAverageRatings(); break; case "9": //UC11 //dataTableForProductManagement.AddDataTable(); dataTableForProductManagement.CallForReviewRetrieval(); break; case "10": //UC12 //dataTableForProductManagement.AddDataTable(); dataTableForProductManagement.CallForSpecificUserId(); break; default: check = false; break; } } //LinqToDataTable linqToDataTable = new LinqToDataTable(); //linqToDataTable.AddDataTable(); }