public static List <String> processData(IEnumerable <string> lines)
{
List <String> retVal = new List <String>();
List <DiscountProduct> discountProducts = new List <DiscountProduct>();
List <BuyersData> ConvertedData = BuyersData.GetConvertedData(lines);
IEnumerable <string> DistinctProducts = ConvertedData.Select(x => x.ProductName).Distinct();
var q1 = from b in ConvertedData select b;
var q2 = (from b in ConvertedData select b).ToArray();
foreach (string product in DistinctProducts)
{
var minPrice = ConvertedData.Where(x => x.ProductName == product).Min(p => p.Price);
var maxPrice = ConvertedData.Where(x => x.ProductName == product).Max(p => p.Price);
if (minPrice != maxPrice)
{
DiscountProduct discountProduct = new DiscountProduct();
discountProduct.ProductName = product;
discountProduct.MinPrice = minPrice;
discountProduct.MaxPrice = maxPrice;
discountProducts.Add(discountProduct);
}
}
foreach (DiscountProduct discountProduct in discountProducts)
{
var customerName = ConvertedData.FirstOrDefault(x =>
x.Price == discountProduct.MinPrice && x.ProductName == discountProduct.ProductName)
.CustomerName;
var sometimesBroughtOnHigherPrice = false;
foreach (DiscountProduct innerLoop in discountProducts)
{
sometimesBroughtOnHigherPrice = ConvertedData.Any(x =>
x.CustomerName == customerName &&
x.ProductName == innerLoop.ProductName &&
x.Price == innerLoop.MaxPrice);
if (sometimesBroughtOnHigherPrice)
{
break;
}
}
if (!sometimesBroughtOnHigherPrice)
{
retVal.Add(customerName);
}
}
return(retVal);
}
