.net - How to implement a MVC 4 change log? -


i developing mvc 4 application. client wants have change log, can view fields have been changed. should show old value , new value, in case of edit. if delete, should show row deleted.

whats best way achieve this?

just clarify.. changes actual data in database..

ie might have record of customer names , addresses.. user might update addresses.. need ability see user changed.. old data , new data

thanks...

this typically done using triggers in database. create audit table, , create triggers catch each change , record them.

an article talking here:

http://www.codeproject.com/articles/441498/quick-sql-server-auditing-setup

more recent versions of sql server have auditing built-in, in enterprise editions quite spendy.. people don't have access these features.

another option, , cannot speak how works, third party tools claim add auditing capability. example, simple google search found these:

http://krell-software.com/omniaudit/

https://renholdsoftware.com/sqltableaudit


Comments

Post a Comment

Popular posts from this blog

java.util.scanner - How to read and add only numbers to array from a text file -

i'm learning java , have question regarding reading file want read numbers file contains strings well. here example of file: 66.56 "3 java 3-43 5-42 2.1 1 and here coding: public class test { public static void main (string [] args){ if (0 < args.length) { file x = new file(args[0]); try{ scanner in = new scanner( new fileinputstream(x)); arraylist<double> test = new arraylist<>(); while(in.hasnext()){ if(in.hasnextdouble()){ double f=in.nextdouble(); test.add(f);} else {in.next();} } catch(ioexception e) { system.err.println("exception during reading: " + e); } } my problem add 66.56,2.1 , 1 doesn't add 3 after "3 or ignores 3-43 , 5-42 can tell me how skip strings , add doubles here? thanks all said 3 ie; "3, 3-43 , 4-42 strings either u read string , split , check number @ " , - or put in space between characters , integers. jvm after compilation tre
Read more

rewrite - Trouble with Wordpress multiple custom querystrings -

i'm working on adding multiple querystring , doesn't seem work. i've found codes seems work others might i'm missing something. i want like: http://mydomain.com/board/?getyear=2013&getsometext2=sometext to http://mydomain.com/board/2013/sometext/ i added code below functions.php file. doesn't seem work should though. this works. echoing querystring gets both variable without problem. http://mydomain.com/board/2013/sometext/ but doesn't. tested querystring vis isset() seems nothing being set/get http://mydomain.com/board/2013/ function add_query_vars($vars) { $vars[] = "getyear"; $vars[] = "getsometext2"; return $vars; } add_filter('query_vars', 'add_query_vars'); function add_rewrite_rules($arules) { $anewrules = array('board/([^/]+)/([^/]+)/?$' => 'index.php?pagename=board&getyear=$matches[1]&getsometext2=$matches[2]'); $arules = $a
Read more

debian - 500 Error upon login into Plesk Admin - auth.php3? -

hello , reading this, i'm suffering 500 error after login admin panel on plesk 11.5.30. if incorrect user/pass input lgin form returns correct response. however upon successful login page jumps 500 error. i've tried using following command: /usr/bin/sw-engine-cgi -c /usr/local/psa/admin/conf/php.ini -d auto_prepend_file=auth.php3 -u psaadm this returns following: php warning: unknown: failed open stream: no such file or directory in unknown on line 0 php warning: unknown: failed open stream: no such file or directory in unknown on line 0 php fatal error: unknown: failed opening required 'auth.php3' (include_path='/opt/psa/admin/plib:/opt/psa/admin/externals') in unknown on line 0 status: 500 internal server error content-type: text/html restarting plesk achieves: /etc/init.d/psa start [ ok ing psa... [....] starting plesk engine pool manager: sw-engine-fpm. done starti
Read more