示例#1
0
        public bool HasUserUnSubscribed(int UserId)
        {
            List <SQLParam> Param = new List <SQLParam>();

            Param.Add(new SQLParam("@UserId", UserId));
            string strSpName = "[dbo].[usp_ServiceSubscription_HasUserUnSubscribed]";
            SQLGet sqlHAsy   = new SQLGet();

            return(sqlHAsy.ExecuteAsScalar <bool>(strSpName, Param));
        }
示例#2
0
        public string GetUserEmailById(int UserId)
        {
            List <SQLParam> Param = new List <SQLParam>();

            Param.Add(new SQLParam("@UserId", UserId));
            string strSpName = "[dbo].[usp_ServiceSubscription_GetUserEmailById]";
            SQLGet sqlHAsy   = new SQLGet();

            return(sqlHAsy.ExecuteAsScalar <string>(strSpName, Param));
        }
示例#3
0
        public bool IsEmailAddressExists(string UserEmail)
        {
            List <SQLParam> Param = new List <SQLParam>();

            Param.Add(new SQLParam("@UserEmail", UserEmail));
            string strSpName = "[dbo].[usp_ServiceSubscription_IsEmailAddressExists]";
            SQLGet sqlHAsy   = new SQLGet();

            return(sqlHAsy.ExecuteAsScalar <bool>(strSpName, Param));
        }