/// <summary>
/// Indicates whether the <see cref="DbRule"/> of the <see cref="DbRuleObject"/> differs from the <see cref="Rule"/>,
/// thereby requiring the <see cref="DbRule"/> and related <see cref="DbCondition"/> objects to be updated in the database.
/// </summary>
/// <param name="dbRuleObject"></param>
/// <param name="rule"></param>
/// <returns>True if update is required otherwise false</returns>
public static bool DbRuleObjectRequiresUpdate(DbRuleObject dbRuleObject, Rule rule)
{
if (dbRuleObject.DbRule.GeotabId != rule.Id.ToString())
{
throw new ArgumentException($"Cannot compare Rule '{rule.Id}' with DbUser '{dbRuleObject.DbRule.GeotabId}' because the IDs do not match.");
}
if (dbRuleObject.DbRule.Version != rule.Version)
{
return(true);
}
return(false);
}
/// <summary>
/// Builds the <see cref="DbRuleObject"/> and then inserts it into the database
/// </summary>
/// <param name="ruleList">List of Geotab <see cref="Rule"/> objects</param>
/// <param name="entityStatus"></param>
/// <param name="recordLastChanged"></param>
/// <param name="operationType"></param>
/// <param name="cancellationTokenSource">The <see cref="CancellationTokenSource"/>.</param>
/// <returns>The count of successful inserts</returns>
public async static Task <int> InsertDbRuleObjectsFromRuleListAsync(IList <Rule> ruleList, int entityStatus,
DateTime recordLastChanged, DatabaseWriteOperationType operationType, CancellationTokenSource cancellationTokenSource)
{
CancellationToken cancellationToken = cancellationTokenSource.Token;
int insertCount = 0;
foreach (Rule rule in ruleList)
{
using (DbRuleObject dbRuleObject = new DbRuleObject())
{
dbRuleObject.BuildRuleObject(rule, entityStatus, recordLastChanged, operationType);
if (await InsertDbRuleObjectAsync(dbRuleObject, cancellationTokenSource))
{
insertCount++;
}
}
cancellationToken.ThrowIfCancellationRequested();
}
return(insertCount);
}
/// <summary>
/// Inserts the <see cref="DbRuleObject"/> object into the database
/// </summary>
/// <param name="dbRuleObject">The <see cref="DbRuleObject"/> object to insert.</param>
/// <param name="cancellationTokenSource">The <see cref="CancellationTokenSource"/>.</param>
/// <returns></returns>
public async static Task <bool> InsertDbRuleObjectAsync(DbRuleObject dbRuleObject, CancellationTokenSource cancellationTokenSource)
{
ConnectionInfo connectionInfo = new(Globals.ConfigurationManager.DatabaseConnectionString, Globals.ConfigurationManager.DatabaseProviderType);
long ruleEntitiesInserted;
try
{
ruleEntitiesInserted = await DbRuleService.InsertRuleAsync(connectionInfo, dbRuleObject.DbRule, Globals.ConfigurationManager.TimeoutSecondsForDatabaseTasks);
}
catch (Exception)
{
cancellationTokenSource.Cancel();
throw;
}
logger.Debug($"{ruleEntitiesInserted} rules inserted. Rule Name: {dbRuleObject.DbRule.Name}");
long condEntitiesInserted;
try
{
condEntitiesInserted = await DbConditionService.InsertAsync(connectionInfo, dbRuleObject.DbConditions, cancellationTokenSource, Globals.ConfigurationManager.TimeoutSecondsForDatabaseTasks);
}
catch (Exception)
{
cancellationTokenSource.Cancel();
throw;
}
logger.Debug($"{condEntitiesInserted} conditions inserted");
if ((ruleEntitiesInserted > 0) && (condEntitiesInserted > 0))
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// Gets the Rules and Conditions from the database and constructs the DbRuleObjects which are then returned as a list.
/// </summary>
/// <param name="cancellationTokenSource">The <see cref="CancellationTokenSource"/>.</param>
/// <returns></returns>
public static async Task <IList <DbRuleObject> > GetDatabaseRuleObjectsAsync(CancellationTokenSource cancellationTokenSource)
{
MethodBase methodBase = MethodBase.GetCurrentMethod();
logger.Trace($"Begin {methodBase.ReflectedType.Name}.{methodBase.Name}");
ConnectionInfo connectionInfo = new ConnectionInfo(Globals.ConfigurationManager.DatabaseConnectionString, Globals.ConfigurationManager.DatabaseProviderType);
string sql = "Select * from \"vwRuleObject\"";
IEnumerable <DbVwRuleObject> dbVwRuleObjects;
try
{
dbVwRuleObjects = await DbGeneralService.ExecDynamicTypeQueryAsync <DbVwRuleObject>(connectionInfo, sql, cancellationTokenSource, Globals.ConfigurationManager.TimeoutSecondsForDatabaseTasks);
}
catch (Exception)
{
cancellationTokenSource.Cancel();
throw;
}
IList <DbRuleObject> dbRuleObjectList = new List <DbRuleObject>();
string ruleId = "";
int countOfDbVwRuleObjects = dbVwRuleObjects.Count();
int countOfProcessedDbVwRuleObjects = 0;
DbRule dbRule = new DbRule();
DbCondition dbCondition;
IList <DbCondition> dbConditionList = new List <DbCondition>();
// Loop through all database rows of vwRuleObject
foreach (DbVwRuleObject dbVwRuleObject in dbVwRuleObjects)
{
string currentRuleId = dbVwRuleObject.GeotabId;
logger.Debug($"Current RuleId: {currentRuleId}");
// If rule Id changes go in here
if (currentRuleId != ruleId)
{
// Add the previous data iteration to the dbRuleObjectList
if (ruleId.Length > 0)
{
// Build the DbRuleObject
DbRuleObject dbRuleObject = new DbRuleObject();
dbRuleObject.BuildFromDatabaseObjects(dbRule, dbConditionList);
dbRuleObjectList.Add(dbRuleObject);
}
// Add the latest rule
ruleId = currentRuleId;
logger.Debug($"Add rule with Id: {ruleId}");
dbRule = new DbRule
{
GeotabId = dbVwRuleObject.GeotabId,
Name = dbVwRuleObject.Name,
BaseType = dbVwRuleObject.BaseType,
ActiveFrom = dbVwRuleObject.ActiveFrom,
ActiveTo = dbVwRuleObject.ActiveTo,
Version = dbVwRuleObject.Version,
EntityStatus = dbVwRuleObject.EntityStatus,
RecordLastChangedUtc = dbVwRuleObject.RecordLastChangedUtc
};
// Instantiate the next condition list to add the conditions.
dbConditionList = new List <DbCondition>();
}
// Create the current DbCondition object
string conditionId = dbVwRuleObject.Cond_Id;
logger.Debug($"Add condition with Id: {conditionId}");
dbCondition = new DbCondition
{
GeotabId = conditionId,
ParentId = dbVwRuleObject.Cond_ParentId,
RuleId = dbVwRuleObject.Cond_RuleId,
ConditionType = dbVwRuleObject.Cond_ConditionType,
DeviceId = dbVwRuleObject.Cond_DeviceId,
DiagnosticId = dbVwRuleObject.Cond_DiagnosticId,
DriverId = dbVwRuleObject.Cond_DriverId,
Value = (double?)dbVwRuleObject.Cond_Value,
WorkTimeId = dbVwRuleObject.Cond_WorkTimeId,
ZoneId = dbVwRuleObject.Cond_ZoneId,
EntityStatus = (int)dbVwRuleObject.Cond_EntityStatus,
RecordLastChangedUtc = dbVwRuleObject.Cond_RecordLastChangedUtc
};
// Add the current DbCondition object to the condition list.
dbConditionList.Add(dbCondition);
// Update count for interest.
countOfProcessedDbVwRuleObjects++;
// If this is the last DbVwRuleObject being pocessed, a corresponding DbRuleObject must be built and added to the list.
if (countOfProcessedDbVwRuleObjects == countOfDbVwRuleObjects)
{
DbRuleObject dbRuleObject = new DbRuleObject();
dbRuleObject.BuildFromDatabaseObjects(dbRule, dbConditionList);
dbRuleObjectList.Add(dbRuleObject);
}
}
logger.Info($"Row count: {countOfProcessedDbVwRuleObjects}");
logger.Trace($"End {methodBase.ReflectedType.Name}.{methodBase.Name}");
return(dbRuleObjectList);
}