internal static DbVehicleInfo VehicleSave(DbConnector dbConn, VehicleInfo vi) { var dbvi = new DbVehicleInfo { VehicleInfo = vi.Clone() }; dbvi.VehicleInfo.DataSource = DataSources.Backend; if (!dbvi.VehicleInfo.BatteryId.IsEmpty) { var dbbi = dbConn.ExecuteBpl(new BatteryGetById { BatteryId = dbvi.VehicleInfo.BatteryId }); if (dbbi != null) { dbvi.BatteryKey = dbbi.BatteryKey; } else { Log.Warn("Battery with Id {0} not found in DB. Cleared.", dbvi.VehicleInfo.BatteryId.LocalId.ToString()); dbvi.VehicleInfo.BatteryId = BplIdentity.Empty; } } var exVehicle = dbConn.ExecuteBpl(new VehicleGetById { VehicleId = dbvi.VehicleInfo.VehicleId }); if (exVehicle != null) { // TK: we are using OpCo settings from SD (periodic) dbvi.VehicleInfo.Operator = exVehicle.VehicleInfo.Operator; dbvi.VehicleKey = exVehicle.VehicleKey; if ((exVehicle.VehicleInfo.DataSource == DataSources.Backend) || (OscarServer.UseBackendMasterData)) { dbConn.ExecuteBpl(new VehicleUpdate { i = dbvi }); } } else { dbvi = null; } return dbvi; }
internal void Handle(PeriodicUpdateRequest request) { var resp = new PeriodicUpdateResponse(); using (var dbConn = DatabaseManager.DbConn()) { var dataSource = DataSources.Vehicle; var opco = _detectOperator(request.OperatorName); var platformId = (request.PlatformVersion == null) ? BplIdentity.Empty : BplIdentity.Get(request.PlatformVersion.Revision.ToString("X08")); var deviceId = MasterDataHelpers.DeviceResolveId(dbConn, request.AutosSerialNumber, request.HardwareId); var codeName = ""; if (platformId.IsEmpty || deviceId.IsEmpty) { DiagnosticsHelpers.ReportIntegrityError(dbConn, "PeriodicUpdateRequest", DumpRequest(), "No device information found (Device Id: '{0}') or no device type (Platform Id: '{1}'). Record skipped.", deviceId, platformId); Reply(resp); return; } var imageInstalls = dbConn.ExecuteBpl(new InstallGetByPlatformIdType { PlatformId = platformId, Type = Mpcr.Services.Oscar.Logistics.SoftwareUpdateType.Image }); if (imageInstalls == null || imageInstalls.Count == 0) { Log.Warn("No installations found for platform {0}. Record skipped.", platformId.LocalId.ToString()); Reply(resp); return; } var deviceType = DeviceType.Get(request.PlatformVersion.Revision); foreach (var cv in request.ClientVersions) { if (cv.Version == null || cv.UpdateType != SoftwareUpdateType.Image) { continue; } var vn = SwlVersion.FromVersion(cv.Version).ToInt32(); var ii = dbConn.ExecuteBpl(new InstallGetByPlatformIdTypeVersionNumber(platformId, (Mpcr.Services.Oscar.Logistics.SoftwareUpdateType)cv.UpdateType, vn)); if (ii == null) { continue; } codeName = ii.CodeName; } if (codeName.IsEmpty()) { DiagnosticsHelpers.ReportIntegrityError(dbConn, "PeriodicUpdateRequest", DumpRequest(), "No code name found for device '{0}'. Record skipped.", deviceId); Reply(resp); return; } var dei = new DeviceInfo(); dei.DeviceId = deviceId; dei.Operator = opco; dei.Type = deviceType; dei.DeviceSN = request.AutosSerialNumber; dei.DialupPhone = PhoneStruct.ToPhone(request.AutOSClient.ModemNumber); dei.SimIMEI = request.AutOSClient.SimIMEI; dei.SimIMSI = request.AutOSClient.SimIMSI; dei.SecretCode = request.AutOSClient.SecretCode; dei.HardwareId = request.HardwareId; dei.DataSource = dataSource; var exDevice = dbConn.ExecuteBpl(new DeviceGetById { DeviceId = dei.DeviceId }); if (exDevice != null) { if (dei.Operator == null) { dei.Operator = exDevice.Operator; } dbConn.ExecuteBpl(new DeviceUpdate { Device = dei }); } else { dbConn.ExecuteBpl(new DeviceAdd { Device = dei }); } // // Master Data update // if (codeName.StartsWith("SP4")) { Log.Trace("Processing old master data update (SP4 path)"); dbConn.BeginTransaction(this); var dbbi = new DbBatteryInfo(); if (request.Battery != null) { dbbi.BatteryInfo = new BatteryInfo(); dbbi.BatteryInfo.BatteryId = (request.Battery.IsFactory) ? BplIdentity.Empty : request.Battery.Id; dbbi.BatteryInfo.Operator = opco; dbbi.BatteryInfo.Type = request.Battery.Type; dbbi.BatteryInfo.BatterySN = request.Battery.SerialNumber; dbbi.BatteryInfo.DataSource = dataSource; dbbi = MasterDataHelpers.BatterySave(dbConn, deviceType, dbbi); } else { // no battery in request - is normal, e.g. while battery is being switched, so nothing to log here dbbi = null; } var dbvi = new DbVehicleInfo(); if (request.Vehicle != null) { dbvi.VehicleInfo = new VehicleInfo(); dbvi.VehicleInfo.VehicleId = (request.Vehicle.IsFactory) ? BplIdentity.Empty : request.Vehicle.Id; dbvi.VehicleInfo.Operator = opco; dbvi.VehicleInfo.Type = request.Vehicle.Type; dbvi.VehicleInfo.VehicleSN = _decodeLegacyVehicleSN(request.Vehicle.SerialNumber); dbvi.VehicleInfo.VehicleVIN = request.Vehicle.VIN; dbvi.VehicleInfo.LicensePlate = request.Vehicle.LicensePlate; dbvi.VehicleInfo.ModelColor = request.Vehicle.Color; dbvi.VehicleInfo.ModelName = request.Vehicle.ModelName; dbvi.VehicleInfo.ModelYear = request.Vehicle.ModelYear; dbvi.VehicleInfo.DeviceId = dei.DeviceId; dbvi.VehicleInfo.DataSource = dataSource; dbvi.BatteryKey = (dbbi != null) ? dbbi.BatteryKey : null; dbvi = MasterDataHelpers.VehicleSave(dbConn, deviceType, dbvi); } else { Log.Warn("No vehicle in request"); dbvi = null; } var dri = new DriverInfo(); if (request.PrimaryDriver != null && request.PrimaryDriver.Type != DriverTypes.Factory) { dri.DriverId = request.PrimaryDriver.Id; dri.Operator = opco; dri.Type = request.PrimaryDriver.Type; if (request.PrimaryDriver.LocalizedName.IsEmpty) { var dict = new Dictionary<Locale, string>(); dict[request.PrimaryDriver.PrimaryLocale] = "{0}, {1}".Substitute(request.PrimaryDriver.FirstName, request.PrimaryDriver.LastName); dri.Name = MultiString.FromDictionary(dict); } else { dri.Name = request.PrimaryDriver.LocalizedName; } dri.Gender = request.PrimaryDriver.Gender; dri.BirthDate = Date.Undefined; dri.DriverSsn = ""; dri.DefaultLocale = request.PrimaryDriver.PrimaryLocale; dri.DefaultVehicleId = (dbvi != null) ? dbvi.VehicleInfo.VehicleId : BplIdentity.Empty; dri.DataSource = dataSource; dri = MasterDataHelpers.DriverSave(dbConn, dri); if ((dbvi != null) && (dri != null)) { var subi = new DbSubscriptionInfo(); subi.SubscriptionInfo = new SubscriptionInfo(); subi.SubscriptionInfo.SubscriptionId = BplIdentity.Get(Guid.NewGuid().ToString()); subi.SubscriptionInfo.Operator = opco; subi.SubscriptionInfo.Type = SubscriptionType.Get("EV"); subi.SubscriptionInfo.Status = SubscriptionStatus.Active; subi.SubscriptionInfo.DriverId = dri.DriverId; subi.SubscriptionInfo.DataSource = dataSource; subi.VehicleKey = dbvi.VehicleKey; dbConn.ExecuteBpl(new SubscriptionAdd { i = subi }); } } else { dri = null; } dbConn.CommitTransaction(); } // // Logistics Data update // if (!deviceId.IsEmpty) { dbConn.BeginTransaction(this); dei = dbConn.ExecuteBpl(new DeviceGetById { DeviceId = deviceId }); if (dei != null) { var devPlatformId = dbConn.ExecuteBpl(new DeviceGetPlatformId { DeviceId = deviceId }); if (platformId != devPlatformId) { if (!platformId.IsEmpty) { dbConn.ExecuteBpl(new DeviceSetPlatformId { DeviceId = dei.DeviceId, PlatformId = platformId }); } else { platformId = devPlatformId; } } if (!platformId.IsEmpty) { dbConn.ExecuteBpl(new DeviceInstallDeleteByDeviceId(deviceId)); foreach (var cv in request.ClientVersions) { if (cv.Version == null) { Log.Warn("Version NULL in type {0}", cv.UpdateType); continue; } var vn = SwlVersion.FromVersion(cv.Version).ToInt32(); Log.Trace("Type {0} Version {1} ({2})", cv.UpdateType, vn, cv.Version); var ii = dbConn.ExecuteBpl(new InstallGetByPlatformIdTypeVersionNumber(platformId, (Mpcr.Services.Oscar.Logistics.SoftwareUpdateType)cv.UpdateType, vn)); if (ii == null) { Log.Warn("No installation PLID {0}, Type {1}, Version {2}", platformId, (Mpcr.Services.Oscar.Logistics.SoftwareUpdateType)cv.UpdateType, vn); continue; } dbConn.ExecuteBpl(new DeviceInstallAdd(deviceId, (Mpcr.Services.Oscar.Logistics.SoftwareUpdateType)cv.UpdateType, ii.InstallId)); } } } dbConn.CommitTransaction(); } var target = LogisticsHelpers.CampaignTargetCheckForUpdate(dbConn, deviceId); if (target != null) { PeriodicUpdate pu = new PeriodicUpdate(); pu.UpdateType = (Mpcr.Messages.AutOS_SW.SoftwareUpdateType)target.CampaignType; pu.UpdateId = new Guid(target.TargetId.LocalId.ToString()); resp.AvailableUpdates.Add(pu); } } Reply(resp); }
internal static DbVehicleInfo VehicleSave(DbConnector dbConn, DeviceType dt, DbVehicleInfo vi) { if ((vi == null) || (vi.VehicleInfo == null)) { Log.Warn("Exiting: Vehicle info is null."); return null; } if (vi.VehicleInfo.VehicleSN.IsEmpty()) { Log.Warn("Exiting: Vehicle serial number is empty."); return null; } if (IsSimulated(vi.VehicleInfo.VehicleSN) || IsFactory(vi.VehicleInfo.VehicleSN)) { Log.Warn("Exiting: Vehicle serial number '{0}' is factory or simulated.", vi.VehicleInfo.VehicleSN); return null; } if (!vi.VehicleInfo.VehicleId.IsEmpty) { if (!vi.VehicleInfo.VehicleId.LocalId.ToString().EndsWith(vi.VehicleInfo.VehicleSN)) { Log.Warn("VehicleId '{0}' does not match VehicleSN '{1}'. Cleared.", vi.VehicleInfo.VehicleId.LocalId.ToString(), vi.VehicleInfo.VehicleSN); vi.VehicleInfo.VehicleId = BplIdentity.Empty; } } vi.VehicleKey = BuildKey(dt, vi.VehicleInfo.VehicleSN); if (vi.VehicleKey.IsEmpty()) { Log.Warn("Exiting: Vehicle Key is empty."); return null; } var exVehicle = dbConn.ExecuteBpl(new VehicleGetByKey { VehicleKey = vi.VehicleKey }); if (exVehicle != null) { if ((exVehicle.VehicleInfo.DataSource == DataSources.Vehicle) || (!OscarServer.UseBackendMasterData)) { if (vi.VehicleInfo.Operator == null) { vi.VehicleInfo.Operator = exVehicle.VehicleInfo.Operator; } dbConn.ExecuteBpl(new VehicleUpdate { i = vi }); } } else { dbConn.ExecuteBpl(new VehicleAdd { i = vi }); } if (OscarServer.UseBackendMasterData) { var viReq = new GetVehicleInfoHandler(); viReq.RequestVehicleInfo(vi.VehicleInfo.VehicleId); } return vi; }