event / Venue / allied services / booking system

We require a venue booking system to be written in dotnet using c#. 3 tiered programming structure. Inline SQL statements. No LINQ. No Stored Procedures. System must allow admin users to add/edit multiple rooms within venue. Rooms can be booked per day or per hour with each room having different opening and closing times. Different rooms will have different hourly and daily price. Price will also be different if user is member of venue so each room needs 4 prices :Member per hour, member per day, non member per hour, non member per day. User to tick box if member. Rooms can only be booked in hourly blocks (no part hours), or for entire day. Room time selection will be based around a calendar, with each day showing with the number of hours available for that room to be booked. User to be able to select room times by clicking on hourly slots available or click and drag to colour in number of hours. Bookings can be recurring (eg, same time each day for 5 weeks) User to receive receipt upon payment (Payment gateway already in place) User to be able to see via calendar which days/times each room is available for booking. Admin user to be able to run reports on bookings an also edit bookings to move users from one room to another, or to alter date/time of booking. Admin user should be able to block out times / days when the room is not available for booking. All source code to be provided upon completion of project. No code is to be included in dll's. System must be configured for mobile use as well as desktop (responsive html design) This will be in the lines of [login to view URL]