public SqlDataReader getEmployeeCode1(string strEmployeeName)
{
DLEmployee dlsr = new DLEmployee();
try
{
SqlDataReader dr = dlsr.getEmployeeCode1(strEmployeeName);
return dr;
}
catch
{
throw;
}
finally
{
dlsr = null;
}
}
public SqlDataReader getEmployeeName1()
{
DLEmployee dlc = new DLEmployee();
try
{
SqlDataReader dr = dlc.getEmployeeName1();
return dr;
}
catch
{
throw;
}
finally
{
//dlc = null;
}
}
public SqlDataReader getEmpDetailsForUpdate1(int intEmployeeID)
{
DLEmployee dlsr = new DLEmployee();
try
{
SqlDataReader dr = dlsr.getEmpDetailsForUpdate1(intEmployeeID);
return dr;
}
catch
{
throw;
}
finally
{
dlsr = null;
}
}
public void updateEmployee1(int intEmployeeID, string strAddress1, string strAddress2, string strAddress3, string strPAN, string strBankName, string strBankAddress, string strAccountNo, string strBranch, string strDesignation, int intIsDeleted, string strMobile, string strTelephone, string strEmailID, int intApprove)
{
DLEmployee dlc = new DLEmployee();
try
{
dlc.updateEmployee1( intEmployeeID, strAddress1, strAddress2, strAddress3, strPAN, strBankName, strBankAddress, strAccountNo, strBranch, strDesignation, intIsDeleted, strMobile, strTelephone, strEmailID, intApprove);
}
catch
{
throw;
}
finally
{
dlc = null;
}
}
public string saveEmployee1(string strEmployeeName, string strEmployeeCode, string strAddress1, string strAddress2, string strAddress3, string strPAN, string strBankName, string strBankAddress, string strAccountNo, string strBranch, string strDesignation, int intIsDeleted, string strMobile, string strTelephone, string strEmailID, int intApprove)
{
DLEmployee dle = new DLEmployee();
try
{
msg = dle.saveEmployee1(strEmployeeName, strEmployeeCode, strAddress1, strAddress2, strAddress3, strPAN, strBankName, strBankAddress, strAccountNo, strBranch, strDesignation, intIsDeleted, strMobile, strTelephone, strEmailID, intApprove);
}
catch
{
throw;
}
finally
{
dle = null;
}
return msg;
}
public SqlDataReader isDelEmpNameChecked1(string strEmployeeName,int intIsDeleted)
{
DLEmployee dlc = new DLEmployee();
try
{
SqlDataReader dr = dlc.isDelEmpNameChecked1(strEmployeeName,intIsDeleted);
return dr;
}
catch
{
throw;
}
finally
{
//dlc = null;
}
}
public SqlDataReader gridFillEmployee1()
{
DLEmployee dld = new DLEmployee();
try
{
SqlDataReader dr = dld.gridFillEmployee1();
return dr;
}
catch
{
throw;
}
finally
{
dld = null;
}
}
public SqlDataReader gridFillApproveEmpName1(string strEmployeeName, int intApprove)
{
DLEmployee dlsr = new DLEmployee();
try
{
SqlDataReader dr = dlsr.gridFillApproveEmpName1(strEmployeeName, intApprove);
return dr;
}
catch
{
throw;
}
finally
{
dlsr = null;
}
}
public SqlDataAdapter getEmpNameEmployee1(string strEmployeeName)
{
SqlDataAdapter da = new SqlDataAdapter();
DLEmployee dltow = new DLEmployee();
try
{
dltow.getEmpNameEmployee1(strEmployeeName);
return da;
}
catch
{
throw;
}
finally
{
//dltow = null;
}
}