/// <summary>
/// Updates the state of the existing entity.
/// </summary>
/// <param name="context">The context.</param>
/// <param name="entityEntry">The entity entry.</param>
/// <param name="egmMetric">The egm metric.</param>
private static void UpdateExistingEntityState(HmsDbContext context, DbEntityEntry entityEntry,
EgmMetric egmMetric)
{
var metricEntity = (EgmMetric)entityEntry.Entity;
if (!metricEntity.SentAt.Equals(egmMetric.SentAt))
{
metricEntity.SentAt = egmMetric.SentAt;
}
if (!metricEntity.ReportGuid.Equals(egmMetric.ReportGuid))
{
metricEntity.ReportGuid = egmMetric.ReportGuid;
}
DaoUtilities.UpdateVersion(context, entityEntry);
}
/// <summary>
/// Updates the state of the existing entity.
/// </summary>
/// <param name="context">The context.</param>
/// <param name="entityEntry">The entity entry.</param>
/// <param name="egmWindowsEvent">The egm windows event entity.</param>
private static void UpdateExistingEntityState(HmsDbContext context, DbEntityEntry entityEntry,
EgmWindowsEvent egmWindowsEvent)
{
var winEvtEntity = (EgmWindowsEvent)entityEntry.Entity;
if (!winEvtEntity.SentAt.Equals(egmWindowsEvent.SentAt))
{
winEvtEntity.SentAt = egmWindowsEvent.SentAt;
}
if (!winEvtEntity.ReportGuid.Equals(egmWindowsEvent.ReportGuid))
{
winEvtEntity.ReportGuid = egmWindowsEvent.ReportGuid;
}
DaoUtilities.UpdateVersion(context, entityEntry);
}
/// <summary>
/// Resolves the entity update conflict.
/// </summary>
/// <param name="context">The context.</param>
/// <param name="entityEntry">The entity entry.</param>
private static void ResolveEntityUpdateConflict(HmsDbContext context, DbEntityEntry entityEntry)
{
///////////////////////////////////////////////////////////////////////////
// This should never occur for EgmMetric entities
// because we simply add records to the db table when we receive
// them from the HMS EGM Client message (HMS Onsite Service) or the HMS Onsite
// Service (HMS Cloud Service). We do update the records on the
// HMS Onsite Service when we package them up and send them to
// the HMS Cloud Service (ReportGuid and SentAt fields are updated)
// but in a single-threaded way and only after having created the
// initial record.
//
// We will use the "first in wins" resolution approach, but this ought
// never be invoked.
//////////////////////////////////////////////////////////////////////////
entityEntry.Reload();
DaoUtilities.UpdateVersion(context, entityEntry);
}
/// <summary>
/// Resolves the entity update conflict.
/// </summary>
/// <param name="context">The context.</param>
/// <param name="entityEntry">The entity entry.</param>
private static void ResolveEntityUpdateConflict(HmsDbContext context, DbEntityEntry entityEntry)
{
///////////////////////////////////////////////////////////////////////////
// There is potential for DbConcurrencyUpdate optimistic locking conflicts
// with CompositeEgmMeterData entities.
//
// Specifically, when multiple threads are consuming incoming meter reading
// data on the HMS Cloud Service, there is the potential for more than one
// such thread to have meter readings with the same EgmCompositeKey.
//
// Thus, we need to sort out such potential conflicts here.
//////////////////////////////////////////////////////////////////////////
var currentValues = entityEntry.CurrentValues;
var originalValues = entityEntry.OriginalValues;
entityEntry.Reload();
var dbValues = entityEntry.CurrentValues;
var currentUpdates = new List <string>();
var dbUpdates = new List <string>();
var mutableMeters = new List <string>
{
nameof(CompositeEgmMeterData.CoinIn),
nameof(CompositeEgmMeterData.CoinOut),
nameof(CompositeEgmMeterData.BillDrop),
nameof(CompositeEgmMeterData.GamesPlayed),
nameof(CompositeEgmMeterData.GamesLost),
nameof(CompositeEgmMeterData.GamesWon),
nameof(CompositeEgmMeterData.Handpay),
nameof(CompositeEgmMeterData.Jackpot),
nameof(CompositeEgmMeterData.MeteredAttendantPaidProgressive),
nameof(CompositeEgmMeterData.MeteredMachinePaidProgressive),
nameof(CompositeEgmMeterData.TicketDrop),
nameof(CompositeEgmMeterData.TicketOut)
};
// Look for updates to meters (relative to original values) in both
// current changes and conflicting db updates
foreach (var meter in mutableMeters)
{
if (currentValues.GetValue <long>(meter) != originalValues.GetValue <long>(meter))
{
currentUpdates.Add(meter);
}
if (dbValues.GetValue <long>(meter) != originalValues.GetValue <long>(meter))
{
dbUpdates.Add(meter);
}
}
// Check if there are meters which were updated in both our current updates
// and the conflicting db updates.
foreach (var commonMeter in currentUpdates.Intersect(dbUpdates))
{
// since the mutable meters can only increase in value,
// we take the larger value as winner
var currentMeterValue = currentValues.GetValue <long>(commonMeter);
var dbMeterValue = dbValues.GetValue <long>(commonMeter);
entityEntry.CurrentValues[commonMeter] = currentMeterValue > dbMeterValue
? currentMeterValue
: dbMeterValue;
currentUpdates.Remove(commonMeter);
dbUpdates.Remove(commonMeter);
}
// Take any current updates and apply to entity
foreach (var meter in currentUpdates)
{
entityEntry.CurrentValues[meter] = currentValues.GetValue <long>(meter);
}
// Finally, we update the dependent meters (SlotRevenue and AverageBet)
var coinIn = entityEntry.CurrentValues.GetValue <long>(nameof(CompositeEgmMeterData.CoinIn));
var coinOut = entityEntry.CurrentValues.GetValue <long>(nameof(CompositeEgmMeterData.CoinOut));
var gamesPlayed = entityEntry.CurrentValues.GetValue <long>(nameof(CompositeEgmMeterData.GamesPlayed));
var jackpot = entityEntry.CurrentValues.GetValue <long>(nameof(CompositeEgmMeterData.Jackpot));
if (CompositeEgmMeterData.MeterNotRecordedL != coinIn &&
CompositeEgmMeterData.MeterNotRecordedL != gamesPlayed && 0 < gamesPlayed)
{
entityEntry.CurrentValues[nameof(CompositeEgmMeterData.AverageBet)] = (decimal)coinIn / gamesPlayed;
}
if (CompositeEgmMeterData.MeterNotRecordedL != coinIn &&
CompositeEgmMeterData.MeterNotRecordedL != coinOut &&
CompositeEgmMeterData.MeterNotRecordedL != jackpot)
{
entityEntry.CurrentValues[nameof(CompositeEgmMeterData.SlotRevenue)] = coinIn - coinOut - jackpot;
}
DaoUtilities.UpdateVersion(context, entityEntry);
}
/// <summary>
/// Updates the state of the existing entity.
/// </summary>
/// <param name="context">The context.</param>
/// <param name="entityEntry">The entity entry.</param>
/// <param name="compositeEgmMeterData">The composite egm meter data.</param>
private static void UpdateExistingEntityState(HmsDbContext context, DbEntityEntry entityEntry,
ICompositeEgmMeterData compositeEgmMeterData)
{
entityEntry.CurrentValues.SetValues(compositeEgmMeterData);
DaoUtilities.UpdateVersion(context, entityEntry);
}