public string GetListMemberships(string userName)
        {
            string answer = "";

            using (SqlConnection connection = new SqlConnection(ConnectionString))
            {
                try
                {
                    connection.Open();
                    DaTypeMembership odaTypeMembership = new DaTypeMembership();
                    answer = odaTypeMembership.GetListMemberships(connection, userName);
                    connection.Close();
                }
                catch (Exception e)
                {
                    RecordLog(e.Message, e.StackTrace);
                }
            }
            return(answer);
        }
        public bool CancelMembershipUpgrate(int codeUpgrate, int nuevoNmembershi)
        {
            bool answer = false;

            using (SqlConnection connection = new SqlConnection(ConnectionString))
            {
                try
                {
                    connection.Open();
                    DaTypeMembership odaTypeMembership = new DaTypeMembership();
                    answer = odaTypeMembership.CancelMembershipUpgrate(connection, codeUpgrate, nuevoNmembershi);
                    connection.Close();
                }
                catch (Exception e)
                {
                    RecordLog(e.Message, e.StackTrace);
                }
            }
            return(answer);
        }
        public string GetTypeMembership(int idAccount_N_Membership)
        {
            string answer = "";

            using (SqlConnection connection = new SqlConnection(ConnectionString))
            {
                try
                {
                    connection.Open();
                    DaTypeMembership odaTypeMembership = new DaTypeMembership();
                    answer = odaTypeMembership.GetTypeMembership(connection, idAccount_N_Membership);
                    connection.Close();
                }
                catch (Exception e)
                {
                    RecordLog(e.Message, e.StackTrace);
                }
            }
            return(answer);
        }
        public bool AddMembershipUser(string data)
        {
            bool answer = false;

            using (SqlConnection connection = new SqlConnection(ConnectionString))
            {
                try
                {
                    connection.Open();
                    DaTypeMembership odaTypeMembership = new DaTypeMembership();
                    answer = odaTypeMembership.AddMembershipUser(connection, data);
                    connection.Close();
                }
                catch (Exception e)
                {
                    RecordLog(e.Message, e.StackTrace);
                }
            }
            return(answer);
        }