Esempio n. 1
0
        public ActionResult verEstadisticas()
        {
            if (Request.Cookies["Sesion"] == null)
            {

                return RedirectToAction("Index", "Home");
            }
            else
            {
                HttpCookie aCookie = Request.Cookies["Sesion"];
                if (!aCookie["Tipo"].Equals("Coor"))
                    return RedirectToAction("Index", "Home");
                else
                    ViewBag.Texto = Server.HtmlEncode(aCookie.Values["Usuario"]);
            }
            String tipoConsulta = Request["Estadistica"];
            Asistentes_TutoresEntities db = new Asistentes_TutoresEntities();
            if (tipoConsulta == "Carrera"){
                ViewBag.GraphicName = "Asistencia por Carrera";
                ViewBag.Creategraphic = 1;
                ViewData["Valor"] = "Carrera";
                var result = db.SP_EstadisticasCarrera().ToArray();
                var json = new JavaScriptSerializer().Serialize(result);
                ViewData["json"] = json;

            }
            else if (tipoConsulta == "Curso"){
                ViewBag.GraphicName = "Asistencia por Curso";
                ViewBag.Creategraphic = 1;
                ViewData["Valor"] = "Curso";
                var result = db.SP_EstadisticasCurso().ToArray();
                var json = new JavaScriptSerializer().Serialize(result);
                ViewData["json"] = json;

            }
            else if (tipoConsulta == "Tutor"){
                ViewBag.GraphicName = "Asistencia por Tutor";
                ViewBag.Creategraphic = 1;
                ViewData["Valor"] = "Tutor";
                var result = db.SP_EstadisticasTutor().ToArray();
                var json = new JavaScriptSerializer().Serialize(result);
                ViewData["json"] = json;

            }
            else if (tipoConsulta == "Fechas"){
                ViewBag.GraphicName = "Asistencia por Rango de Fechas";
                ViewBag.Creategraphic = 1;
                ViewData["Valor"] = "Fechas";
                String fechaInicial = Request["dateStart"];
                String fechaFinal = Request["dateEnd"];
                ViewData["FI"] = Request["dateStart"];
                ViewData["FF"] = Request["dateEnd"];

                string format = "yyyy-MM-dd";
                var result = db.SP_EstadisticasFechas(DateTime.Parse(Request["dateStart"]), DateTime.Parse(Request["dateEnd"])).ToArray();
                List<Histograma> pointlist = new List<Histograma>();
                foreach (var point in result)
                {

                    Histograma p = new Histograma();
                    p.x = point.x.ToString();
                    p.date = point.Fecha.ToString(format);
                    pointlist.Add(p);

                }
                var json = new JavaScriptSerializer().Serialize(pointlist);
                ViewData["json"] = json;
                System.Diagnostics.Debug.WriteLine(json);
            }
            else{
                ViewBag.Creategraphic = 0;
            }

            return View();
        }