//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); }