private void TmConsultaNFeDestinatario_Tick(object sender, EventArgs e)
{
TmConsultaNFeDestinatario.Enabled = false;
EnviarConsultaDestinatario ObjConDest = new EnviarConsultaDestinatario();
Entidade_ConsNFDest ObjRet = new Entidade_ConsNFDest();
ObjConDest.Enviar(null, out ObjRet);
TmConsultaNFeDestinatario.Enabled = true;
}
public void InsertConsNFDest(Entidade_ConsNFDest ObjConsNFDest)
{
BancoDados.OpenConection();
NpgsqlCommand command;
BeginTrans = BancoDados.conexao.BeginTransaction();
command = new NpgsqlCommand("spincluirconsultadestinatario", BancoDados.conexao);
command.Transaction = BeginTrans;
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("codstatus", ObjConsNFDest.codstatus);
command.Parameters.AddWithValue("dhresp", ObjConsNFDest.dhresp);
command.Parameters.AddWithValue("indcont", ObjConsNFDest.indcont);
var Id = command.ExecuteScalar();
foreach (var item in ObjConsNFDest.ListItemConsDest)
{
command = new NpgsqlCommand("spincluiritemconsultanfdest", BancoDados.conexao);
command.Transaction = BeginTrans;
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("id_consdest", Convert.ToInt32(Id));
command.Parameters.AddWithValue("nsu", item.nsu);
command.Parameters.AddWithValue("chacessonfe", item.chacessonfe);
command.Parameters.AddWithValue("cnpjcpf", item.cnpjcpf.Trim());
command.Parameters.AddWithValue("nomeemitente", item.nomeemitente);
command.Parameters.AddWithValue("dtemissao", item.dtemissao);
command.Parameters.AddWithValue("tpnfe", item.tpnfe);
command.Parameters.AddWithValue("vlnfe", item.vlnfe);
command.Parameters.AddWithValue("dhautorizacao", item.dhautorizacao);
command.Parameters.AddWithValue("sitnfe", item.sitnfe);
command.Parameters.AddWithValue("sit_manifestacao_dest", item.sit_manifestacao_dest);
command.ExecuteNonQuery();
}
BeginTrans.Commit();
BancoDados.CloseConection();
}
