DateTime operations in c sharp

See more:

C#

I am doing asset management system for certain bank. So in asset function their is a internal sub function called Depreciation. Depreciation means subtract the actual purchase cost after year by year.Normally we assigned book value of certain asset as 0 after ending third year of asset lifetime. :)

1. The first thing i want to know is, in Inserting Asset part their is date time piker to set Purchase Date. What i want is auto set the dispose date Date Time Piker after 3 years from purchase cost... so that thing i want some small date time operation to handle it...? :-\

2. My second question is i want to depreciate the book value of each Asset year after year. so that means i want to check whether their are any asset that fulfilled the depreciation period condition and subtract the amount from that certain asset and update asset book value details as soon as possible in page loading state...
I. Where am i use this code...?

II. How am i write this code...?

III. Wheter it wants SQL Triggers, Procedure or Function...?

Please Answer this soon as possible
You are not my boss!

*** We use Straight line depreciation.

Thank you... :cool:

1. No txtspk!
2. Elipsis is only ... not more.
3. One smiley is enough. Everybody understands your mood.
4. One ? is enough... At most two.
5. It is urgent only for you and for the people you pay to do it! Not for us!