locked
Resourse Reservation webpart RRS feed

  • Question

  • Hi,

    I'm developing a webpart using Visual Studio C#. My design is as follows

    calendar to select the date the user wants to reserve the resource

    Dropdown list -bind with db to get resource list

    two combo boxes- to select  required resource  starting period and ending period

    Data view- this will display resource booked period and  available period when a user select the date and the resource that he need to book

    Up to this point all are working ok.

    I m new to SharePoint and need to know do following in a site page

    I want to know how can I lock a resource from other users till one user is release it. ( mean I want to avoid same resource will book by multiple users at the same time) Without using exchange server help. Can any body give me an idea or useful link ( any useful web site or a book will be good)

    Also much appreciate any idea to improve my design.

    Thanks.


    d.n weerasinghe
    Thursday, December 29, 2011 11:31 AM

Answers

  • Hi,

    I would suggest you to approach like this:

    1. Create a list to hold your resources.

    2. Create a list to select reservations for these resources. Add a column in this list as a lookup to pick values from first list.

    3. Now include date columns for the duration.

    4. Implement event receives for ItemAdding and ItemUpdating events to check if the resource you are trying to book is already booked for the duration or not.

    Add the second list as a list viewer webpart to your site page. 

    I hope this will help you out.


    Thanks, Rahul Rashu
    Monday, January 2, 2012 7:35 PM

All replies

  • Hi!

    Can you define "Resource"?


    MVP Office Development, MCP, MCTS SharePoint 2010 Development
    Friday, December 30, 2011 2:40 AM
  • Hi Joao,

    My resources are TV,Projecter,Computer lab, etc..

    Thanks.


    d.n weerasinghe
    • Edited by newnw Friday, December 30, 2011 11:09 AM
    Friday, December 30, 2011 10:57 AM
  • Hi!

    Sorry!, You want to lock a Record in SQL Server? since is selected by a user in the combobox?


    MVP Office Development, MCP, MCTS SharePoint 2010 Development
    Monday, January 2, 2012 3:09 PM
  • Hi,

    I would suggest you to approach like this:

    1. Create a list to hold your resources.

    2. Create a list to select reservations for these resources. Add a column in this list as a lookup to pick values from first list.

    3. Now include date columns for the duration.

    4. Implement event receives for ItemAdding and ItemUpdating events to check if the resource you are trying to book is already booked for the duration or not.

    Add the second list as a list viewer webpart to your site page. 

    I hope this will help you out.


    Thanks, Rahul Rashu
    Monday, January 2, 2012 7:35 PM
  • Hi Rashu,

    Thank you very much for your help. As you mentioned I followed your steps and currently developing event receivers. 

     

    Thanks.


    d.n weerasinghe
    • Edited by Mike Walsh FIN Tuesday, January 3, 2012 1:52 PM New question removed. Start a new thread.
    Tuesday, January 3, 2012 1:51 PM