internal string GetEmployeeEmail(EmployeeSetup objEmployeeSetup)
{
try
{
string sql = " SELECT [Email] FROM [hrEmployeeSetup] WHERE CompanyID = " + objEmployeeSetup.CompanyID + " AND DataUsed ='A' AND EmployeeID = '" + objEmployeeSetup.EmployeeID + "'";
EmployeeDetailsSetup objEmployeeDetailsSetup = new EmployeeDetailsSetup();
clsDataManipulation objclsDataManipulation = new clsDataManipulation();
return(objEmployeeDetailsSetup.Email = objclsDataManipulation.GetSingleValueAsString(this.ConnectionString, sql));
}
catch (Exception msgException)
{
throw msgException;
}
}
private string CheckSecurityCode(UserList objUserList)
{
try
{
string targetSecurityCode = null;
string sql = @" SELECT B.SecurityCode FROM [hrEmployeeSetup] A
INNER JOIN UserSecurityCode B ON A.CompanyID = B.CompanyID AND A.EmployeeID = B.EmployeeID WHERE
B.SecurityCodeStatus = 0 AND B.DataUsed = 'A' AND A.Email = '" + objUserList.UserEmail + "'";
clsDataManipulation objclsDataManipulation = new clsDataManipulation();
targetSecurityCode = objclsDataManipulation.GetSingleValueAsString(this.ConnectionString, sql);
return(targetSecurityCode);
}
catch (Exception msgException)
{
throw msgException;
}
}