void guardarEstado() { using (SqlConnection sqlCon = new SqlConnection(connectionString)) { sqlCon.Open(); string query = "UPDATE inmueble SET estado=@estado WHERE inmueble_id=@inmueble_id"; SqlCommand sqlCmd = new SqlCommand(query, sqlCon); sqlCmd.Parameters.AddWithValue("@estado", "Arrendado"); sqlCmd.Parameters.AddWithValue("@inmueble_id", (TxtCodigoInmueble.FindControl("TxtCodigoInmueble") as TextBox).Text.Trim()); sqlCmd.ExecuteNonQuery(); } }
void guardarContrato() { using (SqlConnection sqlCon = new SqlConnection(connectionString)) { sqlCon.Open(); string query = "INSERT INTO contrato (inmueble_id,persona_id) VALUES (@inmueble_id,@persona_id)"; SqlCommand sqlCmd = new SqlCommand(query, sqlCon); sqlCmd.Parameters.AddWithValue("@inmueble_id", (TxtCodigoInmueble.FindControl("TxtCodigoInmueble") as TextBox).Text.Trim()); sqlCmd.Parameters.AddWithValue("@persona_id", (TxtCodigoCliente.FindControl("TxtCodigoCliente") as TextBox).Text.Trim()); sqlCmd.ExecuteNonQuery(); lblSuccessMessage.Text = "Registro Con Exito"; lblSuccessMessage.Visible = true; lblErrorMessage.Text = ""; lblErrorMessage.Visible = true; sqlCmd.Parameters.Clear(); } }