예제 #1
0
        public EvaluationOutput Evaluate(EvaluationRequest request)
        {
            IEnumerable <TemplateField> templateFields = null;

            if (!string.IsNullOrEmpty(request.TemplateName))
            {
                var template = repository.GetLatestTemplate(request.TemplateName);
                if (template != null)
                {
                    templateFields = OpenXmlWordProcessing.FindTemplateFields(template.Buffer);
                }
            }
            if (templateFields == null)
            {
                templateFields = request.Expressions.Select(e => new TemplateField()
                {
                    Name         = e.Name,
                    Parent       = e.Parent,
                    IsCollection = e.IsCollection,
                    Content      = e.Content
                });
            }

            var processor = new MappingExpressionEvaluator();
            var input     = new EvaluationInput()
            {
                Fields      = templateFields,
                Expressions = request.Expressions,
                Sources     = request.Sources
            };
            var response = processor.Evaluate(input);

            return(response);
        }
예제 #2
0
        public Stream CreateMappingForTemplate(Stream templateBytes, Stream mappingBytes, FillMappingInfo info)
        {
            var templateFields = OpenXmlWordProcessing.FindTemplateFields(templateBytes);
            var excelBytes     = OpenXmlSpreadsheet.FillMappingsSheet(mappingBytes, templateFields, info);

            return(excelBytes);
        }
예제 #3
0
        public void CanFindCorrectTemplateFieldsWhenAlternateContent()
        {
            var buffer = new MemoryStream(Resources.simple_receipt_template_docx);

            var templateFields = OpenXmlWordProcessing.FindTemplateFields(buffer);

            Assert.Equal(9, templateFields.Count());
        }
예제 #4
0
        public void CanFindTemplateFields002()
        {
            var buffer = new MemoryStream(Resources.find_template_fields002_docx);

            var templateFields = OpenXmlWordProcessing.FindTemplateFields(buffer);

            Assert.Equal(11, templateFields.Count());
        }
예제 #5
0
        public TemplateDetails GetTemplate(string templateName, string templateVersion = null)
        {
            var content = repository.GetTemplate(templateName, templateVersion);

            if (content == null)
            {
                return(null);
            }
            var fields   = OpenXmlWordProcessing.FindTemplateFields(content.Buffer);
            var template = TransformFull(content, fields);

            return(template);
        }
예제 #6
0
        public void CanFindTemplateFields001()
        {
            var buffer = new MemoryStream(Resources.find_template_fields001_docx);

            var templateFields = OpenXmlWordProcessing.FindTemplateFields(buffer);

            Assert.Equal(7, templateFields.Count());
            Assert.Equal(new string[] {
                "FromAccountNumber",
                "FromAccountHolder",
                "ToAccountNumber",
                "Currency",
                "Amount",
                "TransactionDate",
                "TransactionTime"
            }, templateFields.Select(o => o.Name).ToArray());
        }
        public void CanEvaluateForExcelExample01()
        {
            var json           = JObject.Parse(Resources.evaluate_for_excel_example01_json);
            var request        = json.ToObject <EvaluationRequest>();
            var templateBytes  = new MemoryStream(Resources.evaluate_for_excel_example01_docx);
            var templateFields = OpenXmlWordProcessing.FindTemplateFields(templateBytes);

            var processor = new MappingExpressionEvaluator(CultureInfo.GetCultureInfo("el-GR"));
            var input     = new EvaluationInput()
            {
                Fields      = templateFields,
                Expressions = request.Expressions,
                Sources     = request.Sources
            };
            var response = processor.Evaluate(input);

            var fields = new Dictionary <string, string>();

            response.Results.ToList().ForEach(o => fields.Add(o.Name, o.Text));
            Assert.Equal(23, response.Total);
            Assert.Equal(0, response.Errors);
            Assert.Equal(DateTime.Today.ToString("d/M/yyyy"), fields["F01"]);
            Assert.Equal("ΠΡΟΘΕΣΜΙΑΚΗ ΜΕ BONUS 3 ΜΗΝΩΝ - ΑΠΟ ΕΥΡΩ 10.000", fields["F02"]);
            Assert.Equal("923456789012345", fields["F03"]);
            Assert.Equal("3", fields["F04"]);
            Assert.Equal("MONTH", fields["F05"]);
            Assert.Equal("έκαστης", fields["F06"]);
            Assert.Equal("10000", fields["F07"]);
            Assert.Equal("3", fields["F08"]);
            Assert.Equal("1", fields["F09"]);
            Assert.Equal("['{}','{}']", fields["F10"]);
            Assert.Equal("['1','3']", fields["F11"]);
            Assert.Equal("['0,2','0,25']", fields["F12"]);
            Assert.Equal("['500','1000']", fields["F13"]);
            Assert.Equal("0,17", fields["F14"]);
            Assert.Equal("1", fields["F15"]);
            Assert.Equal("Πρώτος προαιρετικός όρος", fields["F16"]);
            Assert.Equal("1", fields["F17"]);
            Assert.Equal("", fields["F18"]);
            Assert.Equal("5000", fields["F19"]);
            Assert.Equal("10000", fields["F20"]);
            Assert.Equal("Προθεσμιακή με Bonus 3 Μηνών - Από Ευρώ 10.000", fields["F21"]);
            Assert.Equal("923456789012345", fields["F22"]);
            Assert.Equal("123", fields["F23"]);
        }
예제 #8
0
        public Stream CreateDocument(Stream templateBytes, Stream mappingBytes, DocumentPayload payload)
        {
            var         templateFields = OpenXmlWordProcessing.FindTemplateFields(templateBytes);
            MappingInfo mappingInfo;

            if (mappingBytes != null)
            {
                mappingInfo = OpenXmlSpreadsheet.GetMappingInfo(mappingBytes, payload.Sources);
            }
            else
            {
                mappingInfo = OpenXmlSpreadsheet.BuildIdentityExpressions(templateFields, payload.Sources);
            }
            var results            = CreateDocumentInternal(templateFields, mappingInfo.Expressions, mappingInfo.Sources);
            var contentControlData = BuildContentControlData(templateFields, results);

            return(OpenXmlWordProcessing.MergeTemplateWithMappings(contentControlData, templateBytes));
        }
예제 #9
0
        public async Task <TemplateDetails> CreateTemplate(TemplateData templateData, Stream bytes)
        {
            templateData = templateData ?? throw new ArgumentNullException(nameof(templateData));
            var templateName = templateData.TemplateName ?? throw new ArgumentNullException(nameof(templateData.TemplateName));

            IEnumerable <TemplateField> fields;

            try
            {
                fields = OpenXmlWordProcessing.FindTemplateFields(bytes);
            }
            catch (FileFormatException)
            {
                throw new ArgumentException(nameof(bytes));
            }
            var content = await repository.CreateTemplate(templateName, bytes);

            if (htmlRepository != null)
            {
                var conversion = OpenXmlWordConverter.ConvertToHtml(bytes, content.Name);
                htmlRepository.SaveHtml(content.Name, null, conversion.Images);
            }
            return(TransformFull(content, fields));
        }