public static IQueryable <MarketCarInfo> GetCarsComMarketCarQuery(vincontrolscrappingEntities context, int?year) { if (!year.HasValue) { return(null); } if (year.Value <= 2000) { return(CarsComMapper.GetMarketCarInfoQuery(context.carscom_lessorequal_year2000).Where(x => x.Year == year)); } else if (year.Value >= 2001 && year.Value <= 2003) { return(CarsComMapper.GetMarketCarInfoQuery(context.carscom_from_year2001_to_year2003).Where(x => x.Year == year)); } else if (year.Value >= 2004 && year.Value <= 2005) { return(CarsComMapper.GetMarketCarInfoQuery(context.carscom_from_year2004_to_year2005).Where(x => x.Year == year)); } else if (year.Value == 2006) { return(CarsComMapper.GetMarketCarInfoQuery(context.carscom_year2006)); } else if (year.Value == 2007) { return(CarsComMapper.GetMarketCarInfoQuery(context.carscom_year2007)); } else if (year.Value == 2008) { return(CarsComMapper.GetMarketCarInfoQuery(context.carscom_year2008)); } else if (year.Value == 2009) { return(CarsComMapper.GetMarketCarInfoQuery(context.carscom_year2009)); } else if (year.Value == 2010) { return(CarsComMapper.GetMarketCarInfoQuery(context.carscom_year2010)); } else if (year.Value == 2011) { return(CarsComMapper.GetMarketCarInfoQuery(context.carscom_year2011)); } else if (year.Value == 2012) { return(CarsComMapper.GetMarketCarInfoQuery(context.carscom_year2012)); } else if (year.Value == 2013) { return(CarsComMapper.GetMarketCarInfoQuery(context.carscom_year2013)); } return(null); }
public static IQueryable <manheim_auctions> GetManheimAuctionMarketData(int year, string make, string modelWord, string trim) { var context = new vincontrolscrappingEntities(); if (make.ToLower().Equals("bmw") && modelWord.ToLower().Contains("series")) { modelWord = trim; } if (make.ToLower().Equals("mercedes-benz") && modelWord.ToLower().Contains("class")) { modelWord = trim; modelWord = modelWord.Replace("Sport", ""); modelWord = modelWord.Replace("Luxry", ""); modelWord = modelWord.Replace("BlueTEC", ""); modelWord = modelWord.Replace("BTC", ""); modelWord = modelWord.Replace("CDI", ""); modelWord = modelWord.Replace("BLK", ""); if (modelWord.Length >= 2) { if (modelWord.Substring(modelWord.Length - 2, 2).Equals("S4")) { modelWord = modelWord.Replace("S4", ""); } if (modelWord.Substring(modelWord.Length - 2, 2).Equals("V4")) { modelWord = modelWord.Replace("V4", ""); } if (modelWord.Substring(modelWord.Length - 2, 2).Equals("W4")) { modelWord = modelWord.Replace("W4", ""); } if (modelWord.Substring(modelWord.Length - 2, 2).Equals("AE")) { modelWord = modelWord.Replace("AE", ""); } if (modelWord.Substring(modelWord.Length - 2, 2).Equals("WZ")) { modelWord = modelWord.Replace("WZ", ""); } } if (modelWord[modelWord.Length - 1] == 'W') { modelWord = modelWord.Substring(0, modelWord.Length - 1); } if (modelWord[modelWord.Length - 1] == 'R') { modelWord = modelWord.Substring(0, modelWord.Length - 1); } if (modelWord[modelWord.Length - 1] == 'V') { modelWord = modelWord.Substring(0, modelWord.Length - 1); } if (modelWord[modelWord.Length - 1] == 'C') { modelWord = modelWord.Substring(0, modelWord.Length - 1); } if (modelWord[modelWord.Length - 1] == 'A') { modelWord = modelWord.Substring(0, modelWord.Length - 1); } if (modelWord[modelWord.Length - 1] == 'K') { modelWord = modelWord.Substring(0, modelWord.Length - 1); } } modelWord = FilterCarModelForMarket(modelWord); if (!make.ToLower().Equals("land rover")) { var result = context.manheim_auctions.Where(i => i.Year == year && i.Make == make && ((i.Model.Replace("-", "").Replace(" ", "").ToLower() + i.Trim.Replace(" ", "").Trim().ToLower()).Contains(modelWord.Replace(" ", "").ToLower())) && i.Mmr > 0); return(result); } else { if (modelWord.ToLower().Contains("rangeroversport")) { var result = context.manheim_auctions.Where(i => i.Year == year && i.Make == make && ((i.Model.Replace("-", "").Replace(" ", "").ToLower() + i.Trim.Replace(" ", "").ToLower()).Contains("rangeroversport") && i.Mmr > 0)); return(result); } else if (modelWord.ToLower().Contains("rangeroverevoque")) { var result = context.manheim_auctions.Where(i => i.Year == year && i.Make == make && ((i.Model.Replace("-", "").Replace(" ", "").ToLower() + i.Trim.Replace(" ", "").ToLower()).Contains("rangeroverevoque") && i.Mmr > 0)); return(result); } else if (modelWord.ToLower().Equals("rangerover")) { var result = context.manheim_auctions.Where(i => i.Year == year && i.Make == make && ((i.Model.Replace("-", "").Replace(" ", "").ToLower() + i.Trim.Replace(" ", "").ToLower()).Contains("rangerover") && !(i.Model.Replace("-", "").Replace(" ", "").ToLower() + i.Trim.Replace(" ", "").ToLower()).Contains("sport") && !(i.Model.Replace("-", "").Replace(" ", "").ToLower() + i.Trim.Replace(" ", "").ToLower()).Contains("evoque") && i.Mmr > 0)); return(result); } else { var result = context.manheim_auctions.Where(i => i.Year == year && i.Make == make && ((i.Model.Replace("-", "").Replace(" ", "").ToLower() + i.Trim.Replace(" ", "").Trim().ToLower()).Contains(modelWord.Replace(" ", "").ToLower())) && i.Mmr > 0); return(result); } } }