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