Get the total number of rows for the selected month WPF MVVM

Question

I am looking for a way to count the number of days based on the selected month from a datepicker.

The date and the id field in my model are defined as:

public Nullable<System.DateTime> Date { get; set; }

public int ID { get; set; }

 private DateTime _mDate = DateTime.Now;



    public DateTime MDate

    {



        get { return _mDate; }

        set

        {

            if (value == _mDate)

            {

                return;

            }

            else if (_selectedTabIndex == 0)

            {

                _mDate = value;

            }



            else

            {

                _mDate = value;

                OnPropertyChanged("MDate");

                SetDaysCompleted();

            }



        }



    }





private void SetDaysCompleted()

        {

         int.TryParse(MDate.ToString("MM"), out int month);

         DaysCompleted = Convert.ToDecimal(db.MyTable

.Where(a => (a.Date < MDate) && (int.TryParse(a.Date.ToString("MM"), out int smonth) == month))

.Select(a => a.ID).Count());

         }

I hoped something like this would work but I get a "No overload for method 'ToString' takes 1 arguments" error. Can someone please suggest how should I rewrite the query or if there's a better way to get the row count from the beginning of the selected month? Thank you.

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

Answer 1

I may be mistaken, but I think the issue lies here:

public Nullable<System.DateTime> Date { get; set; }  
public int ID { get; set; }

Try converting the Nullable<System.DateTime> Date to System.DateTime Date first in order to be able to use .ToString("MM") on it.

Another potential issue in your code could be : Where(a=>(a.Date < MDate). Again, if I'm understanding correctly a.Date is of type DateTime? and cannot be compared to DateTime MDate

Get the total number of rows for the selected month WPF MVVM

Sign up