コード例 #1
0
        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));
        }
コード例 #2
0
        public override Task <WorkerEventResponse> RemoveTeam(TeamDescription request, ServerCallContext context)
        {
            DBConnection.Open();
            String     command    = "DELETE FROM Team WHERE TeamName =" + request.Name;
            SqlCommand newCommand = new SqlCommand(command, DBConnection);

            newCommand.ExecuteNonQuery();
            DBConnection.Close();
            return(System.Threading.Tasks.Task.FromResult(new WorkerEventResponse {
                State = true, Msg = "Team deleted sucesfully!"
            }));
        }
コード例 #3
0
        public static List <ReplayDescription> GetListOfReplays(Guid accountID)
        {
            try
            {
                List <ReplayDescription> userreplays = new List <ReplayDescription>();

                List <Game> usergames = (from g in db.Game
                                         where g.Creator_ID == accountID
                                         select g).ToList <Game>();

                foreach (Game g in usergames)
                {
                    List <TeamDescription> teamsingame = new List <TeamDescription>();

                    foreach (Team t in (from t in db.Teams
                                        where t.GameGame_ID == g.Game_ID
                                        select t))
                    {
                        TeamDescription tdesc = new TeamDescription();
                        tdesc.ID         = t.Team_ID;
                        tdesc.Intellects = new List <Guid>();

                        foreach (Intellect i in t.Intellects)
                        {
                            tdesc.Intellects.Add(i.Intellect_ID);
                        }
                    }

                    ReplayDescription replay = new ReplayDescription();

                    replay.ID    = g.Game_ID;
                    replay.Name  = g.Game_Name;
                    replay.Teams = teamsingame;

                    userreplays.Add(replay);
                }

                return(userreplays);
            }
            catch (Exception e)
            {
                return(null);
            }
        }
コード例 #4
0
        public override Task <WorkerEventResponse> RemoveTeam(TeamDescription request, ServerCallContext context)
        {
            _DbConnection.Open();
            var command    = "DELETE FROM Team WHERE TeamName = '" + request.Name + "'";
            var newCommand = new SqlCommand(command, _DbConnection);

            try
            {
                newCommand.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                _DbConnection.Close();
            }
            _DbConnection.Close();
            return(System.Threading.Tasks.Task.FromResult(new WorkerEventResponse {
                State = true, Msg = "Team deleted successfully!"
            }));
        }
コード例 #5
0
        public override Task <TeamDescription> GetDepHead(DepartmentDescription request, ServerCallContext context)
        {
            TeamDescription headDesc = new TeamDescription();

            DBConnection.Open();
            String        command    = "SELECT WorkerID, Name FROM Worker WHERE DepartmentID =" + request.Index;
            SqlCommand    newCommand = new SqlCommand(command, DBConnection);
            SqlDataReader dataReader = newCommand.ExecuteReader();

            if (dataReader.Read())
            {
                headDesc.Index = dataReader.GetInt32(0);
                headDesc.Name  = dataReader.GetString(1);
            }
            else
            {
                headDesc.Index = -1;
                headDesc.Name  = "None";
            }
            dataReader.Close();
            DBConnection.Close();
            return(System.Threading.Tasks.Task.FromResult(headDesc));
        }