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