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