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);
}
