public EntLog Inserir(EntLog objLog)
{
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
objLog = dalLog.Inserir(objLog, transaction, db);
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw;
}
finally
{
connection.Close();
}
}
return(objLog);
}
private List <EntLog> Popular(DbDataReader dtrDados)
{
List <EntLog> listEntReturn = new List <EntLog>();
EntLog entReturn;
try
{
while (dtrDados.Read())
{
entReturn = new EntLog();
entReturn.IdLog = ObjectUtils.ToInt(dtrDados["CDA_LOG"]);
entReturn.Log = ObjectUtils.ToString(dtrDados["TX_LOG"]);
entReturn.TipoLog = ObjectUtils.ToInt(dtrDados["NU_TIPO_LOG"]);
entReturn.DateEvento = ObjectUtils.ToDate(dtrDados["DT_EVENTO"]);
entReturn.Usuario.IdUsuario = ObjectUtils.ToInt(dtrDados["CEA_USUARIO"]);
entReturn.Usuario.Usuario = ObjectUtils.ToString(dtrDados["TX_USUARIO"]);
listEntReturn.Add(entReturn);
}
dtrDados.Close();
}
catch (Exception ex)
{
throw ex;
}
return(listEntReturn);
}
protected void SaveLog(Int32 IdUsuario, Int32 TipoLog, String Log, Int32 IdEntidade, object Entidade, DbTransaction transaction, Database db)
{
EntLog log = new EntLog();
log.DateEvento = DateTime.Now;
log.Usuario.IdUsuario = IdUsuario;
log.TipoLog = TipoLog;
log.Log = Log + " " + EntLog.GetMyProperties(Entidade);
if (IdEntidade > 0)
{
log.Log = log.Log + " (ID " + IdEntidade + ")";
}
dalLog.Inserir(log, transaction, db);
}
public EntLog Inserir(EntLog objLog, DbTransaction transaction, Database db)
{
DbCommand dbCommand = db.GetStoredProcCommand("STP_LogInserir");
dbCommand.CommandTimeout = BdConfig.CommmandTimeout;
db.AddOutParameter(dbCommand, "@CDA_LOG", DbType.Int32, objLog.IdLog);
db.AddInParameter(dbCommand, "@TX_LOG", DbType.String, objLog.Log);
db.AddInParameter(dbCommand, "@NU_TIPO_LOG", DbType.Int32, IntUtils.ToIntNullProc(objLog.TipoLog));
db.AddInParameter(dbCommand, "@DT_EVENTO", DbType.DateTime, DateTime.Now);
db.AddInParameter(dbCommand, "@CEA_USUARIO", DbType.Int32, IntUtils.ToIntNullProc(objLog.Usuario.IdUsuario));
db.ExecuteNonQuery(dbCommand, transaction);
objLog.IdLog = ObjectUtils.ToInt(db.GetParameterValue(dbCommand, "@CDA_LOG"));
return(objLog);
}
protected void SaveLog(Int32 IdUsuario, Int32 TipoLog, String Log, Int32 IdEntidade, object Entidade, String Erro, Database db, DbConnection connection)
{
DbTransaction transaction = connection.BeginTransaction();
try
{
EntLog log = new EntLog();
log.DateEvento = DateTime.Now;
log.Usuario.IdUsuario = IdUsuario;
log.TipoLog = TipoLog;
log.Log = Log + " " + EntLog.GetMyProperties(Entidade);
if (IdEntidade > 0)
{
log.Log = log.Log + " (ID " + IdEntidade + "): " + Erro;
}
dalLog.Inserir(log, transaction, db);
}
catch
{
transaction.Rollback();
throw;
}
}
