コード例 #1
0
        public void UnSubscribeService(int UserId)
        {
            List <SQLParam> Param = new List <SQLParam>();

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

            sqlHAsy.ExecuteNonQuery(strSpName, Param);
        }
コード例 #2
0
        public void DeleteProject(int id)
        {
            List <SQLParam> Param = new List <SQLParam>();

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

            sqlHAsy.ExecuteNonQuery(strSpName, Param);
        }
コード例 #3
0
        public int AddUserSubscription(int UserId, int subscribeType)
        {
            List <SQLParam> Param = new List <SQLParam>();

            Param.Add(new SQLParam("@UserId", UserId));
            Param.Add(new SQLParam("@SubscribeType", subscribeType));
            string             strSpName = "[dbo].[usp_ServiceSubscription_AddUserSubscription]";
            SQLExecuteNonQuery sqlHAsy   = new SQLExecuteNonQuery();

            return(sqlHAsy.ExecuteNonQueryAsGivenType <int>(strSpName, Param, "@SubscriptionId"));
        }
コード例 #4
0
        public void AddProject(ProjectInfo objInfo)
        {
            List <SQLParam> Param = new List <SQLParam>();

            Param.Add(new SQLParam("@ProjectName", objInfo.ProjectName));
            Param.Add(new SQLParam("@ProjectCode", objInfo.ProjectCode));
            string             strSpName = "usp_AddProject";
            SQLExecuteNonQuery sqlHAsy   = new SQLExecuteNonQuery();

            sqlHAsy.ExecuteNonQuery(strSpName, Param);
        }
コード例 #5
0
        public void AddUser(UserInfo objInfo)
        {
            List <SQLParam> Param = new List <SQLParam>();

            Param.Add(new SQLParam("@FirstName", objInfo.FirstName));
            Param.Add(new SQLParam("@LastName", objInfo.LastName));
            Param.Add(new SQLParam("@UserName", objInfo.UserName));
            Param.Add(new SQLParam("@Email", objInfo.Email));
            Param.Add(new SQLParam("@PasswordHash", objInfo.PasswordHash));
            Param.Add(new SQLParam("@PasswordSalt", objInfo.PasswordSalt));
            Param.Add(new SQLParam("@Role", objInfo.Role));
            string             strSpName = "[dbo].[usp_ServiceSubscription_AddUser]";
            SQLExecuteNonQuery sqlHAsy   = new SQLExecuteNonQuery();

            sqlHAsy.ExecuteNonQuery(strSpName, Param);
        }