internal static DbBatteryInfo BatterySave(DbConnector dbConn, DeviceType dt, DbBatteryInfo bi) { if ((bi == null) || (bi.BatteryInfo == null)) { Log.Warn("Exiting: Battery info is null."); return null; } if (bi.BatteryInfo.BatterySN.IsEmpty()) { Log.Warn("Exiting: Battery serial number is empty."); return null; } if (IsSimulated(bi.BatteryInfo.BatterySN) || IsFactory(bi.BatteryInfo.BatterySN)) { Log.Warn("Exiting: Battery serial number '{0}' is factory or simulated.", bi.BatteryInfo.BatterySN); return null; } if (!bi.BatteryInfo.BatteryId.IsEmpty) { if (!bi.BatteryInfo.BatteryId.LocalId.ToString().EndsWith(bi.BatteryInfo.BatterySN)) { Log.Warn("BatteryId '{0}' does not match BatterySN '{1}'. Cleared.", bi.BatteryInfo.BatteryId.LocalId.ToString(), bi.BatteryInfo.BatterySN); bi.BatteryInfo.BatteryId = BplIdentity.Empty; } } bi.BatteryKey = BuildKey(dt, bi.BatteryInfo.BatterySN); if (bi.BatteryKey.IsEmpty()) { Log.Warn("Exiting: Battery Key is empty."); return null; } var exBattery = dbConn.ExecuteBpl(new BatteryGetByKey { BatteryKey = bi.BatteryKey }); if (exBattery != null) { if ((exBattery.BatteryInfo.DataSource == DataSources.Vehicle) || (!OscarServer.UseBackendMasterData)) { if (bi.BatteryInfo.Operator == null) { bi.BatteryInfo.Operator = exBattery.BatteryInfo.Operator; } dbConn.ExecuteBpl(new BatteryUpdate { i = bi }); } } else { dbConn.ExecuteBpl(new BatteryAdd { i = bi }); } return bi; }
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); }