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