public void LoadActiveHoliday()
{
//load active holiday to datagrid
string active = "SELECT payroll_holiday_id,payroll_holiday_name,payroll_holiday_date,payroll_holiday_category from tbl_payroll_holiday where payroll_holiday_archived=0";
payroll.FillDataGrid(active, payroll_datagrid_holiday_active);
payroll_datagrid_holiday_active.Columns["payroll_holiday_id"].Visible = false;
}
public void LoadActiveCompany()
{
//load active department to datagrid
string active = "SELECT * from tbl_payroll_department where payroll_department_archived=0";
payroll.FillDataGrid(active, payroll_department_datagrid_active);
payroll_department_datagrid_active.Columns["payroll_department_id"].Visible = false;
payroll_department_datagrid_active.Columns["payroll_department_archived"].Visible = false;
}
public void LoadActiveJob()
{
//load active job to datagrid
string active = "SELECT tbl_payroll_jobtitle.payroll_jobtitle_id, tbl_payroll_jobtitle.payroll_jobtitle_name, tbl_payroll_department.payroll_department_name, tbl_payroll_jobtitle.payroll_jobtitle_department_id from tbl_payroll_jobtitle LEFT JOIN tbl_payroll_department ON tbl_payroll_jobtitle.payroll_jobtitle_department_id = tbl_payroll_department.payroll_department_id where payroll_jobtitle_archived=0";
payroll.FillDataGrid(active, payroll_job_datagrid_active);
payroll_job_datagrid_active.Columns["payroll_jobtitle_id"].Visible = false;
payroll_job_datagrid_active.Columns["payroll_jobtitle_department_id"].Visible = false;
}
public void LoadAuditLogs(DataGridView datagrid)
{
//load auditlogs to datagrid
string auditlogs = "SELECT * from tbl_payroll_audit_logs where payroll_audit_logs_archived = 0";
payroll.FillDataGrid(auditlogs, datagrid);
datagrid.Columns["payroll_audit_logs_id"].Visible = false;
datagrid.Columns["payroll_audit_logs_archived"].Visible = false;
}
public void LoadEmployeeActive(DataGridView payroll_active_grid)
{
//load employee to datagrid
string active = "SELECT * from tbl_payroll_employee_basic";
payroll.FillDataGrid(active, payroll_active_grid);
}
public void LoadCompany(DataGridView datagrid)
{
//load company to datagrid
string company = "SELECT company.* , bank.bank_name from tbl_payroll_company as company";
company += " LEFT JOIN tbl_payroll_bank_convertion as bank";
company += " ON company.payroll_company_bank = bank.payroll_bank_convertion_id";
payroll.FillDataGrid(company, datagrid);
datagrid.Columns["payroll_company_logo"].Visible = false;
datagrid.Columns["payroll_company_id"].Visible = false;
datagrid.Columns["payroll_company_archived"].Visible = false;
datagrid.Columns["payroll_company_bank"].Visible = false;
}
