Ejemplo n.º 1
0
        /// <summary>
        /// Convert a .Net DataSet object to a DSDataSet object
        /// </summary>
        /// <returns>The DS data set.</returns>
        /// <param name="Data">Data.</param>
        public static DSDataSet ToDSDataSet(this DataSet Data)
        {
            var newDS = new DSDataSet(Data.DataSetName);

            foreach (DataTable table in Data.Tables)
            {
                newDS.Tables.Add(table.ToDSDataTable());
            }

            return(newDS);
        }
Ejemplo n.º 2
0
 public HttpResponseMessage PostDataset(DSDataSet model)
 {
     if (model != null)
     {
         db.DSDataSets.AddOrUpdate(model);
         db.SaveChanges();
         return(Response(HttpStatusCode.OK, "OK"));
     }
     else
     {
         return(Response(HttpStatusCode.BadRequest, "Incorrect data was provided"));
     }
 }
        private List <GdcoTicket.Model.GdcoTicket> CreateGdcoTickets(List <AllEgsOutputModel> results, string mode)
        {
            var gdcoTickets = new List <GdcoTicket.Model.GdcoTicket>();
            HashSet <String> failedDescriptions = new HashSet <String>();

            if (results == null || !results.Any())
            {
                return(gdcoTickets);
            }

            // Check for failed tests, create tickets
            foreach (var result in results)
            {
                var errorTypeToExchangeResults = new Dictionary <string, List <AllEngineeringGroupsResult> >();
                var exchangeResults            = result.AllEgsOutput.Where(eo => eo.TestStatus.Equals("Failed") && !string.IsNullOrEmpty(eo.QcName));
                var mdmId = string.IsNullOrEmpty(result.MdmId) ? result.ProjectId : result.MdmId;

                KustoAccess ka = new KustoAccess();

                // compare the current ticket with CIS Kusto feed, if different, cut the ticket
                var kustoErrMsg = "";

                if (exchangeResults != null && exchangeResults.Any())
                {
                    kustoErrMsg = ka.GetErrorEsgByMdmid(mdmId);
                }

                foreach (var exchangeResult in exchangeResults)
                {
                    if (!errorTypeToExchangeResults.ContainsKey(exchangeResult.QcName))
                    {
                        errorTypeToExchangeResults[exchangeResult.QcName] = new List <AllEngineeringGroupsResult> {
                            exchangeResult
                        };
                    }
                    else
                    {
                        var exchangeResultList = errorTypeToExchangeResults[exchangeResult.QcName];
                        exchangeResultList.Add(exchangeResult);
                    }
                }

                if (!errorTypeToExchangeResults.Any())
                {
                    continue;
                }

                foreach (var key in errorTypeToExchangeResults.Keys)
                {
                    var    exchangeErrorList = errorTypeToExchangeResults[key];
                    var    projectId         = string.IsNullOrEmpty(result.ProjectId) ? result.MdmId : result.ProjectId;
                    var    currentWorkOrder  = exchangeErrorList.First().WorkOrderName;
                    var    errorCode         = key;
                    string errorTitle        = null;
                    var    errorDescription  = GetExoResultError(exchangeErrorList);
                    var    dcCode            = result.DataCenterCode;
                    var    requestOwner      = "oadpm";
                    string severity          = null;
                    string parentTicketId    = null;

                    // KustoErrMsg is empty means we couldn't found ticket in Kusto feed, we should email
                    if (String.IsNullOrEmpty(kustoErrMsg))
                    {
                        // send email if there is something diff between us and their Kusto feed
                        EmailBody.AppendLine("<tr><td>" + projectId + "</td><td>" + errorTitle + "</td><td>" + errorDescription + "</td></tr>");
                    }

                    if (result.GroupType.IndexOf("PreRack", StringComparison.OrdinalIgnoreCase) >= 0)
                    {
                        continue;
                    }

                    var gdcoTicket = new GdcoTicketHandler().CreateTicket(projectId, currentWorkOrder,
                                                                          errorCode, errorTitle, errorDescription, dcCode, requestOwner, severity, parentTicketId, mode, "msassetsku");
                    gdcoTickets.Add(gdcoTicket);

                    try
                    {
                        if (mode.Equals("P"))
                        {
                            new GdcoTicketHandler().AssignParent(projectId, gdcoTicket.Id);
                        }
                        else if (mode.Equals("M"))
                        {
                            var cisProject = new CisAccess().GetCisProjectsFromCache().CisProjects.Where(c => c.MdmId.Equals(projectId)).FirstOrDefault();
                            if (cisProject != null && cisProject.UpdateAssetDataTicketId != null)
                            {
                                new GdcoTicketHandler().AssignParent(Convert.ToInt64(cisProject.UpdateAssetDataTicketId), gdcoTicket.Id);
                            }
                        }
                        else if (mode.Equals("D"))
                        {
                            var       dsDataSet       = new DSDataSetAccess().GetInProgressExchangeDeploymentsToRTEG();
                            DSDataSet updateAssetTask = null;
                            DSDataSet oaTask          = null;
                            if (dsDataSet.ContainsKey(projectId))
                            {
                                updateAssetTask = dsDataSet[projectId].Where(d => (d.GDCOFaultCode.Equals("124107") || d.GDCOFaultCode.Equals("124246") || d.GDCOFaultCode.Equals("124054"))).FirstOrDefault();
                                oaTask          = dsDataSet[projectId].Where(d => (d.GDCOFaultCode.Equals("124110"))).FirstOrDefault();
                            }
                            if (updateAssetTask != null && updateAssetTask.TicketState.Equals("Created") && updateAssetTask.TicketId != null)
                            {
                                new GdcoTicketHandler().AssignParent(Convert.ToInt64(updateAssetTask.TicketId), gdcoTicket.Id);
                            }
                            else if (oaTask != null && oaTask.TicketId != null)
                            {
                                new GdcoTicketHandler().AssignParent(Convert.ToInt64(oaTask.TicketId), gdcoTicket.Id);
                            }
                        }
                    }
                    catch (Exception)
                    {
                    }
                    errorDescription = errorDescription.Length > 1000 ? errorDescription.Substring(0, 1000) : errorDescription;
                    failedDescriptions.Add(errorDescription);
                }
            }

            // Check for passed cases that have failed earlier and ticket is not updated. Update the tickets.
            var pids       = new List <string>();
            var failedPids = new List <string>();

            foreach (var result in results)
            {
                if (result.GroupType.IndexOf("PreRack", StringComparison.OrdinalIgnoreCase) >= 0)
                {
                    continue;
                }
                var failedExchangeResults = result.AllEgsOutput.Where(eo => eo.TestStatus.Equals("Failed") && !string.IsNullOrEmpty(eo.QcName));
                var pid = string.IsNullOrEmpty(result.ProjectId) ? result.MdmId : result.ProjectId;
                if (!failedExchangeResults.Any())
                {
                    pids.Add(pid);
                }
                else
                {
                    failedPids.Add(pid);
                }
            }
            if (pids.Any())
            {
                foreach (var pid in pids)
                {
                    gdcoTickets.AddRange(new GdcoTicketHandler().UpdateTicket(pid, "msassetsku"));
                }
            }
            if (failedPids.Any())
            {
                foreach (var pid in failedPids)
                {
                    gdcoTickets.AddRange(new GdcoTicketHandler().UpdateFailedTicket(pid, "msassetsku", failedDescriptions));
                }
            }
            return(gdcoTickets);
        }
        public AllEgsResult GetDSMsAssetSkuValidationResult(string fulfillmentID = null, string CurrentUser = null, bool Email = false, string EmailList = null)
        {
            var exoResult         = new AllEgsResult();
            var exchangeOutput    = new List <AllEgsOutputModel>();
            var error             = new StringBuilder();
            var emailSubject      = "Exchange MSAsset/SKU Validation Report for FulfillmentIDs from DS - " + DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
            var errorEmailSubject = "Error: Exchange MSAsset/SKU Validation Report for FulfillmentIDs from DS - " + DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");

            ExecutionMode = (fulfillmentID == null) ? "S" : "U";

            if (currentExeName != null)
            {
                emailTrigger = currentExeName.IndexOf("AllEgsMsAssetSkuValidationReporting", StringComparison.OrdinalIgnoreCase) >= 0 ? true : false;
            }

            Dictionary <string, List <DSDataSet> > dsDataSet = null;

            try
            {
                dsDataSet = new DSDataSetAccess().GetInProgressExchangeDeploymentsToRTEG(fulfillmentID);
            }
            catch (Exception ex)
            {
                throw ex;
            }

            AllEgsQc exoQc = new AllEgsQc();

            // Get FulfillmentId to DemandId mapping
            GDCOTicketStoreHandler      GDCOTicketStoreHandler = new GDCOTicketStoreHandler();
            Dictionary <string, string> FidToDemandIdMapping   = GDCOTicketStoreHandler.GetFidToDemandIdMapping(dsDataSet.Keys.ToList());

            // Get CPS FidList, it contains all of the fids which are CPS
            Dictionary <string, string> CpsFidTitleDic = GDCOTicketStoreHandler.GetCpsFidTitleDic(FidToDemandIdMapping);

            // Iterate over each DS project
            foreach (var fID in dsDataSet.Keys)
            {
                var dsTasks   = dsDataSet[fID];
                var GroupType = dsTasks.Last().GroupType;
                if (dsTasks != null && dsTasks.Any())
                {
                    var dcCode = dsTasks.Last().DeploymentDCCode;

                    var exoOpModel = exoQc.PerformAllEgsSkuMsAssetValidation(fID, dsTasks.Last().GDCOFaultDescription, dsTasks.Last().DeploymentPGName, "D", null, null, dcCode, GroupType, CpsFidTitleDic, dsTasks.Last().MDMIdList, null, true);
                    exoOpModel.GroupType = GroupType;
                    exchangeOutput.Add(exoOpModel);
                    error.AppendLine(exoOpModel.Error.ToString());
                }
            }

            // Save the exchangeOutput to QcExecutionRawResult table and to the shared path
            List <string> resultFiles = null;

            try
            {
                resultFiles = SaveResultToFile(exchangeOutput, "D");
            }
            catch (Exception ex)
            {
                error.AppendLine("Exception in saving results to the csv file. " + ex.ToString());
            }

            try
            {
                var gdcoTickets = CreateGdcoTickets(exchangeOutput, "D");

                // Create blocking ICM ticket for EXO fid
                DSDataSetAccess   dsa = new DSDataSetAccess();
                GdcoTicketHandler gdcoTicketHandler = new GdcoTicketHandler();

                foreach (var fID in dsDataSet.Keys)
                {
                    var dsTasks = dsDataSet[fID];
                    if (dsTasks != null && dsTasks.Any() && dsTasks.Last().GroupType.IndexOf("PreRack", StringComparison.OrdinalIgnoreCase) < 0)
                    {
                        var dcCode           = dsTasks.Last().DeploymentDCCode;
                        var clusterName      = dsTasks.Last().ClusterName;
                        var currentWorkOrder = dsTasks.Last().GDCOFaultDescription;
                        var errorDescription = "Please complete manual QC for this cluster " + clusterName + "< EOM >";
                        var errorCode        = "Exo manual block ticket";
                        var errorTitle       = "NetworkProvisioning - General Investigation for Azure Networking - MOR/PRD build (Non PNaaS)";

                        if (dsa.IsInOA(dsTasks))
                        {
                            var tickets = new List <GdcoTicket.Model.GdcoTableTicket>();
                            try
                            {
                                tickets = new GdcoTicketTableHandler().GetTickets(fID, "msassetsku");
                            }
                            catch (Exception ex)
                            {
                                return(null);
                            }

                            bool             blockTicketExist = false;
                            List <DSDataSet> oaTasks          = new List <DSDataSet>();

                            if (dsDataSet.ContainsKey(fID))
                            {
                                oaTasks = dsDataSet[fID].Where(d => (d.GDCOFaultCode.Equals("124110"))).ToList();
                            }
                            foreach (var oaTask in oaTasks)
                            {
                                if (oaTask.TicketState.Equals("Created", StringComparison.OrdinalIgnoreCase) || oaTask.TicketState.Equals("InProgress", StringComparison.OrdinalIgnoreCase) ||
                                    oaTask.TicketState.Equals("Blocked", StringComparison.OrdinalIgnoreCase))
                                {
                                    // Loop through each ticket to see if manual exo blocking ticket exist under active OA task ticket
                                    foreach (var ticket in tickets)
                                    {
                                        if (ticket.GdcoTicket.IndexOf(errorTitle, StringComparison.OrdinalIgnoreCase) >= 0 &&
                                            ticket.GdcoTicket.IndexOf(oaTask.TicketId, StringComparison.OrdinalIgnoreCase) >= 0)
                                        {
                                            blockTicketExist = true;
                                            break;
                                        }
                                    }
                                }
                                if (blockTicketExist)
                                {
                                    break;
                                }
                            }

                            if (!blockTicketExist)
                            {
                                try
                                {
                                    var ExoBlockingTicket = new GdcoTicketHandler().CreateTicket(fID, currentWorkOrder,
                                                                                                 errorCode, errorTitle, errorDescription, dcCode, "oadpm", "3", "", "D", "msassetsku");
                                    gdcoTickets.Add(ExoBlockingTicket);

                                    // Assign blocking tickets' parents
                                    DSDataSet oaTask = null;

                                    if (dsDataSet.ContainsKey(fID))
                                    {
                                        oaTask = dsDataSet[fID].Where(d => ((d.GDCOFaultCode.Equals("124110")) &&
                                                                            (d.TicketState.Equals("Created", StringComparison.OrdinalIgnoreCase) || d.TicketState.Equals("InProgress", StringComparison.OrdinalIgnoreCase)))).FirstOrDefault();
                                    }
                                    if (oaTask != null && oaTask.TicketId != null)
                                    {
                                        new GdcoTicketHandler().AssignParent(Convert.ToInt64(oaTask.TicketId), ExoBlockingTicket.Id);
                                    }
                                }
                                catch (Exception ex)
                                {
                                    SendEmail.SendExoSkuMsAssetReportEmail(Constants.serviceAccount, Constants.automationTeam, "EXO Blocking ticket failure", ex.ToString());
                                }
                            }
                        }
                    }
                }

                foreach (var gdcoTicket in gdcoTickets)
                {
                    if (!string.IsNullOrEmpty(gdcoTicket.Error))
                    {
                        error.AppendLine("Error in GDCO Ticket Creation " + gdcoTicket.Error);
                    }
                }
            }
            catch (Exception ex)
            {
                error.AppendLine("Exception in creating GDCO Tickets. " + ex.ToString());
            }

            // Insert the record and send email
            try
            {
                exoResult.Result = exchangeOutput;
                var insertedResultId = QcExecutionRawResultHandler.InsertQcExecutionRawResult(PropertyGroup, ExecutionMode, JsonConvert.SerializeObject(exchangeOutput), DateTime.Now, resultFiles, CurrentUser);
                exoResult.Report = GetExoReport(insertedResultId, "D");
            }
            catch (Exception ex)
            {
                error.AppendLine("Error in inserting the execution result. " + ex.ToString());
            }
            exoResult.Error = error;

            // send diff email
            if (EmailBody.Length > 440)
            {
                string to      = "*****@*****.**";
                string subject = "OA CIS tickets comparision";
                EmailBody.AppendLine("</table>");
                SendEmail.SendExoSkuMsAssetReportEmail(Constants.serviceAccount, to, subject, EmailBody.ToString());
            }

            if (Email)
            {
                var    body            = new StringBuilder();
                var    dbSummaryReport = new StringBuilder();
                string dbDetailReport  = null;
                body.AppendLine("<style> table {    font-family: arial, sans-serif;    border-collapse: collapse;    width: 100%;}td, th {    border: 1px solid #dddddd;    text-align: left;    padding: 8px;}tr:nth-child(even) {    background-color: #dddddd;} h3 {    font-family: arial, sans-serif; color:#2F4F4F;}</style>");
                body.AppendLine("<p><h3>Summary Report:</h3></p>");
                body.AppendLine("<table>");
                body.AppendLine("<tr><td>MdmId</td><td>Current WO</td><td>Failed Tests</td><td>Ticket(s)/Status</td></tr>");
                foreach (var report in exoResult.Report)
                {
                    var tickets = new StringBuilder(string.Empty);
                    if (report.gdcoTickets != null && report.gdcoTickets.Any())
                    {
                        foreach (var gdcoTicket in report.gdcoTickets)
                        {
                            if (gdcoTicket.Fields.ContainsKey("GDCOTicketing.Custom.UpdateInfo") && gdcoTicket.Fields.ContainsKey("System.State"))
                            {
                                var ticketUrl  = gdcoTicket.Fields["GDCOTicketing.Custom.UpdateInfo"].ToString();
                                var firstIndex = ticketUrl.IndexOf("<a");
                                var lastIndex  = ticketUrl.IndexOf(">", firstIndex);
                                tickets.Append(ticketUrl.Substring(firstIndex, lastIndex - firstIndex + 1) + gdcoTicket.Id + "</a>" + "(" + gdcoTicket.Fields["System.State"] + ") ");
                            }
                        }
                    }
                    body.AppendLine("<tr><td>" + report.MdmId + "</td><td>" + report.WorkOrder + "</td><td>" + report.FailedTests + "</td><td>" + tickets.ToString() + "</td></tr>");
                    dbSummaryReport.Append(report.MdmId + "," + report.WorkOrder + "," + report.FailedTests + "," + tickets.ToString() + ";");
                }
                if (dbSummaryReport.Length > 0)
                {
                    dbSummaryReport.Remove(dbSummaryReport.Length - 1, 1);
                }
                body.AppendLine("</table>");
                if (exoResult.Report != null && exoResult.Report.Any())
                {
                    body.AppendLine("<p><h3>Detail Report: </h3>" + exoResult.Report.First().DetailReport + "</p>");
                    dbDetailReport = exoResult.Report.First().DetailReport;
                }
                // Save the Report to database
                try
                {
                    new ReportingHandler().SaveReport(dbSummaryReport.ToString(), dbDetailReport, "ds", "msassetsku");
                }
                catch (Exception ex)
                {
                    exoResult.Error.AppendLine(ex.ToString());
                }

                if (exoResult.Error != null && exoResult.Error.ToString().Trim().Length > 0)
                {
                    string[] errorLines = exoResult.Error.ToString().Split(new string[] { Environment.NewLine }, StringSplitOptions.None);
                    body.AppendLine("<p><h3>Errors: </h3><ol>");
                    foreach (var erroLine in errorLines)
                    {
                        if (erroLine != null && !string.IsNullOrEmpty(erroLine.Trim()))
                        {
                            body.AppendLine("<li>" + erroLine + "</li>");
                        }
                    }
                    body.AppendLine("</ol></p>");
                }
                SendEmail.SendExoSkuMsAssetReportEmail(CurrentUser, EmailList, emailSubject, body.ToString());
            }

            // Send out email to OA when no pid/mdmid found in MSAsset and no PO found for these Fids
            if (emailTrigger && error.ToString().IndexOf("MSAsset returned no output", StringComparison.OrdinalIgnoreCase) >= 0)
            {
                // Filter the error just contains MsAsset association issues.
                string[]      sep     = { Environment.NewLine, "\n" }; // "\n" added in case you manually appended a newline
                string[]      errList = error.ToString().Split(sep, StringSplitOptions.None);
                StringBuilder sb      = new StringBuilder();
                sb.AppendLine("<p><h3>Below EXO fids don't have both MsAsset and PO Associations, please find investigate. </h3></p>");

                foreach (string line in errList)
                {
                    if (line.IndexOf("MSAsset returned no output", StringComparison.OrdinalIgnoreCase) >= 0)
                    {
                        sb.AppendLine(line);
                    }
                }

                string subject = "Below EXO Fids don't have MsAsset and PO Associations";
                string to      = Constants.msAssetSupportAccount + ";" + Constants.OADPMAccount;
                SendEmail.SendExoSkuMsAssetReportEmail(Constants.serviceAccount, to, subject, sb.ToString());
            }

            return(exoResult);
        }
        private List <GdcoTicket.Model.GdcoTicket> CreateGdcoTickets(List <AllEgsOutputModel> results, string mode)
        {
            var gdcoTickets = new List <GdcoTicket.Model.GdcoTicket>();
            HashSet <String> failedDescriptions = new HashSet <String>();
            KustoAccess      ka = new KustoAccess();

            if (results == null || !results.Any())
            {
                return(gdcoTickets);
            }

            // Check for failed tests, create tickets
            foreach (var result in results)
            {
                var errorTypeToAllEgsResults = new Dictionary <string, List <AllEngineeringGroupsResult> >();
                var allEgsResults            = result.AllEgsOutput.Where(eo => eo.TestStatus.Equals("Failed") && !string.IsNullOrEmpty(eo.QcName));
                var mdmId = string.IsNullOrEmpty(result.ProjectId) ? result.MdmId : result.ProjectId;
                // compare the current ticket with CIS Kusto feed, if different, cut the ticket
                var kustoErrMsg = "";

                if (allEgsResults != null && allEgsResults.Any())
                {
                    kustoErrMsg = ka.GetErrorEsgByMdmid(mdmId);
                }

                foreach (var allEgResult in allEgsResults)
                {
                    if (!errorTypeToAllEgsResults.ContainsKey(allEgResult.QcName))
                    {
                        errorTypeToAllEgsResults[allEgResult.QcName] = new List <AllEngineeringGroupsResult> {
                            allEgResult
                        };
                    }
                    else
                    {
                        var exchangeResultList = errorTypeToAllEgsResults[allEgResult.QcName];
                        exchangeResultList.Add(allEgResult);
                    }
                }

                if (!errorTypeToAllEgsResults.Any())
                {
                    continue;
                }

                foreach (var key in errorTypeToAllEgsResults.Keys)
                {
                    var    allEgsErrorList  = errorTypeToAllEgsResults[key];
                    var    projectId        = string.IsNullOrEmpty(result.ProjectId) ? result.MdmId : result.ProjectId;
                    var    currentWorkOrder = allEgsErrorList.First().WorkOrderName.Trim();
                    var    errorCode        = key;
                    string errorTitle       = null;
                    var    errorDescription = GetAllEgsResultError(allEgsErrorList);
                    var    dcCode           = result.DataCenterCode.Trim();
                    var    requestOwner     = "oadpm";
                    string severity         = null;
                    string parentTicketId   = null;

                    var gdcoTicket = new GdcoTicket.Model.GdcoTicket();
                    try
                    {
                        if (String.IsNullOrEmpty(kustoErrMsg))
                        {
                            // send email if there is something diff between us and their Kusto feed
                            EmailBody.AppendLine("<tr><td>" + projectId + "</td><td>" + errorTitle + "</td><td>" + errorDescription + "</td></tr>");
                        }


                        if (result.GroupType.IndexOf("PreRack", StringComparison.OrdinalIgnoreCase) >= 0)
                        {
                            continue;
                        }

                        // Leave cutting ticket part here and will move into above if later
                        if (ErrorCodeMapping.LiveErrorChanges.Contains(errorCode))
                        {
                            var internalErrorCode = mode.Equals("P") ? ErrorCodeMapping.InternalGfsdErrorToInternalFc[key] : ErrorCodeMapping.InternalCisErrorToInternalFc[key];
                            errorTitle       = ErrorCodeMapping.InternalFcToGdcoTicketTitle.Keys.Contains(internalErrorCode) ? ErrorCodeMapping.InternalFcToGdcoTicketTitle[internalErrorCode] : "";
                            errorDescription = GetAllEgsNewResultError(allEgsErrorList, internalErrorCode);
                            gdcoTicket       = new GdcoTicketHandler().CreateErrorTicket(projectId, currentWorkOrder,
                                                                                         internalErrorCode, errorTitle, errorDescription, dcCode, requestOwner, severity, parentTicketId, mode, "allegs_msassetsku");
                        }
                        else
                        {
                            gdcoTicket = new GdcoTicketHandler().CreateTicket(projectId, currentWorkOrder,
                                                                              errorCode, errorTitle, errorDescription, dcCode, requestOwner, severity, parentTicketId, mode, "allegs_msassetsku");
                        }
                    }
                    catch (Exception ex)
                    {
                        SendEmail.SendExoSkuMsAssetReportEmail(Constants.serviceAccountAlias, Constants.automationTeam, "Exception in CreateTicket(), Ticket Creation failed for ", "ProjectId: " + projectId + " Exception in CreateTicket(): " + ex);
                        continue;
                    }
                    errorDescription = errorDescription.Length > 1000 ? errorDescription.Substring(0, 1000) : errorDescription;
                    failedDescriptions.Add(errorDescription);
                    gdcoTickets.Add(gdcoTicket);
                    try
                    {
                        if (mode.Equals("P"))
                        {
                            new GdcoTicketHandler().AssignParent(projectId, gdcoTicket.Id);
                        }
                        else if (mode.Equals("M"))
                        {
                            var cisProject = cisProjectModel.CisProjects.Where(c => c.MdmId.Equals(projectId)).FirstOrDefault();
                            if (cisProject != null && cisProject.UpdateAssetDataTicketId != null)
                            {
                                new GdcoTicketHandler().AssignParent(Convert.ToInt64(cisProject.UpdateAssetDataTicketId), gdcoTicket.Id);
                            }
                        }
                        else if (mode.Equals("D"))
                        {
                            var       dsDataSet       = new DSDataSetAccess().GetInProgressAllEGsDeploymentsToRTEG();
                            DSDataSet updateAssetTask = null;
                            DSDataSet oaTask          = null;
                            if (dsDataSet.ContainsKey(projectId))
                            {
                                updateAssetTask = dsDataSet[projectId].Where(d => (d.GDCOFaultCode.Equals("124107") || d.GDCOFaultCode.Equals("124246") || d.GDCOFaultCode.Equals("124054"))).FirstOrDefault();
                                oaTask          = dsDataSet[projectId].Where(d => (d.GDCOFaultCode.Equals("124110"))).FirstOrDefault();
                            }
                            if (updateAssetTask != null && updateAssetTask.TicketState.Equals("Created") && updateAssetTask.TicketId != null)
                            {
                                new GdcoTicketHandler().AssignParent(Convert.ToInt64(updateAssetTask.TicketId), gdcoTicket.Id);
                            }
                            else if (oaTask != null && oaTask.TicketId != null)
                            {
                                new GdcoTicketHandler().AssignParent(Convert.ToInt64(oaTask.TicketId), gdcoTicket.Id);
                            }
                        }
                    }
                    catch (Exception ex)
                    {
                        SendEmail.SendExoSkuMsAssetReportEmail(Constants.serviceAccountAlias, Constants.automationTeam, "Exception in CreateGdcoTickets()", "ProjectId: " + projectId + " Exception in CreateGdcoTickets(): " + ex);
                        continue;
                    }
                }
            }

            // Check for passed cases that have failed earlier and ticket is not updated. Update the tickets.
            var pids       = new List <string>();
            var failedPids = new List <string>();

            foreach (var result in results)
            {
                if (result.GroupType.IndexOf("PreRack", StringComparison.OrdinalIgnoreCase) >= 0)
                {
                    continue;
                }
                var failedAllEgsResults = result.AllEgsOutput.Where(eo => eo.TestStatus.Equals("Failed") && !string.IsNullOrEmpty(eo.QcName));
                var pid = string.IsNullOrEmpty(result.ProjectId) ? result.MdmId : result.ProjectId;

                if (!failedAllEgsResults.Any())
                {
                    pids.Add(pid);
                }
                else
                {
                    failedPids.Add(pid);
                }
            }
            if (pids.Any())
            {
                foreach (var pid in pids)
                {
                    gdcoTickets.AddRange(new GdcoTicketHandler().UpdateTicket(pid, "allegs_msassetsku"));
                }
            }
            if (failedPids.Any())
            {
                foreach (var pid in failedPids)
                {
                    gdcoTickets.AddRange(new GdcoTicketHandler().UpdateFailedTicket(pid, "allegs_msassetsku", failedDescriptions));
                }
            }
            return(gdcoTickets);
        }