/// <inheritdoc /> public void Handle(GetJobIdQuery <T> query, IDbCommand dbCommand, CommandStringTypes commandType) { dbCommand.CommandText = _commandCache.GetCommand(commandType); var param = dbCommand.CreateParameter(); param.ParameterName = "@JobName"; param.Size = 255; param.DbType = DbType.AnsiString; param.Value = query.JobName; dbCommand.Parameters.Add(param); }
/// <inheritdoc /> public int Handle(GetJobIdQuery <int> query) { using (var db = _connectionInformation.GetDatabase()) { var col = db.Database.GetCollection <Schema.StatusTable>(_tableNameHelper.StatusName); var results = col.Query() .Where(x => x.JobName == query.JobName) .Limit(1) .ToList(); if (results != null && results.Count == 1) { return(results[0].QueueId); } return(default);
/// <inheritdoc /> public T Handle(GetJobIdQuery <T> query) { using (var connection = _dbConnectionFactory.Create()) { connection.Open(); using (var command = connection.CreateCommand()) { _prepareQuery.Handle(query, command, CommandStringTypes.GetJobId); using (var reader = command.ExecuteReader()) { if (reader.Read()) { return(_readColumn.ReadAsType <T>(CommandStringTypes.GetJobId, 0, reader)); } } } } return(default);
/// <inheritdoc /> public string Handle(GetJobIdQuery <string> query) { var db = _connection.Connection.GetDatabase(); return(db.HashGet(_redisNames.JobNames, query.JobName)); }