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