Column contains null data in asp.net mvc

Question

I am getting the data for the current month. For site.ID=4 there is no data in the backend. I am getting the column contains no data exception. How can I resolve this issue?

List<ManHourReport> manHoursReports = new List<ManHourReport>();
var sites = context.JocSites.Where(j => j.JOCid == jocID).ToList();
    foreach (var site in sites)
    {
       double manPowermonthly = context.ManHoursWorked.
              Where(s => s.SiteID == site.ID && s.Date.Month==DateTime.Now.Month).
              Sum(m => m.NumOfLabourForJOC); // here for the site.ID=4, there is no data in the backend. I am getting the error.
       double manHoursMonthly = context.ManHoursWorked.
              Where(s => s.SiteID == site.ID && s.Date.Month == DateTime.Now.Month).
              Sum(m => m.NumOfWorkingHoursJOC);
       double manHoursYearly = context.ManHoursWorked.
              Where(s => s.SiteID == site.ID && s.Date.Year == DateTime.Now.Year).
              Sum(m => m.NumOfWorkingHoursJOC);
                manHoursReports.Add(new ManHourReport()
                {
                    SiteManPower = manPowermonthly,
                    SiteManHourMonthly = manHoursMonthly,
                    SiteManHourYearly = manHoursYearly
                });
    }

You should check if context.ManHoursWorked.Where(...) return any value before trying to SUM values. — jpgrassi
– jpgrassi, Commented Jan 15, 2016 at 14:04

Steve Greene · Accepted Answer · 2016-01-15 14:20:38Z

4

Use DefaultIfEmpty after projecting the field you want to sum:

double manPowermonthly = context.ManHoursWorked
    .Where(s => s.SiteID == site.ID && s.Date.Month==DateTime.Now.Month)
    .Select(s => s.NumOfLabourForJOC)
    .DefaultIfEmpty(0)
    .Sum();

https://coding.abel.nu/2012/08/null-sematics-in-linqs-sum/

answered Jan 15, 2016 at 14:20

Steve Greene

12.4k2 gold badges36 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Column contains null data in asp.net mvc

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related