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