public ConsultantDashboard() { // populate some dummy data test test this.dates = new TimeSlipDates(System.DateTime.Parse("5/14/2017")); this.vacation_days_available = 15; this.vacation_days_remaining = 13; this.hours_this_week = 38; this.hours_last_week = 41; this.hours_mtd = 63; this.hours_last_month = 161; }
// Constructors public ConsultantDashboard(int consultant_id) { this.dates = new TimeSlipDates(System.DateTime.Now); meradia_db db = new meradia_db(); // get vacation days available for the current year this.vacation_days_available = ( db.consultants.Where(c => c.ID == consultant_id). Select(c => c.vacation_available).First()) ?? 0M; this.vacation_days_remaining = CalcVacationDaysRemaining(consultant_id, db); this.hours_this_week = SumHours(db, consultant_id, dates.this_week_start_dt, dates.this_week_end_dt); this.hours_last_week = SumHours(db, consultant_id, dates.last_week_start_dt, dates.last_week_end_dt); this.hours_mtd = SumHours(db, consultant_id, dates.mtd_start_dt, dates.mtd_end_dt); this.hours_last_month = SumHours(db, consultant_id, dates.last_month_start_dt, dates.last_month_end_dt); }