public virtual ActionResult Index()
        {
            SupervisionPorfolioModel ModelSupervisionPorfolio = new SupervisionPorfolioModel();

            var ListCountryDepartment      = ClientGenericRepositoty.GetCountryDepartments(Globals.NeutralLanguage);
            var ListSectorDepartment       = ClientGenericRepositoty.GetSectorDepartment(Globals.NeutralLanguage);
            var ListCountry                = ClientGenericRepositoty.GetCountries(Globals.NeutralLanguage);
            var ListDivision               = ClientGenericRepositoty.GetDivisions(Globals.NeutralLanguage);
            var ListValidationStageSupPlan = ClientGenericRepositoty.GetStatesForSupervisionReport();
            var ListESG_Tracking           = new Dictionary <bool, string>();

            ListESG_Tracking.Add(true, Localization.GetText("Yes"));
            ListESG_Tracking.Add(false, Localization.GetText("No"));
            var YearsSupervision = ClientGenericRepositoty.GetMaxAndMinYearSupervisionPlanReport();
            var ListYears        = new Dictionary <int, int>();

            ModelSupervisionPorfolio.StartYear = YearsSupervision["MinYear"];
            ModelSupervisionPorfolio.EndYear   = YearsSupervision["MaxYear"];

            for (int x = ModelSupervisionPorfolio.StartYear; x <= ModelSupervisionPorfolio.EndYear; x++)
            {
                ListYears.Add(x, x);
            }

            ViewBag.ListCountryDepartment      = new MultiSelectList(ListCountryDepartment, "ConvergenceMasterDataId", "Name");
            ViewBag.ListSectorDepartment       = new MultiSelectList(ListSectorDepartment, "ConvergenceMasterDataId", "Name");
            ViewBag.ListCountry                = new MultiSelectList(ListCountry, "ConvergenceMasterDataId", "Name");
            ViewBag.ListDivision               = new MultiSelectList(ListDivision, "ConvergenceMasterDataId", "Name");
            ViewBag.ListValidationStageSupPlan = new SelectList(ListValidationStageSupPlan, "ConvergenceMasterDataId", "Name");
            ViewBag.ListESG_Tracking           = new SelectList(ListESG_Tracking, "Key", "Value");
            ViewBag.ListStartYear              = new SelectList(ListYears, "Key", "Value");
            ViewBag.ListEndYear                = new SelectList(ListYears.OrderByDescending(x => x.Key).ToList(), "Key", "Value");

            return(View(ModelSupervisionPorfolio));
        }
        public virtual ActionResult Index(SupervisionPorfolioModel ModelSupervisionPorfolio)
        {
            var ListCountryDepartment      = ClientGenericRepositoty.GetCountryDepartments(Globals.NeutralLanguage);
            var ListSectorDepartment       = ClientGenericRepositoty.GetSectorDepartment(Globals.NeutralLanguage);
            var ListCountry                = ClientGenericRepositoty.GetCountries(Globals.NeutralLanguage);
            var ListDivision               = ClientGenericRepositoty.GetDivisions(Globals.NeutralLanguage);
            var ListValidationStageSupPlan = ClientGenericRepositoty.GetStatesForSupervisionReport();
            var ListESG_Tracking           = new Dictionary <bool, string>();

            ListESG_Tracking.Add(true, Localization.GetText("Yes"));
            ListESG_Tracking.Add(false, Localization.GetText("No"));
            var YearsSupervision = ClientGenericRepositoty.GetMaxAndMinYearSupervisionPlanReport();
            var ListYears        = new Dictionary <int, int>();

            var startYear = YearsSupervision["MinYear"];
            var endYear   = YearsSupervision["MaxYear"];

            for (int x = startYear; x <= endYear; x++)
            {
                ListYears.Add(x, x);
            }

            ViewBag.ListCountryDepartment      = new MultiSelectList(ListCountryDepartment, "ConvergenceMasterDataId", "Name");
            ViewBag.ListSectorDepartment       = new MultiSelectList(ListSectorDepartment, "ConvergenceMasterDataId", "Name");
            ViewBag.ListCountry                = new MultiSelectList(ListCountry, "ConvergenceMasterDataId", "Name");
            ViewBag.ListDivision               = new MultiSelectList(ListDivision, "ConvergenceMasterDataId", "Name");
            ViewBag.ListValidationStageSupPlan = new SelectList(ListValidationStageSupPlan, "ConvergenceMasterDataId", "Name");
            ViewBag.ListESG_Tracking           = new SelectList(ListESG_Tracking, "Key", "Value");
            ViewBag.ListStartYear              = new SelectList(ListYears, "Key", "Value");
            ViewBag.ListEndYear                = new SelectList(ListYears.OrderByDescending(x => x.Key).ToList(), "Key", "Value");

            string lang = string.Empty;

            if (!string.IsNullOrEmpty(IDBContext.Current.CurrentLanguage))
            {
                lang = IDBContext.Current.CurrentLanguage.ToUpper();
            }
            else
            {
                lang = Globals.NeutralLanguage.ToUpper();
            }

            var SupervisionResults = _ClientGenericRepositoty.GetSupervisionPlanresults(ModelSupervisionPorfolio, lang);

            ModelSupervisionPorfolio.ListSupervionResults.AddRange(SupervisionResults);

            return(View(ModelSupervisionPorfolio));
        }