❔ How to populate my IGrouping with null values??

So I have this way of grouping items, and I'm a little stuck.
I have two classes, one is the child of another. This is the model of data from the Database.

public class Hours 
{
  // Other props
  public int Month {get;set;}
  public int Year {get;set;}
  public List<Days> WorkedDays {get;set;}
}

public class Days
{
  public DateTime WorkedDay {get;set}
  // Other properties
}

public class Hours 
{
  // Other props
  public int Month {get;set;}
  public int Year {get;set;}
  public List<Days> WorkedDays {get;set;}
}

public class Days
{
  public DateTime WorkedDay {get;set}
  // Other properties
}

Now what I want to do with this data, is render it in a

<table>

<table>

(in Blazor), but grouped by week.
However, what I have now, is that it only populates the existing items, but what I want is for the table to look like the image (For <example> in the image, see second image)

Now I have the items the user has added to their

List<Days>

List<Days>

grouped by week number with the following piece of code (Thanks to someone on this server):

Hours selected = _allHours.Find(m => m.Month == (int)_selectedMonth && m.Year == _selectedYear);

var grouped = selected.WorkedDays.GroupBy(d => CultureInfo.CurrentCulture.Calendar.GetWeekOfyear(d.WorkedDay, CalendarWeekRule.FirstDay, DayOfWeek.Monday);

Hours selected = _allHours.Find(m => m.Month == (int)_selectedMonth && m.Year == _selectedYear);

var grouped = selected.WorkedDays.GroupBy(d => CultureInfo.CurrentCulture.Calendar.GetWeekOfyear(d.WorkedDay, CalendarWeekRule.FirstDay, DayOfWeek.Monday);

But what I don't know now, and why I came to you awesome guys, is to help me figure out how I am going to populate the

IEnumerable<IGrouped<int, Hours>>

IEnumerable<IGrouped<int, Hours>>

with null values for each of the Dates in my

Hours.WorkedDays

Hours.WorkedDays

(

List<Days>

List<Days>

)
And then render an empty container for the days that have "null" in them, and render the already existing items in the days of the week they belong to, but both having the option to add an item to that specific day.

And afterwards, how am I going to render the entire grouping back into a List so I can push that back into the Hours class, and update the database.

Hope my question isnt too vague..

C#•4y ago•

2 replies

malkav

❔ How to populate my IGrouping with null values??

So I have this way of grouping items, and I'm a little stuck.
I have two classes, one is the child of another. This is the model of data from the Database.

public class Hours 
{
  // Other props
  public int Month {get;set;}
  public int Year {get;set;}
  public List<Days> WorkedDays {get;set;}
}

public class Days
{
  public DateTime WorkedDay {get;set}
  // Other properties
}

public class Hours 
{
  // Other props
  public int Month {get;set;}
  public int Year {get;set;}
  public List<Days> WorkedDays {get;set;}
}

public class Days
{
  public DateTime WorkedDay {get;set}
  // Other properties
}

Now what I want to do with this data, is render it in a

<table>

<table>

List<Days>

List<Days>

grouped by week number with the following piece of code (Thanks to someone on this server):

Hours selected = _allHours.Find(m => m.Month == (int)_selectedMonth && m.Year == _selectedYear);

var grouped = selected.WorkedDays.GroupBy(d => CultureInfo.CurrentCulture.Calendar.GetWeekOfyear(d.WorkedDay, CalendarWeekRule.FirstDay, DayOfWeek.Monday);

Hours selected = _allHours.Find(m => m.Month == (int)_selectedMonth && m.Year == _selectedYear);

var grouped = selected.WorkedDays.GroupBy(d => CultureInfo.CurrentCulture.Calendar.GetWeekOfyear(d.WorkedDay, CalendarWeekRule.FirstDay, DayOfWeek.Monday);

But what I don't know now, and why I came to you awesome guys, is to help me figure out how I am going to populate the

IEnumerable<IGrouped<int, Hours>>

IEnumerable<IGrouped<int, Hours>>

with null values for each of the Dates in my

Hours.WorkedDays

Hours.WorkedDays

(

List<Days>

List<Days>

❔ How to populate my IGrouping with null values??

❔ How to populate my IGrouping with null values??

Similar Threads

Similar Threads

Similar Threads