public override LogDto GetById(Guid Id)
{
using (UnitOfMongo op = new UnitOfMongo())
{
NoSQLLogEntity entity = op.Query <NoSQLLogEntity>().Where(x => x.Id.Equals(Id)).FirstOrDefault();
return(ConvertEntityToDto(entity));
}
}
public override List <LogDto> GetAll()
{
using (UnitOfMongo op = new UnitOfMongo())
{
List <NoSQLLogEntity> entity = op.Query <NoSQLLogEntity>().ToList();
return(ConvertEntityListToDtoList(entity));
}
}
public override AppDto GetById(Guid Id)
{
using (UnitOfMongo op = new UnitOfMongo())
{
return(op.Query <NoSQLLogEntity>().Where(x => x.AppId.Equals(Id)).Select(x => new AppDto {
Id = x.AppId, Name = x.AppName
}).FirstOrDefault());
}
}
public override List <AppDto> GetAll()
{
using (UnitOfMongo op = new UnitOfMongo())
{
return(op.Query <NoSQLLogEntity>().Select(x => new AppDto {
Id = x.AppId, Name = x.AppName
}).Distinct().ToList());
}
}
public List <LogDto> GetLogsByAppId(Guid AppId)
{
List <LogDto> result = new List <LogDto>();
using (UnitOfMongo op = new UnitOfMongo())
{
result = ConvertEntityListToDtoList(op.Query <NoSQLLogEntity>().Where(x => x.AppId.Equals(AppId)).Take(10000).OrderBy(x => x.LogDate).ToList());
}
return(result);
}
public override void Delete(LogDto dto)
{
using (UnitOfMongo op = new UnitOfMongo())
{
NoSQLLogEntity entity = op.Query <NoSQLLogEntity>().Where(x => x.Id.Equals(dto.Id)).FirstOrDefault();
if (entity != null)
{
op.Delete(entity);
}
}
}
public List <LogReportDto> GetLogsReport()
{
List <LogReportDto> result = new List <LogReportDto>();
using (UnitOfMongo op = new UnitOfMongo())
{
List <AppDto> apps = (new NoSQLAppRepository()).GetAll();
result = op.Query <NoSQLLogEntity>().GroupBy(x => new { x.AppId, x.AppName, x.Level }).Select(y => new LogReportDto {
Id = y.Key.AppId, AppName = y.Key.AppName, Level = y.Key.Level, Count = y.Count()
}).ToList();
}
return(result);
}
public override void Delete(AppDto dto)
{
using (UnitOfMongo op = new UnitOfMongo())
{
List <NoSQLLogEntity> entity = op.Query <NoSQLLogEntity>().Where(x => x.AppId.Equals(dto.Id)).ToList();
if (entity != null && entity.Count > 0)
{
foreach (NoSQLLogEntity log in entity)
{
op.Delete(log);
}
}
}
}
public override void Save(AppDto dto)
{
using (UnitOfMongo op = new UnitOfMongo())
{
List <NoSQLLogEntity> logs = op.Query <NoSQLLogEntity>().Where(x => x.AppId.Equals(dto.Id)).ToList();
if (logs != null && logs.Count > 0)
{
foreach (NoSQLLogEntity entity in logs)
{
entity.AppName = dto.Name;
op.SaveOrUpdate(entity);
}
}
}
}
public override void Save(LogDto dto)
{
using (UnitOfMongo op = new UnitOfMongo())
{
NoSQLLogEntity entity = op.Query <NoSQLLogEntity>().Where(x => x.Id.Equals(dto.Id)).FirstOrDefault();
if (entity == null)
{
entity = new NoSQLLogEntity();
}
entity.AppId = dto.App.Id;
entity.AppName = dto.App.Name;
entity.Level = dto.Level;
entity.LogDate = dto.LogDate;
entity.Message = dto.Message;
op.SaveOrUpdate(entity);
}
}
private int CountLogs(Guid?SelectedApp, string TextToSearch)
{
using (UnitOfMongo op = new UnitOfMongo())
{
op.BeginTransaction();
IEnumerable <NoSQLLogEntity> query = op.Query <NoSQLLogEntity>();
if (!string.IsNullOrEmpty(TextToSearch))
{
query = query.Where(x => x.Message.Contains(TextToSearch));
}
if (SelectedApp != null)
{
query = query.Where(x => x.AppId.Equals(SelectedApp));
}
return(query.Count());
}
}
public IPagedList <LogDto> Search(Guid?SelectedApp, string TextToSearch, int PageNum, int SizePage)
{
using (UnitOfMongo op = new UnitOfMongo())
{
IQueryable <NoSQLLogEntity> query = op.Query <NoSQLLogEntity>();
if (!string.IsNullOrEmpty(TextToSearch))
{
query = query.Where(x => x.Message.ToLower().Contains(TextToSearch.ToLower()));
}
if (SelectedApp != null)
{
query = query.Where(x => x.AppId.Equals(SelectedApp));
}
query = query.Skip((PageNum - 1) * SizePage);
query = query.Take(SizePage);
List <NoSQLLogEntity> entity = query.ToList();
List <LogDto> dto = ConvertEntityListToDtoList(entity);
return(new StaticPagedList <LogDto>(dto.AsEnumerable <LogDto>(), PageNum, SizePage, CountLogs(SelectedApp, TextToSearch)));
}
}