bennotti · November 25, 2022 22:04 · Nov 25, 2022 · Nov 24, 2022 · Nov 23, 2022
diff --git a/program.cs b/program.cs
@@ -3,25 +3,26 @@
 using System.Reflection;
 using System.Reflection.Metadata;
 
-
-var padrao = new List<padraoDto> { new padraoDto { Number = "208"}, new padraoDto { Number = "655" } };
-var cliente = new List<string> { "655" };
+/*
+var padrao = new List<padraoDto> { new padraoDto { Number = "234"}, new padraoDto { Number = "754" } };
+var cliente = new List<string> { "754" };
 
 var listaFaltando = padrao.Where(p => !cliente.Any(x => x == p.Number)).ToList();
 
 foreach (var item in listaFaltando)
 {
-    Console.WriteLine(item);
-}
+    Console.WriteLine(item.Number);
+}*/
 
 var y = new Teste { 
     Nome = "ok",
     Valor = "2"
 };
 
-var camposSelect = CamposSelect(new { 
-    nome = "",
-    casa = 2
+var camposSelect = CamposSelect<Teste>(new { 
+    Nome = "",
+    casa = 2,
+    Email = ""
 });
 
 //await insert(
@@ -35,50 +36,71 @@
     Console.WriteLine(campo);
 }
 
-static string[] CamposSelect(object atype)
+static string[] CamposSelect<T>(object atype) where T : class
 {
     if (atype == null) return new string[] { };
     Type t = atype.GetType();
+    Type entityType = typeof(T);
+    PropertyInfo[] entityProps = entityType.GetProperties();
     PropertyInfo[] props = t.GetProperties();
     List<string> propNames = new List<string>();
     foreach (PropertyInfo prp in props)
     {
-        var nomeCampo = prp.Name;
-        object[] attrs = prp.GetCustomAttributes(true);
-        foreach (object attr in attrs)
-        {
-            UsarSelectAttribute selectAttr = attr as UsarSelectAttribute;
-            if (selectAttr != null && !string.IsNullOrEmpty(selectAttr.NomeCampo)) {
-                nomeCampo = selectAttr.NomeCampo;
+        foreach (PropertyInfo prpEntity in entityProps) {
+            if (prp.Name == prpEntity.Name) {
+                var nomeCampo = string.Empty;
+                object[] attrs = prpEntity.GetCustomAttributes(true);
+                foreach (object attr in attrs) {
+                    ColunaAttribute selectAttr = attr as ColunaAttribute;
+                    if (selectAttr != null && selectAttr.UsarSelect) {
+                        nomeCampo = string.IsNullOrEmpty(selectAttr.NomeCampo) ? prp.Name : selectAttr.NomeCampo;
+                    }
+                }
+                if (!string.IsNullOrEmpty(nomeCampo)) {
+                    propNames.Add(nomeCampo);
+                    break;
+                }
             }
         }
-        propNames.Add(nomeCampo);
+
     }
     return propNames.ToArray();
 }
 
 public class Teste: Teste2
 {
-    [UsarSelect]
+    [Coluna]
     public string Nome { get; set; }
-    [UsarSelect("ValorAmount")]
+    [Coluna("ValorAmount")]
     public string Valor { get; set; }
 }
 
 public class Teste2
 {
-    [UsarSelect("EMAIL_CAMPO")]
+    [Coluna("EMAIL_CAMPO")]
     public string Email { get; set; }
 }
 
 [System.AttributeUsage(System.AttributeTargets.Property)
 ]
-public class UsarSelectAttribute : System.Attribute
+public class ColunaAttribute : System.Attribute
 {
-    public string NomeCampo { get; private set; }
-    public UsarSelectAttribute() { }
-    public UsarSelectAttribute(string nomeCampo)
+    public string NomeCampo { get; private set; } = string.Empty;
+    public bool UsarSelect { get; private set; } = true;
+    public bool UsarInsert { get; private set; } = true;
+    public bool UsarUpdate { get; private set; } = true;
+    public ColunaAttribute() { }
+    public ColunaAttribute(string nomeCampo = "", bool usarSelect = true, bool usarInsert = true, bool usarUpdate = true)
+    {
+        UsarInsert = usarInsert;
+        NomeCampo = nomeCampo;
+        UsarSelect = usarSelect;
+        UsarUpdate = usarUpdate;
+    }
+    public ColunaAttribute(bool usarSelect = true, bool usarInsert = true, bool usarUpdate = true)
     {
-        this.NomeCampo = nomeCampo;
+        UsarInsert = usarInsert;
+        UsarSelect = usarSelect;
+        UsarUpdate = usarUpdate;
     }
 }
diff --git a/padraoDto.cs b/padraoDto.cs
@@ -0,0 +1,13 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace PocClassPropertiesList
+{
+    public class padraoDto
+    {
+        public string Number { get; set; }
+    }
+}
diff --git a/program.cs b/program.cs
@@ -1,13 +1,34 @@
 // See https://aka.ms/new-console-template for more information
+using PocClassPropertiesList;
 using System.Reflection;
 using System.Reflection.Metadata;
 
+
+var padrao = new List<padraoDto> { new padraoDto { Number = "208"}, new padraoDto { Number = "655" } };
+var cliente = new List<string> { "655" };
+
+var listaFaltando = padrao.Where(p => !cliente.Any(x => x == p.Number)).ToList();
+
+foreach (var item in listaFaltando)
+{
+    Console.WriteLine(item);
+}
+
 var y = new Teste { 
     Nome = "ok",
     Valor = "2"
 };
 
-var camposSelect = CamposSelect(y);
+var camposSelect = CamposSelect(new { 
+    nome = "",
+    casa = 2
+});
+
+//await insert(
+//    NOME | EMAIL,
+//    new { nome = "", email = "" });
+
+//await inserir(new { nome = "", email = "" });
 
 foreach(var campo in camposSelect)
 {

diff --git a/program.cs b/program.cs
@@ -0,0 +1,63 @@
+// See https://aka.ms/new-console-template for more information
+using System.Reflection;
+using System.Reflection.Metadata;
+
+var y = new Teste { 
+    Nome = "ok",
+    Valor = "2"
+};
+
+var camposSelect = CamposSelect(y);
+
+foreach(var campo in camposSelect)
+{
+    Console.WriteLine(campo);
+}
+
+static string[] CamposSelect(object atype)
+{
+    if (atype == null) return new string[] { };
+    Type t = atype.GetType();
+    PropertyInfo[] props = t.GetProperties();
+    List<string> propNames = new List<string>();
+    foreach (PropertyInfo prp in props)
+    {
+        var nomeCampo = prp.Name;
+        object[] attrs = prp.GetCustomAttributes(true);
+        foreach (object attr in attrs)
+        {
+            UsarSelectAttribute selectAttr = attr as UsarSelectAttribute;
+            if (selectAttr != null && !string.IsNullOrEmpty(selectAttr.NomeCampo)) {
+                nomeCampo = selectAttr.NomeCampo;
+            }
+        }
+        propNames.Add(nomeCampo);
+    }
+    return propNames.ToArray();
+}
+
+public class Teste: Teste2
+{
+    [UsarSelect]
+    public string Nome { get; set; }
+    [UsarSelect("ValorAmount")]
+    public string Valor { get; set; }
+}
+
+public class Teste2
+{
+    [UsarSelect("EMAIL_CAMPO")]
+    public string Email { get; set; }
+}
+
+[System.AttributeUsage(System.AttributeTargets.Property)
+]
+public class UsarSelectAttribute : System.Attribute
+{
+    public string NomeCampo { get; private set; }
+    public UsarSelectAttribute() { }
+    public UsarSelectAttribute(string nomeCampo)
+    {
+        this.NomeCampo = nomeCampo;
+    }
+}