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