public override Task <TaskListResponse> GetTeamSpecificTasks(TeamDescription request, ServerCallContext context)
{
var respList = new TaskListResponse();
var teamID = -1;
_dbConnection.Open();
var command = "SELECT TeamID FROM Worker WHERE WorkerID =" + request.Index;
var newCommand = new SqlCommand(command, _dbConnection);
var dataReader = newCommand.ExecuteReader();
if (dataReader.Read())
{
teamID = dataReader.GetInt32(0);
command = "SELECT Team, TeamID, Status, Text FROM ScheduleItem WHERE Status = '" + request.Name +
"' AND TeamID =" + teamID;
newCommand = new SqlCommand(command, _dbConnection);
dataReader = newCommand.ExecuteReader();
while (dataReader.Read())
{
respList.Tasks.Add(new MessagesPack.Task
{
Team = dataReader.GetString(0), TeamID = dataReader.GetInt32(1),
Status = dataReader.GetString(2), Text = dataReader.GetString(3)
});
}
}
dataReader.Close();
_dbConnection.Close();
return(System.Threading.Tasks.Task.FromResult(respList));
}
public override Task <TaskListResponse> GetAllDepTasks(NameRequest request, ServerCallContext context) //TODO this throws error when invoked
{
//get all department teams
TeamListResp teams = new TeamListResp();
DBConnection.Open();
String command = "SELECT TeamID, TeamName FROM Team WHERE DepartmentName =" + request.TeamName;
SqlCommand newCommand = new SqlCommand(command, DBConnection);
SqlDataReader dataReader = newCommand.ExecuteReader();
while (dataReader.Read())
{
teams.TeamDesc.Add(new TeamDescription {
Index = dataReader.GetInt32(0), Name = dataReader.GetString(1)
});
}
//get all tasks for these teams
TaskListResponse taskList = new TaskListResponse();
foreach (var team in teams.TeamDesc)
{
command = "SELECT * FROM ScheduleItem WHERE Team =" + team.Name;
newCommand = new SqlCommand(command, DBConnection);
dataReader = newCommand.ExecuteReader();
while (dataReader.Read())
{
taskList.Tasks.Add(new MessagesPack.Task {
Status = dataReader.GetString(3), Team = dataReader.GetString(1), TeamID = dataReader.GetInt32(0), Text = dataReader.GetString(4)
});
}
}
dataReader.Close();
DBConnection.Close();
return(System.Threading.Tasks.Task.FromResult(taskList));
}
//服务器任务列表返回
void OnListRequestFinished(BaseHttpRequest request, BaseResponse response)
{
ComLoading.Close();
if (Core.Data.guideManger.isGuiding)
{
Core.Data.guideManger.AutoRUN();
}
if (response.status != BaseResponse.ERROR)
{
TaskListResponse res = response as TaskListResponse;
foreach (TaskDataResponse data in res.data.tasks)
{
TaskData tdata = tm[data.id];
if (tdata != null)
{
tdata.curProgress = data.progress;
tdata.Progress = data.condition;
if (tdata.Type == 0)
{
DayTaskList.Add(tdata);
}
else if (tdata.Type == 1)
{
MainTaskList.Add(tdata);
}
}
else
{
Debug.LogError("Not find Task[" + data.id.ToString() + "]");
}
}
}
//如果某种任务完成,优先显示那一类
if (isHaveCompleteTask(ref MainTaskList))
{
Core.Data.taskManager.LastSelectedType = 1;
}
if (isHaveCompleteTask(ref DayTaskList))
{
Core.Data.taskManager.LastSelectedType = 0;
}
if (curTaskType == UITaskType.None)
{
curTaskType = (UITaskType)Core.Data.taskManager.LastSelectedType;
}
//每日任务列表可能为空,但主线任务列表永远不会为空
if (DayTaskList.Count == 0)
{
_view.SetBtnBright(0, 1);
curTaskType = UITaskType.MainLine;
}
RefreshTaskList();
}
private async Task <IActionResult> HandlePhysicalViewNode(GraphNode <Key, FormNode> viewNode,
bool returnToSummary = false,
IDictionary <string, Answer> inFlightAnswers = null,
IDictionary <string, string> inFlightErrors = null)
{
var viewData = await _physicalNodeHandlerStrategy.Handle(GetFormTypeFromFormId(), GetFormId(), viewNode);
viewData.CurrentNodeId = viewNode.Key.Value;
ViewData[FormConstants.TempDataErrors] = inFlightErrors;
ViewData[FormConstants.TempDataAnswers] = inFlightAnswers;
ViewData[FormConstants.TempDataReturnToSummary] = returnToSummary;
ViewData[FormConstants.BackButtonProps] = new BackButtonProps(viewNode.Key.Value, viewData.ShowBackButton);
ViewData[FormConstants.ViewDataFormTitle] = _staticFormProvider.GetFormName(GetFormTypeFromFormId());
return(viewData switch
{
TaskListResponse taskListResponse => View("TaskList", taskListResponse),
TaskPageResponse taskQuestionResponse => View("TaskQuestionPage", taskQuestionResponse),
TaskSummaryResponse taskSummaryResponse => View("TaskSummary", taskSummaryResponse),
RepeatTaskResponse repeatTaskResponse => View("RepeatTask", repeatTaskResponse),
ConsentPageResponse consentPageResponse => View("ConsentPage", consentPageResponse),
PreTaskResponse preTaskResponse => View("PreTask", preTaskResponse),
RepeatSubTaskResponse repeatSubTaskResponse => View("RepeatSubTask", repeatSubTaskResponse),
_ => throw new NotImplementedException()
});
public async Task <IEnumerable <TaskListResponse> > GetAllAsync()
{
var taskLists = await _taskListService.GetAllAsync(GetCurrentUserId());
var responseList = TaskListResponse.MapFromTaskList(taskLists);
return(responseList);
}
void Update()
{
taskList = client.GetAllDepTasks(new MessagesPack.NameRequest {
TeamName = (client.GetDepFromUser(new MessagesPack.IntegerRequest {
Number = GlobalUsage.CurrentUser.workerID
}).Msg)
});
UpdateVisuals();
}
public async Task get_repair_request_by_reference_returns_a_repair_object_for_a_valid_request()
{
var mockLogger = new Mock <ILoggerAdapter <RepairsActions> >();
var request = new RepairRefRequest();
var response = new RepairGetResponse()
{
Success = true,
RepairRequest = new RepairRequestDto()
{
Reference = "43453543",
Problem = "tap leaking",
PriorityCode = "N",
PropertyReference = "123456890",
LocationCode = "1",
Name = "Test"
}
};
var tasksListResponse = new TaskListResponse
{
Success = true,
TaskList = new List <RepairTaskDto>
{
new RepairTaskDto
{
WorksOrderReference = "987654",
SupplierReference = "00000127",
JobCode = "12345678"
}
}.ToArray()
};
var fakeService = new Mock <IHackneyRepairsService>();
fakeService.Setup(service => service.GetRepairRequestByReferenceAsync(request))
.ReturnsAsync(response);
fakeService.Setup(service => service.GetRepairTasksAsync(It.IsAny <RepairRefRequest>()))
.ReturnsAsync(tasksListResponse);
var fakeRequestBuilder = new Mock <IHackneyRepairsServiceRequestBuilder>();
fakeRequestBuilder.Setup(service => service.BuildRepairRequest("43453543")).Returns(request);
RepairsActions repairsActions = new RepairsActions(fakeService.Object, fakeRequestBuilder.Object, mockLogger.Object);
var results = await repairsActions.GetRepairByReference("43453543");
var workOrders = new object[1];
workOrders[0] = new { workOrderReference = "987654", sorCode = "12345678", supplierReference = "00000127" };
var repairRequest = new
{
repairRequestReference = "43453543",
problemDescription = "tap leaking",
priority = "N",
propertyReference = "123456890",
contact = new { name = "Test" },
workOrders = workOrders
};
Assert.Equal(JsonConvert.SerializeObject(repairRequest), JsonConvert.SerializeObject(results));
}
public async Task <IHttpActionResult> Get([FromUri] string categoryName = null)
{
var categories = await _taskCategoryRepository.GetAll();
var categoryList = categories.ToList();
var tasks = await _taskRepository.GetAll(categoryName);
var taskList = tasks.ToList();
var result = new TaskListResponse
{
Data = taskList,
};
result.Lists.Add(categories);
return(Ok(result));
}
public Task <TaskListResponse> GetRepairTasksAsync(RepairRefRequest request)
{
var tasksListResponse = new TaskListResponse
{
Success = true,
TaskList = new List <RepairTaskDto>
{
new RepairTaskDto
{
WorksOrderReference = "987654",
RepairRequestReference = "123456",
SupplierReference = "000000127",
JobCode = "20090190"
}
}.ToArray()
};
return(Task.Run(() => tasksListResponse));
}
public override Task <TaskListResponse> GetTaskList(TaskListRequest request, ServerCallContext context)
{
TaskListResponse taskList = new TaskListResponse();
DBConnection.Open();
String command = "SELECT * FROM ScheduleItem WHERE Team =" + request.TeamName;
SqlCommand newCommand = new SqlCommand(command, DBConnection);
SqlDataReader dataReader = newCommand.ExecuteReader();
while (dataReader.Read())
{
taskList.Tasks.Add(new MessagesPack.Task {
Status = dataReader.GetString(3), Team = dataReader.GetString(1), TeamID = dataReader.GetInt32(0), Text = dataReader.GetString(4)
});
}
dataReader.Close();
DBConnection.Close();
return(System.Threading.Tasks.Task.FromResult(taskList));
}
GetAllDepTasks(NameRequest request, ServerCallContext context)
{
var teams = new TeamListResp();
_dbConnection.Open();
var command = "SELECT TeamID, TeamName FROM Team WHERE DepartmentName = '" + request.TeamName + "'";
var newCommand = new SqlCommand(command, _dbConnection);
var dataReader = newCommand.ExecuteReader();
while (dataReader.Read())
{
teams.TeamDesc.Add(new TeamDescription
{
Index = dataReader.GetInt32(0), Name = dataReader.GetString(1)
});
}
dataReader.Close();
_dbConnection.Close();
//get all tasks for these teams
var taskList = new TaskListResponse();
foreach (var team in teams.TeamDesc)
{
command = "SELECT * FROM ScheduleItem WHERE Team = '" + team.Name + "'";
newCommand = new SqlCommand(command, _dbConnection);
dataReader = newCommand.ExecuteReader();
while (dataReader.Read())
{
taskList.Tasks.Add(new MessagesPack.Task
{
Status = dataReader.GetString(3), Team = dataReader.GetString(1),
TeamID = dataReader.GetInt32(0), Text = dataReader.GetString(4)
});
}
}
dataReader.Close();
_dbConnection.Close();
return(System.Threading.Tasks.Task.FromResult(taskList));
}
public async Task create_repair_with_work_order_returns_a_created_repair_response_object_with_orders_included()
{
var mockLogger = new Mock <ILoggerAdapter <RepairsActions> >();
var request = new RepairRequest
{
ProblemDescription = "tap leaking",
Priority = "N",
PropertyReference = "00000320",
Contact = new RepairRequestContact
{
Name = "Test",
TelephoneNumber = "0123456789"
},
WorkOrders = new List <WorkOrder>
{
new WorkOrder
{
SorCode = "20090190"
}
}
};
var repairRequest = new NewRepairTasksRequest
{
RepairRequest = new RepairRequestInfo
{
PropertyRef = request.PropertyReference,
Priority = request.Priority,
Problem = request.ProblemDescription
},
TaskList = new List <RepairTaskInfo>
{
new RepairTaskInfo
{
JobCode = "12345678",
PropertyReference = "00000320",
}
}.ToArray()
};
var fakeRepairService = new Mock <IHackneyRepairsService>();
var response = new WorksOrderListResponse
{
Success = true,
WorksOrderList = new List <WorksOrderDto>
{
new WorksOrderDto
{
RepairRequestReference = "123456",
OrderReference = "987654",
PropertyReference = "00000320",
SupplierReference = "00000127"
}
}.ToArray()
};
var tasksListResponse = new TaskListResponse
{
Success = true,
TaskList = new List <RepairTaskDto>
{
new RepairTaskDto
{
WorksOrderReference = "987654",
SupplierReference = "00000127",
JobCode = "12345678"
}
}.ToArray()
};
fakeRepairService.Setup(service => service.CreateRepairWithOrderAsync(repairRequest))
.ReturnsAsync(response);
fakeRepairService.Setup(service => service.UpdateRequestStatus("123456")).ReturnsAsync(true);
fakeRepairService.Setup(service => service.GetRepairTasksAsync(It.IsAny <RepairRefRequest>()))
.ReturnsAsync(tasksListResponse);
var fakeRequestBuilder = new Mock <IHackneyRepairsServiceRequestBuilder>();
fakeRequestBuilder.Setup(builder => builder.BuildNewRepairTasksRequest(request)).Returns(repairRequest);
fakeRequestBuilder.Setup(builder => builder.BuildRepairRequest("123456")).Returns(new RepairRefRequest());
var repairsActions = new RepairsActions(fakeRepairService.Object, fakeRequestBuilder.Object, mockLogger.Object);
var result = await repairsActions.CreateRepair(request);
var workOrders = new object[1];
workOrders[0] = new { workOrderReference = "987654", sorCode = "12345678", supplierReference = "00000127" };
var response1 = new
{
repairRequestReference = "123456",
propertyReference = "00000320",
problemDescription = "tap leaking",
priority = "N",
contact = new { name = "Test", telephoneNumber = "0123456789" },
workOrders = workOrders
};
Assert.Equal(JsonConvert.SerializeObject(response1), JsonConvert.SerializeObject(result));
}
