Exemplo n.º 1
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));
        }
Exemplo n.º 2
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));
        }
Exemplo n.º 3
0
        public SubscribeTypeInfo HasUserSubscribed(int UserId)
        {
            List <SQLParam> Param = new List <SQLParam>();

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

            return(sqlHAsy.ExecuteAsObject <SubscribeTypeInfo>(strSpName, Param));
        }
Exemplo n.º 4
0
        public UserInfo GetUserDetailsById(int UserId)
        {
            List <SQLParam> Param = new List <SQLParam>();

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

            return(sqlHAsy.ExecuteAsObject <UserInfo>(strSpName, Param));
        }
Exemplo n.º 5
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));
        }
Exemplo n.º 6
0
        public ProjectInfo GetProject(int?id)
        {
            List <SQLParam> Param = new List <SQLParam>();

            Param.Add(new SQLParam("@ProjectID", id));
            string strSpName = "usp_GetProject";
            SQLGet sqlHAsy   = new SQLGet();

            return(sqlHAsy.ExecuteAsObject <ProjectInfo>(strSpName, Param));
        }