public Dictionary<int, SystemLog> GetAllSystemLogs(ref string errMessage)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
var list = new Dictionary<int, SystemLog>();
try
{
DataSet ds = SystemLogDataAccess.GetAllSystemLogs(db);
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 static int Insert(Database db, SystemLog systemLog)
{
StringBuilder sbField = new StringBuilder();
StringBuilder sbValue = new StringBuilder();
sbField.Append("INSERT INTO SystemLog(");
sbValue.Append("values(");
sbField.Append("Happentime");
sbValue.AppendFormat("'{0}'", systemLog.HappenTime);
sbField.Append(",systemtypeid");
sbValue.AppendFormat(",{0}", systemLog.SystemTypeId);
sbField.Append(",systemtypename");
sbValue.AppendFormat(",'{0}'", systemLog.SystemTypeName);
sbField.Append(",content");
sbValue.AppendFormat(",'{0}'", systemLog.Content);
sbField.Append(",sysusername");
sbValue.AppendFormat(",'{0}'", systemLog.SyeUserName);
sbField.Append(",clientusername");
sbValue.AppendFormat(",'{0}'", systemLog.ClientUserName);
sbField.Append(",clientuserid)");
sbValue.AppendFormat(",{0})", systemLog.ClientUserId);
string cmdText = sbField.ToString() + " " + sbValue.ToString();
try
{
cmdText = cmdText.Replace("\r\n", "");
return db.ExecuteNonQuery(CommandType.Text, cmdText);
}
catch (Exception ex)
{
throw ex;
}
}
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;
}
}
