public RealEstateInfo RealEstateInfoIDataReader(IDataReader dr)
{
DataAccess.RealEstateInfo obj = new DataAccess.RealEstateInfo();
obj.RealEstateID = (dr["RealEstateID"] is DBNull) ? string.Empty : dr["RealEstateID"].ToString();
obj.RealEstateName = (dr["RealEstateName"] is DBNull) ? string.Empty : dr["RealEstateName"].ToString();
obj.RealEstateTypeID = (dr["RealEstateTypeID"] is DBNull) ? string.Empty : dr["RealEstateTypeID"].ToString();
obj.LocationID = (dr["LocationID"] is DBNull) ? string.Empty : dr["LocationID"].ToString();
obj.Description = (dr["Description"] is DBNull) ? string.Empty : dr["Description"].ToString();
obj.CityID = (dr["CityID"] is DBNull) ? string.Empty : dr["CityID"].ToString();
obj.CreateBy = (dr["CreateBy"] is DBNull) ? string.Empty : dr["CreateBy"].ToString();
obj.CreateDate = (dr["CreateDate"] is DBNull) ? string.Empty : dr["CreateDate"].ToString();
obj.DistrictID = (dr["DistrictID"] is DBNull) ? string.Empty : dr["DistrictID"].ToString();
obj.RealEstateOwnersID = (dr["RealEstateOwnersID"] is DBNull) ? string.Empty : dr["RealEstateOwnersID"].ToString();
obj.Address = (dr["Address"] is DBNull) ? string.Empty : dr["Address"].ToString();
obj.Price = (dr["Price"] is DBNull) ? string.Empty : dr["Price"].ToString();
obj.Description = (dr["Description"] is DBNull) ? string.Empty : dr["Description"].ToString();
obj.Area = (dr["Area"] is DBNull) ? string.Empty : dr["Area"].ToString();
obj.Lengh = (dr["Lengh"] is DBNull) ? string.Empty : dr["Lengh"].ToString();
obj.Width = (dr["Width"] is DBNull) ? string.Empty : dr["Width"].ToString();
obj.Height = (dr["Height"] is DBNull) ? string.Empty : dr["Height"].ToString();
obj.Images = (dr["Images"] is DBNull) ? string.Empty : dr["Images"].ToString();
obj.Status = (dr["Status"] is DBNull) ? string.Empty : dr["Status"].ToString();
obj.IsVip = (dr["IsVip"] is DBNull) ? string.Empty : dr["IsVip"].ToString();
obj.Period = (dr["Period"] is DBNull) ? string.Empty : dr["Period"].ToString();
return(obj);
}
public List <RealEstateInfo> RealEstateInfo_GetByAll()
{
List <DataAccess.RealEstateInfo> list = new List <DataAccess.RealEstateInfo>();
DataAccess.RealEstateInfo obj = new DataAccess.RealEstateInfo();
DbCommand cmd = db.GetStoredProcCommand("RealEstates_SelectAll");
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.RealEstateInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public List <RealEstateInfo> RealEstateInfo_GetByLevel(string Level, int LevelLength)
{
List <DataAccess.RealEstateInfo> list = new List <DataAccess.RealEstateInfo>();
DataAccess.RealEstateInfo obj = new DataAccess.RealEstateInfo();
DbCommand cmd = db.GetStoredProcCommand("sp_RealEstateInfo_GetByLevel", Level, LevelLength);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.RealEstateInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public List <RealEstateInfo> RealEstateInfo_Paging(string CurentRealEstateInfo, string RealEstateInfoSize)
{
List <DataAccess.RealEstateInfo> list = new List <DataAccess.RealEstateInfo>();
DataAccess.RealEstateInfo obj = new DataAccess.RealEstateInfo();
DbCommand cmd = db.GetStoredProcCommand("RealEstates_SelectPage", CurentRealEstateInfo, RealEstateInfoSize);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.RealEstateInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
