Пример #1
0
        public static Boolean Delete(NotaFiscalTO clsNotaFiscal)
        {
            String myConnection = "Server=localhost;Database=gerenciadornf;Uid=root;Pwd=;";

            MySqlConnection connection = new MySqlConnection(myConnection);
            MySqlCommand cmd;
            connection.Open();

            try
            {
                StringBuilder strSql = new StringBuilder();
                strSql.Append("DELETE FROM NotaFiscal WHERE IDNotaFiscal=@IDNotaFiscal");

                cmd = connection.CreateCommand();

                cmd.CommandText = strSql.ToString();
                cmd.Parameters.AddWithValue("@IDNotaFiscal", clsNotaFiscal.IDNotaFiscal);

                cmd.ExecuteNonQuery();
                return true;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                if (connection.State == ConnectionState.Open)
                {
                    connection.Close();
                }
            }
        }
 protected void gvwNotaFiscal_RowDeleting(object sender, GridViewDeleteEventArgs e)
 {
     NotaFiscalTO clsNotaFiscal = new NotaFiscalTO();
     Int32 ID = (Int32)gvwNotaFiscal.DataKeys[e.RowIndex].Value;
     clsNotaFiscal = NotaFiscalBLL.GetNotaFiscalByID(ID);
     NotaFiscalBLL.Delete(clsNotaFiscal);
     LoadGrid();
 }
        public void LoadNF()
        {
            clsNotaFiscal = NotaFiscalBLL.GetNotaFiscalByID(idNotaFiscal);
            clsCliente = ClienteBLL.GetClienteByID(clsNotaFiscal.IDCliente);
            clsEmitente = EmitenteBLL.GetEmitenteByID(clsNotaFiscal.IDEmitente);
            clsTransportadora = TransportadoraBLL.GetTransportadoraByID(clsNotaFiscal.IDTransportadora);
            clsNotaFiscalProduto = NotaFiscalProdutoBLL.getNotaFiscalProdutoByNF(clsNotaFiscal.IDNotaFiscal);
            clsFormaPagamento = FormaPagamentoBLL.GetFormaPagamentoByID(clsNotaFiscal.iDFormaPagamento);

            lblNumeroNF.Text = clsNotaFiscal.IDNotaFiscal.ToString();
            lblDataEmissao.Text = clsNotaFiscal.DataCadastro.ToString();
            lblNaturezaOperacao.Text = clsNotaFiscal.TipoSaidaEntrada;
            lblFormaPagamento.Text = clsFormaPagamento.Descricao;
            lblDataSaidaEntrada.Text = clsNotaFiscal.DataSaidaEntrada.ToString();

            lblNomeEmitente.Text = clsEmitente.NomeFantasia;
            lblCNPJEmitente.Text = clsEmitente.Cnpj;
            lblIEEmitente.Text = clsEmitente.InscricaoEstadual;
            lblCepEmitente.Text = clsEmitente.Cep;
            lblLograduraEmitente.Text = clsEmitente.Logradura;
            lblNumeroEmitente.Text = clsEmitente.Numero;
            lblCidadeEmitente.Text = clsEmitente.Cidade;
            lblUFEmitente.Text = clsEmitente.Uf;
            lblTelefoneEmitente.Text = clsEmitente.Telefone;

            lblNomeCliente.Text = clsCliente.NomeFantasia;
            lblCNPJCliente.Text = clsCliente.Cnpj;
            lblIECliente.Text = clsCliente.InscricaoEstadual;
            lblCepCliente.Text = clsCliente.Cep;
            lblLograduraCliente.Text = clsCliente.Logradura;
            lblNumeroCliente.Text = clsCliente.Numero;
            lblCidadeCliente.Text = clsCliente.Cidade;
            lblUFCliente.Text = clsCliente.Uf;
            lblTelefoneCliente.Text = clsCliente.Telefone;

            Double dblTotalSemImpostos = 0;
            Double dblTotalFinal = 0;
            double dblTotalImpostos = 0;
            Double dblTotalICMS = 0;
            Double dblTotalIPI = 0;
            foreach (NotaFiscalProdutoTO _clsNotaFiscalProduto in clsNotaFiscalProduto)
            {
                  dblTotalSemImpostos += (_clsNotaFiscalProduto.ValorUnitario * _clsNotaFiscalProduto.QtdProduto);
                //dblTotalImpostos += _clsNotaFiscalProduto.ValorTotal;
                  dblTotalICMS += (dblTotalSemImpostos * _clsNotaFiscalProduto.Icms)/100;
                  dblTotalIPI += (dblTotalSemImpostos * _clsNotaFiscalProduto.Ipi)/100;
                  dblTotalFinal += _clsNotaFiscalProduto.ValorTotal;
            }
            //dblTotalFinal = dblTotalImpostos + dblTotalSemImpostos;

            lblBaseCalculoICMS.Text = "R$ " + dblTotalSemImpostos.ToString();
            lblTotalICMS.Text = dblTotalICMS.ToString();
            lblValorTotalIPI.Text = dblTotalIPI.ToString();
            lblValorTotalProduto.Text = "R$ "+dblTotalSemImpostos.ToString();

            gvNotaFiscalProduto.DataSource = this.clsNotaFiscalProduto;
            gvNotaFiscalProduto.DataBind();
        }
        protected void Load()
        {
            clsNotaFiscal = this.NotaFiscal;
            int intEmitente = 0;
            int.TryParse(ddlEmitente.SelectedValue, out intEmitente);
            clsNotaFiscal.IDEmitente = intEmitente;
            int intTransportadora = 0;
            int.TryParse(ddlTransportadora.SelectedValue, out intTransportadora);
            clsNotaFiscal.IDTransportadora = intTransportadora;
            int intCliente = 0;
            int.TryParse(ddlCliente.SelectedValue, out intCliente);
            clsNotaFiscal.IDCliente = intCliente;
            int intFormaPagamento = 0;
            int.TryParse(ddlFormaDePagamento.SelectedValue, out intFormaPagamento);
            clsNotaFiscal.iDFormaPagamento = intFormaPagamento;

            clsNotaFiscal.DataCadastro = DateTime.Now;

            if (radSaida.Checked)
            {
                clsNotaFiscal.TipoSaidaEntrada = "Saída";
            }
            if (radEntrada.Checked)
            {
                clsNotaFiscal.TipoSaidaEntrada = "Entrada";
            }

            if (radEmitente.Checked)
            {
                clsNotaFiscal.TipoTransporte = "Emitente";
            }
            if (radDestinatario.Checked)
            {
                clsNotaFiscal.TipoTransporte = "Destinatário";
            }

               // clsNotaFiscal.QtdTransporte = Convert.ToInt32(txtQtdTransporte.Text);
            clsNotaFiscal.EspecieTransporte = txtEspecieTransporte.Text;
            clsNotaFiscal.MarcaTransporte = txtMarcaTransporte.Text;
            clsNotaFiscal.NumeroTransporte = Convert.ToInt32(txtNumeroTransporte.Text);
            clsNotaFiscal.PesoBruto = Convert.ToDouble(txtPesoBruto.Text);
            clsNotaFiscal.PesoLiquido = Convert.ToDouble(txtPesoLiquido.Text);
        }
Пример #5
0
 public static Boolean Update(NotaFiscalTO clsNotaFiscal)
 {
     return NotaFiscalDAL.Update(clsNotaFiscal);
 }
Пример #6
0
 public static void insert(NotaFiscalTO clsNotaFiscal)
 {
     NotaFiscalDAL.insert(clsNotaFiscal);
 }
Пример #7
0
 public static Boolean Delete(NotaFiscalTO clsNotaFiscal)
 {
     return NotaFiscalDAL.Delete(clsNotaFiscal);
 }
Пример #8
0
        public static List<NotaFiscalTO> GetNotaFiscalAll()
        {
            String myConnection = "Server=localhost;Database=gerenciadornf;Uid=root;Pwd=;";

            MySqlConnection connection = new MySqlConnection(myConnection);
            MySqlCommand cmd;
            connection.Open();
            try
            {
                List<NotaFiscalTO> clsNotaFiscals = new List<NotaFiscalTO>();

                string strSql = "SELECT notafiscal.*, emitente.nome as nomeEmitente, cliente.nome as nomeCliente FROM notafiscal INNER JOIN Emitente ON emitente.idEmitente = notafiscal.idemitente INNER JOIN Cliente On cliente.idCliente = notafiscal.idCliente";

                cmd = connection.CreateCommand();
                cmd.CommandText = strSql;
                cmd.ExecuteNonQuery();

                MySqlDataReader adap = cmd.ExecuteReader();

                while (adap.Read())
                {
                    NotaFiscalTO clsNotaFiscal = new NotaFiscalTO();

                    clsNotaFiscal.IDNotaFiscal = Convert.ToInt32(adap["IDNotaFiscal"]);
                    clsNotaFiscal.IDEmitente = Convert.ToInt32(adap["IDEmitente"]);
                    clsNotaFiscal.IDTransportadora = Convert.ToInt32(adap["IDTransportadora"]);
                    clsNotaFiscal.IDCliente = Convert.ToInt32(adap["IDCliente"]);
                    clsNotaFiscal.iDFormaPagamento = Convert.ToInt32(adap["iDFormaPagamento"]);
                    clsNotaFiscal.ValorTotal = Convert.ToInt32(adap["ValorTotal"]);
                    clsNotaFiscal.DataCadastro = Convert.ToDateTime(adap["DataCadastro"]);

                    clsNotaFiscal.TipoSaidaEntrada = adap["TipoSaidaEntrada"].ToString();

                    clsNotaFiscal.DataSaidaEntrada = Convert.ToDateTime(adap["DataSaidaEntrada"]);

                    clsNotaFiscal.QtdTransporte = Convert.ToInt32(adap["QtdTransporte"]);
                    clsNotaFiscal.TipoTransporte = adap["TipoTransporte"].ToString();
                    clsNotaFiscal.EspecieTransporte = adap["EspecieTransporte"].ToString();
                    clsNotaFiscal.MarcaTransporte = adap["MarcaTransporte"].ToString();
                    clsNotaFiscal.NumeroTransporte = Convert.ToInt32(adap["NumeroTransporte"]);
                    clsNotaFiscal.PesoBruto = Convert.ToDouble(adap["PesoBruto"]);
                    clsNotaFiscal.PesoLiquido = Convert.ToDouble(adap["PesoLiquido"]);

                    clsNotaFiscal.NomeCliente = adap["nomeCliente"].ToString();
                    clsNotaFiscal.NomeEmitente = adap["nomeEmitente"].ToString();

                    clsNotaFiscals.Add(clsNotaFiscal);
                }

                return clsNotaFiscals;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            finally
            {
                if (connection.State == ConnectionState.Open)
                {
                    connection.Close();
                }
            }
        }
Пример #9
0
        public static Boolean Update(NotaFiscalTO clsNotaFiscal)
        {
            String myConnection = "Server=localhost;Database=gerenciadornf;Uid=root;Pwd=;";

            MySqlConnection connection = new MySqlConnection(myConnection);
            MySqlCommand cmd;
            connection.Open();

            try
            {
                StringBuilder strSql = new StringBuilder();
                strSql.Append("UPDATE NotaFiscal SET IDEmitente=@IDEmitente, IDTransportadora=@IDTransportadora,IDCliente=@IDCliente,iDFormaPagamento=@iDFormaPagamento,ValorTotal=@ValorTotal,DataCadastro=@DataCadastro, TipoSaidaEntrada=@TipoSaidaEntrada, DataSaidaEntrada=@DataSaidaEntrada, QtdTransporte=@QtdTransporte, TipoTransporte=@TipoTransporte, EspecieTransporte=@EspecieTransporte, MarcaTransporte=@MarcaTransporte, NumeroTransporte=@NumeroTransporte, PesoBruto=@PesoBruto,  PesoLiquido=@PesoLiquido WHERE IDNotaFiscal=@IDNotaFiscal ");

                cmd = connection.CreateCommand();

                cmd.CommandText = strSql.ToString();
                cmd.Parameters.AddWithValue("@IDNotaFiscal", clsNotaFiscal.IDNotaFiscal);
                cmd.Parameters.AddWithValue("@IDEmitente", clsNotaFiscal.IDEmitente);
                cmd.Parameters.AddWithValue("@IDTransportadora", clsNotaFiscal.IDTransportadora);
                cmd.Parameters.AddWithValue("@IDCliente", clsNotaFiscal.IDCliente);
                cmd.Parameters.AddWithValue("@iDFormaPagamento", clsNotaFiscal.iDFormaPagamento);
                cmd.Parameters.AddWithValue("@ValorTotal", clsNotaFiscal.ValorTotal);
                cmd.Parameters.AddWithValue("@DataCadastro", clsNotaFiscal.DataCadastro);

                cmd.Parameters.AddWithValue("@TipoSaidaEntrada", clsNotaFiscal.TipoSaidaEntrada);
                cmd.Parameters.AddWithValue("@DataSaidaEntrada", clsNotaFiscal.DataSaidaEntrada);
                cmd.Parameters.AddWithValue("@QtdTransporte", clsNotaFiscal.QtdTransporte);
                cmd.Parameters.AddWithValue("@TipoTransporte", clsNotaFiscal.TipoTransporte);
                cmd.Parameters.AddWithValue("@EspecieTransporte", clsNotaFiscal.EspecieTransporte);
                cmd.Parameters.AddWithValue("@MarcaTransporte", clsNotaFiscal.MarcaTransporte);
                cmd.Parameters.AddWithValue("@NumeroTransporte", clsNotaFiscal.NumeroTransporte);
                cmd.Parameters.AddWithValue("@PesoBruto", clsNotaFiscal.PesoBruto);
                cmd.Parameters.AddWithValue("@PesoLiquido", clsNotaFiscal.PesoLiquido);

                cmd.ExecuteNonQuery();
                return true;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                if (connection.State == ConnectionState.Open)
                {
                    connection.Close();
                }
            }
        }
Пример #10
0
        public static void insert(NotaFiscalTO clsNotaFiscal)
        {
            String myConnection = "Server=localhost;Database=gerenciadornf;Uid=root;Pwd=;";

            MySqlConnection connection = new MySqlConnection(myConnection);
            MySqlCommand cmd;
            connection.Open();

            try
            {
                StringBuilder strSql = new StringBuilder();
                strSql.Append("INSERT INTO NotaFiscal(IDEmitente, IDTransportadora,IDCliente,iDFormaPagamento,ValorTotal,DataCadastro, TipoSaidaEntrada,DataSaidaEntrada, QtdTransporte, TipoTransporte, EspecieTransporte, MarcaTransporte, NumeroTransporte, PesoBruto,  PesoLiquido) ");
                strSql.Append("VALUES (@IDEmitente, @IDTransportadora,@IDCliente,@iDFormaPagamento,@ValorTotal,@DataCadastro, @TipoSaidaEntrada,@DataSaidaEntrada, @QtdTransporte, @TipoTransporte, @EspecieTransporte, @MarcaTransporte, @NumeroTransporte, @PesoBruto,  @PesoLiquido); ");
                strSql.Append("SELECT NotaFiscal.* FROM NotaFiscal WHERE NotaFiscal.IDNotaFiscal=@@IDENTITY;");

                cmd = connection.CreateCommand();

                cmd.CommandText = strSql.ToString();
                cmd.Parameters.AddWithValue("@IDEmitente", clsNotaFiscal.IDEmitente);
                cmd.Parameters.AddWithValue("@IDTransportadora", clsNotaFiscal.IDTransportadora);
                cmd.Parameters.AddWithValue("@IDCliente", clsNotaFiscal.IDCliente);
                cmd.Parameters.AddWithValue("@iDFormaPagamento", clsNotaFiscal.iDFormaPagamento);
                cmd.Parameters.AddWithValue("@ValorTotal", clsNotaFiscal.ValorTotal);
                cmd.Parameters.AddWithValue("@DataCadastro", clsNotaFiscal.DataCadastro);

                cmd.Parameters.AddWithValue("@TipoSaidaEntrada", clsNotaFiscal.TipoSaidaEntrada);
                cmd.Parameters.AddWithValue("@DataSaidaEntrada", clsNotaFiscal.DataSaidaEntrada);
                cmd.Parameters.AddWithValue("@QtdTransporte", clsNotaFiscal.QtdTransporte);
                cmd.Parameters.AddWithValue("@TipoTransporte", clsNotaFiscal.TipoTransporte);
                cmd.Parameters.AddWithValue("@EspecieTransporte", clsNotaFiscal.EspecieTransporte);
                cmd.Parameters.AddWithValue("@MarcaTransporte", clsNotaFiscal.MarcaTransporte);
                cmd.Parameters.AddWithValue("@NumeroTransporte", clsNotaFiscal.NumeroTransporte);
                cmd.Parameters.AddWithValue("@PesoBruto", clsNotaFiscal.PesoBruto);
                cmd.Parameters.AddWithValue("@PesoLiquido", clsNotaFiscal.PesoLiquido);

                cmd.ExecuteNonQuery();
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                if (connection.State == ConnectionState.Open)
                {
                    connection.Close();
                }
            }
        }
Пример #11
0
        public static NotaFiscalTO GetNotaFiscalByID(int IDNotaFiscal)
        {
            String myConnection = "Server=localhost;Database=gerenciadornf;Uid=root;Pwd=;";

            MySqlConnection connection = new MySqlConnection(myConnection);
            MySqlCommand cmd;
            connection.Open();
            try
            {

                NotaFiscalTO clsNotaFiscal = new NotaFiscalTO();

                string strSql = "SELECT NotaFiscal.* FROM NotaFiscal WHERE NotaFiscal.IDNotaFiscal = @IDNotaFiscal";

                cmd = connection.CreateCommand();
                cmd.CommandText = strSql;
                cmd.Parameters.AddWithValue("@IDNotaFiscal", IDNotaFiscal);
                cmd.ExecuteNonQuery();

                MySqlDataReader adap = cmd.ExecuteReader();
                while (adap.Read())
                {
                    clsNotaFiscal.IDNotaFiscal = Convert.ToInt32(adap["IDNotaFiscal"]);
                    clsNotaFiscal.IDEmitente = Convert.ToInt32(adap["IDEmitente"]);
                    clsNotaFiscal.IDTransportadora = Convert.ToInt32(adap["IDTransportadora"]);
                    clsNotaFiscal.IDCliente = Convert.ToInt32(adap["IDCliente"]);
                    clsNotaFiscal.iDFormaPagamento = Convert.ToInt32(adap["iDFormaPagamento"]);
                    clsNotaFiscal.ValorTotal = Convert.ToInt32(adap["ValorTotal"]);
                    clsNotaFiscal.DataCadastro = Convert.ToDateTime(adap["DataCadastro"]);

                    clsNotaFiscal.TipoSaidaEntrada = adap["TipoSaidaEntrada"].ToString();
                    clsNotaFiscal.DataSaidaEntrada = Convert.ToDateTime(adap["DataSaidaEntrada"]);

                    clsNotaFiscal.QtdTransporte = Convert.ToInt32(adap["QtdTransporte"]);
                    clsNotaFiscal.TipoTransporte = adap["TipoTransporte"].ToString();
                    clsNotaFiscal.EspecieTransporte = adap["EspecieTransporte"].ToString();
                    clsNotaFiscal.MarcaTransporte = adap["MarcaTransporte"].ToString();
                    clsNotaFiscal.NumeroTransporte = Convert.ToInt32(adap["NumeroTransporte"]);
                    clsNotaFiscal.PesoBruto = Convert.ToDouble(adap["PesoBruto"]);
                    clsNotaFiscal.PesoLiquido = Convert.ToDouble(adap["PesoLiquido"]);
                }

                return clsNotaFiscal;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            finally
            {
                if (connection.State == ConnectionState.Open)
                {
                    connection.Close();
                }
            }
        }
Пример #12
0
        public static List<NotaFiscalTO> GetNotaFiscalBusca(String strNumeroNota, int intIDEmitente, int intIDCliente)
        {
            String myConnection = "Server=localhost;Database=gerenciadornf;Uid=root;Pwd=;";

            MySqlConnection connection = new MySqlConnection(myConnection);
            MySqlCommand cmd;
            connection.Open();
            try
            {
                List<NotaFiscalTO> clsNotaFiscals = new List<NotaFiscalTO>();

                StringBuilder strSql = new StringBuilder();
                Boolean blnSqlWhere= false;
                strSql.Append(" SELECT notafiscal.*, emitente.nome as nomeEmitente, cliente.nome as nomeCliente FROM notafiscal INNER JOIN Emitente ON emitente.idEmitente = notafiscal.idemitente INNER JOIN Cliente On cliente.idCliente = notafiscal.idCliente ");

                if (!string.IsNullOrEmpty(strNumeroNota))
                {
                    if (!blnSqlWhere)
                    {
                        strSql.Append(" WHERE notafiscal.idnotafiscal = @Notafiscal ");
                        blnSqlWhere = true;
                    }
                    else
                    {
                        strSql.Append(" AND notafiscal.idnotafiscal = @Notafiscal ");
                    }
                }

                if (intIDEmitente != 0 )
                {
                    if (!blnSqlWhere)
                    {
                        blnSqlWhere = true;
                        strSql.Append(" WHERE notafiscal.idemitente = @idemitente ");
                    }
                    else
                    {
                        strSql.Append(" AND notafiscal.idemitente = @idemitente ");
                    }
                }
                if (intIDCliente != 0)
                {
                    if (!blnSqlWhere)
                    {
                        blnSqlWhere = true;
                        strSql.Append(" WHERE notafiscal.idcliente = @idcliente ");
                    }
                    else
                    {
                        strSql.Append(" AND notafiscal.idcliente = @idcliente ");
                    }
                }

                //string strSql = "SELECT notafiscal.*, emitente.nome as nomeEmitente, cliente.nome as nomeCliente FROM notafiscal INNER JOIN Emitente ON emitente.idEmitente = notafiscal.idemitente INNER JOIN Cliente On cliente.idCliente = notafiscal.idCliente";

                cmd = connection.CreateCommand();
                cmd.CommandText = strSql.ToString();
                cmd.Parameters.AddWithValue("@Notafiscal", strNumeroNota);
                cmd.Parameters.AddWithValue("@idemitente", intIDEmitente);
                cmd.Parameters.AddWithValue("@idcliente", intIDCliente);
                cmd.ExecuteNonQuery();

                MySqlDataReader adap = cmd.ExecuteReader();

                while (adap.Read())
                {
                    NotaFiscalTO clsNotaFiscal = new NotaFiscalTO();

                    clsNotaFiscal.IDNotaFiscal = Convert.ToInt32(adap["IDNotaFiscal"]);
                    clsNotaFiscal.IDEmitente = Convert.ToInt32(adap["IDEmitente"]);
                    clsNotaFiscal.IDTransportadora = Convert.ToInt32(adap["IDTransportadora"]);
                    clsNotaFiscal.IDCliente = Convert.ToInt32(adap["IDCliente"]);
                    clsNotaFiscal.iDFormaPagamento = Convert.ToInt32(adap["iDFormaPagamento"]);
                    clsNotaFiscal.ValorTotal = Convert.ToInt32(adap["ValorTotal"]);
                    clsNotaFiscal.DataCadastro = Convert.ToDateTime(adap["DataCadastro"]);

                    clsNotaFiscal.TipoSaidaEntrada = adap["TipoSaidaEntrada"].ToString();

                    clsNotaFiscal.DataSaidaEntrada = Convert.ToDateTime(adap["DataSaidaEntrada"]);

                    clsNotaFiscal.QtdTransporte = Convert.ToInt32(adap["QtdTransporte"]);
                    clsNotaFiscal.TipoTransporte = adap["TipoTransporte"].ToString();
                    clsNotaFiscal.EspecieTransporte = adap["EspecieTransporte"].ToString();
                    clsNotaFiscal.MarcaTransporte = adap["MarcaTransporte"].ToString();
                    clsNotaFiscal.NumeroTransporte = Convert.ToInt32(adap["NumeroTransporte"]);
                    clsNotaFiscal.PesoBruto = Convert.ToDouble(adap["PesoBruto"]);
                    clsNotaFiscal.PesoLiquido = Convert.ToDouble(adap["PesoLiquido"]);

                    clsNotaFiscal.NomeCliente = adap["nomeCliente"].ToString();
                    clsNotaFiscal.NomeEmitente = adap["nomeEmitente"].ToString();

                    clsNotaFiscals.Add(clsNotaFiscal);
                }

                return clsNotaFiscals;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            finally
            {
                if (connection.State == ConnectionState.Open)
                {
                    connection.Close();
                }
            }
        }
 protected void LoadGrid()
 {
     List<NotaFiscalTO> clsNotaFiscal = new List<NotaFiscalTO>();
     clsNotaFiscal = NotaFiscalBLL.getNotaFiscalALL();
     gvNotaFiscal.DataSource = clsNotaFiscal;
     gvNotaFiscal.DataBind();
 }
        private void PopulaDados()
        {
            clsNotaFiscal = this.NotaFiscal;

            populaEmitente();

            populaTransportadora();

            populaCliente();

            populaPagamento();

            if (clsNotaFiscal.TipoSaidaEntrada == "Saída")
            {
                radSaida.Checked = true;
            }
            if (clsNotaFiscal.TipoSaidaEntrada == "Entrada")
            {
                radEntrada.Checked = true;
            }

            if (clsNotaFiscal.TipoTransporte == "Emitente")
            {
                radEmitente.Checked = true;
            }
            if (clsNotaFiscal.TipoTransporte == "Destinatário")
            {
                radDestinatario.Checked = true;
            }

               // txtQtdTransporte.Text = clsNotaFiscal.QtdTransporte.ToString();
            txtEspecieTransporte.Text = clsNotaFiscal.EspecieTransporte;
            txtMarcaTransporte.Text = clsNotaFiscal.MarcaTransporte;
            txtNumeroTransporte.Text = clsNotaFiscal.NumeroTransporte.ToString();
            txtPesoBruto.Text = clsNotaFiscal.PesoBruto.ToString();
            txtPesoLiquido.Text =  clsNotaFiscal.PesoLiquido.ToString();
        }