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 GetMsAssetSkuValidationMdmIdsResult(string MdmId = null, string CurrentUser = null, bool Email = false, string EmailList = null)
{
var allEgsResult = new AllEgsResult();
var allEgsOutput = new List <AllEgsOutputModel>();
var error = new StringBuilder();
var emailSubject = "All EGs MSAsset/SKU Validation Report for MdmIds from Cis - " + DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
var errorEmailSubject = "Error: All EGs MSAsset/SKU Validation Report for MdmIds from Cis - " + DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
ExecutionMode = (MdmId == null) ? "S" : "U";
if (currentExeName != null)
{
emailTrigger = currentExeName.IndexOf("AllEgsMsAssetSkuValidationReporting", StringComparison.OrdinalIgnoreCase) >= 0 ? true : false;
}
var cisAccess = new CisAccess();
Dictionary <string, CisProject> cisProjectDictionary = new Dictionary <string, CisProject>();
// Fetch the incoming MdmIds
if (string.IsNullOrEmpty(MdmId))
{
try
{
cisProjectModel = cisAccess.GetCisProjectsFromCis(true);
}
catch (Exception ex)
{
error.AppendLine(ex.ToString());
allEgsResult.Error = error;
if (Email)
{
SendEmail.SendExoSkuMsAssetReportEmail(CurrentUser, Constants.automationTeam, errorEmailSubject, "Error in fetching Projects from Cis. " + error.ToString());
}
return(allEgsResult);
}
var incomingCisProjects = cisProjectModel.CisProjects.Where(c => c.UpdateAssetWorkOrderStatus.IndexOf("Finished", StringComparison.OrdinalIgnoreCase) >= 0);
if (cisProjectModel == null || !incomingCisProjects.Any())
{
error.AppendLine("No Exchange Project Found in Cis coming to OA queue.");
allEgsResult.Error = error;
if (Email)
{
SendEmail.SendExoSkuMsAssetReportEmail(CurrentUser, Constants.automationTeam, emailSubject, error.ToString());
}
return(allEgsResult);
}
foreach (var cisProj in incomingCisProjects)
{
cisProjectDictionary[cisProj.MdmId] = cisProj;
}
}
else
{
cisProjectDictionary[MdmId] = new CisProject
{
MdmId = MdmId,
CurrentWorkOrder = string.Empty,
UpdateAssetWorkOrderStatus = string.Empty
};
}
AllEgsQc allEgsQc = new AllEgsQc();
// Iterate over each Cis project
foreach (var mdmId in cisProjectDictionary.Keys)
{
var cisProjectDetails = cisProjectDictionary[mdmId];
if (cisProjectDetails != null)
{
// Perform the QC
var allEgsOpModel = allEgsQc.PerformAllEgsSkuMsAssetValidation(mdmId, cisProjectDetails.CurrentWorkOrder, cisProjectDetails.PropertyGroupName, "M", null, null, cisProjectDetails.DatacenterCode);
if (allEgsOpModel != null)
{
allEgsOutput.Add(allEgsOpModel);
error.AppendLine(allEgsOpModel.Error.ToString());
}
}
}
// Save the exchangeOutput to QcExecutionRawResult table and to the shared path
List <string> resultFiles = null;
try
{
resultFiles = SaveResultToFile(allEgsOutput, "M");
}
catch (Exception ex)
{
error.AppendLine("Exception in saving results to the csv file. " + ex.ToString());
}
try
{
var gdcoTickets = CreateGdcoTickets(allEgsOutput, "M");
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
{
allEgsResult.Result = allEgsOutput;
allEgsResult.Report = GetExoReport(allEgsOutput, "M");
}
catch (Exception ex)
{
error.AppendLine("Error in inserting the execution result. " + ex.ToString());
}
// Filter out duplicate errors
HashSet <String> set = new HashSet <String>();
string[] delim = { Environment.NewLine, "\n" };
string[] lines = error.ToString().Split(delim, StringSplitOptions.None);
foreach (string line in lines)
{
set.Add(line);
}
error = new StringBuilder();
foreach (string line in set)
{
error.AppendLine(line);
}
allEgsResult.Error = error;
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>PropertyGroup</td><td>MdmId</td><td>Current WO</td><td>Failed Tests</td><td>Ticket(s)/Status</td></tr>");
foreach (var report in allEgsResult.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") && gdcoTicket.Fields.ContainsKey("GDCOTicketing.Custom.SLARemaining"))
{
var ticketUrl = gdcoTicket.Fields["GDCOTicketing.Custom.UpdateInfo"].ToString();
var firstIndex = ticketUrl.IndexOf("<a");
var lastIndex = ticketUrl.IndexOf(">", firstIndex);
var assignedTo = "None";
if (gdcoTicket.Fields.ContainsKey("System.AssignedTo"))
{
assignedTo = gdcoTicket.Fields["System.AssignedTo"].ToString();
}
var state = (string)gdcoTicket.Fields["System.State"];
if (state.IndexOf("Canceled", StringComparison.OrdinalIgnoreCase) >= 0 || state.IndexOf("Resolved", StringComparison.OrdinalIgnoreCase) >= 0)
{
tickets.Append(ticketUrl.Substring(firstIndex, lastIndex - firstIndex + 1) + gdcoTicket.Id + "</a>" + "(" + state + ") ");
}
else
{
tickets.Append(ticketUrl.Substring(firstIndex, lastIndex - firstIndex + 1) + gdcoTicket.Id + "</a>" + "(" + state + "|RemainingSLA: " + Math.Round(TimeSpan.FromMilliseconds(Convert.ToDouble(gdcoTicket.Fields["GDCOTicketing.Custom.SLARemaining"])).TotalHours, 1) + "H|AssignedTo:" + assignedTo + ") ");
}
}
}
}
body.AppendLine("<tr><td>" + report.PropertyGroupName + "</td><td>" + report.MdmId + "</td><td>" + report.WorkOrder + "</td><td>" + report.FailedTests + "</td><td>" + tickets.ToString() + "</td></tr>");
dbSummaryReport.Append(report.PropertyGroupName + "," + report.MdmId + "," + report.WorkOrder + "," + report.FailedTests + "," + tickets.ToString() + ";");
}
if (dbSummaryReport.Length > 0)
{
dbSummaryReport.Remove(dbSummaryReport.Length - 1, 1);
}
body.AppendLine("</table>");
if (resultFiles != null && resultFiles.Any())
{
body.AppendLine("<p><h3>Detail Report: </h3>" + resultFiles.First() + "</p>");
dbDetailReport = resultFiles.First();
}
// Save the Report to database
if (MdmId == null)
{
try
{
new ReportingHandler().SaveReport(dbSummaryReport.ToString(), dbDetailReport, "cis", "allegs_msassetsku");
}
catch (Exception ex)
{
allEgsResult.Error.AppendLine(ex.ToString());
}
}
if (allEgsResult.Error != null && allEgsResult.Error.ToString().Trim().Length > 0)
{
string[] errorLines = allEgsResult.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());
}
return(allEgsResult);
}
