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