How perform created_by and updated_by in store procedure?

Atul Patil

10y1.2k

How perform following operation in Insert and Update store procedure?

I want to implement an abstract entity from which I will derive my entities. This abstract entity will contain the common fields like:

Key (int)
CreatedBy (String)
UpdatedBy (String)
CreatedDate (DateTime)
UpdatedDate (DateTime)

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vishal Jadav10y ago
Accepted answer
Hi,
Whats the issue you are facing in it ?

Because you need to do it this way only by passing insertby or updateby id from the code it self.

I think this is the right way of doing it.

Thanks.
0
Atul Patil10y ago
ALTER PROCEDURE [dbo].[insert_user]
@firstname varchar(50),
@lastname varchar(50),
@email varchar(100),
@contact varchar(15),
@address1 varchar(500),
@address2 varchar(500),
@city varchar(50),
@country varchar(50),
@created_by int,
@user_type int,
@user_role int
AS
Begin
begin try
begin transaction insertTrans
IF (SELECT COUNT(*) FROM [dbo].[user] WHERE first_name = @firstname AND last_name=@lastname and email=@email and contact=@contact) = 0
begin
insert into [dbo].[user]
(
[first_name],
[last_name],
[email],
[contact],
[address1],
[address2],
[city],
[country],
[created_at],
[created_by],
[updated_at],
[updated_by],
[user_type],
[user_role],
[is_active]
)
values
(
@firstname ,
@lastname ,
@email ,
@contact ,
@address1 ,
@address2 ,
@city ,
@country ,
getdate() ,
@created_by ,
getdate(),
@created_by,
@user_type,
@user_role,
'1'
)
end
commit transaction insertTrans
end try
begin catch
throw

rollback transaction insertTrans

end catch
END
0
Manas Mohapatra10y ago
What is the issue you are facing now..please share details..
0
Vishal Jadav10y ago
Hi,
If possible you can pass the operatorid in UpdatedBy / CreatedBy for further use.
If possible can you provide the stored procedure ?
Thank you,
Jadav Vishal
0
Ehsan Sajjad10y ago
can you show your stored procedure, how you have wrote it ?
0