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