Exemple #1
0
        public List <MLFormaPgto> Listar(MLFormaPgto formaPgto)
        {
            DlConexao          objDLConexao   = new DlConexao();
            List <MLFormaPgto> lstMLFormaPgto = new List <MLFormaPgto>();

            try
            {
                objDLConexao.limparParametros();
                DataTable dt = objDLConexao.ExecutarConsulta(CommandType.StoredProcedure, "[dbo].[P_ListarFormaPgto]");

                if (dt != null)
                {
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        formaPgto = new MLFormaPgto();
                        formaPgto = Genericos.Popular <MLFormaPgto>(dt, i);
                        lstMLFormaPgto.Add(formaPgto);
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (objDLConexao != null)
                {
                    objDLConexao = null;
                }
            }
            return(lstMLFormaPgto);
        }
Exemple #2
0
        public List <MLFormaPgto> ListarFormaPagamento(int FormaPgtoId = 0)
        {
            DlConexao          objDLConexao = new DlConexao();
            DataTable          dt           = new DataTable();
            List <MLFormaPgto> lst          = new List <MLFormaPgto>();

            try
            {
                objDLConexao.limparParametros();

                dt = objDLConexao.ExecutarConsulta(CommandType.StoredProcedure, "[dbo].[P_ListarFormaPgto]");

                if (dt != null)
                {
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        MLFormaPgto objMlFormaPagamento = new MLFormaPgto();
                        objMlFormaPagamento.FormaPgtoId = Convert.ToInt32(dt.Rows[i].ItemArray[0]);
                        objMlFormaPagamento.Descricao   = Convert.ToString(dt.Rows[i].ItemArray[1]);
                        lst.Add(objMlFormaPagamento);
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (objDLConexao != null)
                {
                    objDLConexao = null;
                }
            }

            return(lst);
        }