/// <summary> /// Get number of components for selected language /// </summary> /// <param name="language">Selected language</param> /// <param name="connection">Database connection</param> /// <returns>Dictionary of components names and their numbers</returns> public static Dictionary <string, int> GetNumerOfComponents(string language, Database_Operation.Connection connection) { // Get SQL Connection SqlConnection myConnection = connection.GetConnection(); // Load components LoadComponents(language, myConnection); // Get number of component Dictionary <string, int> numberOf = new Dictionary <string, int>(); int numberOfScenarios = 0; int numberOfSections = 0; int numberOfCheckPoints = 0; int numberOfOperations = 0; // Scenarios numberOfScenarios = export_scenarios.Count; // Sections foreach (Database_Export.Scenario scenario in export_scenarios.Values) { numberOfSections += scenario.sections.Count; } // CheckPoints numberOfCheckPoints = export_checkpoints.Count; // Operations foreach (Database_Export.CheckPoint checkPoint in export_checkpoints.Values) { numberOfOperations += checkPoint.operations.Count; } // Add all to output numberOf.Add("Scenarios", numberOfScenarios); numberOf.Add("Sections", numberOfSections); numberOf.Add("CheckPoints", numberOfCheckPoints); numberOf.Add("Operations", numberOfOperations); // Clear old values ClearComponents(); return(numberOf); }
/// <summary> /// Generate database output in JSON, into 'export' file, in program folder /// </summary> /// <param name="language">Selected language</param> /// <param name="myConnection">Database connection</param> public static void Generate(string language, Database_Operation.Connection connection) { // Get SQL Connection SqlConnection myConnection = connection.GetConnection(); // Load components LoadComponents(language, myConnection); // Create JSON and save into file Directory.CreateDirectory(@".\export\" + language); StreamWriter sw; foreach (string key in scenarios.Keys) { sw = new StreamWriter(@".\export\" + language + @"\" + export_scenarios[key].name + ".json"); sw.Write(export_scenarios[key].ToJson()); sw.Flush(); sw.Close(); } // Clear old values ClearComponents(); }