public double GetTotalHoursByTimesheetID(Int32 TimesheetID) { TimeEntriesTotalCollection col = FetchByTimesheetID(TimesheetID); double?total = 0; foreach (TimeEntriesTotal timeentriestotal in col) { total += timeentriestotal.Totalhours; } return((double)total); }
public TimeEntriesTotalCollection FetchByTimesheetID(int TimesheetID) { TimeEntriesTotalCollection col = new TimeEntriesTotalCollection().Where(TimeEntriesTotal.Columns.Timesheetid, TimesheetID).Load(); return(col); }