public SendMail()
{
ResourceFileManager resourceFileManager = ResourceFileManager.Instance;
resourceFileManager.SetResources();
Email = resourceFileManager._resourceManager.GetString("emailUserDefault");
Password = resourceFileManager._resourceManager.GetString("emailPwdDefault");
Port = Convert.ToInt32(resourceFileManager._resourceManager.GetString("emailPortDefault"));
Host = resourceFileManager._resourceManager.GetString("emailSmtpDefault");
isSsl = Convert.ToBoolean(Convert.ToInt32(resourceFileManager._resourceManager.GetString("emailIsSslDefault")));
}
public Boolean CreateDocxMassive(string sNameFileDocx, string sNameFileXls, out string errTags)
{
Boolean bResult = false;
try
{
ResourceFileManager resourceFileManager = ResourceFileManager.Instance;
errTags = "";
resourceFileManager.SetResources();
string sPathWork = resourceFileManager._resourceManager.GetString("ExcelWorkFolder");
ExcelDocumentReader excelDocumentReader = new ExcelDocumentReader(sNameFileXls);
var columnNames = excelDocumentReader.GetColumnNames();
//var getData = excelDocumentReader.getData<LinqToExcel.Row>();
// Ciclo i singoli record estrapolati dal file excel
Int16 iIndiceFile = 1;
foreach (var a in excelDocumentReader.getData)
{
//Apro il FileStyleUriParser template DocX da valorizzare
using (DocX document = DocX.Load(@sPathWork + sNameFileDocx))
{
// Ciclo tra i nomi delle colonne
foreach (var columnName in columnNames)
{
// sostituisco il valore dei nomi colonne formattandole come TAG che sia suppone sia presente nel template DOCX
document.ReplaceText("«" + columnName + "»", a[columnName].ToString());
}
// Verifico che tutti i TAG presenti all'interno del file docx siano stati valorizzati
var lineBreaks = document.FindUniqueByPattern("«*\\b[^»]*»", System.Text.RegularExpressions.RegexOptions.None);
// Qualora siano presenti restituisco i tag non ripristinati come segnalazione di una anomalia
if (lineBreaks.Count > 0)
{
foreach (var tagErr in lineBreaks)
{
errTags += tagErr + " ";
}
break;
}
else
{
document.SaveAs(excelDocumentReader.sTransactionPath + iIndiceFile + ".docx");
}
}
iIndiceFile += 1;
}
bResult = true;
}
catch (Exception ex)
{ throw ex; }
finally { }
return(bResult);
}
