public List <SqlServerDataViewModel> Read <SqlServerDataViewModel>(Expression <Func <SqlServerData, bool> > predicate) { var config = new MapperConfiguration(cfg => { cfg.CreateMissingTypeMaps = true; }); var query = _sqlServerDataRep.GetQueryable().Where(predicate); return(query.ProjectTo <SqlServerDataViewModel>(config).ToList()); }
public List <SqlJobsViewModel> Get(int sqlServerDataId, string currentUserId, string jtSorting) { var _config = new MapperConfiguration(cfg => { cfg.CreateMissingTypeMaps = true; }); var mapper = new Mapper(_config); var sqlServer = _sqlServerDataRepository.GetQueryable().Where (x => x.ApplicationUserId == currentUserId && x.SqlServerDataId == sqlServerDataId).SingleOrDefault(); IJobsDataSource source = new JobsDataSource(sqlServer.ConnectionString); return(mapper.DefaultContext.Mapper.Map <List <SqlJobsViewModel> >(source.Get(jtSorting))); }
public List <CpuLoadViewModel> Get(int sqlServerDataId, string currentUserId, int numberOfRecords) { var _config = new MapperConfiguration(cfg => { cfg.CreateMissingTypeMaps = true; cfg.AddGlobalIgnore("EventTimeText"); }); var mapper = new Mapper(_config); var sqlServer = _sqlServerDataRepository.GetQueryable().Where (x => x.ApplicationUserId == currentUserId && x.SqlServerDataId == sqlServerDataId).SingleOrDefault(); ICpuDataSource source = new CpuDataSource(sqlServer.ConnectionString); return(mapper.DefaultContext.Mapper.Map <List <CpuLoadViewModel> >(source.Get(numberOfRecords))); }
public List <SqlDatabasesSizeViewModel> Get(int sqlServerDataId, string currentUserId, List <int> databaseIds, string jtSorting) { var _config = new MapperConfiguration(cfg => { cfg.CreateMissingTypeMaps = true; //exist just in ViewModel cfg.AddGlobalIgnore("SizeMB"); }); var mapper = new Mapper(_config); var sqlServer = _sqlServerDataRepository.GetQueryable().Where (x => x.ApplicationUserId == currentUserId && x.SqlServerDataId == sqlServerDataId).SingleOrDefault(); IDatabaseSizeDataSource source = new DatabaseSizeDataSource(sqlServer.ConnectionString); return(mapper.DefaultContext.Mapper.Map <List <SqlDatabasesSizeViewModel> >(source.Get(databaseIds, jtSorting))); }