}//GetTrainingsRatio()

                public Ratio GetAssignmentsRatio(string project)
                {
                    List<AdvancedTask> trainingsList = new Selector(Constants.DatabaseValues.PROJECT_PATH).SelectAssignments(project);

                        int done = 0;
                        int total = 0;

                        foreach (AdvancedTask item in trainingsList)
                        {
                                if (item._state == States.DONE)
                                {
                                        done++;
                                }

                                total++;
                        }

                        return new Ratio(done, total);
                }//GetAssignmentsRatio()
                private double GetProjectsD()
                {
                        foreach (string project in _projectsList)
                        {
                                int numberOfTasks = 0;
                                bool isFinished = true;
                                List<AdvancedTask> workinList = new Selector(Paths.PROJECTS_SAVE).SelectTrainings(project);

                                foreach (AdvancedTask item in workinList)
                                {
                                        if(item._state == States.OPEN || item._state == States.PROGRESS)
                                        {
                                                isFinished = false;
                                                break;
                                        }
                                        numberOfTasks++;
                                }

                                if(isFinished)
                                {
                                        workinList = new Selector(Paths.PROJECTS_SAVE).SelectAssignments(project);

                                        foreach (AdvancedTask item in workinList)
                                        {
                                                if (item._state == States.OPEN || item._state == States.PROGRESS)
                                                {
                                                        isFinished = false;
                                                        break;
                                                }
                                                numberOfTasks++;
                                        }
                                }

                                if (isFinished)
                                {
                                        workinList = new Selector(Paths.PROJECTS_SAVE).SelectMaintenances(project);

                                        foreach (AdvancedTask item in workinList)
                                        {
                                                if (item._state == States.OPEN || item._state == States.PROGRESS)
                                                {
                                                        isFinished = false;
                                                        break;
                                                }
                                                numberOfTasks++;
                                        }
                                }

                                if(isFinished && numberOfTasks >0)
                                {
                                        _projectsDNB++;
                                }
                        }

                        return _projectsDNB;
                }//ctor()