public PartialViewResult ShowStudentIndicators(string drpStudentIndicator)
        {
            try
            {
                IBIManagementService BIPService = BIPControllerBase.GetServiceProxy<IBIManagementService>();
                int indicatorId = Convert.ToInt32(drpStudentIndicator);
                int?[] degreIds;
                int?[] statusIds;

                List<DynamicHtmlTable> resultTable = new List<DynamicHtmlTable>();
                DimAcademicProgramCO academicProgramSearchCriteria = new DimAcademicProgramCO();
                DimAcademicProgramDTO[] academicProgramsArray = null;
                switch (indicatorId)
                {
                    case 1:
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.Onlisans };
                        statusIds = DefaultStatusIds();
                        resultTable = IndicatorBuilder.GetStudentIndicators(degreIds, null, statusIds, GetStudentIndicatorsDropDownMenu().SingleOrDefault(x => x.Key == 1).Value, null, true);
                        break;
                    case 2:
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.Lisans };
                        statusIds = DefaultStatusIds();
                        academicProgramSearchCriteria.AcademicUnitTypeIds = new int[] { (int)EAcademicUnitTypeId.DogaMuhendislikBilimleri};
                        academicProgramsArray = BIPService.SearchAcademicPrograms(academicProgramSearchCriteria);
                        resultTable = IndicatorBuilder.GetStudentIndicators(degreIds, academicProgramsArray.Select(x=>(int?)x.FacultyId).ToArray(), statusIds, GetStudentIndicatorsDropDownMenu().SingleOrDefault(x => x.Key == 2).Value, null, true);
                        break;
                    case 3:
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.Lisans };
                        statusIds = DefaultStatusIds();
                        academicProgramSearchCriteria.AcademicUnitTypeIds = new int[] { (int)EAcademicUnitTypeId.BeseriSosyalBilimler};
                        academicProgramsArray = BIPService.SearchAcademicPrograms(academicProgramSearchCriteria);
                        resultTable = IndicatorBuilder.GetStudentIndicators(degreIds, academicProgramsArray.Select(x => (int?)x.FacultyId).ToArray(), statusIds, GetStudentIndicatorsDropDownMenu().SingleOrDefault(x => x.Key == 3).Value, null, true);
                        break;
                    case 4:
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.Lisans };
                        statusIds = DefaultStatusIds();
                        academicProgramSearchCriteria.AcademicUnitTypeIds = new int[] { (int)EAcademicUnitTypeId.SaglikBilimleri};
                        academicProgramsArray = BIPService.SearchAcademicPrograms(academicProgramSearchCriteria);
                        resultTable = IndicatorBuilder.GetStudentIndicators(degreIds, academicProgramsArray.Select(x => (int?)x.FacultyId).ToArray(), statusIds, GetStudentIndicatorsDropDownMenu().SingleOrDefault(x => x.Key == 4).Value, null, true);
                        break;
                    case 5:
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.Lisans };
                        statusIds = DefaultStatusIds();
                        resultTable = IndicatorBuilder.GetStudentIndicators(degreIds, null, statusIds, GetStudentIndicatorsDropDownMenu().SingleOrDefault(x => x.Key == 5).Value, null, true);
                        break;
                    case 6:
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.TezsizYuksekLisans, (int)EnumEducationQualificationDegree.YuksekLisans, (int)EnumEducationQualificationDegree.Doktora };
                        statusIds = DefaultStatusIds();
                        academicProgramSearchCriteria.AcademicUnitTypeIds = new int[] { (int)EAcademicUnitTypeId.DogaMuhendislikBilimleri};
                        academicProgramsArray = BIPService.SearchAcademicPrograms(academicProgramSearchCriteria);
                        resultTable = IndicatorBuilder.GetStudentIndicators(degreIds, academicProgramsArray.Select(x => (int?)x.FacultyId).ToArray(), statusIds, GetStudentIndicatorsDropDownMenu().SingleOrDefault(x => x.Key == 6).Value, null, true);
                        break;
                    case 7:
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.TezsizYuksekLisans, (int)EnumEducationQualificationDegree.YuksekLisans, (int)EnumEducationQualificationDegree.Doktora };
                        statusIds = DefaultStatusIds();
                        academicProgramSearchCriteria.AcademicUnitTypeIds = new int[] { (int)EAcademicUnitTypeId.BeseriSosyalBilimler};
                        academicProgramsArray = BIPService.SearchAcademicPrograms(academicProgramSearchCriteria);
                        resultTable = IndicatorBuilder.GetStudentIndicators(degreIds, academicProgramsArray.Select(x => (int?)x.FacultyId).ToArray(), statusIds, GetStudentIndicatorsDropDownMenu().SingleOrDefault(x => x.Key == 7).Value, null, true);
                        break;
                    case 8:
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.TezsizYuksekLisans, (int)EnumEducationQualificationDegree.YuksekLisans, (int)EnumEducationQualificationDegree.Doktora };
                        statusIds = DefaultStatusIds();
                        academicProgramSearchCriteria.AcademicUnitTypeIds = new int[] { (int)EAcademicUnitTypeId.SaglikBilimleri};
                        academicProgramsArray = BIPService.SearchAcademicPrograms(academicProgramSearchCriteria);
                        resultTable = IndicatorBuilder.GetStudentIndicators(degreIds, academicProgramsArray.Select(x => (int?)x.FacultyId).ToArray(), statusIds, GetStudentIndicatorsDropDownMenu().SingleOrDefault(x => x.Key == 8).Value, null, true);
                        break;
                    case 9:
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.YuksekLisans };
                        statusIds = DefaultStatusIds();
                        resultTable = IndicatorBuilder.GetStudentIndicators(degreIds, null, statusIds, GetStudentIndicatorsDropDownMenu().SingleOrDefault(x => x.Key == 9).Value, null, true);
                        break;
                    case 10:
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.TezsizYuksekLisans };
                        statusIds = DefaultStatusIds();
                        resultTable = IndicatorBuilder.GetStudentIndicators(degreIds, null, statusIds, GetStudentIndicatorsDropDownMenu().SingleOrDefault(x => x.Key == 10).Value, null, true);
                        break;
                    case 11:
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.TezsizYuksekLisans, (int)EnumEducationQualificationDegree.YuksekLisans };
                        statusIds = DefaultStatusIds();
                        resultTable = IndicatorBuilder.GetStudentIndicators(degreIds, null, statusIds, GetStudentIndicatorsDropDownMenu().SingleOrDefault(x => x.Key == 11).Value, null, true);
                        break;
                    case 12:
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.Doktora };
                        statusIds = DefaultStatusIds();
                        resultTable = IndicatorBuilder.GetStudentIndicators(degreIds, null, statusIds, GetStudentIndicatorsDropDownMenu().SingleOrDefault(x => x.Key == 12).Value, null, true);
                        break;
                    case 13:
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.TezsizYuksekLisans, (int)EnumEducationQualificationDegree.YuksekLisans, (int)EnumEducationQualificationDegree.Doktora };
                        statusIds = DefaultStatusIds();
                        resultTable = IndicatorBuilder.GetStudentIndicators(degreIds, null, statusIds, GetStudentIndicatorsDropDownMenu().SingleOrDefault(x => x.Key == 13).Value, null, true);
                        break;
                    case 14:
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.TezsizYuksekLisans, (int)EnumEducationQualificationDegree.YuksekLisans, (int)EnumEducationQualificationDegree.Doktora, (int)EnumEducationQualificationDegree.Lisans, (int)EnumEducationQualificationDegree.Onlisans };
                        statusIds = DefaultStatusIds();
                        resultTable = IndicatorBuilder.GetStudentIndicators(degreIds, null, statusIds, GetStudentIndicatorsDropDownMenu().SingleOrDefault(x => x.Key == 14).Value, null, true);
                        break;
                    case 15:    //?????? BAKILACAK
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.TezsizYuksekLisans, (int)EnumEducationQualificationDegree.YuksekLisans, (int)EnumEducationQualificationDegree.Doktora, (int)EnumEducationQualificationDegree.Lisans, (int)EnumEducationQualificationDegree.Onlisans };
                        statusIds = DefaultStatusIds();
                        resultTable = IndicatorBuilder.GetStudentIndicators(degreIds, null, statusIds, GetStudentIndicatorsDropDownMenu().SingleOrDefault(x => x.Key == 15).Value, (int?)EnumCountryTypes.Turkiye, true);
                        break;
                    case 16:
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.Doktora };
                        statusIds = new int?[] { (int)EnumStudentStatus.Mezun };
                        resultTable = IndicatorBuilder.GetStudentIndicators(degreIds, null, statusIds, GetStudentIndicatorsDropDownMenu().SingleOrDefault(x => x.Key == 16).Value, null, false);
                        break;
                    case 17:
                        statusIds = new int?[] { (int)EnumStudentStatus.Mezun };
                        resultTable = IndicatorBuilder.GetStudentIndicators(null, null, statusIds, GetStudentIndicatorsDropDownMenu().SingleOrDefault(x => x.Key == 17).Value, null, false);
                        break;
                    default: break;

                }

                PartialTableModel model = new PartialTableModel();
                model.DynamicTable = resultTable;
                model.Header = GetStudentIndicatorsDropDownMenu().Where(x => x.Key == indicatorId).FirstOrDefault().Value;

                return PartialView("../Partial/_dynamictable", model);
            }
            catch (Exception ex)
            {
                return PartialView("../Partial/_dynamictable", null);
            }
        }
        public PartialViewResult ShowStudentRatios(string drpStudentRatios)
        {
            try
            {
                IBIManagementService BIPService = BIPControllerBase.GetServiceProxy<IBIManagementService>();
                DimAcademicProgramCO academicProgramSearchCriteria = new DimAcademicProgramCO();
                DimAcademicProgramDTO[] academicProgramsArray = null;
                IndicatorTableModel indicatorModel = new IndicatorTableModel();
                int indicatorId = Convert.ToInt32(drpStudentRatios);
                List<DynamicHtmlTable> resultTable = new List<DynamicHtmlTable>();
                //ConstantGroupedUnitsForLicence groupedUnitsForLicence = new ConstantGroupedUnitsForLicence();
                List<int> unitList = new List<int>();
                int?[] unvanTypeIds;
                int?[] degreIds;
                int?[] degreIds2;
                int?[] statusIds;
                switch (indicatorId)
                {
                    case 1:
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.Lisans, (int)EnumEducationQualificationDegree.Doktora, (int)EnumEducationQualificationDegree.YuksekLisans, (int)EnumEducationQualificationDegree.TezsizYuksekLisans };
                        academicProgramSearchCriteria.AcademicUnitTypeIds = new int[] { (int)EAcademicUnitTypeId.BeseriSosyalBilimler};
                        academicProgramsArray = BIPService.SearchAcademicPrograms(academicProgramSearchCriteria);
                        statusIds = DefaultStatusIds();
                        unvanTypeIds = new int?[0];
                        //int?[] unitTypes = new int?[] { (int)EnumUnitTypes.MeslekYuksekOkulu };
                        indicatorModel = IndicatorBuilder.GetStudentRatios(degreIds, academicProgramsArray.Select(x=>x.FacultyId).ToList(), unvanTypeIds, statusIds, null, null);
                        break;
                    case 2:
                        unvanTypeIds = new int?[] { (int)EnumKadroUnvanTypes.Profesor, (int)EnumKadroUnvanTypes.Docent, (int)EnumKadroUnvanTypes.YardimciDocent };
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.Lisans, (int)EnumEducationQualificationDegree.Doktora, (int)EnumEducationQualificationDegree.YuksekLisans, (int)EnumEducationQualificationDegree.TezsizYuksekLisans };
                        academicProgramSearchCriteria.AcademicUnitTypeIds = new int[] { (int)EAcademicUnitTypeId.BeseriSosyalBilimler};
                        academicProgramsArray = BIPService.SearchAcademicPrograms(academicProgramSearchCriteria);
                        statusIds = DefaultStatusIds();
                        indicatorModel = IndicatorBuilder.GetStudentRatios(degreIds, academicProgramsArray.Select(x => x.FacultyId).ToList(), unvanTypeIds, statusIds, null, null);
                        break;
                    case 3:
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.Lisans, (int)EnumEducationQualificationDegree.Doktora, (int)EnumEducationQualificationDegree.YuksekLisans, (int)EnumEducationQualificationDegree.TezsizYuksekLisans };
                         academicProgramSearchCriteria.AcademicUnitTypeIds = new int[] { (int)EAcademicUnitTypeId.DogaMuhendislikBilimleri};
                        academicProgramsArray = BIPService.SearchAcademicPrograms(academicProgramSearchCriteria);
                        statusIds = DefaultStatusIds();
                        unvanTypeIds = new int?[0];
                        //int?[] unitTypes = new int?[] { (int)EnumUnitTypes.MeslekYuksekOkulu };
                        indicatorModel = IndicatorBuilder.GetStudentRatios(degreIds, academicProgramsArray.Select(x => x.FacultyId).ToList(), unvanTypeIds, statusIds, null, null);
                        break;
                    case 4:
                        unvanTypeIds = new int?[] { (int)EnumKadroUnvanTypes.Profesor, (int)EnumKadroUnvanTypes.Docent, (int)EnumKadroUnvanTypes.YardimciDocent };
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.Lisans, (int)EnumEducationQualificationDegree.Doktora, (int)EnumEducationQualificationDegree.YuksekLisans, (int)EnumEducationQualificationDegree.TezsizYuksekLisans };
                        academicProgramSearchCriteria.AcademicUnitTypeIds = new int[] { (int)EAcademicUnitTypeId.DogaMuhendislikBilimleri};
                        academicProgramsArray = BIPService.SearchAcademicPrograms(academicProgramSearchCriteria);
                        statusIds = DefaultStatusIds();
                        indicatorModel = IndicatorBuilder.GetStudentRatios(degreIds, academicProgramsArray.Select(x => x.FacultyId).ToList(), unvanTypeIds, statusIds, null, null);
                        break;
                    case 5:
                        unvanTypeIds = new int?[] { (int)EnumKadroUnvanTypes.Profesor, (int)EnumKadroUnvanTypes.Docent, (int)EnumKadroUnvanTypes.YardimciDocent };
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.Doktora};
                        statusIds = new int?[] { (int)EnumStudentStatus.Mezun };
                        indicatorModel = IndicatorBuilder.GetStudentRatios(degreIds, null, null, statusIds, null, null);
                        break;
                    case 6:
                        unvanTypeIds = new int?[] { (int)EnumKadroUnvanTypes.Profesor, (int)EnumKadroUnvanTypes.Docent, (int)EnumKadroUnvanTypes.YardimciDocent };
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.Doktora};
                        statusIds = DefaultStatusIds();
                        indicatorModel = IndicatorBuilder.GetStudentRatios(degreIds, null, null, statusIds, null, null);
                        break;
                    case 7:
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.Doktora, (int)EnumEducationQualificationDegree.YuksekLisans, (int)EnumEducationQualificationDegree.TezsizYuksekLisans };
                        degreIds2 = new int?[] { (int)EnumEducationQualificationDegree.Lisans};
                        statusIds = DefaultStatusIds();
                        indicatorModel = IndicatorBuilder.GetStudentRatios(degreIds, degreIds2, statusIds,null);
                        break;
                    case 8:
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.Doktora, (int)EnumEducationQualificationDegree.YuksekLisans, (int)EnumEducationQualificationDegree.TezsizYuksekLisans };
                        degreIds2 = new int?[] { (int)EnumEducationQualificationDegree.Doktora, (int)EnumEducationQualificationDegree.YuksekLisans, (int)EnumEducationQualificationDegree.TezsizYuksekLisans, (int)EnumEducationQualificationDegree.Onlisans, (int)EnumEducationQualificationDegree.Lisans };
                        statusIds = DefaultStatusIds();
                        indicatorModel = IndicatorBuilder.GetStudentRatios(degreIds, degreIds2, statusIds,null);
                        break;
                    case 9:
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.Doktora, (int)EnumEducationQualificationDegree.YuksekLisans, (int)EnumEducationQualificationDegree.TezsizYuksekLisans, (int)EnumEducationQualificationDegree.Onlisans, (int)EnumEducationQualificationDegree.Lisans };
                        statusIds = DefaultStatusIds();
                        indicatorModel = IndicatorBuilder.GetStudentRatios(degreIds, unitList, null, statusIds, null, null);
                        break;
                    case 10:
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.Onlisans};
                        statusIds = DefaultStatusIds();
                        indicatorModel = IndicatorBuilder.GetStudentRatios(degreIds, unitList, null, statusIds, null, null);
                        break;
                    case 11:
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.Lisans, (int)EnumEducationQualificationDegree.Doktora, (int)EnumEducationQualificationDegree.YuksekLisans, (int)EnumEducationQualificationDegree.TezsizYuksekLisans };
                         academicProgramSearchCriteria.AcademicUnitTypeIds = new int[] { (int)EAcademicUnitTypeId.SaglikBilimleri};
                        academicProgramsArray = BIPService.SearchAcademicPrograms(academicProgramSearchCriteria);
                        statusIds = DefaultStatusIds();
                        unvanTypeIds = new int?[0];
                        indicatorModel = IndicatorBuilder.GetStudentRatios(degreIds, academicProgramsArray.Select(x => x.FacultyId).ToList(), unvanTypeIds, statusIds, null, null);
                        break;
                    case 12:
                        unvanTypeIds = new int?[] { (int)EnumKadroUnvanTypes.Profesor, (int)EnumKadroUnvanTypes.Docent, (int)EnumKadroUnvanTypes.YardimciDocent };
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.Lisans, (int)EnumEducationQualificationDegree.Doktora, (int)EnumEducationQualificationDegree.YuksekLisans, (int)EnumEducationQualificationDegree.TezsizYuksekLisans };
                         academicProgramSearchCriteria.AcademicUnitTypeIds = new int[] { (int)EAcademicUnitTypeId.DogaMuhendislikBilimleri};
                        academicProgramsArray = BIPService.SearchAcademicPrograms(academicProgramSearchCriteria);
                        statusIds = DefaultStatusIds();
                        indicatorModel = IndicatorBuilder.GetStudentRatios(degreIds, academicProgramsArray.Select(x => x.FacultyId).ToList(), unvanTypeIds, statusIds, null, null);
                        break;
                    case 13:
                        degreIds = new int?[] { (int)EnumEducationQualificationDegree.Doktora, (int)EnumEducationQualificationDegree.YuksekLisans, (int)EnumEducationQualificationDegree.TezsizYuksekLisans, (int)EnumEducationQualificationDegree.Onlisans, (int)EnumEducationQualificationDegree.Lisans };
                        degreIds2 = new int?[] { (int)EnumEducationQualificationDegree.Doktora, (int)EnumEducationQualificationDegree.YuksekLisans, (int)EnumEducationQualificationDegree.TezsizYuksekLisans, (int)EnumEducationQualificationDegree.Onlisans, (int)EnumEducationQualificationDegree.Lisans };
                        statusIds = DefaultStatusIds();
                        indicatorModel = IndicatorBuilder.GetStudentRatios(degreIds, degreIds2, statusIds, (int)EnumCountryTypes.Turkiye);
                        break;
                    //case 14:
                    //    resultTable = IndicatorBuilder.GetOfficerIndicators("İDARİ", null, null, null);
                    //    break;
                    default: break;

                }

                StudentRatiosModel model = new StudentRatiosModel();
                model.IndicatorTable = indicatorModel;
                model.Header = GetStudentRatiosDropDownMenu().Where(x => x.Key == indicatorId).FirstOrDefault().Value;
                return PartialView("../Partial/_indicatorTable", model);
            }
            catch (Exception ex)
            {
                return PartialView("../Partial/_indicatorTable", null);
            }
        }
        public PartialViewResult ShowOfficerIndicators(string drpOfficerIndicator)
        {
            try
            {
                IBIManagementService BIPService = BIPControllerBase.GetServiceProxy<IBIManagementService>();
                int indicatorId = Convert.ToInt32(drpOfficerIndicator);
                List<DynamicHtmlTable> resultTable = new List<DynamicHtmlTable>();

                List<int> unitList = new List<int>();
                int?[] unvanTypeIds;
                DimAcademicProgramCO academicProgramSearchCriteria = new DimAcademicProgramCO();
                DimAcademicProgramDTO[] academicProgramsArray = null;
                switch (indicatorId)
                {
                    case 1:
                        int?[] unitTypes = new int?[] { (int)EnumUnitTypes.MeslekYuksekOkulu };
                        resultTable = IndicatorBuilder.GetOfficerIndicators("AKADEMİK", unitTypes, null, null);
                        break;
                    case 2:
                        unvanTypeIds = new int?[] { (int)EnumKadroUnvanTypes.Profesor, (int)EnumKadroUnvanTypes.Docent, (int)EnumKadroUnvanTypes.YardimciDocent };
                        academicProgramSearchCriteria.AcademicUnitTypeIds = new int[] { (int)EAcademicUnitTypeId.DogaMuhendislikBilimleri };
                        academicProgramsArray = BIPService.SearchAcademicPrograms(academicProgramSearchCriteria);
                        resultTable = IndicatorBuilder.GetOfficerIndicators("AKADEMİK", null, academicProgramsArray.Select(x => (int?)x.FacultyId).ToArray(), unvanTypeIds);
                        break;
                    case 3:  //?? .............bakılacak..............
                        unvanTypeIds = new int?[] { (int)EnumKadroUnvanTypes.ArastirmaGorevlisi };
                        academicProgramSearchCriteria.AcademicUnitTypeIds = new int[] { (int)EAcademicUnitTypeId.DogaMuhendislikBilimleri};
                        academicProgramsArray = BIPService.SearchAcademicPrograms(academicProgramSearchCriteria);
                        resultTable = IndicatorBuilder.GetOfficerIndicators("AKADEMİK", null, academicProgramsArray.Select(x => (int?)x.FacultyId).ToArray(), unvanTypeIds);
                        break;
                    case 4:
                        unvanTypeIds = new int?[] { (int)EnumKadroUnvanTypes.Profesor, (int)EnumKadroUnvanTypes.Docent, (int)EnumKadroUnvanTypes.YardimciDocent };
                        academicProgramSearchCriteria.AcademicUnitTypeIds = new int[] { (int)EAcademicUnitTypeId.BeseriSosyalBilimler};
                        academicProgramsArray = BIPService.SearchAcademicPrograms(academicProgramSearchCriteria);
                        resultTable = IndicatorBuilder.GetOfficerIndicators("AKADEMİK", null, academicProgramsArray.Select(x => (int?)x.FacultyId).ToArray(), unvanTypeIds);
                        break;
                    case 5:  //?? .............bakılacak..............
                        unvanTypeIds = new int?[] { (int)EnumKadroUnvanTypes.ArastirmaGorevlisi };
                        academicProgramSearchCriteria.AcademicUnitTypeIds = new int[] { (int)EAcademicUnitTypeId.BeseriSosyalBilimler };
                        academicProgramsArray = BIPService.SearchAcademicPrograms(academicProgramSearchCriteria);

                        resultTable = IndicatorBuilder.GetOfficerIndicators("AKADEMİK", null, academicProgramsArray.Select(x => (int?)x.FacultyId).ToArray(), unvanTypeIds);
                        break;
                    case 6:
                        unvanTypeIds = new int?[] { (int)EnumKadroUnvanTypes.Profesor, (int)EnumKadroUnvanTypes.Docent, (int)EnumKadroUnvanTypes.YardimciDocent };
                        academicProgramSearchCriteria.AcademicUnitTypeIds = new int[] { (int)EAcademicUnitTypeId.SaglikBilimleri};
                        academicProgramsArray = BIPService.SearchAcademicPrograms(academicProgramSearchCriteria);
                        resultTable = IndicatorBuilder.GetOfficerIndicators("AKADEMİK", null, academicProgramsArray.Select(x => (int?)x.FacultyId).ToArray(), unvanTypeIds);
                        break;
                    case 7:  //?? .............bakılacak..............
                        unvanTypeIds = new int?[] { (int)EnumKadroUnvanTypes.ArastirmaGorevlisi };
                        academicProgramSearchCriteria.AcademicUnitTypeIds = new int[] { (int)EAcademicUnitTypeId.SaglikBilimleri};
                        academicProgramsArray = BIPService.SearchAcademicPrograms(academicProgramSearchCriteria);
                        resultTable = IndicatorBuilder.GetOfficerIndicators("AKADEMİK", null, academicProgramsArray.Select(x => (int?)x.FacultyId).ToArray(), unvanTypeIds);
                        break;
                    case 8:  //?? .............bakılacak..............
                        unvanTypeIds = new int?[] { (int)EnumKadroUnvanTypes.Profesor, (int)EnumKadroUnvanTypes.Docent, (int)EnumKadroUnvanTypes.YardimciDocent };
                        resultTable = IndicatorBuilder.GetOfficerIndicators("AKADEMİK", null, null, unvanTypeIds);
                        break;
                    case 9:  //?? .............bakılacak..............
                        resultTable = IndicatorBuilder.GetOfficerIndicators("AKADEMİK", null, null, null);
                        break;
                    case 10:
                        resultTable = IndicatorBuilder.GetOfficerIndicators("İDARİ", null, null, null);
                        break;
                    default: break;

                }

                PartialTableModel model = new PartialTableModel();
                model.DynamicTable = resultTable;
                model.Header = GetOfficersIndicatorsDropDownMenu().Where(x => x.Key == indicatorId).FirstOrDefault().Value;

                return PartialView("../Partial/_dynamictable", model);
            }
            catch (Exception ex)
            {
                return PartialView("../Partial/_dynamictable", null);
            }
        }