public void UpdateQueue(Guid batchDetailsId, UploadStatus status, String user)
{
UploadQueueVMDC uploadRecord = uploadQueueManager.GetUploadQueue(user, user, appID, "", batchDetailsId.ToString());
UploadQueueDC toUpdate = uploadRecord.UploadQueueItem;
switch (status)
{
case UploadStatus.Cancelled:
toUpdate.Status = "X";
break;
case UploadStatus.Uploaded:
toUpdate.Status = "U";
break;
case UploadStatus.Processed:
toUpdate.Status = "P";
break;
case UploadStatus.Failed:
toUpdate.Status = "F";
break;
case UploadStatus.Queued:
toUpdate.Status = "Q";
break;
case UploadStatus.Running:
toUpdate.Status = "R";
break;
}
uploadQueueManager.UpdateUploadQueue(user, user, appID, "", toUpdate);
}
public Guid Queue(BatchDetails batchDetails)
{
UploadQueueDC dc = new UploadQueueDC();
dc.ApplicationCode = batchDetails.AppId;
dc.ConnectionString = batchDetails.DatabaseConnectionString;
dc.TempTableName = batchDetails.TableName;
dc.StoredProcedure = batchDetails.StoredProcedure;
dc.UploadFileName = batchDetails.FileName;
dc.Status = "R";
UploadQueueVMDC result = uploadQueueManager.CreateUploadQueue(batchDetails.CurrentUser, batchDetails.CurrentUser, appID, "", dc);
batchDetails.ProcessId = result.UploadQueueItem.Code;
return(result.UploadQueueItem.Code);
}
