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