/// <summary>
/// Recupera uma lista de eventos
/// </summary>
/// <param name="count">Quantidade maxima de mensagens que devem ser retornadas</param>
/// <returns></returns>
public Dictionary <long, string> GetList(int count = 100)
{
Dictionary <long, string> ret = new Dictionary <long, string>();
List <Entities.Log> evs = new List <Entities.Log>();
using (IDbConnection db = base.GetConnection())
using (IDbCommand cmd = db.CreateCommand())
{
cmd.CommandText = "SELECT IdLog, Message from Log order by IdLog asc LIMIT " + count;
cmd.CommandType = CommandType.Text;
db.Open();
cmd.Prepare();
IDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Entities.Log log = new Entities.Log();
log.IdLog = reader.GetInt64(reader.GetOrdinal("IdLog"));
log.Message = reader.IsDBNull(reader.GetOrdinal("Message")) ? null : reader.GetString(reader.GetOrdinal("Message"));
evs.Add(log);
}
}
foreach (Entities.Log item in evs)
{
ret.Add(item.IdLog, item.Message);
}
return(ret);
}
/// <summary>
/// Recupera um evento do banco de dados
/// </summary>
/// <param name="id">Codigo do evento</param>
/// <returns></returns>
public NetStashEvent Get(out long id)
{
Entities.Log getLog = null;
using (IDbConnection db = GetConnection())
using (IDbCommand cmd = db.CreateCommand())
{
cmd.CommandText = "SELECT IdLog, Message from Log order by IdLog asc LIMIT 1";
cmd.CommandType = CommandType.Text;
db.Open();
cmd.Prepare();
IDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
getLog = new Entities.Log
{
IdLog = reader.GetInt64(reader.GetOrdinal("IdLog")),
Message = reader.IsDBNull(reader.GetOrdinal("Message"))
? null
: reader.GetString(reader.GetOrdinal("Message"))
};
}
}
if (getLog == null)
{
id = -1;
return(null);
}
id = getLog.IdLog;
return(JsonConvert.DeserializeObject <NetStashEvent>(getLog.Message));
}
public void Add(NetStashEvent log)
{
Entities.Log addLog = new Entities.Log();
//addLog.Message = Newtonsoft.Json.JsonConvert.SerializeObject(log);
//Microsoft.AspNetCore.Formatter.Json
string JsonString = log.GetJson();
addLog.Message = JsonString;
using (IDbConnection db = NetStashStandard.Log.NetStashLog.TypeNet == Log.TypeNet.NetCore ? baseProxy.GetConnectionSqlite() : baseProxy.GetConnection())
using (IDbCommand cmd = db.CreateCommand())
{
cmd.CommandText = "INSERT INTO Log (Message) VALUES (@Message)";
cmd.CommandType = CommandType.Text;
IDbDataParameter pMessage = cmd.CreateParameter();
pMessage.ParameterName = "@Message";
pMessage.Value = addLog.Message;
cmd.Parameters.Add(pMessage);
cmd.Prepare();
db.Open();
cmd.ExecuteNonQuery();
}
}
public void AddLog(string message, LogDetails details)
{
var existingClass = GetExistingOrNewClass(details);
var existingMethod = GetExistingOrNewMethod(details, existingClass);
var newLogEnt = new Entities.Log
{
MethodId = existingMethod.Id,
Message = message,
DateCreated = details.TimeLogged,
LogType = (short)details.LogType
};
_logEntryData.Save(newLogEnt);
}
/// <summary>
/// Adiciona uma nova mensagem no banco de dados
/// </summary>
/// <param name="log">Evento que sera adicionado</param>
public void Add(NetStashEvent log)
{
Entities.Log addLog = new Entities.Log();
addLog.Message = Newtonsoft.Json.JsonConvert.SerializeObject(log.ToDictionary());
using (IDbConnection db = base.GetConnection())
using (IDbCommand cmd = db.CreateCommand())
{
cmd.CommandText = "INSERT INTO Log (Message) VALUES (@Message)";
cmd.CommandType = CommandType.Text;
IDbDataParameter pMessage = cmd.CreateParameter();
pMessage.ParameterName = "@Message";
pMessage.Value = addLog.Message;
cmd.Parameters.Add(pMessage);
db.Open();
cmd.Prepare();
cmd.ExecuteNonQuery();
}
}
public static List <Entities.Log> ListarLog(string ticketid)
{
var lista = new List <Entities.Log>();
using (var cn = new SqlConnection(conexion.Cadena))
{
using (var cmd = new SqlCommand("select ld.Id,ld.RobotVirtualMachineId,ro.Description as robot,ld.StateId,st.Name as state, " +
"ld.TicketId,ld.Description,ld.Exception, ld.StackTrace, ld.Method, ld.CreationDate from[EES.BBVA.2018v1].dbo.LogDatas ld " +
"left join[EES.BBVA.2018v1].dbo.RobotVirtualMachines rvm on rvm.Id = ld.RobotVirtualMachineId " +
"left join[EES.BBVA.2018v1].dbo.Robots ro on ro.Id = rvm.RobotId " +
"left join[EES.BBVA.2018v1].dbo.States st on st.Id = ld.StateId " +
"where ld.TicketId = " + ticketid + " order by ld.id desc", cn))
{
cn.Open();
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
var oLog = new Entities.Log();
oLog.id = Convert.ToString(dr[dr.GetOrdinal("Id")]);
oLog.robotvirtualmachineId = Convert.ToString(dr[dr.GetOrdinal("RobotVirtualMachineId")]);
oLog.robot = Convert.ToString(dr[dr.GetOrdinal("robot")]);
oLog.stateid = Convert.ToString(dr[dr.GetOrdinal("StateId")]);
oLog.state = Convert.ToString(dr[dr.GetOrdinal("state")]);
oLog.ticketid = Convert.ToString(dr[dr.GetOrdinal("TicketId")]);
oLog.description = Convert.ToString(dr[dr.GetOrdinal("Description")]);
oLog.exception = Convert.ToString(dr[dr.GetOrdinal("Exception")]);
oLog.method = Convert.ToString(dr[dr.GetOrdinal("Method")]);
oLog.creationdate = Convert.ToString(dr[dr.GetOrdinal("CreationDate")]);
lista.Add(oLog);
}
}
return(lista);
}
}
}