public static void DisconnectQCServer()
{
if (IsProjectConnected)
{
mTDConn.DisconnectProject();
}
if (IsServerConnected)
{
mTDConn.Logout();
}
if (mTDConn != null && mTDConn.Connected)
{
mTDConn.Disconnect();
}
}
protected void Disconnect()
{
try
{
if (tdc.Connected)
{
if (tdc.LoggedIn)
{
if (tdc.ProjectConnected)
{
tdc.Disconnect();
}
tdc.Logout();
}
tdc.ReleaseConnection();
}
}
catch (COMException ce)
{
rr.AddErrorLine(HandleException(ce));
}
}
public static string ReportResults(List<Results> results, string runName, string userName, string password)
{
string rc = "Nothing Reported";
if (runName != null && userName != null && password != null)
{
TDConnection connection = null;
try
{
connection = new TDConnection();
String URL = "http://hpqualitycenter/qcbin/";
String domainName = "Default";
String projectName = "Production";
//Response.Write("Server:" + URL + " Domain:" + domainName + " Project:" + projectName + "<br/>");
//Prompt for QC credentials.
connection.InitConnectionEx(URL);
connection.Login(userName, password);
connection.Connect(domainName, projectName);
//Response.Write("Opening Connection <br/>");
//Response.Write("Connection Status: " + (connection.Connected ? "connected" : "not connected") + "<br/>");
if (connection != null && connection.Connected)
{
foreach (Results r in results)
{
TestSetTreeManager treeManager = (TestSetTreeManager)connection.TestSetTreeManager;
//Response.Write("Folder: " + rootPathPrefix + path + " <br/>");
TestSetFolder folder = (TestSetFolder)treeManager.get_NodeByPath(rootPathPrefix + r.Path);
TestSetFactory tFactory = (TestSetFactory)folder.TestSetFactory;
TDFilter tFilter = (TDFilter)tFactory.Filter;
tFilter["TS_TEST_ID"] = r.Id;
//http://atg05-yyz/YUI/ReportResultToQC.aspx?id=2367453&path=BlackBerry%20Developer%20Tools\Sandbox&result=0
if (r.Id != null)
{
//Response.Write("testId= " + testId + " result= " + result + "<br/>");
List tests = folder.FindTestInstances("", false, tFilter.Text);
if (tests.Count == 1)
{
TSTest t = (TSTest)tests[1];
//Response.Write(t.ID + " " + t.Status + " " + t.Name + " " + "<br/>");
RunFactory runFactory = (RunFactory)t.RunFactory;
Run newRun = (Run)runFactory.AddItem(runName);
switch (r.Result)
{
case 0:
newRun.Status = @"FAILED";
break;
case 1:
newRun.Status = @"PASSED";
break;
case 2:
newRun.Status = @"N/A";
break;
}
//Response.Write("Status = " + newRun.Status + "<br/>");
newRun.Post();
rc = "Success";
}
else
{
rc = "Error: Multiple Tests Returned for ID # " + r.Id;
break;
}
}
else
{
rc = "No Test Specified";
break;
}
}//foreach result
}//if connection
else
rc = "Connection to QC could not be established";
}
catch (Exception ex)
{
rc = ex.Message;
}
finally
{
if (connection != null)
{
if (connection.Connected)
connection.Disconnect();
if (connection.LoggedIn)
connection.Logout();
connection.ReleaseConnection();
connection = null;
}
}
}
return rc;
}
private static void ExportRequirements()
{
string server_url = ConfigurationManager.AppSettings["SERVER_URL"];
string username = ConfigurationManager.AppSettings["USER_NAME"];
string password = ConfigurationManager.AppSettings["PASSWORD"];
string domain = ConfigurationManager.AppSettings["DOMAIN"];
string project = ConfigurationManager.AppSettings["PROJECT"];
string req_file = ConfigurationManager.AppSettings["REQUIREMENTS_FILE"];
string att_file = ConfigurationManager.AppSettings["ATTACHMENTS_FILE"];
string att_path = ConfigurationManager.AppSettings["ATTACHMENTS_PATH"];
if (!Directory.Exists(att_path))
{
Directory.CreateDirectory(att_path);
}
TDConnection tdc = new TDConnection();
tdc.InitConnectionEx(server_url);
tdc.ConnectProjectEx(domain, project, username, password);
Console.WriteLine("Connected to QC Server");
ReqFactory req_factory = (ReqFactory)tdc.ReqFactory;
TDFilter req_filter = (TDFilter)req_factory.Filter;
/**
* Set your own filters for requirements below
*/
// req_filter["RQ_REQ_PATH"] = "AAAAAGAAE*";
StreamWriter rfs = new StreamWriter(File.Open(req_file, FileMode.Create),
Encoding.Default,
1024);
StreamWriter afs = new StreamWriter(File.Open(att_file, FileMode.Create),
Encoding.Default,
1024);
foreach (Req r in req_filter.NewList())
{
string name = r.Name.Replace("\"","").Replace("\t","").Trim();
Console.WriteLine("Req \"{0}\"", name);
rfs.WriteLine(String.Join("\t", new String[]{
r.ID.ToString(),
r.ParentId.ToString(),
r["RQ_REQ_PATH"],
name,
r["RQ_VTS"].ToString()
}));
if (!r.HasAttachment)
continue;
AttachmentFactory att_factory = r.Attachments;
foreach (Attachment a in att_factory.NewList(""))
{
Console.WriteLine("Attachment \"{0}\"", a.Name);
afs.WriteLine(String.Join("\t", new String[]{
r.ID.ToString(),
a.ID.ToString(),
a.Name,
a.FileSize.ToString(),
a.LastModified.ToShortDateString()
}));
IExtendedStorage storage = a.AttachmentStorage;
storage.ClientPath = Path.GetFullPath(att_path) + "\\";
storage.Load(a.Name, true);
}
}
rfs.Close();
afs.Close();
tdc.Disconnect();
tdc.Logout();
Console.WriteLine("Disconnected.");
}
private static void ExportRequirements()
{
string server_url = ConfigurationManager.AppSettings["SERVER_URL"];
string username = ConfigurationManager.AppSettings["USER_NAME"];
string password = ConfigurationManager.AppSettings["PASSWORD"];
string domain = ConfigurationManager.AppSettings["DOMAIN"];
string project = ConfigurationManager.AppSettings["PROJECT"];
string req_file = ConfigurationManager.AppSettings["REQUIREMENTS_FILE"];
string att_file = ConfigurationManager.AppSettings["ATTACHMENTS_FILE"];
string att_path = ConfigurationManager.AppSettings["ATTACHMENTS_PATH"];
if (!Directory.Exists(att_path))
{
Directory.CreateDirectory(att_path);
}
TDConnection tdc = new TDConnection();
tdc.InitConnectionEx(server_url);
tdc.ConnectProjectEx(domain, project, username, password);
Console.WriteLine("Connected to QC Server");
ReqFactory req_factory = (ReqFactory)tdc.ReqFactory;
TDFilter req_filter = (TDFilter)req_factory.Filter;
/**
* Set your own filters for requirements below
*/
// req_filter["RQ_REQ_PATH"] = "AAAAAGAAE*";
StreamWriter rfs = new StreamWriter(File.Open(req_file, FileMode.Create),
Encoding.Default,
1024);
StreamWriter afs = new StreamWriter(File.Open(att_file, FileMode.Create),
Encoding.Default,
1024);
foreach (Req r in req_filter.NewList())
{
string name = r.Name.Replace("\"", "").Replace("\t", "").Trim();
Console.WriteLine("Req \"{0}\"", name);
rfs.WriteLine(String.Join("\t", new String[] {
r.ID.ToString(),
r.ParentId.ToString(),
r["RQ_REQ_PATH"],
name,
r["RQ_VTS"].ToString()
}));
if (!r.HasAttachment)
{
continue;
}
AttachmentFactory att_factory = r.Attachments;
foreach (Attachment a in att_factory.NewList(""))
{
Console.WriteLine("Attachment \"{0}\"", a.Name);
afs.WriteLine(String.Join("\t", new String[] {
r.ID.ToString(),
a.ID.ToString(),
a.Name,
a.FileSize.ToString(),
a.LastModified.ToShortDateString()
}));
IExtendedStorage storage = a.AttachmentStorage;
storage.ClientPath = Path.GetFullPath(att_path) + "\\";
storage.Load(a.Name, true);
}
}
rfs.Close();
afs.Close();
tdc.Disconnect();
tdc.Logout();
Console.WriteLine("Disconnected.");
}
