public VehicleDetailsResponse GetVehicleDetails(VehicleDetailsRequest req)
{
try
{
ADPVehiclesReference.VehiclesServicesSoap obj =
new VehiclesServicesSoapClient();
var header = new ADPVehiclesReference.ADPSoapHeaderIn()
{
UserName = username,
Password = password
};
var inner = new GetVehicleDetailsRequest()
{
UserID = userId,
SystemCode = systemCode
};
//plate info as null
//if (req.ChassisNoExist)
if (true)
{
inner.PlateInfo = new ADPVehiclesReference.PlateKey()
{
PlateNo = req.PlateNo,
PlateOrgNo = req.PlateOrgNo,
PlateColorCode = req.PlateColorCode,
PlateKindCode = req.PlateKindCode,
PlateTypeCode = req.PlateTypeCode,
PlateSourceCode = req.PlateSourceCode
};
}
if (!req.ChassisNoExist)
{
inner.ChassisNo = req.ChassisNo;
}
var objToSend = new getVehicleDetailsRequest1(header, inner);//header,
var result = obj.getVehicleDetails(objToSend);
Utility.WriteLog("After Execution");
if (result == null)
{
Utility.WriteLog("Object Is Null");
return(null);
}
else
{
Utility.WriteLog("Object Is not Null");
return(result.getVehicleDetailsResult.ConvertToVehicleDetails());
}
}
catch (Exception ex)
{
Utility.WriteErrorLog(ex);
return(null);
}
}
public VehicleDetailsRequest GetVehicleDetails(int vehicleId)
{
var vehicle = _vehicles.Where(v => v.VehicleId == vehicleId).ToList();
var vehicleDetails = GetNamesFromId(vehicle).ToList();
VehicleDetailsRequest finalVehicle = null;
if (vehicleDetails.Count > 0)
{
foreach (var v in vehicleDetails)
{
finalVehicle = new VehicleDetailsRequest();
finalVehicle.MakeName = v.MakeName;
finalVehicle.ModelName = v.ModelName;
finalVehicle.Year = v.Year;
finalVehicle.PictureFileName = v.PictureFileName;
finalVehicle.SalesPrice = v.SalesPrice;
finalVehicle.BodyStyle = v.BodyStyle;
finalVehicle.ColorType = v.ColorType;
finalVehicle.Descrip = v.Descrip;
finalVehicle.InteriorType = v.InteriorType;
finalVehicle.IsFeatured = v.IsFeatured;
finalVehicle.IsNew = v.IsNew;
finalVehicle.IsSold = v.IsSold;
finalVehicle.Mileage = v.Mileage;
finalVehicle.MSRP = v.MSRP;
finalVehicle.TransmitionType = v.TransmitionType;
finalVehicle.VehicleId = v.VehicleId;
finalVehicle.VinNum = v.VinNum;
}
}
return(finalVehicle);
}
public bool GetVehicleIsWanted(VehicleDetailsRequest req)
{
try
{
ADPVehiclesReference.VehiclesServicesSoap obj =
new VehiclesServicesSoapClient();
var header = new ADPVehiclesReference.ADPSoapHeaderIn()
{
UserName = username,
Password = password
};
var inner = new CheckVehicleWantedRequest()
{
UserID = userId,
SystemCode = systemCode
};
//plate info as null
if (!req.ChassisNoExist)
{
inner.PlateInfo = new ADPVehiclesReference.PlateKey()
{
PlateNo = req.PlateNo,
PlateOrgNo = req.PlateOrgNo,
PlateColorCode = req.PlateColorCode,
PlateKindCode = req.PlateKindCode,
PlateTypeCode = req.PlateTypeCode,
PlateSourceCode = req.PlateSourceCode,
};
}
if (!req.ChassisNoExist)
{
inner.ChassisNo = req.ChassisNo;
}
var objToSend = new checkVehicleWantedRequest1(header, inner);//header
var result = obj.checkVehicleWanted(objToSend);
if (result == null)
{
return(false);
}
else
{
return(result.checkVehicleWantedResult.IsWanted);
}
}
catch
{
return(false);
}
}
public async Task <VehicleDetailsResponse> GetVehicleDetails([FromForm] VehicleDetailsRequest request)
{
var success = false;
var vehicleDetails = new VehicleDetailsDtos();
if (!string.IsNullOrEmpty(request.Registration))
{
try
{
vehicleDetails = DataRepository.GetData()
.Where(x => x.Registration.ToLower() == request.Registration.ToLower().Trim())
.Select(x => new VehicleDetailsDtos
{
Registration = x.Registration,
Status = x.Status,
Description = x.Description,
MakeCode = x.MakeCode,
ModelCode = x.ModelCode,
BodyType = x.BodyType,
CountryCode = x.CountryCode,
OnFleetDate = x.OnFleetDate,
FuelType = x.FuelType,
MPG = x.MPG,
CostPerMile = x.CostPerMile,
CostPerKM = GetCostPerKM(x.CostPerMile),
OdometerReading = x.OdometerReading,
OdometerType = x.OdometerType,
OdometerDate = x.OdometerDate,
MOTDueDate = x.MOTDueDate,
InsuranceDueDate = x.InsuranceDueDate,
TaxDueDate = x.TaxDueDate,
DatePurchased = x.DatePurchased,
DateRegistered = x.DateRegistered
})
.FirstOrDefault();
if (vehicleDetails != null)
{
success = true;
}
}
catch (Exception ex)
{
_logger.LogError(ex, "Data failed to load");
}
}
return(new VehicleDetailsResponse()
{
Success = success,
VehicleDetails = vehicleDetails
});
}
public VehicleDetailsResponse GetVehicleDetails(VehicleDetailsRequest req)
{
try
{
return(inquiry.GetVehicleDetails(req));
}
catch (Exception ex)
{
Utility.WriteErrorLog(ex);
return(null);
}
}
public VehicleDetailsRequest GetVehicleDetails(int vehicleId)
{
VehicleDetailsRequest vehicle = null;
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("GetVehicleDetails");
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@VehicleId", vehicleId);
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
vehicle = new VehicleDetailsRequest();
vehicle.BodyStyle = dr["BodyStyle"].ToString();
vehicle.ColorType = dr["ColorType"].ToString();
vehicle.InteriorType = dr["InteriorType"].ToString();
vehicle.MakeName = dr["MakeName"].ToString();
vehicle.ModelName = dr["ModelName"].ToString();
vehicle.Mileage = (int)dr["Mileage"];
vehicle.MSRP = Convert.ToInt32(dr["MSRP"]);
vehicle.Descrip = dr["Descrip"].ToString();
vehicle.SalesPrice = Convert.ToInt32(dr["SalesPrice"]);
vehicle.TransmitionType = dr["TransmitionType"].ToString();
vehicle.VehicleId = (int)dr["VehicleId"];
vehicle.VinNum = dr["VinNum"].ToString();
vehicle.Year = Convert.ToInt32(dr["Year"]);
vehicle.IsNew = Convert.ToBoolean(dr["IsNew"]);
vehicle.IsFeatured = Convert.ToBoolean(dr["IsFeatured"]);
vehicle.IsSold = Convert.ToBoolean(dr["IsSold"]);
if (dr["PictureFileName"] != DBNull.Value)
{
vehicle.PictureFileName = dr["PictureFileName"].ToString();
}
vehicle.IsDeleted = Convert.ToBoolean(dr["IsDeleted"]);
}
return(vehicle);
}
}
}
private void GetVehicleDetails()
{
VehicleDetailsRequest req = new VehicleDetailsRequest();
int colorId, kindId, authorityId, plateNum;
if (SupervisorNotificationDTO.DangerousViolatorDetails != null &&
int.TryParse(SupervisorNotificationDTO.DangerousViolatorDetails.PlateColor, out colorId) &&
int.TryParse(SupervisorNotificationDTO.DangerousViolatorDetails.PlateKind, out kindId) &&
int.TryParse(SupervisorNotificationDTO.DangerousViolatorDetails.PlateAuthority, out authorityId) &&
int.TryParse(SupervisorNotificationDTO.DangerousViolatorDetails.PlateNumber, out plateNum))
{
req.PlateColorCode = colorId;
req.PlateKindCode = kindId;
req.PlateNo = SupervisorNotificationDTO.DangerousViolatorDetails.PlateNumber;
req.PlateSourceCode = authorityId;
//req.SystemCode = 4;
req.ChassisNoExist = true;
req.PlateTypeCode = kindId;
//req.UserId = "nn";
//req.PlateColorCode = 21;
//req.PlateKindCode = 1;
//req.PlateNo = "1234";
//req.PlateSourceCode = 2;
//req.PlateTypeCode = 1;
var resp = _ADPUTSclient.GetVehicleDetailsAsync(req);
resp.ContinueWith(x => UpdateVehicleDetails(resp.Result));
}
}
private void SearchDangerousViolatorExecute()
{
try
{
IsControlBusy = true;
VehicleDetailsRequest req = new VehicleDetailsRequest();
bool canSearch = true;
ErrorRecordFoundStatus = string.Empty;
//var reportedDangViolatorHandler = ViolatorSearched;
//GoToNextStepEventArgs e = new GoToNextStepEventArgs();
//if (reportedDangViolatorHandler != null)
// reportedDangViolatorHandler(this, e);
ErrorRecordFoundStatus = string.Empty;
if (!string.IsNullOrEmpty(PlateNumber))
{
req.PlateNo = PlateNumber;
}
else
{
ErrorRecordFoundStatus = (string.IsNullOrEmpty(ErrorRecordFoundStatus)) ? "Enter Plate Number" : ErrorRecordFoundStatus + ", " + "Enter Plate Number";
}
if (SelectedPlateType != null && SelectedPlateType.Name != Properties.Resources.strSelect)
{
req.PlateTypeCode = Convert.ToInt32(SelectedPlateType.Id);
}
else
{
ErrorRecordFoundStatus = (string.IsNullOrEmpty(ErrorRecordFoundStatus)) ? "Select Plate Type" : ErrorRecordFoundStatus + ", " + "Select Plate Type";
}
if (SelectedColor != null && SelectedColor.Name != Properties.Resources.strSelect)
{
req.PlateColorCode = Convert.ToInt32(SelectedColor.Id);
}
else
{
ErrorRecordFoundStatus = (string.IsNullOrEmpty(ErrorRecordFoundStatus)) ? "Select Plate Color" : ErrorRecordFoundStatus + ", " + "Select Plate Color";
}
if (SelectedKind != null && SelectedKind.Name != Properties.Resources.strSelect)
{
req.PlateKindCode = Convert.ToInt32(SelectedKind.Id);
}
else
{
ErrorRecordFoundStatus = (string.IsNullOrEmpty(ErrorRecordFoundStatus)) ? "Select Plate Kind" : ErrorRecordFoundStatus + ", " + "Select Plate Kind";
}
if (SelectedSource != null && SelectedSource.Name != Properties.Resources.strSelect)
{
req.PlateSourceCode = Convert.ToInt32(SelectedSource.Id);
}
else
{
ErrorRecordFoundStatus = (string.IsNullOrEmpty(ErrorRecordFoundStatus)) ? "Select Plate Source" : ErrorRecordFoundStatus + ", " + "Select Plate Source";
}
//if (SelectedBusinessRule == null)
// ErrorRecordFoundStatus = (string.IsNullOrEmpty(ErrorRecordFoundStatus)) ? "Select Business Rule" : ErrorRecordFoundStatus + ", " + "Select Business Rule";
if (string.IsNullOrEmpty(ErrorRecordFoundStatus))
{
//req.SystemCode = 4;
//req.UserId = "nn";
req.ChassisNoExist = true;
var searchResult = adpUTSclient.GetVehicleDetailsAsync(req);
searchResult.ContinueWith(x => SearchedDangerousViolator(x.Result));
//await Task.Delay(1500);
//req.PlateNo = "48724";
//req.PlateColorCode = 21;
//req.PlateKindCode = 1;
//req.PlateOrgNo = 0;
//req.PlateSourceCode = 2;
//req.PlateTypeCode = 1;
//req.SystemCode = 4;
//req.UserId = "nn";
//req.ChassisNoExist = true;
}
else
{
ErrorRecordFoundStatus = "";
IsControlBusy = false;
}
}
catch (Exception ex)
{
IsControlBusy = false;
throw ex;
}
}
public IEnumerable <VehicleDetailsRequest> GetSearchResults(VehicleSearchParameters parameters)
{
VehicleSearchParameters parameter = new VehicleSearchParameters();
List <VehicleDetailsRequest> resultsList = new List <VehicleDetailsRequest>();
if (parameters.maxPrice == null)
{
parameter.maxPrice = 0;
}
else
{
parameter.maxPrice = parameters.maxPrice;
}
if (parameters.minPrice == null)
{
parameter.minPrice = 0;
}
else
{
parameter.minPrice = parameters.minPrice;
}
if (parameters.minYear == null)
{
parameter.minYear = 0;
}
else
{
parameter.minYear = parameters.minYear;
}
if (parameters.maxYear == null)
{
parameter.maxYear = 0;
}
else
{
parameter.maxYear = parameters.maxYear;
}
parameter.search = parameters.search;
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
string query = "SELECT TOP 20 BodyStyle, ColorType, InteriorType, MakeName, Mileage, MSRP, SalesPrice, TransmitionType, VehicleId, VinNum, [Year], ModelName, IsNew, IsSold, IsFeatured, PictureFileName, IsDeleted FROM Vehicle v INNER JOIN BodyStyle b ON v.BodyStyleId = b.BodyStyleId INNER JOIN Color c ON v.ColorId = c.ColorId INNER JOIN Interior i ON v.InteriorId = i.InteriorId INNER JOIN Make ma ON v.MakeId = ma.MakeId INNER JOIN Transmition t ON v.TransmitionId = t.TransmitionId INNER JOIN Model mo ON mo.ModelId = v.ModelId WHERE 1 = 1 ";
if (parameter.minPrice != 0 && parameter.minPrice != null)
{
query += "AND SalesPrice >= @MinPrice ";
cmd.Parameters.AddWithValue("@MinPrice", parameters.minPrice.Value);
}
if (parameter.maxPrice != 0 && parameter.maxPrice != null)
{
query += "AND SalesPrice <= @MaxPrice ";
cmd.Parameters.AddWithValue("@MaxPrice", parameters.maxPrice.Value);
}
if (parameter.minYear != 0 && parameter.minYear != null)
{
query += "AND [Year] >= @MinYear ";
cmd.Parameters.AddWithValue("@MinYear", parameters.minYear);
}
if (parameter.maxYear != 0 && parameter.maxYear != null)
{
query += "AND [Year] <= @MaxYear ";
cmd.Parameters.AddWithValue("@MaxYear", parameters.maxYear);
}
if (!string.IsNullOrEmpty(parameter.search))
{
query += "AND MakeName Like @Search OR ModelName LIKE @Search OR [Year] LIKE @Search ";
cmd.Parameters.AddWithValue("@Search", parameters.search + '%');
}
query += "ORDER BY MSRP DESC";
cmd.CommandText = query;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
VehicleDetailsRequest currentRow = new VehicleDetailsRequest();
currentRow.BodyStyle = dr["BodyStyle"].ToString();
currentRow.ColorType = dr["ColorType"].ToString();
currentRow.InteriorType = dr["InteriorType"].ToString();
currentRow.MakeName = dr["MakeName"].ToString();
currentRow.ModelName = dr["ModelName"].ToString();
currentRow.Mileage = Convert.ToDecimal(dr["Mileage"]);
currentRow.MSRP = Convert.ToDecimal(dr["MSRP"]);
currentRow.SalesPrice = Convert.ToDecimal(dr["SalesPrice"]);
currentRow.TransmitionType = dr["TransmitionType"].ToString();
currentRow.PictureFileName = dr["PictureFileName"].ToString();
currentRow.VehicleId = (int)dr["VehicleId"];
currentRow.VinNum = dr["VinNum"].ToString();
currentRow.Year = Convert.ToInt32(dr["Year"]);
currentRow.IsNew = Convert.ToBoolean(dr["IsNew"]);
currentRow.IsDeleted = Convert.ToBoolean(dr["IsDeleted"]);
currentRow.IsSold = Convert.ToBoolean(dr["IsSold"]);
currentRow.IsFeatured = Convert.ToBoolean(dr["IsFeatured"]);
resultsList.Add(currentRow);
}
return(resultsList);
}
}
}
public PurchaseViewModel()
{
Sale = new Sales();
VehicleDetails = new VehicleDetailsRequest();
}
private async void GetVehicleDetails()
{
int colorId;
if (DangerousVehicleDetails != null && !string.IsNullOrEmpty(DangerousVehicleDetails.PlateColor) && Int32.TryParse(DangerousVehicleDetails.PlateColor, out colorId))
{
SelectedColor = VehiclePlateColorList.Where(x => x.Id == colorId).FirstOrDefault();
}
else
{
SelectedColor = VehiclePlateColorList[0];
}
int kindId;
if (DangerousVehicleDetails != null && !string.IsNullOrEmpty(DangerousVehicleDetails.PlateKind) && Int32.TryParse(DangerousVehicleDetails.PlateKind, out kindId))
{
SelectedKind = VehiclePlateKindList.Where(x => x.Id == kindId).FirstOrDefault();
SelectedPlateType = VehiclePlateClassficationsList.Where(x => x.Id == kindId).FirstOrDefault();
}
else
{
SelectedKind = VehiclePlateKindList[0];
SelectedPlateType = VehiclePlateClassficationsList[0];
}
int sourceId;
if (DangerousVehicleDetails != null && !string.IsNullOrEmpty(DangerousVehicleDetails.PlateSource) && Int32.TryParse(DangerousVehicleDetails.PlateSource, out sourceId))
{
SelectedSource = VehiclePlateSourceList.Where(x => x.Id == sourceId).FirstOrDefault();
}
else
{
SelectedSource = VehiclePlateSourceList[0];
}
VehicleDetailsRequest req = new VehicleDetailsRequest();
req.PlateNo = this.PlateNumber;
//req.PlateColorCode = Convert.ToInt32(!string.IsNullOrEmpty(DangerousVehicleDetails.PlateColor) ? DangerousVehicleDetails.PlateColor : SelectedColor.Id);
//req.PlateKindCode = Convert.ToInt32(!string.IsNullOrEmpty(DangerousVehicleDetails.PlateKind) ? DangerousVehicleDetails.PlateKind : SelectedKind.Id);
//req.PlateSourceCode = Convert.ToInt32(!string.IsNullOrEmpty(DangerousVehicleDetails.PlateSource) ? DangerousVehicleDetails.PlateSource : SelectedSource.Id);
req.PlateColorCode = Convert.ToInt32(SelectedColor.Id);
req.PlateKindCode = Convert.ToInt32(SelectedKind.Id);
req.PlateSourceCode = Convert.ToInt32(SelectedSource.Id);
req.PlateTypeCode = Convert.ToInt32(SelectedPlateType.Id);
//req.SystemCode = 4;
req.ChassisNoExist = true;
//req.PlateTypeCode = Convert.ToInt32(!string.IsNullOrEmpty(DangerousVehicleDetails.PlateKind) ? DangerousVehicleDetails.PlateKind : SelectedPlateType.Id);
//req.UserId = "nn";
//req.PlateColorCode = 21;
//req.PlateKindCode = 1;
//req.PlateNo = "1234";
//req.PlateSourceCode = 2;
//req.PlateTypeCode = 1;
var resp = adpUTSclient.GetVehicleDetailsAsync(req);
Application.Current.Dispatcher.Invoke(() => { VehicleDetailResponse = resp.Result; });
}
public bool GetVehicleIsWanted(VehicleDetailsRequest req)
{
return(inquiry.GetVehicleIsWanted(req));
}
