public static ProductCollection GetAllProducts()
{
ProductCollection products = new ProductCollection();
List <GetAllProductsDistinct_Result> result = new List <GetAllProductsDistinct_Result>();
using (FreeMarketEntities db = new FreeMarketEntities())
{
result = db.GetAllProductsDistinct()
.ToList();
products = SetAllProductDataDistinct(result);
return(products);
}
}
public static ProductCollection GetMostPopularProducts()
{
ProductCollection products = new ProductCollection();
List <GetAllProductsDistinct_Result> result = new List <GetAllProductsDistinct_Result>();
using (FreeMarketEntities db = new FreeMarketEntities())
{
result = db.GetAllProductsDistinct()
.ToList();
products = SetAllProductDataDistinct(result);
products.Products = products.Products
.Where(c => c.NumberSold != 0)
.OrderByDescending(c => c.NumberSold)
.Take(12)
.ToList();
return(products);
}
}
public RatingsInfo()
{
ProductRatings = new List <ProductReview>();
AverageRatings = new Dictionary <Product, Dictionary <string, int> >();
CourierRatings = new Dictionary <Courier, int>();
using (FreeMarketEntities db = new FreeMarketEntities())
{
ProductRatings = db.GetAllProductsReview()
.Select(c => new ProductReview
{
Approved = c.Approved,
Author = c.Author,
CourierName = c.CourierName,
CourierRating = c.CourierRating ?? 0,
CourierReviewId = c.CourierReviewId,
CourierReviewContent = c.CourierRatingReview,
Date = c.Date,
DeliveryCity = c.DeliveryAddressCity,
OrderNumber = c.OrderNumber,
Price = c.Price,
PriceRating = c.PriceRating,
ProductName = c.Description,
ProductNumber = c.ProductNumber,
Quantity = c.Quantity,
ReviewContent = c.ReviewContent,
ReviewId = c.ReviewId,
ShippingTotal = c.ShippingTotal ?? 0,
StarRating = c.StarRating,
SupplierName = c.SupplierName,
SupplierNumber = c.SupplierNumber,
TotalOrderValue = c.TotalOrderValue,
UserId = c.UserId
}).ToList();
if (ProductRatings == null)
{
ProductRatings = new List <ProductReview>();
}
List <GetAllProductsDistinct_Result> products = db.GetAllProductsDistinct()
.ToList();
if (products != null && products.Count > 0)
{
foreach (GetAllProductsDistinct_Result product in products)
{
Product fullProduct = Product.GetShallowProduct(product.ProductNumber, product.SupplierNumber);
if (fullProduct != null && fullProduct.Activated == true)
{
double qualityRating = db.ProductReviews
.Where(c => c.ProductNumber == product.ProductNumber && c.SupplierNumber == product.SupplierNumber)
.Average(m => m.StarRating) ?? 0;
double priceRating = db.ProductReviews
.Where(c => c.ProductNumber == product.ProductNumber && c.SupplierNumber == product.SupplierNumber)
.Average(m => m.PriceRating) ?? 0;
int countReviews = db.ProductReviews
.Where(c => c.ProductNumber == product.ProductNumber && c.SupplierNumber == product.SupplierNumber)
.Count();
fullProduct.ProductReviewsCount = countReviews;
if (!AverageRatings.ContainsKey(fullProduct))
{
Dictionary <string, int> qualityInfo = new Dictionary <string, int>();
qualityInfo.Add("Quality", (int)qualityRating);
AverageRatings.Add(fullProduct, qualityInfo);
Dictionary <string, int> priceInfo = new Dictionary <string, int>();
priceInfo.Add("Price", (int)priceRating);
AverageRatings[fullProduct].Add("Price", (int)priceRating);
}
}
}
}
List <CourierReview> courierReviews = db.GetAllCouriersReviewList()
.Select(c => new CourierReview
{
StarRating = c.StarRating,
CourierNumber = c.CourierNumber,
CourierName = c.CourierName
})
.ToList();
foreach (Courier courier in db.Couriers)
{
double courierRating = courierReviews
.Where(c => c.CourierNumber == courier.CourierNumber)
.Average(m => m.StarRating) ?? 0;
int countCouriers = db.CourierReviews
.Where(c => c.CourierNumber == courier.CourierNumber)
.Count();
courier.CourierReviewsCount = countCouriers;
if (!CourierRatings.ContainsKey(courier))
{
CourierRatings.Add(courier, (int)courierRating);
}
else
{
CourierRatings[courier] = (int)courierRating;
}
}
}
}