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