public ApartmentInfo ApartmentInfoIDataReader(IDataReader dr)
{
ApartmentInfo obj = new DataAccess.ApartmentInfo();
obj.ApartmentID = (dr["ApartmentID"] is DBNull) ? string.Empty : dr["ApartmentID"].ToString();
obj.RealEstateOwnersID = (dr["RealEstateOwnersID"] is DBNull) ? string.Empty : dr["RealEstateOwnersID"].ToString();
obj.RealEstateID = (dr["RealEstateID"] is DBNull) ? string.Empty : dr["RealEstateID"].ToString();
obj.CityID = (dr["CityID"] is DBNull) ? string.Empty : dr["CityID"].ToString();
obj.DistrictID = (dr["DistrictID"] is DBNull) ? string.Empty : dr["DistrictID"].ToString();
obj.LocationID = (dr["LocationID"] is DBNull) ? string.Empty : dr["LocationID"].ToString();
obj.Name = (dr["Name"] is DBNull) ? string.Empty : dr["Name"].ToString();
obj.Title = (dr["Title"] is DBNull) ? string.Empty : dr["Title"].ToString();
obj.Tag = (dr["Tag"] is DBNull) ? string.Empty : dr["Tag"].ToString();
obj.TransactionType = (dr["TransactionType"] is DBNull) ? string.Empty : dr["TransactionType"].ToString();
obj.Description = (dr["Description"] is DBNull) ? string.Empty : dr["Description"].ToString();
obj.Address = (dr["Address"] is DBNull) ? string.Empty : dr["Address"].ToString();
obj.Price = (dr["Price"] is DBNull) ? string.Empty : dr["Price"].ToString();
obj.TotalArea = (dr["TotalArea"] is DBNull) ? string.Empty : dr["TotalArea"].ToString();
obj.FloorArea = (dr["FloorArea"] is DBNull) ? string.Empty : dr["FloorArea"].ToString();
obj.HomeArea = (dr["HomeArea"] is DBNull) ? string.Empty : dr["HomeArea"].ToString();
obj.BedroomNumber = (dr["BedroomNumber"] is DBNull) ? string.Empty : dr["BedroomNumber"].ToString();
obj.TierNumber = (dr["TierNumber"] is DBNull) ? string.Empty : dr["TierNumber"].ToString();
obj.CreateBy = (dr["CreateBy"] is DBNull) ? string.Empty : dr["CreateBy"].ToString();
obj.CreateDate = (dr["CreateDate"] is DBNull) ? string.Empty : dr["CreateDate"].ToString();
obj.Lang = (dr["Lang"] is DBNull) ? string.Empty : dr["Lang"].ToString();
obj.Image1 = (dr["Image1"] is DBNull) ? string.Empty : dr["Image1"].ToString();
obj.Image2 = (dr["Image2"] is DBNull) ? string.Empty : dr["Image2"].ToString();
obj.Image3 = (dr["Image3"] is DBNull) ? string.Empty : dr["Image3"].ToString();
obj.Image4 = (dr["Image4"] is DBNull) ? string.Empty : dr["Image4"].ToString();
obj.Image5 = (dr["Image5"] is DBNull) ? string.Empty : dr["Image5"].ToString();
obj.Image6 = (dr["Image6"] is DBNull) ? string.Empty : dr["Image6"].ToString();
return(obj);
}
public List <ApartmentInfo> ApartmentInfo_GetByAll(string Lang)
{
List <DataAccess.ApartmentInfo> list = new List <DataAccess.ApartmentInfo>();
using (SqlCommand dbCmd = new SqlCommand("Apartment_SelectAll", GetConnection()))
{
DataAccess.ApartmentInfo obj = new DataAccess.ApartmentInfo();
dbCmd.CommandType = CommandType.StoredProcedure;
dbCmd.Parameters.Add(new SqlParameter("@Lang", Lang));
SqlDataReader dr = dbCmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
list.Add(obj.ApartmentInfoIDataReader(dr));
}
}
dr.Close();
obj = null;
}
return(list);
}
public List <ApartmentInfo> ApartmentInfo_GetByTop(string Top, string Where, string Order)
{
List <DataAccess.ApartmentInfo> list = new List <DataAccess.ApartmentInfo>();
using (SqlCommand dbCmd = new SqlCommand("Apartment_SelectTop", GetConnection()))
{
DataAccess.ApartmentInfo obj = new DataAccess.ApartmentInfo();
dbCmd.CommandType = CommandType.StoredProcedure;
dbCmd.Parameters.Add(new SqlParameter("@Top", Top));
dbCmd.Parameters.Add(new SqlParameter("@Where", Where));
dbCmd.Parameters.Add(new SqlParameter("@Order", Order));
SqlDataReader dr = dbCmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
list.Add(obj.ApartmentInfoIDataReader(dr));
}
}
dr.Close();
obj = null;
}
return(list);
}
