private async Task<List<Umt>> GetUmtInformationAsync(string productCode, string sectionCode)
        {
            List<Umt> result = new();
            using (SqlConnection connection = new(SqlConnectionString.StringConnection))
            {
                connection.Open();
                var sql = QueryConstant.SelectUmtInformation(productCode, sectionCode);
                var command = new SqlCommand(sql, connection);
                var dataReader = command.ExecuteReader();

                while (dataReader.Read())
                {
                    string code = Convert.ToString(dataReader["code"]).Trim();
                    string name = Convert.ToString(dataReader["name"]).Trim();

                    string idenMacroControl = Convert.ToString(dataReader["control"]);
                    string idenMacroControl = Convert.ToString(dataReader["tariff"]);

                    List<Task> tasks = new List<Task>();
                    tasks.Add(GetMacroTextFromIdenMacroAsync(idenMacroControl));
                    tasks.Add(GetMacroTextFromIdenMacroAsync(idenMacroTariff));

                    await Task.WhenAll(tasks);

                    MacroText macroControl = ((Task<MacroText>)tasks.FirstOrDefault(el => ((Task<MacroText>)el).Result.IdenMacro == idenMacroControl)).Result;
                    MacroText tariffMacro = ((Task<MacroText>)tasks.FirstOrDefault(el => ((Task<MacroText>)el).Result.IdenMacro == idenMacroTariff)).Result;

                    result.Add(new Umt { Name = name, Code = code, TariffMacroText = macroControl, ControlMacroText = tariffMacro });

                }
            }
            return result;
        }


private async Task<Umt> CreateUmt(string code, string name, string idenMacroControl, string idenMacroControl) {
    List<Task> tasks = new List<Task>();
                    tasks.Add(GetMacroTextFromIdenMacroAsync(idenMacroControl));
                    tasks.Add(GetMacroTextFromIdenMacroAsync(idenMacroTariff));

                    await Task.WhenAll(tasks);

                    MacroText macroControl = ((Task<MacroText>)tasks.FirstOrDefault(el => ((Task<MacroText>)el).Result.IdenMacro == idenMacroControl)).Result;
                    MacroText tariffMacro = ((Task<MacroText>)tasks.FirstOrDefault(el => ((Task<MacroText>)el).Result.IdenMacro == idenMacroTariff)).Result;

}