public async Task <Guid> AddBackup(DBBackup backup)
{
if (backup.Id == Guid.Empty)
{
backup.Id = Guid.NewGuid();
}
await TblBackups.Insert(backup, false).ExecuteAsync().ConfigureAwait(false);
return(backup.Id);
}
public async Task CancelBackup(Guid backupId)
{
var backup = await TblBackups.Where(b => b.Id == backupId).FirstOrDefault().ExecuteAsync().ConfigureAwait(false);
await TblBackups
.Where(b => b.Server == backup.Server && b.StartDate == backup.StartDate)
.Select(b => new DBBackup {
Status = Status.Cancelled
})
.Update().ExecuteAsync().ConfigureAwait(false);
}
public async Task <IEnumerable <DBBackup> > GetBackups(Guid server)
{
return(await TblBackups.Where(backup => backup.Server == server).Take(20).ExecuteAsync().ConfigureAwait(false));
}
public async Task <IEnumerable <DBBackup> > GetBackups(DateTime from, DateTime to)
{
return(await TblBackups.Where(backup => backup.StartDate >= from && backup.StartDate <= to).Take(20).ExecuteAsync().ConfigureAwait(false));
}
public async Task <IEnumerable <DBBackup> > GetBackups()
{
return(await TblBackups.Take(20).ExecuteAsync().ConfigureAwait(false));
}
public async Task <DBBackup> GetBackup(Guid backupId)
{
return(await TblBackups.Where(backup => backup.Id == backupId).FirstOrDefault().ExecuteAsync().ConfigureAwait(false));
}
