// GET: Ranking public ActionResult Ranking() { using (var db = new CinePlusEntities()) { var data = db.Database.SqlQuery <Ranking_Result>("EXECUTE Ranking").ToList(); ViewBag.BestPeli = data[0].TituloPelicula.ToString(); } return(View()); }
public ActionResult getImage() { using (var db = new CinePlusEntities()) { var data = db.Database.SqlQuery <Ranking_Result>("EXECUTE Ranking").ToList(); var myChart = new Chart(width: 600, height: 400) .AddTitle("Mejores peliculas") .DataBindTable(dataSource: data, xField: "TituloPelicula") .Write(); byte[] byteImage = myChart.GetBytes(); MemoryStream memo = new MemoryStream(byteImage); Image image = Image.FromStream(memo); memo = new MemoryStream(); image.Save(memo, ImageFormat.Jpeg); memo.Position = 0; return(File(memo, "image/jpg")); } }
// GET: Peliculas public ActionResult Peliculas() { List <Peliculas> lst; using (CinePlusEntities DB = new CinePlusEntities()) { lst = (from d in DB.Peliculas select new Peliculas { idPelicula = d.idPelicula, Director = d.Director, Sinopsis = d.Sinopsis, Género = d.Género, TituloPelicula = d.TituloPelicula, Calificacion = d.Calificacion, Poster = d.Poster }).ToList(); } return(View()); }