public async Task <Response> ExecutePreDelete()
{
Logger.LogDebug($"{Constant.Names.ApplicationName} - Entering ExecutePreDelete().");
var response = new Response {
Success = true, Message = string.Empty
};
try
{
var setStatus = await ArtifactQueries.RetrieveRdoJobStatusAsync(SvcManager, WorkspaceArtifactId, IdentityCurrentUser, ActiveArtifactId);
if (!string.IsNullOrEmpty(setStatus))
{
switch (setStatus)
{
case Constant.Status.Job.SUBMITTED:
case Constant.Status.Job.IN_PROGRESS_MANAGER:
case Constant.Status.Job.IN_PROGRESS_WORKER:
case Constant.Status.Job.COMPLETED_MANAGER:
case Constant.Status.Job.CANCELREQUESTED:
case Constant.Status.Job.RETRY:
response.Success = false;
response.Exception = new SystemException(Constant.ErrorMessages.NotSupportedJobDeletion);
break;
case Constant.Status.Job.CANCELLED:
case Constant.Status.Job.COMPLETED:
case Constant.Status.Job.COMPLETED_WITH_ERRORS:
case Constant.Status.Job.ERROR:
case Constant.Status.Job.NEW:
//Do nothing
break;
}
}
}
catch (Exception ex)
{
response.Success = false;
response.Exception = new SystemException($"{Constant.ErrorMessages.DefaultErrorPrepend}, Error Message: {ex}");
}
Logger.LogDebug($"{Constant.Names.ApplicationName} - Exiting ExecutePreDelete().");
return(response);
}
public async Task <Response> ExecutePreSave(bool isArtifactNew, Int32 statusFieldArtifactId)
{
var response = new Response {
Success = true, Message = string.Empty
};
try
{
ValidateEmailTo(response);
if (isArtifactNew)
{
//Update the Status field
ActiveArtifact.Fields[statusFieldArtifactId].Value.Value = Constant.Status.Job.NEW;
}
else
{
var status = await ArtifactQueries.RetrieveRdoJobStatusAsync(SvcManager, WorkspaceArtifactId, IdentityCurrentUser, ActiveArtifact.ArtifactID);
if (!string.IsNullOrEmpty(status))
{
switch (status)
{
case Constant.Status.Job.SUBMITTED:
case Constant.Status.Job.IN_PROGRESS:
case Constant.Status.Job.IN_PROGRESS_MANAGER:
case Constant.Status.Job.IN_PROGRESS_WORKER:
case Constant.Status.Job.COMPLETED_MANAGER:
case Constant.Status.Job.CANCELREQUESTED:
case Constant.Status.Job.RETRY:
response.Success = false;
response.Message = Constant.ErrorMessages.NotSupportedJobEdit;
break;
}
}
}
}
catch (Exception ex)
{
response.Success = false;
response.Message = $"{Constant.ErrorMessages.DefaultErrorPrepend}, Error Message: {ex}";
}
return(response);
}
public async Task <string> RetrieveJobStatusAsync(IServicesMgr svcManager, Int32 workspaceArtifactId, ExecutionIdentity identity, Int32 artifactId)
{
var status = await ArtifactQueries.RetrieveRdoJobStatusAsync(svcManager, workspaceArtifactId, identity, artifactId);
return(status);
}
public async Task <Response> ExecutePreCascadeDelete()
{
var response = new Response {
Success = true, Message = string.Empty
};
try
{
var dtExportJobErrors = SqlQueryHelper.RetrieveJobErrorsFromTempTable(DbContext, TempTableName);
if (dtExportJobErrors != null && dtExportJobErrors.Rows.Count > 0)
{
var jobArtifactIDs = dtExportJobErrors.Rows.OfType <DataRow>().Select(dr => dr.Field <Int32>("ArtifactID")).ToList();
var setStatus = await ArtifactQueries.RetrieveRdoJobStatusAsync(SvcManager, WorkspaceArtifactId, IdentityCurrentUser, jobArtifactIDs[0]);
if (!string.IsNullOrEmpty(setStatus))
{
switch (setStatus)
{
case Constant.Status.Job.SUBMITTED:
case Constant.Status.Job.IN_PROGRESS_MANAGER:
case Constant.Status.Job.IN_PROGRESS_WORKER:
case Constant.Status.Job.COMPLETED_MANAGER:
case Constant.Status.Job.CANCELREQUESTED:
case Constant.Status.Job.RETRY:
response.Success = false;
response.Exception = new SystemException(Constant.ErrorMessages.NotSupportedJobDeletion);
break;
case Constant.Status.Job.CANCELLED:
case Constant.Status.Job.COMPLETED:
case Constant.Status.Job.COMPLETED_WITH_ERRORS:
case Constant.Status.Job.ERROR:
case Constant.Status.Job.NEW:
Logger.LogDebug($"{Constant.Names.ApplicationName} - Delete Export Job button clicked.");
if (jobArtifactIDs.Count > 0)
{
Logger.LogDebug($"{Constant.Names.ApplicationName} - Delete Export Job button click, {jobArtifactIDs.Count} Export Job Errors found.");
var jobErrorArtifactIDs = await ArtifactQueries.QueryJobErrors(SvcManager, IdentityCurrentUser, WorkspaceArtifactId, jobArtifactIDs[0], Constant.Guids.ObjectType.ExportUtilityJobErrors, Constant.Guids.Field.ExportUtilityJobErrors.ExportUtilityJob);
var errorArtifactIDs = jobErrorArtifactIDs as int[] ?? jobErrorArtifactIDs.ToArray();
if (jobErrorArtifactIDs != null & errorArtifactIDs.Any())
{
var artifactTypeId = SqlQueryHelper.RetrieveArtifactTypeIdByGuidAsync(DbContext, Constant.Guids.ObjectType.ExportUtilityJobErrors).Result;
await ArtifactQueries.DeleteJobErrors(SvcManager, IdentityCurrentUser, WorkspaceArtifactId, jobErrorArtifactIDs.ToList(), artifactTypeId);
Logger.LogDebug($"{Constant.Names.ApplicationName} - Delete Export Job button click, {jobArtifactIDs.Count} Export Job Errors deleted.");
}
}
else
{
Logger.LogDebug($"{Constant.Names.ApplicationName} - Delete Export Job button click, no Export Job Errors found.");
}
Logger.LogDebug($"{Constant.Names.ApplicationName} - Delete Export Job button click action completed.");
break;
}
}
}
}
catch (Exception ex)
{
response.Success = false;
response.Exception = new SystemException($@"{Constant.ErrorMessages.DefaultErrorPrepend}, Error Message: {ex}");
}
return(response);
}