public List <DtoEmployee> ListEmployeeSelect(DtoEmployee emp)
{
Entities_Visit ctx;
using (ctx = new Entities_Visit())
{
List <DtoEmployee> list = new List <DtoEmployee>();
DtoEmployee objEmployee;
try
{
var query = ctx.PR_SEARCH_EMPLOYEE_SELECTION(emp.bemp_state, emp.iBra_buis_id, emp.sEmp_name, emp.sEmp_surname, emp.sEmp_document, emp.sEmp_mail, emp.sRol_name);
foreach (var employee in query)
{
objEmployee = new DtoEmployee();
objEmployee.iEmp_id = (int)employee.EMP_ID;
objEmployee.iRol_id = (int)employee.ROL_ID;
objEmployee.iBra_buis_id = (int)employee.BRA_BUIS_ID;
objEmployee.sRol_name = employee.ROL_NAME;
objEmployee.sEmp_document = employee.EMP_DOCUMENT;
objEmployee.sEmp_name = employee.EMP_NAME;
objEmployee.sEmp_surname = employee.EMP_SURNAME;
objEmployee.sEmp_phone = employee.EMP_PHONE;
objEmployee.sEmp_phone2 = employee.EMP_PHONE;
objEmployee.sEmp_cell_phone = employee.EMP_CELL_PHONE;
objEmployee.sEmp_cell_phone2 = employee.EMP_CELL_PHONE2;
objEmployee.sEmp_addres = employee.EMP_ADDRES;
objEmployee.sEmp_mail = employee.EMP_MAIL;
objEmployee.sEmp_mail2 = employee.EMP_MAIL2;
objEmployee.sEmp_password = employee.EMP_PASSWORD;
objEmployee.sEmp_password = employee.EMP_PASSWORD;
objEmployee.sEmp_permission = employee.EMP_PER;
list.Add(objEmployee);
}
list.ToList();
}
catch (Exception e)
{
}
return(list);
}
}
