/// <summary> /// Function to get all the values from Employee Table /// </summary> /// <returns></returns> public List <DataTable> EmployeeViewAll() { List <DataTable> listObj = new List <DataTable>(); try { listObj = SPEmployee.EmployeeViewAll(); } catch (Exception ex) { MessageBox.Show("EC2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(listObj); }
public DataTable EmployeeCodeComboFill() { DataTable dtblEmployeeCode = new DataTable(); try { EmployeeSP spEmployee = new EmployeeSP(); dtblEmployeeCode = spEmployee.EmployeeViewAll(); } catch (Exception ex) { } return(dtblEmployeeCode); }
/// <summary> /// Function to fill EmployeeCode Combobox /// </summary> public void EmployeeCodeComboFill() { try { EmployeeSP spEmployee = new EmployeeSP(); DataTable dtblEmployeeCode = new DataTable(); dtblEmployeeCode = spEmployee.EmployeeViewAll(); cmbEmployeeCode.DataSource = dtblEmployeeCode; cmbEmployeeCode.ValueMember = "employeeId"; cmbEmployeeCode.DisplayMember = "employeeCode"; } catch (Exception ex) { MessageBox.Show("BD1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill EmployeeCode Combobox /// </summary> public void EmployeeCodeComboFill() { try { EmployeeSP spEmployee = new EmployeeSP(); DataTable dtblEmployeeCode = new DataTable(); dtblEmployeeCode = spEmployee.EmployeeViewAll(); cmbEmployeeCode.DataSource = dtblEmployeeCode; cmbEmployeeCode.ValueMember = "employeeId"; cmbEmployeeCode.DisplayMember = "employeeCode"; } catch (Exception ex) { formMDI.infoError.ErrorString = "BD1:" + ex.Message; } }
/// <summary> /// Function to fill EmployeeCode combobox /// </summary> public void EmployeeCodeComboFill() { try { DataTable dtbl = spEmployee.EmployeeViewAll(); DataRow dr = dtbl.NewRow(); dr[3] = "All"; dtbl.Rows.InsertAt(dr, 0); cmbEmployeeCode.DataSource = dtbl; cmbEmployeeCode.ValueMember = "employeeId"; cmbEmployeeCode.DisplayMember = "employeeCode"; } catch (Exception ex) { formMDI.infoError.ErrorString = "DSR2" + ex.Message; } }
/// <summary> /// Function to fill EmployeeCode combobox /// </summary> public void EmployeeCodeComboFill() { try { DataTable dtbl = spEmployee.EmployeeViewAll(); DataRow dr = dtbl.NewRow(); dr[3] = "All"; dtbl.Rows.InsertAt(dr, 0); cmbEmployeeCode.DataSource = dtbl; cmbEmployeeCode.ValueMember = "employeeId"; cmbEmployeeCode.DisplayMember = "employeeCode"; } catch (Exception ex) { MessageBox.Show("DSR2" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill Employee combobox /// </summary> private void EmployeeComboFill() { try { EmployeeSP spEmployee = new EmployeeSP(); DataTable dtblEmployee = new DataTable(); dtblEmployee = spEmployee.EmployeeViewAll(); DataRow dr = dtblEmployee.NewRow(); dr["employeeCode"] = "All"; dtblEmployee.Rows.InsertAt(dr, 0); cmbEmployee.DataSource = dtblEmployee; cmbEmployee.DisplayMember = "employeeCode"; cmbEmployee.ValueMember = "employeeId"; } catch (Exception ex) { MessageBox.Show("DAR:2" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill employee Combobox /// </summary> private void EmployeeComboFill() { try { EmployeeSP spEmployee = new EmployeeSP(); DataTable dtblEmployee = new DataTable(); dtblEmployee = spEmployee.EmployeeViewAll(); DataRow dr = dtblEmployee.NewRow(); dr[3] = "All"; dtblEmployee.Rows.InsertAt(dr, 0); cmbEmployee.DataSource = dtblEmployee; cmbEmployee.DisplayMember = "employeeCode"; cmbEmployee.ValueMember = "employeeId"; } catch (Exception ex) { formMDI.infoError.ErrorString = "BDR:2" + ex.Message; } }