public static List <Nomenclator> RetriveAll()
{
using (Health.Entities.HealthLinQDataContext dc = new Health.Entities.HealthLinQDataContext(Common.CnnString))
{
return(dc.Nomenclators.OrderBy(p => p.Id).ToList <Nomenclator>());
}
}
/// <summary>
/// Retorna lista de sulicitud de registro
/// </summary>
/// <param name="isApproved"></param>
/// <returns></returns>
public static List <RegistrationRequest> Retrive_All_RegistrationRequest(bool?isApproved)
{
using (Health.Entities.HealthLinQDataContext dc = new Health.Entities.HealthLinQDataContext(Common.CnnString))
{
return(dc.RegistrationRequests.Where(p => (isApproved.HasValue || p.IsApproved.Equals(isApproved.Value))).ToList <RegistrationRequest>());
}
}
public static void Process_PMO_Odont()
{
using (Health.Entities.HealthLinQDataContext dc = new Health.Entities.HealthLinQDataContext(Common.CnnString))
{
string[] auxiliar;
var list = dc.Nomenclators.Where(p => p.PMOType.Equals((int)PMOEnum.Odontológicas)).OrderBy(p => p.Id);
foreach (Nomenclator PMO in list)
{
auxiliar = PMO.Code.Split('.');
if (auxiliar.Length == 3)
{
//PMO.Code = temp.Code.Trim();
PMO.ParentCode = string.Concat(auxiliar[0], '.', auxiliar[1]);
PMO.HasChilds = false;
}
if (auxiliar.Length == 2)
{
//PMO.Code = temp.Code.Trim();
PMO.ParentCode = auxiliar[0].ToString().Trim();
PMO.HasChilds = true;
}
if (auxiliar.Length == 1)
{
//PMO.Code = temp.Code.Trim();
PMO.ParentCode = string.Empty;
PMO.HasChilds = true;
}
}
dc.SubmitChanges();
}
}
public static List <Nomenclator> RetriveByType(int type)
{
using (Health.Entities.HealthLinQDataContext dc = new Health.Entities.HealthLinQDataContext(Common.CnnString))
{
return(dc.Nomenclators.Where(p => p.PMOType.Equals(type)).ToList <Nomenclator>());
}
}
/// <summary>
/// Retorna sulicitud de registro por nombre
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static RegistrationRequest Get_RegistrationRequest(int id)
{
using (Health.Entities.HealthLinQDataContext dc = new Health.Entities.HealthLinQDataContext(Common.CnnString))
{
var reg = dc.RegistrationRequests.Where(s => s.Id.Equals(id)).FirstOrDefault <RegistrationRequest>();
return(reg);
}
}
/// <summary>
/// Retorna sulicitud de registro por nombre
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static RegistrationRequest Get_RegistrationRequest(int id)
{
using (Health.Entities.HealthLinQDataContext dc = new Health.Entities.HealthLinQDataContext(Common.CnnString))
{
var reg = dc.RegistrationRequests.Where(s => s.Id.Equals(id)).FirstOrDefault<RegistrationRequest>();
return reg;
}
}
/// <summary>
/// Retorna lista de sulicitud de registro
/// </summary>
/// <param name="isApproved"></param>
/// <returns></returns>
public static List<RegistrationRequest> Retrive_All_RegistrationRequest(bool? isApproved)
{
using (Health.Entities.HealthLinQDataContext dc = new Health.Entities.HealthLinQDataContext(Common.CnnString))
{
return dc.RegistrationRequests.Where(p=> (isApproved.HasValue || p.IsApproved.Equals(isApproved.Value))).ToList < RegistrationRequest>();
}
}
/// <summary>
/// Crea una solicitud. No establece IsApproved = true
/// </summary>
/// <param name="registrationRequest"></param>
public static void CreateRegistrationRequest(RegistrationRequest registrationRequest)
{
using (Health.Entities.HealthLinQDataContext dc = new Health.Entities.HealthLinQDataContext(Common.CnnString))
{
registrationRequest.RequetsTime = System.DateTime.Now;
dc.RegistrationRequests.InsertOnSubmit(registrationRequest);
dc.SubmitChanges();
}
}
/// <summary>
/// Crea una solicitud. No establece IsApproved = true
/// </summary>
/// <param name="registrationRequest"></param>
public static void CreateRegistrationRequest(RegistrationRequest registrationRequest)
{
using (Health.Entities.HealthLinQDataContext dc = new Health.Entities.HealthLinQDataContext(Common.CnnString))
{
registrationRequest.RequetsTime = System.DateTime.Now;
dc.RegistrationRequests.InsertOnSubmit(registrationRequest);
dc.SubmitChanges();
}
}
//public static Profesional_FullViewBE GetByGuid(Guid id)
//{
// using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities))
// {
// var user = dc.Profesional_FullView.Where(s => s.UserId.Equals(id)).FirstOrDefault<Profesional_FullView>();
// return new Profesional_FullViewBE(user);
// }
//}
/// <summary>
/// Aprueva un registro de solicitud
/// Establece IsApproved = true y user id a Socios donde nrsocio coincida
/// Si viene el nro abonado solo actualizaria un dato
/// </summary>
/// <param name="nroSocio">Numero de socio</param>
/// <param name="userId">Id del usuario web generado</param>
public static void Approve(int id)
{
using (Health.Entities.HealthLinQDataContext dc = new Health.Entities.HealthLinQDataContext(Common.CnnString))
{
var r = dc.RegistrationRequests.Where(p => p.Id.Equals(id)).FirstOrDefault <RegistrationRequest>();
r.IsApproved = true;
dc.SubmitChanges();
}
}
public static List<Health.Entities.cei10_view> Retrive_View_All()
{
List<Health.Entities.cei10_view> list = new List<Health.Entities.cei10_view>();
using (Health.Entities.HealthLinQDataContext dc = new Health.Entities.HealthLinQDataContext(Common.CnnString))
{
foreach (cei10_view c in dc.cei10_views)
{
list.Add((cei10_view)c);
}
}
return list;
}
public static List <Health.Entities.cei10_view> Retrive_View_All()
{
List <Health.Entities.cei10_view> list = new List <Health.Entities.cei10_view>();
using (Health.Entities.HealthLinQDataContext dc = new Health.Entities.HealthLinQDataContext(Common.CnnString))
{
foreach (cei10_view c in dc.cei10_views)
{
list.Add((cei10_view)c);
}
}
return(list);
}
public static void Process_PMO(List <Nomenclator> list, int pmoType)
{
Nomenclator wNomenclator;
using (Health.Entities.HealthLinQDataContext dc = new Health.Entities.HealthLinQDataContext(Common.CnnString))
{
string[] auxiliar;
foreach (Nomenclator temp in list.OrderBy(p => p.Id))
{
wNomenclator = new Nomenclator();
auxiliar = temp.Code.Split('.');
if (auxiliar.Length == 3)
{
wNomenclator.Code = temp.Code.Trim();
wNomenclator.ParentCode = string.Concat(auxiliar[0], '.', auxiliar[1]);
wNomenclator.HasChilds = false;
}
if (auxiliar.Length == 2)
{
wNomenclator.Code = temp.Code.Trim();
wNomenclator.ParentCode = auxiliar[0].ToString();
wNomenclator.HasChilds = true;
}
if (auxiliar.Length == 1)
{
wNomenclator.Code = temp.Code.Trim();
wNomenclator.ParentCode = string.Empty;
wNomenclator.HasChilds = true;
}
wNomenclator.Description = temp.Description.Trim();
wNomenclator.PMOType = pmoType;
//wNomenclator.Id = temp.Id;
dc.Nomenclators.InsertOnSubmit(wNomenclator);
}
dc.SubmitChanges();
}
}
public static void Process_PMO_AnalisisClinicos()
{
using (Health.Entities.HealthLinQDataContext dc = new Health.Entities.HealthLinQDataContext(Common.CnnString))
{
string auxiliar = string.Empty;
var list = dc.Nomenclators.Where(p => p.PMOType.Equals((int)PMOEnum.Diagnostico_Analisis_Clinico)).OrderBy(p => p.Id);
foreach (Nomenclator PMO in list)
{
if (!string.IsNullOrEmpty(PMO.Code.Trim()))
{
auxiliar = PMO.Code.Trim();
PMO.Code = auxiliar;
}
PMO.Code = auxiliar;
}
dc.SubmitChanges();
}
}
internal static void Remove_SubscriptionReq(Guid pHealthInstitutionId, int pIdProfesional_To)
{
HealthInstitutions_SuscriptionRequestsList wProfesionalsBEList = new HealthInstitutions_SuscriptionRequestsList();
using (HealthLinQDataContext dc = new HealthLinQDataContext(Common.CnnString))
{
var wSuscription = dc.HealthInstitutions_SuscriptionRequests.Where(p => p.Profesional_To.Equals(pIdProfesional_To)
&& p.HealthInstitutionId.Equals(p.HealthInstitutionId)).FirstOrDefault();
dc.HealthInstitutions_SuscriptionRequests.DeleteOnSubmit(wSuscription);
dc.SubmitChanges();
}
}
/// <summary>
/// Crea un pedido de subscripcion
/// </summary>
/// <param name="pProfesionalId_From"></param>
/// <param name="pProfesionalId_To"></param>
/// <param name="pHealthInstitutionId"></param>
/// <param name="rolname"></param>
/// <param name="msg"></param>
public static void CreateSubscription_Req(int pProfesionalId_From, int pProfesionalId_To, Guid pHealthInstitutionId, string pRolName, string pMessage)
{
using (HealthLinQDataContext dc = new HealthLinQDataContext(Common.CnnString))
{
HealthInstitutions_SuscriptionRequest req = new HealthInstitutions_SuscriptionRequest();
req.HealthInstitutionId = pHealthInstitutionId;
req.Profesional_To = pProfesionalId_To;
req.ProfesionalId_From = pProfesionalId_From;
req.RequestSend = DateTime.Now;
if (!string.IsNullOrEmpty(pMessage))
req.Message = pMessage;
if (!string.IsNullOrEmpty(pRolName))
req.RoleName = pRolName;
dc.HealthInstitutions_SuscriptionRequests.InsertOnSubmit(req);
dc.SubmitChanges();
}
}
/// <summary>
/// Retorna lista <see cref="HealthInstitutions_SuscriptionRequestsList"/> con solo id , nombre + datos de la subscripción
/// </summary>
/// <param name="healthInstituteId"></param>
/// <returns></returns>
internal static HealthInstitutions_SuscriptionRequestsList Retrive_Subscriptions_SimpleList(Guid healthInstituteId)
{
HealthInstitutions_SuscriptionRequestsList wProfesionalsBEList = new HealthInstitutions_SuscriptionRequestsList();
using (HealthLinQDataContext dc = new HealthLinQDataContext(Common.CnnString))
{
var AllProfesionals = from p in dc.HealthInstitutions_SuscriptionRequests
from prof in dc.Profesionals
where
p.HealthInstitutionId.Equals(healthInstituteId)
&& prof.IdProfesional.Equals(p.Profesional_To)
select new HealthInstitutions_SuscriptionRequestsBE
{
Profesional_To = prof.IdProfesional,
Nombre_To = prof.Persona.Nombre,
Apellido_To = prof.Persona.Apellido,
RequestSend = p.RequestSend,
Status = p.State,
Message = p.Message
};
wProfesionalsBEList.AddRange(AllProfesionals.ToList<HealthInstitutions_SuscriptionRequestsBE>());
}
return wProfesionalsBEList;
}
//public static Profesional_FullViewBE GetByGuid(Guid id)
//{
// using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities))
// {
// var user = dc.Profesional_FullView.Where(s => s.UserId.Equals(id)).FirstOrDefault<Profesional_FullView>();
// return new Profesional_FullViewBE(user);
// }
//}
/// <summary>
/// Aprueva un registro de solicitud
/// Establece IsApproved = true y user id a Socios donde nrsocio coincida
/// Si viene el nro abonado solo actualizaria un dato
/// </summary>
/// <param name="nroSocio">Numero de socio</param>
/// <param name="userId">Id del usuario web generado</param>
public static void Approve(int id)
{
using (Health.Entities.HealthLinQDataContext dc = new Health.Entities.HealthLinQDataContext(Common.CnnString))
{
var r = dc.RegistrationRequests.Where (p=> p.Id.Equals(id)).FirstOrDefault<RegistrationRequest>();
r.IsApproved = true;
dc.SubmitChanges();
}
}
/// <summary>
/// Lista usada para ver las solicitudes al Profesional
/// Retorna lista <see cref="HealthInstitutions_SuscriptionRequestsList"/> con solo id , nombre + datos de la subscripción
/// Se retorna Nombre y apellido es del usuario que solicita
/// </summary>
/// <param name="pIdProfesional">Id del profesional que desea ver sus solicitudes pendientes</param>
/// <returns></returns>
internal static HealthInstitutions_SuscriptionRequestsList Retrive_PendingSubscriptions_SimpleList(int pIdProfesional)
{
HealthInstitutions_SuscriptionRequestsList wProfesionalsBEList = new HealthInstitutions_SuscriptionRequestsList();
using (HealthLinQDataContext dc = new HealthLinQDataContext(Common.CnnString))
{
var AllProfesionals = from p in dc.HealthInstitutions_SuscriptionRequests
from h in dc.HealthInstitutions
from prof_from in dc.Profesionals
where
p.Profesional_To.Equals(pIdProfesional)
&& h.HealthInstitutionId.Equals(p.HealthInstitutionId)
&& prof_from.IdProfesional.Equals(p.ProfesionalId_From)
&& !p.State.Equals(SubscriptionRequestStatus.Rechazado)
&& !p.State.Equals(SubscriptionRequestStatus.Expirado)
select new HealthInstitutions_SuscriptionRequestsBE
{
Profesional_To = p.Profesional_To,
Profesional_From = p.ProfesionalId_From,
Nombre_From = prof_from.Persona.Nombre,
Apellido_From = prof_from.Persona.Apellido,
RequestSend = p.RequestSend,
Status = p.State,
HealthInsId = h.HealthInstitutionId,
HealthInstName = h.RazonSocial,
SenderIsOwner = p.SenderIsOwner,
Message = p.Message
};
wProfesionalsBEList.AddRange(AllProfesionals.ToList<HealthInstitutions_SuscriptionRequestsBE>());
}
return wProfesionalsBEList;
}
/// <summary>
///
/// </summary>
/// <param name="pHealthInstitutionId"></param>
/// <param name="pIdProfesional_To"></param>
/// <param name="status"></param>
public static void Update_Subscriptions_Status(Guid pHealthInstitutionId, int pIdProfesional_To, SubscriptionRequestStatus status)
{
HealthInstitutions_SuscriptionRequestsList wProfesionalsBEList = new HealthInstitutions_SuscriptionRequestsList();
using (HealthLinQDataContext dc = new HealthLinQDataContext(Common.CnnString))
{
var wSuscription = dc.HealthInstitutions_SuscriptionRequests.Where(p => p.Profesional_To.Equals(pIdProfesional_To)
&& p.HealthInstitutionId.Equals(p.HealthInstitutionId)).FirstOrDefault();
wSuscription.State = (int)status;
dc.SubmitChanges();
}
}
/// <summary>
///
/// </summary>
/// <param name="pHealthInstitutionId"></param>
/// <param name="pIdProfesional_To"></param>
/// <param name="status"></param>
public static void Acept_Subscriptions_Req(Guid pHealthInstitutionId, int pIdProfesional_To, Guid user_guid)
{
HealthInstitutions_SuscriptionRequestsList wProfesionalsBEList = new HealthInstitutions_SuscriptionRequestsList();
using (HealthLinQDataContext dc = new HealthLinQDataContext(Common.CnnString))
{
var wSuscription = dc.HealthInstitutions_SuscriptionRequests.Where(p => p.Profesional_To.Equals(pIdProfesional_To)
&& p.HealthInstitutionId.Equals(p.HealthInstitutionId)).FirstOrDefault();
//Asociar el Profesional
Profesional_Associate_As_AdminOwner(pHealthInstitutionId, pIdProfesional_To, user_guid, wSuscription.RoleName);
//Elimina la subscripcion
dc.HealthInstitutions_SuscriptionRequests.DeleteOnSubmit(wSuscription);
dc.SubmitChanges();
}
}