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); }
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); }