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