/// <summary> /// Function to get particular values from employee table for payslip /// </summary> /// <returns></returns> public List <DataTable> EmployeeViewForPaySlip() { List <DataTable> listObj = new List <DataTable>(); try { listObj = SPEmployee.EmployeeViewForPaySlip(); } catch (Exception ex) { MessageBox.Show("EC18:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(listObj); }
/// <summary> /// Function to fill Employee combobox /// </summary> public void FillEmployee() { try { DataTable dtbl = new DataTable(); EmployeeSP spEmployee = new EmployeeSP(); dtbl = spEmployee.EmployeeViewForPaySlip(); DataRow dr = dtbl.NewRow(); dr[1] = "--Select--"; dtbl.Rows.InsertAt(dr, 0); cmbEmployee.DataSource = dtbl; cmbEmployee.ValueMember = "employeeId"; cmbEmployee.DisplayMember = "employeeName"; } catch (Exception ex) { formMDI.infoError.ErrorString = "PS1:" + ex.Message; } }
public DataTable FillEmployee() { DataTable dtbl = new DataTable(); try { EmployeeSP spEmployee = new EmployeeSP(); dtbl = spEmployee.EmployeeViewForPaySlip(); DataRow dr = dtbl.NewRow(); dr[0] = "0"; dr[1] = "--Select--"; dtbl.Rows.InsertAt(dr, 0); return(dtbl); } catch (Exception ex) { return(null); } }
/// <summary> /// Function to fill Employee combobox /// </summary> public void FillEmployee() { try { DataTable dtbl = new DataTable(); EmployeeSP spEmployee = new EmployeeSP(); dtbl = spEmployee.EmployeeViewForPaySlip(); DataRow dr = dtbl.NewRow(); dr[1] = "--Select--"; dtbl.Rows.InsertAt(dr, 0); cmbEmployee.DataSource = dtbl; cmbEmployee.ValueMember = "employeeId"; cmbEmployee.DisplayMember = "employeeName"; } catch (Exception ex) { MessageBox.Show("PS 1: " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }