public IHttpActionResult UpdateBulk(string groupName, ExecutionReportStatus status)
{
var result = new ResultMessage <bool>();
try
{
result = this.testQueueService.UpdateTestQueueStatusByGroupName(this.UserId, groupName, status);
}
catch (Exception ex)
{
this.LoggerService.LogException(ex);
result.Messages.Add(new Message(null, ex.Message));
}
return(this.CreateCustomResponse(result));
}
public IHttpActionResult ChangeTestQueueState(long testQueueId, ExecutionReportStatus stateId)
{
var result = new ResultMessage <TblTestQueueDto>();
try
{
result = this.testQueueService.GetById(testQueueId);
if (!result.IsError)
{
result.Item.Status = (int)stateId;
result = this.testQueueService.SaveOrUpdate(result.Item, this.UserId);
}
}
catch (Exception ex)
{
this.LoggerService.LogException(ex);
result.Messages.Add(new Message(null, ex.Message));
}
return(this.CreateCustomResponse(result));
}
/// <summary>
/// Updates the name of the test queue status by group.
/// </summary>
/// <param name="userId">The user identifier.</param>
/// <param name="groupName">Name of the group.</param>
/// <param name="status">The status.</param>
/// <returns>
/// Status update
/// </returns>
public ResultMessage <bool> UpdateTestQueueStatusByGroupName(long userId, string groupName, ExecutionReportStatus status)
{
var sqlQuery = "update \"TblTestQueue\" set \"Status\" = @Status, \"ModifiedOn\" = current_timestamp, \"ModifiedBy\" = @UserId where \"GroupName\" = @groupName";
if (status == ExecutionReportStatus.Cancelled)
{
sqlQuery = "update \"TblTestQueue\" set \"Status\" = @Status, \"ModifiedOn\" = current_timestamp, \"ModifiedBy\" = @UserId where \"GroupName\" = @groupName and \"Status\" in (0, 1)";
}
var result = new ResultMessage <bool>
{
Item =
this.Table.ExecuteSqlCommand(
sqlQuery,
new NpgsqlParameter("@groupName", groupName),
new NpgsqlParameter("@UserId", userId),
new NpgsqlParameter("@Status", (int)status)) > 0
};
return(result);
}
