public static void add(DUAuditoria eAuditoria)
{
using (var db = new Mapeo("security"))
{
eAuditoria.Pk = "0";
db.uAuditoria.Add(eAuditoria);
db.SaveChanges();
}
}
public static void update(Object newObj, Object oldObj, string session, string esquema, string tabla)
{
DUAuditoria eAuditoria = new DUAuditoria();
eAuditoria.Fecha = DateTime.Now;
eAuditoria.Accion = "UPDATE";
eAuditoria.UserBd = "Postgres";
eAuditoria.Schema = esquema;
eAuditoria.Tabla = tabla;
eAuditoria.Session = session;
JObject jObject = new JObject();
Boolean sinCambios = true;
foreach (PropertyInfo propertyInfo in newObj.GetType().GetProperties())
{
if (propertyInfo.PropertyType == typeof(string) || propertyInfo.PropertyType == typeof(int) || propertyInfo.PropertyType == typeof(Boolean))
{
if (propertyInfo.Name.Equals("Id"))
{
jObject[propertyInfo.Name] = propertyInfo.GetValue(newObj).ToString();
}
if (!propertyInfo.GetValue(newObj).ToString().Equals(propertyInfo.GetValue(oldObj).ToString()) && !propertyInfo.Name.Equals("IdAcceso"))
{
jObject["new_" + propertyInfo.Name] = propertyInfo.GetValue(newObj).ToString();
jObject["old_" + propertyInfo.Name] = propertyInfo.GetValue(oldObj).ToString();
sinCambios = false;
}
}
else if (propertyInfo.PropertyType == typeof(List <int>) && !JsonConvert.SerializeObject(propertyInfo.GetValue(newObj)).Equals(JsonConvert.SerializeObject(propertyInfo.GetValue(oldObj))))
{
jObject["new_" + propertyInfo.Name] = JsonConvert.SerializeObject(propertyInfo.GetValue(newObj));
jObject["old_" + propertyInfo.Name] = JsonConvert.SerializeObject(propertyInfo.GetValue(oldObj));
sinCambios = false;
}
}
if (sinCambios)
{
return;
}
eAuditoria.Data = JsonConvert.SerializeObject(jObject);
daoAuditoria.add(eAuditoria);
}
public static void delete(Object obj, string session, string esquema, string tabla)
{
DUAuditoria eAuditoria = new DUAuditoria();
eAuditoria.Fecha = DateTime.Now;
eAuditoria.Accion = "DELETE";
eAuditoria.UserBd = "Postgres";
eAuditoria.Schema = esquema;
eAuditoria.Tabla = tabla;
eAuditoria.Session = session;
JObject jObject = new JObject();
foreach (PropertyInfo propertyInfo in obj.GetType().GetProperties())
{
if (propertyInfo.PropertyType == typeof(string) || propertyInfo.PropertyType == typeof(int) || propertyInfo.PropertyType == typeof(Boolean))
{
jObject[propertyInfo.Name] = propertyInfo.GetValue(obj).ToString();
}
}
eAuditoria.Data = JsonConvert.SerializeObject(jObject);
daoAuditoria.add(eAuditoria);
}
