how to create AuditTrail For EmployeeAbsence

Question

0.00/5 (No votes)

See more:

Hii All,

I want to create Audit trail for EmployeeAbsence. In which employee can request for his leave, update his leave , adjust his leave and all. Firstly i was thinking to simply apply trigger for that but then i realised that trigger makes application slower.

Please suggest me how to Create Audit trail for my requirement?

Posted 27-Aug-13 20:05pm

Torakami

Updated 27-Aug-13 20:26pm

v2

Add a Solution

Comments

Manikandan Sekar 2-Sep-13 3:00am

What you are asking is a project. If you want someone to do your project means hire someone. If you want create on your own means Google it and get some ideas. Start your move and ask help when you stuck anywhere means.

Torakami 2-Sep-13 10:38am

What i meant was if trigger is safer or shall go for dynamic changes

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Answer 1 · 2013-09-10T05:00:00

Solution 1

You could use Trigger or Stored procedure.
Store Procedure for Audit Trial in SQL[^]

Posted 10-Sep-13 5:00am

thatraja

Comments

Torakami 11-Sep-13 3:43am

Thnaks but my work is already done .. i had gone for dynamic updates using methods and from there i am updating and creating table changes .. i did so much research on topic and came to know that using store procedure is quite slower the process on the server side ...

thatraja 11-Sep-13 5:02am

I don't think so, stored procedure could reduce many headaches. And you could reuse the code for some other places & it's faster. Anyway glad to know that you have solved the issue yourself. If possible please share what you did, which could help others in future.