//obtinene los tickets entre fechas para generar el reporte.
        public ActionResult Get_Events_By_Dates()
        {
            DateTime         F_INICIO = DateTime.Now.AddDays(-7);
            DateTime         F_FIN    = DateTime.Now;
            TicketController tc       = new TicketController();
            List <Ticket>    list     = tc.Get_Tickets_By_Dates(F_INICIO, F_FIN, "E", "C", "I", "T");

            TempData["f_inicio"] = F_INICIO.ToString("MM/dd/yyyy");
            TempData["f_fin"]    = F_FIN.ToString("MM/dd/yyyy");
            return(View(list));
        }
        public JsonResult Get_Events_By_Dates_Json(string date_start = "", string date_end = "", string filter = "", string t_fecha = "", string t_movimiento = "", string t_estatus = "")
        {
            DateTime F_INICIO = DateTime.Now;
            DateTime F_FIN    = DateTime.Now;

            if (date_start == "" && date_end == "")
            {
                F_INICIO = DateTime.Now.AddDays(-7);
                F_FIN    = DateTime.Now;
            }
            else
            {
                string format = "MM/dd/yyyy";
                F_INICIO = DateTime.ParseExact(date_start, format, CultureInfo.InvariantCulture);
                F_FIN    = DateTime.ParseExact(date_end, format, CultureInfo.InvariantCulture);
            }
            TicketController tc   = new TicketController();
            List <Ticket>    list = tc.Get_Tickets_By_Dates(F_INICIO, F_FIN, filter, t_fecha, t_movimiento, t_estatus);

            return(Json(list));
        }