//Loads the all the JSON files from the Streaming Assets
void LoadFileNames(string dir)
{
procedureName = new List <string>();
proceduresPath = new List <string>();
string location = Application.streamingAssetsPath;
try
{
string temp = location + dir;
foreach (string file in System.IO.Directory.GetFiles(temp))
{
string label = file.Replace(temp, ""); // file (e.x. = procedure1.JSON)
if (label.EndsWith(".json"))
{
string contents = System.IO.File.ReadAllText(temp + label);
ProcedureNames procedureNames = JsonUtility.FromJson <ProcedureNames>(contents);
// Debug.Log(procedureNames.title);
procedureName.Add(procedureNames.title);
proceduresPath.Add(label);
}
}
}
catch (System.Exception ex)
{
Debug.Log("Error: JSON input. " + ex.Message);
}
}
/// <summary>
/// Gets table from database depending on recieved object.
/// </summary>
/// <param name="procName">Selected procedure from ProcedureNames enum.</param>
/// <returns>DataTable based on condition</returns>
public DataTable GetTable(ProcedureNames procName, string param = null)
{
DataTable dt = new DataTable();
string query = $"EXEC {CreateQuery(procName, param)};";
try
{
using SqlConnection conn = new SqlConnection(ConnHelper.ConnStr(connection_name));
using SqlDataAdapter sda = new SqlDataAdapter(query, conn);
//Fill the DataTable with records from Table.
sda.Fill(dt);
}
catch (SqlException e)
{
MessageBox.Show(
$"Provjerite vezu sa bazom podataka.\n {e.Message}",
"Greška",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
catch (Exception e)
{
MessageBox.Show(
$"Nepoznata greška kod dohvata županija, kontaktirajte podršku.\n {e.Message}",
"Greška",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
return(dt);
}
private string CreateQuery(ProcedureNames name, string param = null)
{
return(name switch
{
ProcedureNames.Placa_Distinct_Datum => "Placa_Distinct_Datum",
ProcedureNames.Dodatak_Distinct_Datum => "Dodatak_Distinct_Datum",
ProcedureNames.Drop_Table => "Drop_Table " + param,
ProcedureNames.PlacaPregled => "PlacaPregled",
ProcedureNames.Prebaci_postBroj => "Prebaci_postBroj",
ProcedureNames.Prebaci_prirez => "Prebaci_prirez",
ProcedureNames.Joppd_podaci => "Joppd_podaci",
ProcedureNames.Get_Table_Names => "Get_Table_Names",
ProcedureNames.Izdvoji_Troskove => "Izdvoji_Troskove",
ProcedureNames.Izdvoji_Odobrenja => "Izdvoji_Odobrenja",
ProcedureNames.Izvod_GetLastId => "Izvod_GetLastId",
ProcedureNames.Izdvoji_Repromaterijal => "Izdvoji_Repromaterijal",
_ => "",
});
/// <summary>
/// Gets the query condition.
/// </summary>
/// <returns></returns>
public string GetQueryCondition(string alias, string ownerFilter, string aliasObjectName)
{
//const string param1 = ":ownername";
//const string param2 = ":tablename";
string param1 = OwnerNames == null ? null : "'" + string.Join("','", OwnerNames) + "'";
string param2 = TableNames == null ? null : "'" + string.Join("','", TableNames) + "'";
string param3 = ProcedureNames == null ? null : "'" + string.Join("','", ProcedureNames) + "'";
DbParams.Clear();
string s = string.Empty;
List <string> tags = new List <string> {
" ", " AND ", " AND "
};
List <string> conditions = new List <string>();
if (OwnerNames != null && OwnerNames.Any())
{
DbParams.Add(OracleContext.Manager.CreateParameter(param1, ParameterDirection.Input, "'" + string.Join("','", OwnerNames) + "'"));
conditions.Add(string.Format(alias + "." + ownerFilter + " IN (" + param1 + ")"));
}
if (TableNames != null && TableNames.Any())
{
DbParams.Add(OracleContext.Manager.CreateParameter(param2, ParameterDirection.Input, "'" + string.Join("','", TableNames) + "'"));
conditions.Add(alias + ".TABLE_NAME IN (" + param2 + ")");
}
if (ProcedureNames != null && ProcedureNames.Any())
{
DbParams.Add(OracleContext.Manager.CreateParameter(param3, ParameterDirection.Input, "'" + string.Join("','", ProcedureNames) + "'"));
conditions.Add(string.Format(alias + "." + aliasObjectName + " IN (" + param3 + ")"));
}
// additionner toutes les conditions dans la requete
int i = 0;
foreach (string cond in conditions)
{
s += (tags[i++] + cond);
}
return(s);
}
private static Optional <MultiClusterRoutingResult> CallProcedure(CoreGraphDatabase db, ProcedureNames procedure, IDictionary <string, object> @params)
{
Optional <MultiClusterRoutingResult> routingResult = null;
using (InternalTransaction tx = Db.beginTransaction(KernelTransaction.Type.@explicit, EnterpriseLoginContext.AUTH_DISABLED), Result result = Db.execute(tx, "CALL " + procedure.callName(), ValueUtils.asMapValue(@params)))
{
//JAVA TO C# CONVERTER TODO TASK: Java iterators are only converted within the context of 'while' and 'for' loops:
if (result.HasNext())
{
//JAVA TO C# CONVERTER TODO TASK: Java iterators are only converted within the context of 'while' and 'for' loops:
routingResult = MultiClusterRoutingResultFormat.parse(result.Next());
}
}
return(routingResult);
}
