public ArticleViewModel GetHouses(int id) { try { ArticleViewModel articleViewModel = new ArticleViewModel(); IQueryable <House> HouseListEF = from h in db.Houses where h.ArticleId == id select h; List <House> HouseList = HouseListEF.ToList(); House house = null; HouseAux houseAux = null; foreach (var houseResult in HouseList) { if (house == null) { house = houseResult; var houseFeatureHouse = from f in db.HouseFeatureHouse where f.HouseId == house.HouseId select f; house.HouseFeaturesHouse = houseFeatureHouse.ToList(); } else { houseAux = new HouseAux(); houseAux.Id = houseResult.HouseId; houseAux.BathroomsAux = houseResult.Bathrooms; houseAux.BedroomsAux = houseResult.Bedrooms; houseAux.GarageAux = houseResult.Garage; houseAux.HouseBackgroundMeasureAux = houseResult.HouseBackgroundMeasure; houseAux.HouseForeheadMeasureAux = houseResult.HouseForeheadMeasure; houseAux.LevelsAux = houseResult.Levels; var houseFeatureHouseAux = from f in db.HouseFeatureHouse where f.HouseId == houseAux.Id select f; houseAux.HouseFeaturesHouse = houseFeatureHouseAux.ToList(); } } articleViewModel.House = house; articleViewModel.HouseAux = houseAux; return(articleViewModel); } catch (Exception ex) { throw; } }
public ArticleViewModel GetFeatures(Article article, House house, HouseAux houseAux) { ArticleViewModel articleViewModel = new ArticleViewModel(); var terrainFeaturesid = from f in db.TerrainFeaturesTerrain where f.TerrainId == article.TerrainId select f.TerrainFeatureId; ICollection <int> terrainFeatures = new List <int>(); foreach (var feature in terrainFeaturesid) { terrainFeatures.Add(feature); } //articleViewModel.Article.Terrain.TerrainFeaturesTerrain = terrainFeatures.ToArray(); var houseFeaturesid = from h in db.HouseFeatureHouse where h.HouseId == house.HouseId select h.HouseFeatureId; if (house != null) { ICollection <int> houseFeatures = new List <int>(); foreach (var feature in houseFeaturesid) { houseFeatures.Add(feature); } //articleViewModel.HouseFeatures = houseFeatures.ToArray(); } var houseAuxFeaturesid = from h in db.HouseFeatureHouse where h.HouseId == houseAux.Id select h.HouseFeatureId; if (houseAux != null) { ICollection <int> houseAuxFeatures = new List <int>(); foreach (var feature in houseAuxFeaturesid) { houseAuxFeatures.Add(feature); } //articleViewModel.HouseAuxFeatures = houseAuxFeatures.ToArray(); } return(articleViewModel); }
public ArticleViewModel SetArticleViewModel(List <ArticlePicture> pictures, ArticlePicture outstandingPicture, House house, HouseAux houseAux, Article article) { try { ArticleViewModel articleViewModel = new ArticleViewModel(); articleViewModel.Article = article; articleViewModel.Pictures = pictures; articleViewModel.OutstandingPicture = outstandingPicture; articleViewModel.House = house; articleViewModel.HouseAux = houseAux; return(articleViewModel); } catch (Exception ex) { ViewBag.error += "Error al setear el modelo de articulo" + ex.InnerException; return(null); } }