How To Compare Date In Asp.net.

Two Solution:
1.If you want new record every time for booking than:
Add a column name like BookingYear. Now every-time user book cylinder new entry will be made with current date's year in this column. Now run following query before saving or booking:

Select * from table1 where BookingYear = '2014'

(like for the year of 2014).

Now if the Rows.count for this query is greater than equal to 9, than show message.

2.If you want 1 row for a year then add column to table like 'CylinderBookCount'. Every time user make a book uodate this table by increasing the amount in this column.

Now before booking cylinder add check like

Select CylinderBookCount from table1 where UserID = 'CopyOrAnyUniqueIDOfUser' BookingYear = '2014' 

Now if this return column haveing value then greater than equal to 9, than show message.

You should select all booking data from your database table for that user for that year then test the count, like in the next code where I am using EF:

DateTime now = DateTime.Now;
var searchResults = dataContext.UserBookings.Where(c => c.UserID == userID && c.StartDate >= now);
//
if(searchResults.Count  + newAmount <= 9)
  return true; //You can enable the new order! 

Hi Amiet_Mhaske,

Add a field in your table having name as BookingCounter.
When user wants to book one more then update this field.
Before update check whether this value is lesthan or equalto (<=) 9
if this condition then do the update.

Thanks,
Sibassis