//Get the ID number in the database to register information for new employees.
public int GetRegisterNumber()
{
Modules.DBModules DB = new Modules.DBModules();
Models.SearchEmployee SearchEmployee = new Models.SearchEmployee();
SqlDataReader sqlRdr = null;
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT EmployeeId FROM M_Employee");
try
{
if (!DB.DB_Connect())
{
}
if (DB.DB_SqlReader(strSql.ToString(), ref sqlRdr))
{
}
while (sqlRdr.Read())
{
SearchEmployee = new Models.SearchEmployee();
SearchEmployee.EmployeeId = int.Parse(sqlRdr["EmployeeId"].ToString());
}
}
catch (Exception ex)
{
}
finally
{
if (sqlRdr != null)
{
if (!sqlRdr.IsClosed)
{
sqlRdr.Close();
}
}
DB.DB_Close();
}
return(SearchEmployee.EmployeeId);
}
public List <Models.SearchEmployee> SearchResult(int SelectDepartmentId, string SearchEmployeeName)
{
bool sqlFlag = false;
Modules.DBModules DB = new Modules.DBModules();
Models.SearchEmployee SearchEmployee = new Models.SearchEmployee();
List <Models.SearchEmployee> SearchEmployeeList = new List <Models.SearchEmployee>();
SqlDataReader sqlRdr = null;
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT M_Employee.EmployeeName, M_Employee.CompanyEmployeeCode, M_Department.DepartmentName, M_Department.RegionName");
strSql.Append(" FROM M_Department");
strSql.Append(" INNER JOIN M_Employee ON M_Department.DepartmentId=M_Employee.DepartmentId");
// When the user select Department in Search condition.
if (SelectDepartmentId != 0)
{
strSql.Append(" WHERE");
strSql.Append(" M_Employee.DepartmentId = ");
strSql.AppendFormat("{0}", SelectDepartmentId);
sqlFlag = true;
}
if (SearchEmployeeName != "")
{
if (sqlFlag == true)
{
strSql.Append(" AND");
}
if (SelectDepartmentId == 0)
{
strSql.Append(" WHERE");
}
strSql.Append(" M_Employee.EmployeeName = ");
strSql.AppendFormat("'{0}'", SearchEmployeeName);
}
try
{
if (!DB.DB_Connect())
{
}
if (DB.DB_SqlReader(strSql.ToString(), ref sqlRdr))
{
}
while (sqlRdr.Read())
{
SearchEmployee = new Models.SearchEmployee();
SearchEmployee.EmployeeName = sqlRdr["EmployeeName"].ToString();
SearchEmployee.CompanyEmployeeCode = sqlRdr["CompanyEmployeeCode"].ToString();
SearchEmployee.DepartmentName = sqlRdr["DepartmentName"].ToString();
SearchEmployee.RegionName = sqlRdr["RegionName"].ToString();
SearchEmployeeList.Add(SearchEmployee);
}
}
catch (Exception ex)
{
}
finally
{
if (sqlRdr != null)
{
if (!sqlRdr.IsClosed)
{
sqlRdr.Close();
}
}
DB.DB_Close();
}
return(SearchEmployeeList);
}