public static void CheckAzureDBConnectivity()
{
DatabaseUtility.SQLConnectionString = "Data Source=tczxnf5cbu.database.windows.net;Initial Catalog=ArchiveService;Integrated Security=false;User ID=cxp;Password=ConferenceXP!";
if (DatabaseUtility.CheckConnectivity())
{
Debug.WriteLine("Azure database is alive.");
Conference[] confs = DatabaseUtility.GetConferences();
}
else
{
Debug.WriteLine("Azure database is not alive.");
}
}
private void lookupThreadProc()
{
working.Reset();
if (!DatabaseUtility.CheckConnectivity())
{
done = true;
sqlConnectError = true;
working.Set();
return;
}
Conference[] confs = DatabaseUtility.GetConferences();
this.conferenceData = new ArrayList();
participantCount = DatabaseUtility.CountParticipants();
if (participantCount < 1)
{
done = true;
sqlConnectError = false;
working.Set();
return;
}
currentParticipant = 0;
foreach (Conference c in confs)
{
if (stopNow)
{
break;
}
ConferenceWrapper cw = new ConferenceWrapper();
cw.Conference = c;
cw.Description = "Conference: " + c.Start.ToString() + " - " + c.Description;
cw.Participants = new ArrayList();
Participant[] participants = DatabaseUtility.GetParticipants(c.ConferenceID);
foreach (Participant part in participants)
{
if (stopNow)
{
break;
}
ParticipantWrapper pw = new ParticipantWrapper();
pw.Description = "Participant: " + part.CName;
pw.Participant = part;
pw.StreamGrouper = new StreamGrouper(part.CName);
//Here is the slow part:
Stream[] streams = DatabaseUtility.GetStreams(part.ParticipantID);
currentParticipant++;
if (streams == null)
{
continue;
}
foreach (Stream str in streams)
{
pw.StreamGrouper.AddStream(str);
}
//Only show the participants that sent some supported data
if (pw.StreamGrouper.GroupCount > 0)
{
cw.Participants.Add(pw);
}
}
conferenceData.Add(cw);
}
done = true;
working.Set();
}