/// <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));
}
