public static void DeleteError(KElmahDBType kElmahDBType, string errType, string errMessage)
{
if (kElmahDBType == KElmahDBType.AuditManager)
{
using (var db = new KElmahDbContext_AuditManager())
{
DeleteError(db, errType, errMessage);
}
}
else if (kElmahDBType == KElmahDBType.KAudit)
{
using (var db = new KElmahDbContext())
{
DeleteError(db, errType, errMessage);
}
}
else if (kElmahDBType == KElmahDBType.All)
{
using (var db = new KElmahDbContext_AuditManager())
{
DeleteError(db, errType, errMessage);
}
using (var db = new KElmahDbContext())
{
DeleteError(db, errType, errMessage);
}
}
}
public static List<Tuple<string, string>> GetErrors(KElmahDBType kElmahDBType)
{
List<Tuple<string, string>> result = new List<Tuple<string, string>>();
if (kElmahDBType == KElmahDBType.AuditManager)
{
using (var db = new KElmahDbContext_AuditManager())
{
result.AddRange(GetErrors(db));
}
}
else if (kElmahDBType == KElmahDBType.KAudit)
{
using (var db = new KElmahDbContext())
{
result.AddRange(GetErrors(db));
}
}
else if (kElmahDBType == KElmahDBType.All)
{
using (var db = new KElmahDbContext_AuditManager())
{
result.AddRange(GetErrors(db));
}
using (var db = new KElmahDbContext())
{
result.AddRange(GetErrors(db));
}
}
return result.Distinct().OrderBy(x => x.Item1).ToList();
}
private int GetErrors(int pageIndex, System.Collections.IList errorEntryList, int pageSize = 15)
{
List<string> kEx = new List<string>();
KConfig.GetKException.Split(',').ToList().ForEach(x => kEx.Add(x.ToEnum<KExceptionType>().Value.ToEnumAttr<KExceptionType, DescriptionAttribute>().Description));
List<string> kExMsg = KConfig.GetKExceptionMsg.Split(',').ToList();
using (var db = new KElmahDbContext())
{
using (var tran = db.Database.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted))
{
int errorCount = db.ELMAH_Error
.Where(x => kEx.Contains(x.Type) && !kExMsg.Any(y => x.Message.Contains(y)))
.Count();
var eLMAH_Error = db.ELMAH_Error
.Where(x => kEx.Contains(x.Type) && !kExMsg.Any(y => x.Message.Contains(y)))
.OrderByDescending(x => x.Sequence)
.Skip(pageIndex * pageSize)
.Take(pageSize)
.ToList();
eLMAH_Error.ForEach(x =>
{
errorEntryList.Add(new ErrorLogEntry(this, x.ErrorId.ToString(), new Error
{
ApplicationName = x.Application,
Detail = x.AllXml,
HostName = x.Host,
Message = x.Message,
Source = x.Source,
StatusCode = x.StatusCode,
Time = x.TimeUtc,
Type = x.Type,
User = x.User,
WebHostHtmlMessage = ""
}));
});
return errorCount;
}
}
}
public static List<string> GetErrorType(KElmahDBType kElmahDBType)
{
List<string> result = new List<string>();
if (kElmahDBType == KElmahDBType.AuditManager)
{
using (var db = new KElmahDbContext_AuditManager())
{
result.AddRange(GetErrorType(db));
}
}
else if (kElmahDBType == KElmahDBType.KAudit)
{
using (var db = new KElmahDbContext())
{
result.AddRange(GetErrorType(db));
}
}
else if (kElmahDBType == KElmahDBType.All)
{
using (var db = new KElmahDbContext_AuditManager())
{
result.AddRange(GetErrorType(db));
}
using (var db = new KElmahDbContext())
{
result.AddRange(GetErrorType(db));
}
}
return result.Distinct().ToList();
}
