Auto Delete after time period from table

Question

Hi friends,

 

I have a table in which a customer adds his product details.

 

what i have to do is, need to delete the product after 30 days and show message before 5 days of expiry.

If possible then a email message is send at the time of deletion.

 

need help in SQL tables, procedure and c# .

 

plz help....