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;
}
