public RealEstateTypeInfo RealEstateTypeInfoIDataReader(IDataReader dr)
{
DataAccess.RealEstateTypeInfo obj = new DataAccess.RealEstateTypeInfo();
obj.RealEstateTypeID = (dr["RealEstateTypeID"] is DBNull) ? string.Empty : dr["RealEstateTypeID"].ToString();
obj.NameRealEstateType = (dr["NameRealEstateType"] is DBNull) ? string.Empty : dr["NameRealEstateType"].ToString();
obj.Description = (dr["Description"] is DBNull) ? string.Empty : dr["Description"].ToString();
return(obj);
}
public List <RealEstateTypeInfo> RealEstateTypeInfo_GetByLevel(string Level, int LevelLength)
{
List <DataAccess.RealEstateTypeInfo> list = new List <DataAccess.RealEstateTypeInfo>();
DataAccess.RealEstateTypeInfo obj = new DataAccess.RealEstateTypeInfo();
DbCommand cmd = db.GetStoredProcCommand("sp_RealEstateTypeInfo_GetByLevel", Level, LevelLength);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.RealEstateTypeInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public List <RealEstateTypeInfo> RealEstateTypeInfo_GetByAll()
{
List <DataAccess.RealEstateTypeInfo> list = new List <DataAccess.RealEstateTypeInfo>();
DataAccess.RealEstateTypeInfo obj = new DataAccess.RealEstateTypeInfo();
DbCommand cmd = db.GetStoredProcCommand("RealEstateType_SelectAll");
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.RealEstateTypeInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public List <RealEstateTypeInfo> RealEstateTypeInfo_Paging(string CurentRealEstateTypeInfo, string RealEstateTypeInfoSize)
{
List <DataAccess.RealEstateTypeInfo> list = new List <DataAccess.RealEstateTypeInfo>();
DataAccess.RealEstateTypeInfo obj = new DataAccess.RealEstateTypeInfo();
DbCommand cmd = db.GetStoredProcCommand("RealEstateType_SelectPage", CurentRealEstateTypeInfo, RealEstateTypeInfoSize);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.RealEstateTypeInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}