public List <IndustrialArea> GetAreaByCityId(int cityId) { OfferQuery offerQuery = new OfferQuery(language); System.Data.DataTable dataTable = conn_db.ReadTable(offerQuery.GetObjectByColname("IndustrialAreas", "CITY_ID", cityId)); if (dataTable.Rows.Count == 0) { throw new EmptyViewException(language); } IndustrialArea industrialArea; List <IndustrialArea> listArea = new List <IndustrialArea>(); foreach (System.Data.DataRow row in dataTable.Rows) { industrialArea = new IndustrialArea(); industrialArea.id = Convert.ToInt32(row["id"].ToString()); industrialArea.areaName = row["areaName"].ToString(); industrialArea.areaNumber = row["areaNumber"].ToString(); industrialArea.areaLocationX = row["LocationX"].ToString(); industrialArea.areaLocationY = row["LocationY"].ToString(); listArea.Add(industrialArea); } return(listArea); }