IBE.SQL.EliteDBIO.getEconomyLevels C# (CSharp) Method

getEconomyLevels() private method

retrieves all known economylevels as original string in capitals and in the current language
private getEconomyLevels ( ) : string>.Dictionary
return string>.Dictionary
        internal Dictionary<string, string> getEconomyLevels()
        {
            String sqlString;
            DataTable Data;
            Dictionary<string, string> retValue = new  Dictionary<string, string>();

            try
            {
                Data = new DataTable();
                
                sqlString = "select Upper(level) as level, loclevel from tbEconomyLevel";
                Program.DBCon.Execute(sqlString, Data);

                foreach (DataRow currentRow in Data.Rows)
                    retValue.Add((String)currentRow["level"], (String)currentRow["loclevel"]);

                return retValue;
            }
            catch (Exception ex)
            {
                throw new Exception("Error while getting dictionary of all economylevels", ex);
            }
        }