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); }