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 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);
}
void Awake()
{
propertyType = "malewig";
//GetComponent<Button>().onClick.AddListener(UseThisWig);
rfm = GameObject.FindGameObjectWithTag("ResourceFileManager").GetComponent <ResourceFileManager>();
gameController = GameObject.FindGameObjectWithTag("GameController").GetComponent <GameController>();
}
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);
}
public override DbSharper2.Schema.Database.Database GetSchema(string connectionString)
{
this.connectionString = connectionString;
this.database = new DbSharper2.Schema.Database.Database();
this.resourceFileManager = new ResourceFileManager(Assembly.GetExecutingAssembly());
DataSet ds = this.GetSchemaDataSet();
this.LoadDatabaseSchema(ds);
return(this.database);
}
/// <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>
/// Default constructor
/// </summary>
public ManageConsoleOutputs()
{
resourceMan = new ResourceFileManager();
}
public void InitializeOrnamentProperty(MiniJsonObject m)
{
if (gameController == null)
{
gameController = GameObject.FindGameObjectWithTag("GameController").GetComponent <GameController>();
}
if (rfm == null)
{
rfm = GameObject.FindGameObjectWithTag("ResourceFileManager").GetComponent <ResourceFileManager>();
}
propertyType = "ornament";
GetComponent <Button>().onClick.RemoveAllListeners();
GetComponent <Button>().onClick.AddListener(InvokeUseThisOrnament);
mo = m;
serializedJsonObject = mo.ToString(); //MiniJSON.jsonEncode(m);
wearingCode = mo.GetField("type_id", -1);
imgName = mo.GetField("icon", "");
lockStatus = mo.GetField("lock_status", "false");
if (!gameController.IsPaidUser && lockStatus == "true")
{
//GetComponent<Button>().interactable = false; // may we need to change this..?
transform.GetChild(0).gameObject.SetActive(true);
}
switch (wearingCode)
{
case 1: //download female dress
{
if (imgName != "")
{
finalImageUrl = string.Format(rfm.imageUrlFormat, imgName);
finalSavePath = Path.Combine(rfm.dataPathDict["dressFemaleDataPath"], imgName);
//StartCoroutine(DownloadImage(finalImageUrl, finalSavePath));
//UpdateDownloadInfo();
}
break;
}
case 2: //download female wig
{
if (imgName != "")
{
finalImageUrl = string.Format(rfm.imageUrlFormat, imgName);
finalSavePath = Path.Combine(rfm.dataPathDict["wigFemaleDataPath"], imgName);
//StartCoroutine(DownloadImage(finalImageUrl, finalSavePath));
//UpdateDownloadInfo();
}
break;
}
case 3: //download female ornament
{
if (imgName != "")
{
finalImageUrl = string.Format(rfm.imageUrlFormat, imgName);
finalSavePath = Path.Combine(rfm.dataPathDict["ornamentFemaleDataPath"], imgName);
//StartCoroutine(DownloadImage(finalImageUrl, finalSavePath));
//UpdateDownloadInfo();
}
break;
}
case 4: //download female shoe
{
if (imgName != "")
{
finalImageUrl = string.Format(rfm.imageUrlFormat, imgName);
finalSavePath = Path.Combine(rfm.dataPathDict["shoeFemaleDataPath"], imgName);
//StartCoroutine(DownloadImage(finalImageUrl, finalSavePath));
//UpdateDownloadInfo();
}
break;
}
case 5: //download male wig
{
if (imgName != "")
{
finalImageUrl = string.Format(rfm.imageUrlFormat, imgName);
finalSavePath = Path.Combine(rfm.dataPathDict["wigMaleDataPAth"], imgName);
//StartCoroutine(DownloadImage(finalImageUrl, finalSavePath));
//UpdateDownloadInfo();
}
break;
}
case 6: // download male tie
{
if (imgName != "")
{
finalImageUrl = string.Format(rfm.imageUrlFormat, imgName);
finalSavePath = Path.Combine(rfm.dataPathDict["tieMaleDataPath"], imgName);
//StartCoroutine(DownloadImage(finalImageUrl, finalSavePath));
//UpdateDownloadInfo();
}
break;
}
default:
{
break;
}
}
_isInitialized = true;
StartCoroutine(SetImage());
}
/// <summary>
/// Default contructor
/// </summary>
public GenerateHtmlTestReport()
{
resourceMan = new ResourceFileManager();
}
public void InitializeShoeProperty(string jsonString, Color sc)
{
if (jsonString == "" || jsonString == null)
{
IsInitialized = false;
return;
}
MiniJsonObject m = new MiniJsonObject(jsonString);
if (gameController == null)
{
gameController = GameObject.FindGameObjectWithTag("GameController").GetComponent <GameController>();
}
if (rfm == null)
{
rfm = GameObject.FindGameObjectWithTag("ResourceFileManager").GetComponent <ResourceFileManager>();
}
propertyType = "shoe";
//GetComponent<Button>().onClick.RemoveAllListeners();
//GetComponent<Button>().onClick.AddListener(UseThisDress);
mo = m;
serializedJsonObject = mo.ToString(); //MiniJSON.jsonEncode(mo);
wearingCode = mo.GetField("type_id", -1);
imgName = mo.GetField("icon", "");
lockStatus = mo.GetField("lock_status", "false");
//if (!gameController.IsPaidUser && lockStatus == "true")
//{
// GetComponent<Button>().interactable = false;
// transform.GetChild(0).gameObject.SetActive(true);
//}
switch (wearingCode)
{
case 1: //download female dress
{
if (imgName != "")
{
finalImageUrl = string.Format(rfm.imageUrlFormat, imgName);
finalSavePath = Path.Combine(rfm.dataPathDict["dressFemaleDataPath"], imgName);
//finalSavePath = Path.Combine(rfm.dataPathDict["thumb_dressFemaleDataPath"], imgName);
//StartCoroutine(DownloadImage(finalImageUrl, finalSavePath));
//UpdateDownloadInfo();
}
break;
}
case 2: //download female wig
{
if (imgName != "")
{
finalImageUrl = string.Format(rfm.imageUrlFormat, imgName);
finalSavePath = Path.Combine(rfm.dataPathDict["wigFemaleDataPath"], imgName);
//finalSavePath = Path.Combine(rfm.dataPathDict["thumb_wigFemaleDataPath"], imgName);
//StartCoroutine(DownloadImage(finalImageUrl, finalSavePath));
//UpdateDownloadInfo();
}
break;
}
case 3: //download female ornament
{
if (imgName != "")
{
finalImageUrl = string.Format(rfm.imageUrlFormat, imgName);
finalSavePath = Path.Combine(rfm.dataPathDict["ornamentFemaleDataPath"], imgName);
//finalSavePath = Path.Combine(rfm.dataPathDict["thumb_ornamentFemaleDataPath"], imgName);
//StartCoroutine(DownloadImage(finalImageUrl, finalSavePath));
//UpdateDownloadInfo();
}
break;
}
case 4: //download female shoe
{
if (imgName != "")
{
finalImageUrl = string.Format(rfm.imageUrlFormat, imgName);
finalSavePath = Path.Combine(rfm.dataPathDict["shoeFemaleDataPath"], imgName);
//finalSavePath = Path.Combine(rfm.dataPathDict["thumb_shoeFemaleDataPath"], imgName);
//StartCoroutine(DownloadImage(finalImageUrl, finalSavePath));
//UpdateDownloadInfo();
}
break;
}
case 5: //download male wig
{
if (imgName != "")
{
finalImageUrl = string.Format(rfm.imageUrlFormat, imgName);
finalSavePath = Path.Combine(rfm.dataPathDict["wigMaleDataPAth"], imgName);
//finalSavePath = Path.Combine(rfm.dataPathDict["thumb_wigMaleDataPAth"], imgName);
//StartCoroutine(DownloadImage(finalImageUrl, finalSavePath));
//UpdateDownloadInfo();
}
break;
}
case 6: // download male tie
{
if (imgName != "")
{
finalImageUrl = string.Format(rfm.imageUrlFormat, imgName);
finalSavePath = Path.Combine(rfm.dataPathDict["tieMaleDataPath"], imgName);
//finalSavePath = Path.Combine(rfm.dataPathDict["thumb_tieMaleDataPath"], imgName);
//StartCoroutine(DownloadImage(finalImageUrl, finalSavePath));
//UpdateDownloadInfo();
}
break;
}
default:
{
break;
}
}
shoeColor = new float[] { sc.r, sc.g, sc.b, sc.a };
_isInitialized = true;
print("successfully init shoeproperty");
//StartCoroutine(SetImage());
}
/// <summary>
/// Default constructor
/// </summary>
public ManageConsoleArguments()
{
resourceMan = new ResourceFileManager();
}
/// <summary>
/// Constructor that takes a Oracle Database instance
/// </summary>
/// <param name="database"></param>
public ReadDataForReport(OracleDatabase database)
{
_database = database;
resourceFileManager = ResourceFileManager.Instance;
resourceFileManager.SetResources();
}
/// <summary>
/// Default constructor
/// </summary>
public ParseDocumentationFile()
{
resourceMan = new ResourceFileManager();
}
/// <summary>
/// Default constructor
/// </summary>
public ParseTestReportFile()
{
resourceMan = new ResourceFileManager();
}
