public async Task <IEnumerable <AuditLogDto> > FetchAuditLogsAsync()
{
this.AuditLogCollection.Clear();
var Count = await JSRuntime.InvokeAsync <string>("FetchLogCount");
LogCount = int.Parse(Count);
for (int i = 0; i < LogCount; i++)
{
var log = await JSRuntime.InvokeAsync <object>("FetchLogs", i.ToString());
var auditlog = JsonSerializer.Deserialize <Dictionary <string, object> >(log.ToString());
var datetimestamp = auditlog["datetimestamp"];
var user = auditlog["user"];
var change = auditlog["change"];
var oldvalue = auditlog["oldvalue"];
var newvalue = auditlog["newvalue"];
var auditLogDto = new AuditLogDto()
{
DateTimeStamp = datetimestamp.ToString(),
User = user.ToString(),
Change = change.ToString(),
OldValue = oldvalue.ToString(),
NewValue = newvalue.ToString()
};
AuditLogCollection.Add(auditLogDto);
}
return(AuditLogCollection);
}
public async Task DeletePippetteAsync(Guid pippetteId)
{
if (pippetteId == null)
{
throw new ArgumentNullException("pippetteId");
}
var pippette = await DBContext.Pippettes
.Include(p => p.Manufacture)
.Include(p => p.Location)
.Include(p => p.PippetteUser)
.Where(p => p.Pippette_Id == pippetteId).FirstOrDefaultAsync();
var oldValue = pippette.ToString();
DBContext.Pippettes.Remove(pippette);
await DBContext.SaveChangesAsync();
var auditLogDto = new AuditLogDto()
{
DateTimeStamp = DateTime.UtcNow.Date.ToString("ddMMyyyyhhmmss"),
User = "",
Change = "Deleted a pippette",
OldValue = oldValue,
NewValue = string.Empty
};
await AuditDataService.AddLog(auditLogDto);
}
public async Task UpdatePippetteAsync(Guid pippetteId, PippetteDataDto pippetteDataDto)
{
if (pippetteId == null)
{
throw new ArgumentNullException("pippetteId");
}
if (pippetteDataDto == null)
{
throw new ArgumentNullException("pippetteDataDto");
}
var manufacture = await DBContext.Manufactures.Where(m => m.Manufacture_Name == pippetteDataDto.Manufacture_Name).FirstOrDefaultAsync();
var location = await DBContext.Locations.Where(l => l.Location_Name == pippetteDataDto.Location_Name).FirstOrDefaultAsync();
var user = await DBContext.PippetteUsers.Where(u => u.Pippette_User_Name == pippetteDataDto.Pippette_User_Name).FirstOrDefaultAsync();
var pippette = await DBContext.Pippettes
.Include(p => p.Manufacture)
.Include(p => p.Location)
.Include(p => p.PippetteUser)
.Where(p => p.Pippette_Id == pippetteId).FirstOrDefaultAsync();
var oldValue = pippette.ToString();
pippette.Manufacture_Id = manufacture.Manufacture_Id;
pippette.Location_Id = location.Location_Id;
pippette.Pippette_User_Id = user.Pippette_User_Id;
pippette.ModelName = pippetteDataDto.ModelName;
pippette.SerialNumber = pippetteDataDto.SerialNumber;
pippette.UsageFrequency = pippetteDataDto.UsageFrequency;
DBContext.Pippettes.Attach(pippette);
await DBContext.SaveChangesAsync();
var auditLogDto = new AuditLogDto()
{
DateTimeStamp = DateTime.UtcNow.Date.ToString("ddMMyyyyhhmmss"),
User = pippetteDataDto.Pippette_User_Name,
Change = "Updated a pippette",
OldValue = oldValue,
NewValue = pippetteDataDto.ToString()
};
await AuditDataService.AddLog(auditLogDto);
}
public async Task AddPippetteAsync(PippetteDataDto pippetteDataDto)
{
if (pippetteDataDto == null)
{
throw new ArgumentNullException("pippetteDataDto");
}
var manufacture = await DBContext.Manufactures.Where(m => m.Manufacture_Name == pippetteDataDto.Manufacture_Name).FirstOrDefaultAsync();
var location = await DBContext.Locations.Where(l => l.Location_Name == pippetteDataDto.Location_Name).FirstOrDefaultAsync();
var user = await DBContext.PippetteUsers.Where(u => u.Pippette_User_Name == pippetteDataDto.Pippette_User_Name).FirstOrDefaultAsync();
var pippette = new Pippette()
{
Pippette_Id = Guid.NewGuid(),
Manufacture_Id = manufacture.Manufacture_Id,
Location_Id = location.Location_Id,
Pippette_User_Id = user.Pippette_User_Id,
ModelName = pippetteDataDto.ModelName,
SerialNumber = pippetteDataDto.SerialNumber,
UsageFrequency = pippetteDataDto.UsageFrequency
};
await DBContext.Pippettes.AddAsync(pippette);
await DBContext.SaveChangesAsync();
var auditLogDto = new AuditLogDto()
{
DateTimeStamp = DateTime.UtcNow.Date.ToString("ddMMyyyyhhmmss"),
User = pippetteDataDto.Pippette_User_Name,
Change = "Inserted a pippette",
OldValue = string.Empty,
NewValue = pippetteDataDto.ToString()
};
await AuditDataService.AddLog(auditLogDto);
}
public async Task AddLog(AuditLogDto auditLogDto)
{
await JSRuntime.InvokeVoidAsync("AddLog", auditLogDto.DateTimeStamp, auditLogDto.User, auditLogDto.Change, auditLogDto.OldValue, auditLogDto.NewValue);
}