//public IEnumerable<SealedNameList> headers { set { if (headers == null)_headers = value } get => _headers; }
public XlsxResultProcessor(String path, String cwwsn, IDictionary <string, IEnumerable <KeyValuePair <string, string> > > bindmaps, IEnumerable <SealedNameList> headers)
{
this.fflds = bindmaps[XCDconfigsEnum.IAFormatFields.ToString()].ToDictionary(prop => prop.Key, prop => prop.Value?.Split(","));
p = new ExcelPackage(new System.IO.FileInfo(path));
worksheet = ConsolidateHelper.GetWorksheetOrAdd(p.Workbook, cwwsn);
this.headers = headers;
if (!p.Workbook.Names.ContainsKey("_end_") && (worksheet.Dimension?.End?.Row ?? 0) < 1)
{
foreach (var header in headers)
{
worksheet.Cells[1, header.value].Value = header.name;
}
}
if (p.Workbook.Names.ContainsKey("_end_"))
{
r = p.Workbook.Names["_end_"].Start.Row - 1;
c = p.Workbook.Names["_end_"].Start.Column - 1;
}
else
{
r = (worksheet.Dimension?.End?.Row ?? 0) + 1;
}
}
public override bool?validate(string value, string matcher = null)
{
var parts = matcher.Split(",");
var path = parts[1];
if (File.Exists(path))
{
using (FileStream fs = new FileStream(path, FileMode.Open))
{
if (fs.CanRead)
{
using (ExcelPackage p = new ExcelPackage(fs))
return(ConsolidateHelper.GetRowByID(parts.Length < 3 ? p.Workbook.Worksheets[0] : p.Workbook.Worksheets[parts[2]], value, parts[0], parts.Length < 4 ? 1 : Int32.Parse(parts[4])) != null);
}
}
}
Logger.Log($"[Xlsx source does not exist or not readable]{path}");
return(true);
}
public override bool?process(Outlook.MailItem subject, IControl <FileInfo, IValidationConfigCol <IValidator <string, string>, EmailValidatorConfig>, Dictionary <ValidResultConfig, Dictionary <String, ValidResults> > > controller, IDictionary <string, string> configs = null)
{
String moveto = null, rhtml = null;
bool clearCat = false, movetoinbox = false;
if (subject.Attachments?.Count > 0)
{
Outlook.Attachment attachment = null;
var attachments = subject.Attachments;
Dictionary <EmailValidatorConfig, IEnumerable <Tuple <String, String, Boolean?> > > avalCols = new Dictionary <EmailValidatorConfig, IEnumerable <Tuple <String, String, Boolean?> > >();
Dictionary <ValidResultConfig, Dictionary <String, ValidResults> > resultsCol = new Dictionary <ValidResultConfig, Dictionary <String, ValidResults> >();
try
{
for (int i = 1; i <= attachments.Count; i++)
{
if (stopOnReject || error)
{
break;
}
attachment = attachments[i];
if (attachment.FileName.Split(".").Last().ToLower().Equals("xlsm"))
{
var d = Directory.CreateDirectory($@"temp\{Guid.NewGuid()}");
var path = Tools.GetUniqueFileName(Path.Combine(d.FullName, attachment.FileName.Replace("~", "").Trim()));
attachment.SaveAsFile(path);
Logger.Log($"{attachment.FileName} saved to {path} ...");
if (controller == null)
{
ExecuteValidationConfig(vconfigCol, avalCols, path, resultsCol);
}
else
{
resultsCol.Concat(controller.execute(new FileInfo(path), null, configs));
}
}
Logger.WriteToConsole($"Successfully validated {attachment.FileName}");
// Logger.WriteToConsole($"Logged to DB for [{path}], result:{DBHelper.InsertOptAttachmentReceived(new OptAttachmentReceived() { AttachmentFileName = attachment.FileName, ExecutionTime = DateTime.Now, ImportErrorMessage = String.Join(",", results.Select(r => $"[{r.Key}][{r.Value}]")), Subject = mail.Subject, SenderEmailAddress = evals[ConfigHelper.Sender_Email_Address.name], RecievedTime = mail.ReceivedTime, _ImportResult = success })}");
}
var guid = Guid.NewGuid().ToString();
var evals = new Dictionary <String, String>()
{
{ ConfigHelper.Email_Date, subject.ReceivedTime.ToString("MM/dd/yyyy HH:mm:ss") },
{ ConfigHelper.Email_Subject, Tools.SafeSubstring(subject.Subject, 0, 199) },
{ ConfigHelper.Sender_Email_Address, OutlookHelper.GetSenderEmailAddr(subject) },
{ ConfigHelper.SN, ConsolidateHelper.TimeLapsedID }
};
var pstpath = configs.ContainsKey(PSTconfigsEnum.pstPath.ToString()) ? Directory.CreateDirectory(pnc?.execute(configs[PSTconfigsEnum.pstPath.ToString()], null, null) ?? configs[PSTconfigsEnum.pstPath.ToString()]).FullName : "";
if (success && resultsCol.Any())
{
foreach (var aresultsCol in resultsCol)
{
var tdpath = $@"temp\${Guid.NewGuid()}";
var dpath = pnc?.execute(aresultsCol.Key.targetPath, null, null) ?? aresultsCol.Key.targetPath;
if (File.Exists(dpath))
{
if (!Tools.FileOverWriteCopy(dpath, tdpath))
{
throw new Exception($"Unable to create temp data result [{dpath}] to [{tdpath}]");
}
}
else if (File.Exists(aresultsCol.Key.tempatePath) && !Tools.FileOverWriteCopy(aresultsCol.Key.tempatePath, tdpath))
{
throw new Exception($"Unable to create temp data result [{aresultsCol.Key.tempatePath}] to [{tdpath}] with template [{aresultsCol.Key.tempatePath}]");
}
var bindmaps = getBindMaps(aresultsCol.Key);
configs[XCDconfigsEnum.cwwsn.ToString()] = aresultsCol.Key.targetSheet ?? Path.GetFileNameWithoutExtension(dpath);
var headersID = aresultsCol.Key.headersPath;
if (!String.IsNullOrWhiteSpace(headersID) && !DATARSTHeader.headers.ContainsKey(headersID))
{
YamlStream yaml = new YamlStream();
using (var sr = new FileInfo(headersID).OpenText())
yaml.Load(sr);
(yaml.Documents[0].RootNode as YamlMappingNode).Children.Where(e => !ConsolidateHelper.isIgnoredHeader(e.Value?.ToString())).Select(e => new DATARSTHeader(e.Value.ToString(), headersID, DATARSTHeader.headers.GetValueOrDefault(headersID)?.FirstOrDefault(h => h.name == e.Value.ToString())?.value ?? 0)).ToArray();
}
var headers = DATARSTHeader.headers?.GetValueOrDefault(headersID);
var sqlPFile = String.IsNullOrWhiteSpace(aresultsCol.Key.sqlPath) ? "" : (pnc?.execute(aresultsCol.Key.sqlPath, null, null) ?? aresultsCol.Key.sqlPath);
if (File.Exists(aresultsCol.Key.sqlTemplatePath))
{
if (!Tools.FileOverWriteCopy(aresultsCol.Key.sqlTemplatePath, sqlPFile))
{
throw new Exception("Unable to create temp data result @:" + tdpath);
}
}
configs[PSTconfigsEnum.template.ToString()] = aresultsCol.Key.sqlQueryTemplate;
Directory.CreateDirectory(Path.GetDirectoryName(sqlPFile));
Directory.CreateDirectory(Path.GetDirectoryName(dpath));
using (PersistenceSQLProcessor pp = String.IsNullOrWhiteSpace(sqlPFile) ? null : new PersistenceSQLProcessor(sqlPFile, configs.ContainsKey(PSTconfigsEnum.pstConnString.ToString()) && !String.IsNullOrWhiteSpace(configs[PSTconfigsEnum.pstConnString.ToString()]) ? configs[PSTconfigsEnum.pstConnString.ToString()] : "", bindmaps))
using (XlsxResultProcessor p = String.IsNullOrWhiteSpace(dpath) ? null : new XlsxResultProcessor(tdpath, configs[XCDconfigsEnum.cwwsn.ToString()], bindmaps, headers))
success = new XlsxConsolidator()
{
headers = headers,
evals = evals,
bindmaps = bindmaps
}.consolidate(new List <IProcessor <IDictionary <String, String>, Object> >()
{
pp, p
}, aresultsCol.Value, configs);
//Transfering consolation results to designated paths
if (!mergeTempResults(tdpath, dpath))
{
throw new Exception($"[{dpath}] transfer filed...");
}
if (!String.IsNullOrWhiteSpace(sqlPFile) && !Tools.FileOverWriteMove(sqlPFile, sqlPFile + ".sql"))
{
throw new Exception($"[{sqlPFile}] transfer filed...");
}
}
if (success)
{
moveto = configs[EPconfigsEnum.sucFolder.ToString()];
try
{
if (configs.ContainsKey(EPconfigsEnum.saveMailPath.ToString()))
{
saveMailtoLocal(subject, configs[EPconfigsEnum.saveMailPath.ToString()]);
}
}
catch (Exception ex)
{
Logger.Log(ex);
}
}
else
{
throw new Exception($"Attachment [{attachment.FileName}] consolidation filed...");
}
}
try
{
if (configs.ContainsKey(EPconfigsEnum.emailLogConnString.ToString()))
{
foreach (var fname in resultsCol.SelectMany(r => r.Value))
{
using (PersistenceSQLProcessor pp = new PersistenceSQLProcessor(Path.Combine(pstpath, guid + ".log"), configs[EPconfigsEnum.emailLogConnString.ToString()], null))
Logger.WriteToConsole($"Logged to DB for [{fname.Key}], result:{pp.process(evals.Append(new KeyValuePair<string, string>("ImportResult", fname.Value.Any(v => v.Value == false) ? "FAIL" : "SUCCESS")).Append(new KeyValuePair<string, string>("ImportErrorMessage", Tools.SafeSubstring($"[{String.Join(",", fname.Value?.Select(v => $"{{\"{v.Key}\":\"{v.Value?.ToString() ?? "null"}\"}}"))}]", 0, 499))).Append(new KeyValuePair<string, string>("AttachmentFileName", Tools.SafeSubstring(Path.GetFileName(fname.Key), 0, 99))).Append(new KeyValuePair<string, string>("Filename", Tools.SafeSubstring(Path.GetFileName(currentEmailFilePath ?? ""), 0, 99))).Append(new KeyValuePair<string, string>("guid", guid)).ToDictionary(prop => prop.Key, prop => prop.Value), null, new Dictionary<String, String>() { { PSTconfigsEnum.template.ToString(), configs[EPconfigsEnum.emailLogTemplate.ToString()] } })}");
}
}
}
catch (Exception ex)
{
Logger.Log(ex);
}
}
catch (Exception ex)
{
error = true;
Logger.Log(ex);
rhtml = ex.StackTrace.ToString();
success = false;
}
finally
{
Marshal.ReleaseComObject(attachment);
attachment = null;
}
if (error)
{
new EmailResponseController().execute(subject, new EmailResponseConfig()
{
oApp = oApp, defaultMessage = rhtml ?? "Error occurred!", replyRecipients = configs[EPconfigsEnum.AdminEmail.ToString()]?.Split(";")
});
moveto = configs[EPconfigsEnum.rdestFolder.ToString()];
if (String.IsNullOrEmpty(moveto) || moveto == configs[EPconfigsEnum.destFolder.ToString()])
{
clearCat = true;
}
Logger.WriteToConsole($"Prepared internal error response for [{subject.Subject}]");
}
else
{
if (success)
{
clearCat = true;
Logger.WriteToConsole($"Cleared mark for [{subject.Subject}]");
}
if (avalCols.Any())
{
foreach (var avalcol in avalCols)
{
var t = validColsCols.First(vc => vc == avalcol.Key);
new EmailResponseController().execute(subject, new EmailResponseConfig()
{
oApp = oApp, replyRecipients = avalcol.Value == null ? t.sucEmails : t.rejEmails, template = avalcol.Value == null ? t.sucTemplate : t.rejTemplate, rows = avalcol.Value, sentonbehalf = configs.ContainsKey(EPconfigsEnum.sentonbehalf.ToString()) ? configs[EPconfigsEnum.sentonbehalf.ToString()] : null, ResultMap = t.ResultMap
});
if (!success)
{
moveto = t.rejFolder;
if (moveto == null)
{
clearCat = true;
}
}
Logger.WriteToConsole($"Sending response template [{(success ? t.sucTemplate : t.rejTemplate)}] for [{subject.Subject}]");
}
}
else if (resultsCol?.Any() == true)
{
new EmailResponseController().execute(subject, new EmailResponseConfig()
{
oApp = oApp, template = configs.ContainsKey(EPconfigsEnum.sucTemplate.ToString()) ? new FileInfo(configs[EPconfigsEnum.sucTemplate.ToString()]) : null, sentonbehalf = configs.ContainsKey(EPconfigsEnum.sentonbehalf.ToString()) ? configs[EPconfigsEnum.sentonbehalf.ToString()] : null, savesentfolder = configs.ContainsKey(EPconfigsEnum.saveSentFolder.ToString()) ? configs[EPconfigsEnum.saveSentFolder.ToString()] : null
});
Logger.WriteToConsole($"Sending response success template for [{subject.Subject}]");
}
else if (success)
{
movetoinbox = true;
Logger.WriteToConsole($"Moving to [{configs[EPconfigsEnum.retfolder.ToString()]}] due to having nothing to load...");
}
else
{
Logger.WriteToConsole($"Unknown error occurred for [{subject.Subject}] ...");
}
}
}
else
{
movetoinbox = true;
}
if (saveChanges)
{
if (movetoinbox)
{
clearCat = true; moveto = configs[EPconfigsEnum.retfolder.ToString()];
}
if (clearCat)
{
subject.Categories = null; subject.Save();
}
if (moveto != null && moveto != configs[EPconfigsEnum.destFolder.ToString()])
{
var movetohandle = oApp.Session.Stores[configs[EPconfigsEnum.storename.ToString()]].GetRootFolder().Folders[moveto];
subject.Move(movetohandle);
Marshal.ReleaseComObject(movetohandle);
movetohandle = null;
Logger.WriteToConsole($"Moved [{subject.Subject}] to [{moveto}]");
}
}
return(success);
}