CREATE PROCEDURE [dbo].[csp_consumer_signup]
@Consumer_Firstname varchar(100),
@Consumer_Lastname varchar(100),
@gender varchar(30),
@User_ID varchar(50),
@password varchar(100)
AS
BEGIN
if((select count(*) from tbl_user_login where User_ID=User_ID)< 0)
Begin
INSERT INTO tbl_user_login
(
User_ID,
password,
last_login,
role,
updated_id,
updated_date,
created_date,
active_flag
)
VALUES
(
@User_ID,
@password,
GETUTCDATE(),
'Consumer',
@User_ID,
GETUTCDATE(),
GETUTCDATE(),
'true'
)
INSERT INTO consumer_details
(
Consumer_Firstname,
Consumer_Lastname,
last_update_uid,
last_update_date
)
VALUES
(
@Consumer_Firstname,
@Consumer_Lastname,
@User_ID,
GETUTCDATE()
)
End