/// <summary> /// Receive the Promoter Id and returns a Select /// list with Years that have an "Product Order" in database /// </summary> /// <param name="idPromoter"></param> /// <returns></returns> public List<SelectListItem> GetYearsSelectListItem(int idPromoter) { var commissions = new Commissions().SelectFiltered(Settings.AutenticationKeyEarningSystem, null, null, idPromoter); var firstDateCommission = new DateTime(); var lastDateCommission = new DateTime(); var firstOrDefault = commissions.FirstOrDefault(); if (firstOrDefault != null) { if (firstOrDefault.DataPedido != null) firstDateCommission = firstOrDefault.DataPedido.Value; } var lastOrDefault = commissions.LastOrDefault(); if (lastOrDefault != null) { if (lastOrDefault.DataPedido != null) lastDateCommission = lastOrDefault.DataPedido.Value; } var firstYear = firstDateCommission.Year; var lastYear = lastDateCommission.Year; var listYear = new List<Int32>(); for (var i = firstYear; i <= lastYear; i++) { listYear.Add(i); } return listYear.Select(item => new SelectListItem { Text = item.ToString(CultureInfo.InvariantCulture), Value = item.ToString(CultureInfo.InvariantCulture) }).ToList(); }