private void LoadTrigers() { Trigers.Clear(); string strSelectTrigers = "SELECT * FROM USER_TRIGGERS T"; DataTable dtTrigers = new DataTable(); this.FillDataTable(ref dtTrigers, strSelectTrigers); LogManager.LogWriter.Debug(dtTrigers.Rows.Count.ToString() + " Trigger Bulundu..."); foreach (DataRow row in dtTrigers.Rows) { Triger trg = new Triger() { Name = row["TRIGGER_NAME"].ToString(), Owner = this }; Trigers.Add(trg); LogManager.LogWriter.Info("Triger Yapısı Okundu : " + trg.Name); FireEvent("Triger Generated : " + trg.Name); } }
private void LoadProcedure() { string strSelectSql = "SELECT DISTINCT OBJECT_NAME,OBJECT_TYPE FROM USER_PROCEDURES"; DataTable dtProcedure = new DataTable(); this.FillDataTable(ref dtProcedure, strSelectSql); LogManager.LogWriter.Debug(dtProcedure.Rows.Count.ToString() + " Procedure Bulundu"); foreach (DataRow dataRow in dtProcedure.Rows) { if (dataRow["OBJECT_TYPE"].ToString() == "FUNCTION") { Function func = new Function() { Name = dataRow["OBJECT_NAME"].ToString() }; func.Owner = this; func.BuildSql(); this.Functions.Add(func); LogManager.LogWriter.Info("Function Yapısı Okundu : " + func.Name); FireEvent("Function Created : " + func.Name); } else if (dataRow["OBJECT_TYPE"].ToString() == "TRIGGER") { try { Triger trg = new Triger() { Name = dataRow["OBJECT_NAME"].ToString() }; trg.Owner = this; trg.BuildSql(); this.Trigers.Add(trg); LogManager.LogWriter.Info("Triger Yapısı Okundu : " + trg.Name); FireEvent("Triger Created : " + trg.Name); } catch (Exception ex) { LogManager.LogWriter.Error("Triger Oluşturulamadı !: " + ex.Message); } } else if (dataRow["OBJECT_TYPE"].ToString() == "PACKAGE") { Package pck = new Package() { Name = dataRow["OBJECT_NAME"].ToString() }; pck.Owner = this; pck.BuildSql(); this.Packages.Add(pck); LogManager.LogWriter.Info("PACKAGE Yapısı Okundu : " + pck.Name); FireEvent("Triger Package : " + pck.Name); } else if (dataRow["OBJECT_TYPE"].ToString() == "PROCEDURE") { Procedure proc = new Procedure() { Name = dataRow["OBJECT_NAME"].ToString() }; proc.Owner = this; proc.BuildSql(); this.Procedures.Add(proc); LogManager.LogWriter.Info("PROCEDURE Yapısı Okundu : " + proc.Name); FireEvent("Triger Procedure : " + proc.Name); } } }