Skip to content

Instantly share code, notes, and snippets.

@alandalegend
alandalegend / xaf_imagen_desde_filedata.cs
Created August 10, 2023 22:57
XAF para visualizar una imagen subida (como filedata) y se visualice sin necesidad de descargar
private byte[] _VistaImagen;
[NonPersistent]
[ImageEditor(ListViewImageEditorMode = ImageEditorMode.PictureEdit, DetailViewImageEditorMode = ImageEditorMode.PictureEdit, ListViewImageEditorCustomHeight = 40, DetailViewImageEditorFixedHeight = 80)]
[XafDisplayName("Vista (cuando es imagen)")]
public byte[] VistaImagen
{
get
{
if (_VistaImagen == null)
@alandalegend
alandalegend / XAF_pdf_visor.cs
Created August 10, 2023 22:55
XAF Visualizar un PDF en DetailView
//Esta propiedad permite visualizar el PDF en modo lectura, presentando el PDF y poder navegar dentro de sus páginas.
[VisibleInListView(false), VisibleInDetailView(true)]
[XafDisplayName("Visor PDF Original")]
public byte[] PdfDataOriginal
{
get
{
if (ArchivoOriginal == null) return new byte[0];
@alandalegend
alandalegend / allProcedures.sql
Created June 29, 2023 04:18
Obtener todos los storedProcedures de tu bd
/*Fuente: https://database.guide/3-ways-to-list-all-stored-procedures-in-a-sql-server-database/*/
SELECT
ROUTINE_SCHEMA,
ROUTINE_NAME
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = 'PROCEDURE';
@alandalegend
alandalegend / allTriggers.sql
Created June 29, 2023 04:15
Obtener todos los trriggers en SQL
/*Fuente https://stackoverflow.com/a/4305751 */
SELECT
sysobjects.name AS trigger_name
,USER_NAME(sysobjects.uid) AS trigger_owner
,s.name AS table_schema
,OBJECT_NAME(parent_obj) AS table_name
,OBJECTPROPERTY( id, 'ExecIsUpdateTrigger') AS isupdate
,OBJECTPROPERTY( id, 'ExecIsDeleteTrigger') AS isdelete
,OBJECTPROPERTY( id, 'ExecIsInsertTrigger') AS isinsert
@alandalegend
alandalegend / propertys.cs
Created October 16, 2021 19:04
XAF convert Base64 and preview byte[]
/***Guarda tu imagen en formato base64, y el DevExpress te mostrará la vista previa.***/
private string base64;
[VisibleInDetailView(false), VisibleInListView(false), VisibleInLookupListView(false)]
[Size(SizeAttribute.Unlimited)]
public string Base64
{
get { return base64; }
set { SetPropertyValue("Base64", ref base64, value); }
}
@alandalegend
alandalegend / Futures.dart
Last active August 10, 2023 23:19
Futures.dart
void main() {
print('Estamos a punto de pedir datos');
httpGet("hola").then((data){
print(data);
});
print('Recibimos los datos');
}
@alandalegend
alandalegend / mixin.dart
Created September 17, 2020 21:57
Mixins Dart
void main() {
final pato = new Pato();
pato.volar();
final pezVolador = new PezVolador();
pezVolador.nadar();
}
abstract class Volador {
void volar() => print("Estoy volando");
}