public ResultSet <JobsViewModel> Get() { var jobsDataSource = new JobsDataSource(); var jobDailyAnalitics = jobsDataSource.Query <JobsViewModel>(); return(jobDailyAnalitics); }
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))); }