public void PopulateTimesheet(DataGridView dg) { PayrollQuery pq = new PayrollQuery(); DateTime dateInc = StartDate; dg.Rows.Clear(); for (int i = 0; i <= (EndDate - StartDate).Days; i++) { string clockIn; string clockOut; string shift; try { clockIn = pq.GetTimesheetInfo(UserId, dateInc)[0].CLockInTime.ToString(); } catch (Exception) { clockIn = "---"; } try { clockOut = pq.GetTimesheetInfo(UserId, dateInc)[0].ClockOutTime.ToString(); } catch (Exception) { clockOut = "---"; } try { shift = pq.GetScheduleInfo(UserId, dateInc)[0].Shift; } catch (Exception) { shift = "OFF"; } dg.Rows.Add(dateInc.ToString().Substring(0, 10), dateInc.DayOfWeek, shift, clockIn, clockOut); dateInc = dateInc.AddDays(1); } }
void CalculatePay() { PayrollQuery pq = new PayrollQuery(); DateTime date = DateStart; decimal hours; for (int i = 0; i < (DateEnd - DateStart).Days; i++) { try { hours = pq.GetTimesheetInfo(UserId, date)[0].TotalHours; } catch (Exception e) { hours = 0; } TotalHours += hours; date = date.AddDays(1); } TotalPay = TotalHours * PayRate; }