public static BlackBookViewModel GetBBModelInDatabase(string Vin) { BlackBookViewModel dealerPrice = new BlackBookViewModel() { Vin = Vin, TrimReportList = new List <BlackBookTrimReport>() }; int status = SQLHelper.CheckVinHasBbReport(Vin); if (status == 1) { var context = new whitmanenterprisewarehouseEntities(); var list = context.whitmanenterprisebbs.Where(x => x.Vin.Equals(Vin)); foreach (whitmanenterprisebb bb in list) { BlackBookTrimReport TrimReport = new BlackBookTrimReport() { TradeInRough = CommonHelper.ConvertToCurrency(bb.TradeInFairPrice), TradeInAvg = CommonHelper.ConvertToCurrency(bb.TradeInGoodPrice), TradeInClean = CommonHelper.ConvertToCurrency(bb.TradeInVeryGoodPrice), TrimName = bb.Trim }; dealerPrice.TrimReportList.Add(TrimReport); dealerPrice.ExistDatabase = status; } } else { dealerPrice.ExistDatabase = status; } return(dealerPrice); }
//public static BlackBookViewModel GetDealerPrice(string Vin,int Mileage,string State) //{ // BlackBookViewModel blackbook = new BlackBookViewModel() // { // Vin=Vin // }; // DataTable dt = GetValuesFromVin(Vin, Mileage,State); // if (dt != null) // { // blackbook.TrimList = new List<BlackBookTrimDetail>(); // foreach (DataRow dr in dt.Rows) // { // BlackBookTrimDetail trimDetail = new BlackBookTrimDetail() // { // TrimName = dr.Field<string>("series") // }; // trimDetail.MaximumPrice = dr.Field<Decimal>("tradein_clean").ToString("c0"); // trimDetail.AveragePrice = dr.Field<Decimal>("tradein_avg").ToString("c0"); // trimDetail.MinimumPrice = dr.Field<Decimal>("tradein_rough").ToString("c0"); // blackbook.TrimList.Add(trimDetail); // } // blackbook.Success = true; // } // else // blackbook.Success = false; // return blackbook; //} public static BlackBookViewModel GetDirectFullReport(string Vin, string Mileage, string State) { BlackBookViewModel blackbook = new BlackBookViewModel() { Vin = Vin }; if (!String.IsNullOrEmpty(Vin)) { int MileageResult = 0; bool flag = Int32.TryParse(Mileage, out MileageResult); if (flag) { Hashtable hashUnique = new Hashtable(); DataTable dt = GetValuesFromVin(Vin, MileageResult, State); if (dt != null) { blackbook.TrimReportList = new List <BlackBookTrimReport>(); foreach (DataRow dr in dt.Rows) { BlackBookTrimReport trimDetail = new BlackBookTrimReport(); if (!String.IsNullOrEmpty(dr["series"].ToString())) { trimDetail.TrimName = dr.Field <string>("series"); } else { trimDetail.TrimName = dr.Field <string>("model"); } if (!hashUnique.Contains(trimDetail.TrimName)) { hashUnique.Add(trimDetail.TrimName, trimDetail.TrimName); trimDetail.BaseWholeSaleExtraClean = dr.Field <Decimal>("base_whole_xclean").ToString("c0"); trimDetail.BaseWholeSaleClean = dr.Field <Decimal>("base_whole_clean").ToString("c0"); trimDetail.BaseWholeSaleAvg = dr.Field <Decimal>("base_whole_avg").ToString("c0"); trimDetail.BaseWholeSaleRough = dr.Field <Decimal>("base_whole_rough").ToString("c0"); trimDetail.WholeSaleExtraClean = dr.Field <Decimal>("whole_xclean").ToString("c0"); trimDetail.WholeSaleClean = dr.Field <Decimal>("whole_clean").ToString("c0"); trimDetail.WholeSaleAvg = dr.Field <Decimal>("whole_avg").ToString("c0"); trimDetail.WholeSaleRough = dr.Field <Decimal>("whole_rough").ToString("c0"); trimDetail.MileageAdjWholeSaleExtraClean = dr.Field <Decimal>("mileage_adj_whole_xclean").ToString("c0"); trimDetail.MileageAdjWholeSaleClean = dr.Field <Decimal>("mileage_adj_whole_clean").ToString("c0"); trimDetail.MileageAdjWholeSaleAvg = dr.Field <Decimal>("mileage_adj_whole_avg").ToString("c0"); trimDetail.MileageAdjWholeSaleRough = dr.Field <Decimal>("mileage_adj_whole_rough").ToString("c0"); trimDetail.ManualOrAutomaticAdjWholeSaleExtraClean = dr.Field <Decimal>("ad_adj_whole_xclean").ToString("c0"); trimDetail.ManualOrAutomaticAdjWholeSaleClean = dr.Field <Decimal>("ad_adj_whole_clean").ToString("c0"); trimDetail.ManualOrAutomaticAdjWholeSaleAvg = dr.Field <Decimal>("ad_adj_whole_avg").ToString("c0"); trimDetail.ManualOrAutomaticAdjWholeSaleRough = dr.Field <Decimal>("ad_adj_whole_rough").ToString("c0"); trimDetail.BaseRetailExtraClean = dr.Field <Decimal>("base_retail_xclean").ToString("c0"); trimDetail.BaseRetailClean = dr.Field <Decimal>("base_retail_clean").ToString("c0"); trimDetail.BaseRetailAvg = dr.Field <Decimal>("base_retail_avg").ToString("c0"); trimDetail.BaseRetailRough = dr.Field <Decimal>("base_retail_rough").ToString("c0"); trimDetail.RetailExtraClean = dr.Field <Decimal>("retail_xclean").ToString("c0"); trimDetail.RetailaClean = dr.Field <Decimal>("retail_clean").ToString("c0"); trimDetail.RetailAvg = dr.Field <Decimal>("retail_avg").ToString("c0"); trimDetail.RetailRough = dr.Field <Decimal>("retail_rough").ToString("c0"); trimDetail.MileageAdjRetailExtraClean = dr.Field <Decimal>("mileage_adj_retail_xclean").ToString("c0"); trimDetail.MileageAdjRetailClean = dr.Field <Decimal>("mileage_adj_retail_clean").ToString("c0"); trimDetail.MileageAdjRetailAvg = dr.Field <Decimal>("mileage_adj_retail_avg").ToString("c0"); trimDetail.MileageAdjRetailRough = dr.Field <Decimal>("mileage_adj_retail_rough").ToString("c0"); trimDetail.ManualOrAutomaticAdjRetailExtraClean = dr.Field <Decimal>("ad_adj_retail_xclean").ToString("c0"); trimDetail.ManualOrAutomaticAdjRetailClean = dr.Field <Decimal>("ad_adj_retail_clean").ToString("c0"); trimDetail.ManualOrAutomaticAdjRetailAvg = dr.Field <Decimal>("ad_adj_retail_avg").ToString("c0"); trimDetail.ManualOrAutomaticAdjRetailRough = dr.Field <Decimal>("ad_adj_retail_rough").ToString("c0"); trimDetail.TradeInClean = dr.Field <Decimal>("tradein_clean").ToString("c0"); trimDetail.TradeInAvg = dr.Field <Decimal>("tradein_avg").ToString("c0"); trimDetail.TradeInRough = dr.Field <Decimal>("tradein_rough").ToString("c0"); trimDetail.BaseTradeInClean = dr.Field <Decimal>("base_tradein_clean").ToString("c0"); trimDetail.BaseTradeInAvg = dr.Field <Decimal>("base_tradein_avg").ToString("c0"); trimDetail.BaseTradeInRough = dr.Field <Decimal>("base_tradein_rough").ToString("c0"); trimDetail.MileageAdjTradeInClean = dr.Field <Decimal>("mileage_adj_tradein_clean").ToString("c0"); trimDetail.MileageAdjTradeInAvg = dr.Field <Decimal>("mileage_adj_tradein_avg").ToString("c0"); trimDetail.MileageAdjTradeInRough = dr.Field <Decimal>("mileage_adj_tradein_rough").ToString("c0"); trimDetail.ManualOrAutomaticAdjTradeInClean = dr.Field <Decimal>("ad_adj_tradein_clean").ToString("c0"); trimDetail.ManualOrAutomaticAdjTradeInAvg = dr.Field <Decimal>("ad_adj_tradein_avg").ToString("c0"); trimDetail.ManualOrAutomaticAdjTradeInRough = dr.Field <Decimal>("ad_adj_tradein_rough").ToString("c0"); blackbook.TrimReportList.Add(trimDetail); } } if (blackbook.TrimReportList.Count > 0) { blackbook.Success = true; //SQLHelper.AddSimpleBBReport(blackbook); } } else { blackbook.Success = false; } } else { blackbook.Success = false; } } else { blackbook.Success = false; } //blackbook.Success = false; return(blackbook); }