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();
}
}
/// <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 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();
}
}
//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>
///
/// </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();
}
}
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>
///
/// </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>
/// 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();
}
}