public void ShowQueryDetails(string ProjectName) { List <Query> Queries = projectValidator.ReadActiveQueries(ProjectName); if (Queries == null || Queries.Count == 0) { Console.ForegroundColor = ConsoleColor.Green; Console.WriteLine("Congarts no Active Queries :)"); Console.ForegroundColor = ConsoleColor.White; return; } Console.Write(">> Would u prefer to see in Console or Excel sheet : "); if (Console.ReadLine().Trim().ToLower().StartsWith("c")) { int Querynumber = 0; foreach (Query query in Queries) { if (query.QueryStatus == 1) { Console.ForegroundColor = ConsoleColor.Magenta; Console.Write($"Query "); Console.ForegroundColor = ConsoleColor.White; Console.WriteLine($"{Querynumber++}-{query.QueryName}"); Console.ForegroundColor = ConsoleColor.Yellow; Console.WriteLine("Resolutions :"); Console.ForegroundColor = ConsoleColor.White; int ResolutionNumber = 0; foreach (Resolution solution in query.Resolution) { if (solution.ResolutionStatus == 1) { Console.WriteLine($" {ResolutionNumber++}-{solution.Solution}"); } } } } return; } projectValidator.ReadActiveQueriesForXLSheet(ProjectName); Console.ForegroundColor = ConsoleColor.Cyan; Console.WriteLine($"Check the Excel sheet with name '{ProjectName.ToUpper()} Queries.xlsx' in Downloads folder"); Console.ForegroundColor = ConsoleColor.White; }
public void ShowQueryDetails(string ProjectName) { List <Query> Queries = projectValidator.ReadActiveQueries(ProjectName); if (Queries == null || Queries.Count == 0) { Console.ForegroundColor = ConsoleColor.Green; Console.WriteLine("Congarts no Active Queries :)"); Console.ForegroundColor = ConsoleColor.White; } else if (Queries.Count >= 5) { projectValidator.ReadActiveQueriesForXLSheet(ProjectName); Console.ForegroundColor = ConsoleColor.Cyan; Console.WriteLine($"Check the Excel sheet with name '{ProjectName.ToUpper()} Queries.xlsx'"); Console.ForegroundColor = ConsoleColor.White; } else { int Querynumber = 0; foreach (Query query in Queries) { if (query.QueryStatus == 1) { Console.ForegroundColor = ConsoleColor.Magenta; Console.Write($"Query "); Console.ForegroundColor = ConsoleColor.White; Console.WriteLine($"{Querynumber++}-{query.QueryName}"); Console.ForegroundColor = ConsoleColor.Yellow; Console.WriteLine("Resolutions :"); Console.ForegroundColor = ConsoleColor.White; int ResolutionNumber = 0; foreach (Resolution solution in query.Resolution) { if (solution.ResolutionStatus == 1) { Console.WriteLine($" {ResolutionNumber++}-{solution.Solution}"); } } } } } }