1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
// using DevExpress.XtraReports.UI;
// using Uniconta.API.Service;
// using Uniconta.API.System;
// using Uniconta.ClientTools;
// using Uniconta.ClientTools.Controls;
// using Uniconta.ClientTools.DataModel;
// using Uniconta.ClientTools.Page;
// using Uniconta.DataModel;
// using Uniconta.Reports.Utilities;
// using UnicontaClient.Pages;
private static async Task<XtraReport> LoadReport<T>(CrudAPI api, string reportName) where T : UserReportDevExpressClient, UnicontaBaseEntity, new()
{
    var apiWrapper = new ApiWrapper<T>(api);
    var reportRow = (await apiWrapper.Filter()
       .WhereEqual(x => x.Name, reportName)
       .Run()).FirstOrDefault();
    return await GetReportInternal(api, reportName, reportRow);
}
private static async Task<byte[]> GetByteArrayFromReport(XtraReport report)
{
    var stream = new MemoryStream();
    await report.ExportToPdfAsync(stream, new PdfExportOptions());
    stream.Position = 0;
    return stream.ToArray();
}
private static async Task<XtraReport> GetReportInternal(CrudAPI api, string reportName, UserReportDevExpressClient reportRow)
{
    if (reportRow == null)
        throw new Exception($"Kon rapport '{reportName}' niet vinden!");
    // Load Layout bytes in repord
    _ = await api.Read(reportRow);
    var reportLayout = reportRow.Layout;
    if (reportLayout == null)
        throw new Exception($"Kon rapport '{reportName}' layout niet laden!");
    XtraReport report;
    try
    {
        report = ReportUtil.GetXtraReportFromLayout(reportLayout);
    }
    catch (Exception)
    {
        report = null;
    }
    if (report == null)
        throw new Exception($"Kon rapport '{reportName}' niet laden! (error while loading layout)");
    return report;
}
private static async Task<UserDocsClient> GetOfferReportBasedOnProjectType(CrudAPI api, GiftProject giftProject, string reportName)
{
    var report = await LoadReport<UserReportDevExpressClient>(api, reportName);
    var orderService = new OrderService();
    var projectConvertedToOrder = orderService.ConvertProjectToOrder<UniDebtorOffer>(giftProject);
    var lines = orderService.GetOrderlinesForProject<UniDebtorOfferLine>(giftProject);
    report.DataSource = ConvertToMasterDetailDataSource(projectConvertedToOrder, lines.ToArray());
    var reportAsByteArray = await GetByteArrayFromReport(report);
    return new UserDocsClient()
    {
        _Data = reportAsByteArray,
        _Text = $"Offerte {giftProject.Code}",
        _DocumentType = FileextensionsTypes.PDF
    };
}
public void ViewUserDoc(UserDocsClient attachment)
{
    ViewDocument("UserDocsPage3", attachment);
}
public class CustomPrintReport : IPrintReport
{
    public DevExpress.XtraReports.UI.XtraReport Report { get; set; }
    public Task InitializePrint()
    {
        return Task.FromResult(0);
    }
}
private void SetReportParameter(DevExpress.XtraReports.UI.XtraReport report, string name, object value)
{
    var p = report.Parameters
        .AsQueryable()
        .Cast<DevExpress.XtraReports.Parameters.Parameter>()
        .FirstOrDefault(x => string.Equals(x.Name, name));
    if (p == null)
    {
        p = new DevExpress.XtraReports.Parameters.Parameter
        {
            Name = name
        };
        report.Parameters.Add(p);
    }
    p.Value = value;
}
var reportApi = new UserReportAPI(api);
var reportName = "MyReportName";
var customReport = false;
if (!string.IsNullOrWhiteSpace(e.ArticleReport))
{
    customReport = true;
    reportName = e.ArticleReport;
}
byte[] reportLayout;
XtraReport report;
try
{
    reportLayout = ThreadsHelper.RunSync(() => reportApi.LoadForRun(reportName, 1));
    report = ReportUtil.GetXtraReportFromLayout(reportLayout);
}
catch (Exception ex)
{
    throw new Exception($"Kon rapport {reportName} niet laden!", ex);
}
if (report == null)
    throw new Exception($"Kon rapport {reportName} niet laden! (2)");
if (customReport)
{
    var dataSource = new List<UnicontaMasterDetail>();
    //var master = productionOrder;
    // #1. Laatste productie gereedmeld-regel opzoeken (productie artikel)
    var productionPostedClients = await api.Query<ProductionPostedClient>(productionOrder);
    var productionPostedClient = productionPostedClients.OrderByDescending(x => x.LineNumber).FirstOrDefault();
    if (productionPostedClient == null)
        return;
    // #2. Laatste gereedmeld-detailregel opzoeken
    var invTransClients = await api.Query<InvTransClient>(productionPostedClient);
    var invTransClient = invTransClients.Where(x => x.MovementTypeEnum == InvMovementType.ReportAsFinished).OrderByDescending(x => x.LineNumber).FirstOrDefault();
    //var filter = new List<PropValuePair>
    //{
    //    PropValuePair.GenereteWhereElements(nameof(InvSerieBatchClient.Number), e.BatchNumber, CompareOperator.Equal),
    //    PropValuePair.GenereteWhereElements(nameof(InvSerieBatchClient.Item), productionOrder.Item, CompareOperator.Equal),
    //};
    // #3. var de invTransClient de bijbehorende batchnummers opzoeken
    var batchNumbers = await api.Query<InvSerieBatchClient>(invTransClient);
    // Force re-check
    var specificBatchNumbers = batchNumbers.Where(x => x.Number == e.BatchNumber && x.Item == productionOrder.Item).ToArray();
    
    dataSource.Add(new UnicontaMasterDetail()
    {
        Master = invTransClient,
        Details = specificBatchNumbers
    });
    
    report.DataSource = dataSource;
}
else
{
    report.DataSource = new List<ProductionOrderClient>() { productionOrder };
}
SetReportParameter(report, "EmployeeNumber", employee.Number);
SetReportParameter(report, "EmployeeName", employee.Name);
SetReportParameter(report, "Quantity", e.Quantity);
SetReportParameter(report, "QuantityToBook", e.QuantityToBook);
SetReportParameter(report, "BatchNumber", e.BatchNumber);
SetReportParameter(report, "Date", e.Date);
SetReportParameter(report, "BatchExpiryDate", e.BatchExpiryDate);
SetReportParameter(report, "ArticleDescription", e.ArticleDescription);
SetReportParameter(report, "ArticleCode", e.ArticleCode);
SetReportParameter(report, "BookingDescription", e.BookingDescription);
SetReportParameter(report, "ProductionDate", ProductionOrderList.ProductionDate);
SetReportParameter(report, "ProductionOrderDescription", e.ProductionOrderDescription);
// Via GUI
Dispatcher.Invoke(() =>
{
    IPrintReport printReport = new CustomPrintReport() { Report = report };
    var dockName = $"{Localization.lookup("ProductionOrder")} {productionOrder.KeyStr}";
    AddDockItem(UnicontaTabs.StandardPrintReportPage, new object[] { new List<IPrintReport> { printReport }, reportName }, dockName);
});
// As stream / byte[]
var pdfOptions = new PdfExportOptions() { };
var stream = new MemoryStream();
await report.ExportToPdfAsync(stream, pdfOptions);
stream.Position = 0;
return stream.ToArray();
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX