How can i create a Dropdownlist in C# - MVC3 with all Month

Thanks Philippe,

now i have only one problem how i connect that with the startdate and enddate of the datagrid = table output.

DateTime startdate = DateTime.Today.AddDays((DateTime.Today.Day - 1) * -1);
DateTime enddate = startdate.AddMonths(1).AddDays(-1);

With the DropdownList i want choose the Month of the Table Output of all Database Entries from the selected month.

I think that i have to change the "1" of AddMonth(1) to a parameter with that i get a reference to MonthList Function, but how can i get this?

The second problem in this combination is the startdate.

Thank you!

Well you can filter months in AllMonths property with something like that (assuming that you only want to handle calendars with 12 months each year) :

int startYear = startdate.Year;
int startMonth = startdate.Month;

int index = 1;
foreach (var monthName in info.DateTimeFormat.MonthNames)
{
    var testYear = index < startMonth ? startYear + 1 : startYear
    var testDate = new DateTime(testYear, index, 1);
    
    if (testDate >= startDate && testDate < enddate)
    {
        yield return new MonthInfo { Index = index, MonthName = monthName };
    }
    ++index;
}

You will have to remove static modifier and store start and end date in your model.

Thanks :)

Now i did entered the data such as follow.

My ViewModel:

// MonthList-Model for Dropdownlist
        public int? SelectedMonth;

        public SelectList MonthList
        {
            get
            {
                return new SelectList(AllMonths, "Index", "Name", SelectedMonth);
            }
        }
        public IEnumerable<MonthInfo> AllMonths
        {
            get
            {
                CultureInfo info =
                    System.Threading.Thread.CurrentThread.CurrentCulture;

                var today = DateTime.Today;

                DateTime startDate = new DateTime(today.Year, today.Month, 1);
                DateTime endDate = startDate.AddMonths(1).AddDays(-1);

                int startYear = startDate.Year;
                int startMonth = startDate.Month;
                 
                int index = 1;
                foreach (var monthName in info.DateTimeFormat.MonthNames)
                {
                    var testYear = index < startMonth ? startYear + 1 : startYear;
                    var testDate = new DateTime(testYear, index, 1);
    
                    if (testDate >= startDate && testDate < endDate)
                    {
                        yield return new MonthInfo { Index = index, Name = monthName };
                    }
                    ++index;
                }

            }
        }

        public class MonthInfo
        {
            public int Index { get; set; }
            public string Name { get; set; }
        }

         //---- End DropdownList

My Controller:

public ActionResult Index()
{

    //DateTime startdate = DateTime.Today.AddDays((DateTime.Today.Day - 1) * -1);
    //DateTime enddate = startdate.AddMonths(1).AddDays(-1);
    var data = new RosterIndexViewModel(startYear, startMonth);
    //var data = new RosterIndexViewModel(startdate.Year, startdate.Month);
    data.GridRows = (from e in db.EmployeeSet
                     select new RosterGridRow() { Employee = e }).ToList();
    // Load Rosterentries for selected Month
    foreach (var gr in data.GridRows)
    {
        gr.RosterEntries = (from r in db.RosterSet
                            where r.EmployeeId == gr.Employee.Id
                                && r.RosterDate >= startDate && r.RosterDate <= endDate
                            select r).ToList();
    }
    return View(data);

In my Controller i get four error messages now, that the Names of "startMonth", "startYear", "startDate" and "endDate" aren't be in the current Context.

With the using .....Models.ViewModels; i get no solution.

Hello Phillippe,

at the moment i stay on the line. Please can you make me a suggestion please?

I have changed now following steps:

RosterIndexViewModel.ccs - File:

namespace RosterManagementSystemWeb.Models.ViewModels
{
    public class RosterIndexViewModel
    {
        public RosterIndexViewModel(int year, int month)
        {
            DaysofMonth = new List<DateTime>();
            var d = new DateTime(year, month, 1);
            while (d.Month == month)
            {
                DaysofMonth.Add(d);
                d = d.AddDays(1);
            }
        }

        public class MonthListView
        {
            // MonthList-Model for Dropdownlist
            public int? SelectedMonth;
            public SelectList MonthList
            {
                get
                {
                    return new SelectList(AllMonths, "Index", "Name", SelectedMonth);
                }
            }
            public IEnumerable<MonthInfo> AllMonths
            {
                get
                {
                    CultureInfo info =
                        System.Threading.Thread.CurrentThread.CurrentCulture;
                    var today = DateTime.Today;
                    DateTime startDate = new DateTime(today.Year, today.Month, 1);
                    DateTime endDate = startDate.AddMonths(1).AddDays(-1);
                    int startYear = startDate.Year;
                    int startMonth = startDate.Month;
                    int index = 1;
                    foreach (var monthName in info.DateTimeFormat.MonthNames)
                    {
                        var testYear = index < startMonth ? startYear + 1 : startYear;
                        var testDate = new DateTime(testYear, index, 1);
                        if (testDate >= startDate && testDate < endDate)
                        {
                            yield return new MonthInfo { Index = index, Name = monthName };
                        }
                        ++index;
                    }
                }
            }
            public class MonthInfo
            {
                public int Index { get; set; }
                public string Name { get; set; }

            }
        }
    }
    public class RosterGridRow
    {
        public Employee Employee { get; set; }
        public IEnumerable<Roster> RosterEntries { get; set; }
        public RosterGridRow()
        {
            RosterEntries = new List<Roster>();
        }
    }
}

RosterController.cs - File:

namespace RosterManagementSystemWeb.Controllers
{

    public class RosterController : Controller
    {
        private RosterDb db = new RosterDb();

        //
        // GET: /Roster/

        public ActionResult Index()
        {
            
            
            
            //DateTime startdate = DateTime.Today.AddDays((DateTime.Today.Day - 1) * -1);
            //DateTime enddate = startdate.AddMonths(1).AddDays(-1);



            var data = new RosterIndexViewModel(2011, 8);

            //var data = new RosterIndexViewModel(startdate.Year, startdate.Month);
            data.GridRows = (from e in db.EmployeeSet
                             select new RosterGridRow() { Employee = e }).ToList();

            // Load Rosterentries for selected Month
            foreach (var gr in data.GridRows)
            {
                gr.RosterEntries = (from r in db.RosterSet
                                    where r.EmployeeId == gr.Employee.Id
                                        && r.RosterDate >= startDate && r.RosterDate <= endDate
                                    select r).ToList();
            }

            return View(data);
        }

In the RosterController.cs on the line -> public RosterIndexViewModel(int year, int month), i'm not sure how can i get the right result.

I hope you can helo otherwise i must wait until to Thursday that help me my Trainer.

Thank you :)

While surfing i have found one link this may help you

http://www.dotnetpools.com/2012/10/binding-dropdownlist-in-mvc3-using-c.html[^]