Exemple #1
0
        public UIAutomationAggregate(int TeamId)
        {
            var dbU = new ApplicationDbContext();

            CurrentUser = dbU.Users.FirstOrDefault(u => u.Email == HttpContext.Current.User.Identity.Name);

            var db          = new AutomationDashboardEntities();
            var productTeam = db.ProductTeams.First(team => team.TeamId == TeamId);

            TotalTFSTests       = productTeam.TotalTFSTests ?? 0;
            TotalAutomatedTests = productTeam.TotalAutomatedTests ?? 0;

            dailySmokes = db.DailySmokes.Where(e => e.TeamId == TeamId).OrderByDescending(column => column.Date).ToList();
            foreach (var smokeItem in dailySmokes)
            {
                smokeItem.detail_results = null;
            }
            FullPass = db.FullPasses.Where(e => e.TeamId == TeamId).OrderByDescending(column => column.Date).ToList();
            foreach (var fullPassReport in FullPass)
            {
                fullPassReport.detail_results = null;
            }
            testSuites = db.spGetTestSuitesForTeam(TeamId).OrderBy(col => col.SuiteName).ToList();

            CoreModSmokes = db.CoreModSmokes.Where(e => e.TeamId == TeamId).OrderByDescending(column => column.Date).ToList();
            foreach (var coreModSmokesReport in CoreModSmokes)
            {
                coreModSmokesReport.detail_results = null;
            }
            productTeams = db.ProductTeams.Where(t => t.TeamId > 0).ToList();
            CurrentTeam  = db.ProductTeams.First(t => t.TeamId == TeamId);
        }
        public TeamAutomationWeeklyProgress(int TeamId)
        {
            this.TeamId = TeamId;
            var db = new AutomationDashboardEntities();

            WeeklyStatus = db.spGetPreviousAndCurrentWeekAutomationAggregateData(TeamId).ToList();

            var ProductAreas = db.AutomateDatas.Where(e => e.TeamId == TeamId).Select(col => col.ProductArea).Distinct().ToList();

            if (DateTime.Now.DayOfWeek == DayOfWeek.Friday)
            {
                Date1 = DateTime.Now.Date;
            }
            else
            {
                Date1 = Helpers.GetPreviousFriday(DateTime.Now);
            }

            Date2 = Helpers.GetPreviousFriday(Date1);
            Date3 = Helpers.GetPreviousFriday(Date2);
            Date4 = Helpers.GetPreviousFriday(Date3);

            var data3 = GetProgress(TeamId, Date4, Date3, ProductAreas);
            var data2 = GetProgress(TeamId, Date3, Date2, ProductAreas);
            var data1 = GetProgress(TeamId, Date2, Date1, ProductAreas);

            Week1.TFSTestCasesThisWeek  = data1.Select(r => r.TFSTestCasesThisWeek).Sum();
            Week1.AutomatedThisWeek     = data1.Select(r => r.AutomatedThisWeek).Sum();
            Week1.NoOfTestCasesDebugged = data1.Select(r => r.NoOfTestCasesDebugged).Sum();

            Week2.TFSTestCasesThisWeek  = data2.Select(r => r.TFSTestCasesThisWeek).Sum();
            Week2.AutomatedThisWeek     = data2.Select(r => r.AutomatedThisWeek).Sum();
            Week2.NoOfTestCasesDebugged = data2.Select(r => r.NoOfTestCasesDebugged).Sum();

            Week3.TFSTestCasesThisWeek  = data3.Select(r => r.TFSTestCasesThisWeek).Sum();
            Week3.AutomatedThisWeek     = data3.Select(r => r.AutomatedThisWeek).Sum();
            Week3.NoOfTestCasesDebugged = data3.Select(r => r.NoOfTestCasesDebugged).Sum();

            try
            {
                TFSTotal       = WeeklyStatus[1].TotalTFS;
                AutomatedTotal = WeeklyStatus[1].TotalAutomated;
            }
            catch
            {
                TFSTotal       = 0;
                AutomatedTotal = 0;
            }
            TeamName = db.ProductTeams.Where(r => r.TeamId == TeamId).First().TeamName;
        }
        static void UpdateTriaging(int TeamId, List <spGetCurrentStatusOfAutomationForATeam_Result> automationStatus)
        {
            var CurrentFriday = GetPreviousFriday(DateTime.Now).AddDays(7);

            using (var db = new AutomationDashboardEntities())
            {
                foreach (var productArea in automationStatus)
                {
                    var entry = db.WeeklyTriagings.FirstOrDefault(row => row.TeamId == TeamId && row.ProductArea == productArea.ProductArea && row.Date == CurrentFriday);
                    if (entry == null)
                    {
                        productArea.NoOfTestCasesDebugged = 0;
                    }
                    else
                    {
                        productArea.NoOfTestCasesDebugged = entry.NoOfTestCasesDebugged;
                    }
                }
            }
        }
        public static void WriteAutomationStatusToExcel(string ExcelFilePath, int TeamId)
        {
            var db = new AutomationDashboardEntities();
            var automationStatus = db.spGetCurrentStatusOfAutomationForATeam(TeamId).ToList();

            UpdateTriaging(TeamId, automationStatus);

            //clear the excel file
            ClearExcelFile(ExcelFilePath, automationStatus.Count);

            try
            {
                new FileInfo(ExcelFilePath)
                {
                    IsReadOnly = false
                };
                ExcelPackage Browser          = new ExcelPackage(new FileInfo(ExcelFilePath));
                var          BrowserWorkBook  = Browser.Workbook;
                var          BrowserWorkSheet = BrowserWorkBook.Worksheets[1];

                for (int i = 2; i <= automationStatus.Count + 1; i++)
                {
                    BrowserWorkSheet.Cells[i, 1].Value = automationStatus[i - 2].ProductArea;
                    BrowserWorkSheet.Cells[i, 2].Value = automationStatus[i - 2].NoOfTFSTestcase;
                    BrowserWorkSheet.Cells[i, 3].Value = automationStatus[i - 2].NoOfAutomatedTestcases;
                    BrowserWorkSheet.Cells[i, 4].Value = automationStatus[i - 2].NoOfTestCasesDebugged;
                    if (TeamId == 1)
                    {
                        BrowserWorkSheet.Cells[i, 5].Value = automationStatus[i - 2].ExpectedTestCases;
                    }
                    Browser.Save();
                }

                BrowserWorkSheet.Dispose();
            }
            catch (Exception e)
            {
                Debug.WriteLine("Error occured in ClearExcelFile \n" + e.ToString());
            }
        }
        static List <spGetWeeklyProgressForProductAreaBetweenDates_Result> GetProgress(int TeamId, DateTime From, DateTime To, List <string> ProductAreas)
        {
            var db         = new AutomationDashboardEntities();
            var FirstData  = db.spGetStatusOfAutomationForATeamWithSpecifiedDate(TeamId, To).ToDictionary(s => s.ProductArea);
            var SecondData = db.spGetStatusOfAutomationForATeamWithSpecifiedDate(TeamId, From).ToDictionary(s => s.ProductArea);
            List <spGetWeeklyProgressForProductAreaBetweenDates_Result> list = new List <spGetWeeklyProgressForProductAreaBetweenDates_Result>();

            foreach (string productArea in ProductAreas)
            {
                var progressData = new spGetWeeklyProgressForProductAreaBetweenDates_Result();
                progressData.ProductArea = productArea;
                progressData.TeamId      = TeamId;
                if (FirstData.ContainsKey(productArea) && SecondData.ContainsKey(productArea))
                {
                    progressData.TFSTestCasesThisWeek = FirstData[productArea].NoOfTFSTestcase - SecondData[productArea].NoOfTFSTestcase;
                    progressData.AutomatedThisWeek    = FirstData[productArea].NoOfAutomatedTestcases - SecondData[productArea].NoOfAutomatedTestcases;
                }
                else if (!FirstData.ContainsKey(productArea) && !SecondData.ContainsKey(productArea))
                {
                    progressData.TFSTestCasesThisWeek = 0;
                    progressData.AutomatedThisWeek    = 0;
                }
                else if (FirstData.ContainsKey(productArea))
                {
                    progressData.TFSTestCasesThisWeek = FirstData[productArea].NoOfTFSTestcase;
                    progressData.AutomatedThisWeek    = FirstData[productArea].NoOfAutomatedTestcases;
                }

                var temp = db.WeeklyTriagings.Where(row => row.TeamId == TeamId && row.Date <= To && row.Date > From && row.ProductArea == productArea).FirstOrDefault();
                progressData.NoOfTestCasesDebugged = temp == null ? 0 : temp.NoOfTestCasesDebugged;

                list.Add(progressData);
            }

            return(list);
        }
        public AutomationTeamModel(int TeamId)
        {
            var db = new AutomationDashboardEntities();

            automateData = db.AutomateDatas.Where(e => e.TeamId == TeamId).First();
        }