/// <summary>
/// Main function
/// </summary>
/// <param name="args"></param>
public static void Main(string[] args)
{
//connection database
MadDogObjects.Utilities.Security.SetDB("mdsql3", "OrcasTS");
MadDogObjects.Utilities.Security.AppName = "MDTesting";
MadDogObjects.Utilities.Security.AppOwner = Environment.UserName;
Console.WriteLine("Please enter a Run ID:");
string RunID = Console.ReadLine();
int runid = int.Parse(RunID);
/*string sql = "SELECT Run.RunID As RunID, Run.Title As Title, RunOS.OSName As OSName, RunProductsBranches.BranchName As BranchName, " +
"RunOSLCIDs.LanguageLocale As OSLanguageLocale, RunProductsLCIDs.LanguageLocale As ProductLanguageLocale" +
"FROM dbo.Run WITH (NOLOCK) INNER JOIN dbo.OS As RunOS WITH(NOLOCK) ON(Run.OSID = RunOS.OSID) where(RunID in ({ 0})); ";
string sql = "SELECT Run.RunID As RunID, Run.Title As Title, RunOS.OSName As OSName, RunProductsBranches.BranchName As BranchName, " +
"RunOSLCIDs.LanguageLocale As OSLanguageLocale, RunProductsLCIDs.LanguageLocale As ProductLanguageLocale" +
"FROM dbo.Run WITH (NOLOCK) INNER JOIN dbo.OS As RunOS WITH(NOLOCK) ON (Run.OSID = RunOS.OSID) where RunID='3935639';";
*/
Run run = new Run(runid);
string branch=(run.Branch).ToString();
string Testquery=run.TestcaseQuery.ToString();
string BuildNo = run.ProductVersion.ToString();
string OS = run.OS.ToString();
string b=run.GetResultsSummary().ToString();
// Console.WriteLine("buildno: " + BuildNo);
// Console.WriteLine("runid: "+runid);
// Console.WriteLine("OS: " + OS);
// Console.WriteLine("branch: " + branch);
// Console.WriteLine("Testquery: ");
// Console.WriteLine("Final PR: ");
Console.WriteLine("c:");
// Console.WriteLine(b);
Console.ReadKey();
}