protected void btnGuardarSe_Click(object sender, EventArgs e)
{
DTOSensor sen = new DTOSensor();
sen.Id_sen = int.Parse(txtCodigoSe.Text);
sen.Magnitud_sen1 = txtMagnitudSe.Text;
sen.Caracteristica_sen1 = txtCaracteristicaSe.Text;
CADSensor datos = new CADSensor();
bool existe = datos.InsertarSensor(sen);
Response.Redirect("inicio.aspx#sensores");
}
protected void btnListarSe_Click(object sender, EventArgs e)
{
ocultarSen.Visible = false;
btnVolverSen.Visible = true;
DTOSensor dts = new DTOSensor();
CADSensor datos = new CADSensor();
gvSensor.DataSource = datos.ConsultarSensor(dts);
gvSensor.DataBind();
}
public DataTable ConsultarSensor(DTOSensor Id_sen)
{
DataTable dt = new DataTable();
SqlConnection con = new SqlConnection(cadena);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "Consultar_Sensor";
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
con.Close();
return(dt);
}
public bool ModificarSensor(DTOSensor Id_sen)
{
DataTable dt = new DataTable();
SqlConnection con = new SqlConnection(cadena);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "Modificar_Sensor";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id_sen", Id_sen.Id_sen1);
cmd.Parameters.AddWithValue("@Magnitud_sen", Id_sen.Magnitud_sen1);
cmd.Parameters.AddWithValue("@Caracteristica_sen", Id_sen.Caracteristica_sen1);
con.Open();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
con.Close();
return(true);
}
