public MostWantedPizzaViewModel GetMostWantedPizza()
{
SqlDataReader reader = this.ExecuteReader(
@"SELECT TOP 1 p.Id,
p.Name,
p.Description,
p.PicturePath,
sales.Count
FROM (SELECT p.Id, COUNT(po.PizzaId) AS Count
FROM Pizzas AS p
JOIN PizzaOrders AS po
ON po.PizzaId = p.Id
GROUP BY p.Id
) AS sales
JOIN Pizzas AS p
ON sales.Id = p.Id
ORDER BY sales.Count DESC");
using (reader)
{
if (reader.Read())
{
int pizzaId = reader.GetInt32(0);
string pizzaName = reader.GetString(1);
string description = reader.GetString(2);
string picturePath = reader.GetString(3);
int salesCount = reader.GetInt32(4);
MostWantedPizzaViewModel pizza = new MostWantedPizzaViewModel(pizzaId, pizzaName, description, picturePath, salesCount);
return(pizza);
}
return(null);
}
}
public MostWantedPizzaViewModel GetMostWantedPizza()
{
using (this.pizzaRepository)
{
MostWantedPizzaViewModel pizza = this.pizzaRepository.GetMostWantedPizza();
return(pizza);
}
}
public ActionResult MostWantedPizza()
{
MostWantedPizzaViewModel pizza = this.pizzaManager.GetMostWantedPizza();
return(this.PartialView(pizza));
}
