public override Task <StringResponse> GetWorkerStatus(IntegerRequest request, ServerCallContext context)
{
var response = new StringResponse();
var user = _activeMembers.Find(member => member.ID == IntegerRequest.NumberFieldNumber);
response.Resp = user.ID == -1 ? "absent" : user.Status;
return(System.Threading.Tasks.Task.FromResult(response));
}
public override Task <WorkerEventResponse> GetWorkerName(IntegerRequest request, ServerCallContext context)
{
var tmp = new WorkerEventResponse
{
Msg = GetWorkerNameFromId(request.Number)
};
return(System.Threading.Tasks.Task.FromResult(tmp));
}
public override Task <WorkerEventResponse> GetWorkerName(IntegerRequest request, ServerCallContext context)
{
WorkerEventResponse tmp = new WorkerEventResponse();
DBConnection.Open();
tmp.Msg = GetWorkerNameFromID(request.Number);
DBConnection.Close();
return(System.Threading.Tasks.Task.FromResult(tmp));
}
public override Task <GetLeadersResponse> GetDepLeaders(IntegerRequest request, ServerCallContext context)
{
var tmp = new GetLeadersResponse();
_dbConnection.Open();
var command = "SELECT WorkerID, Name, TeamName, TeamID FROM Worker WHERE Level = 1 AND DepartmentID = " + request.Number;
var newCommand = new SqlCommand(command, _dbConnection);
var dataReader = newCommand.ExecuteReader();
while (dataReader.Read())
{
tmp.Leaders.Add(new leaderItem {
LeaderId = dataReader.GetInt32(0), LeaderName = dataReader.GetString(1), TeamName = dataReader.GetString(2), TeamId = dataReader.GetInt32(3)
});
}
dataReader.Close();
_dbConnection.Close();
return(System.Threading.Tasks.Task.FromResult(tmp));
}
public IActionResult PostVolumeState([FromBody] IntegerRequest volumeParameter)
{
if (volumeParameter.Name == null || !volumeParameter.Name.Equals("Volume"))
{
return(BadRequest(volumeParameter));
}
if (!ITunesService.Instance.IsActive)
{
return(new StatusCodeResult((int)HttpStatusCode.ServiceUnavailable));
}
var newVolume = ITunesService.Instance.ChangeVolume(volumeParameter.Data);
var volumeValue = newVolume ?? 0;
var response = new IntegerResponse()
{
Data = volumeValue,
Name = nameof(ITunesService.Instance.Volume)
};
return(Ok(response));
}
public override Task <WorkerEventResponse> GetDepFromUser(IntegerRequest request, ServerCallContext context)
{
var resp = new WorkerEventResponse();
DBConnection.Open();
String command = "SELECT DepartmentName FROM Worker WHERE DepartmentID =" + request.Number;
SqlCommand newCommand = new SqlCommand(command, DBConnection);
SqlDataReader dataReader = newCommand.ExecuteReader();
if (dataReader.Read())
{
resp.Msg = dataReader.GetString(0);
resp.State = true;
}
else
{
resp.Msg = "Empty";
resp.State = false;
}
dataReader.Close();
DBConnection.Close();
return(System.Threading.Tasks.Task.FromResult(resp));
}
