CREATE PROCEDURE dbo.AddMember(@Username nvarchar(50),
@Password nvarchar(50),
@MemberName nvarchar(50),
@Gender int,
@BirthDate char(100),
@CountryID int,
@CityID int,
@Profession char(50),
@JobTitle char(50),
@CompanyName char(50),
@Email nvarchar(50),
@Phone char(50),
@Mobile char(50),
@Address char(50),
@MemberPhoto char(50),
@SecurityQuestion int,
@SecurityAnswer nvarchar(255),
@HearAboutUs char(50),
@Subscribed char(1))
AS
SET NOCOUNT ON
If Len(@BirthDate) = 0
set @BirthDate = NULL
If Len(@Profession) = 0
set @Profession = NULL
If Len(@JobTitle) = 0
set @JobTitle = NULL
If Len(@CompanyName) = 0
set @CompanyName = NULL
If Len(@Phone) = 0
set @Phone = NULL
If Len(@Mobile) = 0
set @Mobile = NULL
If Len(@Address) = 0
set @Address = NULL
If Len(@MemberPhoto) = 0
set @MemberPhoto = NULL
If Len(@HearAboutUs) = 0
set @HearAboutUs = NULL
If Len(@Subscribed) = 0
set @Subscribed = 0
INSERT INTO dbo.Members
(Username, Password, MemberName, Gender, BirthDate, CountryID, CityID, Profession, JobTitle, CompanyName, Email, Phone, Mobile, Address,
MemberPhoto, SecurityQuestion, SecurityAnswer, HearAboutUs)
VALUES (@Username, @Password, @MemberName, @Gender, @BirthDate, @CountryID, @CityID, @Profession, @JobTitle, @CompanyName, @Email,
@Phone, @Mobile, @Address, @MemberPhoto, @SecurityQuestion, @SecurityAnswer, @HearAboutUs)
if (@Subscribed=1)
begin
declare @MemberID int
set @MemberID = (select @@identity as MemberID)
exec JoinElsayaratMailinglist @MemberName ,@Gender ,@BirthDate ,@CountryID ,@CityID ,@Profession ,@JobTitle ,@CompanyName ,@EMail ,@Phone ,@Mobile ,@Address, @Subscribed, @MemberID
end
GO
|
