public Task GeneratePayroll(PayrollFilter payrollFilter)
{
throw new System.NotImplementedException();
}
public void PayrollExportXlxs(DateTime targetDate, bool commit, PayrollFilter filter, out GridViewSettings gridViewSettings, out IEnumerable <PayrollGridItemVM> data)
{
data = HoursRepository.GetPayablesByPeriod(new DateTime(targetDate.Year, targetDate.Month, 1), filter);
gridViewSettings = new GridViewSettings
{
Name = "gvPayrollOverviewGrid",
KeyFieldName = "ID"
};
gridViewSettings.SettingsBehavior.AllowSort = false;
gridViewSettings.SettingsBehavior.AllowGroup = false;
gridViewSettings.SettingsBehavior.AllowFocusedRow = false;
gridViewSettings.SettingsBehavior.AllowSelectSingleRowOnly = true;
gridViewSettings.Settings.ShowFilterRow = false;
gridViewSettings.CallbackRouteValues = new { Action = "PayrollGridCallback" };
gridViewSettings.SettingsExport.ExportSelectedRowsOnly = false;
gridViewSettings.SettingsExport.FileName = "Payables_" + DateTime.Now.ToString("yyyy-MM-dd") + ".xlsx";
gridViewSettings.Columns.Add(col =>
{
col.Name = "PayrollID";
col.FieldName = "PayrollID";
col.Caption = "PayrollID";
});
gridViewSettings.Columns.Add(col =>
{
col.Name = "colFirstName";
col.FieldName = "FirstName";
col.Caption = "First Name";
});
gridViewSettings.Columns.Add(col =>
{
col.Name = "colLastName";
col.FieldName = "LastName";
col.Caption = "Last Name";
});
gridViewSettings.Columns.Add(col =>
{
col.Name = "colHours";
col.FieldName = "Hours";
col.Caption = "Hours";
col.Width = 80;
});
gridViewSettings.Columns.Add(col =>
{
col.Name = "colEntriesMissingCatalystData";
col.FieldName = "EntriesMissingCatalystData";
col.Caption = "Entries Missing Catalyst Data";
});
try
{
if (commit)
{
ReportService.GeneratePayrollReport(targetDate, filter);
}
return;
}
catch (Exception e)
{
Exceptions.Handle(e, Global.GetWebInfo());
throw e;
}
}
