public string GetMarkAsProcessedCommand(AnDatabaseTypes.DriverType driverType) { var result = ""; try { if (ProcessedDateTime <= AnTypes.MinDateTimeValue) { ProcessedDateTime = DateTime.UtcNow; } result = AnDatabaseTypes.GenerateUpdateStatement(DbTableName, GeneratePrimaryKeyWhereClause(driverType), new List <AnDatabaseCommandData> { new AnDatabaseCommandData(nameof(ProcessedDateTime), ProcessedDateTime, AnTypes.DataType.DateTime, AnSerialization.DateTimeSize), new AnDatabaseCommandData(nameof(ErrorMessage), ErrorMessage, AnTypes.DataType.VarChar, ErrorMessageSize), new AnDatabaseCommandData(nameof(Result), Result, AnTypes.DataType.Boolean, AnSerialization.BooleanSize), new AnDatabaseCommandData(nameof(Processed), true, AnTypes.DataType.Boolean, AnSerialization.BooleanSize) }, new List <AnDatabaseCommandData>(), driverType, false); } catch (Exception ex) { AnLog.Error(ex); } return(result); }
public string GenerateUpdateStatement <T>(AnDatabaseTypes.DriverType driverType, T modelObject) { var result = ""; try { var whereClause = GeneratePrimaryKeyWhereClause(driverType); if (!string.IsNullOrEmpty(whereClause)) { result = AnDatabaseTypes.GenerateUpdateStatement(GetDbTableName(), whereClause, GenerateDatabaseCommandDataList(false), (modelObject as AnModelBase)?.GenerateDatabaseCommandDataList(false) ?? new AnList <AnDatabaseCommandData>(), driverType, false); } } catch (Exception ex) { AnLog.Error(ex); } return(result); }