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)); }
public override Task <TeamListResp> GetAllWorkers(BlankMsg request, ServerCallContext context) { TeamListResp tmp = new TeamListResp(); DBConnection.Open(); String command = "SELECT WorkerID, Name FROM Worker"; SqlCommand newCommand = new SqlCommand(command, DBConnection); SqlDataReader dataReader = newCommand.ExecuteReader(); while (dataReader.Read()) { tmp.TeamDesc.Add(new TeamDescription { Index = dataReader.GetInt32(0), Name = dataReader.GetString(1) }); } dataReader.Close(); DBConnection.Close(); return(System.Threading.Tasks.Task.FromResult(tmp)); }
public override Task <TeamListResp> GetDepartmetTeams(NameRequest request, ServerCallContext context) { TeamListResp tmp = new TeamListResp(); DBConnection.Open(); String command = "SELECT * FROM Team WHERE DepartmentName=" + request.TeamName; SqlCommand newCommand = new SqlCommand(command, DBConnection); SqlDataReader dataReader = newCommand.ExecuteReader(); while (dataReader.Read()) { tmp.TeamDesc.Add(new TeamDescription { Index = dataReader.GetInt32(0), Name = dataReader.GetString(1) }); } dataReader.Close(); DBConnection.Close(); return(System.Threading.Tasks.Task.FromResult(tmp)); }
public override Task <TeamListResp> GetDepartmentWorkers(NameRequest request, ServerCallContext context) { var tmp = new TeamListResp(); _dbConnection.Open(); var command = "SELECT * FROM Worker WHERE DepartmentName = '" + request.TeamName + "'"; var newCommand = new SqlCommand(command, _dbConnection); var dataReader = newCommand.ExecuteReader(); while (dataReader.Read()) { tmp.TeamDesc.Add(new TeamDescription { Index = dataReader.GetInt32(0), Name = dataReader.GetString(2) }); } dataReader.Close(); _dbConnection.Close(); return(System.Threading.Tasks.Task.FromResult(tmp)); }
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)); }