public HomeTypeInfo HomeTypeInfoIDataReader(IDataReader dr)
{
HomeTypeInfo obj = new DataAccess.HomeTypeInfo();
obj.HomeTypeID = (dr["HomeTypeID"] is DBNull) ? string.Empty : dr["HomeTypeID"].ToString();
obj.HomeTypeName = (dr["HomeTypeName"] is DBNull) ? string.Empty : dr["HomeTypeName"].ToString();
return(obj);
}
public List <HomeTypeInfo> HomeTypeInfo_GetByAll()
{
List <DataAccess.HomeTypeInfo> list = new List <DataAccess.HomeTypeInfo>();
DataAccess.HomeTypeInfo obj = new DataAccess.HomeTypeInfo();
DbCommand cmd = db.GetStoredProcCommand("HomeType_SelectAll");
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.HomeTypeInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public List <HomeTypeInfo> HomeTypeInfo_GetByLevel(string Level, int LevelLength)
{
List <DataAccess.HomeTypeInfo> list = new List <DataAccess.HomeTypeInfo>();
DataAccess.HomeTypeInfo obj = new DataAccess.HomeTypeInfo();
DbCommand cmd = db.GetStoredProcCommand("sp_HomeTypeInfo_GetByLevel", Level, LevelLength);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.HomeTypeInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public List <HomeTypeInfo> HomeTypeInfo_Paging(string CurentHomeTypeInfo, string HomeTypeInfoSize)
{
List <DataAccess.HomeTypeInfo> list = new List <DataAccess.HomeTypeInfo>();
DataAccess.HomeTypeInfo obj = new DataAccess.HomeTypeInfo();
DbCommand cmd = db.GetStoredProcCommand("HomeType_SelectPage", CurentHomeTypeInfo, HomeTypeInfoSize);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.HomeTypeInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
