re: DAV: How To Search Calendar For Conflicts

zille — Mon, 31 Jul 2006 13:57:01 GMT

thanks a lot. My problem is solved :)

re: DAV: How To Search Calendar For Conflicts

Matt Stehle - MSFT — Fri, 28 Jul 2006 17:08:19 GMT

This is a common mistake if I'm reading your comment correctly...

Make sure you use ">" and "<" instead of ">" or "<" because the angle brackets are reserved for XML tags. See my request above...

re: DAV: How To Search Calendar For Conflicts

zille — Fri, 28 Jul 2006 14:32:53 GMT

I am trying to query a calender folder to get the appointments with a specific data range but the exception arises that request is not right. I am not sure what is the problem with the request that i am making. can any one guide me i am posting the code:
// Variables.
System.Net.HttpWebRequest Request;
System.Net.WebResponse Response;
System.Net.CredentialCache MyCredentialCache;
string strCalendarURI = "http://EUR-MSG-01/exchange/t-annaw/calendar/";
string strUserName = "i-zilleh";
string strPassword = "zill-786";
string strDomain = "EUROPE";
string strQuery = "";
byte[] bytes = null;
System.IO.Stream RequestStream;
System.IO.Stream ResponseStream;
System.Xml.XmlDocument ResponseXmlDoc;
System.Xml.XmlNodeList SubjectNodeList;
System.Xml.XmlNodeList LocationNodeList;
System.Xml.XmlNodeList StartTimeNodeList;
System.Xml.XmlNodeList EndTimeNodeList;
System.Xml.XmlNodeList BusyStatusNodeList;
System.Xml.XmlNodeList InstanceTypeNodeList;

try
{
// Build the SQL query.
strQuery = "<?xml version=\"1.0\"?>"
+ "<g:searchrequest xmlns:g=\"DAV:\">"
+ "<g:sql>SELECT \"urn:schemas:calendar:location\", \"urn:schemas:httpmail:subject\", "
+ "\"urn:schemas:calendar:dtstart\", \"urn:schemas:calendar:dtend\", "
+ "\"urn:schemas:calendar:busystatus\", \"urn:schemas:calendar:instancetype\" "
+ "FROM Scope('SHALLOW TRAVERSAL OF \"" + strCalendarURI + "\"') "
+ "WHERE NOT \"urn:schemas:calendar:instancetype\" = 1 "
+ "AND \"DAV:contentclass\" = 'urn:content-classes:appointment' "
+ "AND \"urn:schemas:calendar:dtstart\" > '2006/07/18 00:00:00' "
+ "ORDER BY \"urn:schemas:calendar:dtstart\" ASC"
+ "</g:sql></g:searchrequest>";

// Create a new CredentialCache object and fill it with the network
// credentials required to access the server.
MyCredentialCache = new System.Net.CredentialCache();
MyCredentialCache.Add(new System.Uri(strCalendarURI),
"NTLM",
new System.Net.NetworkCredential(strUserName, strPassword, strDomain)
);

// Create the HttpWebRequest object.
Request = (System.Net.HttpWebRequest)HttpWebRequest.Create(strCalendarURI);

// Add the network credentials to the request.
Request.Credentials = MyCredentialCache;

// Specify the method.
Request.Method = "SEARCH";

// Encode the body using UTF-8.
bytes = Encoding.UTF8.GetBytes((string)strQuery);

// Set the content header length. This must be
// done before writing data to the request stream.
Request.ContentLength = bytes.Length;

// Get a reference to the request stream.
RequestStream = Request.GetRequestStream();

// Write the SQL query to the request stream.
RequestStream.Write(bytes, 0, bytes.Length);

// Close the Stream object to release the connection
// for further use.
RequestStream.Close();

// Set the content type header.
Request.ContentType = "text/xml";

// Send the SEARCH method request and get the
// response from the server.
Response = (HttpWebResponse)Request.GetResponse();

// Get the XML response stream.
ResponseStream = Response.GetResponseStream();

// Create the XmlDocument object from the XML response stream.
ResponseXmlDoc = new XmlDocument();
ResponseXmlDoc.Load(ResponseStream);

// Build a list of the urn:schemas:httpmail:subject XML nodes,
// corresponding to the calendar item subjects returned in the search request.
// The urn:schemas:httpmail: namespace is typically
// assigned the e: prefix in the XML response body.
SubjectNodeList = ResponseXmlDoc.GetElementsByTagName("e:subject");

// Build a list of the urn:schemas:calendar:location XML nodes,
// corresponding to the calendar item locations returned in the search request.
// The urn:schemas:calendar: namespace is typically
// assigned the d: prefix in the XML response body.
LocationNodeList = ResponseXmlDoc.GetElementsByTagName("d:location");

// Build a list of the urn:schemas:calendar:dtstart XML nodes,
// corresponding to the calendar item locations returned in the search request.
StartTimeNodeList = ResponseXmlDoc.GetElementsByTagName("d:dtstart");

// Build a list of the urn:schemas:calendar:dtend XML nodes,
// corresponding to the calendar item locations returned in the search request.
EndTimeNodeList = ResponseXmlDoc.GetElementsByTagName("d:dtend");

// Build a list of the urn:schemas:calendar:busystatus XML nodes,
// corresponding to the calendar item locations returned in the search request.
BusyStatusNodeList = ResponseXmlDoc.GetElementsByTagName("d:busystatus");

// Build a list of the urn:schemas:calendar:instancetype XML nodes,
// corresponding to the calendar item locations returned in the search request.
InstanceTypeNodeList = ResponseXmlDoc.GetElementsByTagName("d:instancetype");

// Loop through the returned calendar items (if any).

if (SubjectNodeList.Count > 0)
{
Console.WriteLine("Calendar items...");
for (int i = 0; i < SubjectNodeList.Count; i++)
{

// Display the subject.
Console.WriteLine(" Subject: " + SubjectNodeList[i].InnerText);

// Display the location.
Console.WriteLine(" Location: " + LocationNodeList[i].InnerText);

// Display the start time.
Console.WriteLine(" Start time: " + StartTimeNodeList[i].InnerText);

// Display the end time.
Console.WriteLine(" End time: " + Convert.ToDateTime(EndTimeNodeList[i].InnerText));

// Display the busy status.
Console.WriteLine(" Busy status: " + BusyStatusNodeList[i].InnerText);

// Display the instance type.
if (InstanceTypeNodeList[i].InnerText == "0")
Console.WriteLine(" Instance type: 0-Single appointment");
else if (InstanceTypeNodeList[i].InnerText == "1")
Console.WriteLine(" Instance type: 1-Master recurring appointment");
else if (InstanceTypeNodeList[i].InnerText == "2")
Console.WriteLine(" Instance type: 2-Single instance, recurring appointment");
else if (InstanceTypeNodeList[i].InnerText == "3")
Console.WriteLine(" Instance type: 3-Exception to a recurring appointment");
else
Console.WriteLine(" Instance type: Unknown");

Console.WriteLine("");

Console.ReadLine();
}
}

else
{
Console.WriteLine("No calendar items found ...");

}

// Clean up.
ResponseStream.Close();
Response.Close();
}
catch (Exception ex)
{
// Catch any exceptions. Any error codes from the SEARCH
// method request on the server will be caught here, also.
Console.WriteLine(ex.Message);

FYI: The Freebusy Story & New Sample Code!

The CDOs and CDONTS of Messaging Development — Tue, 13 Jun 2006 00:13:45 GMT

Many times when scheduling appointments in Exchange, especially when you are already using HTTP requests...

SAMPLES: WebDAV Samples Listing

The CDOs and CDONTS of Messaging Development — Tue, 13 Jun 2006 00:09:43 GMT

WebDAV Samples Index
&nbsp;
Listed below are links to my WebDAV samples.&nbsp; If you have questions...

DAV: How To Search Calendar For Conflicts

re: DAV: How To Search Calendar For Conflicts

re: DAV: How To Search Calendar For Conflicts

re: DAV: How To Search Calendar For Conflicts

FYI: The Freebusy Story &amp; New Sample Code!

SAMPLES: WebDAV Samples Listing

FYI: The Freebusy Story & New Sample Code!