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