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