public List <Employee> GetAllEmployee(EmployeeAdvanceSearch employeeAdvanceSearch)
{
return(_employeeRepository.GetAllEmployee(employeeAdvanceSearch));
}
public List <Employee> GetAllEmployee(EmployeeAdvanceSearch employeeAdvanceSearch)
{
List <Employee> employeeList = null;
try
{
using (SqlConnection con = _databaseFactory.GetDBConnection())
{
using (SqlCommand cmd = new SqlCommand())
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.Connection = con;
cmd.CommandText = "[PSA].[GetAllEmployee]";
if (string.IsNullOrEmpty(employeeAdvanceSearch.SearchTerm))
{
cmd.Parameters.AddWithValue("@SearchTerm", DBNull.Value);
}
else
{
cmd.Parameters.Add("@SearchTerm", SqlDbType.NVarChar, -1).Value = employeeAdvanceSearch.SearchTerm;
}
cmd.Parameters.Add("@RowStart", SqlDbType.Int).Value = employeeAdvanceSearch.DataTablePaging.Start;
if (employeeAdvanceSearch.DataTablePaging.Length == -1)
{
cmd.Parameters.AddWithValue("@Length", DBNull.Value);
}
else
{
cmd.Parameters.Add("@Length", SqlDbType.Int).Value = employeeAdvanceSearch.DataTablePaging.Length;
}
cmd.Parameters.Add("@DepartmentCode", SqlDbType.Int).Value = employeeAdvanceSearch.AdvDepartmentCode;
cmd.Parameters.Add("@PositionCode", SqlDbType.Int).Value = employeeAdvanceSearch.AdvPositionCode;
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader sdr = cmd.ExecuteReader())
{
if ((sdr != null) && (sdr.HasRows))
{
employeeList = new List <Employee>();
while (sdr.Read())
{
Employee employee = new Employee();
{
employee.ID = (sdr["ID"].ToString() != "" ? Guid.Parse(sdr["ID"].ToString()) : employee.ID);
employee.Code = (sdr["Code"].ToString() != "" ? sdr["Code"].ToString() : employee.Code);
employee.Name = (sdr["Name"].ToString() != "" ? sdr["Name"].ToString() : employee.Name);
employee.MobileNo = (sdr["MobileNo"].ToString() != "" ? sdr["MobileNo"].ToString() : employee.MobileNo);
employee.Address = (sdr["Address"].ToString() != "" ? sdr["Address"].ToString() : employee.Address);
employee.ImageURL = (sdr["ImageURL"].ToString() != "" ? sdr["ImageURL"].ToString() : employee.ImageURL);
employee.Department = new Department();
employee.Department.Description = (sdr["Department"].ToString() != "" ? (sdr["Department"].ToString()) : employee.Department.Description);
employee.Position = new Position();
employee.Position.Description = (sdr["Position"].ToString() != "" ? (sdr["Position"].ToString()) : employee.Position.Description);
employee.GeneralNotes = (sdr["GeneralNotes"].ToString() != "" ? sdr["GeneralNotes"].ToString() : employee.GeneralNotes);
employee.FilteredCount = (sdr["FilteredCount"].ToString() != "" ? int.Parse(sdr["FilteredCount"].ToString()) : employee.FilteredCount);
employee.TotalCount = (sdr["TotalCount"].ToString() != "" ? int.Parse(sdr["TotalCount"].ToString()) : employee.FilteredCount);
}
employeeList.Add(employee);
}
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(employeeList);
}
