public void InsertarModelo(string Modelo)
{
var comando = new SqlCommand("INSERT INTO[dbo].[Cat_Modelo]([Modelo])VALUES ('" + Modelo + "')", Conexion.AbrirConexion());
try
{
comando.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
Conexion.CerrarConexion();
}
public DataTable CargarDatosSites(int edificio)
{
DataTable dtd = new DataTable();
var comando = new SqlCommand("select * from Cat_Site where idEdificio = '" + edificio + "';", Conexion.AbrirConexion());
SqlDataReader dr = comando.ExecuteReader();
dtd.Clear();
dtd.Load(dr);
Conexion.CerrarConexion();
return(dtd);
}
public void InsertarSite(string Site)
{
var comando = new SqlCommand("INSERT INTO[dbo].[Cat_Site]([Site])VALUES ('" + Site + "')", Conexion.AbrirConexion());
try
{
comando.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
Conexion.CerrarConexion();
}
public void InsertarProveedor(string Proveedor)
{
var comando = new SqlCommand("INSERT INTO[dbo].[Cat_Proveedor]([Proveedor])VALUES ('" + Proveedor + "')", Conexion.AbrirConexion());
try
{
comando.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
Conexion.CerrarConexion();
}
