public static clsListHouses getHouses() { clsListHouses tmp = new clsListHouses(); IRemaxData rmx = new clsRemaxData(); DataTable tab = null; tab = rmx.getHouses(); foreach (DataRow rowHouse in tab.Rows) { //Get client for house clsClient client = null; if (Convert.ToInt32(rowHouse["client"].ToString()) > 0) { DataRow rowClient = rmx.getClient(Convert.ToInt32(rowHouse["client"].ToString())); if (rowClient != null) { client = new clsClient(Convert.ToInt32(rowClient["ID"].ToString()), rowClient["fullname"].ToString(), rowClient["phone"].ToString(), rowClient["email"].ToString(), (enumClientType)Enum.Parse(typeof(enumClientType), rowClient["type"].ToString()), null); } } clsHouse house = new clsHouse(Convert.ToInt32(rowHouse["id"].ToString()), rowHouse["code"].ToString(), Convert.ToSingle(rowHouse["aria"].ToString()), Convert.ToByte(rowHouse["rooms"].ToString()), Convert.ToByte(rowHouse["bathrooms"].ToString()), (enumCityzone)Enum.Parse(typeof(enumCityzone), rowHouse["cityzone"].ToString()), rowHouse["address"].ToString(), Convert.ToSingle(rowHouse["price"].ToString()), rowHouse["description"].ToString(), (enumHouseType)Enum.Parse(typeof(enumHouseType), rowHouse["type"].ToString()), rowHouse["pic"].ToString(), (enumHouseStatus)Enum.Parse(typeof(enumHouseStatus), rowHouse["status"].ToString()), Convert.ToDateTime(rowHouse["datein"]), client, Convert.ToInt32(rowHouse["employee"].ToString())); tmp.Add(house, house.Code); house = null; } tab = null; return(tmp); }