static void Main(string[] args)
{
//UC-1
Console.WriteLine("Product Review Management With Linq!");
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 = 6, Review = "Nice", isLike = true
}, new ProductReview()
{
ProductId = 1, UserId = 1, Rating = 5, Review = "Good", isLike = true
}, new ProductReview()
{
ProductId = 1, UserId = 1, Rating = 5, Review = "Good", isLike = true
}, new ProductReview()
{
ProductId = 1, UserId = 1, Rating = 5, Review = "Good", isLike = true
},
new ProductReview()
{
ProductId = 3, UserId = 3, Rating = 4, Review = "Good", isLike = true
},
new ProductReview()
{
ProductId = 4, UserId = 4, Rating = 5, Review = "Good", isLike = true
},
new ProductReview()
{
ProductId = 5, UserId = 5, Rating = 4, Review = "Good", isLike = true
},
new ProductReview()
{
ProductId = 6, UserId = 6, Rating = 3, Review = "Nice", isLike = true
},
new ProductReview()
{
ProductId = 9, UserId = 9, Rating = 8, Review = "Good", isLike = true
},
new ProductReview()
{
ProductId = 8, UserId = 8, Rating = 3, Review = "Good", isLike = true
},
new ProductReview()
{
ProductId = 9, UserId = 9, Rating = 3, Review = "Nice", isLike = true
},
new ProductReview()
{
ProductId = 4, UserId = 4, Rating = 4, Review = "Good", isLike = true
},
new ProductReview()
{
ProductId = 11, UserId = 11, Rating = 4, Review = "Good", isLike = true
},
new ProductReview()
{
ProductId = 12, UserId = 12, Rating = 9, Review = "Good", isLike = true
},
new ProductReview()
{
ProductId = 1, UserId = 1, Rating = 3, Review = "Nice", isLike = true
},
new ProductReview()
{
ProductId = 14, UserId = 14, Rating = 3, Review = "Good", isLike = true
},
new ProductReview()
{
ProductId = 15, UserId = 15, Rating = 5, Review = "Good", isLike = true
},
new ProductReview()
{
ProductId = 16, UserId = 16, Rating = 2, Review = "bad", 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);
* }*/
ProductManagement management = new ProductManagement();
//management.TopRecords(productReviewList);
// management.RetriveRecordsOnSpecificCon(productReviewList);
//management.CountOfRecordsByProductID(productReviewList);
//management.RetrieveProductIDAndReview(productReviewList);
// management.skippedTopFiveRecords(productReviewList);
ProductReviewDataTable productReviewDataTable = new ProductReviewDataTable();
DataTable dataTable = productReviewDataTable.CreateDataTableAddDefaultValues();
/*
* Retrive All records
* foreach (DataRow row in data.Rows)
* {
* Console.Write("-->");
* foreach (var item in row.ItemArray)
* {
* Console.Write(" "+item);
* }
* Console.Write("\n ");
* }*/
/*// iterate all rows.
* foreach (DataRow row in data.Rows)
* {
* Console.WriteLine(row.Field<int>(0), row.Field<int>(1), row.Field<int>(2), row.Field<string>(3), row.Field<bool>(4));
* }*/
/*foreach (DataRow row in data.Rows)
* {
* foreach (var item in row.ItemArray)
* {
* bool islike = row.Field<bool>(4);
* if (islike == true)
* {
* Console.Write(" " + item);
* }
* }
* Console.Write("\n ");
* }*/
//management.retriveRecordsWhohaveLikeValueTrue(dataTable);
//management.calAverageRatingOfEachProductID(dataTable);
//management.RetrievRecordsReviewIsNice(dataTable);
management.RetrievPerticularUserIDRecords(dataTable);
}
/// <summary>
/// Defines the entry point of the application.
/// </summary>
/// <param name="args">The arguments.</param>
static void Main(string[] args)
{
Console.WriteLine("Welcome to product review mangaement with linq");
/// Created instances of object class
ProductManagement productManagement = new ProductManagement();
/// Created a list
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 = "Good", isLike = true
},
new ProductReview()
{
ProductId = 3, UserId = 3, Rating = 5, Review = "Good", isLike = true
},
new ProductReview()
{
ProductId = 4, UserId = 4, Rating = 5, Review = "Good", isLike = true
},
new ProductReview()
{
ProductId = 5, UserId = 5, Rating = 4, Review = "Good", isLike = true
},
new ProductReview()
{
ProductId = 6, UserId = 6, Rating = 5, Review = "Good", isLike = true
},
new ProductReview()
{
ProductId = 7, UserId = 7, Rating = 5, Review = "bad", isLike = true
},
new ProductReview()
{
ProductId = 8, UserId = 8, Rating = 5, Review = "Good", isLike = true
},
new ProductReview()
{
ProductId = 9, UserId = 9, Rating = 5, Review = "nice", isLike = true
},
new ProductReview()
{
ProductId = 10, UserId = 10, Rating = 4, Review = "Good", isLike = false
},
new ProductReview()
{
ProductId = 11, UserId = 10, Rating = 4, Review = "nice", isLike = true
},
new ProductReview()
{
ProductId = 12, UserId = 10, Rating = 5, Review = "Good", isLike = true
},
new ProductReview()
{
ProductId = 13, UserId = 11, Rating = 2, Review = "Good", isLike = false
},
new ProductReview()
{
ProductId = 14, UserId = 12, Rating = 5, Review = "nice", isLike = true
},
new ProductReview()
{
ProductId = 15, UserId = 13, Rating = 3, Review = "Good", isLike = false
},
new ProductReview()
{
ProductId = 16, UserId = 13, Rating = 4, Review = "nice", isLike = true
},
new ProductReview()
{
ProductId = 17, UserId = 13, Rating = 4, Review = "Good", isLike = true
},
new ProductReview()
{
ProductId = 18, UserId = 14, Rating = 5, Review = "Good", isLike = false
},
new ProductReview()
{
ProductId = 19, UserId = 15, Rating = 5, Review = "Good", isLike = false
},
new ProductReview()
{
ProductId = 20, UserId = 16, Rating = 5, Review = "nice", isLike = false
},
new ProductReview()
{
ProductId = 21, UserId = 17, Rating = 4, Review = "Good", isLike = false
},
new ProductReview()
{
ProductId = 22, UserId = 10, Rating = 5, Review = "Good", isLike = false
},
new ProductReview()
{
ProductId = 23, UserId = 18, Rating = 5, Review = "Good", isLike = false
},
new ProductReview()
{
ProductId = 24, UserId = 20, Rating = 5, Review = "Good", isLike = false
},
new ProductReview()
{
ProductId = 25, UserId = 20, Rating = 5, Review = "Good", isLike = false
},
};
/// UC1
/// Iterating through list.
//foreach (var list in productReviewList)
//{
// Console.WriteLine("ProductId :-" + list.ProductId + " " + "UserId:-" + list.UserId + " " + "Rating :-" + " " + list.Rating + " "
// + "Review :-" + list.Review + " " + "isLike :-" + list.isLike);
//}
/// Retrieve records Having same user id with ratings
productManagement.RetrieveRecordsHavingSameUserIdwithRatings();
}