/// <summary>
/// Retorna TODAS las HealthInstitution_Profesional del profecional
/// </summary>
/// <param name="pPrefesionalId"></param>
/// <returns></returns>
public static Health.BE.HealthInstitution_ProfesionalList Retrive_HealthInstitution_Relationships(int pPrefesionalId)
{
using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities))
{
List <Health.Back.BE.HealthInstitution_Profesional> list2 = null;
list2 = (from p in dc.HealthInstitution_Profesional
where
p.ProfesionalId.Equals(pPrefesionalId)
select p).ToList <Health.Back.BE.HealthInstitution_Profesional>();
HealthInstitution_ProfesionalList list = new HealthInstitution_ProfesionalList();
HealthInstitution_ProfesionalBE wBE;
foreach (Health.Back.BE.HealthInstitution_Profesional i in list2)
{
wBE = (HealthInstitution_ProfesionalBE)i;
//Asignar el array de Roles a cada profesional
var health_roles = from r in dc.HealtInstitute_UsersInRoles where r.HealthInstitutionId.Equals(i.HealthInstitutionId) select r.RoleName;
if (health_roles.Count() != 0)
{
wBE.Roles = health_roles.ToArray <string>();
}
list.Add(wBE);
}
return(list);
}
}
/// <summary>
/// Retorna los profecionales activos de una healthInstitute
/// </summary>
/// <param name="profesionalId">Profesional para no incluir</param>
/// <param name="healthInstituteId">Institusion</param>
/// <returns></returns>
public static HealthInstitution_ProfesionalList Profesionals_Retrive_AllRelated(int profesionalId, Guid healthInstituteId)
{
HealthInstitution_ProfesionalList wProfesionalsBEList = new HealthInstitution_ProfesionalList();
using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities))
{
///Profesionales que ya pertenecen a la institución Esta es una lista para quitar
var profesionals_exist = from hp in dc.HealthInstitution_Profesional
from p in dc.Profesional_FullView
where
hp.HealthInstitutionId.Equals(healthInstituteId) &&
hp.ProfesionalId.Equals(p.IdProfesional) &&
hp.ProfesionalId.Equals(profesionalId) == false &&
hp.ActiveFlag.Equals(true)
select new HealthInstitution_ProfesionalBE
{
ProfesionalId = p.IdProfesional,
FullName = String.Concat(p.Apellido, p.Nombre),
IsAdmin = hp.IsAdmin,
IsLockedOut = hp.IsLockedOut,
IsOwner = hp.IsOwner,
UserId = hp.UserId,
};
//Asignar el array de Roles a cada profesionals_exist
var health_roles = from r in dc.HealtInstitute_UsersInRoles where r.HealthInstitutionId.Equals(healthInstituteId) select r;
foreach (HealthInstitution_ProfesionalBE p in profesionals_exist)
{
p.Roles = (from r in health_roles select r.RoleName).ToArray <string>();
}
wProfesionalsBEList.AddRange(profesionals_exist.ToList <HealthInstitution_ProfesionalBE>());
}
return(wProfesionalsBEList);
}
/// <summary>
/// Retorna TODAS las HealthInstitution_Profesional del profecional
/// </summary>
/// <param name="pPrefesionalId"></param>
/// <returns></returns>
public static Health.BE.HealthInstitution_ProfesionalList Retrive_HealthInstitution_Relationships(int pPrefesionalId)
{
using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities))
{
List<Health.Back.BE.HealthInstitution_Profesional> list2 = null;
list2 = (from p in dc.HealthInstitution_Profesional
where
p.ProfesionalId.Equals(pPrefesionalId)
select p).ToList<Health.Back.BE.HealthInstitution_Profesional>();
HealthInstitution_ProfesionalList list = new HealthInstitution_ProfesionalList();
HealthInstitution_ProfesionalBE wBE;
foreach (Health.Back.BE.HealthInstitution_Profesional i in list2)
{
wBE = (HealthInstitution_ProfesionalBE)i;
//Asignar el array de Roles a cada profesional
var health_roles = from r in dc.HealtInstitute_UsersInRoles where r.HealthInstitutionId.Equals(i.HealthInstitutionId) select r.RoleName;
if (health_roles.Count() != 0)
wBE.Roles = health_roles.ToArray<string>();
list.Add(wBE);
}
return list;
}
}
/// <summary>
/// Retorna los Profesionales activos de una healthInstitute
/// </summary>
/// <param name="profesionalId">Profesional para no incluir</param>
/// <param name="healthInstituteId">Institusion</param>
/// <returns></returns>
public static HealthInstitution_ProfesionalList Profesionals_Retrive_AllRelated(int profesionalId, Guid healthInstituteId)
{
HealthInstitution_ProfesionalList wProfesionalsBEList = new HealthInstitution_ProfesionalList();
using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities))
{
///Profesionales que ya pertenecen a la institución Esta es una lista para quitar
var profesionals_exist = from hp in dc.HealthInstitution_Profesional
from p in dc.Profesional_FullView
where
hp.HealthInstitutionId.Equals(healthInstituteId) &&
hp.ProfesionalId.Equals(p.IdProfesional) &&
hp.ProfesionalId.Equals(profesionalId) == false &&
hp.ActiveFlag.Equals(true)
select new HealthInstitution_ProfesionalBE
{
ProfesionalId = p.IdProfesional,
FullName = String.Concat(p.Apellido, p.Nombre),
IsAdmin = hp.IsAdmin,
IsLockedOut = hp.IsLockedOut,
IsOwner = hp.IsOwner,
UserId = hp.UserId,
};
//Asignar el array de Roles a cada profesionals_exist
var health_roles = from r in dc.HealtInstitute_UsersInRoles where r.HealthInstitutionId.Equals(healthInstituteId) select r;
foreach (HealthInstitution_ProfesionalBE p in profesionals_exist)
{
p.Roles = (from r in health_roles select r.RoleName).ToArray<string>();
}
wProfesionalsBEList.AddRange(profesionals_exist.ToList<HealthInstitution_ProfesionalBE>());
}
return wProfesionalsBEList;
}
