Repository navigation
Expand file tree
/
Copy pathLogService.cs
More file actions
213 lines (186 loc) · 10.4 KB
/
Copy pathLogService.cs
File metadata and controls
213 lines (186 loc) · 10.4 KB
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
202
203
204
205
206
207
208
209
210
211
212
213
using Microsoft.Data.SqlClient;
using Microsoft.EntityFrameworkCore;
using Xml2SqlImport.Data.Context;
using Xml2SqlImport.Helpers.Enums;
using Xml2SqlImport.Helpers.Responses;
using Xml2SqlImport.Interfaces;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Runtime;
namespace Xml2SqlImport.Services
{
public class LogService : ILogService
{
private readonly LogDbContext _dbContext;
private readonly IAppSettings _settings;
public LogService(LogDbContext context, IAppSettings appSettings)
{
_dbContext = context;
_settings = appSettings;
}
public async Task<TaskResult> logStepAsync(enumLogJobStep JobType, string stepDescr, string errorText, bool isSuccess, int recordAffected, DateTime stepStart, DateTime stepEnd, string errorType, int stepSeverity, bool isForTest, string tablePrefix)
{
try
{
int jobId = 23;
string jobName = "";
string stepSP = "";
string appName = $"Xml2SqlImport - {tablePrefix}";
string stepCategory = "";
string respUsr = "Eric Bracke - Noel Wallez - Lieven Vanderghote";
bool isDelta = false;
switch (JobType)
{
case enumLogJobStep.GET_NEXT_XML:
{
jobName = "GET NEXT XML";
stepSP = "spIMPORT_GetNextFileInfo";
stepCategory = "EXEC SP";
isDelta = false;
break;
}
case enumLogJobStep.COPY_XML_TO_LOCAL:
{
jobName = "COPY XML TO LOCAL";
stepCategory = "COPY FILE";
isDelta = false;
break;
}
case enumLogJobStep.READ_XML:
{
jobName = "READ XML";
stepCategory = "READ XML FILE";
isDelta = false;
break;
}
case enumLogJobStep.IMPORT_XML:
{
jobName = "IMPORT XML";
stepSP = "BulkCopy";
stepCategory = "BULKCOPY";
isDelta = true;
break;
}
case enumLogJobStep.IMPORT_XML_POST:
{
jobName = "IMPORT XML POST PROCESS";
stepSP = "spIMPORT_PostProcess";
stepCategory = "EXEC SP";
isDelta = true;
break;
}
case enumLogJobStep.RECAP_VALUES_CALC:
{
jobName = "RECAP VALUES CALC";
stepSP = "spIMPORT_CalcKpiValues";
stepCategory = "EXEC SP";
isDelta = true;
break;
}
case enumLogJobStep.DELETE_XML_LOCAL:
{
jobName = "DELETE XML LOCAL";
stepCategory = "DELETE FILE";
isDelta = true;
break;
}
}
var jIdParam = new SqlParameter { ParameterName = "@jobId", DbType = System.Data.DbType.Int32, Value = jobId };
var jAppParam = new SqlParameter { ParameterName = "@appName", DbType = System.Data.DbType.String, Value = appName, Size = 100 };
var jNameParam = new SqlParameter { ParameterName = "@jobName", DbType = System.Data.DbType.String, Value = jobName, Size = 50 };
var jCatParam = new SqlParameter { ParameterName = "@stepCategory", DbType = System.Data.DbType.String, Value = stepCategory, Size = 50 };
var jDescrParam = new SqlParameter { ParameterName = "@stepDescr", DbType = System.Data.DbType.String, Value = stepDescr, Size = 100 };
var jSpParam = new SqlParameter { ParameterName = "@stepSP", DbType = System.Data.DbType.String, Value = stepSP, Size = 40 };
var jStartParam = new SqlParameter { ParameterName = "@stepStart", DbType = System.Data.DbType.DateTime2, Value = stepStart };
var jEndParam = new SqlParameter { ParameterName = "@stepEnd", DbType = System.Data.DbType.DateTime2, Value = stepEnd };
var jRecsParam = new SqlParameter { ParameterName = "@recordAffected", DbType = System.Data.DbType.Int32, Value = recordAffected };
var jDeltaParam = new SqlParameter { ParameterName = "@isDelta", DbType = System.Data.DbType.Boolean, Value = isDelta };
var jTestParam = new SqlParameter { ParameterName = "@isForTest", DbType = System.Data.DbType.Boolean, Value = isForTest };
var jIsSuccessParam = new SqlParameter { ParameterName = "@isSuccess", DbType = System.Data.DbType.Boolean, Value = isSuccess };
var errTxtParam = new SqlParameter { ParameterName = "@stepError", DbType = System.Data.DbType.String, Value = errorText, Size = 800 };
var errTypeParam = new SqlParameter { ParameterName = "@stepErrorType", DbType = System.Data.DbType.String, Value = errorType, Size = 50 };
var errSeveParam = new SqlParameter { ParameterName = "@stepErrorSeverity", DbType = System.Data.DbType.Int32, Value = stepSeverity };
var respUsrParam = new SqlParameter { ParameterName = "@responsibleUser", DbType = System.Data.DbType.String, Value = respUsr, Size = 50 };
var successParam = new SqlParameter { ParameterName = "@Success", DbType = System.Data.DbType.Boolean, Direction = System.Data.ParameterDirection.Output };
StringBuilder sB = new StringBuilder();
sB.AppendLine("EXEC dbo.spCPT_LogJobStepV1");
sB.AppendLine("@jobId, ");
sB.AppendLine("@appName, ");
sB.AppendLine("@jobName, ");
sB.AppendLine("@stepCategory, ");
sB.AppendLine("@stepDescr, ");
sB.AppendLine("@stepSP, ");
sB.AppendLine("@stepStart, ");
sB.AppendLine("@stepEnd, ");
sB.AppendLine("@recordAffected, ");
sB.AppendLine("@isDelta, ");
sB.AppendLine("@isForTest, ");
sB.AppendLine("@isSuccess, ");
sB.AppendLine("@stepError, ");
sB.AppendLine("@stepErrorType, ");
sB.AppendLine("@stepErrorSeverity, ");
sB.AppendLine("@responsibleUser, ");
sB.AppendLine("@Success OUT");
await _dbContext.Database.ExecuteSqlRawAsync(sB.ToString(), jIdParam, jAppParam, jNameParam, jCatParam, jDescrParam, jSpParam,
jStartParam, jEndParam, jRecsParam, jDeltaParam, jTestParam, jIsSuccessParam, errTxtParam, errTypeParam, errSeveParam, respUsrParam, successParam);
// get the value of the output paramater
var result = (bool)successParam.Value;
return new TaskResult { success = result };
}
catch (Exception e)
{
return new TaskResult { success = false, error = e.Message };
}
}
public async Task<RetVal<bool>> isDateToBypass(DateTime theDate, bool isMissing)
{
var ret = new RetVal<bool> { success = false, returnVal = false, errorMessage = "Something went wrong" };
try
{
var dateParam = new SqlParameter { ParameterName = "@TheDate", DbType = System.Data.DbType.DateTime, Value = theDate };
var weekEndParam = new SqlParameter { ParameterName = "@IsWeekend", DbType = System.Data.DbType.Boolean, Direction = System.Data.ParameterDirection.Output };
var holydayParam = new SqlParameter { ParameterName = "@IsHolyday", DbType = System.Data.DbType.Boolean, Direction = System.Data.ParameterDirection.Output };
var successParam = new SqlParameter { ParameterName = "@Success", DbType = System.Data.DbType.Boolean, Direction = System.Data.ParameterDirection.Output };
StringBuilder sB = new StringBuilder();
sB.AppendLine("EXEC dbo.spCPT_LogGetDateDimInfo ");
sB.AppendLine("@TheDate, ");
sB.AppendLine("@IsWeekend OUT, ");
sB.AppendLine("@IsHolyday OUT, ");
sB.AppendLine("@Success OUT");
await _dbContext.Database.ExecuteSqlRawAsync(sB.ToString(), dateParam, weekEndParam, holydayParam, successParam);
// get the value of the output paramater
var success = (bool)successParam.Value;
if (!success)
{
ret.errorMessage = "Could not fetch the date dim data";
return ret;
}
var isWeekend = (bool)weekEndParam.Value;
var isHoliday = (bool)holydayParam.Value;
if (isMissing)
{
if (isWeekend && _settings.currentFile!.bypassMissingFileWeekend) ret.returnVal = true;
if (isHoliday && _settings.currentFile!.bypassMissingFileHolyday) ret.returnVal = true;
if (!isWeekend && !isHoliday && _settings.currentFile!.bypassMissingFileWeek) ret.returnVal = true;
}
else
{
if (isWeekend && _settings.currentFile!.bypassEmptyFileWeekend) ret.returnVal = true;
if (isHoliday && _settings.currentFile!.bypassEmptyFileHolyday) ret.returnVal = true;
if (!isWeekend && !isHoliday && _settings.currentFile!.bypassEmptyFileWeek) ret.returnVal = true;
}
ret.errorMessage = null;
ret.success = true;
return ret;
}
catch (Exception e)
{
ret.errorMessage = e.Message;
}
return ret;
}
}
}