the sp should be modify like the following , the red text part are missing. int database of svn 221
ALTER PROCEDURE [dbo].[BugNet_Project_CreateNewProject]
@Name nvarchar(50),
@Code nvarchar(3),
@Description nvarchar(80),
@ManagerUserName nvarchar(255),
@UploadPath nvarchar(80),
@Active int,
@AccessType int,
@CreatorUserName nvarchar(255),
@AllowAttachments int
AS
IF NOT EXISTS( SELECT ProjectId,Code FROM Project WHERE LOWER(Name) = LOWER(@Name) OR LOWER(Code) = LOWER(@Code) )
BEGIN
DECLARE @ManagerUserId UNIQUEIDENTIFIER
DECLARE @CreatorUserId UNIQUEIDENTIFIER
SELECT @ManagerUserId = UserId FROM aspnet_users WHERE Username = @ManagerUserName
SELECT @CreatorUserId = UserId FROM aspnet_users WHERE Username = @CreatorUserName
INSERT Project
(
Name,
Code,
Description,
UploadPath,
ManagerUserId,
CreateDate,
CreatorUserId,
AccessType,
Active,
AllowAttachments
)
VALUES
(
@Name,
@Code,
@Description,
@UploadPath,
@ManagerUserId ,
GetDate(),
@CreatorUserId,
@AccessType,
@Active,
@AllowAttachments
)
RETURN @@IDENTITY
END
ELSE
RETURN 0