/// <summary>
/// Get import task from database.
/// </summary>
/// <param name="taskId">The task identifier.</param>
/// <param name="progressOnly">True to get the progress info only, false to get full details from the task xml.</param>
public static LongRunningInfo GetTaskInfo(Guid taskId, bool progressOnly)
{
var importResult = new LongRunningInfo( );
using (DatabaseContext databaseContext = DatabaseContext.GetContext( ))
{
// Create and initialize the command object
using (IDbCommand command = databaseContext.CreateCommand("spGetLongRunningTask", CommandType.StoredProcedure))
{
databaseContext.AddParameter(command, "@taskId", DbType.Guid, taskId);
using (IDataReader reader = command.ExecuteReader( ))
{
if (reader.Read( ))
{
LongRunningInfo info = null;
if (progressOnly)
{
// If the task is in progress, just return the task id
// and the status without deserializing the data contract.
LongRunningStatus status;
string statusAsString = reader.GetString(1);
if (!string.IsNullOrWhiteSpace(statusAsString) &&
Enum.TryParse(statusAsString, out status) &&
status == LongRunningStatus.InProgress)
{
info = new LongRunningInfo()
{
TaskId = taskId,
Status = status
};
}
}
if (info == null)
{
string xml = reader.GetString(2);
info = XmlHelper.DeserializeUsingDataContract <LongRunningInfo>(xml);
}
return(info);
}
}
}
}
return(importResult);
}
/// <summary>
/// Update long running task status.
/// </summary>
public static void UpdateStatus(Guid taskId, LongRunningStatus status, string errorMessage = null)
{
LongRunningInfo info = GetTaskInfo(taskId, false);
if (!string.IsNullOrEmpty(errorMessage))
{
info.ErrorMessage = errorMessage;
}
if (info.Status != LongRunningStatus.Cancelled)
{
info.Status = status;
SaveLongRunningTaskInfo(info);
}
}
/// <summary>
/// Cancels the task if it is still running or queued.
/// </summary>
/// <param name="taskId">The task identifier.</param>
/// <exception cref="System.ArgumentException">@Invalid task identifier</exception>
public static void CancelTask(string taskId)
{
Guid taskIdentifier;
if (!Guid.TryParse(taskId, out taskIdentifier))
{
throw new ArgumentException(@"Invalid task identifier", taskId);
}
LongRunningInfo info = LongRunningHelper.GetTaskInfo(taskIdentifier, false);
if (info.Status == LongRunningStatus.InProgress || info.Status == LongRunningStatus.Queued)
{
LongRunningHelper.UpdateStatus(taskIdentifier, LongRunningStatus.Cancelled);
}
}
/// <summary>
/// Create/Save long running task in the database.
/// </summary>
/// <param name="info">The info.</param>
public static void SaveLongRunningTaskInfo(LongRunningInfo info)
{
string infoXml = XmlHelper.SerializeUsingDataContract(info);
using (DatabaseContext databaseContext = DatabaseContext.GetContext( ))
{
// Create and initialize the command object
using (IDbCommand command = databaseContext.CreateCommand("spSaveLongRunningTask", CommandType.StoredProcedure))
{
databaseContext.AddParameter(command, "@taskId", DbType.Guid, info.TaskId);
databaseContext.AddParameter(command, "@status", DbType.String, info.Status);
databaseContext.AddParameter(command, "@additionalInfo", DbType.String, infoXml);
command.ExecuteNonQuery( );
}
}
}
/// <summary>
/// Starts a new
/// </summary>
/// <param name="action"></param>
/// <returns></returns>
public static LongRunningInfo StartLongRunningInWorkerThread(Action <LongRunningInfo> action)
{
var requestContext = RequestContext.GetContext( );
var info = new LongRunningInfo
{
Status = LongRunningStatus.InProgress,
TaskId = Guid.NewGuid( )
};
SaveLongRunningTaskInfo(info);
var thread = new Thread(StartWorker)
{
Name = "LongRunningHelper", IsBackground = true
};
thread.Start(new Tuple <Action <LongRunningInfo>, LongRunningInfo, RequestContext>(action, info, requestContext));
return(info);
}
