public List <RealEstateOwnersInfo> RealEstateOwnersInfo_GetByLevel(string Level, int LevelLength)
{
List <DataAccess.RealEstateOwnersInfo> list = new List <DataAccess.RealEstateOwnersInfo>();
DataAccess.RealEstateOwnersInfo obj = new DataAccess.RealEstateOwnersInfo();
DbCommand cmd = db.GetStoredProcCommand("sp_RealEstateOwnersInfo_GetByLevel", Level, LevelLength);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.RealEstateOwnersInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public List <RealEstateOwnersInfo> RealEstateOwnersInfo_GetByAll()
{
List <DataAccess.RealEstateOwnersInfo> list = new List <DataAccess.RealEstateOwnersInfo>();
DataAccess.RealEstateOwnersInfo obj = new DataAccess.RealEstateOwnersInfo();
DbCommand cmd = db.GetStoredProcCommand("RealEstateOwners_SelectAll");
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.RealEstateOwnersInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public List <RealEstateOwnersInfo> RealEstateOwnersInfo_Paging(string CurentRealEstateOwnersInfo, string RealEstateOwnersInfoSize)
{
List <DataAccess.RealEstateOwnersInfo> list = new List <DataAccess.RealEstateOwnersInfo>();
DataAccess.RealEstateOwnersInfo obj = new DataAccess.RealEstateOwnersInfo();
DbCommand cmd = db.GetStoredProcCommand("RealEstateOwners_SelectPage", CurentRealEstateOwnersInfo, RealEstateOwnersInfoSize);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.RealEstateOwnersInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}