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}");
}
}
}
}
}
}