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