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