Example #1
0
        public string ExportTestSteps(string token, string accountName = "", string projectName = "")
        {
            try
            {
                string exportPath  = string.Empty;
                string environment = ConfigurationManager.AppSettings["environment"];
                if (environment == Constants.DevEnvironment)
                {
                    accountName = "tooldemo";
                    projectName = "tooldemoproject";
                    token       = ConfigurationManager.AppSettings["PAT"];
                }
                VMRootTestCase vmRootTestCase = new VMRootTestCase();
                VMProject      vmProject      = new VMProject();
                vmProject.Plans = new List <VMPlan>();
                List <string> wiIdList  = new List <string>();
                string        wiIds     = string.Empty;
                int           wiIDCount = 0;
                CLProfile     profile   = new CLProfile(token);
                CLWorkItem    workItem  = new CLWorkItem(token);


                ADOCLProjects projects           = new ADOCLProjects(token);
                var           getProjectResponse = projects.GetProjects(accountName);
                List <Value>  projectDetails     = new List <Value>();
                projectDetails = JsonConvert.DeserializeObject <List <Value> >(JsonConvert.SerializeObject(getProjectResponse.ResponseAsDynamicObj.value));

                var projectDetail = projectDetails.FirstOrDefault(x => x.name.ToLower() == projectName.ToLower());

                vmProject.Id   = projectDetail.id;
                vmProject.Name = projectDetail.name;

                ADOCLTest testPlan = new ADOCLTest(token);

                var testPlanResponse = testPlan.GetTestPlans(accountName, projectDetail.name);
                foreach (var testPan in testPlanResponse.ResponseAsDynamicObj.value)
                {
                    var vmTestPlan = new VMPlan();
                    vmTestPlan.Id     = Convert.ToString(testPan.id);
                    vmTestPlan.Name   = Convert.ToString(testPan.name);
                    vmTestPlan.Suites = new List <VMSuite>();
                    var testSuites = testPlan.GetTestSuitesByTestPlanId(accountName, projectDetail.name, vmTestPlan.Id);
                    foreach (var suite in testSuites.ResponseAsDynamicObj.value)
                    {
                        var vmTestSuites = new VMSuite();
                        vmTestSuites.Id        = Convert.ToString(suite.id);
                        vmTestSuites.Name      = Convert.ToString(suite.name);
                        vmTestSuites.TestCases = new List <VMTestcase>();

                        var testCases = testPlan.GetTestCasesByPlanIdAndSuiteId(accountName, projectDetail.name, vmTestPlan.Id, vmTestSuites.Id);

                        foreach (var testCase in testCases.ResponseAsDynamicObj.value)
                        {
                            wiIDCount++;
                            var vmTestCase = new VMTestcase();
                            vmTestCase.Id = Convert.ToInt32(testCase.testCase.id);
                            wiIds         = wiIds + "," + vmTestCase.Id;
                            vmTestSuites.TestCases.Add(vmTestCase);
                        }
                        vmTestPlan.Suites.Add(vmTestSuites);
                        //break;
                    }

                    vmProject.Plans.Add(vmTestPlan);
                    //break;
                }

                wiIds = wiIds.Trim(',');
                var commanSeparatedWIs = wiIds.WIAsList();

                foreach (var wItemIds in commanSeparatedWIs)
                {
                    var getWIResponse = workItem.GetWIByIds(accountName, projectDetail.name, wItemIds);
                    var steps         = JsonConvert.DeserializeObject <CLTestCase.CLTestCaseDetail>(getWIResponse.ResponseAsString);

                    foreach (var wi in steps.value)
                    {
                        foreach (var plans in vmProject.Plans)
                        {
                            foreach (var suites in plans.Suites)
                            {
                                foreach (var testcases in suites.TestCases)
                                {
                                    var testCases = suites.TestCases.FirstOrDefault(x => x.Id == wi.id);
                                    if (testCases != null)
                                    {
                                        suites.TestCases.FirstOrDefault(x => x.Id == wi.id).Name  = wi.fields.Title;
                                        suites.TestCases.FirstOrDefault(x => x.Id == wi.id).Steps = new List <Step>();
                                        if (wi.fields.Steps != null)
                                        {
                                            System.Xml.XmlDocument doc = new System.Xml.XmlDocument();
                                            doc.LoadXml(wi.fields.Steps);
                                            string jsonText = JsonConvert.SerializeXmlNode(doc).Replace(@"&nbsp;", "").Replace(@"@", "").Replace(@"#", "").Replace(@"<DIV>", "").Replace(@"<\DIV>", "");

                                            var t = Regex.Replace(jsonText, "<.*?>", String.Empty);

                                            var steps1 = JsonConvert.DeserializeObject <CLSteps.CLStepsTemplate>(t);
                                            foreach (var stepParams in steps1.Steps.step)
                                            {
                                                var newSteps = new Step();
                                                newSteps.Id        = stepParams.id;
                                                newSteps.StepNames = new List <string>();
                                                foreach (var stepItem in stepParams.parameterizedString)
                                                {
                                                    newSteps.StepNames.Add(stepItem.text);
                                                }
                                                suites.TestCases.FirstOrDefault(x => x.Id == wi.id).Steps.Add(newSteps);
                                            }
                                        }
                                    }
                                }
                            }
                        }
                    }
                }

                using (ExcelPackage xp = new ExcelPackage())
                {
                    string jsom          = JsonConvert.SerializeObject(vmProject);
                    int    startRow      = 2;
                    int    totalColCount = 5;
                    var    workSheet     = xp.Workbook.Worksheets.Add("Sheet1");
                    workSheet.TabColor         = System.Drawing.Color.Black;
                    workSheet.DefaultRowHeight = 12;
                    workSheet.Row(1).Height    = 20;
                    workSheet.Cells[1, 1, 1, 5].Style.Border.BorderAround(ExcelBorderStyle.Thick);
                    workSheet.Row(1).Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
                    workSheet.Row(1).Style.Font.Bold           = true;
                    workSheet.Cells[1, 1].Value = "PlanName";
                    workSheet.Cells[1, 2].Value = "Suite";
                    workSheet.Cells[1, 3].Value = "TestCase";
                    workSheet.Cells[1, 4].Value = "Steps";
                    workSheet.Cells[1, 5].Value = "Expected Result";
                    int startStyle = 2;
                    foreach (var plans in vmProject.Plans)
                    {
                        startStyle = startRow;
                        workSheet.Cells[startRow, 1].Value = plans.Name;
                        foreach (var suites in plans.Suites)
                        {
                            bool stepsExists = false;
                            workSheet.Cells[startRow, 2].Value = suites.Name;
                            foreach (var testcases in suites.TestCases)
                            {
                                workSheet.Cells[startRow, 3].Value = testcases.Name;
                                int i = 1;
                                foreach (var stepParams in testcases.Steps)
                                {
                                    stepsExists = true;
                                    bool isExpectedResult = false;
                                    foreach (var stepItem in stepParams.StepNames)
                                    {
                                        if (!isExpectedResult)
                                        {
                                            workSheet.Cells[startRow, 4].Value = "Step " + i + " : " + stepItem;
                                            isExpectedResult = true;
                                            i++;
                                        }
                                        else
                                        {
                                            workSheet.Cells[startRow, 5].Value = stepItem;
                                            isExpectedResult = false;
                                        }
                                    }

                                    if (stepParams.StepNames.Count > 0)
                                    {
                                        startRow++;
                                    }
                                }
                                startRow++;
                            }
                            if (!stepsExists)
                            {
                                startRow++;
                            }
                        }
                        startRow++;
                    }

                    for (int i = 1; i < totalColCount + 1; i++)
                    {
                        workSheet.Column(i).AutoFit();
                    }
                    exportPath = DriveInfo.GetDrives()[0] + @"ExportExcel\";
                    if (!Directory.Exists(exportPath))
                    {
                        Directory.CreateDirectory(exportPath);
                    }
                    exportPath = string.Format(@"{0}{1}_{2}.xlsx", exportPath, projectName, DateTime.Now.ToString("yyyyMMddHHssss"));
                    xp.SaveAs(new System.IO.FileInfo(exportPath));
                }


                return(exportPath);
            }
            catch (Exception)
            {
                return(Constants.Failed);
            }
        }
Example #2
0
        public VMProject TestCaseDetails(string token, string accountName = "", string projectName = "")
        {
            try
            {
                accountName = "tooldemo";
                projectName = "tooldemoproject";

                VMRootTestCase vmRootTestCase = new VMRootTestCase();
                VMProject      vmProject      = new VMProject();
                vmProject.Plans = new List <VMPlan>();
                List <string> wiIdList  = new List <string>();
                string        wiIds     = string.Empty;
                int           wiIDCount = 0;
                CLProfile     profile   = new CLProfile(token);
                CLWorkItem    workItem  = new CLWorkItem(token);

                var       profiles = profile.GetCurrentProfile();
                CLAccount account  = new CLAccount(token, Convert.ToString(profiles.ResponseAsDynamicObj.id));
                var       accounts = account.GetListAccounts();

                List <CLMAccount> acc = new List <CLMAccount>();
                acc = JsonConvert.DeserializeObject <List <CLMAccount> >(accounts.ResponseAsString);
                var accountDetails = acc.FirstOrDefault(x => x.AccountName == accountName);



                ADOCLProjects projects           = new ADOCLProjects(token);
                var           getProjectResponse = projects.GetProjects(accountDetails.AccountName);
                List <Value>  projectDetails     = new List <Value>();
                projectDetails = JsonConvert.DeserializeObject <List <Value> >(JsonConvert.SerializeObject(getProjectResponse.ResponseAsDynamicObj.value));

                var projectDetail = projectDetails.FirstOrDefault(x => x.name == projectName);

                vmProject.Id   = projectDetail.id;
                vmProject.Name = projectDetail.name;

                ADOCLTest testPlan = new ADOCLTest(token);

                var testPlanResponse = testPlan.GetTestPlans(accountDetails.AccountName, projectDetail.name);
                //deCounter = testPlanResponse.ResponseAsDynamicObj.value.Count;
                foreach (var testPan in testPlanResponse.ResponseAsDynamicObj.value)
                {
                    var vmTestPlan = new VMPlan();
                    vmTestPlan.Id     = Convert.ToString(testPan.id);
                    vmTestPlan.Name   = Convert.ToString(testPan.name);
                    vmTestPlan.Suites = new List <VMSuite>();
                    var testSuites = testPlan.GetTestSuitesByTestPlanId(accountDetails.AccountName, projectDetail.name, vmTestPlan.Id);
                    foreach (var suite in testSuites.ResponseAsDynamicObj.value)
                    {
                        var vmTestSuites = new VMSuite();
                        vmTestSuites.Id        = Convert.ToString(suite.id);
                        vmTestSuites.Name      = Convert.ToString(suite.name);
                        vmTestSuites.TestCases = new List <VMTestcase>();

                        var testCases = testPlan.GetTestCasesByPlanIdAndSuiteId(accountDetails.AccountName, projectDetail.name, vmTestPlan.Id, vmTestSuites.Id);

                        foreach (var testCase in testCases.ResponseAsDynamicObj.value)
                        {
                            wiIDCount++;
                            var vmTestCase = new VMTestcase();
                            vmTestCase.Id = Convert.ToInt32(testCase.testCase.id);
                            wiIds         = wiIds + "," + vmTestCase.Id;
                            vmTestSuites.TestCases.Add(vmTestCase);
                        }
                        vmTestPlan.Suites.Add(vmTestSuites);
                        //break;
                    }

                    vmProject.Plans.Add(vmTestPlan);
                    //break;
                }

                wiIds = wiIds.Trim(',');
                var commanSeparatedWIs = wiIds.WIAsList();

                foreach (var wItemIds in commanSeparatedWIs)
                {
                    var getWIResponse = workItem.GetWIByIds(accountDetails.AccountName, projectDetail.name, wItemIds);
                    var steps         = JsonConvert.DeserializeObject <CLTestCase.CLTestCaseDetail>(getWIResponse.ResponseAsString);

                    foreach (var wi in steps.value)
                    {
                        foreach (var plans in vmProject.Plans)
                        {
                            foreach (var suites in plans.Suites)
                            {
                                foreach (var testcases in suites.TestCases)
                                {
                                    var testCases = suites.TestCases.FirstOrDefault(x => x.Id == wi.id);
                                    if (testCases != null)
                                    {
                                        suites.TestCases.FirstOrDefault(x => x.Id == wi.id).Name  = wi.fields.Title;
                                        suites.TestCases.FirstOrDefault(x => x.Id == wi.id).Steps = new List <Step>();
                                        if (wi.fields.Steps != null)
                                        {
                                            System.Xml.XmlDocument doc = new System.Xml.XmlDocument();
                                            doc.LoadXml(wi.fields.Steps);
                                            string jsonText = JsonConvert.SerializeXmlNode(doc).Replace(@"&nbsp;", "").Replace(@"@", "").Replace(@"#", "").Replace(@"<DIV>", "").Replace(@"<\DIV>", "");

                                            var t = Regex.Replace(jsonText, "<.*?>", String.Empty);

                                            var steps1 = JsonConvert.DeserializeObject <CLSteps.CLStepsTemplate>(t);
                                            foreach (var stepParams in steps1.Steps.step)
                                            {
                                                var newSteps = new Step();
                                                newSteps.Id        = stepParams.id;
                                                newSteps.StepNames = new List <string>();
                                                foreach (var stepItem in stepParams.parameterizedString)
                                                {
                                                    newSteps.StepNames.Add(stepItem.text);
                                                }
                                                suites.TestCases.FirstOrDefault(x => x.Id == wi.id).Steps.Add(newSteps);
                                            }
                                        }
                                    }
                                }
                            }
                        }
                    }
                }



                return(vmProject);
            }
            catch (Exception)
            {
                return(null);
            }
        }
Example #3
0
        public ExcelPackage ExportTestCases(string token, string accountName = "", string projectName = "")
        {
            try
            {
                accountName = "tooldemo";
                projectName = "tooldemoproject";

                VMRootTestCase vmRootTestCase = new VMRootTestCase();
                VMProject      vmProject      = new VMProject();
                vmProject.Plans = new List <VMPlan>();
                List <string> wiIdList  = new List <string>();
                string        wiIds     = string.Empty;
                int           wiIDCount = 0;
                CLProfile     profile   = new CLProfile(token);
                CLWorkItem    workItem  = new CLWorkItem(token);

                var       profiles = profile.GetCurrentProfile();
                CLAccount account  = new CLAccount(token, Convert.ToString(profiles.ResponseAsDynamicObj.id));
                var       accounts = account.GetListAccounts();

                List <CLMAccount> acc = new List <CLMAccount>();
                acc = JsonConvert.DeserializeObject <List <CLMAccount> >(accounts.ResponseAsString);
                var accountDetails = acc.FirstOrDefault(x => x.AccountName == accountName);



                ADOCLProjects projects           = new ADOCLProjects(token);
                var           getProjectResponse = projects.GetProjects(accountDetails.AccountName);
                List <Value>  projectDetails     = new List <Value>();
                projectDetails = JsonConvert.DeserializeObject <List <Value> >(JsonConvert.SerializeObject(getProjectResponse.ResponseAsDynamicObj.value));

                var projectDetail = projectDetails.FirstOrDefault(x => x.name == projectName);

                vmProject.Id   = projectDetail.id;
                vmProject.Name = projectDetail.name;

                ADOCLTest testPlan = new ADOCLTest(token);

                var testPlanResponse = testPlan.GetTestPlans(accountDetails.AccountName, projectDetail.name);
                //deCounter = testPlanResponse.ResponseAsDynamicObj.value.Count;
                foreach (var testPan in testPlanResponse.ResponseAsDynamicObj.value)
                {
                    var vmTestPlan = new VMPlan();
                    vmTestPlan.Id     = Convert.ToString(testPan.id);
                    vmTestPlan.Name   = Convert.ToString(testPan.name);
                    vmTestPlan.Suites = new List <VMSuite>();
                    var testSuites = testPlan.GetTestSuitesByTestPlanId(accountDetails.AccountName, projectDetail.name, vmTestPlan.Id);
                    foreach (var suite in testSuites.ResponseAsDynamicObj.value)
                    {
                        var vmTestSuites = new VMSuite();
                        vmTestSuites.Id        = Convert.ToString(suite.id);
                        vmTestSuites.Name      = Convert.ToString(suite.name);
                        vmTestSuites.TestCases = new List <VMTestcase>();

                        var testCases = testPlan.GetTestCasesByPlanIdAndSuiteId(accountDetails.AccountName, projectDetail.name, vmTestPlan.Id, vmTestSuites.Id);

                        foreach (var testCase in testCases.ResponseAsDynamicObj.value)
                        {
                            wiIDCount++;
                            var vmTestCase = new VMTestcase();
                            vmTestCase.Id = Convert.ToInt32(testCase.testCase.id);
                            wiIds         = wiIds + "," + vmTestCase.Id;
                            vmTestSuites.TestCases.Add(vmTestCase);
                        }
                        vmTestPlan.Suites.Add(vmTestSuites);
                        //break;
                    }

                    vmProject.Plans.Add(vmTestPlan);
                    //break;
                }

                wiIds = wiIds.Trim(',');
                var commanSeparatedWIs = wiIds.WIAsList();

                foreach (var wItemIds in commanSeparatedWIs)
                {
                    var getWIResponse = workItem.GetWIByIds(accountDetails.AccountName, projectDetail.name, wItemIds);
                    var steps         = JsonConvert.DeserializeObject <CLTestCase.CLTestCaseDetail>(getWIResponse.ResponseAsString);

                    foreach (var wi in steps.value)
                    {
                        foreach (var plans in vmProject.Plans)
                        {
                            foreach (var suites in plans.Suites)
                            {
                                foreach (var testcases in suites.TestCases)
                                {
                                    var testCases = suites.TestCases.FirstOrDefault(x => x.Id == wi.id);
                                    if (testCases != null)
                                    {
                                        suites.TestCases.FirstOrDefault(x => x.Id == wi.id).Name  = wi.fields.Title;
                                        suites.TestCases.FirstOrDefault(x => x.Id == wi.id).Steps = new List <Step>();
                                        if (wi.fields.Steps != null)
                                        {
                                            System.Xml.XmlDocument doc = new System.Xml.XmlDocument();
                                            doc.LoadXml(wi.fields.Steps);
                                            string jsonText = JsonConvert.SerializeXmlNode(doc).Replace(@"&nbsp;", "").Replace(@"@", "").Replace(@"#", "").Replace(@"<DIV>", "").Replace(@"<\DIV>", "");

                                            var t = Regex.Replace(jsonText, "<.*?>", String.Empty);

                                            var steps1 = JsonConvert.DeserializeObject <CLSteps.CLStepsTemplate>(t);
                                            foreach (var stepParams in steps1.Steps.step)
                                            {
                                                var newSteps = new Step();
                                                newSteps.Id        = stepParams.id;
                                                newSteps.StepNames = new List <string>();
                                                foreach (var stepItem in stepParams.parameterizedString)
                                                {
                                                    newSteps.StepNames.Add(stepItem.text);
                                                }
                                                suites.TestCases.FirstOrDefault(x => x.Id == wi.id).Steps.Add(newSteps);
                                            }
                                        }
                                    }
                                }
                            }
                        }
                    }
                }

                using (ExcelPackage xp = new ExcelPackage())
                {
                    string jsom     = JsonConvert.SerializeObject(vmProject);
                    int    startRow = 2;

                    var workSheet = xp.Workbook.Worksheets.Add("Sheet1");
                    workSheet.TabColor         = System.Drawing.Color.Black;
                    workSheet.DefaultRowHeight = 12;
                    workSheet.Row(1).Height    = 20;
                    workSheet.Cells[1, 1, 1, 5].Style.Border.BorderAround(ExcelBorderStyle.Thick);
                    workSheet.Row(1).Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
                    workSheet.Row(1).Style.Font.Bold           = true;
                    workSheet.Cells[1, 1].Value = "PlanName";
                    workSheet.Cells[1, 2].Value = "Suite";
                    workSheet.Cells[1, 3].Value = "TestCase";
                    workSheet.Cells[1, 4].Value = "Steps";
                    workSheet.Cells[1, 5].Value = "Expected Result";
                    int startStyle = 2;
                    //bool toggleColor = true;
                    foreach (var plans in vmProject.Plans)
                    {
                        startStyle = startRow;
                        workSheet.Cells[startRow, 1].Value = plans.Name;
                        workSheet.Cells[startRow, 1].AutoFitColumns();// = true;
                        //workSheet.Cells[startRow, 1].Style.VerticalAlignment = ExcelVerticalAlignment.Justify;
                        //workSheet.Cells[startRow, 1].Style.HorizontalAlignment = ExcelHorizontalAlignment.Justify;
                        foreach (var suites in plans.Suites)
                        {
                            bool stepsExists = false;
                            workSheet.Cells[startRow, 2].Value = suites.Name;

                            workSheet.Cells[startRow, 2].AutoFitColumns();// = true;
                            //workSheet.Cells[startRow, 2].Style.VerticalAlignment = ExcelVerticalAlignment.Justify;
                            //workSheet.Cells[startRow, 2].Style.HorizontalAlignment = ExcelHorizontalAlignment.Justify;
                            foreach (var testcases in suites.TestCases)
                            {
                                workSheet.Cells[startRow, 3].Value = testcases.Name;

                                workSheet.Cells[startRow, 3].AutoFitColumns();// = true;
                                //workSheet.Cells[startRow, 3].Style.VerticalAlignment = ExcelVerticalAlignment.Justify;
                                //workSheet.Cells[startRow, 3].Style.HorizontalAlignment = ExcelHorizontalAlignment.Justify; ;
                                int i = 0;
                                foreach (var stepParams in testcases.Steps)
                                {
                                    stepsExists = true;
                                    bool isExpectedResult = false;
                                    foreach (var stepItem in stepParams.StepNames)
                                    {
                                        if (!isExpectedResult)
                                        {
                                            workSheet.Cells[startRow, 4].Value = "Step " + i + " : " + stepItem;
                                            workSheet.Cells[startRow, 4].AutoFitColumns();// = true;
                                            //workSheet.Cells[startRow, 4].Style.VerticalAlignment = ExcelVerticalAlignment.Justify;
                                            //workSheet.Cells[startRow, 4].Style.HorizontalAlignment = ExcelHorizontalAlignment.Justify;
                                            isExpectedResult = true;
                                            i++;
                                        }
                                        else
                                        {
                                            workSheet.Cells[startRow, 5].Value = stepItem;
                                            workSheet.Cells[startRow, 5].AutoFitColumns();// = true;
                                            //workSheet.Cells[startRow, 5].Style.VerticalAlignment = ExcelVerticalAlignment.Justify;
                                            //workSheet.Cells[startRow, 5].Style.HorizontalAlignment = ExcelHorizontalAlignment.Justify;
                                            isExpectedResult = false;
                                        }
                                    }

                                    if (stepParams.StepNames.Count > 0)
                                    {
                                        startRow++;
                                    }
                                }

                                startRow++;
                            }
                            if (!stepsExists)
                            {
                                startRow++;
                            }
                        }


                        //workSheet.Cells[startStyle, 1, startRow, 5].Style.Fill.PatternType = ExcelFillStyle.Solid;
                        //if (toggleColor)
                        //{
                        //    toggleColor = false;

                        //    workSheet.Cells[startStyle, 1, startRow, 5].Style.Fill.BackgroundColor.SetColor(Color.Wheat);
                        //    workSheet.Cells[startStyle, 1, startRow, 5].Style.Border.BorderAround(ExcelBorderStyle.Thick);
                        //}
                        //else
                        //{
                        //    toggleColor = true; ;
                        //    workSheet.Cells[startStyle, 1, startRow, 5].Style.Fill.BackgroundColor.SetColor(Color.Lavender);
                        //    workSheet.Cells[startStyle, 1, startRow, 5].Style.Border.BorderAround(ExcelBorderStyle.Thick);
                        //}
                        startRow++;
                    }
                    return(xp);
                    // xp.SaveAs(new System.IO.FileInfo(string.Format(@"D:\excel\{0}.xlsx", Guid.NewGuid().ToString())));
                }


                //return null;
            }
            catch (Exception)
            {
                return(null);
            }
        }