none
Update Status In Data Base (SQL Server) While Accept the Appointment RRS feed

  • Question

  • Dear All,

    I have to do functionality like Any user will Accept the Appointment then status will be updated in database table(SQL Server 2008).

    I have to do this functionality using Exchange Server 2007 SP1 and  EWS.

    How can i achieve this functionality ? How can i fire Accept event for User who get the Email for Meeting or other event ?  

    Kindly Reply.

    Thanks and Regards,

    Hardik Ramwani

    Wednesday, July 3, 2013 10:38 AM

All replies

  • When somebody clicks accept on a Meeting Invitation there no specific Server sides events that will fire for the accept in Outlook Web Access. On the Server what happens in the Appointment would get created in the Attendees Mailbox, the Invite would be deleted and a Response would be sent to the Organizer. These will fire Exchange Web Services notifications on the Calendar, Inbox and Sent Items folder for the Creation of the appointment and deletion of the invite message.

    You would also get a Notification on the Appointment owners mailbox when the meeting responses are processed and the original appointment is updated. I would suggest monitoring the Source Meeting object rather then the attendees would be an easier way of keeping tracking of meeting responses.

    Either way you can look at using EWS Notifications to capture this http://blogs.msdn.com/b/vikas/archive/2007/08/28/ews-exchange-2007-notification-subsystem.aspx.

    An alternative if you users are using Outlook you could write a Outlook Plug in to capture the action at the client side.

    Cheers
    Glen

    Thursday, July 4, 2013 7:28 AM
  • Hello Glen,

    Yes we have option of Outlook Plug, But i think so that we have to install that plugin in all the machine.

    And also any updates will occur than we have to Modify that plugin, that will increase the maintenance work for client.

    Is there any way to install  plugin to all the machine, with Same Exchange Server.

    Ex. - 5 different Users at 5 Different Machine  with Outlook.

    And also for "EWS Notifications" is there any specific sample available that will help me more, As i have not much idea about  EWS Notifications.

    Thanks And Regards,

    Hardik Ramwani

    Friday, July 5, 2013 10:57 AM
  • Plugins need to be deployed to workstations so use what every Software delivery mechansim you have available or something like http://www.symantec.com/business/support/index?page=content&id=HOWTO74984 (Exchange itself has no mechanisms to deploy these)

    For EWS notificaitons see

    http://exchangenotification.codeplex.com/

    and

    http://blogs.msdn.com/b/emeamsgdev/archive/2012/12/20/ews-push-notification-sample.aspx

    Cheers
    Glen

    Friday, July 5, 2013 11:37 PM