예제 #1
0
        private Template loadTemplateBy(TemplateDatabaseType templateDatabaseType, string templateName, string templateType, DAS connection)
        {
            try
            {
                addTemplateNameParameter(templateName, connection);

                var sqlQuery = string.Format("SELECT t.{2} FROM {3} t WHERE t.{0} = '{4}' AND t.{1}={5}",
                                             TemplateTable.Columns.TEMPLATE_TYPE, TemplateTable.Columns.NAME,
                                             TemplateTable.Columns.DESCRIPTION, TemplateTable.NAME, templateType, _pName);


                var row = connection.ExecuteQueryForSingleRow(sqlQuery);
                return(new Template
                {
                    DatabaseType = templateDatabaseType,
                    TemplateType = EnumHelper.ParseValue <TemplateType>(templateType),
                    Name = templateName,
                    Description = row.StringAt(TemplateTable.Columns.DESCRIPTION)
                });
            }
            finally
            {
                removeNameParameter(connection);
            }
        }