private List <BEDvv> MapearDvv(DataTable dt)
{
List <BEDvv> lstDvv = new List <BEDvv>();
foreach (DataRow _row in dt.Rows)
{
BEDvv unDvv = new BEDvv();
unDvv.Entidad = System.Convert.ToString(_row["entidad"]);
unDvv.Dvv = System.Convert.ToInt32(_row["dvv"]);
lstDvv.Add(unDvv);
}
return(lstDvv);
}
public List <BEDvv> Retrieve(BEDvv unDvv)
{
List <BEDvv> lista = new List <BEDvv>();
string _SP = "DvvSelect";
SqlParameter[] sqlParametros = new SqlParameter[1];
sqlParametros[0] = DALSqlHelper.instancia.crearParametro("entidad", unDvv.Entidad);
DataTable dtDvv = new DataTable();
dtDvv = DALSqlHelper.instancia.EjecutarConsulta(_SP, sqlParametros);
if (dtDvv.Rows.Count <= 0)
{
return(null);
}
else
{
lista = MapearDvv(dtDvv);
return(lista);
}
/* TODO Change to default(_) if this is not a reference type */;
//return MapearDvv(dtDvv)(0);
}
