public IEnumerable<roomimage> GetRoomImagesByRoomId()
{
using (SqlDataReader sdr = SqlHelper.ExecuteReader(SqlHelper.GetConnection(), "[GetRoomImagesByRoomId]", RoomId))
{
IEnumerable<roomimage> lstRoomImage = new IEnumerable<roomimage>();
RoomImage objRoomImage = new RoomImage();
if (sdr.HasRows)
{
while (sdr.Read())
{
yield return new RoomImage
{
objRoomImage.RoomId = Convert.ToInt32(sdr["RoomId"]),
objRoomImage. RoomImageId = Convert.ToInt32(sdr["RoomImageId"]),
objRoomImage. ThumbnailImage = Convert.ToString(sdr["ThumbnailImage"]),
objRoomImage.NormalImage = Convert.ToString(sdr["NormalImage"])
lstRoomImage.Add(objRoomImage);
};
}
}
}
retrun lstRoomImage;
}
</roomimage></roomimage></roomimage>