public List <VinControlVehicleReport> GetNext7DaysBucketJumpVehicles(int dealerId)
{
var mProducts = new List <VinControlVehicleReport>();
var context = new whitmanenterprisewarehouseEntities();
IQueryable <whitmanenterprisedealershipinventory> avaiInventory =
from e in InventoryQueryHelper.GetSingleOrGroupInventory(context)
where e.NewUsed.ToLower().Equals("used") && (e.Recon == null || !((bool)e.Recon))
select e;
var dtDealerSetting = InventoryQueryHelper.GetSingleOrGroupSetting(context).ToList();
var dtDealerInfo = InventoryQueryHelper.GetSingleOrGroupDealer(context).ToList();
for (int i = 1; i <= 7; i++)
{
foreach (var tmp in avaiInventory.OrderBy(x => x.Make))
{
int daysInInvenotry = DateTime.Now.AddDays(i).Subtract(tmp.DateInStock.GetValueOrDefault()).Days;
bool flag = dtDealerSetting.FirstOrDefault(item => tmp.DealershipId == item.DealershipId).IntervalBucketJump != 0 && ((daysInInvenotry == dtDealerSetting.FirstOrDefault(item => tmp.DealershipId == item.DealershipId).FirstTimeRangeBucketJump) || (daysInInvenotry == dtDealerSetting.FirstOrDefault(item => tmp.DealershipId == item.DealershipId).SecondTimeRangeBucketJump) || ((daysInInvenotry - dtDealerSetting.FirstOrDefault(item => tmp.DealershipId == item.DealershipId).SecondTimeRangeBucketJump) % dtDealerSetting.FirstOrDefault(item => tmp.DealershipId == item.DealershipId).IntervalBucketJump) == 0);
if (flag)
{
var v = new VinControlVehicleReport
{
AutoId = mProducts.Count + 1,
ModelYear = tmp.ModelYear.GetValueOrDefault(),
Make = String.IsNullOrEmpty(tmp.Make) ? "" : tmp.Make,
Model = String.IsNullOrEmpty(tmp.Model) ? "" : tmp.Model,
Trim = String.IsNullOrEmpty(tmp.Trim) ? "" : tmp.Trim,
StockNumber = String.IsNullOrEmpty(tmp.StockNumber) ? "" : tmp.StockNumber,
Vin = String.IsNullOrEmpty(tmp.VINNumber) ? "" : tmp.VINNumber,
Mileage = String.IsNullOrEmpty(tmp.Mileage) ? "" : tmp.Mileage,
ExteriorColor = String.IsNullOrEmpty(tmp.ExteriorColor) ? "" : tmp.ExteriorColor,
SalePrice = String.IsNullOrEmpty(tmp.SalePrice) ? "" : tmp.SalePrice,
DaysInInvenotry = DateTime.Now.Subtract(tmp.DateInStock.Value).Days,
DealershipName = String.IsNullOrEmpty(dtDealerInfo.FirstOrDefault(item => tmp.DealershipId == item.idWhitmanenterpriseDealership).DealershipName)
? ""
: dtDealerInfo.FirstOrDefault(item => tmp.DealershipId == item.idWhitmanenterpriseDealership).DealershipName,
Engine = String.IsNullOrEmpty(tmp.EngineType) ? "" : tmp.EngineType,
Style = String.IsNullOrEmpty(tmp.BodyType) ? "" : tmp.BodyType,
Date = new DateTime(DateTime.Now.AddDays(i).Year, DateTime.Now.AddDays(i).Month, DateTime.Now.AddDays(i).Day)
};
if (v.Engine.Contains("Engine"))
{
v.Engine = v.Engine.Replace("Engine", "");
}
mProducts.Add(v);
}
}
}
return(mProducts);
}
public List <VinControlVehicleReport> GetCertifiedVehicles(int dealerId)
{
var mProducts = new List <VinControlVehicleReport>();
var context = new whitmanenterprisewarehouseEntities();
IQueryable <whitmanenterprisedealershipinventory> avaiInventory =
from e in InventoryQueryHelper.GetSingleOrGroupInventory(context)
where e.Certified.Value
select e;
var dtDealerSetting = context.whitmanenterprisesettings.FirstOrDefault(x => x.DealershipId == dealerId);
var dtDealerInfo = context.whitmanenterprisedealerships.FirstOrDefault(x => x.idWhitmanenterpriseDealership == dealerId);
foreach (var tmp in avaiInventory.OrderBy(x => x.Make))
{
var v = new VinControlVehicleReport
{
AutoId = mProducts.Count + 1,
ModelYear = tmp.ModelYear.GetValueOrDefault(),
Make = String.IsNullOrEmpty(tmp.Make) ? "" : tmp.Make,
Model = String.IsNullOrEmpty(tmp.Model) ? "" : tmp.Model,
Trim = String.IsNullOrEmpty(tmp.Trim) ? "" : tmp.Trim,
StockNumber = String.IsNullOrEmpty(tmp.StockNumber) ? "" : tmp.StockNumber,
Vin = String.IsNullOrEmpty(tmp.VINNumber) ? "" : tmp.VINNumber,
Mileage = String.IsNullOrEmpty(tmp.Mileage) ? "" : tmp.Mileage,
ExteriorColor = String.IsNullOrEmpty(tmp.ExteriorColor) ? "" : tmp.ExteriorColor,
SalePrice = String.IsNullOrEmpty(tmp.SalePrice) ? "" : tmp.SalePrice,
DaysInInvenotry = DateTime.Now.Subtract(tmp.DateInStock.Value).Days,
DealershipName =
String.IsNullOrEmpty(dtDealerInfo.DealershipName) ? "" : dtDealerInfo.DealershipName,
Engine = String.IsNullOrEmpty(tmp.EngineType) ? "" : tmp.EngineType,
};
if (v.Engine.Contains("Engine"))
{
v.Engine = v.Engine.Replace("Engine", "");
}
if (String.IsNullOrEmpty(tmp.CarImageUrl))
{
v.Pics = "0";
}
else
{
string[] splitArray =
tmp.CarImageUrl.Split(new string[] { ",", "|" }, StringSplitOptions.RemoveEmptyEntries).ToArray
();
if (splitArray.Count() > 1)
{
v.Pics = splitArray.Count().ToString(CultureInfo.InvariantCulture);
}
else
{
if (!String.IsNullOrEmpty(tmp.DefaultImageUrl) &&
!String.IsNullOrEmpty(dtDealerSetting.DefaultStockImageUrl) &&
!tmp.CarImageUrl.Equals(tmp.DefaultImageUrl) &&
!tmp.CarImageUrl.Equals(dtDealerSetting.DefaultStockImageUrl))
{
v.Pics = "1";
}
else
{
v.Pics = "1(D)";
}
}
}
mProducts.Add(v);
}
return(mProducts);
}
public List <VinControlVehicleReport> GetKarPowerVehicles(int dealerId)
{
var mProducts = new List <VinControlVehicleReport>();
var context = new whitmanenterprisewarehouseEntities();
var avaiInventory =
from e in InventoryQueryHelper.GetSingleOrGroupInventory(context)
from et in context.whitmanenterprisekbbs
where
e.NewUsed.ToLower().Equals("used") && e.KBBTrimId > 0 &&
e.KBBTrimId == et.TrimId && e.VINNumber == et.Vin &&
(e.Recon ==
null ||
!((bool)
e.Recon))
select new
{
e.Make,
e.ModelYear,
e.Model,
e.StockNumber,
e.VINNumber,
e.Mileage,
e.ExteriorColor,
e.SalePrice,
e.DateInStock,
e.DealershipName,
e.KBBTrimId,
et.BaseWholeSale,
et.MileageAdjustment,
et.WholeSale,
e.EngineType
};
foreach (var tmp in avaiInventory.OrderBy(x => x.Make))
{
var number = CommonHelper.RemoveSpecialCharactersAndReturnNumber(tmp.BaseWholeSale);
if (number > 0)
{
var v = new VinControlVehicleReport
{
AutoId = mProducts.Count + 1,
ModelYear = tmp.ModelYear.GetValueOrDefault(),
Make = String.IsNullOrEmpty(tmp.Make) ? "" : tmp.Make,
Model = String.IsNullOrEmpty(tmp.Model) ? "" : tmp.Model,
StockNumber = String.IsNullOrEmpty(tmp.StockNumber) ? "" : tmp.StockNumber,
Vin = String.IsNullOrEmpty(tmp.VINNumber) ? "" : tmp.VINNumber,
Mileage = String.IsNullOrEmpty(tmp.Mileage) ? "" : tmp.Mileage,
ExteriorColor = String.IsNullOrEmpty(tmp.ExteriorColor) ? "" : tmp.ExteriorColor,
SalePrice = String.IsNullOrEmpty(tmp.SalePrice) ? "" : tmp.SalePrice,
DaysInInvenotry = DateTime.Now.Subtract(tmp.DateInStock.Value).Days,
DealershipName = tmp.DealershipName,
BasewholeSale = tmp.BaseWholeSale,
MileageAdjustment = tmp.MileageAdjustment,
WholeSale = tmp.WholeSale,
Engine = String.IsNullOrEmpty(tmp.EngineType) ? "" : tmp.EngineType,
};
if (v.Engine.Contains("Engine"))
{
v.Engine = v.Engine.Replace("Engine", "");
}
mProducts.Add(v);
}
}
return(mProducts);
}
public List <VinControlVehicleReport> GetManheimInventoryVehicles(int dealerId)
{
var mProducts = new List <VinControlVehicleReport>();
var context = new whitmanenterprisewarehouseEntities();
IQueryable <whitmanenterprisedealershipinventory> avaiInventory =
from e in InventoryQueryHelper.GetSingleOrGroupInventory(context)
where (e.Recon == false || e.Recon == null)
select e;
var dtDealerSetting = InventoryQueryHelper.GetSingleOrGroupSetting(context).ToList();
foreach (var tmp in avaiInventory.OrderBy(x => x.Make))
{
if (dtDealerSetting != null)
{
var manheimWholesales = LinqHelper.ManheimReport(tmp /*, dtDealerSetting.Manheim.Trim(), dtDealerSetting.ManheimPassword.Trim()*/);
if (manheimWholesales.Count > 0)
{
foreach (var item in manheimWholesales)
{
var v = new VinControlVehicleReport
{
AutoId = mProducts.Count + 1,
ListingId = tmp.ListingID,
ModelYear = tmp.ModelYear.GetValueOrDefault(),
Make = tmp.Make ?? string.Empty,
Model = tmp.Model ?? string.Empty,
Trim = tmp.Trim ?? string.Empty,
StockNumber = tmp.StockNumber ?? string.Empty,
Vin = tmp.VINNumber ?? string.Empty,
Mileage = tmp.Mileage ?? string.Empty,
Engine = tmp.EngineType ?? string.Empty,
Cylinder = tmp.Cylinders ?? string.Empty,
Tranmission = tmp.Tranmission ?? string.Empty,
ExteriorColor = tmp.ExteriorColor ?? string.Empty,
SalePrice = tmp.SalePrice ?? string.Empty,
DealerCost = tmp.DealerCost ?? string.Empty,
DaysInInvenotry = DateTime.Now.Subtract(tmp.DateInStock.Value).Days,
DealershipName = tmp.DealershipName ?? string.Empty,
RetailPrice = tmp.RetailPrice ?? string.Empty,
Style = tmp.BodyType ?? string.Empty,
ManheimLowestPrice = item.LowestPrice ?? string.Empty,
ManheimAveragePrice = item.AveragePrice ?? string.Empty,
ManheimHighestPrice = item.HighestPrice ?? string.Empty,
ManheimTrim = item.TrimName ?? string.Empty
};
if (v.Engine.Contains("Engine"))
{
v.Engine = v.Engine.Replace("Engine", "");
}
if (String.IsNullOrEmpty(tmp.CarImageUrl))
{
v.Pics = "0";
}
else
{
string[] splitArray = tmp.CarImageUrl.Split(new string[] { ",", "|" }, StringSplitOptions.RemoveEmptyEntries).ToArray();
if (splitArray.Count() > 1)
{
v.Pics = splitArray.Count().ToString(CultureInfo.InvariantCulture);
}
else
{
if (!String.IsNullOrEmpty(tmp.DefaultImageUrl) &&
!String.IsNullOrEmpty(dtDealerSetting.FirstOrDefault(i => tmp.DealershipId == i.DealershipId).DefaultStockImageUrl) &&
!tmp.CarImageUrl.Equals(tmp.DefaultImageUrl) &&
!tmp.CarImageUrl.Equals(dtDealerSetting.FirstOrDefault(i => tmp.DealershipId == i.DealershipId).DefaultStockImageUrl))
{
v.Pics = "1";
}
else
{
v.Pics = "1(D)";
}
}
}
mProducts.Add(v);
}
}
else
{
var v = new VinControlVehicleReport
{
AutoId = mProducts.Count + 1,
ListingId = tmp.ListingID,
ModelYear = tmp.ModelYear.GetValueOrDefault(),
Make = tmp.Make ?? string.Empty,
Model = tmp.Model ?? string.Empty,
Trim = tmp.Trim ?? string.Empty,
StockNumber = tmp.StockNumber ?? string.Empty,
Vin = tmp.VINNumber ?? string.Empty,
Mileage = tmp.Mileage ?? string.Empty,
Engine = tmp.EngineType ?? string.Empty,
Cylinder = tmp.Cylinders ?? string.Empty,
Tranmission = tmp.Tranmission ?? string.Empty,
ExteriorColor = tmp.ExteriorColor ?? string.Empty,
SalePrice = tmp.SalePrice ?? string.Empty,
DealerCost = tmp.DealerCost ?? string.Empty,
DaysInInvenotry = DateTime.Now.Subtract(tmp.DateInStock.Value).Days,
DealershipName = tmp.DealershipName ?? string.Empty,
RetailPrice = tmp.RetailPrice ?? string.Empty,
Style = tmp.BodyType ?? string.Empty,
ManheimLowestPrice = string.Empty,
ManheimAveragePrice = string.Empty,
ManheimHighestPrice = string.Empty,
ManheimTrim = tmp.Trim ?? string.Empty
};
if (v.Engine.Contains("Engine"))
{
v.Engine = v.Engine.Replace("Engine", "");
}
if (String.IsNullOrEmpty(tmp.CarImageUrl))
{
v.Pics = "0";
}
else
{
string[] splitArray = tmp.CarImageUrl.Split(new string[] { ",", "|" }, StringSplitOptions.RemoveEmptyEntries).ToArray();
if (splitArray.Count() > 1)
{
v.Pics = splitArray.Count().ToString(CultureInfo.InvariantCulture);
}
else
{
if (!String.IsNullOrEmpty(tmp.DefaultImageUrl) &&
!String.IsNullOrEmpty(dtDealerSetting.FirstOrDefault(i => tmp.DealershipId == i.DealershipId).DefaultStockImageUrl) &&
!tmp.CarImageUrl.Equals(tmp.DefaultImageUrl) &&
!tmp.CarImageUrl.Equals(dtDealerSetting.FirstOrDefault(i => tmp.DealershipId == i.DealershipId).DefaultStockImageUrl))
{
v.Pics = "1";
}
else
{
v.Pics = "1(D)";
}
}
}
mProducts.Add(v);
}
}
}
return(mProducts);
}
public List <VinControlVehicleReport> GetTodayBucketJumpVehicles(int dealerId)
{
var mProducts = new List <VinControlVehicleReport>();
var context = new whitmanenterprisewarehouseEntities();
IQueryable <whitmanenterprisedealershipinventory> avaiInventory =
from e in InventoryQueryHelper.GetSingleOrGroupInventory(context)
where e.NewUsed.ToLower().Equals("used") && (e.Recon == null || !((bool)e.Recon))
select e;
var dtDealerSetting = InventoryQueryHelper.GetSingleOrGroupSetting(context).ToList();
var dtDealerInfo = InventoryQueryHelper.GetSingleOrGroupDealer(context).ToList();
foreach (var tmp in avaiInventory.OrderBy(x => x.Make))
{
int daysInInvenotry = DateTime.Now.Subtract(tmp.DateInStock.GetValueOrDefault()).Days;
bool flag = ((daysInInvenotry == dtDealerSetting.FirstOrDefault(i => tmp.DealershipId == i.DealershipId).FirstTimeRangeBucketJump) || (daysInInvenotry == dtDealerSetting.FirstOrDefault(i => tmp.DealershipId == i.DealershipId).SecondTimeRangeBucketJump) || ((daysInInvenotry - dtDealerSetting.FirstOrDefault(i => tmp.DealershipId == i.DealershipId).SecondTimeRangeBucketJump) % dtDealerSetting.FirstOrDefault(i => tmp.DealershipId == i.DealershipId).IntervalBucketJump) == 0);
if (flag)
{
var v = new VinControlVehicleReport
{
AutoId = mProducts.Count + 1,
ModelYear = tmp.ModelYear.GetValueOrDefault(),
Make = String.IsNullOrEmpty(tmp.Make) ? "" : tmp.Make,
Model = String.IsNullOrEmpty(tmp.Model) ? "" : tmp.Model,
Trim = String.IsNullOrEmpty(tmp.Trim) ? "" : tmp.Trim,
StockNumber = String.IsNullOrEmpty(tmp.StockNumber) ? "" : tmp.StockNumber,
Vin = String.IsNullOrEmpty(tmp.VINNumber) ? "" : tmp.VINNumber,
Mileage = String.IsNullOrEmpty(tmp.Mileage) ? "" : tmp.Mileage,
ExteriorColor = String.IsNullOrEmpty(tmp.ExteriorColor) ? "" : tmp.ExteriorColor,
SalePrice = String.IsNullOrEmpty(tmp.SalePrice) ? "" : tmp.SalePrice,
DaysInInvenotry = DateTime.Now.Subtract(tmp.DateInStock.Value).Days,
DealershipName = String.IsNullOrEmpty(dtDealerInfo.FirstOrDefault(i => tmp.DealershipId == i.idWhitmanenterpriseDealership).DealershipName)
? ""
: dtDealerInfo.FirstOrDefault(i => tmp.DealershipId == i.idWhitmanenterpriseDealership).DealershipName,
Engine = String.IsNullOrEmpty(tmp.EngineType) ? "" : tmp.EngineType,
};
if (v.Engine.Contains("Engine"))
{
v.Engine = v.Engine.Replace("Engine", "");
}
if (String.IsNullOrEmpty(tmp.CarImageUrl))
{
v.Pics = "0";
}
else
{
string[] splitArray =
tmp.CarImageUrl.Split(new string[] { ",", "|" }, StringSplitOptions.RemoveEmptyEntries).
ToArray
();
if (splitArray.Count() > 1)
{
v.Pics = splitArray.Count().ToString(CultureInfo.InvariantCulture);
}
else
{
if (!String.IsNullOrEmpty(tmp.DefaultImageUrl) &&
!String.IsNullOrEmpty(dtDealerSetting.FirstOrDefault(i => tmp.DealershipId == i.DealershipId).DefaultStockImageUrl) &&
!tmp.CarImageUrl.Equals(tmp.DefaultImageUrl) &&
!tmp.CarImageUrl.Equals(dtDealerSetting.FirstOrDefault(i => tmp.DealershipId == i.DealershipId).DefaultStockImageUrl))
{
v.Pics = "1";
}
else
{
v.Pics = "1(D)";
}
}
}
mProducts.Add(v);
}
}
return(mProducts);
}
