public static async Task <ServiceEnvironmentStatus> GetServiceEnvironmentStatusAsync(this ServiceMonitorDbContext dbContext, ServiceEnvironmentStatus entity) => await dbContext.ServiceEnvironmentStatus.FirstOrDefaultAsync(item => item.ServiceEnvironmentStatusID == entity.ServiceEnvironmentStatusID);
public static async Task <User> GetUserAsync(this ServiceMonitorDbContext dbContext, string userName) => await dbContext.User.FirstOrDefaultAsync(item => item.UserName == userName);
public static IQueryable <ServiceUser> GetServiceUserByUserID(this ServiceMonitorDbContext dbContext, int?userID) => dbContext.ServiceUser.Where(item => item.UserID == userID);
public static IQueryable <ServiceWatcherItemDto> GetActiveServiceWatcherItems(this ServiceMonitorDbContext dbContext)
{
return(from serviceEnvironment in dbContext.ServiceEnvironment
join service in dbContext.Service on serviceEnvironment.ServiceID equals service.ServiceID
join serviceWatcher in dbContext.ServiceWatcher on serviceEnvironment.ServiceID equals serviceWatcher.ServiceID
join environmentCategory in dbContext.EnvironmentCategory on serviceEnvironment.EnvironmentCategoryID equals environmentCategory.EnvironmentCategoryID
select new ServiceWatcherItemDto
{
ServiceEnvironmentID = serviceEnvironment.ServiceEnvironmentID,
ServiceID = service.ServiceID,
Environment = environmentCategory.EnvironmentCategoryName,
ServiceName = service.Name,
Interval = serviceEnvironment.Interval,
Url = serviceEnvironment.Url,
Address = serviceEnvironment.Address,
ConnectionString = serviceEnvironment.ConnectionString,
TypeName = serviceWatcher.TypeName
});
}
