static void Main(string[] args) { Console.WriteLine("Welcome to Product Review Management"); ///List of ProductDetails List <ProductReview> productReviewList = new List <ProductReview>() { new ProductReview() { ProductID = 1, UserID = 2, Rating = 6, Review = "Average", isLike = true }, new ProductReview() { ProductID = 2, UserID = 5, Rating = 6, Review = "Good", isLike = false }, new ProductReview() { ProductID = 3, UserID = 10, Rating = 6, Review = "Bad", isLike = true }, new ProductReview() { ProductID = 4, UserID = 2, Rating = 6, Review = "Average", isLike = true }, new ProductReview() { ProductID = 5, UserID = 2, Rating = 6, Review = "Average", isLike = false }, new ProductReview() { ProductID = 6, UserID = 2, Rating = 6, Review = "Good", isLike = true }, new ProductReview() { ProductID = 7, UserID = 2, Rating = 6, Review = "Bad", isLike = false }, new ProductReview() { ProductID = 8, UserID = 2, Rating = 6, Review = "Bad", isLike = true }, new ProductReview() { ProductID = 9, UserID = 2, Rating = 6, Review = "Excellent", isLike = true }, new ProductReview() { ProductID = 10, UserID = 2, Rating = 6, Review = "Average", isLike = true }, new ProductReview() { ProductID = 11, UserID = 2, Rating = 6, Review = "Bad", isLike = false }, new ProductReview() { ProductID = 12, UserID = 2, Rating = 6, Review = "Bad", isLike = true }, new ProductReview() { ProductID = 13, UserID = 2, Rating = 6, Review = "Average", isLike = true }, new ProductReview() { ProductID = 14, UserID = 2, Rating = 6, Review = "Average", isLike = false }, new ProductReview() { ProductID = 15, UserID = 2, Rating = 6, Review = "Good", isLike = false }, new ProductReview() { ProductID = 16, UserID = 2, Rating = 6, Review = "Good", isLike = false }, new ProductReview() { ProductID = 17, UserID = 2, Rating = 6, Review = "Average", isLike = true }, new ProductReview() { ProductID = 18, UserID = 2, Rating = 6, Review = "Average", isLike = true }, new ProductReview() { ProductID = 19, UserID = 2, Rating = 6, Review = "Bad", isLike = false }, new ProductReview() { ProductID = 20, UserID = 2, Rating = 6, Review = "Good", isLike = true }, new ProductReview() { ProductID = 21, UserID = 2, Rating = 6, Review = "Good", isLike = false }, new ProductReview() { ProductID = 22, UserID = 2, Rating = 6, Review = "Bad", isLike = true }, new ProductReview() { ProductID = 23, UserID = 2, Rating = 6, Review = "Average", isLike = true }, new ProductReview() { ProductID = 24, UserID = 2, Rating = 6, Review = "Average", isLike = false }, new ProductReview() { ProductID = 25, UserID = 2, Rating = 6, Review = "Average", isLike = true } }; ///ProductReviewRepository productReviewRepository = new ProductReviewRepository(); ///productReviewRepository.GetTopThreeProducts(productReviewList); ///productReviewRepository.RetrieveProductsForCondition(productReviewList); ///productReviewRepository.CountByProductID(productReviewList); ///productReviewRepository.GetProductIDAndReview(productReviewList); ///productReviewRepository.SkipTopFive(productReviewList); ///productReviewRepository.GetProductIDAndReviewUsingSelect(productReviewList); ProductReviewDataTable productReviewDataTable = new ProductReviewDataTable(); productReviewDataTable.CreateDataTable(); /// productReviewDataTable.RetrieveDataWithIsLike(); ///productReviewDataTable.AverageRatingByProductID(); ///productReviewDataTable.RetrieveDataWithReview(); productReviewDataTable.RetrieveDataWithUserID(); }
static void Main(string[] args) { Console.WriteLine("Welcome to product review management!\n"); //UC 1 List <ProductReview> productReviewList = new List <ProductReview>() { new ProductReview() { ProductID = 1, UserID = 1, Rating = 5, Review = "Excellent", IsLike = true }, new ProductReview() { ProductID = 5, UserID = 10, Rating = 1, Review = "Poor ", IsLike = false }, new ProductReview() { ProductID = 3, UserID = 3, Rating = 3, Review = "Average ", IsLike = true }, new ProductReview() { ProductID = 3, UserID = 6, Rating = 5, Review = "Excellent", IsLike = true }, new ProductReview() { ProductID = 2, UserID = 2, Rating = 4, Review = "Good ", IsLike = true }, new ProductReview() { ProductID = 4, UserID = 7, Rating = 4, Review = "Good ", IsLike = true }, new ProductReview() { ProductID = 2, UserID = 8, Rating = 3, Review = "Average ", IsLike = true }, new ProductReview() { ProductID = 4, UserID = 4, Rating = 2, Review = "Satisfactory", IsLike = false }, new ProductReview() { ProductID = 1, UserID = 9, Rating = 2, Review = "Satisfactory", IsLike = false }, new ProductReview() { ProductID = 9, UserID = 5, Rating = 1, Review = "Poor ", IsLike = false } }; //Printing all contents of the list foreach (var v in productReviewList) { Console.WriteLine($"ProductID:{v.ProductID}\tUserID:{v.UserID}\tRating:{v.Rating}\tReview:{v.Review}\tIsLike:{v.IsLike}"); } //UC 2 ProductManagement.RetrieveTopThreeHighRatedRecords(productReviewList); //UC 3 ProductManagement.RetrieveRecordsWithGreaterThanThreeRating(productReviewList); //UC 4 ProductManagement.RetrieveCountOfReviewsForEachProductID(productReviewList); //UC 5 ProductManagement.RetrieveOnlyProductIDAndReviewOfAllRecords(productReviewList); //UC 6 ProductManagement.SkipTopFiveRecordsAndDisplayOthers(productReviewList); //UC 7 ProductManagement.RetrieveOnlyProductIDAndReviewOfAllRecordsUsingSelect(productReviewList); //UC 8 ProductReviewDataTable.AddDataIntoDataTable(); //UC 9 ProductReviewDataTable.RetrieveAllRecordsWhoseIsLikeIsTrue(); //UC 10 ProductReviewDataTable.FindAverageRatingForEachProductId(); //UC 11 ProductReviewDataTable.RetrieveRecordsWithParticularReviewMessage(); //UC 12 ProductReviewDataTable.RetrieveRecordsForGivenUserIdSortedByRating(); Console.ReadLine(); }
static void Main(string[] args) { Console.WriteLine("Welcome to Product Review Management Project"); 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 = 8, Review = "Nice", isLike = true }, new ProductReview() { ProductID = 3, UserID = 3, Rating = 4, Review = "Good", isLike = true }, new ProductReview() { ProductID = 4, UserID = 4, Rating = 1, Review = "Not Good", isLike = false }, new ProductReview() { ProductID = 5, UserID = 5, Rating = 5, Review = "Good", isLike = true }, new ProductReview() { ProductID = 6, UserID = 6, Rating = 5, Review = "Good", isLike = true }, new ProductReview() { ProductID = 7, UserID = 7, Rating = 8, Review = "Nice", isLike = true }, new ProductReview() { ProductID = 8, UserID = 8, Rating = 7, Review = "Good", isLike = true }, new ProductReview() { ProductID = 9, UserID = 9, Rating = 10, Review = "Nice", isLike = true }, new ProductReview() { ProductID = 10, UserID = 10, Rating = 4.7, Review = "Good", isLike = true }, new ProductReview() { ProductID = 10, UserID = 11, Rating = 5, Review = "Good", isLike = true }, new ProductReview() { ProductID = 12, UserID = 12, Rating = 5.6, Review = "Good", isLike = true }, new ProductReview() { ProductID = 12, UserID = 13, Rating = 4, Review = "Good", isLike = true }, new ProductReview() { ProductID = 14, UserID = 14, Rating = 2, Review = "Not Good", isLike = false }, new ProductReview() { ProductID = 14, UserID = 15, Rating = 5, Review = "Good", isLike = true }, new ProductReview() { ProductID = 16, UserID = 16, Rating = 2.5, Review = "Good", isLike = true }, new ProductReview() { ProductID = 17, UserID = 17, Rating = 9, Review = "Nice", isLike = true }, new ProductReview() { ProductID = 18, UserID = 18, Rating = 7, Review = "Good", isLike = true }, new ProductReview() { ProductID = 19, UserID = 19, Rating = 10, Review = "Nice", isLike = true }, new ProductReview() { ProductID = 20, UserID = 20, Rating = 5, Review = "Good", isLike = true }, new ProductReview() { ProductID = 21, UserID = 21, Rating = 5, Review = "Good", isLike = true }, new ProductReview() { ProductID = 22, UserID = 22, Rating = 1.3, Review = "Not Good", isLike = false }, new ProductReview() { ProductID = 22, UserID = 23, Rating = 4, Review = "Good", isLike = true }, new ProductReview() { ProductID = 24, UserID = 24, Rating = 2, Review = "Not Good", isLike = false }, new ProductReview() { ProductID = 25, UserID = 25, Rating = 9, Review = "Nice", isLike = true }, }; foreach (var list in productReviewList) { Console.WriteLine("\n-----------------"); Console.Write("\nProductID " + list.ProductID + "\nUserID " + list.UserID + "\nRating " + list.Rating + "\nReview " + list.Review + "\nisLike " + list.isLike); Console.WriteLine("\n-----------------"); } ProductReviewManagement management = new ProductReviewManagement(); management.TopRecords(productReviewList); management.SelectedRecords(productReviewList); management.RetrieveCountOfRecords(productReviewList); management.RetrieveProductIDAndReviewFromList(productReviewList); management.DisplayUnskippedRecords(productReviewList); Console.WriteLine("\n*****************************DataTable Operations*************************"); ProductReviewDataTable reviewDataTable = new ProductReviewDataTable(); DataTable table = reviewDataTable.CreateDataBleAndAddDefaultValues(); reviewDataTable.DisplayDataTableRecordsWithIsLikeValueTrue(table); reviewDataTable.FindAverageRatingOfEachProductID(table); reviewDataTable.RetrievRecordsWhoseReviewIsNice(table); reviewDataTable.RetrievRecordsOfPerticularUserID(table); }