public NameValueCollection CreateDocxMassive(ExcelDocumentReader excelDocumentReader, NameValueCollection collectionForReplace, string sPathTemplateDocx, string sColumnIdName, out string errTags) { NameValueCollection oResult = new NameValueCollection(); try { errTags = ""; string cfSelected = string.Empty; var columnNames = excelDocumentReader.GetColumnNames(); ResourceFileManager resourceFileManager = ResourceFileManager.Instance; resourceFileManager.SetResources(); string sColumnIdSubject = resourceFileManager.getConfigData(sColumnIdName); //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 (Novacode.DocX document = Novacode.DocX.Load(sPathTemplateDocx)) { // 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()); if (columnName == sColumnIdSubject) { cfSelected = a[columnName].ToString(); } } for (int i = 0; i < collectionForReplace.Count; i++) { document.ReplaceText("«" + collectionForReplace.GetKey(i) + "»", collectionForReplace.GetValues(i)[0]); } // 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 + " "; } throw new ArgumentException("Sono stati trovati i seguenti tag non sostituiti: " + errTags); //break; } else { document.SaveAs(excelDocumentReader.sTransactionPath + iIndiceFile + ".docx"); oResult.Add(cfSelected, excelDocumentReader.sTransactionPath + iIndiceFile + ".docx"); } } iIndiceFile += 1; } } catch (Exception ex) { throw new ArgumentException(ex.Message); } finally { } return(oResult); }
public Boolean GetDataFromAnag(ExcelDocumentReader excelDocumentReader, string sColumnName, string sIdAnag, out string sValueAnag) { Boolean bResult = false; sValueAnag = ""; try { ResourceFileManager resourceFileManager = ResourceFileManager.Instance; resourceFileManager.SetResources(); var columnNames = excelDocumentReader.GetColumnNames(); //var getData = excelDocumentReader.getData<LinqToExcel.Row>(); // Ciclo i singoli record estrapolati dal file excel foreach (var a in excelDocumentReader.getData) { // Cerco nella lista il codice fiscale per individuare univocamente il soggetto if (a[resourceFileManager.getConfigData("CancAnagCodOCFNameField")].ToString() == sIdAnag) { sValueAnag = a[a.ColumnNames.Count() + int.Parse(resourceFileManager.getConfigData(sColumnName))].ToString(); break; } } bResult = true; } catch (Exception ex) { throw ex; } finally { } return(bResult); }
public Boolean GetCsvRecordKV(ExcelDocumentReader excelDocumentReader, string sColumnIdSubject, string cfFilter, out NameValueCollection lfieldXls) { Boolean bResult = false; lfieldXls = new NameValueCollection(); try { ResourceFileManager resourceFileManager = ResourceFileManager.Instance; resourceFileManager.SetResources(); var columnNames = excelDocumentReader.GetColumnNames(); //var getData = excelDocumentReader.getData<LinqToExcel.Row>(); // Ciclo i singoli record estrapolati dal file excel var listColumns = columnNames.Cast <string>().ToList(); foreach (var a in excelDocumentReader.getData) { // Ciclo tra i nomi delle colonne foreach (var columnName in columnNames) { // Cerco nella lista il codice fiscale per individuare univocamente il soggetto if (columnName.ToUpper().Trim() == sColumnIdSubject.ToUpper().Trim()) { if (a[columnName].ToString().ToUpper().Trim() == cfFilter.ToUpper().Trim()) { for (int i = 0; i < a.Count; i++) { DateTime dateValue; if (DateTime.TryParseExact(a[i].ToString(), "dd/MM/yyyy hh:mm:ss", new CultureInfo("it-IT"), DateTimeStyles.None, out dateValue)) { lfieldXls.Add(listColumns[i].ToString().Replace(" ", "_"), a[i].ToString().Substring(0, 10)); } else { lfieldXls.Add(listColumns[i].ToString().Replace(" ", "_"), a[i].ToString()); } } } break; } } if (lfieldXls.Count > 0) { break; } } bResult = true; } catch (Exception ex) { throw ex; } finally { } return(bResult); }
/// <summary> /// Constructor which takes the connection string name /// </summary> /// <param name="connectionStringName"></param> public OracleDatabase(string connectionString) { Rijndael oRijndael = new Rijndael(); ResourceFileManager resourceFileManager = null; resourceFileManager = ResourceFileManager.Instance; resourceFileManager.SetResources(); if (resourceFileManager.getConfigData("isTest") == "SI") { _connection = new OracleConnection(oRijndael.Decrypt(resourceFileManager.getConfigData(connectionString))); } else { _connection = new OracleConnection(oRijndael.Decrypt(resourceFileManager.getConfigData("ConnectionStringProd"))); } }
public void Convert2Pdf(string sPathDocx, out string sPathPdf) { sPathPdf = ""; string sUrlPathConvert = string.Empty; try { ResourceFileManager resourceFileManager = ResourceFileManager.Instance; resourceFileManager.SetResources(); ServicePointManager.ServerCertificateValidationCallback += new System.Net.Security.RemoteCertificateValidationCallback(customXertificateValidation); if (resourceFileManager.getConfigData("isTest") == "SI") { sUrlPathConvert = resourceFileManager.getConfigData("UrlServerConverterPDF"); } else { sUrlPathConvert = resourceFileManager.getConfigData("UrlServerConverterPDFProd"); } HttpWebRequest request = (HttpWebRequest)WebRequest.Create(sUrlPathConvert); // byte[] bytes; Byte[] bytesDocx = File.ReadAllBytes(sPathDocx); String file = Convert.ToBase64String(bytesDocx); string sBodyXml = "<?xml version=\"1.0\" encoding=\"utf-8\"?><CONVERT_DOCUMENT xmlns:dt=\"urn:schemas-microsoft-com:datatypes\"><EXT dt:dt=\"string\">DOCX</EXT><DOCUMENT dt:dt=\"bin.base64\">" + file + "</DOCUMENT></CONVERT_DOCUMENT>"; // byte[] requestBytes = System.Text.Encoding.ASCII.GetBytes(sBodyXml); request.Method = "POST"; request.ContentType = "text/xml;charset=utf-8"; request.ContentLength = requestBytes.Length; Stream requestStream = request.GetRequestStream(); requestStream.Write(requestBytes, 0, requestBytes.Length); requestStream.Close(); HttpWebResponse res = (HttpWebResponse)request.GetResponse(); StreamReader sr = new StreamReader(res.GetResponseStream(), System.Text.Encoding.Default); string backstr = sr.ReadToEnd(); XmlDocument doc = new XmlDocument(); doc.LoadXml(backstr); XmlNode node = doc.DocumentElement.SelectSingleNode("/CONVERTED_DOCUMENT"); sPathPdf = Path.GetDirectoryName(sPathDocx) + @"\" + Guid.NewGuid() + ".pdf"; File.WriteAllBytes(sPathPdf, Convert.FromBase64String(node.InnerText)); } catch (Exception ex) { throw ex; } finally { } }
public WsAction(string sUser) { ServicePointManager.ServerCertificateValidationCallback += new System.Net.Security.RemoteCertificateValidationCallback(customXertificateValidation); resourceFileManager = ResourceFileManager.Instance; resourceFileManager.SetResources(); Logger = new LOLIB(); oRijndael = new Rijndael(); if (LogId == null || LogId == "") { LogId = LOLIB.CodeGen(sUser); } string sPathWork = resourceFileManager.getConfigData("WorkFolder"); sWorkingFolder = sPathWork + @"\" + LogId; System.IO.Directory.CreateDirectory(sWorkingFolder); Logger.WriteOnLog(LogId, "Creazione della directory di lavoro: " + sWorkingFolder, 3); }
public Boolean GetCsvRecord(ExcelDocumentReader excelDocumentReader, string sColumnIdSubject, string cfFilter, out string sVauleAnag) { Boolean bResult = false; sVauleAnag = ""; try { ResourceFileManager resourceFileManager = ResourceFileManager.Instance; resourceFileManager.SetResources(); var columnNames = excelDocumentReader.GetColumnNames(); //var getData = excelDocumentReader.getData<LinqToExcel.Row>(); // Ciclo i singoli record estrapolati dal file excel var listColumns = columnNames.Cast <string>().ToList(); foreach (var a in excelDocumentReader.getData) { // Ciclo tra i nomi delle colonne foreach (var columnName in columnNames) { // Cerco nella lista il codice fiscale per individuare univocamente il soggetto if (columnName == sColumnIdSubject) { if (a[columnName].ToString() == cfFilter) { for (int i = 0; i < a.Count; i++) { sVauleAnag += listColumns[i].ToString() + "|" + a[i].ToString() + "|"; } } break; } } if (sVauleAnag != "") { break; } } bResult = true; } catch (Exception ex) { throw ex; } finally { } return(bResult); }
public ExcelDocumentReader(string ExcelFileName, string sheet = "") { try { idTransaction = Guid.NewGuid().ToString(); ResourceFileManager resourceFileManager = ResourceFileManager.Instance; resourceFileManager.SetResources(); sDefaultWorkPath = resourceFileManager._resourceManager.GetString("ExcelWorkFolder"); sTransactionPath = sDefaultWorkPath + idTransaction + @"\"; if ((ExcelFileName != null) && (ExcelFileName != "")) { this.ExcelFileName = System.IO.Path.Combine(@sDefaultWorkPath, @ExcelFileName); this.Excel = new ExcelQueryFactory(this.ExcelFileName); this.workSheet = this.Excel.GetWorksheetNames(); if (sheet == "") { sheet = workSheet.First().ToString(); } columnNames = this.Excel.GetColumnNames(sheet); getData = from a in this.Excel.Worksheet(sheet) select a; } else { throw new Exception("FileName is Null or Empty"); } bool exists = System.IO.Directory.Exists(sTransactionPath); if (!exists) { System.IO.Directory.CreateDirectory(sTransactionPath); } } catch (Exception ex) { throw ex; } finally { } }
public Boolean GetSampleRecords(ExcelDocumentReader excelDocumentReader, string sColumnIdSubject, out List <string> lCodiceFiscale) { Boolean bResult = false; lCodiceFiscale = new List <string>(); try { ResourceFileManager resourceFileManager = ResourceFileManager.Instance; resourceFileManager.SetResources(); int iRowSelected = int.Parse(resourceFileManager.getConfigData("IscReadSampleCount")); //string sColumnIdSubject = resourceFileManager._resourceManager.GetString("IscSearchValueUniqueFromAnag"); 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) { // Ciclo tra i nomi delle colonne foreach (var columnName in columnNames) { // Cerco nella lista il codice fiscale per individuare univocamente il soggetto if (columnName == sColumnIdSubject) { lCodiceFiscale.Add(a[columnName].ToString()); break; } } iIndiceFile += 1; if (iRowSelected < iIndiceFile) { break; } } bResult = true; } catch (Exception ex) { throw ex; } finally { } return(bResult); }
/// <summary> /// Constructor that takes a Oracle Database instance /// </summary> /// <param name="database"></param> public ReadDataForReport(OracleDatabase database) { _database = database; resourceFileManager = ResourceFileManager.Instance; resourceFileManager.SetResources(); }