public List <Models.User> GetName(Models.Search P_NAME)
{
List <Models.User> ret = new List <Models.User>();
BdUtil bdUtil = new BdUtil();
System.Data.Common.DbDataReader rs = bdUtil.Qry("select ID,NAME,AGE,ADDRESS from USERS where upper(name) like '%" + P_NAME.Name.ToUpperInvariant() + "%' order by NAME", null);
while (rs.Read())
{
ret.Add(new Models.User {
Id = rs.GetInt32(0), Name = rs.GetString(1), Age = rs.GetInt32(2), Address = rs.GetString(3)
});
}
return(ret);
}
public List <Models.User> GetAll()
{
List <Models.User> ret = new List <Models.User>();
BdUtil bdUtil = new BdUtil();
System.Data.Common.DbDataReader rs = bdUtil.Qry("select ID,NAME,AGE,ADDRESS from USERS order by NAME", null);
while (rs.Read())
{
ret.Add(new Models.User {
Id = rs.GetInt32(0), Name = rs.GetString(1), Age = rs.GetInt32(2), Address = rs.GetString(3)
});
}
return(ret);
}
public Models.User GetId(int P_ID)
{
Models.User ret = new Models.User();
BdUtil bdUtil = new BdUtil();
System.Data.Common.DbDataReader rs = bdUtil.Qry("select ID,NAME,AGE,ADDRESS from USERS where ID = " + P_ID, null);
while (rs.Read())
{
ret.Id = rs.GetInt32(0);
ret.Name = rs.GetString(1);
ret.Age = rs.GetInt32(2);
ret.Address = rs.GetString(3);
}
return(ret);
}
