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