public static string GetFogBugzToken()
{
var token = REST_Caller.GetTokenFromIdentityServer(ConfigDict["IdentityServerClientCredentials"], ConfigDict["IdentityServer"]);
var DecryptedText = REST_Caller.GetDecryptedText(ConfigDict["FogBugzEncryptedPassword"], ConfigDict["EncryptDecryptAPI"], token);
var fogbugz_token = REST_Caller.FogBugzLogon(ConfigDict["FogBugzUserName"], DecryptedText, ConfigDict["FogBugzAPI"]);
return(fogbugz_token);
}
static void Main(string[] args)
{
var start = "Operation Started : " + DateTime.Now.ToString();
InitializeConfiguration();
var Cases = REST_Caller.GetAllFogBugItems(ConfigDict["FogBugzAPI"], GetFogBugzToken());
// var Cases = ReadDataFromFile();
var totalCases = Cases.Count;
var TotalActiveCase = Cases.Where(x => x.Status == "Active").ToList <WorkItem>().Count;
var TotalActiveBugs = Cases.Where(b => b.Category == "Bug" && b.Status == "Active").ToList <WorkItem>().Count;
var TotalResolved = Cases.Where(b => b.Status.ToLower().StartsWith("closed") || b.Status.ToLower().StartsWith("resolved")).ToList <WorkItem>().Count;
Console.WriteLine("Total Cases:" + totalCases);
Console.WriteLine("Total Active:" + TotalActiveCase);
Console.WriteLine("Total Bugs:" + TotalActiveBugs);
Console.WriteLine("Total Resolved:" + TotalResolved);
//string JsonString = JsonConvert.SerializeObject(Cases);
//StreamWriter wr = new StreamWriter(Directory.GetCurrentDirectory() + @"\AllCases.json");
//wr.Write(JsonString);
Console.WriteLine(start);
Console.WriteLine("Operation Ended : " + DateTime.Now.ToString());
// var Cases = ReadDataFromFile();
var repo = FogBugzSQLRepository.GetInstance;
repo.connectionString = GetSQLConnectionString();
foreach (WorkItem item in Cases)
{
foreach (Event eventItem in item.EventList)
{
foreach (Attachments a in eventItem.CaseAttachments)
{
repo.InsertAttachments(a);
}
repo.InsertEvent(eventItem);
}
repo.InsertWorkItem(item);
}
}
