public Dictionary <int, SystemLog> GetSystemLogs(ref string errMessage, string filter)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
var list = new Dictionary <int, SystemLog>();
try
{
DataSet ds = SystemLogDataAccess.GetSystemLogs(db, filter);
SystemLog systemLog;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
systemLog = new SystemLog(ds.Tables[0].Rows[i]);
list.Add(systemLog.Id, systemLog);
}
return(list);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
Logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}
public int Insert(ref string errMessage, SystemLog systemLog)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
return(SystemLogDataAccess.Insert(db, systemLog));
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
Logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(-1);
}
}
public int Delete(ref string errMessage, int id)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
int iRtn = SystemLogDataAccess.Delete(db, id);
return(iRtn);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
Logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(-1);
}
}
public DataTable GetSystemLogDataSet(ref string errMessage, string filter)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
DataSet ds = SystemLogDataAccess.GetSystemLogs(db, filter);
return(ds.Tables[0]);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
Logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}
public ArrayList GetSystemLogTypes(ref string errMessage)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
var list = new ArrayList();
try
{
DataSet ds = SystemLogDataAccess.GetSystemLogTypes(db);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
list.Add(ds.Tables[0].Rows[i][0].ToString());
}
return(list);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
Logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}
