//Get List of All Categories public async Task <List <DatabaseHealthCheck> > GetListDatabaseHealthChecks() { try { using SystemHealthChecksDbContext shc = new SystemHealthChecksDbContext(); { return(await shc.DatabaseHealthCheck.AsNoTracking().ToListAsync()); } } catch (Exception ex) { throw; } }
//Get Category Item public async Task <DatabaseHealthCheck> GetDatabaseHealthCheck(int id) { try { using (SystemHealthChecksDbContext shc = new SystemHealthChecksDbContext()) { return(await shc.DatabaseHealthCheck.AsNoTracking().FirstOrDefaultAsync(x => x.Id == id)); } } catch (Exception ex) { throw; } }
//Get UrlApi Item public async Task <Infrastructure.Entities.UrlApiHealthCheck> GetUrlApiHealthCheck(int id) { try { using (SystemHealthChecksDbContext shc = new SystemHealthChecksDbContext()) { return(await shc.UrlApiHealthCheck.AsNoTracking().FirstOrDefaultAsync(x => x.Id == id)); } } catch (Exception ex) { throw; } }
//To Update Category Item public async Task <UrlApiHealthCheck> UpdateUrlApiHealthCheck(UrlApiHealthCheck urlApibHealthCheck) { try { using (SystemHealthChecksDbContext shc = new SystemHealthChecksDbContext()) { shc.Update(urlApibHealthCheck); return(await Task.FromResult((shc.SaveChanges() > 0 ? urlApibHealthCheck : new UrlApiHealthCheck()))); } } catch (Exception ex) { return(null); } }
//To Add New Category public async Task <bool> NewUrlApiHealthCheck(UrlApiHealthCheck urlApibHealthCheck) { try { using (SystemHealthChecksDbContext shc = new SystemHealthChecksDbContext()) { shc.UrlApiHealthCheck.Add(urlApibHealthCheck); return(await Task.FromResult((shc.SaveChanges() > 0 ? true : false))); } } catch (Exception ex) { return(false); } }
//To Update Category Item public async Task <DatabaseHealthCheck> UpdateHealthCheckCategory(DatabaseHealthCheck dbHealthCheck) { try { using (SystemHealthChecksDbContext shc = new SystemHealthChecksDbContext()) { shc.Update(dbHealthCheck); return(await Task.FromResult((shc.SaveChanges() > 0 ? dbHealthCheck : new DatabaseHealthCheck()))); } } catch (Exception ex) { return(null); } }
//To Add New Category public async Task <bool> DBHealthCheck(DatabaseHealthCheck dbHealthCheck) { try { using (SystemHealthChecksDbContext shc = new SystemHealthChecksDbContext()) { shc.DatabaseHealthCheck.Add(dbHealthCheck); return(await Task.FromResult((shc.SaveChanges() > 0 ? true : false))); } } catch (Exception ex) { return(false); } }
//To Delete Category Item public async Task <bool> DeleteDatabaseHealthCheck(int id) { try { using (SystemHealthChecksDbContext shc = new SystemHealthChecksDbContext()) { DatabaseHealthCheck dbHealthCheck = shc.DatabaseHealthCheck.Find(id); shc.DatabaseHealthCheck.Remove(dbHealthCheck); return(await Task.FromResult((shc.SaveChanges() > 0 ? true : false))); } } catch (Exception ex) { return(false); } }
//To Delete Category Item public async Task <bool> DeleteUrlApiHealthCheck(int id) { try { using (SystemHealthChecksDbContext shc = new SystemHealthChecksDbContext()) { _logger.Information($"we called {nameof(DeleteUrlApiHealthCheck)} with {nameof(id)}: {id}"); UrlApiHealthCheck urlApibHealthCheck = shc.UrlApiHealthCheck.Find(id); shc.UrlApiHealthCheck.Remove(urlApibHealthCheck); return(await Task.FromResult((shc.SaveChanges() > 0 ? true : false))); } } catch (Exception ex) { _logger.Error(nameof(DeleteUrlApiHealthCheck), ex.ToString()); return(false); } }