I'm using a asp.net webpage having a module which is leave management system based.

If we enter the leave for more than 10 days it should check whether we have included the weekends(saturday and sunday) and should make a validation that the user has not applied any previous leave before the applied date.

i need to perform this on database table in which the all the details of the persons leave applied have been stored.

since im new with this asp.net can anyone help me out how to proceed step by step process.