private async void ObtenerVideoDevices() { var camaras = await Camaras.ObtenerCamaras(); listaCamaras = camaras.ToList <Tuple <string, string> >(); lstBoxCamaras.ItemsSource = camaras; }
private void GrabarVideo() { AVIWriter grabadorVideo = new AVIWriter(); try { Bitmap imagen = Camaras.CapturarImagen(visorCamara1); DateTime Hoy = DateTime.Now; string fecha_actual = Hoy.ToString("dd-MM-yyyy HH-mm-ss"); grabadorVideo.Open(rutaCapturas + "\\video_" + fecha_actual + ".avi", imagen.Width, imagen.Height); while (true) { if (grabandoVideo1) { grabadorVideo.AddFrame(Camaras.CapturarImagen(visorCamara1)); Thread.Sleep(50); } else { break; } } grabadorVideo.Close(); } catch (Exception) { grabadorVideo.Close(); } }
//Se inician múltiples hilos del programa y se ejecutan en segundo plano private void Form1_Load(object sender, EventArgs e) { this.Icon = EstacionControl.Properties.Resources.icono_tmmx_nuevo; colorCampos = indicador_temperatura.BackColor; socketConector = new ConectividadRemota(direccion_ip_texto.Text); socketReceptor = new ConectividadRemota(direccion_ip_texto.Text, 7001); controles = new ControlXBOX(socketConector, this); giroscopio = new Giroscopio(socketReceptor); //Hilo para manejar el control de XBOX ONE actualizarControles = new Thread(new ThreadStart(controles.ActualizarEstadoOrdenes)) { IsBackground = true }; //Hilo de verificación de comunicación de dispositivos periféricos remotos dispositivosRemotos = new Thread(new ThreadStart(ComprobarDispositivosRemotos)) { IsBackground = true }; dispositivosRemotos.Priority = ThreadPriority.AboveNormal; //Hilo de verificación de comunicación de dispositivos periféricos locales Thread verifConectividad = new Thread(new ThreadStart(ComprobarDispositivosLocales)) { IsBackground = true }; verifConectividad.Start(); PintarElementos(); //-------------------------------------------// Giroscopio.mybitmap2.MakeTransparent(Color.Yellow); // Sets image transparency Giroscopio.mybitmap4.MakeTransparent(Color.Yellow); // Sets image transparency lista_camaras1.Click += Lista_camaras1_Click; lista_camaras2.Click += Lista_camaras2_Click; Camaras.InicializarCamaras(); Camaras.AgregarCamarasIniciales(); foreach (var camara in Camaras.listaCamaras) { lista_camaras1.Items.Add(camara.Value); lista_camaras2.Items.Add(camara.Value); } lista_camaras1.SelectedIndex = 0; lista_camaras2.SelectedIndex = 1; }
private void botonReconociento_Click(object sender, EventArgs e) { Stopwatch a = new Stopwatch(); ClasificacionFiguras clasificador = new ClasificacionFiguras(); Bitmap bitmap = Camaras.CapturarImagen(visorCamara1); if (bitmap != null) { a.Start(); bitmap = BitMaps.DrawAsNegative(bitmap); EspeciesReconocidas especiesReconocidas = new EspeciesReconocidas(clasificador.ProcesarImagen(bitmap), cantidadFiguras); a.Stop(); especiesReconocidas.ShowDialog(); log.Info("Tiempo de identificación: " + (double)a.ElapsedMilliseconds / 1000); } }
//Se inician múltiples hilos del programa y se ejecutan en segundo plano private void Form1_Load(object sender, EventArgs e) { Icon = EstacionControl.Properties.Resources.icono_tmmx_nuevo; colorCampos = indicador_temperatura.BackColor; socketConector = new ConectividadRemota(direccion_ip_texto.Text); socketReceptor = new ConectividadRemota(direccion_ip_texto.Text, 7001); controles = new ControlXBOX(socketConector, this); giroscopio = new Giroscopio(socketReceptor); //Hilo para manejar el control de XBOX ONE CrearThreads(ListaThreads.actualizarControles); #if DEBUG //Hilo de verificación de comunicación de dispositivos periféricos remotos CrearThreads(ListaThreads.dispositivosRemotos); #endif //Hilo de verificación de comunicación de dispositivos periféricos locales CrearThreads(ListaThreads.verifConectividad); PintarElementos(); //-------------------------------------------// Giroscopio.mybitmap2.MakeTransparent(Color.Yellow); // Sets image transparency Giroscopio.mybitmap4.MakeTransparent(Color.Yellow); // Sets image transparency lista_camaras1.Click += Lista_camaras1_Click; lista_camaras2.Click += Lista_camaras2_Click; Camaras.InicializarCamaras(); Camaras.AgregarCamarasIniciales(); foreach (var camara in Camaras.listaCamaras) { lista_camaras1.Items.Add(camara.Value); lista_camaras2.Items.Add(camara.Value); } lista_camaras1.SelectedIndex = 0; lista_camaras2.SelectedIndex = 1; }
private void Boton_fotografia_Click(object sender, EventArgs e) //Método para tomar fotografía y almacenarla en disco { Bitmap foto = Camaras.CapturarImagen(visorCamara1); Camaras.TomarFotografia(foto); }
public IHttpActionResult todasLasCamaras(string id) { if (id == null) { id = "Malvinas"; } var ip = _context.Systems.SingleOrDefault(m => m.Nombre == id).IpSystem;; var listastring = new List <String>(); var Lista = new List <ListIntListString>(); var camaras = new List <Camaras>(); if (id != "Caba") { string connString = ("Data Source=" + ip + " ; User ID =evtAdmin;Password=a"); //string connString = @"Data Source = 10.200.3.120\XDR; User ID =evtAdmin;Password=a"; //string connString = @"Data Source = 10.200.3.120\XDR; User ID =evtAdmin;Password=a"; //connString.Remove(21,1); try { using (SqlConnection conn = new SqlConnection(connString)) { //retrieve the SQL Server instance version string query = @"SELECT InputChannels.InputChannelIdentity ,InputChannels.DeviceIdentity ,InputChannels.Name As NombreCanal ,InputChannels.StorageDrive ,InputChannels.StorageDrive2 ,InputChannels.MaxRetentionDays ,InputChannels.MaxRetentionDays2 ,Devices.NodeIdentity ,Devices.DeviceIdentity ,Devices.Name As DeviceName ,Devices.UserName ,Devices.Password ,Devices.EndPointIpAddress ,Nodes.NodeIdentity ,Nodes.Name As NodoNombre FROM [EVT]. [dbo].[InputChannels] INNER JOIN [EVT]. [dbo].[Devices] ON InputChannels.DeviceIdentity=Devices.DeviceIdentity INNER JOIN [EVT]. [dbo].[Nodes] ON Devices.NodeIdentity=Nodes.NodeIdentity ;"; SqlCommand cmd = new SqlCommand(query, conn); //open connection conn.Open(); //execute the SQLCommand SqlDataReader dr = cmd.ExecuteReader(); //check if there are records if (dr.HasRows) { var nombreCamara = dr.GetOrdinal("DeviceName"); var channelname = dr.GetOrdinal("NombreCanal"); var Ip = dr.GetOrdinal("EndPointIpAddress"); var Username = dr.GetOrdinal("Username"); var Password = dr.GetOrdinal("Password"); var StorageDrive = dr.GetOrdinal("StorageDrive"); var StorageDrive2 = dr.GetOrdinal("StorageDrive2"); var Retention = dr.GetOrdinal("MaxRetentionDays"); var Retention2 = dr.GetOrdinal("MaxRetentionDays2"); var NodoNombre = dr.GetOrdinal("NodoNombre"); // var NodoNombre = dr.GetOrdinal("NodoNombre"); while (dr.Read()) { //display retrieved record (first column only/string value) //var camara = dr.GetString(0); //var camara = listastring.Add(dr["Name"].ToString()); //listastring.Add(dr.GetString(0)); var camaraNombre = new Camaras { NombreCamara = dr.GetString(nombreCamara), ChannelName = dr.GetString(channelname), Ip = dr.GetString(Ip), Usuario = dr.GetString(Username), Pass = dr.GetString(Password), StorageDrive = dr.GetString(StorageDrive), StorageDrive2 = dr.GetString(StorageDrive2), Retention = dr.GetInt32(Retention).ToString(), Retention2 = dr.GetInt32(Retention2).ToString(), NodoNombre = dr.GetString(NodoNombre) }; camaras.Add(camaraNombre); } } else { Console.WriteLine("No data found."); } dr.Close(); } } catch (Exception ex) { //display error message Console.WriteLine("Exception: " + ex.Message); } } else { #region Caba1A //string connString = @"Data Source = 10.200.3.120\XDR; User ID =evtAdmin;Password=a"; string connString = @"Data Source = 172.23.31.116\XDR; User ID =evtAdmin;Password=a"; //connString.Remove(21,1); try { using (SqlConnection conn = new SqlConnection(connString)) { //retrieve the SQL Server instance version string query = @"SELECT InputChannels.InputChannelIdentity ,InputChannels.DeviceIdentity ,InputChannels.Name As NombreCanal ,InputChannels.StorageDrive ,InputChannels.StorageDrive2 ,InputChannels.MaxRetentionDays ,InputChannels.MaxRetentionDays2 ,Devices.NodeIdentity ,Devices.DeviceIdentity ,Devices.Name As DeviceName ,Devices.UserName ,Devices.Password ,Devices.EndPointIpAddress ,Nodes.NodeIdentity ,Nodes.Name As NodoNombre FROM [EVT]. [dbo].[InputChannels] INNER JOIN [EVT]. [dbo].[Devices] ON InputChannels.DeviceIdentity=Devices.DeviceIdentity INNER JOIN [EVT]. [dbo].[Nodes] ON Devices.NodeIdentity=Nodes.NodeIdentity ;"; SqlCommand cmd = new SqlCommand(query, conn); //open connection conn.Open(); //execute the SQLCommand SqlDataReader dr = cmd.ExecuteReader(); //check if there are records if (dr.HasRows) { var nombreCamara = dr.GetOrdinal("DeviceName"); var channelname = dr.GetOrdinal("NombreCanal"); var Ip = dr.GetOrdinal("EndPointIpAddress"); var Username = dr.GetOrdinal("Username"); var Password = dr.GetOrdinal("Password"); var StorageDrive = dr.GetOrdinal("StorageDrive"); var StorageDrive2 = dr.GetOrdinal("StorageDrive2"); var Retention = dr.GetOrdinal("MaxRetentionDays"); var Retention2 = dr.GetOrdinal("MaxRetentionDays2"); var NodoNombre = dr.GetOrdinal("NodoNombre"); // var NodoNombre = dr.GetOrdinal("NodoNombre"); while (dr.Read()) { //display retrieved record (first column only/string value) //var camara = dr.GetString(0); //var camara = listastring.Add(dr["Name"].ToString()); //listastring.Add(dr.GetString(0)); var camaraNombre = new Camaras { NombreCamara = dr.GetString(nombreCamara), ChannelName = dr.GetString(channelname), Ip = dr.GetString(Ip), Usuario = dr.GetString(Username), Pass = dr.GetString(Password), StorageDrive = dr.GetString(StorageDrive), StorageDrive2 = dr.GetString(StorageDrive2), Retention = dr.GetInt32(Retention).ToString(), Retention2 = dr.GetInt32(Retention2).ToString(), NodoNombre = dr.GetString(NodoNombre), System = "Caba 1A" }; camaras.Add(camaraNombre); } } else { Console.WriteLine("No data found."); } dr.Close(); } } catch (Exception ex) { //display error message Console.WriteLine("Exception: " + ex.Message); } #endregion #region Caba1B //string connString = @"Data Source = 10.200.3.120\XDR; User ID =evtAdmin;Password=a"; string connStringB = @"Data Source = 172.23.31.118\XDR; User ID =evtAdmin;Password=a"; //connString.Remove(21,1); try { using (SqlConnection conn = new SqlConnection(connStringB)) { //retrieve the SQL Server instance version string query = @"SELECT InputChannels.InputChannelIdentity ,InputChannels.DeviceIdentity ,InputChannels.Name As NombreCanal ,InputChannels.StorageDrive ,InputChannels.StorageDrive2 ,InputChannels.MaxRetentionDays ,InputChannels.MaxRetentionDays2 ,Devices.NodeIdentity ,Devices.DeviceIdentity ,Devices.Name As DeviceName ,Devices.UserName ,Devices.Password ,Devices.EndPointIpAddress ,Nodes.NodeIdentity ,Nodes.Name As NodoNombre FROM [EVT]. [dbo].[InputChannels] INNER JOIN [EVT]. [dbo].[Devices] ON InputChannels.DeviceIdentity=Devices.DeviceIdentity INNER JOIN [EVT]. [dbo].[Nodes] ON Devices.NodeIdentity=Nodes.NodeIdentity ;"; SqlCommand cmd = new SqlCommand(query, conn); //open connection conn.Open(); //execute the SQLCommand SqlDataReader dr = cmd.ExecuteReader(); //check if there are records if (dr.HasRows) { var nombreCamara = dr.GetOrdinal("DeviceName"); var channelname = dr.GetOrdinal("NombreCanal"); var Ip = dr.GetOrdinal("EndPointIpAddress"); var Username = dr.GetOrdinal("Username"); var Password = dr.GetOrdinal("Password"); var StorageDrive = dr.GetOrdinal("StorageDrive"); var StorageDrive2 = dr.GetOrdinal("StorageDrive2"); var Retention = dr.GetOrdinal("MaxRetentionDays"); var Retention2 = dr.GetOrdinal("MaxRetentionDays2"); var NodoNombre = dr.GetOrdinal("NodoNombre"); // var NodoNombre = dr.GetOrdinal("NodoNombre"); while (dr.Read()) { //display retrieved record (first column only/string value) //var camara = dr.GetString(0); //var camara = listastring.Add(dr["Name"].ToString()); //listastring.Add(dr.GetString(0)); var camaraNombre = new Camaras { NombreCamara = dr.GetString(nombreCamara), ChannelName = dr.GetString(channelname), Ip = dr.GetString(Ip), Usuario = dr.GetString(Username), Pass = dr.GetString(Password), StorageDrive = dr.GetString(StorageDrive), StorageDrive2 = dr.GetString(StorageDrive2), Retention = dr.GetInt32(Retention).ToString(), Retention2 = dr.GetInt32(Retention2).ToString(), NodoNombre = dr.GetString(NodoNombre), System = "Caba 1B" }; camaras.Add(camaraNombre); } } else { Console.WriteLine("No data found."); } dr.Close(); } } catch (Exception ex) { //display error message Console.WriteLine("Exception: " + ex.Message); } #endregion #region Caba2 //string connString = @"Data Source = 10.200.3.120\XDR; User ID =evtAdmin;Password=a"; string connString2 = @"Data Source = 172.23.31.120\XDR; User ID =evtAdmin;Password=a"; //connString.Remove(21,1); try { using (SqlConnection conn = new SqlConnection(connString2)) { //retrieve the SQL Server instance version string query = @"SELECT InputChannels.InputChannelIdentity ,InputChannels.DeviceIdentity ,InputChannels.Name As NombreCanal ,InputChannels.StorageDrive ,InputChannels.StorageDrive2 ,InputChannels.MaxRetentionDays ,InputChannels.MaxRetentionDays2 ,Devices.NodeIdentity ,Devices.DeviceIdentity ,Devices.Name As DeviceName ,Devices.UserName ,Devices.Password ,Devices.EndPointIpAddress ,Nodes.NodeIdentity ,Nodes.Name As NodoNombre FROM [EVT]. [dbo].[InputChannels] INNER JOIN [EVT]. [dbo].[Devices] ON InputChannels.DeviceIdentity=Devices.DeviceIdentity INNER JOIN [EVT]. [dbo].[Nodes] ON Devices.NodeIdentity=Nodes.NodeIdentity ;"; SqlCommand cmd = new SqlCommand(query, conn); //open connection conn.Open(); //execute the SQLCommand SqlDataReader dr = cmd.ExecuteReader(); //check if there are records if (dr.HasRows) { var nombreCamara = dr.GetOrdinal("DeviceName"); var channelname = dr.GetOrdinal("NombreCanal"); var Ip = dr.GetOrdinal("EndPointIpAddress"); var Username = dr.GetOrdinal("Username"); var Password = dr.GetOrdinal("Password"); var StorageDrive = dr.GetOrdinal("StorageDrive"); var StorageDrive2 = dr.GetOrdinal("StorageDrive2"); var Retention = dr.GetOrdinal("MaxRetentionDays"); var Retention2 = dr.GetOrdinal("MaxRetentionDays2"); var NodoNombre = dr.GetOrdinal("NodoNombre"); // var NodoNombre = dr.GetOrdinal("NodoNombre"); while (dr.Read()) { //display retrieved record (first column only/string value) //var camara = dr.GetString(0); //var camara = listastring.Add(dr["Name"].ToString()); //listastring.Add(dr.GetString(0)); var camaraNombre = new Camaras { NombreCamara = dr.GetString(nombreCamara), ChannelName = dr.GetString(channelname), Ip = dr.GetString(Ip), Usuario = dr.GetString(Username), Pass = dr.GetString(Password), StorageDrive = dr.GetString(StorageDrive), StorageDrive2 = dr.GetString(StorageDrive2), Retention = dr.GetInt32(Retention).ToString(), Retention2 = dr.GetInt32(Retention2).ToString(), NodoNombre = dr.GetString(NodoNombre), System = "Caba 2" }; camaras.Add(camaraNombre); } } else { Console.WriteLine("No data found."); } dr.Close(); } } catch (Exception ex) { //display error message Console.WriteLine("Exception: " + ex.Message); } #endregion #region Caba3 //string connString = @"Data Source = 10.200.3.120\XDR; User ID =evtAdmin;Password=a"; string connString3 = @"Data Source = 172.23.3.198\XDR; User ID =evtAdmin;Password=a"; //connString.Remove(21,1); try { using (SqlConnection conn = new SqlConnection(connString3)) { //retrieve the SQL Server instance version string query = @"SELECT InputChannels.InputChannelIdentity ,InputChannels.DeviceIdentity ,InputChannels.Name As NombreCanal ,InputChannels.StorageDrive ,InputChannels.StorageDrive2 ,InputChannels.MaxRetentionDays ,InputChannels.MaxRetentionDays2 ,Devices.NodeIdentity ,Devices.DeviceIdentity ,Devices.Name As DeviceName ,Devices.UserName ,Devices.Password ,Devices.EndPointIpAddress ,Nodes.NodeIdentity ,Nodes.Name As NodoNombre FROM [EVT]. [dbo].[InputChannels] INNER JOIN [EVT]. [dbo].[Devices] ON InputChannels.DeviceIdentity=Devices.DeviceIdentity INNER JOIN [EVT]. [dbo].[Nodes] ON Devices.NodeIdentity=Nodes.NodeIdentity ;"; SqlCommand cmd = new SqlCommand(query, conn); //open connection conn.Open(); //execute the SQLCommand SqlDataReader dr = cmd.ExecuteReader(); //check if there are records if (dr.HasRows) { var nombreCamara = dr.GetOrdinal("DeviceName"); var channelname = dr.GetOrdinal("NombreCanal"); var Ip = dr.GetOrdinal("EndPointIpAddress"); var Username = dr.GetOrdinal("Username"); var Password = dr.GetOrdinal("Password"); var StorageDrive = dr.GetOrdinal("StorageDrive"); var StorageDrive2 = dr.GetOrdinal("StorageDrive2"); var Retention = dr.GetOrdinal("MaxRetentionDays"); var Retention2 = dr.GetOrdinal("MaxRetentionDays2"); var NodoNombre = dr.GetOrdinal("NodoNombre"); // var NodoNombre = dr.GetOrdinal("NodoNombre"); while (dr.Read()) { //display retrieved record (first column only/string value) //var camara = dr.GetString(0); //var camara = listastring.Add(dr["Name"].ToString()); //listastring.Add(dr.GetString(0)); var camaraNombre = new Camaras { NombreCamara = dr.GetString(nombreCamara), ChannelName = dr.GetString(channelname), Ip = dr.GetString(Ip), Usuario = dr.GetString(Username), Pass = dr.GetString(Password), StorageDrive = dr.GetString(StorageDrive), StorageDrive2 = dr.GetString(StorageDrive2), Retention = dr.GetInt32(Retention).ToString(), Retention2 = dr.GetInt32(Retention2).ToString(), NodoNombre = dr.GetString(NodoNombre), System = "Caba 3" }; camaras.Add(camaraNombre); } } else { Console.WriteLine("No data found."); } dr.Close(); } } catch (Exception ex) { //display error message Console.WriteLine("Exception: " + ex.Message); } #endregion #region Caba4 //string connString = @"Data Source = 10.200.3.120\XDR; User ID =evtAdmin;Password=a"; string connString4 = @"Data Source = 172.23.31.105\XDR; User ID =evtAdmin;Password=a"; //connString.Remove(21,1); try { using (SqlConnection conn = new SqlConnection(connString4)) { //retrieve the SQL Server instance version string query = @"SELECT InputChannels.InputChannelIdentity ,InputChannels.DeviceIdentity ,InputChannels.Name As NombreCanal ,InputChannels.StorageDrive ,InputChannels.StorageDrive2 ,InputChannels.MaxRetentionDays ,InputChannels.MaxRetentionDays2 ,Devices.NodeIdentity ,Devices.DeviceIdentity ,Devices.Name As DeviceName ,Devices.UserName ,Devices.Password ,Devices.EndPointIpAddress ,Nodes.NodeIdentity ,Nodes.Name As NodoNombre FROM [EVT]. [dbo].[InputChannels] INNER JOIN [EVT]. [dbo].[Devices] ON InputChannels.DeviceIdentity=Devices.DeviceIdentity INNER JOIN [EVT]. [dbo].[Nodes] ON Devices.NodeIdentity=Nodes.NodeIdentity ;"; SqlCommand cmd = new SqlCommand(query, conn); //open connection conn.Open(); //execute the SQLCommand SqlDataReader dr = cmd.ExecuteReader(); //check if there are records if (dr.HasRows) { var nombreCamara = dr.GetOrdinal("DeviceName"); var channelname = dr.GetOrdinal("NombreCanal"); var Ip = dr.GetOrdinal("EndPointIpAddress"); var Username = dr.GetOrdinal("Username"); var Password = dr.GetOrdinal("Password"); var StorageDrive = dr.GetOrdinal("StorageDrive"); var StorageDrive2 = dr.GetOrdinal("StorageDrive2"); var Retention = dr.GetOrdinal("MaxRetentionDays"); var Retention2 = dr.GetOrdinal("MaxRetentionDays2"); var NodoNombre = dr.GetOrdinal("NodoNombre"); // var NodoNombre = dr.GetOrdinal("NodoNombre"); while (dr.Read()) { //display retrieved record (first column only/string value) //var camara = dr.GetString(0); //var camara = listastring.Add(dr["Name"].ToString()); //listastring.Add(dr.GetString(0)); var camaraNombre = new Camaras { NombreCamara = dr.GetString(nombreCamara), ChannelName = dr.GetString(channelname), Ip = dr.GetString(Ip), Usuario = dr.GetString(Username), Pass = dr.GetString(Password), StorageDrive = dr.GetString(StorageDrive), StorageDrive2 = dr.GetString(StorageDrive2), Retention = dr.GetInt32(Retention).ToString(), Retention2 = dr.GetInt32(Retention2).ToString(), NodoNombre = dr.GetString(NodoNombre), System = "Caba 4" }; camaras.Add(camaraNombre); } } else { Console.WriteLine("No data found."); } dr.Close(); } } catch (Exception ex) { //display error message Console.WriteLine("Exception: " + ex.Message); } #endregion #region Caba5 //string connString = @"Data Source = 10.200.3.120\XDR; User ID =evtAdmin;Password=a"; string connString5 = @"Data Source = 172.23.31.121\XDR; User ID =evtAdmin;Password=a"; //connString.Remove(21,1); try { using (SqlConnection conn = new SqlConnection(connString5)) { //retrieve the SQL Server instance version string query = @"SELECT InputChannels.InputChannelIdentity ,InputChannels.DeviceIdentity ,InputChannels.Name As NombreCanal ,InputChannels.StorageDrive ,InputChannels.StorageDrive2 ,InputChannels.MaxRetentionDays ,InputChannels.MaxRetentionDays2 ,Devices.NodeIdentity ,Devices.DeviceIdentity ,Devices.Name As DeviceName ,Devices.UserName ,Devices.Password ,Devices.EndPointIpAddress ,Nodes.NodeIdentity ,Nodes.Name As NodoNombre FROM [EVT]. [dbo].[InputChannels] INNER JOIN [EVT]. [dbo].[Devices] ON InputChannels.DeviceIdentity=Devices.DeviceIdentity INNER JOIN [EVT]. [dbo].[Nodes] ON Devices.NodeIdentity=Nodes.NodeIdentity ;"; SqlCommand cmd = new SqlCommand(query, conn); //open connection conn.Open(); //execute the SQLCommand SqlDataReader dr = cmd.ExecuteReader(); //check if there are records if (dr.HasRows) { var nombreCamara = dr.GetOrdinal("DeviceName"); var channelname = dr.GetOrdinal("NombreCanal"); var Ip = dr.GetOrdinal("EndPointIpAddress"); var Username = dr.GetOrdinal("Username"); var Password = dr.GetOrdinal("Password"); var StorageDrive = dr.GetOrdinal("StorageDrive"); var StorageDrive2 = dr.GetOrdinal("StorageDrive2"); var Retention = dr.GetOrdinal("MaxRetentionDays"); var Retention2 = dr.GetOrdinal("MaxRetentionDays2"); var NodoNombre = dr.GetOrdinal("NodoNombre"); // var NodoNombre = dr.GetOrdinal("NodoNombre"); while (dr.Read()) { //display retrieved record (first column only/string value) //var camara = dr.GetString(0); //var camara = listastring.Add(dr["Name"].ToString()); //listastring.Add(dr.GetString(0)); var camaraNombre = new Camaras { NombreCamara = dr.GetString(nombreCamara), ChannelName = dr.GetString(channelname), Ip = dr.GetString(Ip), Usuario = dr.GetString(Username), Pass = dr.GetString(Password), StorageDrive = dr.GetString(StorageDrive), StorageDrive2 = dr.GetString(StorageDrive2), Retention = dr.GetInt32(Retention).ToString(), Retention2 = dr.GetInt32(Retention2).ToString(), NodoNombre = dr.GetString(NodoNombre), System = "Caba 5" }; camaras.Add(camaraNombre); } } else { Console.WriteLine("No data found."); } dr.Close(); } } catch (Exception ex) { //display error message Console.WriteLine("Exception: " + ex.Message); } #endregion #region Caba6 //string connString = @"Data Source = 10.200.3.120\XDR; User ID =evtAdmin;Password=a"; string connString6 = @"Data Source = 172.23.31.26\XDR; User ID =evtAdmin;Password=a"; //connString.Remove(21,1); try { using (SqlConnection conn = new SqlConnection(connString6)) { //retrieve the SQL Server instance version string query = @"SELECT InputChannels.InputChannelIdentity ,InputChannels.DeviceIdentity ,InputChannels.Name As NombreCanal ,InputChannels.StorageDrive ,InputChannels.StorageDrive2 ,InputChannels.MaxRetentionDays ,InputChannels.MaxRetentionDays2 ,Devices.NodeIdentity ,Devices.DeviceIdentity ,Devices.Name As DeviceName ,Devices.UserName ,Devices.Password ,Devices.EndPointIpAddress ,Nodes.NodeIdentity ,Nodes.Name As NodoNombre FROM [EVT]. [dbo].[InputChannels] INNER JOIN [EVT]. [dbo].[Devices] ON InputChannels.DeviceIdentity=Devices.DeviceIdentity INNER JOIN [EVT]. [dbo].[Nodes] ON Devices.NodeIdentity=Nodes.NodeIdentity ;"; SqlCommand cmd = new SqlCommand(query, conn); //open connection conn.Open(); //execute the SQLCommand SqlDataReader dr = cmd.ExecuteReader(); //check if there are records if (dr.HasRows) { var nombreCamara = dr.GetOrdinal("DeviceName"); var channelname = dr.GetOrdinal("NombreCanal"); var Ip = dr.GetOrdinal("EndPointIpAddress"); var Username = dr.GetOrdinal("Username"); var Password = dr.GetOrdinal("Password"); var StorageDrive = dr.GetOrdinal("StorageDrive"); var StorageDrive2 = dr.GetOrdinal("StorageDrive2"); var Retention = dr.GetOrdinal("MaxRetentionDays"); var Retention2 = dr.GetOrdinal("MaxRetentionDays2"); var NodoNombre = dr.GetOrdinal("NodoNombre"); // var NodoNombre = dr.GetOrdinal("NodoNombre"); while (dr.Read()) { //display retrieved record (first column only/string value) //var camara = dr.GetString(0); //var camara = listastring.Add(dr["Name"].ToString()); //listastring.Add(dr.GetString(0)); var camaraNombre = new Camaras { NombreCamara = dr.GetString(nombreCamara), ChannelName = dr.GetString(channelname), Ip = dr.GetString(Ip), Usuario = dr.GetString(Username), Pass = dr.GetString(Password), StorageDrive = dr.GetString(StorageDrive), StorageDrive2 = dr.GetString(StorageDrive2), Retention = dr.GetInt32(Retention).ToString(), Retention2 = dr.GetInt32(Retention2).ToString(), NodoNombre = dr.GetString(NodoNombre), System = "Caba 6" }; camaras.Add(camaraNombre); } } else { Console.WriteLine("No data found."); } dr.Close(); } } catch (Exception ex) { //display error message Console.WriteLine("Exception: " + ex.Message); } #endregion } return(Ok(camaras)); }
public ActionResult GrafanaCamaras(string id) { //id.Replace("-", "."); var ip = id.Replace("-", ".") + @"\XDR"; var listastring = new List <String>(); var Lista = new List <ListIntListString>(); var camaras = new List <Camaras>(); string connString = (@"Data Source=" + ip + " ; User ID =evtAdmin;Password=a"); //string connString = @"Data Source = 10.200.3.120\XDR; User ID =evtAdmin;Password=a"; //string connString = @"Data Source = 10.200.3.120\XDR; User ID =evtAdmin;Password=a"; //connString.Remove(21,1); try { using (SqlConnection conn = new SqlConnection(connString)) { //retrieve the SQL Server instance version string query = @"SELECT InputChannels.InputChannelIdentity ,InputChannels.DeviceIdentity ,InputChannels.Name As NombreCanal ,InputChannels.StorageDrive ,InputChannels.StorageDrive2 ,InputChannels.MaxRetentionDays ,InputChannels.MaxRetentionDays2 ,Devices.NodeIdentity ,Devices.DeviceIdentity ,Devices.Name As DeviceName ,Devices.UserName ,Devices.Password ,Devices.EndPointIpAddress ,Nodes.NodeIdentity ,Nodes.Name As NodoNombre FROM [EVT]. [dbo].[InputChannels] INNER JOIN [EVT]. [dbo].[Devices] ON InputChannels.DeviceIdentity=Devices.DeviceIdentity INNER JOIN [EVT]. [dbo].[Nodes] ON Devices.NodeIdentity=Nodes.NodeIdentity ;"; SqlCommand cmd = new SqlCommand(query, conn); //open connection conn.Open(); //execute the SQLCommand SqlDataReader dr = cmd.ExecuteReader(); //check if there are records if (dr.HasRows) { var nombreCamara = dr.GetOrdinal("DeviceName"); var channelname = dr.GetOrdinal("NombreCanal"); var Ip = dr.GetOrdinal("EndPointIpAddress"); var Username = dr.GetOrdinal("Username"); var Password = dr.GetOrdinal("Password"); var StorageDrive = dr.GetOrdinal("StorageDrive"); var StorageDrive2 = dr.GetOrdinal("StorageDrive2"); var Retention = dr.GetOrdinal("MaxRetentionDays"); var Retention2 = dr.GetOrdinal("MaxRetentionDays2"); var NodoNombre = dr.GetOrdinal("NodoNombre"); // var NodoNombre = dr.GetOrdinal("NodoNombre"); while (dr.Read()) { //display retrieved record (first column only/string value) //var camara = dr.GetString(0); //var camara = listastring.Add(dr["Name"].ToString()); //listastring.Add(dr.GetString(0)); var camaraNombre = new Camaras { NombreCamara = dr.GetString(nombreCamara), ChannelName = dr.GetString(channelname), Ip = dr.GetString(Ip), Usuario = dr.GetString(Username), Pass = dr.GetString(Password), StorageDrive = dr.GetString(StorageDrive), StorageDrive2 = dr.GetString(StorageDrive2), Retention = dr.GetInt32(Retention).ToString(), Retention2 = dr.GetInt32(Retention2).ToString(), NodoNombre = dr.GetString(NodoNombre) }; camaras.Add(camaraNombre); } } else { Console.WriteLine("No data found."); } dr.Close(); } } catch (Exception ex) { //display error message Console.WriteLine("Exception: " + ex.Message); } //var serializer = new JavaScriptSerializer(); // serializer.MaxJsonLength = 500000000; // var jsonResult = Json(camaras, JsonRequestBehavior.AllowGet); // jsonResult.MaxJsonLength = int.MaxValue; // return jsonResult; return(Json(new { data = camaras }, JsonRequestBehavior.AllowGet)); }