How to walk a C#class?

Question

I have the DeserializeObject that fills in an order class and items, on the items I need to go through this class to record the data, the way I’m doing is zeroing the records, how I could read the data?.

public class Item
{
    public string idItemPedido { get; set; }
    public int item { get; set; }
    public string plano { get; set; }
    public Produto produto { get; set; }
    public string descricaoItem { get; set; }
    public decimal valorUnitario { get; set; }
    public string qtde { get; set; }
    public decimal valorTotal { get; set; }
    public string pontos { get; set; }
}

   string teste = "115873";
   GravaItensPedido(teste);


   public void GravaItensPedido(string CodigoCabecahoPedido)
        {
            var strQuery = "";
            IEnumerable<Item> enumeracao = new List<Item>();

            foreach (var item in enumeracao)
            {
                strQuery = "";
            }
        }

Answer 1

You want to generate an update/Insert query for class properties?

If so, I recommend using Dapper to help you. It’s a C# library created by the Stackoverflow team.

It’ll help you a lot: Dapper

Look how cool:

var count = connection.Execute(@"
  set nocount on 
  create table #t(i int) 
  set nocount off 
  insert #t 
  select @a a union all select @b 
  set nocount on 
  drop table #t", new {a=1, b=2 });
Assert.Equal(2, count);

You take an ADO.NET connection, you’ll have an extension method called Execute. Then you call him with 2 parameters.

• in 1 parameter you pass sql
• in the 2nd parameter you pass an object, with the data for it to mount the query for you.

How about?

Answer 2

There’s something missing from your question, so

case 1 : Voce informs the parameter(codeCabecahoPedido) and receives a list using some method

public void GravaItensPedido(string codigoCabecahoPedido)
{

      List<Item> minhaLista= getlistblabla(x=>x.CodigoCabecahoPedido == codigoCabecahoPedido);

      foreach (var itens in minhaLista)
      {
         //Faz alguma coisa
      }
}

case 2: Pass the list that will be changed or something like

public void GravaItensPedido(string codigoCabecahoPedido, List<Item> itens)
{      
  var strQuery = "";

  foreach (var itens in itens)
  {
      if(codigoCabecahoPedido == "test")
      {
        //faca alguma coisa
      }
  }
}