public OrganigramaModel GetData(string organigramaPath)
{
string[] path = organigramaPath.Split('.');
OrganigramaModel model = new OrganigramaModel()
{
Area = path[0],
JobCenter = path[1],
Employess = new List <OrganigramaEmployeeModel>()
};
//EmployeeManager manager = new EmployeeManager();
//manager.Create();
var emps = _isosaemployeesRepository.SearhItemsFor(a => a.Area.ToLower().Equals(path[0].ToLower()) && a.Centro.ToLower().Equals(path[1].ToLower())).Select(j => new OrganigramaEmployeeModel {
Id = j.EMP_EmployeeID, Area = j.Area, JobCenter = j.Centro, Category = j.EMP_ASIGNACION, JobTitle = j.Perfil, Name = j.EMP_FirstName + " " + j.EMP_LastName, RowId = j.HrowGuid.ToString().ToLower()
});
//model.Employess.AddRange(emps);
//HierarchyManager hierarchy = new HierarchyManager();
//hierarchy.Create();
var iden = _isosaemployeesOrganigramaRepository.SearhItemsFor(h => h.RowGuid.Equals(emps.Where(f => f.RowId != "").FirstOrDefault().RowId.ToLower()));
model.RowId = iden.FirstOrDefault().IdentPuesto.ToString().ToLower();
return(model);
}
public OrganigramaModel GetAllDataNoActive()
{
OrganigramaModel model = new OrganigramaModel()
{
EmployeeNoActives = new List <OrganigramaEmployeeNoActive>()
};
//EmployeeManager manager = new EmployeeManager();
//manager.Create();
var nomiPAQ = _nomipaqRepository.GetAll().ToList();
var isosaEmp = _isosaemployeesRepository.SearhItemsFor(o => !o.EMP_StatusCode.Equals("Active"));
var emps = (from emp in isosaEmp
join nomi in nomiPAQ on emp.EMP_EmployeeID equals nomi.codigoempleado
where emp.EMP_StatusCode != "Active"
select new OrganigramaEmployeeNoActive()
{
Id = emp.EMP_EmployeeID.TrimStart(new Char[] { '0' }),
Area = "NA",
JobCenter = "NA",
Category = "NA",
JobTitle = "NA",
Name = $"{emp.EMP_FirstName} {emp.EMP_LastName}",
RowId = emp.HrowGuid.ToString(),
Nomipaq = nomi.codigoempleado != null ? "Si" : "No"
}).ToList();
model.EmployeeNoActives.AddRange(emps);
return(model);
}
public OrganigramaModel GetAllData()
{
OrganigramaModel model = new OrganigramaModel()
{
Employess = new List <OrganigramaEmployeeModel>()
};
//EmployeeManager manager = new EmployeeManager();
//manager.Create();
var isosaOrg = _isosaemployeesOrganigramaRepository.GetAll();
var isosaEmp = _isosaemployeesRepository.SearhItemsFor(o => o.EMP_StatusCode.Equals("Active"));
var t = isosaOrg.Where(d => d.RowGuid.ToString().ToLower().Equals("1DF075D8-C519-401A-BDE9-85B4154546E1".ToLower()));
var t2 = isosaEmp.Where(d => d.HrowGuid.ToString().ToLower().Equals("1DF075D8-C519-401A-BDE9-85B4154546E1".ToLower()));
var emps = (from emp in isosaEmp
join org in isosaOrg on emp.HrowGuid.Value equals org.RowGuid
where emp.EMP_StatusCode == "Active"
select new OrganigramaEmployeeModel()
{
Id = emp.EMP_EmployeeID.TrimStart(new Char[] { '0' }),
Area = org.Area,
JobCenter = org.Centro,
Category = org.Departamento,
JobTitle = org.Puesto,
Name = $"{emp.EMP_FirstName} {emp.EMP_LastName}",
RowId = emp.HrowGuid.ToString(),
UserName = string.IsNullOrEmpty(emp.SARH_Login) ? "" : emp.SARH_Login
}).ToList();
//var nomipaq = _nomipaqRepository.GetAll();
//var noasigado = (from nomi in nomipaq
// join emp in emps on nomi.codigoempleado.TrimStart(new Char[] { '0' }) equals emp.Id into ps
// from p in ps.DefaultIfEmpty()
// select new
// {
// codigoempleado = nomi.codigoempleado.TrimStart(new Char[] { '0' }),
// estado = nomi.estadoempleado
// }
// ).ToList();
//var emps = _isosaemployeesRepository.SearhItemsFor(o => o.EMP_StatusCode.Equals("Active")).Select(j => new OrganigramaEmployeeModel()
//{
// Id = j.EMP_EmployeeID.TrimStart(new Char[] { '0' }),
// Area = GetInfoOrg("1", j.HrowGuid.Value.ToString(), isosaOrg),
// JobCenter = GetInfoOrg("2", j.HrowGuid.Value.ToString(), isosaOrg),
// Category = GetInfoOrg("3", j.HrowGuid.Value.ToString(), isosaOrg),
// JobTitle = GetInfoOrg("4", j.HrowGuid.Value.ToString(), isosaOrg),
// Name = $"{j.EMP_FirstName} {j.EMP_LastName}",
// RowId = j.HrowGuid.ToString()
//});
model.Employess.AddRange(emps);
return(model);
}
